Symfony Profiler

Query Metrics

13 Database Queries

6 Different statements

5.58 ms Query time

0 Invalid entities

113 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.71 ms
(48.49%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.is_text_value AS is_text_value_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.order_num AS order_num_7, t0.type_id AS type_id_8 FROM claim__type_category t0 WHERE t0.type_id = ? ORDER BY t0.order_num ASC

Parameters:

[
  "862985d3-5bbc-4197-9a9b-71a770d8a912"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.is_text_value AS is_text_value_4,
  t0.created_at AS created_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.order_num AS order_num_7,
  t0.type_id AS type_id_8
FROM
  claim__type_category t0
WHERE
  t0.type_id = ?
ORDER BY
  t0.order_num ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.is_text_value AS is_text_value_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.order_num AS order_num_7, t0.type_id AS type_id_8 FROM claim__type_category t0 WHERE t0.type_id = '862985d3-5bbc-4197-9a9b-71a770d8a912' ORDER BY t0.order_num ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 320)
8	__TwigTemplate_a60dfc7b2061cd2c460c45cb195bcfcd->doDisplay (line 402)
9	Twig\Template->yield (line 358)
10	Twig\Template->display (line 373)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 333)
13	Twig\Environment->render (line 40)
14	Sonata\BlockBundle\Block\Service\AbstractBlockService->renderResponse (line 47)
15	App\Block\ClaimFormBlockService->execute (line 46)
16	Sonata\BlockBundle\Block\BlockRenderer->render (line 166)
17	Sonata\BlockBundle\Templating\Helper\BlockHelper->render (line 382)
18	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->block_content (line 446)
19	Twig\Template->yieldBlock (line 195)
20	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->block_body (line 446)
21	Twig\Template->yieldBlock (line 84)
22	__TwigTemplate_cd77c8853490913d30d544ef64586d3d->doDisplay (line 402)
23	Twig\Template->yield (line 55)
24	__TwigTemplate_491dcb68d0a6a8e6e7af6a4800bc7cb6->doDisplay (line 402)
25	Twig\Template->yield (line 56)
26	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->doDisplay (line 402)
27	Twig\Template->yield (line 358)
28	Twig\Template->display (line 373)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 333)
31	Twig\Environment->render (line 448)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 15)
35	App\Controller\DefaultController->indexAction (line 181)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

0.93 ms
(16.59%)

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.is_active AS is_active_2, d0_.is_text_value AS is_text_value_3, d0_.created_at AS created_at_4, d0_.deleted_at AS deleted_at_5 FROM dictionary__agency d0_ WHERE d0_.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.is_active AS is_active_2,
  d0_.is_text_value AS is_text_value_3,
  d0_.created_at AS created_at_4,
  d0_.deleted_at AS deleted_at_5
FROM
  dictionary__agency d0_
WHERE
  d0_.is_active = ?

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.is_active AS is_active_2, d0_.is_text_value AS is_text_value_3, d0_.created_at AS created_at_4, d0_.deleted_at AS deleted_at_5 FROM dictionary__agency d0_ WHERE d0_.is_active = 1;

#	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 27)
7	App\Repository\Dictionary\AgencyRepository->findActive (line 41)
8	App\Block\ClaimFormBlockService->execute (line 46)
9	Sonata\BlockBundle\Block\BlockRenderer->render (line 166)
10	Sonata\BlockBundle\Templating\Helper\BlockHelper->render (line 382)
11	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->block_content (line 446)
12	Twig\Template->yieldBlock (line 195)
13	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->block_body (line 446)
14	Twig\Template->yieldBlock (line 84)
15	__TwigTemplate_cd77c8853490913d30d544ef64586d3d->doDisplay (line 402)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_491dcb68d0a6a8e6e7af6a4800bc7cb6->doDisplay (line 402)
18	Twig\Template->yield (line 56)
19	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 15)
28	App\Controller\DefaultController->indexAction (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.61 ms
(11.01%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_active AS is_active_2, c0_.created_at AS created_at_3, c0_.deleted_at AS deleted_at_4, c0_.order_num AS order_num_5 FROM claim__type c0_ WHERE c0_.is_active = ? ORDER BY c0_.order_num ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.is_active AS is_active_2,
  c0_.created_at AS created_at_3,
  c0_.deleted_at AS deleted_at_4,
  c0_.order_num AS order_num_5
FROM
  claim__type c0_
WHERE
  c0_.is_active = ?
ORDER BY
  c0_.order_num ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_active AS is_active_2, c0_.created_at AS created_at_3, c0_.deleted_at AS deleted_at_4, c0_.order_num AS order_num_5 FROM claim__type c0_ WHERE c0_.is_active = 1 ORDER BY c0_.order_num 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 28)
7	App\Repository\Claim\TypeRepository->findActive (line 45)
8	App\Block\ClaimFormBlockService->execute (line 46)
9	Sonata\BlockBundle\Block\BlockRenderer->render (line 166)
10	Sonata\BlockBundle\Templating\Helper\BlockHelper->render (line 382)
11	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->block_content (line 446)
12	Twig\Template->yieldBlock (line 195)
13	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->block_body (line 446)
14	Twig\Template->yieldBlock (line 84)
15	__TwigTemplate_cd77c8853490913d30d544ef64586d3d->doDisplay (line 402)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_491dcb68d0a6a8e6e7af6a4800bc7cb6->doDisplay (line 402)
18	Twig\Template->yield (line 56)
19	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 15)
28	App\Controller\DefaultController->indexAction (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.50 ms
(8.92%)

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.prosecutor_office AS prosecutor_office_2, d0_.emails AS emails_3, d0_.is_active AS is_active_4, d0_.created_at AS created_at_5, d0_.deleted_at AS deleted_at_6 FROM dictionary__region d0_ WHERE d0_.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.prosecutor_office AS prosecutor_office_2,
  d0_.emails AS emails_3,
  d0_.is_active AS is_active_4,
  d0_.created_at AS created_at_5,
  d0_.deleted_at AS deleted_at_6
FROM
  dictionary__region d0_
WHERE
  d0_.is_active = ?

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.prosecutor_office AS prosecutor_office_2, d0_.emails AS emails_3, d0_.is_active AS is_active_4, d0_.created_at AS created_at_5, d0_.deleted_at AS deleted_at_6 FROM dictionary__region d0_ WHERE d0_.is_active = 1;

#	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 27)
7	App\Repository\Dictionary\RegionRepository->findActive (line 42)
8	App\Block\ClaimFormBlockService->execute (line 46)
9	Sonata\BlockBundle\Block\BlockRenderer->render (line 166)
10	Sonata\BlockBundle\Templating\Helper\BlockHelper->render (line 382)
11	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->block_content (line 446)
12	Twig\Template->yieldBlock (line 195)
13	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->block_body (line 446)
14	Twig\Template->yieldBlock (line 84)
15	__TwigTemplate_cd77c8853490913d30d544ef64586d3d->doDisplay (line 402)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_491dcb68d0a6a8e6e7af6a4800bc7cb6->doDisplay (line 402)
18	Twig\Template->yield (line 56)
19	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 15)
28	App\Controller\DefaultController->indexAction (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.44 ms
(7.79%)

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.is_active AS is_active_2, d0_.created_at AS created_at_3, d0_.deleted_at AS deleted_at_4 FROM dictionary__industry d0_ WHERE d0_.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.is_active AS is_active_2,
  d0_.created_at AS created_at_3,
  d0_.deleted_at AS deleted_at_4
FROM
  dictionary__industry d0_
WHERE
  d0_.is_active = ?

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.is_active AS is_active_2, d0_.created_at AS created_at_3, d0_.deleted_at AS deleted_at_4 FROM dictionary__industry d0_ WHERE d0_.is_active = 1;

#	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 27)
7	App\Repository\Dictionary\IndustryRepository->findActive (line 43)
8	App\Block\ClaimFormBlockService->execute (line 46)
9	Sonata\BlockBundle\Block\BlockRenderer->render (line 166)
10	Sonata\BlockBundle\Templating\Helper\BlockHelper->render (line 382)
11	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->block_content (line 446)
12	Twig\Template->yieldBlock (line 195)
13	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->block_body (line 446)
14	Twig\Template->yieldBlock (line 84)
15	__TwigTemplate_cd77c8853490913d30d544ef64586d3d->doDisplay (line 402)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_491dcb68d0a6a8e6e7af6a4800bc7cb6->doDisplay (line 402)
18	Twig\Template->yield (line 56)
19	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 15)
28	App\Controller\DefaultController->indexAction (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.40 ms
(7.20%)

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.is_active AS is_active_2, d0_.created_at AS created_at_3, d0_.deleted_at AS deleted_at_4 FROM dictionary__legal_form d0_ WHERE d0_.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.is_active AS is_active_2,
  d0_.created_at AS created_at_3,
  d0_.deleted_at AS deleted_at_4
FROM
  dictionary__legal_form d0_
WHERE
  d0_.is_active = ?

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.is_active AS is_active_2, d0_.created_at AS created_at_3, d0_.deleted_at AS deleted_at_4 FROM dictionary__legal_form d0_ WHERE d0_.is_active = 1;

#	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 27)
7	App\Repository\Dictionary\LegalFormRepository->findActive (line 44)
8	App\Block\ClaimFormBlockService->execute (line 46)
9	Sonata\BlockBundle\Block\BlockRenderer->render (line 166)
10	Sonata\BlockBundle\Templating\Helper\BlockHelper->render (line 382)
11	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->block_content (line 446)
12	Twig\Template->yieldBlock (line 195)
13	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->block_body (line 446)
14	Twig\Template->yieldBlock (line 84)
15	__TwigTemplate_cd77c8853490913d30d544ef64586d3d->doDisplay (line 402)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_491dcb68d0a6a8e6e7af6a4800bc7cb6->doDisplay (line 402)
18	Twig\Template->yield (line 56)
19	__TwigTemplate_591c9115c0b3cf8e7fa3252a86b12b92->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 15)
28	App\Controller\DefaultController->indexAction (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	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\Entity\Claim\TypeCategory	33
App\Entity\Dictionary\Region	26
App\Entity\Dictionary\LegalForm	24
App\Entity\Dictionary\Industry	16
App\Entity\Claim\Type	8
App\Entity\Dictionary\Agency	6

Entities Mapping

Class	Mapping errors
App\Entity\Dictionary\Agency	No errors.
App\Entity\Dictionary\Region	No errors.
App\Entity\Dictionary\Industry	No errors.
App\Entity\Dictionary\LegalForm	No errors.
App\Entity\Claim\Type	No errors.
App\Entity\Claim\TypeCategory	No errors.

Symfony Profiler

HEAD http://stoptysk.gp.gov.ua/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping