Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

7.51 ms Query time

0 Invalid entities

25 Managed entities

Queries

Group similar statements

#▲

Time

Info

5.77 ms

SELECT DISTINCT id_6, MIN(sclr_8) AS dctrn_minrownum FROM (SELECT s0_.alpha2 AS alpha2_0, s0_.alpha3 AS alpha3_1, s0_.name AS name_2, s0_.name_full AS name_full_3, s0_.name_eng AS name_eng_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.deleted_at AS deleted_at_7, ROW_NUMBER() OVER(ORDER BY s0_.name ASC) AS sclr_8 FROM states s0_ WHERE (s0_.deleted_at IS NULL)) dctrn_result GROUP BY id_6 ORDER BY dctrn_minrownum ASC LIMIT 25

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_6,
  MIN(sclr_8) AS dctrn_minrownum
FROM
  (
    SELECT
      s0_.alpha2 AS alpha2_0,
      s0_.alpha3 AS alpha3_1,
      s0_.name AS name_2,
      s0_.name_full AS name_full_3,
      s0_.name_eng AS name_eng_4,
      s0_.updated_at AS updated_at_5,
      s0_.id AS id_6,
      s0_.deleted_at AS deleted_at_7,
      ROW_NUMBER() OVER(
        ORDER BY
          s0_.name ASC
      ) AS sclr_8
    FROM
      states s0_
    WHERE
      (s0_.deleted_at IS NULL)
  ) dctrn_result
GROUP BY
  id_6
ORDER BY
  dctrn_minrownum ASC
LIMIT
  25

SELECT DISTINCT id_6, MIN(sclr_8) AS dctrn_minrownum FROM (SELECT s0_.alpha2 AS alpha2_0, s0_.alpha3 AS alpha3_1, s0_.name AS name_2, s0_.name_full AS name_full_3, s0_.name_eng AS name_eng_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.deleted_at AS deleted_at_7, ROW_NUMBER() OVER(ORDER BY s0_.name ASC) AS sclr_8 FROM states s0_ WHERE (s0_.deleted_at IS NULL)) dctrn_result GROUP BY id_6 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_3693bff70b03bd770951303bce08621d->block_body (line 446)
30	Twig\Template->yieldBlock (line 136)
31	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
32	Twig\Template->yield (line 54)
33	__TwigTemplate_3693bff70b03bd770951303bce08621d->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\Geo\Controller\StatesController->__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.89 ms

SELECT s0_.alpha2 AS alpha2_0, s0_.alpha3 AS alpha3_1, s0_.name AS name_2, s0_.name_full AS name_full_3, s0_.name_eng AS name_eng_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.deleted_at AS deleted_at_7 FROM states s0_ WHERE (s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (s0_.deleted_at IS NULL) ORDER BY s0_.name ASC

Parameters:

[
  "d3923732-fc3e-4036-bab9-ffb50bffc0ee"
  "c695010f-63ba-4913-89a2-32385cbd1b06"
  "ed900eb6-4e27-46b3-8463-d8cb6314152a"
  "7d17be6a-4853-47bd-a9d3-d68a6cc4bd3b"
  "d95ab185-e2f9-4fbe-aadc-b3e5a806fd21"
  "5e3d36c9-4589-4b4e-bed2-86c9fd641735"
  "d1c0a92e-1302-4b68-a90b-b1c9360b1451"
  "375b91b4-7689-4d66-a554-20014724469d"
  "36a0bf10-3c92-49c9-93ac-423984a2f256"
  "866374ba-013d-4ae9-bce0-fc93d860af2b"
  "6e59e203-ddeb-4b39-bc5f-d1f91b2239dd"
  "b6626207-53f8-46f5-b898-c453a07c062e"
  "39a5d9dd-2042-49d7-abec-512ae6bf4113"
  "9a744bf5-db8e-490f-baf8-c2f0e8d245ea"
  "2953ab0a-d5e4-4f19-81ea-4c2c8db0c0d5"
  "331c8ce6-f44c-423e-a5bf-1c41fd2580f5"
  "f4439cf2-283d-484f-8344-d978cd819f32"
  "dc7540f6-7e5f-497b-a80b-23974d89df51"
  "5c4469e8-2d1b-4709-a1ff-31cb64c3042d"
  "ebb7bbc6-09dc-460b-9866-206bd01a8b43"
  "a5be428e-5e46-4c0c-bc48-e658c8b6bde0"
  "4b8712e8-3fdb-490a-8d96-c86d2b4cb3ba"
  "52b5aa93-05b2-40ac-8cfa-357f5c37c5c7"
  "ab4a5ed5-a0e3-41c0-b585-bb2f74808009"
  "b5ed0b01-1e6a-4d94-8dc7-c380b4578bcb"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.alpha2 AS alpha2_0,
  s0_.alpha3 AS alpha3_1,
  s0_.name AS name_2,
  s0_.name_full AS name_full_3,
  s0_.name_eng AS name_eng_4,
  s0_.updated_at AS updated_at_5,
  s0_.id AS id_6,
  s0_.deleted_at AS deleted_at_7
FROM
  states s0_
WHERE
  (
    s0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  AND (s0_.deleted_at IS NULL)
ORDER BY
  s0_.name ASC

SELECT s0_.alpha2 AS alpha2_0, s0_.alpha3 AS alpha3_1, s0_.name AS name_2, s0_.name_full AS name_full_3, s0_.name_eng AS name_eng_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.deleted_at AS deleted_at_7 FROM states s0_ WHERE (s0_.id IN ('d3923732-fc3e-4036-bab9-ffb50bffc0ee', 'c695010f-63ba-4913-89a2-32385cbd1b06', 'ed900eb6-4e27-46b3-8463-d8cb6314152a', '7d17be6a-4853-47bd-a9d3-d68a6cc4bd3b', 'd95ab185-e2f9-4fbe-aadc-b3e5a806fd21', '5e3d36c9-4589-4b4e-bed2-86c9fd641735', 'd1c0a92e-1302-4b68-a90b-b1c9360b1451', '375b91b4-7689-4d66-a554-20014724469d', '36a0bf10-3c92-49c9-93ac-423984a2f256', '866374ba-013d-4ae9-bce0-fc93d860af2b', '6e59e203-ddeb-4b39-bc5f-d1f91b2239dd', 'b6626207-53f8-46f5-b898-c453a07c062e', '39a5d9dd-2042-49d7-abec-512ae6bf4113', '9a744bf5-db8e-490f-baf8-c2f0e8d245ea', '2953ab0a-d5e4-4f19-81ea-4c2c8db0c0d5', '331c8ce6-f44c-423e-a5bf-1c41fd2580f5', 'f4439cf2-283d-484f-8344-d978cd819f32', 'dc7540f6-7e5f-497b-a80b-23974d89df51', '5c4469e8-2d1b-4709-a1ff-31cb64c3042d', 'ebb7bbc6-09dc-460b-9866-206bd01a8b43', 'a5be428e-5e46-4c0c-bc48-e658c8b6bde0', '4b8712e8-3fdb-490a-8d96-c86d2b4cb3ba', '52b5aa93-05b2-40ac-8cfa-357f5c37c5c7', 'ab4a5ed5-a0e3-41c0-b585-bb2f74808009', 'b5ed0b01-1e6a-4d94-8dc7-c380b4578bcb')) AND (s0_.deleted_at IS NULL) ORDER BY s0_.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_3693bff70b03bd770951303bce08621d->block_body (line 446)
30	Twig\Template->yieldBlock (line 136)
31	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
32	Twig\Template->yield (line 54)
33	__TwigTemplate_3693bff70b03bd770951303bce08621d->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\Geo\Controller\StatesController->__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.85 ms

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_6 FROM (SELECT s0_.alpha2 AS alpha2_0, s0_.alpha3 AS alpha3_1, s0_.name AS name_2, s0_.name_full AS name_full_3, s0_.name_eng AS name_eng_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.deleted_at AS deleted_at_7 FROM states s0_ WHERE (s0_.deleted_at IS NULL) ORDER BY s0_.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_6
    FROM
      (
        SELECT
          s0_.alpha2 AS alpha2_0,
          s0_.alpha3 AS alpha3_1,
          s0_.name AS name_2,
          s0_.name_full AS name_full_3,
          s0_.name_eng AS name_eng_4,
          s0_.updated_at AS updated_at_5,
          s0_.id AS id_6,
          s0_.deleted_at AS deleted_at_7
        FROM
          states s0_
        WHERE
          (s0_.deleted_at IS NULL)
        ORDER BY
          s0_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_6 FROM (SELECT s0_.alpha2 AS alpha2_0, s0_.alpha3 AS alpha3_1, s0_.name AS name_2, s0_.name_full AS name_full_3, s0_.name_eng AS name_eng_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.deleted_at AS deleted_at_7 FROM states s0_ WHERE (s0_.deleted_at IS NULL) ORDER BY s0_.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_3693bff70b03bd770951303bce08621d->block_body (line 446)
29	Twig\Template->yieldBlock (line 136)
30	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
31	Twig\Template->yield (line 54)
32	__TwigTemplate_3693bff70b03bd770951303bce08621d->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\Geo\Controller\StatesController->__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\Geo\Entity\State	25

Entities Mapping

Class	Mapping errors
App\Geo\Entity\State	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping