Query Metrics

11 Database Queries
11 Different statements
18.23 ms Query time
5 Invalid entities
1225 Managed entities

Queries

Group similar statements

# 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
  • The mappings App\Entity\Article#etat and App\Entity\Etat#articles are inconsistent with each other.
App\Entity\Marque
  • The mappings App\Entity\Marque#nouveautes and App\Entity\Nouveaute#marque are inconsistent with each other.
App\Entity\Etat No errors.
App\Entity\Commande No errors.
App\Entity\SousCategorie
  • The join columns of the many-to-many table 'sous_categorie_has_caracteristique_model' have to contain to ALL identifier columns of the source entity 'App\Entity\SousCategorie', however '' are missing.
App\Entity\Image No errors.
App\Entity\Caracteristique No errors.
App\Entity\RubriqueHasArticle No errors.
App\Entity\Caroussels No errors.
App\Entity\Categorie
  • The association App\Entity\Categorie#nouveautes refers to the owning side field App\Entity\Nouveaute#categorie which does not exist.
  • The field App\Entity\Categorie#sousCaregories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SousCategorie#categorie does not contain the required 'inversedBy="sousCaregories"' attribute.
  • The field App\Entity\Categorie#slides is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Image#categorie does not contain the required 'inversedBy="slides"' attribute.
App\Entity\CaracteristiqueModel No errors.
App\Entity\ProduitMannuels No errors.
App\Entity\Nouveaute
  • The mappings App\Entity\Nouveaute#etat and App\Entity\Etat#articles are inconsistent with each other.