Query Metrics
132
Database Queries
8
Different statements
93.36 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
60.61 ms (64.93%) |
69 |
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.26 ms (18.49%) |
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:
[
871
]
|
5.16 ms (5.52%) |
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.70 ms (2.89%) |
1 |
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 ORDER BY e0_.air_date DESC LIMIT 6
Parameters:
[] |
2.50 ms (2.68%) |
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.05 ms (2.20%) |
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.55 ms (1.66%) |
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.52 ms (1.63%) |
1 |
SELECT o0_.id AS id_0, o0_.key AS key_1, o0_.value AS value_2 FROM options o0_
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. |