https://renovathome.djabdigital.com/realisation/renovation-de-couverture

Query Metrics

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

Grouped Statements

Show all queries

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.