Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.71 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.62 ms
(22.88%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.in_menu AS in_menu_4, t0.position AS position_5, t0.slug AS slug_6, t0.content AS content_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.parent_id AS parent_id_11 FROM regular_page t0 WHERE t0.active = ? AND t0.in_menu = ? ORDER BY t0.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.in_menu AS in_menu_4,
  t0.position AS position_5,
  t0.slug AS slug_6,
  t0.content AS content_7,
  t0.seo_title AS seo_title_8,
  t0.seo_description AS seo_description_9,
  t0.seo_keywords AS seo_keywords_10,
  t0.parent_id AS parent_id_11
FROM
  regular_page t0
WHERE
  t0.active = ?
  AND t0.in_menu = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.in_menu AS in_menu_4, t0.position AS position_5, t0.slug AS slug_6, t0.content AS content_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.parent_id AS parent_id_11 FROM regular_page t0 WHERE t0.active = 1 AND t0.in_menu = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 27)
5	App\Service\MenuGenerator->generatePagesMenu (line 1754)
6	Twig\Extension\CoreExtension::getAttribute (line 52)
7	__TwigTemplate_a2107754e636a7edb9ea3997a9a80872->doDisplay (line 393)
8	Twig\Template->yield (line 54)
9	__TwigTemplate_3c9100dff9660de244b289d27b3252d0->doDisplay (line 393)
10	Twig\Template->yield (line 349)
11	Twig\Template->display (line 364)
12	Twig\Template->render (line 35)
13	Twig\TemplateWrapper->render (line 306)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 121)
18	App\Controller\PagesController->showDeliveryPage (line 178)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.59 ms
(21.74%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.in_menu AS in_menu_4, t0.position AS position_5, t0.slug AS slug_6, t0.content AS content_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.parent_id AS parent_id_11 FROM regular_page t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1

Parameters:

[
  "delivery"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.in_menu AS in_menu_4,
  t0.position AS position_5,
  t0.slug AS slug_6,
  t0.content AS content_7,
  t0.seo_title AS seo_title_8,
  t0.seo_description AS seo_description_9,
  t0.seo_keywords AS seo_keywords_10,
  t0.parent_id AS parent_id_11
FROM
  regular_page t0
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.in_menu AS in_menu_4, t0.position AS position_5, t0.slug AS slug_6, t0.content AS content_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.parent_id AS parent_id_11 FROM regular_page t0 WHERE t0.slug = 'delivery' AND t0.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 73)
5	App\Controller\PagesController->defineReguralPage (line 108)
6	App\Controller\PagesController->showDeliveryPage (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.54 ms
(20.05%)

SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.slug AS slug_4, t0.position AS position_5, t0.external_id AS external_id_6 FROM category t0 WHERE t0.active = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.position AS position_5,
  t0.external_id AS external_id_6
FROM
  category t0
WHERE
  t0.active = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.slug AS slug_4, t0.position AS position_5, t0.external_id AS external_id_6 FROM category t0 WHERE t0.active = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 37)
5	App\Service\MenuGenerator->generateCategoriesMenu (line 1754)
6	Twig\Extension\CoreExtension::getAttribute (line 55)
7	__TwigTemplate_e92b6ed69b1c86b5a48227605de24118->doDisplay (line 393)
8	Twig\Template->yield (line 121)
9	__TwigTemplate_3c9100dff9660de244b289d27b3252d0->block_body (line 437)
10	Twig\Template->yieldBlock (line 67)
11	__TwigTemplate_a2107754e636a7edb9ea3997a9a80872->doDisplay (line 393)
12	Twig\Template->yield (line 54)
13	__TwigTemplate_3c9100dff9660de244b289d27b3252d0->doDisplay (line 393)
14	Twig\Template->yield (line 349)
15	Twig\Template->display (line 364)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 306)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 121)
22	App\Controller\PagesController->showDeliveryPage (line 178)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.50 ms
(18.34%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.content AS content_4 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.content AS content_4
FROM
  setting t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.content AS content_4 FROM setting t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 24)
6	App\Service\SettingsManager->load (line 33)
7	App\Service\SettingsManager->get (line 45)
8	App\Service\SettingsManager->mergeSeoParams (line 119)
9	App\Controller\PagesController->showDeliveryPage (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.46 ms
(16.99%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.organization_id AS organization_id_3, t0.coordinates AS coordinates_4, t0.color AS color_5, t0.min_sum AS min_sum_6, t0.delivery_cost AS delivery_cost_7, t0.delivery_cost_plus AS delivery_cost_plus_8 FROM delivery_zone t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.organization_id AS organization_id_3,
  t0.coordinates AS coordinates_4,
  t0.color AS color_5,
  t0.min_sum AS min_sum_6,
  t0.delivery_cost AS delivery_cost_7,
  t0.delivery_cost_plus AS delivery_cost_plus_8
FROM
  delivery_zone t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.organization_id AS organization_id_3, t0.coordinates AS coordinates_4, t0.color AS color_5, t0.min_sum AS min_sum_6, t0.delivery_cost AS delivery_cost_7, t0.delivery_cost_plus AS delivery_cost_plus_8 FROM delivery_zone t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 110)
6	App\Controller\PagesController->showDeliveryPage (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\RegularPage	No errors.
App\Entity\DeliveryZone	No errors.
App\Entity\Setting	No errors.
App\Entity\Category	No errors.
App\Entity\Product	No errors.

Symfony Profiler

GET https://dev.riva-siberia.ru/delivery

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping