Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

3.79 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.33 ms
(35.07%)

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.title AS title_2, i0_.text AS text_3, i0_.image AS image_4, i0_.description_add AS description_add_5, i0_.keywords AS keywords_6, i0_.slug AS slug_7, i0_.expires_after AS expires_after_8, i0_.show_as_action AS show_as_action_9, i0_.show_as_banner AS show_as_banner_10, i0_.banner_priority AS banner_priority_11, i0_.banner_url AS banner_url_12, i0_.url AS url_13, i0_.erid AS erid_14, i0_.ib_type AS ib_type_15, i0_.group_id AS group_id_16 FROM info_block i0_ WHERE (i0_.slug = ?) AND i0_.ib_type IN ('2')

Parameters:

[
  "current"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.title AS title_2,
  i0_.text AS text_3,
  i0_.image AS image_4,
  i0_.description_add AS description_add_5,
  i0_.keywords AS keywords_6,
  i0_.slug AS slug_7,
  i0_.expires_after AS expires_after_8,
  i0_.show_as_action AS show_as_action_9,
  i0_.show_as_banner AS show_as_banner_10,
  i0_.banner_priority AS banner_priority_11,
  i0_.banner_url AS banner_url_12,
  i0_.url AS url_13,
  i0_.erid AS erid_14,
  i0_.ib_type AS ib_type_15,
  i0_.group_id AS group_id_16
FROM
  info_block i0_
WHERE
  (i0_.slug = ?)
  AND i0_.ib_type IN ('2')

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.title AS title_2, i0_.text AS text_3, i0_.image AS image_4, i0_.description_add AS description_add_5, i0_.keywords AS keywords_6, i0_.slug AS slug_7, i0_.expires_after AS expires_after_8, i0_.show_as_action AS show_as_action_9, i0_.show_as_banner AS show_as_banner_10, i0_.banner_priority AS banner_priority_11, i0_.banner_url AS banner_url_12, i0_.url AS url_13, i0_.erid AS erid_14, i0_.ib_type AS ib_type_15, i0_.group_id AS group_id_16 FROM info_block i0_ WHERE (i0_.slug = 'current') AND i0_.ib_type IN ('2');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 1273)
7	App\Controller\MainController->action (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.75 ms
(19.84%)

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = ? LIMIT 1

Parameters:

[
  "tolyatti"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.town AS town_2,
  t0.name AS name_3,
  t0.seo_name AS seo_name_4
FROM
  town t0
WHERE
  t0.town = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = 'tolyatti' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 41)
4	App\EnvironmentProcessors\KolexTownProcessor->getEnv (line 368)
5	Symfony\Component\DependencyInjection\Container->getEnv (line 2200)
6	ContainerJvrhMxj\App_KernelDevDebugContainer::getTwigService (line 389)
7	Symfony\Component\DependencyInjection\Container->getService (line 40)
8	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 431)
9	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
10	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1241)
12	App\Controller\MainController->actions (line 178)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 119)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->forward (line 1275)
16	App\Controller\MainController->action (line 178)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.73 ms
(19.24%)

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.title AS title_2, i0_.text AS text_3, i0_.image AS image_4, i0_.description_add AS description_add_5, i0_.keywords AS keywords_6, i0_.slug AS slug_7, i0_.expires_after AS expires_after_8, i0_.show_as_action AS show_as_action_9, i0_.show_as_banner AS show_as_banner_10, i0_.banner_priority AS banner_priority_11, i0_.banner_url AS banner_url_12, i0_.url AS url_13, i0_.erid AS erid_14, i0_.ib_type AS ib_type_15, i0_.group_id AS group_id_16 FROM info_block i0_ WHERE (i0_.show_as_action = true AND i0_.created_at <= CURRENT_DATE AND i0_.expires_after >= CURRENT_DATE) AND i0_.ib_type IN ('2') ORDER BY i0_.expires_after DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.title AS title_2,
  i0_.text AS text_3,
  i0_.image AS image_4,
  i0_.description_add AS description_add_5,
  i0_.keywords AS keywords_6,
  i0_.slug AS slug_7,
  i0_.expires_after AS expires_after_8,
  i0_.show_as_action AS show_as_action_9,
  i0_.show_as_banner AS show_as_banner_10,
  i0_.banner_priority AS banner_priority_11,
  i0_.banner_url AS banner_url_12,
  i0_.url AS url_13,
  i0_.erid AS erid_14,
  i0_.ib_type AS ib_type_15,
  i0_.group_id AS group_id_16
FROM
  info_block i0_
WHERE
  (
    i0_.show_as_action = true
    AND i0_.created_at <= CURRENT_DATE
    AND i0_.expires_after >= CURRENT_DATE
  )
  AND i0_.ib_type IN ('2')
ORDER BY
  i0_.expires_after DESC

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.title AS title_2, i0_.text AS text_3, i0_.image AS image_4, i0_.description_add AS description_add_5, i0_.keywords AS keywords_6, i0_.slug AS slug_7, i0_.expires_after AS expires_after_8, i0_.show_as_action AS show_as_action_9, i0_.show_as_banner AS show_as_banner_10, i0_.banner_priority AS banner_priority_11, i0_.banner_url AS banner_url_12, i0_.url AS url_13, i0_.erid AS erid_14, i0_.ib_type AS ib_type_15, i0_.group_id AS group_id_16 FROM info_block i0_ WHERE (i0_.show_as_action = true AND i0_.created_at <= CURRENT_DATE AND i0_.expires_after >= CURRENT_DATE) AND i0_.ib_type IN ('2') ORDER BY i0_.expires_after DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 1240)
7	App\Controller\MainController->actions (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 119)
10	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->forward (line 1275)
11	App\Controller\MainController->action (line 178)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.64 ms
(16.78%)

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.title AS title_2, i0_.text AS text_3, i0_.image AS image_4, i0_.description_add AS description_add_5, i0_.keywords AS keywords_6, i0_.slug AS slug_7, i0_.expires_after AS expires_after_8, i0_.show_as_action AS show_as_action_9, i0_.show_as_banner AS show_as_banner_10, i0_.banner_priority AS banner_priority_11, i0_.banner_url AS banner_url_12, i0_.url AS url_13, i0_.erid AS erid_14, i0_.ib_type AS ib_type_15, i0_.group_id AS group_id_16 FROM info_block i0_ WHERE (i0_.show_as_banner = true AND i0_.created_at <= CURRENT_DATE AND i0_.expires_after >= CURRENT_DATE) AND i0_.ib_type IN ('2') ORDER BY i0_.banner_priority ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.title AS title_2,
  i0_.text AS text_3,
  i0_.image AS image_4,
  i0_.description_add AS description_add_5,
  i0_.keywords AS keywords_6,
  i0_.slug AS slug_7,
  i0_.expires_after AS expires_after_8,
  i0_.show_as_action AS show_as_action_9,
  i0_.show_as_banner AS show_as_banner_10,
  i0_.banner_priority AS banner_priority_11,
  i0_.banner_url AS banner_url_12,
  i0_.url AS url_13,
  i0_.erid AS erid_14,
  i0_.ib_type AS ib_type_15,
  i0_.group_id AS group_id_16
FROM
  info_block i0_
WHERE
  (
    i0_.show_as_banner = true
    AND i0_.created_at <= CURRENT_DATE
    AND i0_.expires_after >= CURRENT_DATE
  )
  AND i0_.ib_type IN ('2')
ORDER BY
  i0_.banner_priority ASC

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.title AS title_2, i0_.text AS text_3, i0_.image AS image_4, i0_.description_add AS description_add_5, i0_.keywords AS keywords_6, i0_.slug AS slug_7, i0_.expires_after AS expires_after_8, i0_.show_as_action AS show_as_action_9, i0_.show_as_banner AS show_as_banner_10, i0_.banner_priority AS banner_priority_11, i0_.banner_url AS banner_url_12, i0_.url AS url_13, i0_.erid AS erid_14, i0_.ib_type AS ib_type_15, i0_.group_id AS group_id_16 FROM info_block i0_ WHERE (i0_.show_as_banner = true AND i0_.created_at <= CURRENT_DATE AND i0_.expires_after >= CURRENT_DATE) AND i0_.ib_type IN ('2') ORDER BY i0_.banner_priority ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 41)
7	App\Service\Kolex->getBanners (line 1635)
8	twig_get_attribute (line 48)
9	__TwigTemplate_eece128f3eff990c429d6e9cd99d616d->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 55)
12	__TwigTemplate_4f28926632ebbcc43d875daa4f43ea76->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 89)
15	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->block_body (line 171)
16	Twig\Template->displayBlock (line 151)
17	__TwigTemplate_9ef0bb04516dbab8b4b6128433c217b8->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 50)
20	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 48)
23	__TwigTemplate_65ab96a183564cdf6cd6f68b4f676084->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 379)
26	Twig\Template->render (line 38)
27	Twig\TemplateWrapper->render (line 280)
28	Twig\Environment->render (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1241)
32	App\Controller\MainController->actions (line 178)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 119)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->forward (line 1275)
36	App\Controller\MainController->action (line 178)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

0.34 ms
(9.07%)

SELECT t0_.id AS id_0, t0_.town AS town_1, t0_.name AS name_2, t0_.seo_name AS seo_name_3 FROM town t0_ ORDER BY t0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.town AS town_1,
  t0_.name AS name_2,
  t0_.seo_name AS seo_name_3
FROM
  town t0_
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.town AS town_1, t0_.name AS name_2, t0_.seo_name AS seo_name_3 FROM town t0_ ORDER BY t0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 76)
7	App\Service\Kolex->getTowns (line 1635)
8	twig_get_attribute (line 54)
9	__TwigTemplate_af3255f4a26e139158aac2b1209ce55b->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 101)
12	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->block_body (line 171)
13	Twig\Template->displayBlock (line 151)
14	__TwigTemplate_9ef0bb04516dbab8b4b6128433c217b8->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 50)
17	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 48)
20	__TwigTemplate_65ab96a183564cdf6cd6f68b4f676084->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1241)
29	App\Controller\MainController->actions (line 178)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 119)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->forward (line 1275)
33	App\Controller\MainController->action (line 178)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	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.

Entities Mapping

Class	Mapping errors
App\Entity\Product	No errors.
App\Entity\Tire	No errors.
App\Entity\Disk	No errors.
App\Entity\Order	No errors.
App\Entity\InfoBlock	No errors.
App\Entity\Action	No errors.
App\Entity\InfoBlockGroup	No errors.
App\Entity\Town	No errors.

Symfony Profiler

GET https://tolyatti.test.kolex.ru/actions/current

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping