Symfony Profiler

Query Metrics

33 Database Queries

12 Different statements

18.04 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

5.30 ms
(29.38%)

SELECT t0.id AS id_1, t0.dose AS dose_2, t0.packs AS packs_3, t0.price AS price_4, t0.old_price AS old_price_5, t0.shop_item_id AS shop_item_id_6 FROM variants t0 WHERE t0.shop_item_id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.dose AS dose_2,
  t0.packs AS packs_3,
  t0.price AS price_4,
  t0.old_price AS old_price_5,
  t0.shop_item_id AS shop_item_id_6
FROM
  variants t0
WHERE
  t0.shop_item_id = ?

SELECT t0.id AS id_1, t0.dose AS dose_2, t0.packs AS packs_3, t0.price AS price_4, t0.old_price AS old_price_5, t0.shop_item_id AS shop_item_id_6 FROM variants t0 WHERE t0.shop_item_id = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 341)
4	App\Controller\IndexController->shopItem (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

4.31 ms
(23.89%)

SELECT t0.id AS id_1, t0.image AS image_2, t0.shop_item_id AS shop_item_id_3 FROM product_images t0 WHERE t0.shop_item_id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.shop_item_id AS shop_item_id_3
FROM
  product_images t0
WHERE
  t0.shop_item_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.shop_item_id AS shop_item_id_3 FROM product_images t0 WHERE t0.shop_item_id = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1828)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1773)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 114)
8	__TwigTemplate_0dcf1dd5fdeaabbb74fe765f97bb7718->block_body (line 430)
9	Twig\Template->yieldBlock (line 163)
10	__TwigTemplate_bc74e25818f8950726da1b3b704fed13->doDisplay (line 360)
11	Twig\Template->yield (line 49)
12	__TwigTemplate_0dcf1dd5fdeaabbb74fe765f97bb7718->doDisplay (line 360)
13	Twig\Template->yield (line 335)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 306)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 360)
20	App\Controller\IndexController->shopItem (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

2.26 ms
(12.55%)

SELECT p0_.image AS image_0 FROM product_images p0_ WHERE p0_.shop_item_id = ? LIMIT 1

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.image AS image_0
FROM
  product_images p0_
WHERE
  p0_.shop_item_id = ?
LIMIT
  1

SELECT p0_.image AS image_0 FROM product_images p0_ WHERE p0_.shop_item_id = 3 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 17)
7	App\Repository\ProductImagesRepository->getFirstImage (line 93)
8	App\Twig\Catalog->getFirstImage (line 260)
9	__TwigTemplate_1ba0e39d44a1b5845562086bfc9ac3db->doDisplay (line 360)
10	Twig\Template->yield (line 146)
11	__TwigTemplate_bc74e25818f8950726da1b3b704fed13->doDisplay (line 360)
12	Twig\Template->yield (line 49)
13	__TwigTemplate_0dcf1dd5fdeaabbb74fe765f97bb7718->doDisplay (line 360)
14	Twig\Template->yield (line 335)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 360)
21	App\Controller\IndexController->shopItem (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

2.07 ms
(11.49%)

SELECT t0.id AS id_1, t0.dose AS dose_2, t0.packs AS packs_3, t0.price AS price_4, t0.old_price AS old_price_5, t0.shop_item_id AS shop_item_id_6 FROM variants t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.dose AS dose_2,
  t0.packs AS packs_3,
  t0.price AS price_4,
  t0.old_price AS old_price_5,
  t0.shop_item_id AS shop_item_id_6
FROM
  variants t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.dose AS dose_2, t0.packs AS packs_3, t0.price AS price_4, t0.old_price AS old_price_5, t0.shop_item_id AS shop_item_id_6 FROM variants t0 WHERE t0.id = 1;

#	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 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Main\Variants::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Main\Variants->__get (line 88)
8	App\Entity\Main\Variants->getShopItem (line 1719)
9	Twig\Extension\CoreExtension::getAttribute (line 260)
10	__TwigTemplate_1ba0e39d44a1b5845562086bfc9ac3db->doDisplay (line 360)
11	Twig\Template->yield (line 146)
12	__TwigTemplate_bc74e25818f8950726da1b3b704fed13->doDisplay (line 360)
13	Twig\Template->yield (line 49)
14	__TwigTemplate_0dcf1dd5fdeaabbb74fe765f97bb7718->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 306)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 360)
22	App\Controller\IndexController->shopItem (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.64 ms
(3.55%)

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.is_hit AS is_hit_2, s0_.is_kit AS is_kit_3, s0_.is_out_of_stock AS is_out_of_stock_4, s0_.description AS description_5, s0_.sku AS sku_6, s0_.catalog_id_id AS catalog_id_id_7 FROM shop_items s0_ WHERE s0_.sku LIKE ? AND s0_.id <> ?

Parameters:

[
  "db-%"
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.is_hit AS is_hit_2,
  s0_.is_kit AS is_kit_3,
  s0_.is_out_of_stock AS is_out_of_stock_4,
  s0_.description AS description_5,
  s0_.sku AS sku_6,
  s0_.catalog_id_id AS catalog_id_id_7
FROM
  shop_items s0_
WHERE
  s0_.sku LIKE ?
  AND s0_.id <> ?

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.is_hit AS is_hit_2, s0_.is_kit AS is_kit_3, s0_.is_out_of_stock AS is_out_of_stock_4, s0_.description AS description_5, s0_.sku AS sku_6, s0_.catalog_id_id AS catalog_id_id_7 FROM shop_items s0_ WHERE s0_.sku LIKE 'db-%' AND s0_.id <> 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 117)
7	App\Repository\ShopItemsRepository->getBySku (line 338)
8	App\Controller\IndexController->shopItem (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.63 ms
(3.49%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_hit AS is_hit_3, t0.is_kit AS is_kit_4, t0.is_out_of_stock AS is_out_of_stock_5, t0.description AS description_6, t0.sku AS sku_7, t0.catalog_id_id AS catalog_id_id_8 FROM shop_items t0 WHERE t0.id = ?

Parameters:

[
  "16"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.is_hit AS is_hit_3,
  t0.is_kit AS is_kit_4,
  t0.is_out_of_stock AS is_out_of_stock_5,
  t0.description AS description_6,
  t0.sku AS sku_7,
  t0.catalog_id_id AS catalog_id_id_8
FROM
  shop_items t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_hit AS is_hit_3, t0.is_kit AS is_kit_4, t0.is_out_of_stock AS is_out_of_stock_5, t0.description AS description_6, t0.sku AS sku_7, t0.catalog_id_id AS catalog_id_id_8 FROM shop_items t0 WHERE t0.id = '16';

#	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 86)
5	Doctrine\ORM\EntityRepository->find (line 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.61 ms
(3.35%)

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.count AS count_3, t0.discount AS discount_4, t0.is_free_item AS is_free_item_5, t0.shop_item_id AS shop_item_id_6, t0.variant_id AS variant_id_7 FROM shop_cart t0 WHERE t0.session_id IS NULL

Parameters:

[]

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.count AS count_3,
  t0.discount AS discount_4,
  t0.is_free_item AS is_free_item_5,
  t0.shop_item_id AS shop_item_id_6,
  t0.variant_id AS variant_id_7
FROM
  shop_cart t0
WHERE
  t0.session_id IS NULL

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.count AS count_3, t0.discount AS discount_4, t0.is_free_item AS is_free_item_5, t0.shop_item_id AS shop_item_id_6, t0.variant_id AS variant_id_7 FROM shop_cart t0 WHERE t0.session_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 50)
4	App\Twig\ShopCart->getShopCart (line 44)
5	__TwigTemplate_1ba0e39d44a1b5845562086bfc9ac3db->doDisplay (line 360)
6	Twig\Template->yield (line 146)
7	__TwigTemplate_bc74e25818f8950726da1b3b704fed13->doDisplay (line 360)
8	Twig\Template->yield (line 49)
9	__TwigTemplate_0dcf1dd5fdeaabbb74fe765f97bb7718->doDisplay (line 360)
10	Twig\Template->yield (line 335)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 306)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 360)
17	App\Controller\IndexController->shopItem (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.51 ms
(2.81%)

SELECT f0_.id AS id_0, f0_.min_order AS min_order_1, f0_.variant_id AS variant_id_2 FROM free_products f0_ ORDER BY f0_.min_order ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.min_order AS min_order_1,
  f0_.variant_id AS variant_id_2
FROM
  free_products f0_
ORDER BY
  f0_.min_order ASC

SELECT f0_.id AS id_0, f0_.min_order AS min_order_1, f0_.variant_id AS variant_id_2 FROM free_products f0_ ORDER BY f0_.min_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 20)
7	App\Repository\FreeProductsRepository->findAndOrder (line 75)
8	App\Twig\ShopCart->getFreeProducts (line 50)
9	__TwigTemplate_1ba0e39d44a1b5845562086bfc9ac3db->doDisplay (line 360)
10	Twig\Template->yield (line 146)
11	__TwigTemplate_bc74e25818f8950726da1b3b704fed13->doDisplay (line 360)
12	Twig\Template->yield (line 49)
13	__TwigTemplate_0dcf1dd5fdeaabbb74fe765f97bb7718->doDisplay (line 360)
14	Twig\Template->yield (line 335)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 360)
21	App\Controller\IndexController->shopItem (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.49 ms
(2.72%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.is_menu_item AS is_menu_item_4, t0.html AS html_5 FROM pages t0 WHERE t0.is_menu_item = ?

Parameters:

[
  1
]

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.is_menu_item AS is_menu_item_4,
  t0.html AS html_5
FROM
  pages t0
WHERE
  t0.is_menu_item = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.is_menu_item AS is_menu_item_4, t0.html AS html_5 FROM pages t0 WHERE t0.is_menu_item = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 88)
4	App\Twig\Catalog->getPagesForMenu (line 109)
5	__TwigTemplate_6f73f992f09da50f1da87b1970abf486->doDisplay (line 360)
6	Twig\Template->yield (line 155)
7	__TwigTemplate_bc74e25818f8950726da1b3b704fed13->doDisplay (line 360)
8	Twig\Template->yield (line 49)
9	__TwigTemplate_0dcf1dd5fdeaabbb74fe765f97bb7718->doDisplay (line 360)
10	Twig\Template->yield (line 335)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 306)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 360)
17	App\Controller\IndexController->shopItem (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.46 ms
(2.54%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3, t0.description AS description_4, t0.image AS image_5, t0.big_image AS big_image_6 FROM categories t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.parent_id AS parent_id_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.big_image AS big_image_6
FROM
  categories t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3, t0.description AS description_4, t0.image AS image_5, t0.big_image AS big_image_6 FROM categories t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 96)
4	Doctrine\ORM\EntityRepository->findAll (line 74)
5	App\Twig\Catalog->getMenuCategories (line 50)
6	__TwigTemplate_6f73f992f09da50f1da87b1970abf486->doDisplay (line 360)
7	Twig\Template->yield (line 155)
8	__TwigTemplate_bc74e25818f8950726da1b3b704fed13->doDisplay (line 360)
9	Twig\Template->yield (line 49)
10	__TwigTemplate_0dcf1dd5fdeaabbb74fe765f97bb7718->doDisplay (line 360)
11	Twig\Template->yield (line 335)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 306)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 360)
18	App\Controller\IndexController->shopItem (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.40 ms
(2.20%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_hit AS is_hit_3, t0.is_kit AS is_kit_4, t0.is_out_of_stock AS is_out_of_stock_5, t0.description AS description_6, t0.sku AS sku_7, t0.catalog_id_id AS catalog_id_id_8 FROM shop_items t0 WHERE t0.is_hit = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.is_hit AS is_hit_3,
  t0.is_kit AS is_kit_4,
  t0.is_out_of_stock AS is_out_of_stock_5,
  t0.description AS description_6,
  t0.sku AS sku_7,
  t0.catalog_id_id AS catalog_id_id_8
FROM
  shop_items t0
WHERE
  t0.is_hit = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_hit AS is_hit_3, t0.is_kit AS is_kit_4, t0.is_out_of_stock AS is_out_of_stock_5, t0.description AS description_6, t0.sku AS sku_7, t0.catalog_id_id AS catalog_id_id_8 FROM shop_items t0 WHERE t0.is_hit = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 339)
4	App\Controller\IndexController->shopItem (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.37 ms
(2.02%)

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.text AS text_3, t0.name AS name_4, t0.date AS date_5, t0.shop_item_id AS shop_item_id_6 FROM reviews t0 WHERE t0.shop_item_id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.text AS text_3,
  t0.name AS name_4,
  t0.date AS date_5,
  t0.shop_item_id AS shop_item_id_6
FROM
  reviews t0
WHERE
  t0.shop_item_id = ?

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.text AS text_3, t0.name AS name_4, t0.date AS date_5, t0.shop_item_id AS shop_item_id_6 FROM reviews t0 WHERE t0.shop_item_id = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 358)
4	App\Controller\IndexController->shopItem (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

Database Connections

Name	Service
tenant	doctrine.dbal.tenant_connection
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
tenant	doctrine.orm.tenant_entity_manager
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

tenant entity manager

No loaded entities.

default entity manager

Class	Mapping errors
App\Entity\Main\ShopItems	The association App\Entity\Main\ShopItems#catalogId refers to the inverse side field App\Entity\Main\Categories#id which is not defined as association. The association App\Entity\Main\ShopItems#catalogId refers to the inverse side field App\Entity\Main\Categories#id which does not exist. The mappings App\Entity\Main\ShopItems#images and App\Entity\Main\ProductImages#shopItem are inconsistent with each other. The mappings App\Entity\Main\ShopItems#variants and App\Entity\Main\Variants#shopItem are inconsistent with each other. The mappings App\Entity\Main\ShopItems#reviews and App\Entity\Main\Reviews#shopItem are inconsistent with each other.
App\Entity\Main\Categories	No errors.
App\Entity\Main\ShopCart	The mappings App\Entity\Main\ShopCart#variant and App\Entity\Main\Variants#shopCarts are inconsistent with each other.
App\Entity\Main\ProductImages	The association App\Entity\Main\ProductImages#shopItem refers to the inverse side field App\Entity\Main\ShopItems#id which is not defined as association. The association App\Entity\Main\ProductImages#shopItem refers to the inverse side field App\Entity\Main\ShopItems#id which does not exist.
App\Entity\Main\Variants	The association App\Entity\Main\Variants#shopItem refers to the inverse side field App\Entity\Main\ShopItems#id which is not defined as association. The association App\Entity\Main\Variants#shopItem refers to the inverse side field App\Entity\Main\ShopItems#id which does not exist. The association App\Entity\Main\Variants#shopCarts refers to the owning side field App\Entity\Main\ShopCart#shopCarts which does not exist.
App\Entity\Main\Reviews	The association App\Entity\Main\Reviews#shopItem refers to the inverse side field App\Entity\Main\ShopItems#id which is not defined as association. The association App\Entity\Main\Reviews#shopItem refers to the inverse side field App\Entity\Main\ShopItems#id which does not exist.
App\Entity\Main\FreeProducts	No errors.
App\Entity\Main\Pages	No errors.

Symfony Profiler

GET https://sampleretailhub.com/shop/item/16

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

tenant entity manager

default entity manager