GET https://kondashop.com/ka/produit-mannuels?page=1&sort%5Bavantages%5D=ASC

Response
200 OK
IP
57.141.20.2
Profiled on
Token
637f2f

Query Metrics

9 Database Queries
5 Different statements
14.07 ms Query time
3 Invalid entities
15 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.67 ms 
SELECT DISTINCT p0_.id AS id_0, p0_.avantages AS avantages_1 FROM produit_mannuels p0_ ORDER BY p0_.avantages ASC LIMIT 20
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.73 ms 
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.description AS description_2, p0_.code AS code_3, p0_.dateajout AS dateajout_4, p0_.actif AS actif_5, p0_.taillepoids AS taillepoids_6, p0_.avantages AS avantages_7, p0_.prix AS prix_8, p0_.nbjoursdelai AS nbjoursdelai_9, p0_.souscategorie_id AS souscategorie_id_10 FROM produit_mannuels p0_ WHERE p0_.id IN (?, ?, ?, ?, ?) ORDER BY p0_.avantages ASC
Parameters: 
[
  5
  3
  4
  1
  2
]
View formatted query    View runnable query    Explain query
3 0.76 ms 
SELECT count(p0_.id) AS sclr_0 FROM produit_mannuels p0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.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.id = ?
Parameters: 
[
  69
]
View formatted query    View runnable query    Explain query
5 5.08 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.produit_mannuels_id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
6 1.20 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.produit_mannuels_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
7 1.18 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.produit_mannuels_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
8 1.26 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.produit_mannuels_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
9 1.20 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.produit_mannuels_id = ?
Parameters: 
[
  2
]
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 8
App\Entity\ProduitMannuels 5
App\Entity\SousCategorie 1
App\Entity\Categorie 1

Entities Mapping

Class Mapping errors
App\Entity\ProduitMannuels 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\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\Caroussels No errors.