Symfony Profiler

Query Metrics

19 Database Queries

13 Different statements

5.77 ms Query time

4 Invalid entities

20 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.57 ms
(27.22%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM product_attributes t0 WHERE t0.id = ?

Parameters:

[
  22
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3
FROM
  product_attributes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM product_attributes t0 WHERE t0.id = 22;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():280} (line 359)
5	Proxies\__CG__\App\Entity\ProductAttribute::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():357}:358} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\ProductAttribute->__get (line 48)
8	App\Entity\ProductAttribute->getName (line 96)
9	App\Entity\Product->_get (line 138)
10	App\Entity\Product->__call (line 1909)
11	Twig\Extension\CoreExtension::getAttribute (line 450)
12	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->block_main (line 446)
13	Twig\Template->yieldBlock (line 87)
14	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->block_body (line 446)
15	Twig\Template->yieldBlock (line 86)
16	__TwigTemplate_14aeedafb46d1953fc74a4aa0269c31f->doDisplay (line 402)
17	Twig\Template->yield (line 56)
18	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->doDisplay (line 402)
19	Twig\Template->yield (line 53)
20	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
29	App\Controller\Website\ProductController->show (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.91 ms
(15.75%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.description AS description_4, t0.price AS price_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9 FROM products t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "stocolor-isol-spray-stocolor-isol-spray-weiss-400-ml"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.slug AS slug_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9
FROM
  products t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.description AS description_4, t0.price AS price_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9 FROM products t0 WHERE t0.slug = 'stocolor-isol-spray-stocolor-isol-spray-weiss-400-ml' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 79)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
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 5)

0.55 ms
(9.51%)

INSERT INTO carts (session_id, type, created_at, updated_at, deleted_at, customer_id) VALUES (?, ?, ?, ?, ?, ?)

Parameters:

[
  "01gsq2j3vsgh5tn3dgve10pn2j"
  "wishlist"
  "2025-07-21 00:39:19"
  "2025-07-21 00:39:19"
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO carts (
  session_id, type, created_at, updated_at,
  deleted_at, customer_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO carts (session_id, type, created_at, updated_at, deleted_at, customer_id) VALUES ('01gsq2j3vsgh5tn3dgve10pn2j', 'wishlist', '2025-07-21 00:39:19', '2025-07-21 00:39:19', NULL, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 261)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1057)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 402)
5	Doctrine\ORM\UnitOfWork->commit (line 268)
6	Doctrine\ORM\EntityManager->flush (line 30)
7	App\Manager\CartOperationsManager->createNewCart (line 167)
8	App\Manager\CartManager->getCurrentCart (line 124)
9	App\Manager\CartManager->hasItem (line 59)
10	App\Controller\Website\ProductController->show (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.50 ms
(8.68%)

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.customer_id AS customer_id_7 FROM carts t0 WHERE t0.id = ? AND t0.type = ? LIMIT 1

Parameters:

[
  1038
  "cart"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.type AS type_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.customer_id AS customer_id_7
FROM
  carts t0
WHERE
  t0.id = ?
  AND t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.customer_id AS customer_id_7 FROM carts t0 WHERE t0.id = 1038 AND t0.type = 'cart' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 26)
5	App\Storage\CartSessionStorage->getCart (line 142)
6	App\Manager\CartManager->getCurrentCart (line 82)
7	App\Manager\CartManager->getCartCount (line 39)
8	App\Twig\Extension\CartExtension->getCartCount (line 54)
9	__TwigTemplate_f7ae94a4edb614fdb447c91d1fc0d908->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 77)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 70)
16	__TwigTemplate_4d797a197d178d6663f250ec6a16355c->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1520)
21	Twig\Extension\CoreExtension::include (line 130)
22	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->block_header (line 446)
23	Twig\Template->yieldBlock (line 82)
24	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->block_body (line 446)
25	Twig\Template->yieldBlock (line 86)
26	__TwigTemplate_14aeedafb46d1953fc74a4aa0269c31f->doDisplay (line 402)
27	Twig\Template->yield (line 56)
28	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->doDisplay (line 402)
29	Twig\Template->yield (line 53)
30	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->doDisplay (line 402)
31	Twig\Template->yield (line 358)
32	Twig\Template->display (line 373)
33	Twig\Template->render (line 51)
34	Twig\TemplateWrapper->render (line 333)
35	Twig\Environment->render (line 459)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
39	App\Controller\Website\ProductController->show (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	require_once (line 5)

0.29 ms
(5.09%)

SELECT t0.id AS id_1, t0.ref AS ref_2, t0.description AS description_3, t0.color_class AS color_class_4, t0.r_color AS r_color_5, t0.g_color AS g_color_6, t0.b_color AS b_color_7, t0.y AS y_8, t0.l AS l_9, t0.a AS a_10, t0.b AS b_11, t0.c AS c_12, t0.h AS h_13, t0.cmy_c AS cmy_c_14, t0.cmy_m AS cmy_m_15, t0.cmy_y AS cmy_y_16, t0.cmyk_c AS cmyk_c_17, t0.cmyk_m AS cmyk_m_18, t0.cmyk_y AS cmyk_y_19, t0.cmyk_k AS cmyk_k_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.deleted_at AS deleted_at_23, t0.color_catalogue_id AS color_catalogue_id_24 FROM colors t0 WHERE t0.id IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ref AS ref_2,
  t0.description AS description_3,
  t0.color_class AS color_class_4,
  t0.r_color AS r_color_5,
  t0.g_color AS g_color_6,
  t0.b_color AS b_color_7,
  t0.y AS y_8,
  t0.l AS l_9,
  t0.a AS a_10,
  t0.b AS b_11,
  t0.c AS c_12,
  t0.h AS h_13,
  t0.cmy_c AS cmy_c_14,
  t0.cmy_m AS cmy_m_15,
  t0.cmy_y AS cmy_y_16,
  t0.cmyk_c AS cmyk_c_17,
  t0.cmyk_m AS cmyk_m_18,
  t0.cmyk_y AS cmyk_y_19,
  t0.cmyk_k AS cmyk_k_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.deleted_at AS deleted_at_23,
  t0.color_catalogue_id AS color_catalogue_id_24
FROM
  colors t0
WHERE
  t0.id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.ref AS ref_2, t0.description AS description_3, t0.color_class AS color_class_4, t0.r_color AS r_color_5, t0.g_color AS g_color_6, t0.b_color AS b_color_7, t0.y AS y_8, t0.l AS l_9, t0.a AS a_10, t0.b AS b_11, t0.c AS c_12, t0.h AS h_13, t0.cmy_c AS cmy_c_14, t0.cmy_m AS cmy_m_15, t0.cmy_y AS cmy_y_16, t0.cmyk_c AS cmyk_c_17, t0.cmyk_m AS cmyk_m_18, t0.cmyk_y AS cmyk_y_19, t0.cmyk_k AS cmyk_k_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.deleted_at AS deleted_at_23, t0.color_catalogue_id AS color_catalogue_id_24 FROM colors t0 WHERE t0.id IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 36)
5	App\Controller\Website\ProductController->show (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.29 ms
(4.96%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.format AS format_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9 FROM currencies t0 WHERE t0.code = ? AND t0.is_active = ? LIMIT 1

Parameters:

[
  "EUR"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3,
  t0.is_active AS is_active_4,
  t0.is_default AS is_default_5,
  t0.format AS format_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9
FROM
  currencies t0
WHERE
  t0.code = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.format AS format_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9 FROM currencies t0 WHERE t0.code = 'EUR' AND t0.is_active = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 67)
5	App\Formatter\MoneyFormatter->getCurrency (line 30)
6	App\Formatter\MoneyFormatter->format (line 18)
7	App\Twig\Extension\MoneyExtension->formatMoney (line 284)
8	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->block_main (line 446)
9	Twig\Template->yieldBlock (line 87)
10	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->block_body (line 446)
11	Twig\Template->yieldBlock (line 86)
12	__TwigTemplate_14aeedafb46d1953fc74a4aa0269c31f->doDisplay (line 402)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->doDisplay (line 402)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
25	App\Controller\Website\ProductController->show (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.27 ms
(4.69%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.thumbnail AS thumbnail_4, t0.featured AS featured_5, t0.product_id AS product_id_6 FROM product_images t0 WHERE t0.product_id = ?

Parameters:

[
  1162
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.thumbnail AS thumbnail_4,
  t0.featured AS featured_5,
  t0.product_id AS product_id_6
FROM
  product_images t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.thumbnail AS thumbnail_4, t0.featured AS featured_5, t0.product_id AS product_id_6 FROM product_images t0 WHERE t0.product_id = 1162;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 166)
8	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->block_main (line 446)
9	Twig\Template->yieldBlock (line 87)
10	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->block_body (line 446)
11	Twig\Template->yieldBlock (line 86)
12	__TwigTemplate_14aeedafb46d1953fc74a4aa0269c31f->doDisplay (line 402)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->doDisplay (line 402)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
25	App\Controller\Website\ProductController->show (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.27 ms
(4.61%)

SELECT t0.id AS id_1, t0.value AS value_2, t0.metadata AS metadata_3, t0.price_adjustment AS price_adjustment_4, t0.product_id AS product_id_5, t0.option_id AS option_id_6 FROM product_option_values t0 WHERE t0.product_id = ?

Parameters:

[
  1162
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.metadata AS metadata_3,
  t0.price_adjustment AS price_adjustment_4,
  t0.product_id AS product_id_5,
  t0.option_id AS option_id_6
FROM
  product_option_values t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.metadata AS metadata_3, t0.price_adjustment AS price_adjustment_4, t0.product_id AS product_id_5, t0.option_id AS option_id_6 FROM product_option_values t0 WHERE t0.product_id = 1162;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1272)
9	Twig\Extension\CoreExtension::length (line 341)
10	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->block_main (line 446)
11	Twig\Template->yieldBlock (line 87)
12	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->block_body (line 446)
13	Twig\Template->yieldBlock (line 86)
14	__TwigTemplate_14aeedafb46d1953fc74a4aa0269c31f->doDisplay (line 402)
15	Twig\Template->yield (line 56)
16	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->doDisplay (line 402)
17	Twig\Template->yield (line 53)
18	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 459)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
27	App\Controller\Website\ProductController->show (line 183)
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 5)

0.26 ms
(4.52%)

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.cart_id AS cart_id_3, t0.product_id AS product_id_4 FROM cart_items t0 WHERE t0.cart_id = ?

Parameters:

[
  1038
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.cart_id AS cart_id_3,
  t0.product_id AS product_id_4
FROM
  cart_items t0
WHERE
  t0.cart_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.cart_id AS cart_id_3, t0.product_id AS product_id_4 FROM cart_items t0 WHERE t0.cart_id = 1038;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 85)
8	App\Manager\CartManager->getCartCount (line 39)
9	App\Twig\Extension\CartExtension->getCartCount (line 54)
10	__TwigTemplate_f7ae94a4edb614fdb447c91d1fc0d908->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 70)
17	__TwigTemplate_4d797a197d178d6663f250ec6a16355c->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 1520)
22	Twig\Extension\CoreExtension::include (line 130)
23	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->block_header (line 446)
24	Twig\Template->yieldBlock (line 82)
25	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->block_body (line 446)
26	Twig\Template->yieldBlock (line 86)
27	__TwigTemplate_14aeedafb46d1953fc74a4aa0269c31f->doDisplay (line 402)
28	Twig\Template->yield (line 56)
29	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->doDisplay (line 402)
30	Twig\Template->yield (line 53)
31	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->doDisplay (line 402)
32	Twig\Template->yield (line 358)
33	Twig\Template->display (line 373)
34	Twig\Template->render (line 51)
35	Twig\TemplateWrapper->render (line 333)
36	Twig\Environment->render (line 459)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
40	App\Controller\Website\ProductController->show (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
43	Symfony\Component\HttpKernel\Kernel->handle (line 35)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
45	require_once (line 5)

0.26 ms
(4.52%)

SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.attribute_id AS attribute_id_4 FROM product_attribute_values t0 WHERE t0.product_id = ?

Parameters:

[
  1162
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.product_id AS product_id_3,
  t0.attribute_id AS attribute_id_4
FROM
  product_attribute_values t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.attribute_id AS attribute_id_4 FROM product_attribute_values t0 WHERE t0.product_id = 1162;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 94)
8	App\Entity\Product->_get (line 138)
9	App\Entity\Product->__call (line 1909)
10	Twig\Extension\CoreExtension::getAttribute (line 450)
11	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->block_main (line 446)
12	Twig\Template->yieldBlock (line 87)
13	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->block_body (line 446)
14	Twig\Template->yieldBlock (line 86)
15	__TwigTemplate_14aeedafb46d1953fc74a4aa0269c31f->doDisplay (line 402)
16	Twig\Template->yield (line 56)
17	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->doDisplay (line 402)
18	Twig\Template->yield (line 53)
19	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 459)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
28	App\Controller\Website\ProductController->show (line 183)
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 5)

0.26 ms
(4.45%)

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM `configurations` t0 WHERE t0.`key` = ? LIMIT 1

Parameters:

[
  "default_currency"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  `configurations` t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM `configurations` t0 WHERE t0.`key` = 'default_currency' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 65)
5	App\Formatter\MoneyFormatter->getCurrency (line 30)
6	App\Formatter\MoneyFormatter->format (line 18)
7	App\Twig\Extension\MoneyExtension->formatMoney (line 284)
8	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->block_main (line 446)
9	Twig\Template->yieldBlock (line 87)
10	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->block_body (line 446)
11	Twig\Template->yieldBlock (line 86)
12	__TwigTemplate_14aeedafb46d1953fc74a4aa0269c31f->doDisplay (line 402)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_2d094f1e09b5b8bb95b97c85266e52e8->doDisplay (line 402)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_181d23bd2b4471da7b4402a518056e63->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
25	App\Controller\Website\ProductController->show (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.18 ms
(3.18%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 381)
2	Doctrine\ORM\UnitOfWork->commit (line 268)
3	Doctrine\ORM\EntityManager->flush (line 30)
4	App\Manager\CartOperationsManager->createNewCart (line 167)
5	App\Manager\CartManager->getCurrentCart (line 124)
6	App\Manager\CartManager->hasItem (line 59)
7	App\Controller\Website\ProductController->show (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.16 ms
(2.80%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 432)
3	Doctrine\ORM\UnitOfWork->commit (line 268)
4	Doctrine\ORM\EntityManager->flush (line 30)
5	App\Manager\CartOperationsManager->createNewCart (line 167)
6	App\Manager\CartManager->getCurrentCart (line 124)
7	App\Manager\CartManager->hasItem (line 59)
8	App\Controller\Website\ProductController->show (line 183)
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 5)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\ProductAttributeValue	7
App\Entity\ProductAttribute	7
App\Entity\Cart	2
App\Entity\Product	1
App\Entity\ProductImage	1
App\Entity\Configuration	1
App\Entity\Currency	1

Entities Mapping

Class	Mapping errors
App\Entity\Product	No errors.
App\Entity\ProductAttributeValue	The mappings App\Entity\ProductAttributeValue#attribute and App\Entity\ProductAttribute#values are inconsistent with each other.
App\Entity\ProductOptionValue	The mappings App\Entity\ProductOptionValue#option and App\Entity\ProductOption#values are inconsistent with each other.
App\Entity\ProductImage	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\ProductTag	No errors.
App\Entity\Color	No errors.
App\Entity\ColorCatalogue	No errors.
App\Entity\Cart	No errors.
App\Entity\CartItem	No errors.
App\Entity\Address	No errors.
App\Entity\Customer	No errors.
App\Entity\Configuration	No errors.
App\Entity\Currency	No errors.
App\Entity\ProductOption	The association App\Entity\ProductOption#values refers to the owning side field App\Entity\ProductOptionValue#productOption which does not exist.
App\Entity\ProductAttribute	The association App\Entity\ProductAttribute#values refers to the owning side field App\Entity\ProductAttributeValue#productAttribute which does not exist.

Symfony Profiler

GET https://www.gelbeeimershop.com/products/stocolor-isol-spray-stocolor-isol-spray-weiss-400-ml

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping