Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.34 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.08 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:

[
  "01a10d6d-0464-7656-82d3-ca033410f146"
]

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 = '01a10d6d-0464-7656-82d3-ca033410f146';

#	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.11 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:

[
  "01a10d6d-046d-7799-9703-2a461442d5f1"
]

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 = '01a10d6d-046d-7799-9703-2a461442d5f1';

#	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.14 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_1','freezebox_filter_3','sparset_filter_0','family_1072','fleischart_15470','family_1078','family_1101','vendor_357','vendor_42','vendor_531','fischart_29998','sparset_filter_1','family_1286','family_1220','fischart_29660','fleischart_15474','family_1106','vendor_751','fischart_54823','family_1080','vendor_1255','fischart_36125','vendor_477','fischart_37803','vendor_1179','fleischart_47539','family_1035','vendor_1316','vendor_752','serie_39534','vendor_1383','vendor_1462','family_1074','vendor_914','fischart_38548','vendor_1027','family_1266','fischart_29999','serie_44736','vendor_1372','vendor_1464','vendor_621','vendor_664','family_1225','family_1265','serie_39538','vendor_1311','vendor_1555','fischart_29740','fleischart_30153','vendor_1455','vendor_1574','vendor_519','vendor_642','vendor_666','vendor_728','family_1118','family_1173','family_1271','fischart_29659','fischart_30000','serie_55386','vendor_1312','family_1226','family_1246','family_1272','fischart_52858','fischart_57425','serie_27405','serie_37454','vendor_1449','vendor_1505','vendor_1577','vendor_1658','vendor_224','vendor_386','vendor_458','vendor_665','vendor_679','vendor_750','vendor_755','vendor_869','vendor_910','vendor_944','family_1105','fischart_37804','fischart_37812','fischart_39433','fischart_43299','fischart_43320','fischart_45346','fischart_52490','fischart_54243','fischart_54516','fischart_54769','fleischart_47119','netto_fuellmenge_filter_5','serie_39536','serie_39537','serie_39540','serie_41382','vendor_1141','vendor_1173','vendor_1373','vendor_1463','vendor_1506','vendor_1592','vendor_1608','vendor_1660','vendor_517','vendor_641','vendor_677','vendor_757','vendor_814','vendor_874','vendor_883','vendor_901','vendor_981') 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_1', 'freezebox_filter_3',
    'sparset_filter_0', 'family_1072',
    'fleischart_15470', 'family_1078',
    'family_1101', 'vendor_357', 'vendor_42',
    'vendor_531', 'fischart_29998',
    'sparset_filter_1', 'family_1286',
    'family_1220', 'fischart_29660',
    'fleischart_15474', 'family_1106',
    'vendor_751', 'fischart_54823',
    'family_1080', 'vendor_1255', 'fischart_36125',
    'vendor_477', 'fischart_37803',
    'vendor_1179', 'fleischart_47539',
    'family_1035', 'vendor_1316', 'vendor_752',
    'serie_39534', 'vendor_1383', 'vendor_1462',
    'family_1074', 'vendor_914', 'fischart_38548',
    'vendor_1027', 'family_1266', 'fischart_29999',
    'serie_44736', 'vendor_1372', 'vendor_1464',
    'vendor_621', 'vendor_664', 'family_1225',
    'family_1265', 'serie_39538', 'vendor_1311',
    'vendor_1555', 'fischart_29740',
    'fleischart_30153', 'vendor_1455',
    'vendor_1574', 'vendor_519', 'vendor_642',
    'vendor_666', 'vendor_728', 'family_1118',
    'family_1173', 'family_1271', 'fischart_29659',
    'fischart_30000', 'serie_55386',
    'vendor_1312', 'family_1226', 'family_1246',
    'family_1272', 'fischart_52858',
    'fischart_57425', 'serie_27405',
    'serie_37454', 'vendor_1449', 'vendor_1505',
    'vendor_1577', 'vendor_1658', 'vendor_224',
    'vendor_386', 'vendor_458', 'vendor_665',
    'vendor_679', 'vendor_750', 'vendor_755',
    'vendor_869', 'vendor_910', 'vendor_944',
    'family_1105', 'fischart_37804',
    'fischart_37812', 'fischart_39433',
    'fischart_43299', 'fischart_43320',
    'fischart_45346', 'fischart_52490',
    'fischart_54243', 'fischart_54516',
    'fischart_54769', 'fleischart_47119',
    'netto_fuellmenge_filter_5', 'serie_39536',
    'serie_39537', 'serie_39540', 'serie_41382',
    'vendor_1141', 'vendor_1173', 'vendor_1373',
    'vendor_1463', 'vendor_1506', 'vendor_1592',
    'vendor_1608', 'vendor_1660', 'vendor_517',
    'vendor_641', 'vendor_677', 'vendor_757',
    'vendor_814', 'vendor_874', 'vendor_883',
    'vendor_901', 'vendor_981'
  )
  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_1','freezebox_filter_3','sparset_filter_0','family_1072','fleischart_15470','family_1078','family_1101','vendor_357','vendor_42','vendor_531','fischart_29998','sparset_filter_1','family_1286','family_1220','fischart_29660','fleischart_15474','family_1106','vendor_751','fischart_54823','family_1080','vendor_1255','fischart_36125','vendor_477','fischart_37803','vendor_1179','fleischart_47539','family_1035','vendor_1316','vendor_752','serie_39534','vendor_1383','vendor_1462','family_1074','vendor_914','fischart_38548','vendor_1027','family_1266','fischart_29999','serie_44736','vendor_1372','vendor_1464','vendor_621','vendor_664','family_1225','family_1265','serie_39538','vendor_1311','vendor_1555','fischart_29740','fleischart_30153','vendor_1455','vendor_1574','vendor_519','vendor_642','vendor_666','vendor_728','family_1118','family_1173','family_1271','fischart_29659','fischart_30000','serie_55386','vendor_1312','family_1226','family_1246','family_1272','fischart_52858','fischart_57425','serie_27405','serie_37454','vendor_1449','vendor_1505','vendor_1577','vendor_1658','vendor_224','vendor_386','vendor_458','vendor_665','vendor_679','vendor_750','vendor_755','vendor_869','vendor_910','vendor_944','family_1105','fischart_37804','fischart_37812','fischart_39433','fischart_43299','fischart_43320','fischart_45346','fischart_52490','fischart_54243','fischart_54516','fischart_54769','fleischart_47119','netto_fuellmenge_filter_5','serie_39536','serie_39537','serie_39540','serie_41382','vendor_1141','vendor_1173','vendor_1373','vendor_1463','vendor_1506','vendor_1592','vendor_1608','vendor_1660','vendor_517','vendor_641','vendor_677','vendor_757','vendor_814','vendor_874','vendor_883','vendor_901','vendor_981') 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	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
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\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/de/frische-kuehlung-c2748.html

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping