Query Metrics
266
Database Queries
12
Different statements
88.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
20.52 ms (23.28%) |
62 |
SELECT t0.id_categorie AS id_categorie_1, t0.nom AS nom_2 FROM categorie t0 INNER JOIN model_categorie ON t0.id_categorie = model_categorie.id_categorie WHERE model_categorie.id_model = ?
Parameters:
[
46
]
|
|
20.33 ms (23.07%) |
62 |
SELECT t0.id_page AS id_page_1, t0.numero AS numero_2, t0.classeur_id AS classeur_id_3, t4.id_classeur AS id_classeur_5, t4.nom AS nom_6, t4.couleur AS couleur_7, t4.armoire_id AS armoire_id_8, t4.etagere_id AS etagere_id_9 FROM page t0 INNER JOIN classeur t4 ON t0.classeur_id = t4.id_classeur INNER JOIN model_page ON t0.id_page = model_page.id_page WHERE model_page.id_model = ?
Parameters:
[
46
]
|
|
20.14 ms (22.86%) |
62 |
SELECT t0.id_sous_categorie AS id_sous_categorie_1, t0.nom AS nom_2, t0.categorie_id AS categorie_id_3 FROM sous_categorie t0 INNER JOIN model_ss_categorie ON t0.id_sous_categorie = model_ss_categorie.id_sous_categorie WHERE model_ss_categorie.id_model = ?
Parameters:
[
46
]
|
|
19.62 ms (22.27%) |
62 |
SELECT t0.id_tag AS id_tag_1, t0.nom AS nom_2 FROM tag t0 INNER JOIN model_tag ON t0.id_tag = model_tag.id_tag WHERE model_tag.id_model = ?
Parameters:
[
46
]
|
|
2.69 ms (3.05%) |
8 |
SELECT t0.id_photo AS id_photo_1, t0.chemin AS chemin_2, t0.name AS name_3, t0.model_id AS model_id_4 FROM photo t0 WHERE t0.model_id = ?
Parameters:
[
48
]
|
|
1.37 ms (1.56%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.surname AS surname_6, t0.comment AS comment_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.enabled AS enabled_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
13
]
|
|
1.01 ms (1.14%) |
2 |
SELECT t0.id_model AS id_model_1, t0.annee AS annee_2, t0.nb_exemplaire_edite AS nb_exemplaire_edite_3, t0.fournisseur AS fournisseur_4, t0.titre AS titre_5, t0.description AS description_6, t0.nb AS nb_7, t0.date_creation AS date_creation_8, t0.date_modification AS date_modification_9, t0.diametre AS diametre_10, t0.reference AS reference_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.matiere_id AS matiere_id_14, t0.forme_id AS forme_id_15, t0.localisation_id AS localisation_id_16, t0.type_collection_id AS type_collection_id_17 FROM model t0
Parameters:
[] |
|
0.71 ms (0.81%) |
2 |
SELECT t0.id_armoire AS id_armoire_1, t0.nom AS nom_2 FROM armoire t0 WHERE t0.id_armoire IN (?)
Parameters:
[
43
]
|
|
0.66 ms (0.75%) |
2 |
SELECT t0.id_etagere AS id_etagere_1, t0.nom AS nom_2, t0.armoire_id AS armoire_id_3 FROM etagere t0 WHERE t0.id_etagere IN (?)
Parameters:
[
42
]
|
|
0.38 ms (0.43%) |
1 |
SELECT t0_.id_tag AS id_tag_0, t0_.nom AS nom_1 FROM tag t0_ ORDER BY t0_.nom ASC
Parameters:
[] |
|
0.35 ms (0.39%) |
1 |
SELECT s0_.id_sous_categorie AS id_sous_categorie_0, s0_.nom AS nom_1, s0_.categorie_id AS categorie_id_2 FROM sous_categorie s0_ ORDER BY s0_.nom ASC
Parameters:
[] |
|
0.34 ms (0.39%) |
1 |
SELECT c0_.id_categorie AS id_categorie_0, c0_.nom AS nom_1 FROM categorie c0_ ORDER BY c0_.nom ASC
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\User | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\SousCategorie | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\Model | No errors. |
| App\Entity\Matiere | No errors. |
| App\Entity\Forme | No errors. |
| App\Entity\Localisation | No errors. |
| App\Entity\TypeCollection | No errors. |
| App\Entity\Photo | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Classeur | No errors. |
| App\Entity\Armoire | No errors. |
| App\Entity\Etagere | No errors. |