Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

38.23 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
34.45 ms (90.13%)	1	SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_comment p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id LEFT JOIN product_test p4_ ON p0_.id = p4_.product_id LEFT JOIN brand b5_ ON p0_.brand_id = b5_.id LEFT JOIN category c6_ ON p0_.category_id = c6_.id LEFT JOIN currency c7_ ON p0_.currency_id = c7_.id ORDER BY p0_.id ASC LIMIT 60 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_comment p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id LEFT JOIN product_test p4_ ON p0_.id = p4_.product_id LEFT JOIN brand b5_ ON p0_.brand_id = b5_.id LEFT JOIN category c6_ ON p0_.category_id = c6_.id LEFT JOIN currency c7_ ON p0_.currency_id = c7_.id ORDER BY p0_.id ASC LIMIT 60 SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_comment p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id LEFT JOIN product_test p4_ ON p0_.id = p4_.product_id LEFT JOIN brand b5_ ON p0_.brand_id = b5_.id LEFT JOIN category c6_ ON p0_.category_id = c6_.id LEFT JOIN currency c7_ ON p0_.currency_id = c7_.id ORDER BY p0_.id ASC LIMIT 60;
3.77 ms (9.87%)	1	SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_comment p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id LEFT JOIN product_test p4_ ON p0_.id = p4_.product_id LEFT JOIN brand b5_ ON p0_.brand_id = b5_.id LEFT JOIN category c6_ ON p0_.category_id = c6_.id LEFT JOIN currency c7_ ON p0_.currency_id = c7_.id Parameters: [] View formatted query View runnable query Explain query SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_comment p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id LEFT JOIN product_test p4_ ON p0_.id = p4_.product_id LEFT JOIN brand b5_ ON p0_.brand_id = b5_.id LEFT JOIN category c6_ ON p0_.category_id = c6_.id LEFT JOIN currency c7_ ON p0_.currency_id = c7_.id SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_comment p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id LEFT JOIN product_test p4_ ON p0_.id = p4_.product_id LEFT JOIN brand b5_ ON p0_.brand_id = b5_.id LEFT JOIN category c6_ ON p0_.category_id = c6_.id LEFT JOIN currency c7_ ON p0_.currency_id = c7_.id;

Time▼

Count

Info

34.45 ms
(90.13%)

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_comment p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id LEFT JOIN product_test p4_ ON p0_.id = p4_.product_id LEFT JOIN brand b5_ ON p0_.brand_id = b5_.id LEFT JOIN category c6_ ON p0_.category_id = c6_.id LEFT JOIN currency c7_ ON p0_.currency_id = c7_.id ORDER BY p0_.id ASC LIMIT 60

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.id AS id_1
FROM
  product p0_
  LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id
  LEFT JOIN product_comment p2_ ON p0_.id = p2_.product_id
  LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id
  LEFT JOIN product_test p4_ ON p0_.id = p4_.product_id
  LEFT JOIN brand b5_ ON p0_.brand_id = b5_.id
  LEFT JOIN category c6_ ON p0_.category_id = c6_.id
  LEFT JOIN currency c7_ ON p0_.currency_id = c7_.id
ORDER BY
  p0_.id ASC
LIMIT
  60

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_comment p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id LEFT JOIN product_test p4_ ON p0_.id = p4_.product_id LEFT JOIN brand b5_ ON p0_.brand_id = b5_.id LEFT JOIN category c6_ ON p0_.category_id = c6_.id LEFT JOIN currency c7_ ON p0_.currency_id = c7_.id ORDER BY p0_.id ASC LIMIT 60;

3.77 ms
(9.87%)

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_comment p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id LEFT JOIN product_test p4_ ON p0_.id = p4_.product_id LEFT JOIN brand b5_ ON p0_.brand_id = b5_.id LEFT JOIN category c6_ ON p0_.category_id = c6_.id LEFT JOIN currency c7_ ON p0_.currency_id = c7_.id

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id
  LEFT JOIN product_comment p2_ ON p0_.id = p2_.product_id
  LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id
  LEFT JOIN product_test p4_ ON p0_.id = p4_.product_id
  LEFT JOIN brand b5_ ON p0_.brand_id = b5_.id
  LEFT JOIN category c6_ ON p0_.category_id = c6_.id
  LEFT JOIN currency c7_ ON p0_.currency_id = c7_.id

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_comment p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id LEFT JOIN product_test p4_ ON p0_.id = p4_.product_id LEFT JOIN brand b5_ ON p0_.brand_id = b5_.id LEFT JOIN category c6_ ON p0_.category_id = c6_.id LEFT JOIN currency c7_ ON p0_.currency_id = c7_.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.

Entities Mapping

Class	Mapping errors
App\Entity\Product	No errors.
App\Entity\Brand	No errors.
App\Entity\ProductAttribute	No errors.
App\Entity\ProductComment	No errors.
App\Entity\ProductImage	No errors.
App\Entity\ProductTest	No errors.
App\Entity\Category	No errors.
App\Entity\Currency	No errors.

Symfony Profiler

https://api.guidefacile.com/products.jsonld?itemsPerPage=60&page=1

Configuration Settings

Theme