Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.53 ms Query time

2 Invalid entities

20 Managed entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.65 ms (36.43%)	1	SELECT i0_.nom AS nom_0, i0_.type AS type_1, i0_.path AS path_2, i0_.id AS id_3, i0_.image AS image_4, i0_.caroussel_id AS caroussel_id_5, i0_.article_idarticle AS article_idarticle_6, i0_.id_categorie AS id_categorie_7, i0_.produit_mannuels_id AS produit_mannuels_id_8 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id WHERE i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i0_.article_idarticle ASC Parameters: [`565 571 572 573 574 575 576 577 578 622 623 650 651 652 653 654 657 658 660 661`] View formatted query View runnable query Explain query SELECT i0_.nom AS nom_0, i0_.type AS type_1, i0_.path AS path_2, i0_.id AS id_3, i0_.image AS image_4, i0_.caroussel_id AS caroussel_id_5, i0_.article_idarticle AS article_idarticle_6, i0_.id_categorie AS id_categorie_7, i0_.produit_mannuels_id AS produit_mannuels_id_8 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id WHERE i0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY i0_.article_idarticle ASC SELECT i0_.nom AS nom_0, i0_.type AS type_1, i0_.path AS path_2, i0_.id AS id_3, i0_.image AS image_4, i0_.caroussel_id AS caroussel_id_5, i0_.article_idarticle AS article_idarticle_6, i0_.id_categorie AS id_categorie_7, i0_.produit_mannuels_id AS produit_mannuels_id_8 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id WHERE i0_.id IN (565, 571, 572, 573, 574, 575, 576, 577, 578, 622, 623, 650, 651, 652, 653, 654, 657, 658, 660, 661) ORDER BY i0_.article_idarticle ASC;
1.45 ms (32.04%)	1	SELECT DISTINCT i0_.id AS id_0, i0_.article_idarticle AS sclr_1 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id ORDER BY i0_.article_idarticle ASC LIMIT 20 OFFSET 60 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT i0_.id AS id_0, i0_.article_idarticle AS sclr_1 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id ORDER BY i0_.article_idarticle ASC LIMIT 20 OFFSET 60 SELECT DISTINCT i0_.id AS id_0, i0_.article_idarticle AS sclr_1 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id ORDER BY i0_.article_idarticle ASC LIMIT 20 OFFSET 60;
1.43 ms (31.53%)	1	SELECT count(DISTINCT i0_.id) AS sclr_0 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id Parameters: [] View formatted query View runnable query Explain query SELECT count(DISTINCT i0_.id) AS sclr_0 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id SELECT count(DISTINCT i0_.id) AS sclr_0 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id;

Time▼

Count

Info

1.65 ms
(36.43%)

SELECT i0_.nom AS nom_0, i0_.type AS type_1, i0_.path AS path_2, i0_.id AS id_3, i0_.image AS image_4, i0_.caroussel_id AS caroussel_id_5, i0_.article_idarticle AS article_idarticle_6, i0_.id_categorie AS id_categorie_7, i0_.produit_mannuels_id AS produit_mannuels_id_8 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id WHERE i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i0_.article_idarticle ASC

Parameters:

View formatted query View runnable query Explain query

SELECT
  i0_.nom AS nom_0,
  i0_.type AS type_1,
  i0_.path AS path_2,
  i0_.id AS id_3,
  i0_.image AS image_4,
  i0_.caroussel_id AS caroussel_id_5,
  i0_.article_idarticle AS article_idarticle_6,
  i0_.id_categorie AS id_categorie_7,
  i0_.produit_mannuels_id AS produit_mannuels_id_8
FROM
  image i0_
  LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id
WHERE
  i0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  i0_.article_idarticle ASC

SELECT i0_.nom AS nom_0, i0_.type AS type_1, i0_.path AS path_2, i0_.id AS id_3, i0_.image AS image_4, i0_.caroussel_id AS caroussel_id_5, i0_.article_idarticle AS article_idarticle_6, i0_.id_categorie AS id_categorie_7, i0_.produit_mannuels_id AS produit_mannuels_id_8 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id WHERE i0_.id IN (565, 571, 572, 573, 574, 575, 576, 577, 578, 622, 623, 650, 651, 652, 653, 654, 657, 658, 660, 661) ORDER BY i0_.article_idarticle ASC;

1.45 ms
(32.04%)

SELECT DISTINCT i0_.id AS id_0, i0_.article_idarticle AS sclr_1 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id ORDER BY i0_.article_idarticle ASC LIMIT 20 OFFSET 60

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT i0_.id AS id_0,
  i0_.article_idarticle AS sclr_1
FROM
  image i0_
  LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id
ORDER BY
  i0_.article_idarticle ASC
LIMIT
  20
OFFSET
  60

SELECT DISTINCT i0_.id AS id_0, i0_.article_idarticle AS sclr_1 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id ORDER BY i0_.article_idarticle ASC LIMIT 20 OFFSET 60;

1.43 ms
(31.53%)

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(DISTINCT i0_.id) AS sclr_0
FROM
  image i0_
  LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM image i0_ LEFT JOIN article a1_ ON i0_.article_idarticle = a1_.id;

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	20

Entities Mapping

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

Symfony Profiler

GET https://kondashop.com/ka/image?page=4&sort%5Barticle%5D=ASC

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping