Symfony Profiler

Query Metrics

8 Database Queries

5 Different statements

13.72 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.73 ms
(56.36%)

SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.iva AS iva_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.reference AS reference_5, p0_.image AS image_6, p0_.hidden AS hidden_7, p1_.id AS id_8, p1_.locale AS locale_9, p1_.name AS name_10, p1_.slug AS slug_11, p1_.description AS description_12, p1_.specifications AS specifications_13, p1_.directions AS directions_14, a2_.id AS id_15, a2_.contact_phone_number AS contact_phone_number_16, a2_.contact_address AS contact_address_17, a2_.billing_email AS billing_email_18, a2_.billing_name AS billing_name_19, a2_.billing_phone_number AS billing_phone_number_20, a2_.billing_address AS billing_address_21, a2_.nif AS nif_22, a2_.updated_at AS updated_at_23, a2_.preferences AS preferences_24, p0_.brand_id AS brand_id_25, p1_.product_id AS product_id_26, a2_.user_id AS user_id_27 FROM products p0_ INNER JOIN brands b3_ ON p0_.brand_id = b3_.id INNER JOIN products_translations p1_ ON p0_.id = p1_.product_id LEFT JOIN favorite_products f4_ ON p0_.id = f4_.product_id LEFT JOIN accounts a2_ ON a2_.id = f4_.account_id INNER JOIN filter_value_product f6_ ON p0_.id = f6_.product_id INNER JOIN filter_values f5_ ON f5_.id = f6_.value_id WHERE p1_.locale = ? AND f5_.code = ? AND p0_.hidden = 0 ORDER BY b3_.display_order ASC, p1_.name ASC

Parameters:

[
  "en"
  "family-pilar-provisional"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.price AS price_1,
  p0_.iva AS iva_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.reference AS reference_5,
  p0_.image AS image_6,
  p0_.hidden AS hidden_7,
  p1_.id AS id_8,
  p1_.locale AS locale_9,
  p1_.name AS name_10,
  p1_.slug AS slug_11,
  p1_.description AS description_12,
  p1_.specifications AS specifications_13,
  p1_.directions AS directions_14,
  a2_.id AS id_15,
  a2_.contact_phone_number AS contact_phone_number_16,
  a2_.contact_address AS contact_address_17,
  a2_.billing_email AS billing_email_18,
  a2_.billing_name AS billing_name_19,
  a2_.billing_phone_number AS billing_phone_number_20,
  a2_.billing_address AS billing_address_21,
  a2_.nif AS nif_22,
  a2_.updated_at AS updated_at_23,
  a2_.preferences AS preferences_24,
  p0_.brand_id AS brand_id_25,
  p1_.product_id AS product_id_26,
  a2_.user_id AS user_id_27
FROM
  products p0_
  INNER JOIN brands b3_ ON p0_.brand_id = b3_.id
  INNER JOIN products_translations p1_ ON p0_.id = p1_.product_id
  LEFT JOIN favorite_products f4_ ON p0_.id = f4_.product_id
  LEFT JOIN accounts a2_ ON a2_.id = f4_.account_id
  INNER JOIN filter_value_product f6_ ON p0_.id = f6_.product_id
  INNER JOIN filter_values f5_ ON f5_.id = f6_.value_id
WHERE
  p1_.locale = ?
  AND f5_.code = ?
  AND p0_.hidden = 0
ORDER BY
  b3_.display_order ASC,
  p1_.name ASC

SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.iva AS iva_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.reference AS reference_5, p0_.image AS image_6, p0_.hidden AS hidden_7, p1_.id AS id_8, p1_.locale AS locale_9, p1_.name AS name_10, p1_.slug AS slug_11, p1_.description AS description_12, p1_.specifications AS specifications_13, p1_.directions AS directions_14, a2_.id AS id_15, a2_.contact_phone_number AS contact_phone_number_16, a2_.contact_address AS contact_address_17, a2_.billing_email AS billing_email_18, a2_.billing_name AS billing_name_19, a2_.billing_phone_number AS billing_phone_number_20, a2_.billing_address AS billing_address_21, a2_.nif AS nif_22, a2_.updated_at AS updated_at_23, a2_.preferences AS preferences_24, p0_.brand_id AS brand_id_25, p1_.product_id AS product_id_26, a2_.user_id AS user_id_27 FROM products p0_ INNER JOIN brands b3_ ON p0_.brand_id = b3_.id INNER JOIN products_translations p1_ ON p0_.id = p1_.product_id LEFT JOIN favorite_products f4_ ON p0_.id = f4_.product_id LEFT JOIN accounts a2_ ON a2_.id = f4_.account_id INNER JOIN filter_value_product f6_ ON p0_.id = f6_.product_id INNER JOIN filter_values f5_ ON f5_.id = f6_.value_id WHERE p1_.locale = 'en' AND f5_.code = 'family-pilar-provisional' AND p0_.hidden = 0 ORDER BY b3_.display_order ASC, p1_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 103)
7	App\Repository\ProductRepository->getAll (line 19)
8	App\Service\PublicArea\Product\ProductIndexService->__invoke (line 58)
9	App\Controller\PublicArea\Products\ProductsController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

2.00 ms
(14.57%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = ?

Parameters:

[
  b"\x01˜>jâÝtà»Í\t¥.Œ6Ï"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.display_order AS display_order_5
FROM
  brands t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = 0x01983E6AE2DD74E0BBCD09A52E8C36CF;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Brand::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Brand->__get (line 72)
8	App\Entity\Brand->getSlug (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 70)
10	__TwigTemplate_546ccece975d032e05bf35c1e247610f->doDisplay (line 388)
11	Twig\Template->yield (line 71)
12	__TwigTemplate_2d32df96bb5413a582a3592c0b87d682->doDisplay (line 388)
13	Twig\Template->yield (line 251)
14	__TwigTemplate_ef32d45b6d407a47a402fb600a47f1ac->block_content (line 432)
15	Twig\Template->yieldBlock (line 136)
16	__TwigTemplate_bfc29421ee5aee2840f77ae144074239->doDisplay (line 388)
17	Twig\Template->yield (line 58)
18	__TwigTemplate_ef32d45b6d407a47a402fb600a47f1ac->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 65)
27	App\Controller\PublicArea\Products\ProductsController->index (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

1.43 ms
(10.41%)

SELECT f0_.id AS id_0 FROM filter_values f0_ INNER JOIN filter_types f1_ ON f0_.type_id = f1_.id INNER JOIN filter_value_product f3_ ON f0_.id = f3_.value_id INNER JOIN products p2_ ON p2_.id = f3_.product_id AND (p2_.hidden = 0) WHERE EXISTS (SELECT 1 AS sclr_1 FROM products p4_ INNER JOIN filter_value_product f6_ ON p4_.id = f6_.product_id INNER JOIN filter_values f5_ ON f5_.id = f6_.value_id WHERE f5_.code = ? AND p4_.id = p2_.id)

Parameters:

[
  "family-pilar-provisional"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0
FROM
  filter_values f0_
  INNER JOIN filter_types f1_ ON f0_.type_id = f1_.id
  INNER JOIN filter_value_product f3_ ON f0_.id = f3_.value_id
  INNER JOIN products p2_ ON p2_.id = f3_.product_id
  AND (p2_.hidden = 0)
WHERE
  EXISTS (
    SELECT
      1 AS sclr_1
    FROM
      products p4_
      INNER JOIN filter_value_product f6_ ON p4_.id = f6_.product_id
      INNER JOIN filter_values f5_ ON f5_.id = f6_.value_id
    WHERE
      f5_.code = ?
      AND p4_.id = p2_.id
  )

SELECT f0_.id AS id_0 FROM filter_values f0_ INNER JOIN filter_types f1_ ON f0_.type_id = f1_.id INNER JOIN filter_value_product f3_ ON f0_.id = f3_.value_id INNER JOIN products p2_ ON p2_.id = f3_.product_id AND (p2_.hidden = 0) WHERE EXISTS (SELECT 1 AS sclr_1 FROM products p4_ INNER JOIN filter_value_product f6_ ON p4_.id = f6_.product_id INNER JOIN filter_values f5_ ON f5_.id = f6_.value_id WHERE f5_.code = 'family-pilar-provisional' AND p4_.id = p2_.id);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 67)
7	App\Repository\FilterValueRepository->getAvailableFilterValues (line 17)
8	App\Service\PublicArea\Filter\FilterValueIndexService->__invoke (line 59)
9	App\Controller\PublicArea\Products\ProductsController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.34 ms
(9.80%)

SELECT f0_.id AS id_0, f1_.code AS code_1, f0_.code AS code_2, f2_.locale AS locale_3, f2_.name AS name_4 FROM filter_values f0_ INNER JOIN filter_types f1_ ON f0_.type_id = f1_.id LEFT JOIN filter_value_translations f2_ ON f0_.id = f2_.value_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f1_.code AS code_1,
  f0_.code AS code_2,
  f2_.locale AS locale_3,
  f2_.name AS name_4
FROM
  filter_values f0_
  INNER JOIN filter_types f1_ ON f0_.type_id = f1_.id
  LEFT JOIN filter_value_translations f2_ ON f0_.id = f2_.value_id

SELECT f0_.id AS id_0, f1_.code AS code_1, f0_.code AS code_2, f2_.locale AS locale_3, f2_.name AS name_4 FROM filter_values f0_ INNER JOIN filter_types f1_ ON f0_.type_id = f1_.id LEFT JOIN filter_value_translations f2_ ON f0_.id = f2_.value_id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 28)
7	App\Repository\FilterValueRepository->getAllFilterValues (line 16)
8	App\Service\PublicArea\Filter\FilterValueIndexService->__invoke (line 59)
9	App\Controller\PublicArea\Products\ProductsController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.21 ms
(8.85%)

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.locale AS locale_3, t0.account_id AS account_id_4 FROM carts t0 WHERE t0.account_id = ?

Parameters:

[
  b"\x01–«{\x00ýp)„Ÿ’zûIi&"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.locale AS locale_3,
  t0.account_id AS account_id_4
FROM
  carts t0
WHERE
  t0.account_id = ?

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.locale AS locale_3, t0.account_id AS account_id_4 FROM carts t0 WHERE t0.account_id = 0x0196AB7B00FD7029849F927AFB496926;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 403)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 103)
12	App\Repository\ProductRepository->getAll (line 19)
13	App\Service\PublicArea\Product\ProductIndexService->__invoke (line 58)
14	App\Controller\PublicArea\Products\ProductsController->index (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

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\ProductTranslation	No errors.
App\Entity\Account	No errors.
App\Entity\FilterValue	No errors.
App\Entity\User	No errors.
App\Entity\Category	No errors.
App\Entity\OrderItem	No errors.
App\Entity\ShippingAddress	No errors.
App\Entity\Cart	No errors.
App\Entity\CartItem	No errors.
App\Entity\Order	No errors.
App\Entity\FilterType	No errors.
App\Entity\FilterValueTranslation	No errors.

Symfony Profiler

GET https://shop.element-dental.com/en/p?family=family-pilar-provisional

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping