https://renovathome.djabdigital.com/realisations

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.30 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
Parameters:
[]
2 0.52 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categorie t0
Parameters:
[]
3 0.60 ms
SELECT c0_.id AS id_0, MAX(r1_.id) AS sclr_1 FROM realisation r1_ INNER JOIN categorie c0_ ON r1_.categorie_id = c0_.id WHERE r1_.favori = 1 GROUP BY c0_.id ORDER BY sclr_1 DESC
Parameters:
[]
4 1.08 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1, r1_.nom AS nom_2, r1_.description AS description_3, r1_.avant AS avant_4, r1_.apres AS apres_5, r1_.slug AS slug_6, r1_.taches AS taches_7, r1_.favori AS favori_8, MAX(r1_.id) AS sclr_9 FROM realisation r1_ INNER JOIN categorie c0_ ON r1_.categorie_id = c0_.id WHERE r1_.id IN (6, 4, 3) GROUP BY c0_.id, c0_.nom, r1_.nom, r1_.description, r1_.avant, r1_.apres, r1_.slug, r1_.taches, r1_.favori ORDER BY sclr_9 DESC
Parameters:
[]

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.