Symfony Profiler

Query Metrics

13 Database Queries

8 Different statements

11.03 ms Query time

0 Invalid entities

13 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

8.54 ms
(77.45%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Repository\CartRepository->createCart (line 138)
4	App\Repository\CartRepository->initAnonCart (line 166)
5	App\Repository\CartRepository->init (line 208)
6	App\EventListener\Locale\StickyListener->sessionListener (line 136)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 191)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

1.15 ms
(10.40%)

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.banner_type AS banner_type_2, b0_.banner_order AS banner_order_3, b0_.image_path AS image_path_4, b0_.destination AS destination_5, b0_.category_include AS category_include_6, b0_.category_exclude AS category_exclude_7, b0_.date_start AS date_start_8, b0_.date_end AS date_end_9, b0_.options AS options_10 FROM banners b0_ WHERE b0_.banner_type = ? AND b0_.date_start < ? AND (b0_.date_end > ? OR b0_.date_end IS NULL)

Parameters:

[
  "top_full_width"
  "2026-01-24 12:52:47"
  "2026-01-24 12:52:47"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.banner_type AS banner_type_2,
  b0_.banner_order AS banner_order_3,
  b0_.image_path AS image_path_4,
  b0_.destination AS destination_5,
  b0_.category_include AS category_include_6,
  b0_.category_exclude AS category_exclude_7,
  b0_.date_start AS date_start_8,
  b0_.date_end AS date_end_9,
  b0_.options AS options_10
FROM
  banners b0_
WHERE
  b0_.banner_type = ?
  AND b0_.date_start < ?
  AND (
    b0_.date_end > ?
    OR b0_.date_end IS NULL
  )

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.banner_type AS banner_type_2, b0_.banner_order AS banner_order_3, b0_.image_path AS image_path_4, b0_.destination AS destination_5, b0_.category_include AS category_include_6, b0_.category_exclude AS category_exclude_7, b0_.date_start AS date_start_8, b0_.date_end AS date_end_9, b0_.options AS options_10 FROM banners b0_ WHERE b0_.banner_type = 'top_full_width' AND b0_.date_start < '2026-01-24 12:52:47' AND (b0_.date_end > '2026-01-24 12:52:47' OR b0_.date_end IS NULL);

#	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	App\Repository\BannerRepository->getBannersByType (line 198)
6	App\Twig\BannersTwigExtension->get (line 43)
7	Twig\Extension\CoreExtension->getAttribute (line 1911)
8	__TwigTemplate_ed0deae518b22eee799934f275457306::doDisplay (line 57)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_7fbd3a8149458fae39102c246465a9a4->block_body (line 154)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_7fbd3a8149458fae39102c246465a9a4->doDisplay (line 112)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_26ff09c297da4a384f752f2804f0a61c->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_cd309de87d98e437266fb202fb00e40c->doDisplay (line 63)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	App\EventListener\Locale\PrefixListener->onKernelException (line 118)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
29	Symfony\Component\HttpKernel\Kernel->handle (line 191)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.57 ms
(5.14%)

SELECT r0_.target AS target_0, r0_.id AS id_1, r0_.source AS source_2, r0_.type AS type_3, r0_.updated_at AS updated_at_4, r0_.created_at AS created_at_5 FROM redirect_rules r0_ WHERE r0_.type = ? AND r0_.source LIKE ?

Parameters:

[
  "category"
  "/de/urjupinsk.html"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.target AS target_0,
  r0_.id AS id_1,
  r0_.source AS source_2,
  r0_.type AS type_3,
  r0_.updated_at AS updated_at_4,
  r0_.created_at AS created_at_5
FROM
  redirect_rules r0_
WHERE
  r0_.type = ?
  AND r0_.source LIKE ?

SELECT r0_.target AS target_0, r0_.id AS id_1, r0_.source AS source_2, r0_.type AS type_3, r0_.updated_at AS updated_at_4, r0_.created_at AS created_at_5 FROM redirect_rules r0_ WHERE r0_.type = 'category' AND r0_.source LIKE '/de/urjupinsk.html';

#	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\RedirectRepository->get (line 75)
7	App\EventListener\Locale\PrefixListener->getRedirectTarget (line 180)
8	App\EventListener\Locale\PrefixListener->onKernelException (line 97)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
15	Symfony\Component\HttpKernel\Kernel->handle (line 191)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

0.17 ms
(1.56%)

INSERT INTO wishlists (id, updated_at, created_at, customer_id) VALUES (?, ?, ?, ?)

Parameters:

[
  "019befd9-7ef9-7f32-b4db-6810d5d10213"
  "2026-01-24 12:52:47"
  "2026-01-24 12:52:47"
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO wishlists (
  id, updated_at, created_at, customer_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO wishlists (id, updated_at, created_at, customer_id) VALUES ('019befd9-7ef9-7f32-b4db-6810d5d10213', '2026-01-24 12:52:47', '2026-01-24 12:52:47', NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
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\Repository\WishlistRepository->createWishlist (line 109)
7	App\Repository\WishlistRepository->initAnonWishlist (line 133)
8	App\Repository\WishlistRepository->init (line 166)
9	App\EventListener\Locale\StickyListener->sessionListener (line 137)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 191)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.17 ms
(1.52%)

"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\Repository\CartRepository->createCart (line 138)
4	App\Repository\CartRepository->initAnonCart (line 166)
5	App\Repository\CartRepository->init (line 208)
6	App\EventListener\Locale\StickyListener->sessionListener (line 136)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 191)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

0.16 ms
(1.46%)

INSERT INTO carts (id, updated_at, created_at, customer_id) VALUES (?, ?, ?, ?)

Parameters:

[
  "019befd9-7ee9-7cc8-8c66-b5eb27130ae5"
  "2026-01-24 12:52:47"
  "2026-01-24 12:52:47"
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO carts (
  id, updated_at, created_at, customer_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO carts (id, updated_at, created_at, customer_id) VALUES ('019befd9-7ee9-7cc8-8c66-b5eb27130ae5', '2026-01-24 12:52:47', '2026-01-24 12:52:47', NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
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\Repository\CartRepository->createCart (line 138)
7	App\Repository\CartRepository->initAnonCart (line 166)
8	App\Repository\CartRepository->init (line 208)
9	App\EventListener\Locale\StickyListener->sessionListener (line 136)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 191)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.16 ms
(1.43%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.category_order AS category_order_3, t0.title_ru AS title_ru_4, t0.title_de AS title_de_5, t0.url_ru AS url_ru_6, t0.url_de AS url_de_7, t0.date_start AS date_start_8, t0.date_end AS date_end_9, t0.options AS options_10 FROM category_menu t0 WHERE t0.type IN (?, ?, ?, ?)

Parameters:

[
  "menu_main"
  "top_amount"
  "top_sold"
  "sale"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.category_order AS category_order_3,
  t0.title_ru AS title_ru_4,
  t0.title_de AS title_de_5,
  t0.url_ru AS url_ru_6,
  t0.url_de AS url_de_7,
  t0.date_start AS date_start_8,
  t0.date_end AS date_end_9,
  t0.options AS options_10
FROM
  category_menu t0
WHERE
  t0.type IN (?, ?, ?, ?)

SELECT t0.id AS id_1, t0.type AS type_2, t0.category_order AS category_order_3, t0.title_ru AS title_ru_4, t0.title_de AS title_de_5, t0.url_ru AS url_ru_6, t0.url_de AS url_de_7, t0.date_start AS date_start_8, t0.date_end AS date_end_9, t0.options AS options_10 FROM category_menu t0 WHERE t0.type IN ('menu_main', 'top_amount', 'top_sold', 'sale');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Repository\CategoryMenuRepository->getMenuPromoCategories (line 70)
5	App\Twig\SnippetExtension->getMenuPromoCategories (line 341)
6	__TwigTemplate_8d693ea6542a997963ca390fff678aaf->doDisplay (line 48)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_e7cfab21c445ac084b5aa1729105138d->doDisplay (line 155)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_7fbd3a8149458fae39102c246465a9a4->block_body (line 160)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_7fbd3a8149458fae39102c246465a9a4->doDisplay (line 112)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_26ff09c297da4a384f752f2804f0a61c->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_cd309de87d98e437266fb202fb00e40c->doDisplay (line 63)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	App\EventListener\Locale\PrefixListener->onKernelException (line 118)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
29	Symfony\Component\HttpKernel\Kernel->handle (line 191)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.11 ms
(1.02%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.category_order AS category_order_3, t0.title_ru AS title_ru_4, t0.title_de AS title_de_5, t0.url_ru AS url_ru_6, t0.url_de AS url_de_7, t0.date_start AS date_start_8, t0.date_end AS date_end_9, t0.options AS options_10 FROM category_menu t0 WHERE t0.type = ?

Parameters:

[
  "menu_mobile"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.category_order AS category_order_3,
  t0.title_ru AS title_ru_4,
  t0.title_de AS title_de_5,
  t0.url_ru AS url_ru_6,
  t0.url_de AS url_de_7,
  t0.date_start AS date_start_8,
  t0.date_end AS date_end_9,
  t0.options AS options_10
FROM
  category_menu t0
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.category_order AS category_order_3, t0.title_ru AS title_ru_4, t0.title_de AS title_de_5, t0.url_ru AS url_ru_6, t0.url_de AS url_de_7, t0.date_start AS date_start_8, t0.date_end AS date_end_9, t0.options AS options_10 FROM category_menu t0 WHERE t0.type = 'menu_mobile';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Repository\CategoryMenuRepository->getMenuPromoCategories (line 70)
5	App\Twig\SnippetExtension->getMenuPromoCategories (line 341)
6	__TwigTemplate_88bf3af06f260c1d791b317a88ff84ed->doDisplay (line 79)
7	Twig\Template->yield (line 402)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	App\Twig\SnippetExtension->menu (line 87)
12	__TwigTemplate_7fbd3a8149458fae39102c246465a9a4->block_custom_modals (line 343)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_7fbd3a8149458fae39102c246465a9a4->block_body (line 224)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_7fbd3a8149458fae39102c246465a9a4->doDisplay (line 112)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_26ff09c297da4a384f752f2804f0a61c->doDisplay (line 54)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_cd309de87d98e437266fb202fb00e40c->doDisplay (line 63)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	App\EventListener\Locale\PrefixListener->onKernelException (line 118)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
31	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
33	Symfony\Component\HttpKernel\Kernel->handle (line 191)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 32)
36	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

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\CategoryMenu	11
App\Entity\Cart	1
App\Entity\Wishlist	1

Entities Mapping

Class	Mapping errors
App\Entity\Cart	No errors.
App\Entity\CartItem	No errors.
App\Entity\Customer	No errors.
App\Entity\Wishlist	No errors.
App\Entity\WishlistItem	No errors.
App\Entity\RedirectRule	No errors.
App\Entity\CategoryMenu	No errors.

Symfony Profiler

GET https://www.posylka-test.colibo.io/de/urjupinsk.html

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping