Query Metrics
5
Database Queries
5
Different statements
2.73 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.73 ms (26.79%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.avant AS avant_4, t0.apres AS apres_5, t0.slug AS slug_6, t0.cover AS cover_7, t0.lieu AS lieu_8, t0.taches AS taches_9, t0.favori AS favori_10, t0.categorie_id AS categorie_id_11 FROM realisation t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"renovation-de-couverture"
]
|
0.67 ms (24.51%) |
1 |
SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.description AS description_2, r0_.avant AS avant_3, r0_.apres AS apres_4, r0_.slug AS slug_5, r0_.cover AS cover_6, r0_.lieu AS lieu_7, r0_.taches AS taches_8, r0_.favori AS favori_9, r0_.categorie_id AS categorie_id_10 FROM realisation r0_ INNER JOIN categorie c1_ ON r0_.categorie_id = c1_.id WHERE c1_.id = ? AND r0_.id <> ?
Parameters:
[ 1 4 ] |
0.46 ms (17.03%) |
1 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.realisation_id AS realisation_id_5 FROM photo t0 WHERE t0.realisation_id = ?
Parameters:
[
4
]
|
0.45 ms (16.62%) |
1 |
SELECT t0.id AS id_1, t0.client AS client_2, t0.photo AS photo_3, t0.commentaire AS commentaire_4, t0.video AS video_5, t0.realisation_id AS realisation_id_6 FROM temoignage t0 WHERE t0.realisation_id = ?
Parameters:
[
4
]
|
0.41 ms (15.05%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\Realisation | No errors. |
App\Entity\Categorie | No errors. |
App\Entity\Photo | No errors. |
App\Entity\Temoignage | No errors. |