Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.36 ms Query time

0 Invalid entities

2 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲

Time

Info

0.09 ms

SELECT t0.id AS id_1, t0.country AS country_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.customer_id AS customer_id_5, t0.last_order_id AS last_order_id_6 FROM carts t0 WHERE t0.id = ?

Parameters:

[
  "01a10d92-77bc-7700-b3a6-0bab509c05ec"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.country AS country_2,
  t0.updated_at AS updated_at_3,
  t0.created_at AS created_at_4,
  t0.customer_id AS customer_id_5,
  t0.last_order_id AS last_order_id_6
FROM
  carts t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.country AS country_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.customer_id AS customer_id_5, t0.last_order_id AS last_order_id_6 FROM carts t0 WHERE t0.id = '01a10d92-77bc-7700-b3a6-0bab509c05ec';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	App\Repository\CartRepository->initAnonCart (line 216)
7	App\Repository\CartRepository->init (line 263)
8	App\EventListener\Locale\StickyListener->sessionListener (line 125)
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 129)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 191)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	require_once (line 5)

0.07 ms

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.customer_id AS customer_id_4 FROM wishlists t0 WHERE t0.id = ?

Parameters:

[
  "01a10d92-77c3-72c6-935b-98c824893c5f"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.created_at AS created_at_3,
  t0.customer_id AS customer_id_4
FROM
  wishlists t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.customer_id AS customer_id_4 FROM wishlists t0 WHERE t0.id = '01a10d92-77c3-72c6-935b-98c824893c5f';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	App\Repository\WishlistRepository->initAnonWishlist (line 129)
7	App\Repository\WishlistRepository->init (line 166)
8	App\EventListener\Locale\StickyListener->sessionListener (line 126)
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 129)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 191)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	require_once (line 5)

0.20 ms

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('coolbox_filter_0','freezebox_filter_3','sparset_filter_0','family_376','family_1073','family_589','vendor_1258','vendor_482','vendor_1135','vendor_1016','family_699','family_629','family_886','vendor_486','vendor_186','vendor_1031','vendor_192','vendor_553','vendor_171','vendor_1133','vendor_316','vendor_743','vendor_1104','vendor_1422','vendor_414','vendor_991','vendor_1289','vendor_1297','vendor_1593','vendor_1606','vendor_552','vendor_772','netto_fuellmenge_filter_3','vendor_1483','vendor_166','vendor_274','vendor_745','netto_fuellmenge_filter_5','vendor_1018','vendor_114','vendor_1302','vendor_554','vendor_744','vendor_1138','vendor_1309','vendor_1319','vendor_1347','vendor_1440','vendor_1624','vendor_187','family_1055','netto_fuellmenge_filter_4','netto_fuellmenge_filter_6','sparset_filter_1','vendor_1091','vendor_1112','vendor_1213','vendor_1299','vendor_1354','vendor_1358','vendor_1394','vendor_1441','vendor_1461','vendor_1617','vendor_212','vendor_225','vendor_256','vendor_291','vendor_438','vendor_551','vendor_785') 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(
    'coolbox_filter_0', 'freezebox_filter_3',
    'sparset_filter_0', 'family_376',
    'family_1073', 'family_589', 'vendor_1258',
    'vendor_482', 'vendor_1135', 'vendor_1016',
    'family_699', 'family_629', 'family_886',
    'vendor_486', 'vendor_186', 'vendor_1031',
    'vendor_192', 'vendor_553', 'vendor_171',
    'vendor_1133', 'vendor_316', 'vendor_743',
    'vendor_1104', 'vendor_1422', 'vendor_414',
    'vendor_991', 'vendor_1289', 'vendor_1297',
    'vendor_1593', 'vendor_1606', 'vendor_552',
    'vendor_772', 'netto_fuellmenge_filter_3',
    'vendor_1483', 'vendor_166', 'vendor_274',
    'vendor_745', 'netto_fuellmenge_filter_5',
    'vendor_1018', 'vendor_114', 'vendor_1302',
    'vendor_554', 'vendor_744', 'vendor_1138',
    'vendor_1309', 'vendor_1319', 'vendor_1347',
    'vendor_1440', 'vendor_1624', 'vendor_187',
    'family_1055', 'netto_fuellmenge_filter_4',
    'netto_fuellmenge_filter_6', 'sparset_filter_1',
    'vendor_1091', 'vendor_1112', 'vendor_1213',
    'vendor_1299', 'vendor_1354', 'vendor_1358',
    'vendor_1394', 'vendor_1441', 'vendor_1461',
    'vendor_1617', 'vendor_212', 'vendor_225',
    'vendor_256', 'vendor_291', 'vendor_438',
    'vendor_551', 'vendor_785'
  )
  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('coolbox_filter_0','freezebox_filter_3','sparset_filter_0','family_376','family_1073','family_589','vendor_1258','vendor_482','vendor_1135','vendor_1016','family_699','family_629','family_886','vendor_486','vendor_186','vendor_1031','vendor_192','vendor_553','vendor_171','vendor_1133','vendor_316','vendor_743','vendor_1104','vendor_1422','vendor_414','vendor_991','vendor_1289','vendor_1297','vendor_1593','vendor_1606','vendor_552','vendor_772','netto_fuellmenge_filter_3','vendor_1483','vendor_166','vendor_274','vendor_745','netto_fuellmenge_filter_5','vendor_1018','vendor_114','vendor_1302','vendor_554','vendor_744','vendor_1138','vendor_1309','vendor_1319','vendor_1347','vendor_1440','vendor_1624','vendor_187','family_1055','netto_fuellmenge_filter_4','netto_fuellmenge_filter_6','sparset_filter_1','vendor_1091','vendor_1112','vendor_1213','vendor_1299','vendor_1354','vendor_1358','vendor_1394','vendor_1441','vendor_1461','vendor_1617','vendor_212','vendor_225','vendor_256','vendor_291','vendor_438','vendor_551','vendor_785') AND  a.is_filterable = true;

#	File/Call
1	Doctrine\DBAL\Statement->executeQuery (line 119)
2	App\Repository\AttributeRepository->getRawFilters (line 73)
3	App\Component\CategoryFilter->parseSelectedFilters (line 32)
4	App\Controller\Pages\DocumentController->categoryDetailAction (line 418)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	App\Controller\AppController->forward (line 165)
8	App\Controller\Pages\LegacyController->forwardCategory (line 135)
9	App\Controller\Pages\LegacyController->indexAction (line 50)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
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

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\Customer	No errors.
App\Entity\Order	No errors.
App\Entity\CartItem	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/ru/produkty-pitaniya/napitki-kofe-chay.html?direction=desc&page=6

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping