Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

9.60 ms Query time

0 Invalid entities

2 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

8.26 ms
(86.05%)

"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)

0.50 ms
(5.22%)

SELECT a.id as group_id, a.code, a.name_ru, a.name_de, a.sort, 
			a.is_metric, a.is_deeplink, a.is_filterable, a.use_deeplink_code, 
			a.group_sort, a.group_name_ru, a.group_name_de,
			av.uid as value_id,  av.name_ru as value_ru, av.name_de as value_de
FROM attribute_value AS av
JOIN attribute AS a on a.code = av.code
WHERE av.uid IN('family_880','netto_gewicht_filter_5','art_52773','verpackung_2954','geschmack_52741','vendor_1212','coolbox_filter_0','freezebox_filter_3') AND  a.is_filterable = true

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a.id as group_id,
  a.code,
  a.name_ru,
  a.name_de,
  a.sort,
  a.is_metric,
  a.is_deeplink,
  a.is_filterable,
  a.use_deeplink_code,
  a.group_sort,
  a.group_name_ru,
  a.group_name_de,
  av.uid as value_id,
  av.name_ru as value_ru,
  av.name_de as value_de
FROM
  attribute_value AS av
  JOIN attribute AS a on a.code = av.code
WHERE
  av.uid IN(
    'family_880', 'netto_gewicht_filter_5',
    'art_52773', 'verpackung_2954',
    'geschmack_52741', 'vendor_1212',
    'coolbox_filter_0', 'freezebox_filter_3'
  )
  AND a.is_filterable = true

SELECT a.id as group_id, a.code, a.name_ru, a.name_de, a.sort, 
			a.is_metric, a.is_deeplink, a.is_filterable, a.use_deeplink_code, 
			a.group_sort, a.group_name_ru, a.group_name_de,
			av.uid as value_id,  av.name_ru as value_ru, av.name_de as value_de
FROM attribute_value AS av
JOIN attribute AS a on a.code = av.code
WHERE av.uid IN('family_880','netto_gewicht_filter_5','art_52773','verpackung_2954','geschmack_52741','vendor_1212','coolbox_filter_0','freezebox_filter_3') AND  a.is_filterable = true;

#	File/Call
1	Doctrine\DBAL\Statement->executeQuery (line 119)
2	App\Repository\AttributeRepository->getRawFilters (line 67)
3	App\Component\CategoryFilter->parseSelectedFilters (line 25)
4	App\Controller\Pages\DocumentController->categoryDetailAction (line 358)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.26 ms
(2.70%)

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

Parameters:

[
  "019beeb0-44c5-75bd-8cf3-952e196eecf1"
  "2026-01-24 07:28:08"
  "2026-01-24 07:28:08"
  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 ('019beeb0-44c5-75bd-8cf3-952e196eecf1', '2026-01-24 07:28:08', '2026-01-24 07:28:08', 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.25 ms
(2.66%)

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

Parameters:

[
  "019beeb0-44d2-7167-8c43-cf589fa82de0"
  "2026-01-24 07:28:08"
  "2026-01-24 07:28:08"
  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 ('019beeb0-44d2-7167-8c43-cf589fa82de0', '2026-01-24 07:28:08', '2026-01-24 07:28:08', 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.18 ms
(1.85%)

"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.15 ms
(1.52%)

SELECT code FROM attribute WHERE is_filterable = true

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  code
FROM
  attribute
WHERE
  is_filterable = true

SELECT code FROM attribute WHERE is_filterable = true;

#	File/Call
1	Doctrine\DBAL\Statement->executeQuery (line 119)
2	App\Repository\AttributeRepository->getGroupCodes (line 82)
3	App\Component\CategoryFilter->buildFiltersTree (line 63)
4	App\Controller\Pages\DocumentController->categoryDetailAction (line 375)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	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\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\Attribute	No errors.

Symfony Profiler

GET https://www.posylka-test.colibo.io/de/zuckerfreie-lebensmittel-c2693.html

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping