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

Response
200 OK
IP
216.73.216.205
Profiled on
Token
d66066

Query Metrics

162 Database Queries
8 Different statements
124.24 ms Query time
5 Invalid entities
284 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
45.35 ms
(36.50%) 		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: 
[
  1018
]
View formatted query    View runnable query    Explain query
39.45 ms
(31.76%) 		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: 
[
  1018
]
View formatted query    View runnable query    Explain query
28.76 ms
(23.15%) 		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: 
[
  1018
]
View formatted query    View runnable query    Explain query
3.24 ms
(2.60%) 		1 
SELECT DISTINCT a0_.id AS id_0, a0_.nombre_etoile AS nombre_etoile_1, a0_.dateajout AS dateajout_2 FROM article a0_ ORDER BY a0_.nombre_etoile DESC, a0_.dateajout DESC LIMIT 50
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.82 ms
(2.27%) 		5 
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
]
View formatted query    View runnable query    Explain query
2.29 ms
(1.84%) 		4 
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: 
[
  1
]
View formatted query    View runnable query    Explain query
1.18 ms
(0.95%) 		1 
SELECT count(a0_.id) AS sclr_0 FROM article a0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.15 ms
(0.93%) 		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, a0_.id_marque AS id_marque_15, a0_.id_etat AS id_etat_16, a0_.commande_id AS commande_id_17 FROM article a0_ WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.nombre_etoile DESC, a0_.dateajout DESC
Parameters: 
[
  1018
  1055
  1054
  1019
  1034
  1024
  1021
  1033
  1027
  976
  977
  975
  834
  832
  141
  4
  983
  886
  1053
  1043
  1039
  1040
  1022
  1049
  1037
  1042
  1044
  1038
  1050
  1035
  1048
  1052
  1025
  1026
  1023
  1041
  1020
  1051
  1045
  1036
  888
  896
  898
  1000
  768
  939
  945
  936
  935
  940
]
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\Image 164
App\Entity\Article 50
App\Entity\Caracteristique 28
App\Entity\SousCategorie 17
App\Entity\CaracteristiqueModel 10
App\Entity\Marque 5
App\Entity\Categorie 5
App\Entity\Etat 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\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.