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

Query Metrics

46 Database Queries
7 Different statements
29.29 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
13.76 ms
(46.97%)
24
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 16:30:00"
  "2025-07-11 16:30:00"
  3
  0
]
5.34 ms
(18.25%)
5
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%"
]
3.84 ms
(13.12%)
5
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:
[
  10
]
2.58 ms
(8.82%)
5
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:
[
  201
]
2.16 ms
(7.36%)
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
]
0.90 ms
(3.07%)
1
SELECT o0_.id AS id_0, o0_.key AS key_1, o0_.value AS value_2 FROM options o0_
Parameters:
[]
0.71 ms
(2.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:
[]

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\Menu No errors.
AppBundle\Entity\MenuItem No errors.
AppBundle\Entity\Article No errors.
AppBundle\Entity\Broadcast No errors.
AppBundle\Entity\Content No errors.
AppBundle\Entity\Board No errors.
AppBundle\Entity\AirNow No errors.
FOS\UserBundle\Model\User No errors.
AppBundle\Entity\User No errors.
AppBundle\Entity\Option No errors.