GET https://kondashop.com/ka/article?page=1&sort%5Bcaracteristiques%5D=DESC

Response
200 OK
IP
216.73.216.205
Profiled on
Token
5abb64

Query Metrics

169 Database Queries
8 Different statements
120.88 ms Query time
5 Invalid entities
501 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
37.01 ms
(30.61%) 		50 
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: 
[
  961
]
View formatted query    View runnable query    Explain query
32.54 ms
(26.91%) 		50 
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: 
[
  961
]
View formatted query    View runnable query    Explain query
29.07 ms
(24.05%) 		50 
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: 
[
  961
]
View formatted query    View runnable query    Explain query
8.58 ms
(7.10%) 		1 
SELECT DISTINCT a0_.id AS id_0, (SELECT COUNT(c1_.id) AS sclr_2 FROM caracteristique c1_ WHERE c1_.article_id = a0_.id) AS sclr_1, a0_.id AS id_3, a0_.dateajout AS dateajout_4 FROM article a0_ LEFT JOIN caracteristique c2_ ON a0_.id = c2_.article_id ORDER BY sclr_1 DESC, a0_.id DESC, a0_.dateajout DESC LIMIT 50
Parameters: 
[]
View formatted query    View runnable query    Explain query
7.07 ms
(5.85%) 		13 
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: 
[
  41
]
View formatted query    View runnable query    Explain query
2.48 ms
(2.05%) 		1 
SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ LEFT JOIN caracteristique c1_ ON a0_.id = c1_.article_id
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.39 ms
(1.98%) 		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, (SELECT COUNT(c1_.id) AS sclr_16 FROM caracteristique c1_ WHERE c1_.article_id = a0_.id) AS sclr_15, a0_.id_marque AS id_marque_17, a0_.id_etat AS id_etat_18, a0_.commande_id AS commande_id_19 FROM article a0_ LEFT JOIN caracteristique c2_ ON a0_.id = c2_.article_id WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_15 DESC, a0_.id DESC, a0_.dateajout DESC
Parameters: 
[
  961
  960
  959
  957
  943
  190
  962
  958
  956
  955
  946
  945
  944
  942
  941
  940
  939
  938
  842
  501
  500
  499
  196
  171
  169
  157
  154
  141
  963
  478
  476
  474
  468
  460
  192
  951
  935
  934
  894
  760
  759
  758
  495
  229
  1014
  1013
  1012
  1011
  1010
  1009
]
View formatted query    View runnable query    Explain query
1.75 ms
(1.45%) 		3 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.immage AS immage_4 FROM etat t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query

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 293
App\Entity\Image 117
App\Entity\Article 50
App\Entity\CaracteristiqueModel 19
App\Entity\Marque 13
App\Entity\Etat 3
App\Entity\SousCategorie 3
App\Entity\Categorie 3

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\Caracteristique No errors.
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\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\ProduitMannuels No errors.
App\Entity\CaracteristiqueModel No errors.
App\Entity\Nouveaute
  • The mappings App\Entity\Nouveaute#etat and App\Entity\Etat#articles are inconsistent with each other.