Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.46 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.14 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:

[
  "01a10bb7-e007-7870-8b63-3d2a7088b0e1"
]

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 = '01a10bb7-e007-7870-8b63-3d2a7088b0e1';

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

[
  "01a10bb7-e010-7b1a-abb8-9746f529aff7"
]

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 = '01a10bb7-e010-7b1a-abb8-9746f529aff7';

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

1.21 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','materialgruppierung_1520','family_60','stahldicke_4087','family_368','materialgruppierung_25881','laenge_2600','material_des_griffs_2758','material_des_griffs_2739','materialgruppierung_1523','vendor_42','gesamthoehe_56264','laenge_2598','stahldicke_3214','family_475','vendor_1411','steuerungsart_5031','grossen_4869','materialgruppierung_1521','stahldicke_3047','gesamthoehe_44331','gesamthoehe_4607','gesamthoehe_56324','gesamthoehe_57119','grossen_56325','hoehe_3051','kohlenbeckengroesse_44334','kohlenbeckengroesse_57110','kohlenbeckengroesse_57115','kohlenbeckengroesse_57161','laenge_2599','laenge_5810','laenge_6134','materialgruppierung_1524','stahldicke_40213','gesamthoehe_56265','gesamthoehe_57100','gesamthoehe_57718','gesamthoehe_57720','gesamthoehe_57722','grossen_56326','grossen_56624','grossen_57719','grossen_57721','grossen_57723','hoehe_3970','hoehe_4915','hoehe_5812','hoehe_7382','kohlenbeckengroesse_57162','kohlenbeckengroesse_57163','laenge_2602','laenge_34358','laenge_4530','laenge_4991','laenge_4994','laenge_5015','laenge_5639','laenge_57099','laenge_57116','laenge_57741','laenge_5986','laenge_6319','laenge_6678','laenge_7331','laenge_8140','materialgruppierung_17837','materialgruppierung_2406','stahldicke_2843','vendor_1483') 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', 'materialgruppierung_1520',
    'family_60', 'stahldicke_4087',
    'family_368', 'materialgruppierung_25881',
    'laenge_2600', 'material_des_griffs_2758',
    'material_des_griffs_2739', 'materialgruppierung_1523',
    'vendor_42', 'gesamthoehe_56264',
    'laenge_2598', 'stahldicke_3214',
    'family_475', 'vendor_1411', 'steuerungsart_5031',
    'grossen_4869', 'materialgruppierung_1521',
    'stahldicke_3047', 'gesamthoehe_44331',
    'gesamthoehe_4607', 'gesamthoehe_56324',
    'gesamthoehe_57119', 'grossen_56325',
    'hoehe_3051', 'kohlenbeckengroesse_44334',
    'kohlenbeckengroesse_57110', 'kohlenbeckengroesse_57115',
    'kohlenbeckengroesse_57161', 'laenge_2599',
    'laenge_5810', 'laenge_6134', 'materialgruppierung_1524',
    'stahldicke_40213', 'gesamthoehe_56265',
    'gesamthoehe_57100', 'gesamthoehe_57718',
    'gesamthoehe_57720', 'gesamthoehe_57722',
    'grossen_56326', 'grossen_56624',
    'grossen_57719', 'grossen_57721',
    'grossen_57723', 'hoehe_3970', 'hoehe_4915',
    'hoehe_5812', 'hoehe_7382', 'kohlenbeckengroesse_57162',
    'kohlenbeckengroesse_57163', 'laenge_2602',
    'laenge_34358', 'laenge_4530', 'laenge_4991',
    'laenge_4994', 'laenge_5015', 'laenge_5639',
    'laenge_57099', 'laenge_57116',
    'laenge_57741', 'laenge_5986', 'laenge_6319',
    'laenge_6678', 'laenge_7331', 'laenge_8140',
    'materialgruppierung_17837', 'materialgruppierung_2406',
    'stahldicke_2843', 'vendor_1483'
  )
  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','materialgruppierung_1520','family_60','stahldicke_4087','family_368','materialgruppierung_25881','laenge_2600','material_des_griffs_2758','material_des_griffs_2739','materialgruppierung_1523','vendor_42','gesamthoehe_56264','laenge_2598','stahldicke_3214','family_475','vendor_1411','steuerungsart_5031','grossen_4869','materialgruppierung_1521','stahldicke_3047','gesamthoehe_44331','gesamthoehe_4607','gesamthoehe_56324','gesamthoehe_57119','grossen_56325','hoehe_3051','kohlenbeckengroesse_44334','kohlenbeckengroesse_57110','kohlenbeckengroesse_57115','kohlenbeckengroesse_57161','laenge_2599','laenge_5810','laenge_6134','materialgruppierung_1524','stahldicke_40213','gesamthoehe_56265','gesamthoehe_57100','gesamthoehe_57718','gesamthoehe_57720','gesamthoehe_57722','grossen_56326','grossen_56624','grossen_57719','grossen_57721','grossen_57723','hoehe_3970','hoehe_4915','hoehe_5812','hoehe_7382','kohlenbeckengroesse_57162','kohlenbeckengroesse_57163','laenge_2602','laenge_34358','laenge_4530','laenge_4991','laenge_4994','laenge_5015','laenge_5639','laenge_57099','laenge_57116','laenge_57741','laenge_5986','laenge_6319','laenge_6678','laenge_7331','laenge_8140','materialgruppierung_17837','materialgruppierung_2406','stahldicke_2843','vendor_1483') 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/de/aus-usbekistan/grill-plov-bbq/mangal-grill.html

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping