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

Response
200 OK
IP
216.73.216.205
Profiled on
Token
c4332c

Query Metrics

160 Database Queries
8 Different statements
197.24 ms Query time
5 Invalid entities
244 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
66.06 ms
(33.49%) 		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: 
[
  1055
]
View formatted query    View runnable query    Explain query
46.87 ms
(23.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: 
[
  1055
]
View formatted query    View runnable query    Explain query
42.72 ms
(21.66%) 		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: 
[
  1055
]
View formatted query    View runnable query    Explain query
25.47 ms
(12.91%) 		1 
SELECT DISTINCT a0_.id AS id_0, a0_.dateajout AS dateajout_1 FROM article a0_ ORDER BY a0_.dateajout DESC LIMIT 50
Parameters: 
[]
View formatted query    View runnable query    Explain query
6.40 ms
(3.24%) 		3 
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
4.64 ms
(2.35%) 		1 
SELECT count(a0_.id) AS sclr_0 FROM article a0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.64 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.45 ms
(0.73%) 		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_.dateajout DESC
Parameters: 
[
  1055
  983
  891
  887
  886
  770
  624
  644
  641
  824
  643
  1054
  1053
  1019
  1052
  1049
  1038
  1042
  1039
  1034
  1048
  1035
  1043
  1026
  1047
  1021
  1023
  1050
  1037
  1018
  1041
  1051
  1027
  1024
  1033
  1022
  1046
  1040
  1036
  1025
  1044
  1045
  1020
  896
  892
  888
  898
  906
  1017
  913
]
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 160
App\Entity\Article 50
App\Entity\SousCategorie 18
App\Entity\Categorie 6
App\Entity\Etat 4
App\Entity\Marque 3
App\Entity\Commande 1
App\Entity\Caracteristique 1
App\Entity\CaracteristiqueModel 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.