https://renovathome.djabdigital.com/realisation/isolation-de-facade

Query Metrics

5 Database Queries
5 Different statements
3.78 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.97 ms
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:
[
  "isolation-de-facade"
]
2 1.26 ms
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:
[
  2
  1
]
3 0.39 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 0.59 ms
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:
[
  1
]
5 0.58 ms
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:
[
  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.