Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

0.71 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.18 ms
(25.28%)

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_61','netto_gewicht_filter_4','geschlecht_66','farbgruppierung_576','farbgruppierung_578','muster_473','muster_36722','materialgruppierung_1535','volumen_2164','hoehe_3085','verpackung_3948','serie_33712','modelname_32526','beschriftungssprache_25380','inschrift_22407','inschrift_23460','modelname_32533','inschrift_22405','modelname_36777','inschrift_26753','modelname_32532','inschrift_22366','modelname_26466','inschrift_23487','modelname_25373','inschrift_32535','modelname_32531','inschrift_32534','modelname_32530','inschrift_22408','modelname_32529','inschrift_22385','modelname_25633','modelname_26999') 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_61', 'netto_gewicht_filter_4',
    'geschlecht_66', 'farbgruppierung_576',
    'farbgruppierung_578', 'muster_473',
    'muster_36722', 'materialgruppierung_1535',
    'volumen_2164', 'hoehe_3085', 'verpackung_3948',
    'serie_33712', 'modelname_32526',
    'beschriftungssprache_25380', 'inschrift_22407',
    'inschrift_23460', 'modelname_32533',
    'inschrift_22405', 'modelname_36777',
    'inschrift_26753', 'modelname_32532',
    'inschrift_22366', 'modelname_26466',
    'inschrift_23487', 'modelname_25373',
    'inschrift_32535', 'modelname_32531',
    'inschrift_32534', 'modelname_32530',
    'inschrift_22408', 'modelname_32529',
    'inschrift_22385', 'modelname_25633',
    'modelname_26999'
  )
  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_61','netto_gewicht_filter_4','geschlecht_66','farbgruppierung_576','farbgruppierung_578','muster_473','muster_36722','materialgruppierung_1535','volumen_2164','hoehe_3085','verpackung_3948','serie_33712','modelname_32526','beschriftungssprache_25380','inschrift_22407','inschrift_23460','modelname_32533','inschrift_22405','modelname_36777','inschrift_26753','modelname_32532','inschrift_22366','modelname_26466','inschrift_23487','modelname_25373','inschrift_32535','modelname_32531','inschrift_32534','modelname_32530','inschrift_22408','modelname_32529','inschrift_22385','modelname_25633','modelname_26999') AND  a.is_filterable = true;

#	File/Call
1	Doctrine\DBAL\Statement->executeQuery (line 119)
2	App\Repository\AttributeRepository->getRawFilters (line 67)
3	App\Component\CategoryFilter->parseSelectedFilters (line 25)
4	App\Controller\Pages\DocumentController->attributeDetailAction (line 509)
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 35)
9	require_once (line 32)
10	require_once (line 5)

0.17 ms
(24.31%)

SELECT code FROM attribute WHERE is_filterable = true

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  code
FROM
  attribute
WHERE
  is_filterable = true

SELECT code FROM attribute WHERE is_filterable = true;

#	File/Call
1	Doctrine\DBAL\Statement->executeQuery (line 119)
2	App\Repository\AttributeRepository->getGroupCodes (line 82)
3	App\Component\CategoryFilter->buildFiltersTree (line 63)
4	App\Controller\Pages\DocumentController->attributeDetailAction (line 516)
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 35)
9	require_once (line 32)
10	require_once (line 5)

0.14 ms
(19.12%)

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 = 'serie' AND av.id=33712

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 = 'serie'
  AND av.id = 33712

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 = 'serie' AND av.id=33712 ;

#	File/Call
1	Doctrine\DBAL\Statement->executeQuery (line 119)
2	App\Repository\AttributeRepository->getAttribute (line 125)
3	App\Controller\Pages\DocumentController->attributeDetailAction (line 493)
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 35)
8	require_once (line 32)
9	require_once (line 5)

0.12 ms
(16.28%)

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 carts t0 WHERE t0.id = ?

Parameters:

[
  "019bf0dd-fad7-79d6-a8b9-0b107401b7f8"
]

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
  carts 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 carts t0 WHERE t0.id = '019bf0dd-fad7-79d6-a8b9-0b107401b7f8';

#	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 161)
7	App\Repository\CartRepository->init (line 208)
8	App\EventListener\Locale\StickyListener->sessionListener (line 136)
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 126)
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 35)
17	require_once (line 32)
18	require_once (line 5)

0.11 ms
(15.00%)

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:

[
  "019bf0dd-fade-7de3-8de5-e0e676c57042"
]

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 = '019bf0dd-fade-7de3-8de5-e0e676c57042';

#	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 137)
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 126)
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 35)
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\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/serie-a33712.html

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping