Query Metrics
11
Database Queries
11
Different statements
18.23 ms
Query time
5
Invalid entities
1225
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.03 ms |
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:
[
"1037"
]
|
| 2 | 1.96 ms |
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:
[
1037
]
|
| 3 | 1.03 ms |
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:
[
1037
]
|
| 4 | 2.36 ms |
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:
[
1037
]
|
| 5 | 1.24 ms |
SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.nom_canonique AS nom_canonique_2, m0_.logo AS logo_3, m0_.immage AS immage_4 FROM marque m0_
Parameters:
[] |
| 6 | 0.93 ms |
SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.nom_canonique AS nom_canonique_2, e0_.immage AS immage_3 FROM etat e0_
Parameters:
[] |
| 7 | 0.53 ms |
SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.nom_canonique AS nom_canonique_2, s0_.code_couleur_apli AS code_couleur_apli_3, s0_.active AS active_4, s0_.categorie_id AS categorie_id_5, s0_.image AS image_6, s0_.image_accueil AS image_accueil_7, s0_.logo_apli AS logo_apli_8 FROM sous_categorie s0_
Parameters:
[] |
| 8 | 2.19 ms |
SELECT c0_.id AS id_0, c0_.valeur AS valeur_1, c0_.caracteristique_model_id AS caracteristique_model_id_2, c0_.article_id AS article_id_3 FROM caracteristique c0_
Parameters:
[] |
| 9 | 0.84 ms |
SELECT h0_.id AS id_0, h0_.titre AS titre_1, h0_.code AS code_2, h0_.description AS description_3, h0_.position AS position_4, h0_.slideauto AS slideauto_5, h0_.pagination AS pagination_6, h0_.control AS control_7, h0_.valide AS valide_8, h0_.intervalle AS intervalle_9, h0_.height AS height_10, h0_.bottomcontent AS bottomcontent_11, h0_.bottomcolor AS bottomcolor_12, h0_.bottomtext AS bottomtext_13, h0_.bottombg AS bottombg_14, h0_.link AS link_15, h0_.categorie_id AS categorie_id_16, h0_.souscategorie_id AS souscategorie_id_17 FROM hh_caroussels h0_
Parameters:
[] |
| 10 | 3.94 ms |
SELECT a0_.nom AS nom_0, a0_.nom_canonique AS nom_canonique_1, a0_.montant AS montant_2, a0_.reference AS reference_3, a0_.descriptif AS descriptif_4, a0_.gamme AS gamme_5, a0_.id AS id_6, a0_.vedete AS vedete_7, a0_.bigblue AS bigblue_8, a0_.pourcentage AS pourcentage_9, a0_.nouveaute AS nouveaute_10, a0_.actif AS actif_11, a0_.dateajout AS dateajout_12, a0_.livraison_gratuite AS livraison_gratuite_13, a0_.nombre_etoile AS nombre_etoile_14, a0_.id_marque AS id_marque_15, a0_.id_etat AS id_etat_16, a0_.commande_id AS commande_id_17 FROM article a0_
Parameters:
[] |
| 11 | 1.18 ms |
SELECT c0_.nom AS nom_0, c0_.nom_canonique AS nom_canonique_1, c0_.code_image AS code_image_2, c0_.id AS id_3, c0_.code_couleur_apli AS code_couleur_apli_4, c0_.active AS active_5, c0_.immage AS immage_6, c0_.image_du_sous_menu AS image_du_sous_menu_7, c0_.logo AS logo_8, c0_.logo_apli AS logo_apli_9, c0_.logo_apli_accueil AS logo_apli_accueil_10, c0_.image_background_apli AS image_background_apli_11 FROM categorie c0_
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Caracteristique | 537 |
| App\Entity\Article | 444 |
| App\Entity\Image | 134 |
| App\Entity\Marque | 44 |
| App\Entity\SousCategorie | 27 |
| App\Entity\CaracteristiqueModel | 23 |
| App\Entity\Categorie | 7 |
| App\Entity\Etat | 4 |
| App\Entity\Caroussels | 4 |
| App\Entity\Commande | 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\CaracteristiqueModel | No errors. |
| App\Entity\ProduitMannuels | No errors. |
| App\Entity\Nouveaute |
|