Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

5.60 ms Query time

1 Invalid entities

28 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.14 ms
(56.07%)

SELECT DISTINCT id_2, MIN(sclr_4) AS dctrn_minrownum FROM (SELECT p0_.name AS name_0, p0_.updated_at AS updated_at_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3, ROW_NUMBER() OVER(ORDER BY p0_.name ASC) AS sclr_4 FROM product_types p0_ WHERE (p0_.deleted_at IS NULL)) dctrn_result GROUP BY id_2 ORDER BY dctrn_minrownum ASC LIMIT 25

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_2,
  MIN(sclr_4) AS dctrn_minrownum
FROM
  (
    SELECT
      p0_.name AS name_0,
      p0_.updated_at AS updated_at_1,
      p0_.id AS id_2,
      p0_.deleted_at AS deleted_at_3,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.name ASC
      ) AS sclr_4
    FROM
      product_types p0_
    WHERE
      (p0_.deleted_at IS NULL)
  ) dctrn_result
GROUP BY
  id_2
ORDER BY
  dctrn_minrownum ASC
LIMIT
  25

SELECT DISTINCT id_2, MIN(sclr_4) AS dctrn_minrownum FROM (SELECT p0_.name AS name_0, p0_.updated_at AS updated_at_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3, ROW_NUMBER() OVER(ORDER BY p0_.name ASC) AS sclr_4 FROM product_types p0_ WHERE (p0_.deleted_at IS NULL)) dctrn_result GROUP BY id_2 ORDER BY dctrn_minrownum ASC LIMIT 25;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 135)
8	App\Infrastructure\EntityTable\Component\EntityTableComponent->getTableData (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 424)
10	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_main_table__in (line 446)
11	Twig\Template->yieldBlock (line 377)
12	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_main_table__out (line 446)
13	Twig\Template->yieldBlock (line 348)
14	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card_body__in (line 446)
15	Twig\Template->yieldBlock (line 320)
16	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card_body__out (line 446)
17	Twig\Template->yieldBlock (line 135)
18	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card__in (line 446)
19	Twig\Template->yieldBlock (line 100)
20	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card__out (line 446)
21	Twig\Template->yieldBlock (line 70)
22	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->doDisplay (line 402)
23	Twig\Template->yield (line 358)
24	Twig\Template->display (line 373)
25	Twig\Template->render (line 77)
26	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
27	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
28	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 118)
29	__TwigTemplate_35389c749ce176c88ca2838bf0697a2a->block_body (line 446)
30	Twig\Template->yieldBlock (line 136)
31	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
32	Twig\Template->yield (line 54)
33	__TwigTemplate_35389c749ce176c88ca2838bf0697a2a->doDisplay (line 402)
34	Twig\Template->yield (line 358)
35	Twig\Template->display (line 373)
36	Twig\Template->render (line 51)
37	Twig\TemplateWrapper->render (line 333)
38	Twig\Environment->render (line 459)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 17)
42	App\ProductType\Controller\ProductTypesController->__invoke (line 183)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
45	Symfony\Component\HttpKernel\Kernel->handle (line 35)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
47	require_once (line 5)

1.21 ms
(21.58%)

SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4 FROM product_types_groups t0 WHERE t0.id = ?

Parameters:

[
  "3f1a9f7a-d3c5-11ed-afa1-0242ac121111"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.updated_at AS updated_at_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4
FROM
  product_types_groups t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4 FROM product_types_groups t0 WHERE t0.id = '3f1a9f7a-d3c5-11ed-afa1-0242ac121111';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 270)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 348)
5	Proxies\__CG__\App\ProductType\Entity\ProductTypeGroup::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\ProductType\Entity\ProductTypeGroup->__get (line 47)
8	App\ProductType\Entity\ProductTypeGroup->getName (line 74)
9	App\ProductType\Entity\ProductType->getGroupName (line 406)
10	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
11	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 161)
12	App\Infrastructure\EntityTable\Component\EntityTableComponent->getPropertyValue (line 1909)
13	Twig\Extension\CoreExtension::getAttribute (line 463)
14	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_main_table__in (line 446)
15	Twig\Template->yieldBlock (line 377)
16	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_main_table__out (line 446)
17	Twig\Template->yieldBlock (line 348)
18	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card_body__in (line 446)
19	Twig\Template->yieldBlock (line 320)
20	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card_body__out (line 446)
21	Twig\Template->yieldBlock (line 135)
22	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card__in (line 446)
23	Twig\Template->yieldBlock (line 100)
24	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card__out (line 446)
25	Twig\Template->yieldBlock (line 70)
26	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->doDisplay (line 402)
27	Twig\Template->yield (line 358)
28	Twig\Template->display (line 373)
29	Twig\Template->render (line 77)
30	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
31	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
32	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 118)
33	__TwigTemplate_35389c749ce176c88ca2838bf0697a2a->block_body (line 446)
34	Twig\Template->yieldBlock (line 136)
35	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
36	Twig\Template->yield (line 54)
37	__TwigTemplate_35389c749ce176c88ca2838bf0697a2a->doDisplay (line 402)
38	Twig\Template->yield (line 358)
39	Twig\Template->display (line 373)
40	Twig\Template->render (line 51)
41	Twig\TemplateWrapper->render (line 333)
42	Twig\Environment->render (line 459)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 17)
46	App\ProductType\Controller\ProductTypesController->__invoke (line 183)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
49	Symfony\Component\HttpKernel\Kernel->handle (line 35)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
51	require_once (line 5)

0.71 ms
(12.67%)

SELECT p0_.name AS name_0, p0_.updated_at AS updated_at_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3, p0_.group_id AS group_id_4 FROM product_types p0_ WHERE (p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (p0_.deleted_at IS NULL) ORDER BY p0_.name ASC

Parameters:

[
  "3ec6152e-93c6-4a70-96b8-6ab63f441038"
  "516dd451-6fc6-4ee2-a6c8-970c91800fbf"
  "4f372085-6657-4132-af0e-c4429c795082"
  "0d71cc78-4dce-4d0d-b10c-b16f79012636"
  "67a94c97-3d70-4152-b733-e2c8c0c6d4c3"
  "7a51bf9a-0c14-4a1b-887a-004f05bdc6cc"
  "0e2ae5f3-16f3-4c88-bf65-65515b7e548c"
  "4535d408-8916-4df0-9492-579187270dec"
  "3fd1ea18-ca8f-446c-a03c-eaff53b2bf41"
  "e33a2a57-881a-4a60-977f-ea258866ab3c"
  "98fc1641-cfb4-4f51-ab4d-c4f935cdc8a5"
  "faf89876-b51e-49e7-8d5b-8e7bd9a4aa0f"
  "4bb38e81-6256-479f-bd98-98bf84f29bdc"
  "81565c4d-7f7f-420c-a349-bc15b0a03e7f"
  "d18613d7-91a4-4964-ad28-025588e7b641"
  "4790ad35-7967-4450-9363-282bf5a62061"
  "3bb3eef3-fd8d-4476-9ca0-07322a5540ac"
  "bd842838-304c-4635-bca0-82ba7f3f4ed8"
  "9f7c266e-8b5c-4ffc-bbb2-8a406f568795"
  "99df9af3-9e9e-4311-ac0d-88de5d58cffa"
  "64dcdd44-f71e-4eb0-bd1b-35186c411666"
  "583b5e56-4d69-496d-a4a1-fa095d5d91d2"
  "2c6dce3f-8ccf-4f53-af54-2708ccee6673"
  "f7aff91a-5f9e-41a8-8ce2-0f033aedaeff"
  "bf2423a0-fa88-409f-b40d-854e70dc182e"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.name AS name_0,
  p0_.updated_at AS updated_at_1,
  p0_.id AS id_2,
  p0_.deleted_at AS deleted_at_3,
  p0_.group_id AS group_id_4
FROM
  product_types p0_
WHERE
  (
    p0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.name ASC

SELECT p0_.name AS name_0, p0_.updated_at AS updated_at_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3, p0_.group_id AS group_id_4 FROM product_types p0_ WHERE (p0_.id IN ('3ec6152e-93c6-4a70-96b8-6ab63f441038', '516dd451-6fc6-4ee2-a6c8-970c91800fbf', '4f372085-6657-4132-af0e-c4429c795082', '0d71cc78-4dce-4d0d-b10c-b16f79012636', '67a94c97-3d70-4152-b733-e2c8c0c6d4c3', '7a51bf9a-0c14-4a1b-887a-004f05bdc6cc', '0e2ae5f3-16f3-4c88-bf65-65515b7e548c', '4535d408-8916-4df0-9492-579187270dec', '3fd1ea18-ca8f-446c-a03c-eaff53b2bf41', 'e33a2a57-881a-4a60-977f-ea258866ab3c', '98fc1641-cfb4-4f51-ab4d-c4f935cdc8a5', 'faf89876-b51e-49e7-8d5b-8e7bd9a4aa0f', '4bb38e81-6256-479f-bd98-98bf84f29bdc', '81565c4d-7f7f-420c-a349-bc15b0a03e7f', 'd18613d7-91a4-4964-ad28-025588e7b641', '4790ad35-7967-4450-9363-282bf5a62061', '3bb3eef3-fd8d-4476-9ca0-07322a5540ac', 'bd842838-304c-4635-bca0-82ba7f3f4ed8', '9f7c266e-8b5c-4ffc-bbb2-8a406f568795', '99df9af3-9e9e-4311-ac0d-88de5d58cffa', '64dcdd44-f71e-4eb0-bd1b-35186c411666', '583b5e56-4d69-496d-a4a1-fa095d5d91d2', '2c6dce3f-8ccf-4f53-af54-2708ccee6673', 'f7aff91a-5f9e-41a8-8ce2-0f033aedaeff', 'bf2423a0-fa88-409f-b40d-854e70dc182e')) AND (p0_.deleted_at IS NULL) ORDER BY p0_.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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 135)
8	App\Infrastructure\EntityTable\Component\EntityTableComponent->getTableData (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 424)
10	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_main_table__in (line 446)
11	Twig\Template->yieldBlock (line 377)
12	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_main_table__out (line 446)
13	Twig\Template->yieldBlock (line 348)
14	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card_body__in (line 446)
15	Twig\Template->yieldBlock (line 320)
16	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card_body__out (line 446)
17	Twig\Template->yieldBlock (line 135)
18	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card__in (line 446)
19	Twig\Template->yieldBlock (line 100)
20	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card__out (line 446)
21	Twig\Template->yieldBlock (line 70)
22	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->doDisplay (line 402)
23	Twig\Template->yield (line 358)
24	Twig\Template->display (line 373)
25	Twig\Template->render (line 77)
26	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
27	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
28	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 118)
29	__TwigTemplate_35389c749ce176c88ca2838bf0697a2a->block_body (line 446)
30	Twig\Template->yieldBlock (line 136)
31	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
32	Twig\Template->yield (line 54)
33	__TwigTemplate_35389c749ce176c88ca2838bf0697a2a->doDisplay (line 402)
34	Twig\Template->yield (line 358)
35	Twig\Template->display (line 373)
36	Twig\Template->render (line 51)
37	Twig\TemplateWrapper->render (line 333)
38	Twig\Environment->render (line 459)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 17)
42	App\ProductType\Controller\ProductTypesController->__invoke (line 183)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
45	Symfony\Component\HttpKernel\Kernel->handle (line 35)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
47	require_once (line 5)

0.54 ms
(9.68%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_2 FROM (SELECT p0_.name AS name_0, p0_.updated_at AS updated_at_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3 FROM product_types p0_ WHERE (p0_.deleted_at IS NULL) ORDER BY p0_.name ASC) dctrn_result) dctrn_table

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_2
    FROM
      (
        SELECT
          p0_.name AS name_0,
          p0_.updated_at AS updated_at_1,
          p0_.id AS id_2,
          p0_.deleted_at AS deleted_at_3
        FROM
          product_types p0_
        WHERE
          (p0_.deleted_at IS NULL)
        ORDER BY
          p0_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_2 FROM (SELECT p0_.name AS name_0, p0_.updated_at AS updated_at_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3 FROM product_types p0_ WHERE (p0_.deleted_at IS NULL) ORDER BY p0_.name ASC) dctrn_result) dctrn_table;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 148)
8	App\Infrastructure\EntityTable\Component\EntityTableComponent->getTotalPagesCount (line 53)
9	Symfony\UX\TwigComponent\ComputedPropertiesProxy->__call (line 1909)
10	Twig\Extension\CoreExtension::getAttribute (line 655)
11	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_pager (line 446)
12	Twig\Template->yieldBlock (line 572)
13	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card_footer__in (line 446)
14	Twig\Template->yieldBlock (line 536)
15	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card_footer__out (line 446)
16	Twig\Template->yieldBlock (line 140)
17	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card__in (line 446)
18	Twig\Template->yieldBlock (line 100)
19	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->block_card__out (line 446)
20	Twig\Template->yieldBlock (line 70)
21	__TwigTemplate_2df2fd653ceffcbe19eba66178ba6887->doDisplay (line 402)
22	Twig\Template->yield (line 358)
23	Twig\Template->display (line 373)
24	Twig\Template->render (line 77)
25	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
26	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
27	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 118)
28	__TwigTemplate_35389c749ce176c88ca2838bf0697a2a->block_body (line 446)
29	Twig\Template->yieldBlock (line 136)
30	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
31	Twig\Template->yield (line 54)
32	__TwigTemplate_35389c749ce176c88ca2838bf0697a2a->doDisplay (line 402)
33	Twig\Template->yield (line 358)
34	Twig\Template->display (line 373)
35	Twig\Template->render (line 51)
36	Twig\TemplateWrapper->render (line 333)
37	Twig\Environment->render (line 459)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 17)
41	App\ProductType\Controller\ProductTypesController->__invoke (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
44	Symfony\Component\HttpKernel\Kernel->handle (line 35)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
46	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\ProductType\Entity\ProductType	25
App\ProductType\Entity\ProductTypeGroup	3

Entities Mapping

Class	Mapping errors
App\ProductType\Entity\ProductType	No errors.
App\ProductType\Entity\ProductTypeGroup	The field App\ProductType\Entity\ProductTypeGroup#productTypes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\ProductType\Entity\ProductType#group does not contain the required 'inversedBy="productTypes"' attribute.

Symfony Profiler

GET https://2025-mu.release.sb.paritet.sprintf.ru/directory/product_types

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping