Query Metrics
36
Database Queries
17
Different statements
11.19 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.87 ms |
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.actif AS actif_2, p0_.image_cover AS image_cover_3, p0_.is_molecule AS is_molecule_4, p0_.date_last_modification AS date_last_modification_5, p0_.tags AS tags_6, p0_.carousel_image AS carousel_image_7, p0_.carousel_only AS carousel_only_8, p0_.treatment_id AS treatment_id_9, p0_.video_id AS video_id_10, p0_.partner_id AS partner_id_11, p0_.category_id AS category_id_12 FROM post p0_ WHERE p0_.id = ? AND p0_.actif = 1
Parameters:
[
"126"
]
|
| 2 | 0.58 ms |
SELECT v0_.id AS id_0, v0_.url AS url_1, v0_.views AS views_2, v0_.actif AS actif_3, v0_.likes AS likes_4, v0_.quality AS quality_5, v0_.main_video AS main_video_6, v0_.image_cover AS image_cover_7, v0_.title AS title_8, v0_.duration AS duration_9, v0_.produced_by_t4_m AS produced_by_t4_m_10, v0_.secondary_video_id AS secondary_video_id_11, v0_.video_quality_id AS video_quality_id_12 FROM video v0_ INNER JOIN post p1_ ON v0_.secondary_video_id = p1_.id WHERE p1_.id = ? AND v0_.actif = 1
Parameters:
[
126
]
|
| 3 | 0.40 ms |
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.display_order AS display_order_3, t0.topic_id AS topic_id_4 FROM theme t0 INNER JOIN post_theme ON t0.id = post_theme.theme_id WHERE post_theme.post_id = ?
Parameters:
[
126
]
|
| 4 | 0.96 ms |
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.actif AS actif_2, p0_.image_cover AS image_cover_3, p0_.is_molecule AS is_molecule_4, p0_.date_last_modification AS date_last_modification_5, p0_.tags AS tags_6, p0_.carousel_image AS carousel_image_7, p0_.carousel_only AS carousel_only_8, p0_.treatment_id AS treatment_id_9, p0_.video_id AS video_id_10, p0_.partner_id AS partner_id_11, p0_.category_id AS category_id_12 FROM post p0_ INNER JOIN post_theme p2_ ON p0_.id = p2_.post_id INNER JOIN theme t1_ ON t1_.id = p2_.theme_id INNER JOIN post_translation p3_ ON p0_.id = p3_.translatable_id INNER JOIN category_post c4_ ON p0_.category_id = c4_.id WHERE c4_.id = ? AND t1_.id IN (?) AND p0_.actif = 1 ORDER BY p3_.title ASC
Parameters:
[ 8 24 ] |
| 5 | 0.26 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.views AS views_3, t0.actif AS actif_4, t0.likes AS likes_5, t0.quality AS quality_6, t0.main_video AS main_video_7, t0.image_cover AS image_cover_8, t0.title AS title_9, t0.duration AS duration_10, t0.produced_by_t4_m AS produced_by_t4_m_11, t0.secondary_video_id AS secondary_video_id_12, t0.video_quality_id AS video_quality_id_13 FROM video t0 WHERE t0.id = ?
Parameters:
[
473
]
|
| 6 | 0.26 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.time_start AS time_start_3, t0.time_end AS time_end_4, t0.image_cover AS image_cover_5, t0.actif AS actif_6, t0.video_id AS video_id_7, t0.theme_id AS theme_id_8 FROM video_sequence t0 WHERE t0.video_id = ? ORDER BY t0.time_start ASC
Parameters:
[
473
]
|
| 7 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.actif AS actif_3, t0.user_id AS user_id_4, t0.sequence_id AS sequence_id_5, t0.post_id AS post_id_6 FROM user_list t0 WHERE t0.post_id = ?
Parameters:
[
127
]
|
| 8 | 0.20 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.views AS views_3, t0.actif AS actif_4, t0.likes AS likes_5, t0.quality AS quality_6, t0.main_video AS main_video_7, t0.image_cover AS image_cover_8, t0.title AS title_9, t0.duration AS duration_10, t0.produced_by_t4_m AS produced_by_t4_m_11, t0.secondary_video_id AS secondary_video_id_12, t0.video_quality_id AS video_quality_id_13 FROM video t0 WHERE t0.id = ?
Parameters:
[
471
]
|
| 9 | 0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.time_start AS time_start_3, t0.time_end AS time_end_4, t0.image_cover AS image_cover_5, t0.actif AS actif_6, t0.video_id AS video_id_7, t0.theme_id AS theme_id_8 FROM video_sequence t0 WHERE t0.video_id = ? ORDER BY t0.time_start ASC
Parameters:
[
471
]
|
| 10 | 0.16 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.actif AS actif_3, t0.user_id AS user_id_4, t0.sequence_id AS sequence_id_5, t0.post_id AS post_id_6 FROM user_list t0 WHERE t0.post_id = ?
Parameters:
[
125
]
|
| 11 | 0.18 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.views AS views_3, t0.actif AS actif_4, t0.likes AS likes_5, t0.quality AS quality_6, t0.main_video AS main_video_7, t0.image_cover AS image_cover_8, t0.title AS title_9, t0.duration AS duration_10, t0.produced_by_t4_m AS produced_by_t4_m_11, t0.secondary_video_id AS secondary_video_id_12, t0.video_quality_id AS video_quality_id_13 FROM video t0 WHERE t0.id = ?
Parameters:
[
474
]
|
| 12 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.time_start AS time_start_3, t0.time_end AS time_end_4, t0.image_cover AS image_cover_5, t0.actif AS actif_6, t0.video_id AS video_id_7, t0.theme_id AS theme_id_8 FROM video_sequence t0 WHERE t0.video_id = ? ORDER BY t0.time_start ASC
Parameters:
[
474
]
|
| 13 | 0.15 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.actif AS actif_3, t0.user_id AS user_id_4, t0.sequence_id AS sequence_id_5, t0.post_id AS post_id_6 FROM user_list t0 WHERE t0.post_id = ?
Parameters:
[
128
]
|
| 14 | 0.16 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.views AS views_3, t0.actif AS actif_4, t0.likes AS likes_5, t0.quality AS quality_6, t0.main_video AS main_video_7, t0.image_cover AS image_cover_8, t0.title AS title_9, t0.duration AS duration_10, t0.produced_by_t4_m AS produced_by_t4_m_11, t0.secondary_video_id AS secondary_video_id_12, t0.video_quality_id AS video_quality_id_13 FROM video t0 WHERE t0.id = ?
Parameters:
[
476
]
|
| 15 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.time_start AS time_start_3, t0.time_end AS time_end_4, t0.image_cover AS image_cover_5, t0.actif AS actif_6, t0.video_id AS video_id_7, t0.theme_id AS theme_id_8 FROM video_sequence t0 WHERE t0.video_id = ? ORDER BY t0.time_start ASC
Parameters:
[
476
]
|
| 16 | 0.15 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.actif AS actif_3, t0.user_id AS user_id_4, t0.sequence_id AS sequence_id_5, t0.post_id AS post_id_6 FROM user_list t0 WHERE t0.post_id = ?
Parameters:
[
129
]
|
| 17 | 0.18 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.views AS views_3, t0.actif AS actif_4, t0.likes AS likes_5, t0.quality AS quality_6, t0.main_video AS main_video_7, t0.image_cover AS image_cover_8, t0.title AS title_9, t0.duration AS duration_10, t0.produced_by_t4_m AS produced_by_t4_m_11, t0.secondary_video_id AS secondary_video_id_12, t0.video_quality_id AS video_quality_id_13 FROM video t0 WHERE t0.id = ?
Parameters:
[
469
]
|
| 18 | 0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.time_start AS time_start_3, t0.time_end AS time_end_4, t0.image_cover AS image_cover_5, t0.actif AS actif_6, t0.video_id AS video_id_7, t0.theme_id AS theme_id_8 FROM video_sequence t0 WHERE t0.video_id = ? ORDER BY t0.time_start ASC
Parameters:
[
469
]
|
| 19 | 0.16 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.actif AS actif_3, t0.user_id AS user_id_4, t0.sequence_id AS sequence_id_5, t0.post_id AS post_id_6 FROM user_list t0 WHERE t0.post_id = ?
Parameters:
[
124
]
|
| 20 | 0.26 ms |
SELECT d0_.id AS id_0, d0_.image_cover AS image_cover_1, d0_.logo AS logo_2, d0_.actif AS actif_3, d0_.date AS date_4, d0_.place AS place_5, d0_.category_id AS category_id_6, d0_.topic_id AS topic_id_7 FROM dossier d0_ INNER JOIN dossier_playlist_item d1_ ON d0_.id = d1_.dossier_id INNER JOIN post p2_ ON d1_.post_id = p2_.id WHERE p2_.id = ?
Parameters:
[
126
]
|
| 21 | 0.24 ms |
SELECT d0_.id AS id_0, d0_.display_order AS display_order_1, ABS(d0_.display_order) AS sclr_2, d0_.dossier_id AS dossier_id_3, d0_.post_id AS post_id_4, d0_.category_id AS category_id_5 FROM dossier_playlist_item d0_ INNER JOIN dossier d1_ ON d0_.dossier_id = d1_.id WHERE d1_.id = ? ORDER BY sclr_2 ASC
Parameters:
[
null
]
|
| 22 | 0.22 ms |
SELECT d0_.id AS id_0, d0_.display_order AS display_order_1, d0_.dossier_id AS dossier_id_2, d0_.post_id AS post_id_3, d0_.category_id AS category_id_4 FROM dossier_playlist_item d0_ INNER JOIN dossier d1_ ON d0_.dossier_id = d1_.id INNER JOIN post p2_ ON d0_.post_id = p2_.id WHERE d1_.id = ? AND p2_.id = ?
Parameters:
[ null 126 ] |
| 23 | 0.61 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
126
]
|
| 24 | 0.50 ms |
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.image_cover AS image_cover_3, t0.image_cover_hover AS image_cover_hover_4, t0.is_coming_soon AS is_coming_soon_5 FROM topics t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 25 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM topics_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
5
]
|
| 26 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM theme_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
24
]
|
| 27 | 0.21 ms |
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.display_order AS display_order_3, t0.parent_id AS parent_id_4 FROM category_post t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 28 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
8
]
|
| 29 | 0.27 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.views AS views_3, t0.actif AS actif_4, t0.likes AS likes_5, t0.quality AS quality_6, t0.main_video AS main_video_7, t0.image_cover AS image_cover_8, t0.title AS title_9, t0.duration AS duration_10, t0.produced_by_t4_m AS produced_by_t4_m_11, t0.secondary_video_id AS secondary_video_id_12, t0.video_quality_id AS video_quality_id_13 FROM video t0 WHERE t0.id = ?
Parameters:
[
472
]
|
| 30 | 0.25 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.time_start AS time_start_3, t0.time_end AS time_end_4, t0.image_cover AS image_cover_5, t0.actif AS actif_6, t0.video_id AS video_id_7, t0.theme_id AS theme_id_8 FROM video_sequence t0 WHERE t0.video_id = ? ORDER BY t0.time_start ASC
Parameters:
[
472
]
|
| 31 | 0.22 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
127
]
|
| 32 | 0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
125
]
|
| 33 | 0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
128
]
|
| 34 | 0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
129
]
|
| 35 | 0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
124
]
|
| 36 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.actif AS actif_4 FROM lien_interet t0 INNER JOIN post_lien_interet ON t0.id = post_lien_interet.lien_interet_id WHERE post_lien_interet.post_id = ?
Parameters:
[
126
]
|
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 |
|---|---|
| App\Entity\Post | No errors. |
| App\Entity\Treatment | No errors. |
| App\Entity\Video |
|
| App\Entity\Partner | No errors. |
| App\Entity\CategoryPost | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\Theme | No errors. |
| App\Entity\UserList | No errors. |
| App\Entity\DossierPlaylistItem | No errors. |
| App\Entity\CarouselHome | No errors. |
| App\Entity\LienInteret | No errors. |
| App\Entity\PostTranslation | No errors. |
| App\Entity\Topics | No errors. |
| App\Entity\VideoSequence | No errors. |
| App\Entity\ThemeTranslation | No errors. |
| App\Entity\User |
|
| App\Entity\VideoSubtitles | No errors. |
| App\Entity\VideoWatchTime | No errors. |
| App\Entity\Dossier | No errors. |
| App\Entity\DossierItemCategory | No errors. |
| App\Entity\UserInfo | No errors. |
| App\Entity\BlogArticle | No errors. |
| App\Entity\TopicsTranslation | No errors. |
| App\Entity\CategoryPostTranslation | No errors. |