Query Metrics
206
Database Queries
24
Different statements
519.75 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
174.66 ms (33.60%) |
1 |
SELECT DISTINCT a0_.id AS id_0, a0_.slug AS slug_1, a0_.upload_path AS upload_path_2, a0_.title AS title_3, a0_.excerpt AS excerpt_4, a0_.date_start AS date_start_5, a0_.thumbnail AS thumbnail_6, a0_.thumbnail_title AS thumbnail_title_7, a0_.thumbnail_description AS thumbnail_description_8, MIN(c1_.id) AS sclr_9 FROM articles a0_ LEFT JOIN category_has_article c2_ ON (c2_.article_id = a0_.id) LEFT JOIN categories c1_ ON (c2_.category_id = c1_.id) WHERE a0_.status = true AND a0_.id <> ? AND a0_.date_start <= ? AND (a0_.date_end >= ? OR a0_.date_end IS NULL) GROUP BY a0_.id, a0_.slug, a0_.upload_path, a0_.title, a0_.excerpt, a0_.date_start, a0_.thumbnail, a0_.thumbnail_title, a0_.thumbnail_description ORDER BY a0_.date_start DESC LIMIT 6
Parameters:
[ 44104 "2025-07-11 19:31:38" "2025-07-11 19:31:38" ] |
90.90 ms (17.49%) |
63 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.url AS url_2 FROM eemce_podcast_items e0_ WHERE e0_.podcast_id = ? AND (e0_.name LIKE ? OR e0_.name LIKE ? OR e0_.name LIKE ?)
Parameters:
[ 2 "%Apple%" "%Spotify%" "%Google%" ] |
88.14 ms (16.96%) |
3 |
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.upload_path AS upload_path_2, a0_.title AS title_3, a0_.excerpt AS excerpt_4, a0_.date_start AS date_start_5, b1_.title AS title_6, MIN(c2_.id) AS sclr_7, a0_.thumbnail AS thumbnail_8 FROM broadcast_has_article b3_ LEFT JOIN articles a0_ ON (b3_.article_id = a0_.id) LEFT JOIN broadcast b1_ ON (b3_.broadcast_id = b1_.id) LEFT JOIN category_has_article c4_ ON (c4_.article_id = a0_.id) LEFT JOIN categories c2_ ON (c4_.category_id = c2_.id) WHERE b3_.broadcast_id = ? AND a0_.status = true AND a0_.date_start <= ? AND (a0_.date_end >= ? OR a0_.date_end IS NULL) GROUP BY a0_.id, a0_.slug, a0_.upload_path, a0_.title, a0_.excerpt, a0_.date_start, b1_.title ORDER BY a0_.sticky DESC, a0_.date_start DESC LIMIT 5
Parameters:
[ 2 "2025-07-11 19:31:38" "2025-07-11 19:31:38" ] |
41.73 ms (8.03%) |
43 |
SELECT m0_.id AS id_0, m0_.parent AS parent_1, m0_.menu AS menu_2, m0_.item AS item_3, m0_.title AS title_4, m0_.url AS url_5, m0_.type AS type_6, m0_.target AS target_7, m0_.rel AS rel_8, m0_.class_selector AS class_selector_9, m0_.date_start AS date_start_10, m0_.date_end AS date_end_11, m0_.status AS status_12, m0_.sort AS sort_13 FROM menu_items m0_ WHERE m0_.status = true AND m0_.date_start <= ? AND (m0_.date_end >= ? OR m0_.date_end IS NULL) AND m0_.menu = ? AND m0_.parent = ? ORDER BY m0_.sort ASC
Parameters:
[ "2025-07-11 19:30:00" "2025-07-11 19:30:00" 1 0 ] |
31.61 ms (6.08%) |
48 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.subtitle AS subtitle_4, t0.audio_file AS audio_file_5, t0.guid AS guid_6, t0.air_date AS air_date_7, t0.url AS url_8, t0.upload_path AS upload_path_9, t0.sort AS sort_10, t0.badge AS badge_11, t0.uses_webp AS uses_webp_12, t0.duration AS duration_13, t0.podcast_id AS podcast_id_14 FROM eemce_podcast_items t0 WHERE t0.id = ?
Parameters:
[
869
]
|
10.95 ms (2.11%) |
6 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.author_mail AS author_mail_4, t0.author_id AS author_id_5, t0.author AS author_6, t0.alt_author AS alt_author_7, t0.alt_author_mail AS alt_author_mail_8, t0.excerpt AS excerpt_9, t0.tags AS tags_10, t0.date_start AS date_start_11, t0.date_end AS date_end_12, t0.upload_path AS upload_path_13, t0.thumbnail AS thumbnail_14, t0.thumbnail_title AS thumbnail_title_15, t0.thumbnail_description AS thumbnail_description_16, t0.thumbnail_source AS thumbnail_source_17, t0.thumbnail_source_url AS thumbnail_source_url_18, t0.youtube_video AS youtube_video_19, t0.hide_author AS hide_author_20, t0.hide_date AS hide_date_21, t0.hide_share AS hide_share_22, t0.show_on_front_page AS show_on_front_page_23, t0.show_on_board AS show_on_board_24, t0.show_on_headline AS show_on_headline_25, t0.show_in_list AS show_in_list_26, t0.tasr AS tasr_27, t0.sticky AS sticky_28, t0.sticky_time_out AS sticky_time_out_29, t0.vip_only AS vip_only_30, t0.redirect_uri AS redirect_uri_31, t0.page_full_width AS page_full_width_32, t0.music_promo AS music_promo_33, t0.comments AS comments_34, t0.share AS share_35, t0.competition AS competition_36, t0.show_thumbnail AS show_thumbnail_37, t0.sticker AS sticker_38, t0.sponsorship AS sponsorship_39, t0.creation_date AS creation_date_40, t0.status AS status_41, t0.seo_title AS seo_title_42, t0.seo_description AS seo_description_43, t0.seo_date AS seo_date_44, t0.seo_location AS seo_location_45, t0.views_4h AS views_4h_46, t0.views_24h AS views_24h_47, t0.views_168h AS views_168h_48, t0.views_total AS views_total_49, t0.cron AS cron_50, t0.match AS match_51, t0.social_thumbnail AS social_thumbnail_52, t0.subdomain_id AS subdomain_id_53, t0.show_on_headline_subdomain AS show_on_headline_subdomain_54, t0.sticky_subdomain AS sticky_subdomain_55, t0.sticky_time_out_subdomain AS sticky_time_out_subdomain_56 FROM articles t0 WHERE t0.id = ?
Parameters:
[
"44104"
]
|
9.63 ms (1.85%) |
1 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.date_start AS date_start_3, c0_.date_end AS date_end_4, c0_.status AS status_5, c0_.pinned AS pinned_6, c0_.excerpt AS excerpt_7, c0_.upload_path AS upload_path_8, c0_.thumbnail AS thumbnail_9, c0_.thumbnail_title AS thumbnail_title_10, c0_.thumbnail_description AS thumbnail_description_11, c0_.seo_title AS seo_title_12, c0_.seo_description AS seo_description_13, c0_.creation_date AS creation_date_14, c0_.gemius_code AS gemius_code_15, c0_.custom_js AS custom_js_16, c0_.uses_webp AS uses_webp_17 FROM categories c0_ LEFT JOIN category_has_article c1_ ON (c1_.category_id = c0_.id) WHERE c1_.article_id = ? AND c0_.status = true AND (c0_.date_end >= ? OR c0_.date_end IS NULL) AND c0_.date_start <= ?
Parameters:
[ 44104 "2025-07-11 19:31:38" "2025-07-11 19:31:38" ] |
9.51 ms (1.83%) |
6 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.answer AS answer_3, t0.required AS required_4, t0.photo AS photo_5, t0.photo_source AS photo_source_6, t0.photo_source_link AS photo_source_link_7, t0.embed AS embed_8, t0.description AS description_9, t0.answer_value AS answer_value_10, t0.trackingCode AS trackingcode_11, t0.sort AS sort_12, t0.answer_color AS answer_color_13, t0.placeholder AS placeholder_14, t0.bonus_points AS bonus_points_15, t0.question_id AS question_id_16 FROM poll_answers t0 WHERE t0.question_id = ? ORDER BY t0.sort ASC, t0.id ASC
Parameters:
[
699
]
|
9.38 ms (1.80%) |
1 |
SELECT g0_.id AS id_0, g0_.gallery_id AS sclr_1, g1_.upload_path AS upload_path_2, g0_.title AS title_3, g0_.description AS description_4, g0_.source AS source_5, g0_.source_url AS source_url_6, g0_.upload_path AS upload_path_7 FROM gallery_photos g0_ INNER JOIN galleries g1_ ON g0_.gallery_id = g1_.id WHERE g0_.gallery_id = ? ORDER BY g0_.sort ASC, g0_.id ASC
Parameters:
[
"865"
]
|
7.94 ms (1.53%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.photo AS photo_3, t0.photo_source AS photo_source_4, t0.photo_source_link AS photo_source_link_5, t0.embed AS embed_6, t0.description AS description_7, t0.save_to_user AS save_to_user_8, t0.random_answer_order AS random_answer_order_9, t0.sort AS sort_10, t0.show_ongoing_result AS show_ongoing_result_11, t0.poll_id AS poll_id_12 FROM poll_questions t0 WHERE t0.poll_id = ? ORDER BY t0.sort ASC, t0.id ASC
Parameters:
[
162
]
|
7.58 ms (1.46%) |
5 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.air_date AS air_date_3, e0_.badge AS badge_4, e0_.audio_file AS audio_file_5, e0_.duration AS duration_6, e1_.id AS id_7, e1_.name AS name_8, e1_.upload_path AS upload_path_9, e1_.custom_show_image AS custom_show_image_10, e1_.show_image_url AS show_image_url_11 FROM eemce_podcast_items e0_ INNER JOIN eemce_podcasts e1_ ON e0_.podcast_id = e1_.id WHERE e0_.air_date IS NOT NULL AND e1_.id = ? ORDER BY e0_.air_date DESC LIMIT 10
Parameters:
[
2
]
|
6.28 ms (1.21%) |
1 |
SELECT c0_.id AS id_0, c0_.category_id AS category_id_1, c0_.article_id AS article_id_2 FROM category_has_article c0_ WHERE c0_.article_id = ? LIMIT 1
Parameters:
[
"44104"
]
|
5.31 ms (1.02%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.status AS status_6, t0.pinned AS pinned_7, t0.excerpt AS excerpt_8, t0.upload_path AS upload_path_9, t0.thumbnail AS thumbnail_10, t0.thumbnail_title AS thumbnail_title_11, t0.thumbnail_description AS thumbnail_description_12, t0.seo_title AS seo_title_13, t0.seo_description AS seo_description_14, t0.creation_date AS creation_date_15, t0.gemius_code AS gemius_code_16, t0.custom_js AS custom_js_17, t0.uses_webp AS uses_webp_18 FROM categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
650
]
|
4.77 ms (0.92%) |
6 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.date_start AS date_start_3, c0_.date_end AS date_end_4, c0_.status AS status_5, c0_.pinned AS pinned_6, c0_.excerpt AS excerpt_7, c0_.upload_path AS upload_path_8, c0_.thumbnail AS thumbnail_9, c0_.thumbnail_title AS thumbnail_title_10, c0_.thumbnail_description AS thumbnail_description_11, c0_.seo_title AS seo_title_12, c0_.seo_description AS seo_description_13, c0_.creation_date AS creation_date_14, c0_.gemius_code AS gemius_code_15, c0_.custom_js AS custom_js_16, c0_.uses_webp AS uses_webp_17 FROM categories c0_ WHERE c0_.id = ?
Parameters:
[
650
]
|
3.98 ms (0.77%) |
4 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2 FROM categories c0_ WHERE c0_.id IN (?)
Parameters:
[ [ 0 => 650 4 => 2096 5 => 2121 ] ] |
2.97 ms (0.57%) |
5 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.feed_url AS feed_url_3, t0.show_image_url AS show_image_url_4, t0.custom_show_image AS custom_show_image_5, t0.instagram_app_id AS instagram_app_id_6, t0.instagram_app_secret AS instagram_app_secret_7, t0.instagram_access_token AS instagram_access_token_8, t0.meta_seo_title AS meta_seo_title_9, t0.meta_seo_description AS meta_seo_description_10, t0.description AS description_11, t0.color_theme AS color_theme_12, t0.upload_path AS upload_path_13, t0.moderators AS moderators_14, t0.sort AS sort_15, t0.uses_webp AS uses_webp_16 FROM eemce_podcasts t0 WHERE t0.id = ?
Parameters:
[
2
]
|
2.38 ms (0.46%) |
3 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image AS image_4, t0.color AS color_5, t0.description AS description_6, t0.author AS author_7, t0.author_avatar AS author_avatar_8, t0.author_bio AS author_bio_9, t0.video AS video_10, t0.video_poster AS video_poster_11, t0.video_description AS video_description_12, t0.upload_path AS upload_path_13, t0.status AS status_14, t0.seo_title AS seo_title_15, t0.seo_description AS seo_description_16, t0.creation_date AS creation_date_17, t0.gemius_code AS gemius_code_18, t0.sort AS sort_19, t0.uses_webp AS uses_webp_20 FROM broadcast t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
2
]
|
2.27 ms (0.44%) |
1 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.image AS image_3, b0_.color AS color_4, b0_.description AS description_5, b0_.author AS author_6, b0_.author_avatar AS author_avatar_7, b0_.author_bio AS author_bio_8, b0_.video AS video_9, b0_.video_poster AS video_poster_10, b0_.video_description AS video_description_11, b0_.upload_path AS upload_path_12, b0_.status AS status_13, b0_.seo_title AS seo_title_14, b0_.seo_description AS seo_description_15, b0_.creation_date AS creation_date_16, b0_.gemius_code AS gemius_code_17, b0_.sort AS sort_18, b0_.uses_webp AS uses_webp_19 FROM broadcast b0_ LEFT JOIN broadcast_has_article b1_ ON (b1_.broadcast_id = b0_.id) WHERE b1_.article_id = ? AND b0_.status = true
Parameters:
[
"44104"
]
|
1.73 ms (0.33%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.location AS location_3 FROM menus t0 WHERE t0.location = ? LIMIT 1
Parameters:
[
"header"
]
|
1.72 ms (0.33%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.source AS source_3, t0.type AS type_4, t0.podcast_episode AS podcast_episode_5, t0.sort AS sort_6, t0.html AS html_7, t0.align AS align_8, t0.width AS width_9, t0.has_take_downs AS has_take_downs_10, t0.article_id AS article_id_11 FROM article_contents t0 WHERE t0.article_id = ? ORDER BY t0.sort ASC
Parameters:
[
44104
]
|
1.68 ms (0.32%) |
2 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.show_image_url AS show_image_url_2, e0_.custom_show_image AS custom_show_image_3, e0_.meta_seo_title AS meta_seo_title_4, e0_.meta_seo_description AS meta_seo_description_5, e0_.description AS description_6, e0_.upload_path AS upload_path_7, e0_.sort AS sort_8 FROM eemce_podcasts e0_ ORDER BY e0_.sort ASC
Parameters:
[] |
1.66 ms (0.32%) |
1 |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.is_default AS is_default_3, s0_.sort AS sort_4, s0_.date_start AS date_start_5, s0_.date_end AS date_end_6, s0_.stream_ad_uri AS stream_ad_uri_7, s0_.stream_64k_mp3_uri AS stream_64k_mp3_uri_8, s0_.stream_128k_mp3_uri AS stream_128k_mp3_uri_9, s0_.stream_192k_mp3_uri AS stream_192k_mp3_uri_10, s0_.gemius_code AS gemius_code_11, s0_.seo_description AS seo_description_12, s0_.seo_keywords AS seo_keywords_13, s0_.logo AS logo_14, s0_.logo_hover AS logo_hover_15, s0_.upload_path AS upload_path_16 FROM sepia_stream s0_ WHERE s0_.date_start <= CURRENT_TIMESTAMP AND (s0_.date_end >= CURRENT_TIMESTAMP OR s0_.date_end IS NULL) ORDER BY s0_.is_default DESC, s0_.sort ASC
Parameters:
[] |
1.53 ms (0.29%) |
1 |
SELECT o0_.id AS id_0, o0_.key AS key_1, o0_.value AS value_2 FROM options o0_
Parameters:
[] |
1.45 ms (0.28%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.date_start AS date_start_3, t0.date_end AS date_end_4, t0.msg_not_started AS msg_not_started_5, t0.msg_ended AS msg_ended_6, t0.msg_sent AS msg_sent_7, t0.msg_open_button AS msg_open_button_8, t0.multi_entry AS multi_entry_9, t0.multi_entry_reset_hour AS multi_entry_reset_hour_10, t0.show_results AS show_results_11, t0.show_stats AS show_stats_12, t0.registered_only AS registered_only_13, t0.show_number_entries AS show_number_entries_14, t0.display_type AS display_type_15, t0.votes_limit AS votes_limit_16, t0.results_summary AS results_summary_17, t0.multi_entry_interval AS multi_entry_interval_18, t0.points AS points_19 FROM poll_polls t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"162"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
AppBundle\Entity\Podcast | No errors. |
AppBundle\Entity\PodcastItem | No errors. |
AppBundle\Entity\Category | No errors. |
AppBundle\Entity\Option | No errors. |
AppBundle\Entity\Article | No errors. |
AppBundle\Entity\Content | No errors. |
AppBundle\Entity\CategoryHasArticle | No errors. |
AppBundle\Entity\Broadcast | No errors. |
AppBundle\Entity\BroadcastHasArticle | No errors. |
Bait\PollBundle\Entity\Poll | No errors. |
AppBundle\Entity\Menu | No errors. |
AppBundle\Entity\MenuItem | No errors. |
AppBundle\Entity\Board | No errors. |
AppBundle\Entity\SepiaStream | No errors. |
AppBundle\Entity\AirNow | No errors. |
Bait\PollBundle\Entity\Question | No errors. |
Bait\PollBundle\Entity\Result | No errors. |
Bait\PollBundle\Entity\UserAnswerGroup | No errors. |
FOS\UserBundle\Model\User | No errors. |
AppBundle\Entity\User | No errors. |
AppBundle\Entity\AirNowModerator | No errors. |
Bait\PollBundle\Entity\Answer | No errors. |
Bait\PollBundle\Entity\UserAnswer | No errors. |
FOS\UserBundle\Model\Group | No errors. |
AppBundle\Entity\Group | No errors. |
AppBundle\Entity\Photo | No errors. |
AppBundle\Entity\Gallery | No errors. |