Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

3.65 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.03 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.active AS active_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6 FROM delivery_type t0 WHERE t0.is_default = ? AND t0.active = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.active AS active_4,
  t0.sort_order AS sort_order_5,
  t0.is_default AS is_default_6
FROM
  delivery_type t0
WHERE
  t0.is_default = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.active AS active_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6 FROM delivery_type t0 WHERE t0.is_default = 1 AND t0.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\EventSubscriber\DeliveryDefaultSubscriber->onKernelRequest (line 63)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

1.49 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visibility AS visibility_2, c0_.parent_category_id AS parent_category_id_3, c0_.meta_title AS meta_title_4, c0_.meta_description AS meta_description_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_h1 AS meta_h1_7, c0_.description AS description_8, c0_.navbar_visibility AS navbar_visibility_9, c0_.footer_visibility AS footer_visibility_10, c0_.slug AS slug_11, c0_.sort_order AS sort_order_12 FROM category c0_ WHERE c0_.navbar_visibility = ? AND c0_.visibility = ? AND c0_.name IS NOT NULL ORDER BY c0_.sort_order ASC, c0_.name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.visibility AS visibility_2,
  c0_.parent_category_id AS parent_category_id_3,
  c0_.meta_title AS meta_title_4,
  c0_.meta_description AS meta_description_5,
  c0_.meta_keywords AS meta_keywords_6,
  c0_.meta_h1 AS meta_h1_7,
  c0_.description AS description_8,
  c0_.navbar_visibility AS navbar_visibility_9,
  c0_.footer_visibility AS footer_visibility_10,
  c0_.slug AS slug_11,
  c0_.sort_order AS sort_order_12
FROM
  category c0_
WHERE
  c0_.navbar_visibility = ?
  AND c0_.visibility = ?
  AND c0_.name IS NOT NULL
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visibility AS visibility_2, c0_.parent_category_id AS parent_category_id_3, c0_.meta_title AS meta_title_4, c0_.meta_description AS meta_description_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_h1 AS meta_h1_7, c0_.description AS description_8, c0_.navbar_visibility AS navbar_visibility_9, c0_.footer_visibility AS footer_visibility_10, c0_.slug AS slug_11, c0_.sort_order AS sort_order_12 FROM category c0_ WHERE c0_.navbar_visibility = 1 AND c0_.visibility = 1 AND c0_.name IS NOT NULL ORDER BY c0_.sort_order ASC, c0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CategoryRepository->findByNavbarVisibility (line 84)
7	App\Service\NavbarCategoryService->getNavbarCategories (line 35)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_91f4b107cd89a9eb9a106438c69923d2::doDisplay (line 468)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_8da9c83dd6e2988435e916e165f6cf69->block_catalog_header (line 251)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_8da9c83dd6e2988435e916e165f6cf69->block_body (line 196)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_3d6567547be14814a08b0369c65e4783->doDisplay (line 98)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_8da9c83dd6e2988435e916e165f6cf69->doDisplay (line 61)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_285399b36471c978d963f47a4fcf5ccd->doDisplay (line 55)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
28	App\Controller\Catalog\InfoController->dostavka (line 127)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

0.63 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visibility AS visibility_2, c0_.parent_category_id AS parent_category_id_3, c0_.meta_title AS meta_title_4, c0_.meta_description AS meta_description_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_h1 AS meta_h1_7, c0_.description AS description_8, c0_.navbar_visibility AS navbar_visibility_9, c0_.footer_visibility AS footer_visibility_10, c0_.slug AS slug_11, c0_.sort_order AS sort_order_12 FROM category c0_ WHERE c0_.navbar_visibility = ? AND c0_.visibility = ? AND c0_.name IS NOT NULL ORDER BY c0_.sort_order ASC, c0_.name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.visibility AS visibility_2,
  c0_.parent_category_id AS parent_category_id_3,
  c0_.meta_title AS meta_title_4,
  c0_.meta_description AS meta_description_5,
  c0_.meta_keywords AS meta_keywords_6,
  c0_.meta_h1 AS meta_h1_7,
  c0_.description AS description_8,
  c0_.navbar_visibility AS navbar_visibility_9,
  c0_.footer_visibility AS footer_visibility_10,
  c0_.slug AS slug_11,
  c0_.sort_order AS sort_order_12
FROM
  category c0_
WHERE
  c0_.navbar_visibility = ?
  AND c0_.visibility = ?
  AND c0_.name IS NOT NULL
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visibility AS visibility_2, c0_.parent_category_id AS parent_category_id_3, c0_.meta_title AS meta_title_4, c0_.meta_description AS meta_description_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_h1 AS meta_h1_7, c0_.description AS description_8, c0_.navbar_visibility AS navbar_visibility_9, c0_.footer_visibility AS footer_visibility_10, c0_.slug AS slug_11, c0_.sort_order AS sort_order_12 FROM category c0_ WHERE c0_.navbar_visibility = 1 AND c0_.visibility = 1 AND c0_.name IS NOT NULL ORDER BY c0_.sort_order ASC, c0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CategoryRepository->findByNavbarVisibility (line 84)
7	App\Service\NavbarCategoryService->getNavbarCategories (line 35)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_225b7d462b9557308daf0c480fccfe30::doDisplay (line 64)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_8da9c83dd6e2988435e916e165f6cf69->block_catalog_navbar (line 278)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_8da9c83dd6e2988435e916e165f6cf69->block_body (line 199)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_3d6567547be14814a08b0369c65e4783->doDisplay (line 98)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_8da9c83dd6e2988435e916e165f6cf69->doDisplay (line 61)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_285399b36471c978d963f47a4fcf5ccd->doDisplay (line 55)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
28	App\Controller\Catalog\InfoController->dostavka (line 127)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

0.49 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visibility AS visibility_2, c0_.parent_category_id AS parent_category_id_3, c0_.meta_title AS meta_title_4, c0_.meta_description AS meta_description_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_h1 AS meta_h1_7, c0_.description AS description_8, c0_.navbar_visibility AS navbar_visibility_9, c0_.footer_visibility AS footer_visibility_10, c0_.slug AS slug_11, c0_.sort_order AS sort_order_12 FROM category c0_ WHERE c0_.footer_visibility = ? AND c0_.visibility = ? AND c0_.name IS NOT NULL ORDER BY c0_.sort_order ASC, c0_.name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.visibility AS visibility_2,
  c0_.parent_category_id AS parent_category_id_3,
  c0_.meta_title AS meta_title_4,
  c0_.meta_description AS meta_description_5,
  c0_.meta_keywords AS meta_keywords_6,
  c0_.meta_h1 AS meta_h1_7,
  c0_.description AS description_8,
  c0_.navbar_visibility AS navbar_visibility_9,
  c0_.footer_visibility AS footer_visibility_10,
  c0_.slug AS slug_11,
  c0_.sort_order AS sort_order_12
FROM
  category c0_
WHERE
  c0_.footer_visibility = ?
  AND c0_.visibility = ?
  AND c0_.name IS NOT NULL
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visibility AS visibility_2, c0_.parent_category_id AS parent_category_id_3, c0_.meta_title AS meta_title_4, c0_.meta_description AS meta_description_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_h1 AS meta_h1_7, c0_.description AS description_8, c0_.navbar_visibility AS navbar_visibility_9, c0_.footer_visibility AS footer_visibility_10, c0_.slug AS slug_11, c0_.sort_order AS sort_order_12 FROM category c0_ WHERE c0_.footer_visibility = 1 AND c0_.visibility = 1 AND c0_.name IS NOT NULL ORDER BY c0_.sort_order ASC, c0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CategoryRepository->findByFooterVisibility (line 67)
7	App\Service\FooterCategoryService->getFooterCategories (line 20)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_3dbb407b80d297ebf64cf1022470e243::doDisplay (line 55)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_8da9c83dd6e2988435e916e165f6cf69->block_catalog_footer (line 343)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_8da9c83dd6e2988435e916e165f6cf69->block_body (line 223)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_3d6567547be14814a08b0369c65e4783->doDisplay (line 98)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_8da9c83dd6e2988435e916e165f6cf69->doDisplay (line 61)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_285399b36471c978d963f47a4fcf5ccd->doDisplay (line 55)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
28	App\Controller\Catalog\InfoController->dostavka (line 127)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	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

Entities Mapping

Class	Mapping errors
App\Entity\DeliveryType	No errors.
App\Entity\City	No errors.
App\Entity\Category	No errors.

Symfony Profiler

GET https://www.moms-pocket.ru/dostavka

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping