Query Metrics
1
Database Queries
1
Different statements
8.39 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 8.39 ms |
SELECT l0_.id AS id_0, l0_.titre AS titre_1, l0_.description AS description_2, l0_.prix AS prix_3, l0_.lien_achat AS lien_achat_4, l0_.annee_publication AS annee_publication_5, l0_.slug AS slug_6, l0_.active AS active_7, a1_.id AS id_8, a1_.nom AS nom_9, a1_.biographie AS biographie_10, a1_.photo AS photo_11, a1_.slug AS slug_12, a1_.date_creation AS date_creation_13, i2_.id AS id_14, i2_.url AS url_15, i2_.alt_text AS alt_text_16, i2_.ordre AS ordre_17, i2_.livre_id AS livre_id_18 FROM livre l0_ LEFT JOIN livre_auteur l3_ ON l0_.id = l3_.livre_id LEFT JOIN auteur a1_ ON a1_.id = l3_.auteur_id LEFT JOIN image_livre i2_ ON l0_.id = i2_.livre_id WHERE l0_.active = ? ORDER BY l0_.annee_publication DESC, i2_.ordre ASC
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\Livre | No errors. |
| App\Entity\Auteur | No errors. |
| App\Entity\ImageLivre | No errors. |