Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.64 ms Query time

1 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.51 ms
(75.68%)

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_groups p0_) 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_groups p0_
  ) 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_groups p0_) 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_396bb961a5d3fad1f28a25ac4d458070->block_body (line 446)
30	Twig\Template->yieldBlock (line 136)
31	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
32	Twig\Template->yield (line 54)
33	__TwigTemplate_396bb961a5d3fad1f28a25ac4d458070->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\ProductTypeGroupsController->__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.59 ms
(12.78%)

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_groups p0_ WHERE p0_.id IN (?, ?, ?) ORDER BY p0_.name ASC

Parameters:

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

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
FROM
  product_types_groups p0_
WHERE
  p0_.id IN (?, ?, ?)
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 FROM product_types_groups p0_ WHERE p0_.id IN ('3f1a9f7a-d3c5-11ed-afa1-0242ac120002', '3f1a9c0c-d3c5-11ed-afa1-0242ac120002', '3f1a9f7a-d3c5-11ed-afa1-0242ac121111') 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_396bb961a5d3fad1f28a25ac4d458070->block_body (line 446)
30	Twig\Template->yieldBlock (line 136)
31	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
32	Twig\Template->yield (line 54)
33	__TwigTemplate_396bb961a5d3fad1f28a25ac4d458070->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\ProductTypeGroupsController->__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
(11.54%)

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_groups p0_ 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_groups p0_
        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_groups p0_ 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_396bb961a5d3fad1f28a25ac4d458070->block_body (line 446)
29	Twig\Template->yieldBlock (line 136)
30	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
31	Twig\Template->yield (line 54)
32	__TwigTemplate_396bb961a5d3fad1f28a25ac4d458070->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\ProductTypeGroupsController->__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\ProductTypeGroup	3

Entities Mapping

Class	Mapping 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.
App\ProductType\Entity\ProductType	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping