Symfony Profiler

Query Metrics

12 Database Queries

6 Different statements

9.02 ms Query time

2 Invalid entities

24 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.15 ms
(34.86%)

SELECT DISTINCT id_1, MIN(sclr_2) AS dctrn_minrownum FROM (SELECT p0_.updated_at AS updated_at_0, p0_.id AS id_1, ROW_NUMBER() OVER(ORDER BY p0_.project_id ASC) AS sclr_2 FROM project_category_products p0_) dctrn_result GROUP BY id_1 ORDER BY dctrn_minrownum ASC LIMIT 25

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_1,
  MIN(sclr_2) AS dctrn_minrownum
FROM
  (
    SELECT
      p0_.updated_at AS updated_at_0,
      p0_.id AS id_1,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.project_id ASC
      ) AS sclr_2
    FROM
      project_category_products p0_
  ) dctrn_result
GROUP BY
  id_1
ORDER BY
  dctrn_minrownum ASC
LIMIT
  25

SELECT DISTINCT id_1, MIN(sclr_2) AS dctrn_minrownum FROM (SELECT p0_.updated_at AS updated_at_0, p0_.id AS id_1, ROW_NUMBER() OVER(ORDER BY p0_.project_id ASC) AS sclr_2 FROM project_category_products p0_) dctrn_result GROUP BY id_1 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_bc7a34455421ac1274c759e4097bd00d->block_body (line 446)
30	Twig\Template->yieldBlock (line 136)
31	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
32	Twig\Template->yield (line 54)
33	__TwigTemplate_bc7a34455421ac1274c759e4097bd00d->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 14)
42	App\ProductCategory\Controller\ProductCategoryController->__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)

2.09 ms
(23.18%)

SELECT p0_.domain AS domain_0, p0_.name AS name_1, p0_.api_key AS api_key_2, p0_.updated_at AS updated_at_3, p0_.id AS id_4, p0_.deleted_at AS deleted_at_5, p0_.legal_id AS legal_id_6, p0_.city_id AS city_id_7 FROM projects p0_ WHERE (p0_.deleted_at IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.domain AS domain_0,
  p0_.name AS name_1,
  p0_.api_key AS api_key_2,
  p0_.updated_at AS updated_at_3,
  p0_.id AS id_4,
  p0_.deleted_at AS deleted_at_5,
  p0_.legal_id AS legal_id_6,
  p0_.city_id AS city_id_7
FROM
  projects p0_
WHERE
  (p0_.deleted_at IS NULL)

SELECT p0_.domain AS domain_0, p0_.name AS name_1, p0_.api_key AS api_key_2, p0_.updated_at AS updated_at_3, p0_.id AS id_4, p0_.deleted_at AS deleted_at_5, p0_.legal_id AS legal_id_6, p0_.city_id AS city_id_7 FROM projects p0_ WHERE (p0_.deleted_at IS NULL);

#	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 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 202)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 120)
21	App\Infrastructure\EntityTable\Component\EntityTableComponent->getFormView (line 95)
22	App\Infrastructure\EntityTable\Component\EntityTableComponent->initializeForm (line 199)
23	Symfony\UX\TwigComponent\ComponentFactory->postMount (line 108)
24	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 84)
25	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
26	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
27	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 118)
28	__TwigTemplate_bc7a34455421ac1274c759e4097bd00d->block_body (line 446)
29	Twig\Template->yieldBlock (line 136)
30	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
31	Twig\Template->yield (line 54)
32	__TwigTemplate_bc7a34455421ac1274c759e4097bd00d->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 14)
41	App\ProductCategory\Controller\ProductCategoryController->__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)

1.58 ms
(17.56%)

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, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  "1df45d75-bf6a-458a-86bb-aab2d770c9d7"
]

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,
  t0.product_type_id AS product_type_id_5,
  t0.brand_id AS brand_id_6
FROM
  products t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

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, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = '1df45d75-bf6a-458a-86bb-aab2d770c9d7' AND ((t0.deleted_at IS NULL));

#	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\Offer\Entity\Product::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Offer\Entity\Product->__get (line 125)
8	App\Offer\Entity\Product->getName (line 93)
9	App\ProductCategory\Entity\ProductProjectCategory->getProductName (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_bc7a34455421ac1274c759e4097bd00d->block_body (line 446)
34	Twig\Template->yieldBlock (line 136)
35	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
36	Twig\Template->yield (line 54)
37	__TwigTemplate_bc7a34455421ac1274c759e4097bd00d->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 14)
46	App\ProductCategory\Controller\ProductCategoryController->__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)

1.26 ms
(13.99%)

SELECT t0.lft AS lft_1, t0.rgt AS rgt_2, t0.lvl AS lvl_3, t0.name AS name_4, t0.slug AS slug_5, t0.id AS id_6, t0.prt AS prt_7, t0.project_id AS project_id_8, t0.tree_root AS tree_root_9 FROM categories_all t0 WHERE t0.id = ?

Parameters:

[
  "1f0adb7f-5768-6516-bf71-278e933446f6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.lft AS lft_1,
  t0.rgt AS rgt_2,
  t0.lvl AS lvl_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.id AS id_6,
  t0.prt AS prt_7,
  t0.project_id AS project_id_8,
  t0.tree_root AS tree_root_9
FROM
  categories_all t0
WHERE
  t0.id = ?

SELECT t0.lft AS lft_1, t0.rgt AS rgt_2, t0.lvl AS lvl_3, t0.name AS name_4, t0.slug AS slug_5, t0.id AS id_6, t0.prt AS prt_7, t0.project_id AS project_id_8, t0.tree_root AS tree_root_9 FROM categories_all t0 WHERE t0.id = '1f0adb7f-5768-6516-bf71-278e933446f6';

#	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\ProductCategory\Entity\ProductCategory::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\ProductCategory\Entity\ProductCategory->__get (line 124)
8	App\ProductCategory\Entity\ProductCategory->getName (line 70)
9	App\ProductCategory\Entity\ProductProjectCategory->getProductCategoryName (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_bc7a34455421ac1274c759e4097bd00d->block_body (line 446)
34	Twig\Template->yieldBlock (line 136)
35	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
36	Twig\Template->yield (line 54)
37	__TwigTemplate_bc7a34455421ac1274c759e4097bd00d->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 14)
46	App\ProductCategory\Controller\ProductCategoryController->__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.63 ms
(6.98%)

SELECT p0_.updated_at AS updated_at_0, p0_.id AS id_1, p0_.project_id AS project_id_2, p0_.product_category_id AS product_category_id_3, p0_.product_id AS product_id_4 FROM project_category_products p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.project_id ASC

Parameters:

[
  "b4d6306f-d615-40cd-8721-349bcba26501"
  "73d84181-f937-4d9e-8322-bef078fea425"
  "2e0e91e5-5056-4da3-92e3-4c93cc9a7bd6"
  "2bc9c00d-e3e7-41eb-9600-4c1e6fe8ae25"
  "53f77aa2-1c14-43b5-ae2a-d6f22b2382a0"
  "0a7d84bf-f1a8-4a75-a6c5-a3c7c3d7c378"
  "f7256f48-764c-48c1-9986-3cb482ab2b6f"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.updated_at AS updated_at_0,
  p0_.id AS id_1,
  p0_.project_id AS project_id_2,
  p0_.product_category_id AS product_category_id_3,
  p0_.product_id AS product_id_4
FROM
  project_category_products p0_
WHERE
  p0_.id IN (?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.project_id ASC

SELECT p0_.updated_at AS updated_at_0, p0_.id AS id_1, p0_.project_id AS project_id_2, p0_.product_category_id AS product_category_id_3, p0_.product_id AS product_id_4 FROM project_category_products p0_ WHERE p0_.id IN ('b4d6306f-d615-40cd-8721-349bcba26501', '73d84181-f937-4d9e-8322-bef078fea425', '2e0e91e5-5056-4da3-92e3-4c93cc9a7bd6', '2bc9c00d-e3e7-41eb-9600-4c1e6fe8ae25', '53f77aa2-1c14-43b5-ae2a-d6f22b2382a0', '0a7d84bf-f1a8-4a75-a6c5-a3c7c3d7c378', 'f7256f48-764c-48c1-9986-3cb482ab2b6f') ORDER BY p0_.project_id 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_bc7a34455421ac1274c759e4097bd00d->block_body (line 446)
30	Twig\Template->yieldBlock (line 136)
31	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
32	Twig\Template->yield (line 54)
33	__TwigTemplate_bc7a34455421ac1274c759e4097bd00d->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 14)
42	App\ProductCategory\Controller\ProductCategoryController->__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.31 ms
(3.42%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT p0_.updated_at AS updated_at_0, p0_.id AS id_1 FROM project_category_products p0_ ORDER BY p0_.project_id 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_1
    FROM
      (
        SELECT
          p0_.updated_at AS updated_at_0,
          p0_.id AS id_1
        FROM
          project_category_products p0_
        ORDER BY
          p0_.project_id ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT p0_.updated_at AS updated_at_0, p0_.id AS id_1 FROM project_category_products p0_ ORDER BY p0_.project_id 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_bc7a34455421ac1274c759e4097bd00d->block_body (line 446)
29	Twig\Template->yieldBlock (line 136)
30	__TwigTemplate_3c6c825967dac734617879087d18ce50->doDisplay (line 402)
31	Twig\Template->yield (line 54)
32	__TwigTemplate_bc7a34455421ac1274c759e4097bd00d->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 14)
41	App\ProductCategory\Controller\ProductCategoryController->__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\ProductCategory\Entity\ProductProjectCategory	7
App\Offer\Entity\Product	7
App\Brand\Entity\Brand	4
App\Project\Entity\Project	3
App\ProductCategory\Entity\ProductCategory	2
App\ProductType\Entity\ProductType	1

Entities Mapping

Class	Mapping errors
App\Project\Entity\Project	The field App\Project\Entity\Project#subProjects is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Project\Entity\Subproject#project does not contain the required 'inversedBy="subProjects"' attribute.
App\Legal\Entity\Legal	No errors.
App\Geo\Entity\City	No errors.
App\Project\Entity\Subproject	No errors.
App\ProductCategory\Entity\ProductProjectCategory	No errors.
App\ProductCategory\Entity\ProductCategory	The field App\ProductCategory\Entity\ProductCategory#rules is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\ProductCategory\Entity\ProductCategoryRule#productCategory does not contain the required 'inversedBy="rules"' attribute.
App\Offer\Entity\Product	No errors.
App\ProductCategory\Entity\ProductCategoryRule	No errors.
App\ProductType\Entity\ProductType	No errors.
App\Brand\Entity\Brand	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping