Symfony Profiler

Query Metrics

9 Database Queries

8 Different statements

8.34 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.19 ms
(38.20%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 433)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Service\CartContext->getOrCreate (line 123)
5	App\Controller\Catalog\CartController->index (line 31)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

1.30 ms
(15.58%)

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_d491aa3bc3a01c2cd37e048f4041aa6b->doDisplay (line 54)
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\CartController->index (line 60)
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)

1.18 ms
(14.09%)

INSERT INTO cart (id, user_id, token, currency, pricing_policy, subtotal, discount_total, total, created_at, updated_at, expires_at, shipping_method, shipping_cost, ship_to_city, shipping_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  b"\x01Ÿ…Ü4y\x02õ–«‰H=èÑ+"
  null
  "06975032-9836-4ace-847c-d8c38ac1f6eb"
  "RUB"
  "SNAPSHOT"
  0
  0
  0
  "2026-07-21 21:07:08"
  "2026-07-21 21:07:08"
  "2027-01-17 21:07:08"
  null
  0
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO cart (
  id, user_id, token, currency, pricing_policy,
  subtotal, discount_total, total,
  created_at, updated_at, expires_at,
  shipping_method, shipping_cost,
  ship_to_city, shipping_data
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO cart (id, user_id, token, currency, pricing_policy, subtotal, discount_total, total, created_at, updated_at, expires_at, shipping_method, shipping_cost, ship_to_city, shipping_data) VALUES (0x019F85DC347902F596AB89483DE8D12B, NULL, '06975032-9836-4ace-847c-d8c38ac1f6eb', 'RUB', 'SNAPSHOT', 0, 0, 0, '2026-07-21 21:07:08', '2026-07-21 21:07:08', '2027-01-17 21:07:08', NULL, 0, NULL, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\CartContext->getOrCreate (line 123)
7	App\Controller\Catalog\CartController->index (line 31)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.11 ms
(13.34%)

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)

0.46 ms
(5.49%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\CartContext->getOrCreate (line 123)
4	App\Controller\Catalog\CartController->index (line 31)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.42 ms
(5.04%)

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.active = ? ORDER BY t0.sort_order ASC

Parameters:

[
  1
]

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.active = ?
ORDER BY
  t0.sort_order ASC

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.active = 1 ORDER BY t0.sort_order ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\Catalog\CartController->index (line 36)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.36 ms
(4.34%)

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_d491aa3bc3a01c2cd37e048f4041aa6b->doDisplay (line 54)
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\CartController->index (line 60)
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.33 ms
(3.92%)

SELECT version FROM cart WHERE id = ?

Parameters:

[
  b"\x01Ÿ…Ü4y\x02õ–«‰H=èÑ+"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  version
FROM
  cart
WHERE
  id = ?

SELECT version FROM cart WHERE id = 0x019F85DC347902F596AB89483DE8D12B;

#	File/Call
1	Doctrine\DBAL\Connection->fetchNumeric (line 610)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->fetchVersionAndNotUpsertableValues (line 324)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->assignDefaultVersionAndUpsertableValues (line 290)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 265)
5	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
6	Doctrine\ORM\UnitOfWork->commit (line 403)
7	Doctrine\ORM\EntityManager->flush (line 268)
8	App\Service\CartContext->getOrCreate (line 123)
9	App\Controller\Catalog\CartController->index (line 31)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	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\Cart	1

Entities Mapping

Class	Mapping errors
App\Entity\DeliveryType	No errors.
App\Entity\Cart	No errors.
App\Entity\CartItem	No errors.
App\Entity\Category	No errors.

Symfony Profiler

GET https://www.moms-pocket.ru/public/cart

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping