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

Response
200 OK
IP
216.73.217.110
Profiled on
Token
8296dd

Query Metrics

29 Database Queries
6 Different statements
16.60 ms Query time
5 Invalid entities
65 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.98 ms 
SELECT DISTINCT s0_.id AS id_0, s0_.image AS sclr_1 FROM sous_categorie s0_ LEFT JOIN image i1_ ON s0_.image = i1_.id ORDER BY s0_.image ASC LIMIT 20 OFFSET 20
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.83 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 image i1_ ON s0_.image = i1_.id WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.image ASC
Parameters: 
[
  64
  66
  67
  65
  69
  70
  71
]
View formatted query    View runnable query    Explain query
3 0.44 ms 
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sous_categorie s0_ LEFT JOIN image i1_ ON s0_.image = i1_.id
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.81 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: 
[
  9
]
View formatted query    View runnable query    Explain query
5 1.84 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: 
[
  64
]
View formatted query    View runnable query    Explain query
6 1.47 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: 
[
  2531
]
View formatted query    View runnable query    Explain query
7 0.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: 
[
  2528
]
View formatted query    View runnable query    Explain query
8 0.43 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: 
[
  4
]
View formatted query    View runnable query    Explain query
9 0.54 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: 
[
  66
]
View formatted query    View runnable query    Explain query
10 0.37 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: 
[
  2532
]
View formatted query    View runnable query    Explain query
11 0.35 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: 
[
  2533
]
View formatted query    View runnable query    Explain query
12 0.58 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: 
[
  67
]
View formatted query    View runnable query    Explain query
13 0.37 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: 
[
  2534
]
View formatted query    View runnable query    Explain query
14 0.35 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: 
[
  2535
]
View formatted query    View runnable query    Explain query
15 0.41 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: 
[
  10
]
View formatted query    View runnable query    Explain query
16 0.47 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: 
[
  65
]
View formatted query    View runnable query    Explain query
17 0.36 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: 
[
  2536
]
View formatted query    View runnable query    Explain query
18 0.36 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: 
[
  2537
]
View formatted query    View runnable query    Explain query
19 0.52 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: 
[
  69
]
View formatted query    View runnable query    Explain query
20 0.94 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: 
[
  2680
]
View formatted query    View runnable query    Explain query
21 0.36 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: 
[
  2681
]
View formatted query    View runnable query    Explain query
22 0.53 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: 
[
  70
]
View formatted query    View runnable query    Explain query
23 0.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: 
[
  2688
]
View formatted query    View runnable query    Explain query
24 0.37 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: 
[
  2687
]
View formatted query    View runnable query    Explain query
25 0.40 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
26 0.45 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
27 0.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
28 0.53 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
29 0.40 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\Image 32
App\Entity\Article 18
App\Entity\SousCategorie 7
App\Entity\Categorie 4
App\Entity\Etat 3
App\Entity\Marque 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\Image 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\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.