Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.97 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.05 ms
(76.62%)

SELECT DISTINCT id_5, MIN(sclr_7) AS dctrn_minrownum FROM (SELECT l0_.opf AS opf_0, l0_.name AS name_1, l0_.ogrn AS ogrn_2, l0_.inn AS inn_3, l0_.updated_at AS updated_at_4, l0_.id AS id_5, l0_.deleted_at AS deleted_at_6, ROW_NUMBER() OVER(ORDER BY l0_.name ASC) AS sclr_7 FROM legals l0_ WHERE (l0_.deleted_at IS NULL)) dctrn_result GROUP BY id_5 ORDER BY dctrn_minrownum ASC LIMIT 25

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_5,
  MIN(sclr_7) AS dctrn_minrownum
FROM
  (
    SELECT
      l0_.opf AS opf_0,
      l0_.name AS name_1,
      l0_.ogrn AS ogrn_2,
      l0_.inn AS inn_3,
      l0_.updated_at AS updated_at_4,
      l0_.id AS id_5,
      l0_.deleted_at AS deleted_at_6,
      ROW_NUMBER() OVER(
        ORDER BY
          l0_.name ASC
      ) AS sclr_7
    FROM
      legals l0_
    WHERE
      (l0_.deleted_at IS NULL)
  ) dctrn_result
GROUP BY
  id_5
ORDER BY
  dctrn_minrownum ASC
LIMIT
  25

SELECT DISTINCT id_5, MIN(sclr_7) AS dctrn_minrownum FROM (SELECT l0_.opf AS opf_0, l0_.name AS name_1, l0_.ogrn AS ogrn_2, l0_.inn AS inn_3, l0_.updated_at AS updated_at_4, l0_.id AS id_5, l0_.deleted_at AS deleted_at_6, ROW_NUMBER() OVER(ORDER BY l0_.name ASC) AS sclr_7 FROM legals l0_ WHERE (l0_.deleted_at IS NULL)) dctrn_result GROUP BY id_5 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_90d3a56fb73db3541b986e3a3431f750->block_body (line 446)
30	Twig\Template->yieldBlock (line 136)
31	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
32	Twig\Template->yield (line 54)
33	__TwigTemplate_90d3a56fb73db3541b986e3a3431f750->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\Legal\Controller\LegalsController->__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.57 ms
(14.34%)

SELECT l0_.opf AS opf_0, l0_.name AS name_1, l0_.ogrn AS ogrn_2, l0_.inn AS inn_3, l0_.updated_at AS updated_at_4, l0_.id AS id_5, l0_.deleted_at AS deleted_at_6 FROM legals l0_ WHERE (l0_.id IN (?, ?, ?, ?)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.name ASC

Parameters:

[
  "38c630c6-596b-4e64-a1d7-18e07ee6aa93"
  "a33831c1-5dc1-41fa-940d-055f4805b238"
  "5a384ba6-dcc3-4cc7-ab14-b7a609d22939"
  "4650310c-d0d5-423f-9bf1-ce79dc1d8fa8"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.opf AS opf_0,
  l0_.name AS name_1,
  l0_.ogrn AS ogrn_2,
  l0_.inn AS inn_3,
  l0_.updated_at AS updated_at_4,
  l0_.id AS id_5,
  l0_.deleted_at AS deleted_at_6
FROM
  legals l0_
WHERE
  (
    l0_.id IN (?, ?, ?, ?)
  )
  AND (l0_.deleted_at IS NULL)
ORDER BY
  l0_.name ASC

SELECT l0_.opf AS opf_0, l0_.name AS name_1, l0_.ogrn AS ogrn_2, l0_.inn AS inn_3, l0_.updated_at AS updated_at_4, l0_.id AS id_5, l0_.deleted_at AS deleted_at_6 FROM legals l0_ WHERE (l0_.id IN ('38c630c6-596b-4e64-a1d7-18e07ee6aa93', 'a33831c1-5dc1-41fa-940d-055f4805b238', '5a384ba6-dcc3-4cc7-ab14-b7a609d22939', '4650310c-d0d5-423f-9bf1-ce79dc1d8fa8')) AND (l0_.deleted_at IS NULL) ORDER BY l0_.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_90d3a56fb73db3541b986e3a3431f750->block_body (line 446)
30	Twig\Template->yieldBlock (line 136)
31	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
32	Twig\Template->yield (line 54)
33	__TwigTemplate_90d3a56fb73db3541b986e3a3431f750->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\Legal\Controller\LegalsController->__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.36 ms
(9.03%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (SELECT l0_.opf AS opf_0, l0_.name AS name_1, l0_.ogrn AS ogrn_2, l0_.inn AS inn_3, l0_.updated_at AS updated_at_4, l0_.id AS id_5, l0_.deleted_at AS deleted_at_6 FROM legals l0_ WHERE (l0_.deleted_at IS NULL) ORDER BY l0_.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_5
    FROM
      (
        SELECT
          l0_.opf AS opf_0,
          l0_.name AS name_1,
          l0_.ogrn AS ogrn_2,
          l0_.inn AS inn_3,
          l0_.updated_at AS updated_at_4,
          l0_.id AS id_5,
          l0_.deleted_at AS deleted_at_6
        FROM
          legals l0_
        WHERE
          (l0_.deleted_at IS NULL)
        ORDER BY
          l0_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (SELECT l0_.opf AS opf_0, l0_.name AS name_1, l0_.ogrn AS ogrn_2, l0_.inn AS inn_3, l0_.updated_at AS updated_at_4, l0_.id AS id_5, l0_.deleted_at AS deleted_at_6 FROM legals l0_ WHERE (l0_.deleted_at IS NULL) ORDER BY l0_.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_90d3a56fb73db3541b986e3a3431f750->block_body (line 446)
29	Twig\Template->yieldBlock (line 136)
30	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
31	Twig\Template->yield (line 54)
32	__TwigTemplate_90d3a56fb73db3541b986e3a3431f750->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\Legal\Controller\LegalsController->__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\Legal\Entity\Legal	4

Entities Mapping

Class	Mapping errors
App\Legal\Entity\Legal	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping