GET https://kondashop.com/ka/categorie/3

Response
200 OK
IP
216.73.216.115
Profiled on
Token
ba4375

Query Metrics

9 Database Queries
4 Different statements
29.22 ms Query time
4 Invalid entities
29 Managed entities

Queries

Group similar statements

#▲ Time Info
1 4.32 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
2 5.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: 
[
  2495
]
View formatted query    View runnable query    Explain query
3 4.23 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
4 7.99 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
5 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: 
[
  2490
]
View formatted query    View runnable query    Explain query
6 1.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: 
[
  1585
]
View formatted query    View runnable query    Explain query
7 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: 
[
  1662
]
View formatted query    View runnable query    Explain query
8 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: 
[
  1672
]
View formatted query    View runnable query    Explain query
9 3.74 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_categorie = ?
Parameters: 
[
  3
]
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 21
App\Entity\SousCategorie 7
App\Entity\Categorie 1

Entities Mapping

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