Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

0.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.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:

[
  "01a10d77-8f93-7761-acee-9cf8f0ef93db"
]

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 = '01a10d77-8f93-7761-acee-9cf8f0ef93db';

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

[
  "01a10d77-8f9c-7a59-86bb-5ee788a777ac"
]

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 = '01a10d77-8f9c-7a59-86bb-5ee788a777ac';

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

SELECT a.id as attr_id, a.code, a.name_ru, a.name_de, 
			av.uid, av.id as value_id, av.name_ru as value_name_ru, av.name_de as value_name_de
FROM attribute_value AS av
JOIN attribute AS a on a.code = av.code
WHERE av.code = 'vendor' AND av.id=1411

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a.id as attr_id,
  a.code,
  a.name_ru,
  a.name_de,
  av.uid,
  av.id as value_id,
  av.name_ru as value_name_ru,
  av.name_de as value_name_de
FROM
  attribute_value AS av
  JOIN attribute AS a on a.code = av.code
WHERE
  av.code = 'vendor'
  AND av.id = 1411

SELECT a.id as attr_id, a.code, a.name_ru, a.name_de, 
			av.uid, av.id as value_id, av.name_ru as value_name_ru, av.name_de as value_name_de
FROM attribute_value AS av
JOIN attribute AS a on a.code = av.code
WHERE av.code = 'vendor' AND av.id=1411 ;

#	File/Call
1	Doctrine\DBAL\Statement->executeQuery (line 119)
2	App\Repository\AttributeRepository->getAttribute (line 131)
3	App\Controller\Pages\DocumentController->attributeDetailAction (line 626)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
8	require_once (line 32)
9	require_once (line 5)

0.16 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','vendor_1411','materialgruppierung_1525','serie_53972','family_152','materialgruppierung_1520','materialgruppierung_2062','materialgruppierung_25881','materialgruppierung_1523','materialgruppierung_1524','materialgruppierung_1535','family_1247','hoehe_3826','cauldron_weight_with_lid_53376','cauldron_weight_with_lid_53384','hoehe_2940','hoehe_3095','cauldron_weight_with_lid_53390','hoehe_3051','cauldron_weight_with_lid_53369','durchmesser_53579','materialgruppierung_1521','herdarten_2765','herdarten_2975','stahldicke_4087','form_2151','family_1278','cauldron_weight_with_lid_53389','family_1139','materialgruppierung_17837','cauldron_weight_with_lid_53361','cauldron_weight_with_lid_53374','family_60','durchmesser_2075','family_105','herdarten_2766','herdarten_2768','cauldron_weight_with_lid_53352','cauldron_weight_with_lid_53365','cauldron_weight_with_lid_53383','durchmesser_2076','durchmesser_2077','durchmesser_22801','family_543','form_2157','material_des_griffs_2758','materialgruppierung_53247','cauldron_weight_with_lid_53350','cauldron_weight_with_lid_53358','durchmesser_4140','durchmesser_53728','family_1245','family_382','groesse_56608','groesse_56609','groesse_56610','groesse_56611','hoehe_3027','hoehe_3050','hoehe_3066','hoehe_3081','material_des_griffs_3072','cauldron_weight_with_lid_53344','durchmesser_2071','durchmesser_2080','durchmesser_2082','durchmesser_2887','durchmesser_4241','durchmesser_4466','durchmesser_53729','durchmesser_53730','durchmesser_5496','durchmesser_55975','durchmesser_7322','durchmesser_7333','family_1175','family_1285','family_159','form_2154','gesamthoehe_41951','gesamthoehe_4607','gesamthoehe_56264','gesamthoehe_56265','gesamthoehe_56324','gesamthoehe_57718','gesamthoehe_57722','grossen_41768','grossen_56325','grossen_56326','grossen_57719','grossen_57723','hoehe_3115','hoehe_3844','hoehe_3905','hoehe_3970','hoehe_5241','laenge_2600','laenge_2602','laenge_5015','laenge_6319','stueckzahl_der_artikel_54162') 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', 'vendor_1411',
    'materialgruppierung_1525', 'serie_53972',
    'family_152', 'materialgruppierung_1520',
    'materialgruppierung_2062', 'materialgruppierung_25881',
    'materialgruppierung_1523', 'materialgruppierung_1524',
    'materialgruppierung_1535', 'family_1247',
    'hoehe_3826', 'cauldron_weight_with_lid_53376',
    'cauldron_weight_with_lid_53384',
    'hoehe_2940', 'hoehe_3095', 'cauldron_weight_with_lid_53390',
    'hoehe_3051', 'cauldron_weight_with_lid_53369',
    'durchmesser_53579', 'materialgruppierung_1521',
    'herdarten_2765', 'herdarten_2975',
    'stahldicke_4087', 'form_2151',
    'family_1278', 'cauldron_weight_with_lid_53389',
    'family_1139', 'materialgruppierung_17837',
    'cauldron_weight_with_lid_53361',
    'cauldron_weight_with_lid_53374',
    'family_60', 'durchmesser_2075',
    'family_105', 'herdarten_2766',
    'herdarten_2768', 'cauldron_weight_with_lid_53352',
    'cauldron_weight_with_lid_53365',
    'cauldron_weight_with_lid_53383',
    'durchmesser_2076', 'durchmesser_2077',
    'durchmesser_22801', 'family_543',
    'form_2157', 'material_des_griffs_2758',
    'materialgruppierung_53247', 'cauldron_weight_with_lid_53350',
    'cauldron_weight_with_lid_53358',
    'durchmesser_4140', 'durchmesser_53728',
    'family_1245', 'family_382', 'groesse_56608',
    'groesse_56609', 'groesse_56610',
    'groesse_56611', 'hoehe_3027', 'hoehe_3050',
    'hoehe_3066', 'hoehe_3081', 'material_des_griffs_3072',
    'cauldron_weight_with_lid_53344',
    'durchmesser_2071', 'durchmesser_2080',
    'durchmesser_2082', 'durchmesser_2887',
    'durchmesser_4241', 'durchmesser_4466',
    'durchmesser_53729', 'durchmesser_53730',
    'durchmesser_5496', 'durchmesser_55975',
    'durchmesser_7322', 'durchmesser_7333',
    'family_1175', 'family_1285', 'family_159',
    'form_2154', 'gesamthoehe_41951',
    'gesamthoehe_4607', 'gesamthoehe_56264',
    'gesamthoehe_56265', 'gesamthoehe_56324',
    'gesamthoehe_57718', 'gesamthoehe_57722',
    'grossen_41768', 'grossen_56325',
    'grossen_56326', 'grossen_57719',
    'grossen_57723', 'hoehe_3115', 'hoehe_3844',
    'hoehe_3905', 'hoehe_3970', 'hoehe_5241',
    'laenge_2600', 'laenge_2602', 'laenge_5015',
    'laenge_6319', 'stueckzahl_der_artikel_54162'
  )
  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','vendor_1411','materialgruppierung_1525','serie_53972','family_152','materialgruppierung_1520','materialgruppierung_2062','materialgruppierung_25881','materialgruppierung_1523','materialgruppierung_1524','materialgruppierung_1535','family_1247','hoehe_3826','cauldron_weight_with_lid_53376','cauldron_weight_with_lid_53384','hoehe_2940','hoehe_3095','cauldron_weight_with_lid_53390','hoehe_3051','cauldron_weight_with_lid_53369','durchmesser_53579','materialgruppierung_1521','herdarten_2765','herdarten_2975','stahldicke_4087','form_2151','family_1278','cauldron_weight_with_lid_53389','family_1139','materialgruppierung_17837','cauldron_weight_with_lid_53361','cauldron_weight_with_lid_53374','family_60','durchmesser_2075','family_105','herdarten_2766','herdarten_2768','cauldron_weight_with_lid_53352','cauldron_weight_with_lid_53365','cauldron_weight_with_lid_53383','durchmesser_2076','durchmesser_2077','durchmesser_22801','family_543','form_2157','material_des_griffs_2758','materialgruppierung_53247','cauldron_weight_with_lid_53350','cauldron_weight_with_lid_53358','durchmesser_4140','durchmesser_53728','family_1245','family_382','groesse_56608','groesse_56609','groesse_56610','groesse_56611','hoehe_3027','hoehe_3050','hoehe_3066','hoehe_3081','material_des_griffs_3072','cauldron_weight_with_lid_53344','durchmesser_2071','durchmesser_2080','durchmesser_2082','durchmesser_2887','durchmesser_4241','durchmesser_4466','durchmesser_53729','durchmesser_53730','durchmesser_5496','durchmesser_55975','durchmesser_7322','durchmesser_7333','family_1175','family_1285','family_159','form_2154','gesamthoehe_41951','gesamthoehe_4607','gesamthoehe_56264','gesamthoehe_56265','gesamthoehe_56324','gesamthoehe_57718','gesamthoehe_57722','grossen_41768','grossen_56325','grossen_56326','grossen_57719','grossen_57723','hoehe_3115','hoehe_3844','hoehe_3905','hoehe_3970','hoehe_5241','laenge_2600','laenge_2602','laenge_5015','laenge_6319','stueckzahl_der_artikel_54162') 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->attributeDetailAction (line 642)
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/ru/vendor-a1411.html?page=5

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping