Query Metrics
4
Database Queries
4
Different statements
3.49 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.30 ms (37.22%) |
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
Parameters:
[] |
1.08 ms (30.89%) |
1 |
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:
[] |
0.60 ms (17.06%) |
1 |
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:
[] |
0.52 ms (14.83%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categorie t0
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. |