GET http://kondashop.com/ar/bio-medecine/consommables-laboratoire_1/pes-pe-e

Query Metrics

34 Database Queries
13 Different statements
33.76 ms Query time
6 Invalid entities
226 Managed entities

Grouped Statements

Show all queries

Time Count Info
6.37 ms
(18.86%)
7
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.id = ?
Parameters:
[
  1708
]
5.22 ms
(15.47%)
5
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.11 ms
(15.13%)
7
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 WHERE t0.categorie_id = ?
Parameters:
[
  3
]
4.36 ms
(12.91%)
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.nom_canonique = ? LIMIT 1
Parameters:
[
  "pes-pe-e"
]
2.16 ms
(6.41%)
4
SELECT t0.id AS id_1, t0.titre AS titre_2 FROM annonces t0
Parameters:
[]
2.15 ms
(6.37%)
3
SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.code_image AS code_image_3, t0.id AS id_4, t0.code_couleur_apli AS code_couleur_apli_5, t0.active AS active_6, t0.immage AS immage_7, t0.image_du_sous_menu AS image_du_sous_menu_8, t0.logo AS logo_9, t0.logo_apli AS logo_apli_10, t0.logo_apli_accueil AS logo_apli_accueil_11, t0.image_background_apli AS image_background_apli_12 FROM categorie t0 WHERE t0.active = ?
Parameters:
[
  1
]
1.77 ms
(5.23%)
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:
[
  1037
]
1.47 ms
(4.36%)
1
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, s1_.id AS id_15, s1_.nom AS nom_16, s1_.nom_canonique AS nom_canonique_17, s1_.code_couleur_apli AS code_couleur_apli_18, s1_.active AS active_19, a0_.id_marque AS id_marque_20, a0_.id_etat AS id_etat_21, a0_.commande_id AS commande_id_22, s1_.categorie_id AS categorie_id_23, s1_.image AS image_24, s1_.image_accueil AS image_accueil_25, s1_.logo_apli AS logo_apli_26 FROM article a0_ LEFT JOIN article_has_sous_categorie a2_ ON a0_.id = a2_.article_idarticle LEFT JOIN sous_categorie s1_ ON s1_.id = a2_.sous_categorie_id WHERE s1_.id IN (?) AND a0_.id <> ? LIMIT 4
Parameters:
[
  58
  1037
]
1.28 ms
(3.79%)
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:
[
  1037
]
1.17 ms
(3.48%)
1
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_ WHERE m0_.logo IS NOT NULL
Parameters:
[]
1.09 ms
(3.22%)
1
SELECT t0.id AS id_1, t0.evenement AS evenement_2, t0.validite AS validite_3, t0.dateajout AS dateajout_4, t0.datedebut AS datedebut_5, t0.datefin AS datefin_6, t0.explication AS explication_7, t0.urlvideos AS urlvideos_8, t0.image AS image_9 FROM topbannieres t0 WHERE t0.validite = ? ORDER BY t0.dateajout DESC LIMIT 1
Parameters:
[
  1
]
1.04 ms
(3.08%)
1
SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.code_image AS code_image_3, t0.id AS id_4, t0.code_couleur_apli AS code_couleur_apli_5, t0.active AS active_6, t0.immage AS immage_7, t0.image_du_sous_menu AS image_du_sous_menu_8, t0.logo AS logo_9, t0.logo_apli AS logo_apli_10, t0.logo_apli_accueil AS logo_apli_accueil_11, t0.image_background_apli AS image_background_apli_12 FROM categorie t0 WHERE t0.nom_canonique = ? LIMIT 1
Parameters:
[
  "bio-medecine"
]
0.57 ms
(1.69%)
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 WHERE t0.nom_canonique = ? LIMIT 1
Parameters:
[
  "consommables-laboratoire_1"
]

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 139
App\Entity\Marque 44
App\Entity\SousCategorie 27
App\Entity\Categorie 7
App\Entity\Article 5
App\Entity\Annonces 3
App\Entity\Topbannieres 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\InfoClient
  • The association App\Entity\InfoClient#pointsTransactions refers to the owning side field App\Entity\PointsTransaction#infoclient which does not exist.
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.
App\Entity\Topbannieres No errors.
App\Entity\Caroussels No errors.
App\Entity\Annonces No errors.