Query Metrics
9
Database Queries
9
Different statements
20.13 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.95 ms (14.66%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.photo AS photo_3, t0.categorie_id AS categorie_id_4 FROM sous_categorie t0 WHERE t0.categorie_id = ?
Parameters:
[
6
]
|
2.82 ms (13.99%) |
1 |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.photo AS photo_2 FROM categorie c0_ WHERE c0_.id <> ? ORDER BY c0_.id ASC
Parameters:
[
1
]
|
2.59 ms (12.85%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.hauteur AS hauteur_3, t0.diametre AS diametre_4, t0.poids AS poids_5, t0.capacite AS capacite_6, t0.couleur AS couleur_7, t0.prix AS prix_8, t0.image_name AS image_name_9, t0.is_top AS is_top_10, t0.anglais AS anglais_11, t0.description AS description_12, t0.descanglais AS descanglais_13, t0.other_images AS other_images_14, t0.is_new_arrival AS is_new_arrival_15, t0.is_promoted AS is_promoted_16, t0.discount AS discount_17, t0.categorie_id AS categorie_id_18, t0.sous_categorie_id AS sous_categorie_id_19, t0.brand_id AS brand_id_20 FROM produit t0
Parameters:
[] |
2.50 ms (12.43%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.photo AS photo_3 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
"6"
]
|
2.30 ms (11.41%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.link AS link_3, t0.anglais AS anglais_4, t0.photo AS photo_5, t0.description AS description_6, t0.other_images AS other_images_7, t0.menu_id AS menu_id_8 FROM sous_menu t0 WHERE t0.menu_id = ?
Parameters:
[
2
]
|
2.21 ms (11.00%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.hauteur AS hauteur_3, t0.diametre AS diametre_4, t0.poids AS poids_5, t0.capacite AS capacite_6, t0.couleur AS couleur_7, t0.prix AS prix_8, t0.image_name AS image_name_9, t0.is_top AS is_top_10, t0.anglais AS anglais_11, t0.description AS description_12, t0.descanglais AS descanglais_13, t0.other_images AS other_images_14, t0.is_new_arrival AS is_new_arrival_15, t0.is_promoted AS is_promoted_16, t0.discount AS discount_17, t0.categorie_id AS categorie_id_18, t0.sous_categorie_id AS sous_categorie_id_19, t0.brand_id AS brand_id_20 FROM produit t0 WHERE t0.categorie_id = ?
Parameters:
[
6
]
|
1.92 ms (9.54%) |
1 |
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.value AS value_3 FROM configuration t0 WHERE t0.keyword = ? LIMIT 1
Parameters:
[
"FOOTER_INFOS"
]
|
1.76 ms (8.73%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.hauteur AS hauteur_3, t0.diametre AS diametre_4, t0.poids AS poids_5, t0.capacite AS capacite_6, t0.couleur AS couleur_7, t0.prix AS prix_8, t0.image_name AS image_name_9, t0.is_top AS is_top_10, t0.anglais AS anglais_11, t0.description AS description_12, t0.descanglais AS descanglais_13, t0.other_images AS other_images_14, t0.is_new_arrival AS is_new_arrival_15, t0.is_promoted AS is_promoted_16, t0.discount AS discount_17, t0.categorie_id AS categorie_id_18, t0.sous_categorie_id AS sous_categorie_id_19, t0.brand_id AS brand_id_20 FROM produit t0 WHERE t0.sous_categorie_id = ?
Parameters:
[
48
]
|
1.09 ms (5.40%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sous_menu AS sous_menu_3, t0.anglais AS anglais_4 FROM menu 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\Categorie | No errors. |
App\Entity\Produit |
|
App\Entity\SousCategorie | No errors. |
App\Entity\Menu | No errors. |
App\Entity\SousMenu | No errors. |
App\Entity\Configuration | No errors. |
App\Entity\Brand | No errors. |
App\Entity\Promotion | No errors. |