GET https://kondashop.com/ka/sous-categorie?page=2&sort%5Bcategorie%5D=DESC

Response
200 OK
IP
216.73.216.115
Profiled on
Token
63575a

Query Metrics

25 Database Queries
6 Different statements
48.53 ms Query time
5 Invalid entities
54 Managed entities

Queries

Group similar statements

#▲ Time Info
1 5.00 ms 
SELECT DISTINCT s0_.id AS id_0, s0_.categorie_id AS sclr_1 FROM sous_categorie s0_ LEFT JOIN categorie c1_ ON s0_.categorie_id = c1_.id ORDER BY s0_.categorie_id DESC LIMIT 20 OFFSET 20
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 4.87 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_ LEFT JOIN categorie c1_ ON s0_.categorie_id = c1_.id WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.categorie_id DESC
Parameters: 
[
  71
  62
  59
  53
  52
  51
  45
]
View formatted query    View runnable query    Explain query
3 0.69 ms 
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sous_categorie s0_ LEFT JOIN categorie c1_ ON s0_.categorie_id = c1_.id
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 2.00 ms 
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.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
5 3.06 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 INNER JOIN article_has_sous_categorie ON t0.id = article_has_sous_categorie.article_idarticle WHERE article_has_sous_categorie.sous_categorie_id = ?
Parameters: 
[
  45
]
View formatted query    View runnable query    Explain query
6 3.92 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.id = ?
Parameters: 
[
  2048
]
View formatted query    View runnable query    Explain query
7 0.62 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.id = ?
Parameters: 
[
  2049
]
View formatted query    View runnable query    Explain query
8 3.11 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 INNER JOIN article_has_sous_categorie ON t0.id = article_has_sous_categorie.article_idarticle WHERE article_has_sous_categorie.sous_categorie_id = ?
Parameters: 
[
  51
]
View formatted query    View runnable query    Explain query
9 2.96 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.id = ?
Parameters: 
[
  2267
]
View formatted query    View runnable query    Explain query
10 0.62 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.id = ?
Parameters: 
[
  2268
]
View formatted query    View runnable query    Explain query
11 0.74 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 INNER JOIN article_has_sous_categorie ON t0.id = article_has_sous_categorie.article_idarticle WHERE article_has_sous_categorie.sous_categorie_id = ?
Parameters: 
[
  52
]
View formatted query    View runnable query    Explain query
12 2.98 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.id = ?
Parameters: 
[
  2518
]
View formatted query    View runnable query    Explain query
13 0.56 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.id = ?
Parameters: 
[
  2282
]
View formatted query    View runnable query    Explain query
14 0.78 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 INNER JOIN article_has_sous_categorie ON t0.id = article_has_sous_categorie.article_idarticle WHERE article_has_sous_categorie.sous_categorie_id = ?
Parameters: 
[
  53
]
View formatted query    View runnable query    Explain query
15 0.56 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.id = ?
Parameters: 
[
  2300
]
View formatted query    View runnable query    Explain query
16 0.83 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.id = ?
Parameters: 
[
  2301
]
View formatted query    View runnable query    Explain query
17 4.48 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 INNER JOIN article_has_sous_categorie ON t0.id = article_has_sous_categorie.article_idarticle WHERE article_has_sous_categorie.sous_categorie_id = ?
Parameters: 
[
  59
]
View formatted query    View runnable query    Explain query
18 0.56 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.id = ?
Parameters: 
[
  2517
]
View formatted query    View runnable query    Explain query
19 0.51 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.id = ?
Parameters: 
[
  2467
]
View formatted query    View runnable query    Explain query
20 0.68 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 INNER JOIN article_has_sous_categorie ON t0.id = article_has_sous_categorie.article_idarticle WHERE article_has_sous_categorie.sous_categorie_id = ?
Parameters: 
[
  62
]
View formatted query    View runnable query    Explain query
21 0.46 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.id = ?
Parameters: 
[
  2520
]
View formatted query    View runnable query    Explain query
22 0.91 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 INNER JOIN article_has_sous_categorie ON t0.id = article_has_sous_categorie.article_idarticle WHERE article_has_sous_categorie.sous_categorie_id = ?
Parameters: 
[
  71
]
View formatted query    View runnable query    Explain query
23 6.38 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.id = ?
Parameters: 
[
  2693
]
View formatted query    View runnable query    Explain query
24 0.65 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.id = ?
Parameters: 
[
  2695
]
View formatted query    View runnable query    Explain query
25 0.60 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.id = ?
Parameters: 
[
  2694
]
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\Article 21
App\Entity\Image 20
App\Entity\SousCategorie 7
App\Entity\Marque 2
App\Entity\Etat 2
App\Entity\Categorie 1
App\Entity\Commande 1

Entities Mapping

Class Mapping 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\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\Image No errors.
App\Entity\Article
  • The mappings App\Entity\Article#etat and App\Entity\Etat#articles are inconsistent with each other.
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\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\Caracteristique No errors.
App\Entity\RubriqueHasArticle No errors.
App\Entity\Caroussels No errors.