Query Metrics
4
Database Queries
4
Different statements
7.40 ms
Query time
0
Invalid entities
Queries
#▲ | 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. |