GET https://mail.philippegautier.com/auteur/Zazie

Query Metrics

6 Database Queries
4 Different statements
8.02 ms Query time
0 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 2.51 ms
SELECT a0_.id AS id_0, a0_.prenom AS prenom_1, a0_.nom AS nom_2, a0_.date_crea AS date_crea_3, a0_.date_modif AS date_modif_4, a0_.texte AS texte_5 FROM auteurs a0_ WHERE a0_.nom LIKE ? ORDER BY a0_.date_crea DESC
Parameters:
[
  "Zazie"
]
2 2.63 ms
SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.video AS video_2, m0_.poster AS poster_3, m0_.categorie AS categorie_4, m0_.legende AS legende_5, m0_.title AS title_6, m0_.actif AS actif_7, m0_.date_crea AS date_crea_8, m0_.date_modif AS date_modif_9, m0_.poster_bd AS poster_bd_10, m0_.ordre_g AS ordre_g_11, m0_.ordre AS ordre_12 FROM medias m0_ LEFT JOIN medias_auteurs m2_ ON m0_.id = m2_.medias_id LEFT JOIN auteurs a1_ ON a1_.id = m2_.auteurs_id WHERE m0_.actif = 1 AND a1_.id LIKE ?
Parameters:
[
  110
]
3 1.45 ms
SELECT t0.id AS id_1, t0.texte AS texte_2, t0.date_crea AS date_crea_3, t0.date_modif AS date_modif_4, t0.actif AS actif_5, t0.media_id AS media_id_6 FROM paroles t0 WHERE t0.media_id = ?
Parameters:
[
  114
]
4 0.43 ms
SELECT t0.id AS id_1, t0.texte AS texte_2, t0.date_crea AS date_crea_3, t0.date_modif AS date_modif_4, t0.actif AS actif_5, t0.media_id AS media_id_6 FROM paroles t0 WHERE t0.media_id = ?
Parameters:
[
  254
]
5 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:
[
  114
]
6 0.49 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:
[
  254
]

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\Medias 2
App\Entity\Auteurs 1

Entities Mapping

Class Mapping errors
App\Entity\Auteurs No errors.
App\Entity\Medias No errors.
App\Entity\Diapos No errors.
App\Entity\Paroles No errors.