Symfony Profiler

Query Metrics

14 Database Queries

8 Different statements

12.85 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

3.13 ms
(24.40%)

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_5c03f6be04942f506837ece20eff0052->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 24)
22	App\Controller\PagesController->getPage (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)

2.78 ms
(21.68%)

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_5c03f6be04942f506837ece20eff0052->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 24)
21	App\Controller\PagesController->getPage (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.67 ms
(20.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 49)
14	__TwigTemplate_5c03f6be04942f506837ece20eff0052->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 24)
22	App\Controller\PagesController->getPage (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.17 ms
(9.10%)

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.url = ? LIMIT 1

Parameters:

[
  "about"
]

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.url = ?
LIMIT
  1

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.url = 'about' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.96 ms
(7.50%)

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_5c03f6be04942f506837ece20eff0052->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 24)
17	App\Controller\PagesController->getPage (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.83 ms
(6.49%)

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_5c03f6be04942f506837ece20eff0052->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 24)
21	App\Controller\PagesController->getPage (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.67 ms
(5.22%)

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_5c03f6be04942f506837ece20eff0052->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 24)
18	App\Controller\PagesController->getPage (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.62 ms
(4.86%)

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_5c03f6be04942f506837ece20eff0052->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 24)
17	App\Controller\PagesController->getPage (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\Pages	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\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\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\Categories	No errors.
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.

Symfony Profiler

GET https://sampleretailhub.com/p/about

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