Query Metrics
5
Database Queries
5
Different statements
6.62 ms
Query time
5
Invalid entities
8
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.13 ms (32.20%) |
1 |
SELECT t0.nom AS nom_1, t0.type AS type_2, t0.path AS path_3, t0.id AS id_4, t0.image AS image_5, t0.caroussel_id AS caroussel_id_6, t0.article_idarticle AS article_idarticle_7, t0.id_categorie AS id_categorie_8, t0.produit_mannuels_id AS produit_mannuels_id_9 FROM image t0 WHERE t0.article_idarticle = ?
Parameters:
[
928
]
|
|
1.45 ms (21.91%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.code_couleur_apli AS code_couleur_apli_4, t0.active AS active_5, t0.categorie_id AS categorie_id_6, t0.image AS image_7, t0.image_accueil AS image_accueil_8, t0.logo_apli AS logo_apli_9 FROM sous_categorie t0 INNER JOIN article_has_sous_categorie ON t0.id = article_has_sous_categorie.sous_categorie_id WHERE article_has_sous_categorie.article_idarticle = ?
Parameters:
[
928
]
|
|
1.37 ms (20.76%) |
1 |
SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.montant AS montant_3, t0.reference AS reference_4, t0.descriptif AS descriptif_5, t0.gamme AS gamme_6, t0.id AS id_7, t0.vedete AS vedete_8, t0.bigblue AS bigblue_9, t0.pourcentage AS pourcentage_10, t0.nouveaute AS nouveaute_11, t0.actif AS actif_12, t0.dateajout AS dateajout_13, t0.livraison_gratuite AS livraison_gratuite_14, t0.nombre_etoile AS nombre_etoile_15, t0.id_marque AS id_marque_16, t0.id_etat AS id_etat_17, t0.commande_id AS commande_id_18 FROM article t0 WHERE t0.id = ?
Parameters:
[
"928"
]
|
|
0.98 ms (14.87%) |
1 |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.caracteristique_model_id AS caracteristique_model_id_3, t0.article_id AS article_id_4 FROM caracteristique t0 WHERE t0.article_id = ?
Parameters:
[
928
]
|
|
0.68 ms (10.27%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.logo AS logo_4, t0.immage AS immage_5 FROM marque t0 WHERE t0.id = ?
Parameters:
[
46
]
|
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\Image | 4 |
| App\Entity\Article | 1 |
| App\Entity\Marque | 1 |
| App\Entity\SousCategorie | 1 |
| App\Entity\Categorie | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Article |
|
| App\Entity\Marque |
|
| App\Entity\Etat | No errors. |
| App\Entity\Commande | No errors. |
| App\Entity\SousCategorie |
|
| App\Entity\Image | No errors. |
| App\Entity\Caracteristique | No errors. |
| App\Entity\RubriqueHasArticle | No errors. |
| App\Entity\Caroussels | No errors. |
| App\Entity\Categorie |
|
| App\Entity\ProduitMannuels | No errors. |
| App\Entity\CaracteristiqueModel | No errors. |
| App\Entity\Nouveaute |
|