Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.39 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.07 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:

[
  "01a11134-5b1a-7a10-815d-a98b7b86464b"
]

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 = '01a11134-5b1a-7a10-815d-a98b7b86464b';

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

[
  "01a11134-5b23-7601-81d8-12c4987b408f"
]

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 = '01a11134-5b23-7601-81d8-12c4987b408f';

#	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.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','family_48','legierung_1277','materialgruppierung_1546','einsatz_1259','einsatzfarbe_45082','thematik_3368','legierung_1281','materialgruppierung_1551','einsatz_2579','family_128','inschrift_3180','muster_50749','materialgruppierung_1549','einsatzfarbe_43608','hoehe_3179','hoehe_3106','einsatzfarbe_43597','hoehe_3240','vendor_395','hoehe_3228','einsatz_2606','hoehe_3178','hoehe_3229','vendor_394','einsatz_8344','hoehe_3234','hoehe_3236','hoehe_3253','hoehe_3254','einsatz_8175','einsatzfarbe_43609','hoehe_3177','einsatz_17950','einsatzfarbe_43606','einsatzfarbe_43610','hoehe_3191','hoehe_3227','hoehe_3233','hoehe_3238','hoehe_3242','hoehe_3251','materialgruppierung_1554','durchmesser_3262','einsatz_1249','einsatz_1258','einsatz_1260','einsatz_18431','einsatz_3318','einsatzfarbe_43648','hoehe_3176','hoehe_3190','hoehe_3255','hoehe_3261','durchmesser_3264','durchmesser_3302','durchmesser_3306','durchmesser_46259','einsatz_1250','einsatz_1251','einsatz_19208','einsatz_28456','einsatz_3243','einsatz_43125','einsatz_45327','einsatz_8162','einsatzfarbe_43627','einsatzfarbe_43667','einsatzfarbe_48911','hoehe_3050','hoehe_3184','hoehe_3200','hoehe_3230','hoehe_3237','hoehe_3239','hoehe_3248','hoehe_3250','hoehe_3252','hoehe_3275','hoehe_3299','hoehe_3305','hoehe_3399','hoehe_57234','inschrift_3395','inschrift_46174','modelname_11643','modelname_26404','modelname_26980','modelname_34061','modelname_43778','modelname_43781','modelname_44057','modelname_44075','modelname_44078','modelname_46276','modelname_46611','muster_11297','thematik_45331') 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', 'family_48',
    'legierung_1277', 'materialgruppierung_1546',
    'einsatz_1259', 'einsatzfarbe_45082',
    'thematik_3368', 'legierung_1281',
    'materialgruppierung_1551', 'einsatz_2579',
    'family_128', 'inschrift_3180',
    'muster_50749', 'materialgruppierung_1549',
    'einsatzfarbe_43608', 'hoehe_3179',
    'hoehe_3106', 'einsatzfarbe_43597',
    'hoehe_3240', 'vendor_395', 'hoehe_3228',
    'einsatz_2606', 'hoehe_3178', 'hoehe_3229',
    'vendor_394', 'einsatz_8344', 'hoehe_3234',
    'hoehe_3236', 'hoehe_3253', 'hoehe_3254',
    'einsatz_8175', 'einsatzfarbe_43609',
    'hoehe_3177', 'einsatz_17950', 'einsatzfarbe_43606',
    'einsatzfarbe_43610', 'hoehe_3191',
    'hoehe_3227', 'hoehe_3233', 'hoehe_3238',
    'hoehe_3242', 'hoehe_3251', 'materialgruppierung_1554',
    'durchmesser_3262', 'einsatz_1249',
    'einsatz_1258', 'einsatz_1260',
    'einsatz_18431', 'einsatz_3318',
    'einsatzfarbe_43648', 'hoehe_3176',
    'hoehe_3190', 'hoehe_3255', 'hoehe_3261',
    'durchmesser_3264', 'durchmesser_3302',
    'durchmesser_3306', 'durchmesser_46259',
    'einsatz_1250', 'einsatz_1251',
    'einsatz_19208', 'einsatz_28456',
    'einsatz_3243', 'einsatz_43125',
    'einsatz_45327', 'einsatz_8162',
    'einsatzfarbe_43627', 'einsatzfarbe_43667',
    'einsatzfarbe_48911', 'hoehe_3050',
    'hoehe_3184', 'hoehe_3200', 'hoehe_3230',
    'hoehe_3237', 'hoehe_3239', 'hoehe_3248',
    'hoehe_3250', 'hoehe_3252', 'hoehe_3275',
    'hoehe_3299', 'hoehe_3305', 'hoehe_3399',
    'hoehe_57234', 'inschrift_3395',
    'inschrift_46174', 'modelname_11643',
    'modelname_26404', 'modelname_26980',
    'modelname_34061', 'modelname_43778',
    'modelname_43781', 'modelname_44057',
    'modelname_44075', 'modelname_44078',
    'modelname_46276', 'modelname_46611',
    'muster_11297', 'thematik_45331'
  )
  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','family_48','legierung_1277','materialgruppierung_1546','einsatz_1259','einsatzfarbe_45082','thematik_3368','legierung_1281','materialgruppierung_1551','einsatz_2579','family_128','inschrift_3180','muster_50749','materialgruppierung_1549','einsatzfarbe_43608','hoehe_3179','hoehe_3106','einsatzfarbe_43597','hoehe_3240','vendor_395','hoehe_3228','einsatz_2606','hoehe_3178','hoehe_3229','vendor_394','einsatz_8344','hoehe_3234','hoehe_3236','hoehe_3253','hoehe_3254','einsatz_8175','einsatzfarbe_43609','hoehe_3177','einsatz_17950','einsatzfarbe_43606','einsatzfarbe_43610','hoehe_3191','hoehe_3227','hoehe_3233','hoehe_3238','hoehe_3242','hoehe_3251','materialgruppierung_1554','durchmesser_3262','einsatz_1249','einsatz_1258','einsatz_1260','einsatz_18431','einsatz_3318','einsatzfarbe_43648','hoehe_3176','hoehe_3190','hoehe_3255','hoehe_3261','durchmesser_3264','durchmesser_3302','durchmesser_3306','durchmesser_46259','einsatz_1250','einsatz_1251','einsatz_19208','einsatz_28456','einsatz_3243','einsatz_43125','einsatz_45327','einsatz_8162','einsatzfarbe_43627','einsatzfarbe_43667','einsatzfarbe_48911','hoehe_3050','hoehe_3184','hoehe_3200','hoehe_3230','hoehe_3237','hoehe_3239','hoehe_3248','hoehe_3250','hoehe_3252','hoehe_3275','hoehe_3299','hoehe_3305','hoehe_3399','hoehe_57234','inschrift_3395','inschrift_46174','modelname_11643','modelname_26404','modelname_26980','modelname_34061','modelname_43778','modelname_43781','modelname_44057','modelname_44075','modelname_44078','modelname_46276','modelname_46611','muster_11297','thematik_45331') 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/ru/ukrasheniya/podveski.html?page=3

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping