Symfony Profiler

Query Metrics

19 Database Queries

14 Different statements

34.33 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.50 ms
(21.86%)

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:

[
  "04d702aa-f0a7-4267-8c0b-026d2f42aa61"
]

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 = '04d702aa-f0a7-4267-8c0b-026d2f42aa61';

#	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 32)
9	Sady\Sales\Product\ShowProductController->__invoke (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 7)

5.19 ms
(15.11%)

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

Parameters:

[
  Termyn\Uuid\Symfony\SymfonyUuid {#439
    __toString(): "04d702aa-f0a7-4267-8c0b-026d2f42aa61"
  }
]

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 = '04d702aa-f0a7-4267-8c0b-026d2f42aa61' 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 32)
6	Sady\Sales\Product\ShowProductController->__invoke (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 7)

2.89 ms
(8.41%)

SELECT id, name, description, image, on_sale, available_for_purchase_online, price_current_incl_vat FROM shop.products WHERE slug = ? LIMIT 1

Parameters:

[
  "kalove-cerpadlo-feka"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  name,
  description,
  image,
  on_sale,
  available_for_purchase_online,
  price_current_incl_vat
FROM
  shop.products
WHERE
  slug = ?
LIMIT
  1

SELECT id, name, description, image, on_sale, available_for_purchase_online, price_current_incl_vat FROM shop.products WHERE slug = 'kalove-cerpadlo-feka' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 206)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAssociative (line 27)
4	Sady\Sales\Product\FindProductHandler->handle (line 28)
5	Sady\Sales\Product\FoundProductValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 7)

2.68 ms
(7.82%)

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE id = ?

Parameters:

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1145
    __toString(): "358d7864-59ef-4723-8c4b-72eaaffe8f2b"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  abbreviation,
  slug,
  parent_id
FROM
  shop.catalog_categories
WHERE
  id = ?

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE id = '358d7864-59ef-4723-8c4b-72eaaffe8f2b';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 206)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAssociative (line 25)
4	Sady\Sales\Catalog\Breadcrumb\CategoryDoctrineRepository->getById (line 25)
5	Sady\Sales\Catalog\Breadcrumb\CollectCategoriesPathsListener->__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 28)
10	Sady\Navigation\Breadcrumb\BreadcrumbTwigComponent->getPaths (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 121)
17	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->block_main (line 442)
18	Twig\Template->yieldBlock (line 176)
19	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
20	Twig\Template->yield (line 53)
21	__TwigTemplate_55e87df771746fb29074ea644937563f->doDisplay (line 398)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->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 40)
30	Sady\Ui\RenderResponseSubscriber->renderView (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.11 ms
(6.15%)

SELECT name, slug, image, price_original_incl_vat, price_current_incl_vat, price_currency, stock_status, at_discount, available_for_purchase_online FROM shop.related_products WHERE related_id = (?) ORDER BY price_current_incl_vat

Parameters:

[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "0dfe3ee8-166d-4d05-8453-8faf3e19aa23"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  name,
  slug,
  image,
  price_original_incl_vat,
  price_current_incl_vat,
  price_currency,
  stock_status,
  at_discount,
  available_for_purchase_online
FROM
  shop.related_products
WHERE
  related_id = (?)
ORDER BY
  price_current_incl_vat

SELECT name, slug, image, price_original_incl_vat, price_current_incl_vat, price_currency, stock_status, at_discount, available_for_purchase_online FROM shop.related_products WHERE related_id = ('0dfe3ee8-166d-4d05-8453-8faf3e19aa23') ORDER BY price_current_incl_vat;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 256)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 27)
4	Sady\Sales\Product\Variants\VariantsDoctrineRepository->findByProduct (line 52)
5	Sady\Sales\Product\Variants\VariantsTwigComponent->mount (line 159)
6	Symfony\UX\TwigComponent\ComponentFactory->mount (line 80)
7	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 65)
8	Symfony\UX\TwigComponent\ComponentFactory->create (line 55)
9	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 60)
10	Symfony\UX\TwigComponent\Twig\ComponentExtension->render (line 157)
11	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->block_main (line 442)
12	Twig\Template->yieldBlock (line 176)
13	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
14	Twig\Template->yield (line 53)
15	__TwigTemplate_55e87df771746fb29074ea644937563f->doDisplay (line 398)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->doDisplay (line 398)
18	Twig\Template->yield (line 354)
19	Twig\Template->display (line 369)
20	Twig\Template->render (line 38)
21	Twig\TemplateWrapper->render (line 306)
22	Twig\Environment->render (line 58)
23	Sady\Ui\RenderResponseSubscriber->setResponse (line 40)
24	Sady\Ui\RenderResponseSubscriber->renderView (line 115)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 7)

2.05 ms
(5.97%)

SELECT name, slug FROM shop.catalogs WHERE id <> ? ORDER BY position ASC LIMIT 20

Parameters:

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1149
    __toString(): "0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  name,
  slug
FROM
  shop.catalogs
WHERE
  id <> ?
ORDER BY
  position ASC
LIMIT
  20

SELECT name, slug FROM shop.catalogs WHERE id <> '0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35' ORDER BY position ASC LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 256)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 35)
4	Sady\Sales\Catalog\Breadcrumb\CatalogDoctrineRepository->findAvailableExceptId (line 32)
5	Sady\Sales\Catalog\Breadcrumb\CollectCatalogPathsListener->__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 28)
10	Sady\Navigation\Breadcrumb\BreadcrumbTwigComponent->getPaths (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 121)
17	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->block_main (line 442)
18	Twig\Template->yieldBlock (line 176)
19	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
20	Twig\Template->yield (line 53)
21	__TwigTemplate_55e87df771746fb29074ea644937563f->doDisplay (line 398)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->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 40)
30	Sady\Ui\RenderResponseSubscriber->renderView (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.89 ms
(5.51%)

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 53)
23	__TwigTemplate_55e87df771746fb29074ea644937563f->doDisplay (line 398)
24	Twig\Template->yield (line 55)
25	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->doDisplay (line 398)
26	Twig\Template->yield (line 354)
27	Twig\Template->display (line 369)
28	Twig\Template->render (line 38)
29	Twig\TemplateWrapper->render (line 306)
30	Twig\Environment->render (line 58)
31	Sady\Ui\RenderResponseSubscriber->setResponse (line 40)
32	Sady\Ui\RenderResponseSubscriber->renderView (line 115)
33	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
34	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
35	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
36	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 7)

1.68 ms
(4.89%)

SELECT extended_description FROM shop.product_specifications WHERE id = ?

Parameters:

[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "0dfe3ee8-166d-4d05-8453-8faf3e19aa23"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  extended_description
FROM
  shop.product_specifications
WHERE
  id = ?

SELECT extended_description FROM shop.product_specifications WHERE id = '0dfe3ee8-166d-4d05-8453-8faf3e19aa23';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 232)
3	Doctrine\DBAL\Query\QueryBuilder->fetchOne (line 33)
4	Sady\Sales\Product\Specifications\DescriptionTwigComponent->mount (line 159)
5	Symfony\UX\TwigComponent\ComponentFactory->mount (line 80)
6	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 65)
7	Symfony\UX\TwigComponent\ComponentFactory->create (line 55)
8	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 60)
9	Symfony\UX\TwigComponent\Twig\ComponentExtension->render (line 241)
10	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->block_main (line 442)
11	Twig\Template->yieldBlock (line 176)
12	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_55e87df771746fb29074ea644937563f->doDisplay (line 398)
15	Twig\Template->yield (line 55)
16	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->doDisplay (line 398)
17	Twig\Template->yield (line 354)
18	Twig\Template->display (line 369)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 306)
21	Twig\Environment->render (line 58)
22	Sady\Ui\RenderResponseSubscriber->setResponse (line 40)
23	Sady\Ui\RenderResponseSubscriber->renderView (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 7)

1.55 ms
(4.53%)

SELECT suitable_for FROM shop.product_specifications WHERE id = ?

Parameters:

[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "0dfe3ee8-166d-4d05-8453-8faf3e19aa23"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  suitable_for
FROM
  shop.product_specifications
WHERE
  id = ?

SELECT suitable_for FROM shop.product_specifications WHERE id = '0dfe3ee8-166d-4d05-8453-8faf3e19aa23';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 232)
3	Doctrine\DBAL\Query\QueryBuilder->fetchOne (line 33)
4	Sady\Sales\Product\Specifications\SuitableForTwigComponent->mount (line 159)
5	Symfony\UX\TwigComponent\ComponentFactory->mount (line 80)
6	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 65)
7	Symfony\UX\TwigComponent\ComponentFactory->create (line 55)
8	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 60)
9	Symfony\UX\TwigComponent\Twig\ComponentExtension->render (line 269)
10	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->block_main (line 442)
11	Twig\Template->yieldBlock (line 176)
12	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_55e87df771746fb29074ea644937563f->doDisplay (line 398)
15	Twig\Template->yield (line 55)
16	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->doDisplay (line 398)
17	Twig\Template->yield (line 354)
18	Twig\Template->display (line 369)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 306)
21	Twig\Environment->render (line 58)
22	Sady\Ui\RenderResponseSubscriber->setResponse (line 40)
23	Sady\Ui\RenderResponseSubscriber->renderView (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 7)

1.46 ms
(4.25%)

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE parent_id = ? and id <> ? ORDER BY position ASC LIMIT 20

Parameters:

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1149
    __toString(): "0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35"
  }
  Termyn\Uuid\Symfony\SymfonyUuid {#1145
    __toString(): "358d7864-59ef-4723-8c4b-72eaaffe8f2b"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  abbreviation,
  slug,
  parent_id
FROM
  shop.catalog_categories
WHERE
  parent_id = ?
  and id <> ?
ORDER BY
  position ASC
LIMIT
  20

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE parent_id = '0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35' and id <> '358d7864-59ef-4723-8c4b-72eaaffe8f2b' ORDER BY position ASC LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 256)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 38)
4	Sady\Sales\Catalog\Breadcrumb\CategoryDoctrineRepository->findAvailableByParentExceptId (line 30)
5	Sady\Sales\Catalog\Breadcrumb\CollectCategoriesPathsListener->__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 28)
10	Sady\Navigation\Breadcrumb\BreadcrumbTwigComponent->getPaths (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 121)
17	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->block_main (line 442)
18	Twig\Template->yieldBlock (line 176)
19	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
20	Twig\Template->yield (line 53)
21	__TwigTemplate_55e87df771746fb29074ea644937563f->doDisplay (line 398)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->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 40)
30	Sady\Ui\RenderResponseSubscriber->renderView (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.45 ms
(4.24%)

SELECT name, value FROM shop.product_attributes WHERE id = ?

Parameters:

[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "0dfe3ee8-166d-4d05-8453-8faf3e19aa23"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  name,
  value
FROM
  shop.product_attributes
WHERE
  id = ?

SELECT name, value FROM shop.product_attributes WHERE id = '0dfe3ee8-166d-4d05-8453-8faf3e19aa23';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 269)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAllKeyValue (line 33)
4	Sady\Sales\Product\Attributes\AttributesTwigComponent->mount (line 159)
5	Symfony\UX\TwigComponent\ComponentFactory->mount (line 80)
6	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 65)
7	Symfony\UX\TwigComponent\ComponentFactory->create (line 55)
8	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 60)
9	Symfony\UX\TwigComponent\Twig\ComponentExtension->render (line 281)
10	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->block_main (line 442)
11	Twig\Template->yieldBlock (line 176)
12	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_55e87df771746fb29074ea644937563f->doDisplay (line 398)
15	Twig\Template->yield (line 55)
16	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->doDisplay (line 398)
17	Twig\Template->yield (line 354)
18	Twig\Template->display (line 369)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 306)
21	Twig\Environment->render (line 58)
22	Sady\Ui\RenderResponseSubscriber->setResponse (line 40)
23	Sady\Ui\RenderResponseSubscriber->renderView (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 7)

1.36 ms
(3.95%)

SELECT key_features FROM shop.product_specifications WHERE id = ?

Parameters:

[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "0dfe3ee8-166d-4d05-8453-8faf3e19aa23"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  key_features
FROM
  shop.product_specifications
WHERE
  id = ?

SELECT key_features FROM shop.product_specifications WHERE id = '0dfe3ee8-166d-4d05-8453-8faf3e19aa23';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 232)
3	Doctrine\DBAL\Query\QueryBuilder->fetchOne (line 33)
4	Sady\Sales\Product\Specifications\KeyFeaturesTwigComponent->mount (line 159)
5	Symfony\UX\TwigComponent\ComponentFactory->mount (line 80)
6	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 65)
7	Symfony\UX\TwigComponent\ComponentFactory->create (line 55)
8	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 60)
9	Symfony\UX\TwigComponent\Twig\ComponentExtension->render (line 273)
10	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->block_main (line 442)
11	Twig\Template->yieldBlock (line 176)
12	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_55e87df771746fb29074ea644937563f->doDisplay (line 398)
15	Twig\Template->yield (line 55)
16	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->doDisplay (line 398)
17	Twig\Template->yield (line 354)
18	Twig\Template->display (line 369)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 306)
21	Twig\Environment->render (line 58)
22	Sady\Ui\RenderResponseSubscriber->setResponse (line 40)
23	Sady\Ui\RenderResponseSubscriber->renderView (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 7)

1.27 ms
(3.69%)

SELECT name, category_id FROM shop.products WHERE id = ?

Parameters:

[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "0dfe3ee8-166d-4d05-8453-8faf3e19aa23"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  name,
  category_id
FROM
  shop.products
WHERE
  id = ?

SELECT name, category_id FROM shop.products WHERE id = '0dfe3ee8-166d-4d05-8453-8faf3e19aa23';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 206)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAssociative (line 27)
4	Sady\Sales\Product\Breadcrumb\ProductDoctrineRepository->getById (line 22)
5	Sady\Sales\Product\Breadcrumb\ResolveProductPathListener->__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 28)
10	Sady\Navigation\Breadcrumb\BreadcrumbTwigComponent->getPaths (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 121)
17	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->block_main (line 442)
18	Twig\Template->yieldBlock (line 176)
19	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
20	Twig\Template->yield (line 53)
21	__TwigTemplate_55e87df771746fb29074ea644937563f->doDisplay (line 398)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->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 40)
30	Sady\Ui\RenderResponseSubscriber->renderView (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.25 ms
(3.64%)

SELECT name, slug FROM shop.catalogs WHERE id = ?

Parameters:

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1149
    __toString(): "0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  name,
  slug
FROM
  shop.catalogs
WHERE
  id = ?

SELECT name, slug FROM shop.catalogs WHERE id = '0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 206)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAssociative (line 23)
4	Sady\Sales\Catalog\Breadcrumb\CatalogDoctrineRepository->getById (line 24)
5	Sady\Sales\Catalog\Breadcrumb\CollectCatalogPathsListener->__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 28)
10	Sady\Navigation\Breadcrumb\BreadcrumbTwigComponent->getPaths (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 121)
17	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->block_main (line 442)
18	Twig\Template->yieldBlock (line 176)
19	__TwigTemplate_111fe16a0b1f34e388fb9f9012116b00->doDisplay (line 398)
20	Twig\Template->yield (line 53)
21	__TwigTemplate_55e87df771746fb29074ea644937563f->doDisplay (line 398)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_dc3abd90a5e6bce6e8f62be7ef525568->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 40)
30	Sady\Ui\RenderResponseSubscriber->renderView (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)

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/produkt/kalove-cerpadlo-feka

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping