Symfony Profiler

Query Metrics

19 Database Queries

13 Different statements

11.21 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

2.24 ms
(19.97%)

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_6aaa4f119c7143b43078a89afa211f4e->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 111)
22	App\Controller\IndexController->shopList (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.66 ms
(14.83%)

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_6aaa4f119c7143b43078a89afa211f4e->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 111)
21	App\Controller\IndexController->shopList (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)

1.43 ms
(12.75%)

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:

[
  3
]

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

#	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_6aaa4f119c7143b43078a89afa211f4e->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 111)
22	App\Controller\IndexController->shopList (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.16 ms
(10.34%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 FROM shop_items s0_ WHERE s0_.catalog_id_id IN (?)) dctrn_result) dctrn_table

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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
        FROM
          shop_items s0_
        WHERE
          s0_.catalog_id_id IN (?)
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 FROM shop_items s0_ WHERE s0_.catalog_id_id IN (5)) dctrn_result) dctrn_table;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 103)
8	App\Controller\IndexController->shopList (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.85 ms
(7.63%)

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.id = ?

Parameters:

[
  5
]

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.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.id = 5;

#	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 97)
6	App\Controller\IndexController->shopList (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.69 ms
(6.20%)

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_6aaa4f119c7143b43078a89afa211f4e->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 111)
17	App\Controller\IndexController->shopList (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.59 ms
(5.25%)

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_6aaa4f119c7143b43078a89afa211f4e->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 111)
21	App\Controller\IndexController->shopList (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
(4.41%)

SELECT DISTINCT id_0 FROM (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 FROM shop_items s0_ WHERE s0_.catalog_id_id IN (?)) dctrn_result LIMIT 20

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    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
    FROM
      shop_items s0_
    WHERE
      s0_.catalog_id_id IN (?)
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (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 FROM shop_items s0_ WHERE s0_.catalog_id_id IN (5)) dctrn_result LIMIT 20;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 208)
8	__TwigTemplate_6aaa4f119c7143b43078a89afa211f4e->block_body (line 430)
9	Twig\Template->yieldBlock (line 163)
10	__TwigTemplate_bc74e25818f8950726da1b3b704fed13->doDisplay (line 360)
11	Twig\Template->yield (line 50)
12	__TwigTemplate_6aaa4f119c7143b43078a89afa211f4e->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 111)
20	App\Controller\IndexController->shopList (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)

0.48 ms
(4.27%)

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_6aaa4f119c7143b43078a89afa211f4e->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 111)
17	App\Controller\IndexController->shopList (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.45 ms
(4.03%)

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_6aaa4f119c7143b43078a89afa211f4e->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 111)
18	App\Controller\IndexController->shopList (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.44 ms
(3.90%)

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_.catalog_id_id IN (?) AND s0_.id IN (?)

Parameters:

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_.catalog_id_id IN (?)
  AND s0_.id IN (?)

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_.catalog_id_id IN (5) AND s0_.id IN (26);

#	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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 208)
8	__TwigTemplate_6aaa4f119c7143b43078a89afa211f4e->block_body (line 430)
9	Twig\Template->yieldBlock (line 163)
10	__TwigTemplate_bc74e25818f8950726da1b3b704fed13->doDisplay (line 360)
11	Twig\Template->yield (line 50)
12	__TwigTemplate_6aaa4f119c7143b43078a89afa211f4e->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 111)
20	App\Controller\IndexController->shopList (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)

0.36 ms
(3.21%)

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:

[
  26
]

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

#	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 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->containsKey (line 420)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1560)
10	Twig\Extension\CoreExtension::getAttribute (line 226)
11	__TwigTemplate_6aaa4f119c7143b43078a89afa211f4e->block_body (line 430)
12	Twig\Template->yieldBlock (line 163)
13	__TwigTemplate_bc74e25818f8950726da1b3b704fed13->doDisplay (line 360)
14	Twig\Template->yield (line 50)
15	__TwigTemplate_6aaa4f119c7143b43078a89afa211f4e->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 111)
23	App\Controller\IndexController->shopList (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.36 ms
(3.20%)

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:

[
  26
]

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

#	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 245)
5	__TwigTemplate_6aaa4f119c7143b43078a89afa211f4e->block_body (line 430)
6	Twig\Template->yieldBlock (line 163)
7	__TwigTemplate_bc74e25818f8950726da1b3b704fed13->doDisplay (line 360)
8	Twig\Template->yield (line 50)
9	__TwigTemplate_6aaa4f119c7143b43078a89afa211f4e->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 111)
17	App\Controller\IndexController->shopList (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\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\FreeProducts	No errors.
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\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.

Symfony Profiler

GET https://sampleretailhub.com/shop/list?category=5

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