Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

7.82 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.13 ms

SELECT slug, name FROM shop.available_catalogs

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  slug,
  name
FROM
  shop.available_catalogs

SELECT slug, name FROM shop.available_catalogs;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 256)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 22)
4	Sady\Shop\Catalog\Menu\CatalogsDoctrineRepository->findAll (line 26)
5	Sady\Shop\Catalog\Menu\ResolveMainMenuItemsListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 31)
10	Sady\Navigation\Page\MenuTwigComponent->getItems (line 191)
11	Symfony\UX\TwigComponent\ComponentRenderer->exposedVariables (line 1)
12	iterator_to_array (line 112)
13	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 62)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 55)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 60)
16	Symfony\UX\TwigComponent\Twig\ComponentExtension->render (line 393)
17	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->block_header_nav (line 442)
18	Twig\Template->yieldBlock (line 339)
19	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->block_header (line 442)
20	Twig\Template->yieldBlock (line 166)
21	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
22	Twig\Template->yield (line 57)
23	__TwigTemplate_3be23afac262fe09a766553567676d8e->doDisplay (line 398)
24	Twig\Template->yield (line 354)
25	Twig\Template->display (line 369)
26	Twig\Template->render (line 38)
27	Twig\TemplateWrapper->render (line 306)
28	Twig\Environment->render (line 58)
29	Sady\Ui\RenderResponseSubscriber->setResponse (line 51)
30	Sady\Ui\RenderResponseSubscriber->renderTemplate (line 115)
31	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
32	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
33	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
34	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 7)

2.12 ms

SELECT t0.count AS count_1, t0.id AS id_2, t0.total_price_amount AS total_price_amount_3, t0.total_price_currency AS total_price_currency_4 FROM domain.carts t0 WHERE t0.id = ?

Parameters:

[
  "237c088d-f347-44f6-bcf5-a2eec4ba4b66"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.count AS count_1,
  t0.id AS id_2,
  t0.total_price_amount AS total_price_amount_3,
  t0.total_price_currency AS total_price_currency_4
FROM
  domain.carts t0
WHERE
  t0.id = ?

SELECT t0.count AS count_1, t0.id AS id_2, t0.total_price_amount AS total_price_amount_3, t0.total_price_currency AS total_price_currency_4 FROM domain.carts t0 WHERE t0.id = '237c088d-f347-44f6-bcf5-a2eec4ba4b66';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 21)
5	Sady\Shopping\Cart\Data\DoctrineCartRepository->getById (line 39)
6	Sady\Shopping\Cart\CurrentCartProvider->findExistingCart (line 25)
7	Sady\Shopping\Cart\CurrentCartProvider->provide (line 17)
8	Sady\Shopping\Cart\GetCartHandler->handle (line 61)
9	Sady\Sales\Cart\CartTwigComponent->getCart (line 30)
10	Sady\Sales\Cart\CartTwigComponent->getItemCount (line 191)
11	Symfony\UX\TwigComponent\ComponentRenderer->exposedVariables (line 1)
12	iterator_to_array (line 112)
13	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 62)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 55)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 60)
16	Symfony\UX\TwigComponent\Twig\ComponentExtension->render (line 460)
17	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->block_actions (line 442)
18	Twig\Template->yieldBlock (line 360)
19	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->block_header (line 442)
20	Twig\Template->yieldBlock (line 166)
21	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
22	Twig\Template->yield (line 57)
23	__TwigTemplate_3be23afac262fe09a766553567676d8e->doDisplay (line 398)
24	Twig\Template->yield (line 354)
25	Twig\Template->display (line 369)
26	Twig\Template->render (line 38)
27	Twig\TemplateWrapper->render (line 306)
28	Twig\Environment->render (line 58)
29	Sady\Ui\RenderResponseSubscriber->setResponse (line 51)
30	Sady\Ui\RenderResponseSubscriber->renderTemplate (line 115)
31	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
32	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
33	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
34	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 7)

1.31 ms

SELECT t0.count AS count_1, t0.id AS id_2, t0.total_price_amount AS total_price_amount_3, t0.total_price_currency AS total_price_currency_4 FROM domain.carts t0 WHERE t0.id = ?

Parameters:

[
  "237c088d-f347-44f6-bcf5-a2eec4ba4b66"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.count AS count_1,
  t0.id AS id_2,
  t0.total_price_amount AS total_price_amount_3,
  t0.total_price_currency AS total_price_currency_4
FROM
  domain.carts t0
WHERE
  t0.id = ?

SELECT t0.count AS count_1, t0.id AS id_2, t0.total_price_amount AS total_price_amount_3, t0.total_price_currency AS total_price_currency_4 FROM domain.carts t0 WHERE t0.id = '237c088d-f347-44f6-bcf5-a2eec4ba4b66';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 21)
5	Sady\Shopping\Cart\Data\DoctrineCartRepository->getById (line 39)
6	Sady\Shopping\Cart\CurrentCartProvider->findExistingCart (line 25)
7	Sady\Shopping\Cart\CurrentCartProvider->provide (line 24)
8	Sady\Shopping\Cart\FetchCartItemsHandler->handle (line 18)
9	Sady\Shopping\Cart\GetCartHandler->handle (line 61)
10	Sady\Sales\Cart\CartTwigComponent->getCart (line 30)
11	Sady\Sales\Cart\CartTwigComponent->getItemCount (line 191)
12	Symfony\UX\TwigComponent\ComponentRenderer->exposedVariables (line 1)
13	iterator_to_array (line 112)
14	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 62)
15	Symfony\UX\TwigComponent\ComponentRenderer->render (line 55)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 60)
17	Symfony\UX\TwigComponent\Twig\ComponentExtension->render (line 460)
18	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->block_actions (line 442)
19	Twig\Template->yieldBlock (line 360)
20	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->block_header (line 442)
21	Twig\Template->yieldBlock (line 166)
22	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
23	Twig\Template->yield (line 57)
24	__TwigTemplate_3be23afac262fe09a766553567676d8e->doDisplay (line 398)
25	Twig\Template->yield (line 354)
26	Twig\Template->display (line 369)
27	Twig\Template->render (line 38)
28	Twig\TemplateWrapper->render (line 306)
29	Twig\Environment->render (line 58)
30	Sady\Ui\RenderResponseSubscriber->setResponse (line 51)
31	Sady\Ui\RenderResponseSubscriber->renderTemplate (line 115)
32	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
34	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
35	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 7)

2.26 ms

SELECT * FROM public.cart_items WHERE cart_id = ? ORDER BY product_id ASC LIMIT 999

Parameters:

[
  Termyn\Uuid\Symfony\SymfonyUuid {#439
    __toString(): "237c088d-f347-44f6-bcf5-a2eec4ba4b66"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  *
FROM
  public.cart_items
WHERE
  cart_id = ?
ORDER BY
  product_id ASC
LIMIT
  999

SELECT * FROM public.cart_items WHERE cart_id = '237c088d-f347-44f6-bcf5-a2eec4ba4b66' ORDER BY product_id ASC LIMIT 999;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 256)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 33)
4	Sady\Shopping\Cart\FetchCartItemsHandler->handle (line 18)
5	Sady\Shopping\Cart\GetCartHandler->handle (line 61)
6	Sady\Sales\Cart\CartTwigComponent->getCart (line 30)
7	Sady\Sales\Cart\CartTwigComponent->getItemCount (line 191)
8	Symfony\UX\TwigComponent\ComponentRenderer->exposedVariables (line 1)
9	iterator_to_array (line 112)
10	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 62)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 55)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 60)
13	Symfony\UX\TwigComponent\Twig\ComponentExtension->render (line 460)
14	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->block_actions (line 442)
15	Twig\Template->yieldBlock (line 360)
16	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->block_header (line 442)
17	Twig\Template->yieldBlock (line 166)
18	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
19	Twig\Template->yield (line 57)
20	__TwigTemplate_3be23afac262fe09a766553567676d8e->doDisplay (line 398)
21	Twig\Template->yield (line 354)
22	Twig\Template->display (line 369)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 306)
25	Twig\Environment->render (line 58)
26	Sady\Ui\RenderResponseSubscriber->setResponse (line 51)
27	Sady\Ui\RenderResponseSubscriber->renderTemplate (line 115)
28	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
30	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
31	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 7)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
Sady\Shopping\Cart\Model\Price	No errors.
Sady\Shopping\Cart\Model\Cart	No errors.

Symfony Profiler

GET https://sady.shop/ochrana-osobnych-udajov

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping