Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

0.42 ms Query time

0 Invalid entities

2 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

0.14 ms
(34.29%)

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('family_238','sparset_filter_0','hauttyp_351','anwendungsgebiet_30906','anwendungsgebiet_30910','netto_fuellmenge_filter_1','netto_fuellmenge_filter_3','netto_fuellmenge_filter_2','vendor_879','vendor_476','anwendungsgebiet_30918','anwendungsgebiet_30919','hauttyp_353','vendor_46','hauttyp_2285','vendor_1434','hauttyp_357','netto_fuellmenge_filter_4','serie_53220','vendor_1098','hauttyp_355','serie_56621','vendor_469','vendor_1335','vendor_1469','vendor_840','vendor_849','vendor_878','anwendungsgebiet_30905','anwendungsgebiet_37352','vendor_1140','vendor_1468','vendor_873','serie_50789','vendor_1040','vendor_1613','vendor_710','anwendungsgebiet_30912','hauttyp_352','hauttyp_354','serie_29565','serie_45475','serie_48829','serie_53022','serie_55819','serie_55822','serie_56311','vendor_1062','vendor_1244','vendor_29','vendor_43','anwendungsgebiet_33918','anwendungsgebiet_37078','anwendungsgebiet_38538','hauttyp_360','serie_48828','serie_53032','serie_54815','serie_56160','serie_56190','vendor_137','vendor_1391','vendor_1401','vendor_1571','vendor_1622','vendor_1625','vendor_1627','vendor_1653','vendor_655','vendor_676') 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(
    'family_238', 'sparset_filter_0',
    'hauttyp_351', 'anwendungsgebiet_30906',
    'anwendungsgebiet_30910', 'netto_fuellmenge_filter_1',
    'netto_fuellmenge_filter_3', 'netto_fuellmenge_filter_2',
    'vendor_879', 'vendor_476', 'anwendungsgebiet_30918',
    'anwendungsgebiet_30919', 'hauttyp_353',
    'vendor_46', 'hauttyp_2285', 'vendor_1434',
    'hauttyp_357', 'netto_fuellmenge_filter_4',
    'serie_53220', 'vendor_1098', 'hauttyp_355',
    'serie_56621', 'vendor_469', 'vendor_1335',
    'vendor_1469', 'vendor_840', 'vendor_849',
    'vendor_878', 'anwendungsgebiet_30905',
    'anwendungsgebiet_37352', 'vendor_1140',
    'vendor_1468', 'vendor_873', 'serie_50789',
    'vendor_1040', 'vendor_1613', 'vendor_710',
    'anwendungsgebiet_30912', 'hauttyp_352',
    'hauttyp_354', 'serie_29565', 'serie_45475',
    'serie_48829', 'serie_53022', 'serie_55819',
    'serie_55822', 'serie_56311', 'vendor_1062',
    'vendor_1244', 'vendor_29', 'vendor_43',
    'anwendungsgebiet_33918', 'anwendungsgebiet_37078',
    'anwendungsgebiet_38538', 'hauttyp_360',
    'serie_48828', 'serie_53032', 'serie_54815',
    'serie_56160', 'serie_56190', 'vendor_137',
    'vendor_1391', 'vendor_1401', 'vendor_1571',
    'vendor_1622', 'vendor_1625', 'vendor_1627',
    'vendor_1653', 'vendor_655', 'vendor_676'
  )
  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('family_238','sparset_filter_0','hauttyp_351','anwendungsgebiet_30906','anwendungsgebiet_30910','netto_fuellmenge_filter_1','netto_fuellmenge_filter_3','netto_fuellmenge_filter_2','vendor_879','vendor_476','anwendungsgebiet_30918','anwendungsgebiet_30919','hauttyp_353','vendor_46','hauttyp_2285','vendor_1434','hauttyp_357','netto_fuellmenge_filter_4','serie_53220','vendor_1098','hauttyp_355','serie_56621','vendor_469','vendor_1335','vendor_1469','vendor_840','vendor_849','vendor_878','anwendungsgebiet_30905','anwendungsgebiet_37352','vendor_1140','vendor_1468','vendor_873','serie_50789','vendor_1040','vendor_1613','vendor_710','anwendungsgebiet_30912','hauttyp_352','hauttyp_354','serie_29565','serie_45475','serie_48829','serie_53022','serie_55819','serie_55822','serie_56311','vendor_1062','vendor_1244','vendor_29','vendor_43','anwendungsgebiet_33918','anwendungsgebiet_37078','anwendungsgebiet_38538','hauttyp_360','serie_48828','serie_53032','serie_54815','serie_56160','serie_56190','vendor_137','vendor_1391','vendor_1401','vendor_1571','vendor_1622','vendor_1625','vendor_1627','vendor_1653','vendor_655','vendor_676') 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)

0.12 ms
(29.77%)

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 = 'family' AND av.id=238

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 = 'family'
  AND av.id = 238

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 = 'family' AND av.id=238 ;

#	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.09 ms
(21.77%)

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:

[
  "01a11287-0b3d-7847-8585-e700949b383e"
]

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 = '01a11287-0b3d-7847-8585-e700949b383e';

#	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.06 ms
(14.17%)

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:

[
  "01a11287-0b31-7de6-b96b-f2981c7bcb91"
]

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 = '01a11287-0b31-7de6-b96b-f2981c7bcb91';

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

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/family-a238.html?direction=asc&page=4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping