Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.50 ms Query time

2 Invalid entities

20 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	1.74 ms	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 100 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 100 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 100;
2	1.98 ms	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: [`683 685 688 689 690 704 705 738 748 749 750 767 772 773 774 775 776 777 779 780`] 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 (683, 685, 688, 689, 690, 704, 705, 738, 748, 749, 750, 767, 772, 773, 774, 775, 776, 777, 779, 780) ORDER BY i0_.article_idarticle ASC;
3	0.78 ms	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

Info

1.74 ms

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 100

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
  100

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 100;

1.98 ms

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 (683, 685, 688, 689, 690, 704, 705, 738, 748, 749, 750, 767, 772, 773, 774, 775, 776, 777, 779, 780) ORDER BY i0_.article_idarticle ASC;

0.78 ms

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=6&sort%5Barticle%5D=ASC

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping