Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.37 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.12 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:

[
  "01a10bfa-6b64-71af-9bb1-6e9e8849a625"
]

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 = '01a10bfa-6b64-71af-9bb1-6e9e8849a625';

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

[
  "01a10bfa-6b6c-7924-9fad-cba986c9ddc8"
]

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 = '01a10bfa-6b6c-7924-9fad-cba986c9ddc8';

#	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.13 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('sparset_filter_0','anwendungsgebiet_30910','hauttyp_351','family_238','netto_fuellmenge_filter_3','family_491','vendor_879','netto_fuellmenge_filter_2','netto_fuellmenge_filter_4','family_255','netto_fuellmenge_filter_1','anwendungsgebiet_30906','serie_29565','vendor_137','family_231','netto_fuellmenge_filter_5','family_970','vendor_29','hauttyp_353','anwendungsgebiet_30919','serie_56621','vendor_46','vendor_469','vendor_1040','vendor_1434','vendor_847','vendor_873','hauttyp_357','serie_54615','family_217','family_237','family_306','family_525','vendor_16','vendor_1647','anwendungsgebiet_30890','family_242','hauttyp_355','haar_typ_1819','vendor_1062','vendor_1209','vendor_43','vendor_710','vendor_840','family_230','family_244','family_985','hauttyp_2285','serie_50789','serie_56190','serie_56314','serie_56315','vendor_1244','vendor_1425','vendor_1502','vendor_388','vendor_476','vendor_546','vendor_712','vendor_886') 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(
    'sparset_filter_0', 'anwendungsgebiet_30910',
    'hauttyp_351', 'family_238', 'netto_fuellmenge_filter_3',
    'family_491', 'vendor_879', 'netto_fuellmenge_filter_2',
    'netto_fuellmenge_filter_4', 'family_255',
    'netto_fuellmenge_filter_1', 'anwendungsgebiet_30906',
    'serie_29565', 'vendor_137', 'family_231',
    'netto_fuellmenge_filter_5', 'family_970',
    'vendor_29', 'hauttyp_353', 'anwendungsgebiet_30919',
    'serie_56621', 'vendor_46', 'vendor_469',
    'vendor_1040', 'vendor_1434', 'vendor_847',
    'vendor_873', 'hauttyp_357', 'serie_54615',
    'family_217', 'family_237', 'family_306',
    'family_525', 'vendor_16', 'vendor_1647',
    'anwendungsgebiet_30890', 'family_242',
    'hauttyp_355', 'haar_typ_1819',
    'vendor_1062', 'vendor_1209', 'vendor_43',
    'vendor_710', 'vendor_840', 'family_230',
    'family_244', 'family_985', 'hauttyp_2285',
    'serie_50789', 'serie_56190', 'serie_56314',
    'serie_56315', 'vendor_1244', 'vendor_1425',
    'vendor_1502', 'vendor_388', 'vendor_476',
    'vendor_546', 'vendor_712', 'vendor_886'
  )
  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('sparset_filter_0','anwendungsgebiet_30910','hauttyp_351','family_238','netto_fuellmenge_filter_3','family_491','vendor_879','netto_fuellmenge_filter_2','netto_fuellmenge_filter_4','family_255','netto_fuellmenge_filter_1','anwendungsgebiet_30906','serie_29565','vendor_137','family_231','netto_fuellmenge_filter_5','family_970','vendor_29','hauttyp_353','anwendungsgebiet_30919','serie_56621','vendor_46','vendor_469','vendor_1040','vendor_1434','vendor_847','vendor_873','hauttyp_357','serie_54615','family_217','family_237','family_306','family_525','vendor_16','vendor_1647','anwendungsgebiet_30890','family_242','hauttyp_355','haar_typ_1819','vendor_1062','vendor_1209','vendor_43','vendor_710','vendor_840','family_230','family_244','family_985','hauttyp_2285','serie_50789','serie_56190','serie_56314','serie_56315','vendor_1244','vendor_1425','vendor_1502','vendor_388','vendor_476','vendor_546','vendor_712','vendor_886') 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/koerperpflege-c1556.html

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping