Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

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

[
  "019befa3-8552-7e39-acf7-6e45d2f59408"
]

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 = '019befa3-8552-7e39-acf7-6e45d2f59408';

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

[
  "019befa3-855a-7bf3-ac55-9c2ba5238c6a"
]

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 = '019befa3-855a-7bf3-ac55-9c2ba5238c6a';

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

0.20 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('family_370','netto_gewicht_filter_3','farbgruppierung_578','materialgruppierung_2386','feiertage_820','grossen_30482','beschriftungssprache_25380','netto_gewicht_filter_1','farbgruppierung_577','muster_474','muster_30613','art_26621','verpackung_2870','inschrift_51648','grossen_23848','netto_gewicht_filter_2','muster_30449','muster_3719','materialgruppierung_17837','grossen_32250','verwendungszweck_2754','verwendungszweck_2772','farbgruppierung_585','muster_5122','grossen_36708','muster_30481','farbgruppierung_576','muster_6570','farbgruppierung_579','muster_31828','netto_gewicht_filter_4','verpackung_3948','grossen_23847','farbgruppierung_588','muster_476','muster_30451','muster_30609','grossen_31669','farbgruppierung_580','muster_3730','muster_30503','grossen_53545','netto_gewicht_filter_5','art_2163','farbgruppierung_587','farbgruppierung_586','muster_13186','grossen_17912','muster_31225','grossen_53784','verpackung_3609','farbgruppierung_583','grossen_53546','inschrift_51672','family_27','form_2154','grossen_53237','muster_7594','grossen_47194','grossen_14559','beschriftungssprache_25548','grossen_53808','family_829','grossen_43911','grossen_35912','grossen_55208','farbgruppierung_581','muster_1699','grossen_55209','muster_31064','grossen_42551','muster_31790','farbgruppierung_590','materialgruppierung_1527','grossen_54132','grossen_7626','grossen_47945','verwendungszweck_25912','grossen_53807','inschrift_46977','grossen_53231','feiertage_822','feiertage_826','inschrift_46979','grossen_53786','farbgruppierung_2835','feiertage_960','inschrift_47123','grossen_5922','inschrift_50672','grossen_53787','inschrift_50670','materialgruppierung_5250','grossen_38494','muster_473','geschlecht_65','verwendungszweck_2859','materialgruppierung_2325','grossen_5287','grossen_51520','farbgruppierung_584','grossen_47192','muster_8100','feiertage_819','verwendungszweck_6815','muster_30450','muster_30454','grossen_43931','muster_26721','feiertage_821','typ_33896','grossen_11312','grossen_38343','grossen_38050','grossen_17911','family_967','materialgruppierung_33495','grossen_25011','grossen_17913','feiertage_824','grossen_5921','serie_31702','serie_31701','grossen_53211','typ_3600','grossen_34284','feiertage_1130','grossen_5947') 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_370',
    'netto_gewicht_filter_3',
    'farbgruppierung_578',
    'materialgruppierung_2386',
    'feiertage_820',
    'grossen_30482',
    'beschriftungssprache_25380',
    'netto_gewicht_filter_1',
    'farbgruppierung_577',
    'muster_474',
    'muster_30613',
    'art_26621',
    'verpackung_2870',
    'inschrift_51648',
    'grossen_23848',
    'netto_gewicht_filter_2',
    'muster_30449',
    'muster_3719',
    'materialgruppierung_17837',
    'grossen_32250',
    'verwendungszweck_2754',
    'verwendungszweck_2772',
    'farbgruppierung_585',
    'muster_5122',
    'grossen_36708',
    'muster_30481',
    'farbgruppierung_576',
    'muster_6570',
    'farbgruppierung_579',
    'muster_31828',
    'netto_gewicht_filter_4',
    'verpackung_3948',
    'grossen_23847',
    'farbgruppierung_588',
    'muster_476',
    'muster_30451',
    'muster_30609',
    'grossen_31669',
    'farbgruppierung_580',
    'muster_3730',
    'muster_30503',
    'grossen_53545',
    'netto_gewicht_filter_5',
    'art_2163',
    'farbgruppierung_587',
    'farbgruppierung_586',
    'muster_13186',
    'grossen_17912',
    'muster_31225',
    'grossen_53784',
    'verpackung_3609',
    'farbgruppierung_583',
    'grossen_53546',
    'inschrift_51672',
    'family_27',
    'form_2154',
    'grossen_53237',
    'muster_7594',
    'grossen_47194',
    'grossen_14559',
    'beschriftungssprache_25548',
    'grossen_53808',
    'family_829',
    'grossen_43911',
    'grossen_35912',
    'grossen_55208',
    'farbgruppierung_581',
    'muster_1699',
    'grossen_55209',
    'muster_31064',
    'grossen_42551',
    'muster_31790',
    'farbgruppierung_590',
    'materialgruppierung_1527',
    'grossen_54132',
    'grossen_7626',
    'grossen_47945',
    'verwendungszweck_25912',
    'grossen_53807',
    'inschrift_46977',
    'grossen_53231',
    'feiertage_822',
    'feiertage_826',
    'inschrift_46979',
    'grossen_53786',
    'farbgruppierung_2835',
    'feiertage_960',
    'inschrift_47123',
    'grossen_5922',
    'inschrift_50672',
    'grossen_53787',
    'inschrift_50670',
    'materialgruppierung_5250',
    'grossen_38494',
    'muster_473',
    'geschlecht_65',
    'verwendungszweck_2859',
    'materialgruppierung_2325',
    'grossen_5287',
    'grossen_51520',
    'farbgruppierung_584',
    'grossen_47192',
    'muster_8100',
    'feiertage_819',
    'verwendungszweck_6815',
    'muster_30450',
    'muster_30454',
    'grossen_43931',
    'muster_26721',
    'feiertage_821',
    'typ_33896',
    'grossen_11312',
    'grossen_38343',
    'grossen_38050',
    'grossen_17911',
    'family_967',
    'materialgruppierung_33495',
    'grossen_25011',
    'grossen_17913',
    'feiertage_824',
    'grossen_5921',
    'serie_31702',
    'serie_31701',
    'grossen_53211',
    'typ_3600',
    'grossen_34284',
    'feiertage_1130',
    'grossen_5947'
  )
  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_370','netto_gewicht_filter_3','farbgruppierung_578','materialgruppierung_2386','feiertage_820','grossen_30482','beschriftungssprache_25380','netto_gewicht_filter_1','farbgruppierung_577','muster_474','muster_30613','art_26621','verpackung_2870','inschrift_51648','grossen_23848','netto_gewicht_filter_2','muster_30449','muster_3719','materialgruppierung_17837','grossen_32250','verwendungszweck_2754','verwendungszweck_2772','farbgruppierung_585','muster_5122','grossen_36708','muster_30481','farbgruppierung_576','muster_6570','farbgruppierung_579','muster_31828','netto_gewicht_filter_4','verpackung_3948','grossen_23847','farbgruppierung_588','muster_476','muster_30451','muster_30609','grossen_31669','farbgruppierung_580','muster_3730','muster_30503','grossen_53545','netto_gewicht_filter_5','art_2163','farbgruppierung_587','farbgruppierung_586','muster_13186','grossen_17912','muster_31225','grossen_53784','verpackung_3609','farbgruppierung_583','grossen_53546','inschrift_51672','family_27','form_2154','grossen_53237','muster_7594','grossen_47194','grossen_14559','beschriftungssprache_25548','grossen_53808','family_829','grossen_43911','grossen_35912','grossen_55208','farbgruppierung_581','muster_1699','grossen_55209','muster_31064','grossen_42551','muster_31790','farbgruppierung_590','materialgruppierung_1527','grossen_54132','grossen_7626','grossen_47945','verwendungszweck_25912','grossen_53807','inschrift_46977','grossen_53231','feiertage_822','feiertage_826','inschrift_46979','grossen_53786','farbgruppierung_2835','feiertage_960','inschrift_47123','grossen_5922','inschrift_50672','grossen_53787','inschrift_50670','materialgruppierung_5250','grossen_38494','muster_473','geschlecht_65','verwendungszweck_2859','materialgruppierung_2325','grossen_5287','grossen_51520','farbgruppierung_584','grossen_47192','muster_8100','feiertage_819','verwendungszweck_6815','muster_30450','muster_30454','grossen_43931','muster_26721','feiertage_821','typ_33896','grossen_11312','grossen_38343','grossen_38050','grossen_17911','family_967','materialgruppierung_33495','grossen_25011','grossen_17913','feiertage_824','grossen_5921','serie_31702','serie_31701','grossen_53211','typ_3600','grossen_34284','feiertage_1130','grossen_5947') 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->categoryDetailAction (line 358)
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.19 ms

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->categoryDetailAction (line 375)
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)

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/geschenkverpackung-c2291.html?page=4

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping