Query Metrics
1
Database Queries
1
Different statements
5.21 ms
Query time
0
Invalid entities
21
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 5.21 ms |
SELECT b0_.id AS id_0, b0_.libelle AS libelle_1, b0_.slug AS slug_2, b0_.ordre AS ordre_3, b0_.actif AS actif_4, b0_.created_at AS created_at_5, b0_.updated_at AS updated_at_6, b1_.id AS id_7, b1_.titre AS titre_8, b1_.description AS description_9, b1_.ordre AS ordre_10, b1_.actif AS actif_11, b1_.created_at AS created_at_12, b1_.updated_at AS updated_at_13, b2_.id AS id_14, b2_.titre AS titre_15, b2_.description AS description_16, b2_.type AS type_17, b2_.chemin_fichier AS chemin_fichier_18, b2_.lien_externe AS lien_externe_19, b2_.ordre AS ordre_20, b2_.actif AS actif_21, b2_.created_at AS created_at_22, b2_.updated_at AS updated_at_23, b2_.couverture AS couverture_24, b1_.categorie_id AS categorie_id_25, b2_.section_id AS section_id_26 FROM bibliotheque_categorie b0_ LEFT JOIN bibliotheque_section b1_ ON b0_.id = b1_.categorie_id AND (b1_.actif = 1) LEFT JOIN bibliotheque_document b2_ ON b1_.id = b2_.section_id AND (b2_.actif = 1) WHERE b0_.actif = ? ORDER BY b0_.ordre ASC, b1_.ordre ASC, b2_.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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\BibliothequeDocument | 13 |
| App\Entity\BibliothequeSection | 5 |
| App\Entity\BibliothequeCategorie | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\BibliothequeCategorie | No errors. |
| App\Entity\BibliothequeSection | No errors. |
| App\Entity\BibliothequeDocument | No errors. |