http://amce.dev.goons.mana.paris/actualites

Query Metrics

4 Database Queries
4 Different statements
7.40 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.39 ms
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.miniature AS miniature_3, p0_.fichier AS fichier_4, p0_.nom_lien AS nom_lien_5, p0_.fichier2 AS fichier2_6, p0_.nom_lien2 AS nom_lien2_7, p0_.fichier3 AS fichier3_8, p0_.nom_lien3 AS nom_lien3_9, p0_.date AS date_10, p0_.slug AS slug_11, p0_.category_id AS category_id_12 FROM publication p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.nom = ? ORDER BY p0_.date DESC
Parameters:
[
  "Actualités"
]
2 1.30 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.sort AS sort_4 FROM category t0 WHERE t0.id IN (?)
Parameters:
[
  5
]
3 1.42 ms
SELECT t0.id AS id_1, t0.ecran AS ecran_2, t0.ordre AS ordre_3, t0.bloc_id AS bloc_id_4, t5.id AS id_6, t5.nom AS nom_7, t5.image AS image_8, t5.titre AS titre_9, t5.stitre AS stitre_10, t5.txt_lien AS txt_lien_11, t5.lien AS lien_12, t5.contenu AS contenu_13, t5.type AS type_14, t5.admin AS admin_15 FROM bloc_ecran t0 LEFT JOIN bloc_droite t5 ON t0.bloc_id = t5.id WHERE t0.ecran = ? ORDER BY t0.ordre ASC
Parameters:
[
  "publication"
]
4 1.30 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.bloc_id AS bloc_id_3, t4.id AS id_5, t4.nom AS nom_6, t4.image AS image_7, t4.titre AS titre_8, t4.stitre AS stitre_9, t4.txt_lien AS txt_lien_10, t4.lien AS lien_11, t4.contenu AS contenu_12, t4.type AS type_13, t4.admin AS admin_14 FROM img_carrousel t0 LEFT JOIN bloc_droite t4 ON t0.bloc_id = t4.id WHERE t0.bloc_id = ?
Parameters:
[
  19
]

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\Publication No errors.
App\Entity\Category No errors.
App\Entity\Tag No errors.
App\Entity\BlocEcran No errors.
App\Entity\BlocDroite No errors.
App\Entity\ImgCarrousel No errors.