Query Metrics
121
Database Queries
9
Different statements
83.17 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
48.37 ms (58.15%) |
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%" ] |
17.34 ms (20.84%) |
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
]
|
6.67 ms (8.02%) |
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, a0_.thumbnail AS thumbnail_6, c1_.title AS title_7 FROM category_has_article c2_ LEFT JOIN articles a0_ ON (c2_.article_id = a0_.id) LEFT JOIN categories c1_ ON (c2_.category_id = c1_.id) WHERE c2_.category_id = ? AND a0_.status = true AND a0_.date_start <= ? AND (a0_.date_end >= ? OR a0_.date_end IS NULL) ORDER BY a0_.sticky DESC, a0_.date_start DESC LIMIT 12
Parameters:
[ 59 "2025-07-16 23:16:58" "2025-07-16 23:16:58" ] |
4.85 ms (5.83%) |
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
]
|
1.46 ms (1.76%) |
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_.slug = ?
Parameters:
[
"podcast"
]
|
1.44 ms (1.73%) |
1 |
SELECT o0_.id AS id_0, o0_.key AS key_1, o0_.value AS value_2 FROM options o0_
Parameters:
[] |
1.43 ms (1.72%) |
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.06 ms (1.27%) |
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:
[] |
0.56 ms (0.67%) |
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\Option | 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\SepiaStream | No errors. |