GET https://www.kondashop.com/sct/TTT/commu

Response
200 OK
IP
216.73.217.176
Profiled on
Token
26a72d

Query Metrics

33 Database Queries
16 Different statements
33.70 ms Query time
5 Invalid entities
138 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.26 ms 
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 WHERE t0.nom_canonique = ? LIMIT 1
Parameters: 
[
  "commu"
]
View formatted query    View runnable query    Explain query
2 1.02 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.nom_canonique = ? LIMIT 1
Parameters: 
[
  "TTT"
]
View formatted query    View runnable query    Explain query
3 0.87 ms 
SELECT  article_idarticle FROM `article_has_sous_categorie` where `sous_categorie_id` = 65
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.87 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.code AS code_4, t0.dateajout AS dateajout_5, t0.actif AS actif_6, t0.taillepoids AS taillepoids_7, t0.avantages AS avantages_8, t0.prix AS prix_9, t0.nbjoursdelai AS nbjoursdelai_10, t0.souscategorie_id AS souscategorie_id_11 FROM produit_mannuels t0 WHERE t0.souscategorie_id = ?
Parameters: 
[
  65
]
View formatted query    View runnable query    Explain query
5 1.56 ms 
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 = ? AND a0_.actif = ? ORDER BY a0_.id ASC
Parameters: 
[
  1023
  1
]
View formatted query    View runnable query    Explain query
6 1.19 ms 
SELECT t0.id AS id_1, t0.evenement AS evenement_2, t0.validite AS validite_3, t0.dateajout AS dateajout_4, t0.datedebut AS datedebut_5, t0.datefin AS datefin_6, t0.explication AS explication_7, t0.urlvideos AS urlvideos_8, t0.image AS image_9 FROM topbannieres t0 WHERE t0.validite = ? ORDER BY t0.dateajout DESC LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
7 0.79 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.active = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
8 2.31 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: 
[
  1708
]
View formatted query    View runnable query    Explain query
9 1.16 ms 
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 WHERE t0.categorie_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
10 1.11 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: 
[
  2497
]
View formatted query    View runnable query    Explain query
11 0.61 ms 
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 WHERE t0.categorie_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
12 0.67 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: 
[
  1706
]
View formatted query    View runnable query    Explain query
13 0.56 ms 
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 WHERE t0.categorie_id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
14 0.48 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: 
[
  2499
]
View formatted query    View runnable query    Explain query
15 0.53 ms 
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 WHERE t0.categorie_id = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
16 0.59 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: 
[
  2501
]
View formatted query    View runnable query    Explain query
17 0.55 ms 
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 WHERE t0.categorie_id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
18 0.54 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: 
[
  2505
]
View formatted query    View runnable query    Explain query
19 0.59 ms 
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 WHERE t0.categorie_id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
20 0.52 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: 
[
  2507
]
View formatted query    View runnable query    Explain query
21 0.55 ms 
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 WHERE t0.categorie_id = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
22 0.49 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.active = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
23 0.98 ms 
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.code AS code_3, t0.description AS description_4, t0.position AS position_5, t0.slideauto AS slideauto_6, t0.pagination AS pagination_7, t0.control AS control_8, t0.valide AS valide_9, t0.intervalle AS intervalle_10, t0.height AS height_11, t0.bottomcontent AS bottomcontent_12, t0.bottomcolor AS bottomcolor_13, t0.bottomtext AS bottomtext_14, t0.bottombg AS bottombg_15, t0.link AS link_16, t0.categorie_id AS categorie_id_17, t0.souscategorie_id AS souscategorie_id_18 FROM hh_caroussels t0 WHERE t0.souscategorie_id = ? LIMIT 1
Parameters: 
[
  65
]
View formatted query    View runnable query    Explain query
24 0.65 ms 
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.code AS code_3, t0.description AS description_4, t0.position AS position_5, t0.slideauto AS slideauto_6, t0.pagination AS pagination_7, t0.control AS control_8, t0.valide AS valide_9, t0.intervalle AS intervalle_10, t0.height AS height_11, t0.bottomcontent AS bottomcontent_12, t0.bottomcolor AS bottomcolor_13, t0.bottomtext AS bottomtext_14, t0.bottombg AS bottombg_15, t0.link AS link_16, t0.categorie_id AS categorie_id_17, t0.souscategorie_id AS souscategorie_id_18 FROM hh_caroussels t0 WHERE t0.valide = ? LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
25 4.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.caroussel_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
26 3.15 ms 
SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.nom_canonique AS nom_canonique_2, m0_.logo AS logo_3, a1_.nom AS nom_4, a1_.nom_canonique AS nom_canonique_5, a1_.montant AS montant_6, a1_.reference AS reference_7, a1_.descriptif AS descriptif_8, a1_.gamme AS gamme_9, a1_.id AS id_10, a1_.vedete AS vedete_11, a1_.bigblue AS bigblue_12, a1_.pourcentage AS pourcentage_13, a1_.nouveaute AS nouveaute_14, a1_.actif AS actif_15, a1_.dateajout AS dateajout_16, a1_.livraison_gratuite AS livraison_gratuite_17, a1_.nombre_etoile AS nombre_etoile_18, m0_.immage AS immage_19, a1_.id_marque AS id_marque_20, a1_.id_etat AS id_etat_21, a1_.commande_id AS commande_id_22 FROM marque m0_ LEFT JOIN article a1_ ON m0_.id = a1_.id_marque LIMIT 4
Parameters: 
[]
View formatted query    View runnable query    Explain query
27 1.13 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.article_idarticle = ?
Parameters: 
[
  1023
]
View formatted query    View runnable query    Explain query
28 1.43 ms 
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
29 0.56 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.active = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
30 1.08 ms 
SELECT t0.id AS id_1, t0.titre AS titre_2 FROM annonces t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
31 0.48 ms 
SELECT t0.id AS id_1, t0.titre AS titre_2 FROM annonces t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
32 0.49 ms 
SELECT t0.id AS id_1, t0.titre AS titre_2 FROM annonces t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
33 0.44 ms 
SELECT t0.id AS id_1, t0.titre AS titre_2 FROM annonces t0
Parameters: 
[]
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 91
App\Entity\SousCategorie 27
App\Entity\Categorie 7
App\Entity\Article 5
App\Entity\Annonces 3
App\Entity\Etat 2
App\Entity\Topbannieres 1
App\Entity\Caroussels 1
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\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\Topbannieres No errors.
App\Entity\Caroussels No errors.
App\Entity\Annonces No errors.