https://funradio.dev.eemce.eu/app_dev.php/esi/anonymous/header/menu/

Query Metrics

154 Database Queries
16 Different statements
256.49 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
93.22 ms
(36.34%)
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 04:45:34"
  "2025-07-11 04:45:34"
]
75.90 ms
(29.59%)
58
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%"
]
31.03 ms
(12.10%)
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
]
18.69 ms
(7.29%)
1
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 12
Parameters:
[
  6
  "2025-07-11 04:45:33"
  "2025-07-11 04:45:33"
]
10.11 ms
(3.94%)
19
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 04:45:00"
  "2025-07-11 04:45:00"
  1
  0
]
8.13 ms
(3.17%)
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
]
3.15 ms
(1.23%)
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:
[
  [
    2096
  ]
]
2.93 ms
(1.14%)
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.82 ms
(1.10%)
4
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:
[
  6
]
2.05 ms
(0.80%)
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.92 ms
(0.75%)
1
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2 FROM broadcast_has_category b1_ LEFT JOIN categories c0_ ON (b1_.category_id = c0_.id) WHERE b1_.broadcast_id = ?
Parameters:
[
  6
]
1.75 ms
(0.68%)
1
SELECT o0_.id AS id_0, o0_.key AS key_1, o0_.value AS value_2 FROM options o0_
Parameters:
[]
1.71 ms
(0.67%)
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.54 ms
(0.60%)
1
SELECT b0_.id AS id_0, b0_.slug AS slug_1, b0_.title AS title_2, b0_.description AS description_3, b0_.author_bio AS author_bio_4, b0_.upload_path AS upload_path_5, b0_.gemius_code AS gemius_code_6 FROM broadcast b0_ WHERE b0_.id = ?
Parameters:
[
  6
]
1.04 ms
(0.41%)
1
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:
[]
0.51 ms
(0.20%)
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_ WHERE c0_.id = ?
Parameters:
[
  650
]

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\Broadcast No errors.
AppBundle\Entity\BroadcastHasCategory No errors.
AppBundle\Entity\AirNow 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\BroadcastHasArticle No errors.
Bait\PollBundle\Entity\Poll No errors.
AppBundle\Entity\Menu No errors.
AppBundle\Entity\MenuItem No errors.
AppBundle\Entity\SepiaStream No errors.
AppBundle\Entity\AirNowModerator No errors.
AppBundle\Entity\Board 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.
Bait\PollBundle\Entity\Answer No errors.
Bait\PollBundle\Entity\UserAnswer No errors.