Symfony Profiler

Query Metrics

12 Database Queries

4 Different statements

23.95 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

20.64 ms
(86.20%)

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-scanbody"
]

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-scanbody' 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.37 ms
(5.71%)

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 121)
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.24 ms
(5.19%)

SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.reference AS reference_4, p0_.image AS image_5, p0_.hidden AS hidden_6, p1_.id AS id_7, p1_.locale AS locale_8, p1_.name AS name_9, p1_.slug AS slug_10, p1_.description AS description_11, p1_.specifications AS specifications_12, p1_.directions AS directions_13, a2_.id AS id_14, a2_.contact_phone_number AS contact_phone_number_15, a2_.contact_address AS contact_address_16, a2_.billing_email AS billing_email_17, a2_.billing_name AS billing_name_18, a2_.billing_phone_number AS billing_phone_number_19, a2_.billing_address AS billing_address_20, a2_.nif AS nif_21, a2_.updated_at AS updated_at_22, a2_.preferences AS preferences_23, p0_.brand_id AS brand_id_24, p1_.product_id AS product_id_25, a2_.user_id AS user_id_26 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:

[
  "es"
  "family-scanbody"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.price AS price_1,
  p0_.created_at AS created_at_2,
  p0_.updated_at AS updated_at_3,
  p0_.reference AS reference_4,
  p0_.image AS image_5,
  p0_.hidden AS hidden_6,
  p1_.id AS id_7,
  p1_.locale AS locale_8,
  p1_.name AS name_9,
  p1_.slug AS slug_10,
  p1_.description AS description_11,
  p1_.specifications AS specifications_12,
  p1_.directions AS directions_13,
  a2_.id AS id_14,
  a2_.contact_phone_number AS contact_phone_number_15,
  a2_.contact_address AS contact_address_16,
  a2_.billing_email AS billing_email_17,
  a2_.billing_name AS billing_name_18,
  a2_.billing_phone_number AS billing_phone_number_19,
  a2_.billing_address AS billing_address_20,
  a2_.nif AS nif_21,
  a2_.updated_at AS updated_at_22,
  a2_.preferences AS preferences_23,
  p0_.brand_id AS brand_id_24,
  p1_.product_id AS product_id_25,
  a2_.user_id AS user_id_26
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_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.reference AS reference_4, p0_.image AS image_5, p0_.hidden AS hidden_6, p1_.id AS id_7, p1_.locale AS locale_8, p1_.name AS name_9, p1_.slug AS slug_10, p1_.description AS description_11, p1_.specifications AS specifications_12, p1_.directions AS directions_13, a2_.id AS id_14, a2_.contact_phone_number AS contact_phone_number_15, a2_.contact_address AS contact_address_16, a2_.billing_email AS billing_email_17, a2_.billing_name AS billing_name_18, a2_.billing_phone_number AS billing_phone_number_19, a2_.billing_address AS billing_address_20, a2_.nif AS nif_21, a2_.updated_at AS updated_at_22, a2_.preferences AS preferences_23, p0_.brand_id AS brand_id_24, p1_.product_id AS product_id_25, a2_.user_id AS user_id_26 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 = 'es' AND f5_.code = 'family-scanbody' 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)

0.69 ms
(2.89%)

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)

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\FilterType	No errors.
App\Entity\FilterValueTranslation	No errors.

Symfony Profiler

GET https://shop.element-dental.com/es/p?family=family-scanbody

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping