GET https://mail.philippegautier.com/reel

Query Metrics

24 Database Queries
8 Different statements
16.96 ms Query time
0 Invalid entities
38 Managed entities

Queries

Group similar statements

# Time Info
1 2.04 ms
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.actif = 1 AND p0_.home_page = 1
Parameters:
[]
2 0.48 ms
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.actif = 1 AND p0_.slug = ?
Parameters:
[
  "/reel"
]
3 0.40 ms
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.home_page = 1
Parameters:
[]
4 1.25 ms
SELECT c0_.id AS id_0, c0_.nom_template AS nom_template_1, c0_.ordre AS ordre_2, c0_.id_conf AS id_conf_3, c0_.actif AS actif_4, c0_.page_id AS page_id_5, c0_.contenu_id AS contenu_id_6 FROM cases_pages c0_ WHERE c0_.page_id = ? AND c0_.actif = 1 ORDER BY c0_.ordre ASC
Parameters:
[
  15
]
5 2.90 ms
SELECT a0_.id AS id_0, a0_.ordre AS ordre_1, a0_.actif AS actif_2, a0_.media_id AS media_id_3 FROM accueil a0_ WHERE a0_.ordre > ? ORDER BY a0_.ordre ASC
Parameters:
[
  0
]
6 1.10 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contenu AS contenu_3, t0.url AS url_4, t0.js AS js_5 FROM contenu t0 WHERE t0.id = ?
Parameters:
[
  15
]
7 0.54 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.poster AS poster_4, t0.categorie AS categorie_5, t0.legende AS legende_6, t0.title AS title_7, t0.actif AS actif_8, t0.date_crea AS date_crea_9, t0.date_modif AS date_modif_10, t0.poster_bd AS poster_bd_11, t0.ordre_g AS ordre_g_12, t0.ordre AS ordre_13, t14.id AS id_15, t14.texte AS texte_16, t14.date_crea AS date_crea_17, t14.date_modif AS date_modif_18, t14.actif AS actif_19, t14.media_id AS media_id_20 FROM medias t0 LEFT JOIN paroles t14 ON t14.media_id = t0.id WHERE t0.id = ?
Parameters:
[
  131
]
8 0.52 ms
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = ?
Parameters:
[
  131
]
9 0.45 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.poster AS poster_4, t0.categorie AS categorie_5, t0.legende AS legende_6, t0.title AS title_7, t0.actif AS actif_8, t0.date_crea AS date_crea_9, t0.date_modif AS date_modif_10, t0.poster_bd AS poster_bd_11, t0.ordre_g AS ordre_g_12, t0.ordre AS ordre_13, t14.id AS id_15, t14.texte AS texte_16, t14.date_crea AS date_crea_17, t14.date_modif AS date_modif_18, t14.actif AS actif_19, t14.media_id AS media_id_20 FROM medias t0 LEFT JOIN paroles t14 ON t14.media_id = t0.id WHERE t0.id = ?
Parameters:
[
  80
]
10 0.39 ms
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = ?
Parameters:
[
  80
]
11 0.39 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.poster AS poster_4, t0.categorie AS categorie_5, t0.legende AS legende_6, t0.title AS title_7, t0.actif AS actif_8, t0.date_crea AS date_crea_9, t0.date_modif AS date_modif_10, t0.poster_bd AS poster_bd_11, t0.ordre_g AS ordre_g_12, t0.ordre AS ordre_13, t14.id AS id_15, t14.texte AS texte_16, t14.date_crea AS date_crea_17, t14.date_modif AS date_modif_18, t14.actif AS actif_19, t14.media_id AS media_id_20 FROM medias t0 LEFT JOIN paroles t14 ON t14.media_id = t0.id WHERE t0.id = ?
Parameters:
[
  41
]
12 0.39 ms
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = ?
Parameters:
[
  41
]
13 0.41 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.poster AS poster_4, t0.categorie AS categorie_5, t0.legende AS legende_6, t0.title AS title_7, t0.actif AS actif_8, t0.date_crea AS date_crea_9, t0.date_modif AS date_modif_10, t0.poster_bd AS poster_bd_11, t0.ordre_g AS ordre_g_12, t0.ordre AS ordre_13, t14.id AS id_15, t14.texte AS texte_16, t14.date_crea AS date_crea_17, t14.date_modif AS date_modif_18, t14.actif AS actif_19, t14.media_id AS media_id_20 FROM medias t0 LEFT JOIN paroles t14 ON t14.media_id = t0.id WHERE t0.id = ?
Parameters:
[
  87
]
14 0.37 ms
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = ?
Parameters:
[
  87
]
15 0.62 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.poster AS poster_4, t0.categorie AS categorie_5, t0.legende AS legende_6, t0.title AS title_7, t0.actif AS actif_8, t0.date_crea AS date_crea_9, t0.date_modif AS date_modif_10, t0.poster_bd AS poster_bd_11, t0.ordre_g AS ordre_g_12, t0.ordre AS ordre_13, t14.id AS id_15, t14.texte AS texte_16, t14.date_crea AS date_crea_17, t14.date_modif AS date_modif_18, t14.actif AS actif_19, t14.media_id AS media_id_20 FROM medias t0 LEFT JOIN paroles t14 ON t14.media_id = t0.id WHERE t0.id = ?
Parameters:
[
  36
]
16 0.53 ms
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = ?
Parameters:
[
  36
]
17 0.49 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.poster AS poster_4, t0.categorie AS categorie_5, t0.legende AS legende_6, t0.title AS title_7, t0.actif AS actif_8, t0.date_crea AS date_crea_9, t0.date_modif AS date_modif_10, t0.poster_bd AS poster_bd_11, t0.ordre_g AS ordre_g_12, t0.ordre AS ordre_13, t14.id AS id_15, t14.texte AS texte_16, t14.date_crea AS date_crea_17, t14.date_modif AS date_modif_18, t14.actif AS actif_19, t14.media_id AS media_id_20 FROM medias t0 LEFT JOIN paroles t14 ON t14.media_id = t0.id WHERE t0.id = ?
Parameters:
[
  92
]
18 0.55 ms
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = ?
Parameters:
[
  92
]
19 0.61 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.poster AS poster_4, t0.categorie AS categorie_5, t0.legende AS legende_6, t0.title AS title_7, t0.actif AS actif_8, t0.date_crea AS date_crea_9, t0.date_modif AS date_modif_10, t0.poster_bd AS poster_bd_11, t0.ordre_g AS ordre_g_12, t0.ordre AS ordre_13, t14.id AS id_15, t14.texte AS texte_16, t14.date_crea AS date_crea_17, t14.date_modif AS date_modif_18, t14.actif AS actif_19, t14.media_id AS media_id_20 FROM medias t0 LEFT JOIN paroles t14 ON t14.media_id = t0.id WHERE t0.id = ?
Parameters:
[
  35
]
20 0.53 ms
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = ?
Parameters:
[
  35
]
21 0.51 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.poster AS poster_4, t0.categorie AS categorie_5, t0.legende AS legende_6, t0.title AS title_7, t0.actif AS actif_8, t0.date_crea AS date_crea_9, t0.date_modif AS date_modif_10, t0.poster_bd AS poster_bd_11, t0.ordre_g AS ordre_g_12, t0.ordre AS ordre_13, t14.id AS id_15, t14.texte AS texte_16, t14.date_crea AS date_crea_17, t14.date_modif AS date_modif_18, t14.actif AS actif_19, t14.media_id AS media_id_20 FROM medias t0 LEFT JOIN paroles t14 ON t14.media_id = t0.id WHERE t0.id = ?
Parameters:
[
  201
]
22 0.51 ms
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = ?
Parameters:
[
  201
]
23 0.51 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.poster AS poster_4, t0.categorie AS categorie_5, t0.legende AS legende_6, t0.title AS title_7, t0.actif AS actif_8, t0.date_crea AS date_crea_9, t0.date_modif AS date_modif_10, t0.poster_bd AS poster_bd_11, t0.ordre_g AS ordre_g_12, t0.ordre AS ordre_13, t14.id AS id_15, t14.texte AS texte_16, t14.date_crea AS date_crea_17, t14.date_modif AS date_modif_18, t14.actif AS actif_19, t14.media_id AS media_id_20 FROM medias t0 LEFT JOIN paroles t14 ON t14.media_id = t0.id WHERE t0.id = ?
Parameters:
[
  34
]
24 0.48 ms
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = ?
Parameters:
[
  34
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Accueil 9
App\Entity\Medias 9
App\Entity\Auteurs 8
App\Entity\Paroles 6
App\Entity\Pages 2
App\Entity\SecurUser 2
App\Entity\CasesPages 1
App\Entity\Contenu 1

Entities Mapping

Class Mapping errors
App\Entity\Pages No errors.
App\Entity\SecurUser No errors.
App\Entity\CasesPages No errors.
App\Entity\Contenu No errors.
App\Entity\Accueil No errors.
App\Entity\Medias No errors.
App\Entity\Paroles No errors.
App\Entity\Auteurs No errors.
App\Entity\Diapos No errors.