Symfony Profiler

Query Metrics

29 Database Queries

12 Different statements

15.05 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

4.36 ms
(28.94%)

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 50)
13	__TwigTemplate_b9f29dafb54e485181d75d38b5355d93->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 67)
21	App\Controller\IndexController->index (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)

3.10 ms
(20.59%)

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:

[
  3
]

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 = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 54)
4	App\Twig\Catalog->getMinPriceForProduct (line 218)
5	__TwigTemplate_b9f29dafb54e485181d75d38b5355d93->block_body (line 430)
6	Twig\Template->yieldBlock (line 163)
7	__TwigTemplate_bc74e25818f8950726da1b3b704fed13->doDisplay (line 360)
8	Twig\Template->yield (line 50)
9	__TwigTemplate_b9f29dafb54e485181d75d38b5355d93->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 67)
17	App\Controller\IndexController->index (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)

1.76 ms
(11.72%)

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 50)
14	__TwigTemplate_b9f29dafb54e485181d75d38b5355d93->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 67)
22	App\Controller\IndexController->index (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)

1.12 ms
(7.42%)

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 51)
4	App\Controller\IndexController->index (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.74 ms
(4.93%)

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 50)
13	__TwigTemplate_b9f29dafb54e485181d75d38b5355d93->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 67)
21	App\Controller\IndexController->index (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.68 ms
(4.51%)

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 ORDER BY t0.id DESC LIMIT 5

Parameters:

[]

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
ORDER BY
  t0.id DESC
LIMIT
  5

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 ORDER BY t0.id DESC LIMIT 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 65)
4	App\Controller\IndexController->index (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.65 ms
(4.34%)

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 50)
9	__TwigTemplate_b9f29dafb54e485181d75d38b5355d93->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 67)
17	App\Controller\IndexController->index (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.63 ms
(4.18%)

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 WHERE t0.parent_id = ?

Parameters:

[
  0
]

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
WHERE
  t0.parent_id = ?

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 WHERE t0.parent_id = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 52)
4	App\Controller\IndexController->index (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.56 ms
(3.75%)

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 50)
10	__TwigTemplate_b9f29dafb54e485181d75d38b5355d93->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 67)
18	App\Controller\IndexController->index (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.54 ms
(3.60%)

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 ORDER BY t0.id DESC LIMIT 20

Parameters:

[]

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
ORDER BY
  t0.id DESC
LIMIT
  20

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 ORDER BY t0.id DESC LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 61)
4	App\Controller\IndexController->index (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.46 ms
(3.03%)

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:

[
  9
]

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 = 9;

#	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\ShopItems::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Main\ShopItems->__get (line 136)
8	App\Entity\Main\ShopItems->getTitle (line 1719)
9	Twig\Extension\CoreExtension::getAttribute (line 274)
10	__TwigTemplate_1ba0e39d44a1b5845562086bfc9ac3db->doDisplay (line 360)
11	Twig\Template->yield (line 146)
12	__TwigTemplate_bc74e25818f8950726da1b3b704fed13->doDisplay (line 360)
13	Twig\Template->yield (line 50)
14	__TwigTemplate_b9f29dafb54e485181d75d38b5355d93->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 67)
22	App\Controller\IndexController->index (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.45 ms
(2.98%)

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 50)
9	__TwigTemplate_b9f29dafb54e485181d75d38b5355d93->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 67)
17	App\Controller\IndexController->index (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)

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\Pages	No errors.
App\Entity\Main\FreeProducts	No errors.

Symfony Profiler

GET https://sampleretailhub.com/

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