Query Metrics
124
Database Queries
12
Different statements
146.51 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
75.90 ms (51.81%) |
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 (21.18%) |
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 (12.76%) |
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" ] |
8.13 ms (5.55%) |
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
]
|
2.93 ms (2.00%) |
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
]
|
1.92 ms (1.31%) |
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 (1.20%) |
1 |
SELECT o0_.id AS id_0, o0_.key AS key_1, o0_.value AS value_2 FROM options o0_
Parameters:
[] |
1.71 ms (1.16%) |
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 (1.05%) |
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.05 ms (0.72%) |
1 |
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
]
|
1.04 ms (0.71%) |
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.82 ms (0.56%) |
1 |
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
]
]
|
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. |