GET https://www.philippegautier.com/recherche/chanter

Query Metrics

9 Database Queries
5 Different statements
15.14 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 8.49 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 LEFT JOIN paroles p3_ ON m0_.id = p3_.media_id WHERE m0_.actif = 1 AND ((m0_.titre LIKE ? OR m0_.categorie LIKE ? OR m0_.legende LIKE ? OR m0_.title LIKE ? OR a1_.nom LIKE ? OR a1_.prenom LIKE ? OR p3_.texte LIKE ?)) ORDER BY m0_.date_crea DESC
Parameters:
[
  "%chanter%"
  "%chanter%"
  "%chanter%"
  "%chanter%"
  "%chanter%"
  "%chanter%"
  "%chanter%"
]
2 0.59 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:
[
  84
]
3 0.49 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:
[
  80
]
4 0.44 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:
[
  79
]
5 1.66 ms
SELECT n0_.id AS id_0, n0_.texte AS texte_1, n0_.date_publi AS date_publi_2, n0_.titre_lien AS titre_lien_3, n0_.lien AS lien_4, n0_.date_crea AS date_crea_5, n0_.date_modif AS date_modif_6, n0_.actif AS actif_7, n0_.titre AS titre_8 FROM news n0_ WHERE n0_.texte LIKE ? ORDER BY n0_.date_crea DESC
Parameters:
[
  "%chanter%"
]
6 1.44 ms
SELECT p0_.id AS id_0, p0_.texte AS texte_1, p0_.date_crea AS date_crea_2, p0_.date_modif AS date_modif_3, p0_.actif AS actif_4, p0_.media_id AS media_id_5 FROM paroles p0_ WHERE p0_.texte LIKE ? ORDER BY p0_.date_crea DESC
Parameters:
[
  "%chanter%"
]
7 0.57 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:
[
  84
]
8 1.01 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
]
9 0.45 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:
[
  79
]

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 3
App\Entity\Paroles 3
App\Entity\Auteurs 3

Entities Mapping

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