Symfony Profiler

Query Metrics

35 Database Queries

25 Different statements

14.77 ms Query time

0 Invalid entities

28 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.38 ms
(16.14%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p1_.category_super_id = ? AND p0_.category_type_id = ? AND p0_.is_active = 1 ORDER BY p1_.sequence ASC, p0_.sequence ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.html AS html_4,
  p0_.title AS title_5,
  p0_.is_active AS is_active_6,
  p0_.slug AS slug_7,
  p0_.javascript AS javascript_8,
  p0_.sequence AS sequence_9,
  p0_.is_menu AS is_menu_10,
  p0_.latitude AS latitude_11,
  p0_.longitude AS longitude_12,
  p0_.state AS state_13,
  p0_.has_comments AS has_comments_14,
  p0_.is_indexable AS is_indexable_15,
  p0_.created_at AS created_at_16,
  p0_.published_at AS published_at_17,
  p0_.additional_data AS additional_data_18,
  p0_.special_category_code AS special_category_code_19,
  p0_.category_type_id AS category_type_id_20,
  p0_.upload_id AS upload_id_21
FROM
  p_category p0_
  LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id
WHERE
  p1_.category_super_id = ?
  AND p0_.category_type_id = ?
  AND p0_.is_active = 1
ORDER BY
  p1_.sequence ASC,
  p0_.sequence ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p1_.category_super_id = 452 AND p0_.category_type_id = 18 AND p0_.is_active = 1 ORDER BY p1_.sequence ASC, p0_.sequence ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CategoryRepository->findSubCategoriesWithType (line 142)
7	App\Service\EshopMenuService->getTypedSubCategories (line 38)
8	App\Service\EshopMenuService->getEshopSideMenuCategories (line 28)
9	__TwigTemplate_c8390cfeaa7c0507b4c95c5633c33689->doDisplay (line 48)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_header (line 80)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
18	Twig\Template->yield (line 411)
19	Twig\Template->display (line 366)
20	Twig\Template->render (line 381)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

1.57 ms
(10.62%)

SELECT e0_.foreign_key AS foreign_key_0 FROM ext_translations e0_ WHERE e0_.locale = ? AND e0_.object_class = ? AND e0_.field = ? AND e0_.content = ? LIMIT 1

Parameters:

[
  "cs"
  "Greendot\EshopBundle\Entity\Project\Product"
  "slug"
  "textilni-paska-pro-vnitrni-zaluzie-climax"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.foreign_key AS foreign_key_0
FROM
  ext_translations e0_
WHERE
  e0_.locale = ?
  AND e0_.object_class = ?
  AND e0_.field = ?
  AND e0_.content = ?
LIMIT
  1

SELECT e0_.foreign_key AS foreign_key_0 FROM ext_translations e0_ WHERE e0_.locale = 'cs' AND e0_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND e0_.field = 'slug' AND e0_.content = 'textilni-paska-pro-vnitrni-zaluzie-climax' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Greendot\EshopBundle\Repository\HintedRepositoryBase->findIdInTranslations (line 83)
7	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 44)
8	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

1.20 ms
(8.11%)

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.is_main_category AS is_main_category_4, t0.category_super_id AS category_super_id_5, t0.category_sub_id AS category_sub_id_6 FROM p_category_category t0 WHERE t0.category_sub_id = ? ORDER BY t0.sequence ASC

Parameters:

[
  459
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.is_main_category AS is_main_category_4,
  t0.category_super_id AS category_super_id_5,
  t0.category_sub_id AS category_sub_id_6
FROM
  p_category_category t0
WHERE
  t0.category_sub_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.is_main_category AS is_main_category_4, t0.category_super_id AS category_super_id_5, t0.category_sub_id AS category_sub_id_6 FROM p_category_category t0 WHERE t0.category_sub_id = 459 ORDER BY t0.sequence ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Greendot\EshopBundle\Service\CategoryInfoGetter->getCategoryBreadCrumbsArray (line 28)
9	Greendot\EshopBundle\Service\BreadcrumbsMaker->makeProductBreadCrumbsArray (line 53)
10	Greendot\EshopBundle\Service\BreadcrumbsMaker->makeEntityBreadCrumbsArray (line 31)
11	App\Twig\BreadcrumbsExtension->getBreadcrumbs (line 25)
12	__TwigTemplate_300e6b6062098d53ef741f0fb49b548a->doDisplay (line 48)
13	Twig\Template->yield (line 411)
14	Twig\Template->display (line 366)
15	Twig\Template->render (line 381)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Extension\CoreExtension->include (line 1522)
18	__TwigTemplate_573df7b29e764451d7c2f37440bbd420::block_content (line 145)
19	Twig\Template->yieldBlock (line 456)
20	Twig\Template->displayBlock (line 146)
21	Twig\Template->renderBlock (line 207)
22	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
23	Twig\Template->yieldBlock (line 456)
24	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
25	Twig\Template->yield (line 411)
26	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
27	Twig\Template->yield (line 411)
28	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
29	Twig\Template->yield (line 411)
30	Twig\Template->display (line 366)
31	Twig\Template->render (line 381)
32	Twig\TemplateWrapper->render (line 51)
33	Twig\Environment->render (line 333)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
37	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Component\HttpKernel\Kernel->handle (line 193)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
42	require_once (line 29)
43	require_once (line 5)

1.16 ms
(7.87%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1

Parameters:

[
  114
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.class AS class_3,
  a0_.is_purchasable AS is_purchasable_4,
  a0_.sequence AS sequence_5
FROM
  availability a0_
  LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id
  AND (p1_.is_active = true)
WHERE
  p1_.product_id = ?
ORDER BY
  a0_.sequence ASC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = 114 ORDER BY a0_.sequence ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Greendot\EshopBundle\Repository\Project\AvailabilityRepository->getAvailabilityForProduct (line 55)
7	Greendot\EshopBundle\EventSubscriber\ProductEventListener->postLoad (line 34)
8	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
9	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
10	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3214)
11	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
12	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
14	Doctrine\ORM\EntityRepository->findOneBy (line 125)
15	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
16	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 52)
17	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
18	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
19	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
20	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.83 ms
(5.59%)

SELECT p0_.id AS id_0, p0_.sequence AS sequence_1, p0_.is_menu_item AS is_menu_item_2, p0_.is_main_category AS is_main_category_3, p0_.category_super_id AS category_super_id_4, p0_.category_sub_id AS category_sub_id_5 FROM p_category_category p0_ WHERE p0_.is_main_category = 1 AND p0_.category_sub_id = ?

Parameters:

[
  459
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.sequence AS sequence_1,
  p0_.is_menu_item AS is_menu_item_2,
  p0_.is_main_category AS is_main_category_3,
  p0_.category_super_id AS category_super_id_4,
  p0_.category_sub_id AS category_sub_id_5
FROM
  p_category_category p0_
WHERE
  p0_.is_main_category = 1
  AND p0_.category_sub_id = ?

SELECT p0_.id AS id_0, p0_.sequence AS sequence_1, p0_.is_menu_item AS is_menu_item_2, p0_.is_main_category AS is_main_category_3, p0_.category_super_id AS category_super_id_4, p0_.category_sub_id AS category_sub_id_5 FROM p_category_category p0_ WHERE p0_.is_main_category = 1 AND p0_.category_sub_id = 459;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Greendot\EshopBundle\Repository\Project\CategoryCategoryRepository->getMainCategoryForSubCategory (line 38)
7	Greendot\EshopBundle\Service\CategoryInfoGetter->getCategoryBreadCrumbsArray (line 29)
8	Greendot\EshopBundle\Service\BreadcrumbsMaker->makeProductBreadCrumbsArray (line 53)
9	Greendot\EshopBundle\Service\BreadcrumbsMaker->makeEntityBreadCrumbsArray (line 31)
10	App\Twig\BreadcrumbsExtension->getBreadcrumbs (line 25)
11	__TwigTemplate_300e6b6062098d53ef741f0fb49b548a->doDisplay (line 48)
12	Twig\Template->yield (line 411)
13	Twig\Template->display (line 366)
14	Twig\Template->render (line 381)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Extension\CoreExtension->include (line 1522)
17	__TwigTemplate_573df7b29e764451d7c2f37440bbd420::block_content (line 145)
18	Twig\Template->yieldBlock (line 456)
19	Twig\Template->displayBlock (line 146)
20	Twig\Template->renderBlock (line 207)
21	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
22	Twig\Template->yieldBlock (line 456)
23	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
24	Twig\Template->yield (line 411)
25	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
26	Twig\Template->yield (line 411)
27	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
28	Twig\Template->yield (line 411)
29	Twig\Template->display (line 366)
30	Twig\Template->render (line 381)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
36	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 193)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
41	require_once (line 29)
42	require_once (line 5)

0.82 ms
(5.55%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id WHERE p0_.is_active = ? AND p0_.id >= ? AND p1_.id IS NULL AND c2_.menu_type_id = ? AND p0_.category_type_id IN (?) ORDER BY c2_.sequence ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.html AS html_4,
  p0_.title AS title_5,
  p0_.is_active AS is_active_6,
  p0_.slug AS slug_7,
  p0_.javascript AS javascript_8,
  p0_.sequence AS sequence_9,
  p0_.is_menu AS is_menu_10,
  p0_.latitude AS latitude_11,
  p0_.longitude AS longitude_12,
  p0_.state AS state_13,
  p0_.has_comments AS has_comments_14,
  p0_.is_indexable AS is_indexable_15,
  p0_.created_at AS created_at_16,
  p0_.published_at AS published_at_17,
  p0_.additional_data AS additional_data_18,
  p0_.special_category_code AS special_category_code_19,
  p0_.category_type_id AS category_type_id_20,
  p0_.upload_id AS upload_id_21
FROM
  p_category p0_
  LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id
  LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p1_.id IS NULL
  AND c2_.menu_type_id = ?
  AND p0_.category_type_id IN (?)
ORDER BY
  c2_.sequence ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p1_.id IS NULL AND c2_.menu_type_id = 2 AND p0_.category_type_id IN (17) ORDER BY c2_.sequence ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Greendot\EshopBundle\Repository\Project\CategoryRepository->findMenuCategories (line 154)
7	App\Service\EshopMenuService->getEshopSideMenuCategories (line 21)
8	__TwigTemplate_c8390cfeaa7c0507b4c95c5633c33689->doDisplay (line 48)
9	Twig\Template->yield (line 411)
10	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_header (line 80)
11	Twig\Template->yieldBlock (line 456)
12	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
17	Twig\Template->yield (line 411)
18	Twig\Template->display (line 366)
19	Twig\Template->render (line 381)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
25	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

0.70 ms
(4.74%)

SELECT p0_.id AS id_0, p0_.sequence AS sequence_1, p0_.discount AS discount_2, p1_.id AS id_3, p1_.name AS name_4, p1_.menu_name AS menu_name_5, p1_.description AS description_6, p1_.title AS title_7, p1_.slug AS slug_8, p1_.is_active AS is_active_9, p1_.is_visible AS is_visible_10, p1_.sequence AS sequence_11, p1_.javascript AS javascript_12, p1_.text_general AS text_general_13, p1_.state AS state_14, p1_.external_id AS external_id_15, p1_.is_indexable AS is_indexable_16, p1_.meta_description AS meta_description_17, p1_.has_variant_picture AS has_variant_picture_18, p1_.sold_amount AS sold_amount_19, p1_.additional_data AS additional_data_20, p1_.is_deleted AS is_deleted_21, p2_.id AS id_22, p2_.name AS name_23, p2_.menu_name AS menu_name_24, p2_.description AS description_25, p2_.title AS title_26, p2_.slug AS slug_27, p2_.is_active AS is_active_28, p2_.is_visible AS is_visible_29, p2_.sequence AS sequence_30, p2_.javascript AS javascript_31, p2_.text_general AS text_general_32, p2_.state AS state_33, p2_.external_id AS external_id_34, p2_.is_indexable AS is_indexable_35, p2_.meta_description AS meta_description_36, p2_.has_variant_picture AS has_variant_picture_37, p2_.sold_amount AS sold_amount_38, p2_.additional_data AS additional_data_39, p2_.is_deleted AS is_deleted_40, p0_.parent_product_id AS parent_product_id_41, p0_.children_product_id AS children_product_id_42, p0_.product_product_type_id AS product_product_type_id_43, p1_.producer_id AS producer_id_44, p1_.upload_id AS upload_id_45, p1_.product_type_id AS product_type_id_46, p1_.product_view_type_id AS product_view_type_id_47, p2_.producer_id AS producer_id_48, p2_.upload_id AS upload_id_49, p2_.product_type_id AS product_type_id_50, p2_.product_view_type_id AS product_view_type_id_51 FROM product_product p0_ INNER JOIN product_product_type p3_ ON p0_.product_product_type_id = p3_.id INNER JOIN product p1_ ON p0_.parent_product_id = p1_.id AND (p1_.is_active = true) INNER JOIN product p2_ ON p0_.children_product_id = p2_.id AND (p2_.is_active = true) WHERE p3_.name = ? AND (p1_.id = ? OR p2_.id = ?) AND p1_.is_active = ? AND p2_.is_active = ? ORDER BY p0_.sequence ASC

Parameters:

[
  "RELATED"
  114
  114
  1
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.sequence AS sequence_1,
  p0_.discount AS discount_2,
  p1_.id AS id_3,
  p1_.name AS name_4,
  p1_.menu_name AS menu_name_5,
  p1_.description AS description_6,
  p1_.title AS title_7,
  p1_.slug AS slug_8,
  p1_.is_active AS is_active_9,
  p1_.is_visible AS is_visible_10,
  p1_.sequence AS sequence_11,
  p1_.javascript AS javascript_12,
  p1_.text_general AS text_general_13,
  p1_.state AS state_14,
  p1_.external_id AS external_id_15,
  p1_.is_indexable AS is_indexable_16,
  p1_.meta_description AS meta_description_17,
  p1_.has_variant_picture AS has_variant_picture_18,
  p1_.sold_amount AS sold_amount_19,
  p1_.additional_data AS additional_data_20,
  p1_.is_deleted AS is_deleted_21,
  p2_.id AS id_22,
  p2_.name AS name_23,
  p2_.menu_name AS menu_name_24,
  p2_.description AS description_25,
  p2_.title AS title_26,
  p2_.slug AS slug_27,
  p2_.is_active AS is_active_28,
  p2_.is_visible AS is_visible_29,
  p2_.sequence AS sequence_30,
  p2_.javascript AS javascript_31,
  p2_.text_general AS text_general_32,
  p2_.state AS state_33,
  p2_.external_id AS external_id_34,
  p2_.is_indexable AS is_indexable_35,
  p2_.meta_description AS meta_description_36,
  p2_.has_variant_picture AS has_variant_picture_37,
  p2_.sold_amount AS sold_amount_38,
  p2_.additional_data AS additional_data_39,
  p2_.is_deleted AS is_deleted_40,
  p0_.parent_product_id AS parent_product_id_41,
  p0_.children_product_id AS children_product_id_42,
  p0_.product_product_type_id AS product_product_type_id_43,
  p1_.producer_id AS producer_id_44,
  p1_.upload_id AS upload_id_45,
  p1_.product_type_id AS product_type_id_46,
  p1_.product_view_type_id AS product_view_type_id_47,
  p2_.producer_id AS producer_id_48,
  p2_.upload_id AS upload_id_49,
  p2_.product_type_id AS product_type_id_50,
  p2_.product_view_type_id AS product_view_type_id_51
FROM
  product_product p0_
  INNER JOIN product_product_type p3_ ON p0_.product_product_type_id = p3_.id
  INNER JOIN product p1_ ON p0_.parent_product_id = p1_.id
  AND (p1_.is_active = true)
  INNER JOIN product p2_ ON p0_.children_product_id = p2_.id
  AND (p2_.is_active = true)
WHERE
  p3_.name = ?
  AND (
    p1_.id = ?
    OR p2_.id = ?
  )
  AND p1_.is_active = ?
  AND p2_.is_active = ?
ORDER BY
  p0_.sequence ASC

SELECT p0_.id AS id_0, p0_.sequence AS sequence_1, p0_.discount AS discount_2, p1_.id AS id_3, p1_.name AS name_4, p1_.menu_name AS menu_name_5, p1_.description AS description_6, p1_.title AS title_7, p1_.slug AS slug_8, p1_.is_active AS is_active_9, p1_.is_visible AS is_visible_10, p1_.sequence AS sequence_11, p1_.javascript AS javascript_12, p1_.text_general AS text_general_13, p1_.state AS state_14, p1_.external_id AS external_id_15, p1_.is_indexable AS is_indexable_16, p1_.meta_description AS meta_description_17, p1_.has_variant_picture AS has_variant_picture_18, p1_.sold_amount AS sold_amount_19, p1_.additional_data AS additional_data_20, p1_.is_deleted AS is_deleted_21, p2_.id AS id_22, p2_.name AS name_23, p2_.menu_name AS menu_name_24, p2_.description AS description_25, p2_.title AS title_26, p2_.slug AS slug_27, p2_.is_active AS is_active_28, p2_.is_visible AS is_visible_29, p2_.sequence AS sequence_30, p2_.javascript AS javascript_31, p2_.text_general AS text_general_32, p2_.state AS state_33, p2_.external_id AS external_id_34, p2_.is_indexable AS is_indexable_35, p2_.meta_description AS meta_description_36, p2_.has_variant_picture AS has_variant_picture_37, p2_.sold_amount AS sold_amount_38, p2_.additional_data AS additional_data_39, p2_.is_deleted AS is_deleted_40, p0_.parent_product_id AS parent_product_id_41, p0_.children_product_id AS children_product_id_42, p0_.product_product_type_id AS product_product_type_id_43, p1_.producer_id AS producer_id_44, p1_.upload_id AS upload_id_45, p1_.product_type_id AS product_type_id_46, p1_.product_view_type_id AS product_view_type_id_47, p2_.producer_id AS producer_id_48, p2_.upload_id AS upload_id_49, p2_.product_type_id AS product_type_id_50, p2_.product_view_type_id AS product_view_type_id_51 FROM product_product p0_ INNER JOIN product_product_type p3_ ON p0_.product_product_type_id = p3_.id INNER JOIN product p1_ ON p0_.parent_product_id = p1_.id AND (p1_.is_active = true) INNER JOIN product p2_ ON p0_.children_product_id = p2_.id AND (p2_.is_active = true) WHERE p3_.name = 'RELATED' AND (p1_.id = 114 OR p2_.id = 114) AND p1_.is_active = 1 AND p2_.is_active = 1 ORDER BY p0_.sequence ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Twig\AppExtension->findProductRelatedProducts (line 156)
7	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->block_content (line 532)
8	Twig\Template->yieldBlock (line 456)
9	Twig\Template->displayBlock (line 146)
10	Twig\Template->renderBlock (line 207)
11	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
18	Twig\Template->yield (line 411)
19	Twig\Template->display (line 366)
20	Twig\Template->render (line 381)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.68 ms
(4.60%)

SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?

Parameters:

[
  114
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.data AS data_0,
  p1_.name AS name_1
FROM
  parameter p0_
  LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id
  AND (p2_.is_active = true)
  LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id
WHERE
  p2_.product_id = ?

SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = 114;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	Greendot\EshopBundle\Repository\Project\ProductRepository->calculateParameters (line 95)
7	Greendot\EshopBundle\EventSubscriber\ProductEventListener->postLoad (line 35)
8	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
9	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
10	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3214)
11	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
12	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
14	Doctrine\ORM\EntityRepository->findOneBy (line 125)
15	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
16	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 52)
17	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
18	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
19	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
20	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.45 ms
(3.06%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.slug = ? AND ((t0.is_active = true)) LIMIT 1

Parameters:

[
  "textilni-paska-pro-vnitrni-zaluzie-climax"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.menu_name AS menu_name_3,
  t0.description AS description_4,
  t0.title AS title_5,
  t0.slug AS slug_6,
  t0.is_active AS is_active_7,
  t0.is_visible AS is_visible_8,
  t0.sequence AS sequence_9,
  t0.javascript AS javascript_10,
  t0.text_general AS text_general_11,
  t0.state AS state_12,
  t0.external_id AS external_id_13,
  t0.is_indexable AS is_indexable_14,
  t0.meta_description AS meta_description_15,
  t0.has_variant_picture AS has_variant_picture_16,
  t0.sold_amount AS sold_amount_17,
  t0.additional_data AS additional_data_18,
  t0.is_deleted AS is_deleted_19,
  t0.producer_id AS producer_id_20,
  t0.upload_id AS upload_id_21,
  t0.product_type_id AS product_type_id_22,
  t0.product_view_type_id AS product_view_type_id_23
FROM
  product t0
WHERE
  t0.slug = ?
  AND (
    (t0.is_active = true)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.slug = 'textilni-paska-pro-vnitrni-zaluzie-climax' AND ((t0.is_active = true)) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 52)
5	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.41 ms
(2.76%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.rounding AS rounding_4, t0.is_default AS is_default_5, t0.default_locale AS default_locale_6, t0.is_symbol_left AS is_symbol_left_7, t0.is_deleted AS is_deleted_8 FROM currency t0 WHERE t0.id = ?

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.symbol AS symbol_3,
  t0.rounding AS rounding_4,
  t0.is_default AS is_default_5,
  t0.default_locale AS default_locale_6,
  t0.is_symbol_left AS is_symbol_left_7,
  t0.is_deleted AS is_deleted_8
FROM
  currency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.rounding AS rounding_4, t0.is_default AS is_default_5, t0.default_locale AS default_locale_6, t0.is_symbol_left AS is_symbol_left_7, t0.is_deleted AS is_deleted_8 FROM currency t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Greendot\EshopBundle\Service\CurrencyManager->get (line 41)
7	Greendot\EshopBundle\EventSubscriber\ProductEventListener->postLoad (line 33)
8	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
9	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
10	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3214)
11	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
12	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
14	Doctrine\ORM\EntityRepository->findOneBy (line 125)
15	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
16	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 52)
17	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
18	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
19	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
20	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.40 ms
(2.70%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.title AS title_4, p0_.slug AS slug_5, p0_.is_active AS is_active_6, p0_.is_visible AS is_visible_7, p0_.sequence AS sequence_8, p0_.javascript AS javascript_9, p0_.text_general AS text_general_10, p0_.state AS state_11, p0_.external_id AS external_id_12, p0_.is_indexable AS is_indexable_13, p0_.meta_description AS meta_description_14, p0_.has_variant_picture AS has_variant_picture_15, p0_.sold_amount AS sold_amount_16, p0_.additional_data AS additional_data_17, p0_.is_deleted AS is_deleted_18, p0_.producer_id AS producer_id_19, p0_.upload_id AS upload_id_20, p0_.product_type_id AS product_type_id_21, p0_.product_view_type_id AS product_view_type_id_22 FROM product p0_ WHERE (p0_.id = ?) AND (p0_.is_active = true)

Parameters:

[
  114
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.title AS title_4,
  p0_.slug AS slug_5,
  p0_.is_active AS is_active_6,
  p0_.is_visible AS is_visible_7,
  p0_.sequence AS sequence_8,
  p0_.javascript AS javascript_9,
  p0_.text_general AS text_general_10,
  p0_.state AS state_11,
  p0_.external_id AS external_id_12,
  p0_.is_indexable AS is_indexable_13,
  p0_.meta_description AS meta_description_14,
  p0_.has_variant_picture AS has_variant_picture_15,
  p0_.sold_amount AS sold_amount_16,
  p0_.additional_data AS additional_data_17,
  p0_.is_deleted AS is_deleted_18,
  p0_.producer_id AS producer_id_19,
  p0_.upload_id AS upload_id_20,
  p0_.product_type_id AS product_type_id_21,
  p0_.product_view_type_id AS product_view_type_id_22
FROM
  product p0_
WHERE
  (p0_.id = ?)
  AND (p0_.is_active = true)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.title AS title_4, p0_.slug AS slug_5, p0_.is_active AS is_active_6, p0_.is_visible AS is_visible_7, p0_.sequence AS sequence_8, p0_.javascript AS javascript_9, p0_.text_general AS text_general_10, p0_.state AS state_11, p0_.external_id AS external_id_12, p0_.is_indexable AS is_indexable_13, p0_.meta_description AS meta_description_14, p0_.has_variant_picture AS has_variant_picture_15, p0_.sold_amount AS sold_amount_16, p0_.additional_data AS additional_data_17, p0_.is_deleted AS is_deleted_18, p0_.producer_id AS producer_id_19, p0_.upload_id AS upload_id_20, p0_.product_type_id AS product_type_id_21, p0_.product_view_type_id AS product_view_type_id_22 FROM product p0_ WHERE (p0_.id = 114) AND (p0_.is_active = true);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Greendot\EshopBundle\Repository\HintedRepositoryBase->findHinted (line 29)
7	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 54)
8	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.38 ms
(2.57%)

SELECT s0_.value AS value_0 FROM settings s0_ WHERE s0_.name = ? ORDER BY s0_.name ASC LIMIT 1

Parameters:

[
  "after_registration_discount"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.value AS value_0
FROM
  settings s0_
WHERE
  s0_.name = ?
ORDER BY
  s0_.name ASC
LIMIT
  1

SELECT s0_.value AS value_0 FROM settings s0_ WHERE s0_.name = 'after_registration_discount' ORDER BY s0_.name ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Greendot\EshopBundle\Repository\Project\SettingsRepository->findParameterValueWithName (line 55)
8	Greendot\EshopBundle\Service\Price\ProductVariantPriceFactory->__construct (line 41)
9	ContainerXoUkwCr\App_KernelDevDebugContainer->getProductVariantPriceFactoryService (line 2339)
10	ContainerXoUkwCr\App_KernelDevDebugContainer::getCalculatedPricesServiceService (line 2296)
11	ContainerXoUkwCr\getProductControllerService::do (line 24)
12	ContainerXoUkwCr\App_KernelDevDebugContainer::load (line 855)
13	Symfony\Component\DependencyInjection\Container->make (line 221)
14	Symfony\Component\DependencyInjection\Container::get (line 203)
15	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
16	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
17	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
18	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
19	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.34 ms
(2.34%)

SELECT c0_.id AS id_0, c0_.sequence AS sequence_1, c0_.is_main_category AS is_main_category_2, c0_.product_id AS product_id_3, c0_.category_id AS category_id_4 FROM category_product c0_ WHERE c0_.is_main_category = 1 AND c0_.product_id = ?

Parameters:

[
  114
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.sequence AS sequence_1,
  c0_.is_main_category AS is_main_category_2,
  c0_.product_id AS product_id_3,
  c0_.category_id AS category_id_4
FROM
  category_product c0_
WHERE
  c0_.is_main_category = 1
  AND c0_.product_id = ?

SELECT c0_.id AS id_0, c0_.sequence AS sequence_1, c0_.is_main_category AS is_main_category_2, c0_.product_id AS product_id_3, c0_.category_id AS category_id_4 FROM category_product c0_ WHERE c0_.is_main_category = 1 AND c0_.product_id = 114;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Greendot\EshopBundle\Repository\Project\CategoryProductRepository->getMainCategoryForProduct (line 101)
7	Greendot\EshopBundle\Service\BreadcrumbsMaker->makeProductBreadCrumbsArray (line 51)
8	Greendot\EshopBundle\Service\BreadcrumbsMaker->makeEntityBreadCrumbsArray (line 31)
9	App\Twig\BreadcrumbsExtension->getBreadcrumbs (line 25)
10	__TwigTemplate_300e6b6062098d53ef741f0fb49b548a->doDisplay (line 48)
11	Twig\Template->yield (line 411)
12	Twig\Template->display (line 366)
13	Twig\Template->render (line 381)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Extension\CoreExtension->include (line 1522)
16	__TwigTemplate_573df7b29e764451d7c2f37440bbd420::block_content (line 145)
17	Twig\Template->yieldBlock (line 456)
18	Twig\Template->displayBlock (line 146)
19	Twig\Template->renderBlock (line 207)
20	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
21	Twig\Template->yieldBlock (line 456)
22	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
23	Twig\Template->yield (line 411)
24	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
25	Twig\Template->yield (line 411)
26	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
27	Twig\Template->yield (line 411)
28	Twig\Template->display (line 366)
29	Twig\Template->render (line 381)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
35	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 193)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 29)
41	require_once (line 5)

0.33 ms
(2.25%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.additional_data AS additional_data_19, t0.special_category_code AS special_category_code_20, t0.category_type_id AS category_type_id_21, t0.upload_id AS upload_id_22 FROM p_category t0 WHERE t0.id = ?

Parameters:

[
  459
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.menu_name AS menu_name_3,
  t0.description AS description_4,
  t0.html AS html_5,
  t0.title AS title_6,
  t0.is_active AS is_active_7,
  t0.slug AS slug_8,
  t0.javascript AS javascript_9,
  t0.sequence AS sequence_10,
  t0.is_menu AS is_menu_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.state AS state_14,
  t0.has_comments AS has_comments_15,
  t0.is_indexable AS is_indexable_16,
  t0.created_at AS created_at_17,
  t0.published_at AS published_at_18,
  t0.additional_data AS additional_data_19,
  t0.special_category_code AS special_category_code_20,
  t0.category_type_id AS category_type_id_21,
  t0.upload_id AS upload_id_22
FROM
  p_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.additional_data AS additional_data_19, t0.special_category_code AS special_category_code_20, t0.category_type_id AS category_type_id_21, t0.upload_id AS upload_id_22 FROM p_category t0 WHERE t0.id = 459;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\Greendot\EshopBundle\Entity\Project\Category::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Greendot\EshopBundle\Entity\Project\Category->__get (line 153)
7	Greendot\EshopBundle\Entity\Project\Category->getCategorySubCategories (line 389)
8	Greendot\EshopBundle\Service\CategoryInfoGetter->getCategoryBreadCrumbsArray (line 28)
9	Greendot\EshopBundle\Service\BreadcrumbsMaker->makeProductBreadCrumbsArray (line 53)
10	Greendot\EshopBundle\Service\BreadcrumbsMaker->makeEntityBreadCrumbsArray (line 31)
11	App\Twig\BreadcrumbsExtension->getBreadcrumbs (line 25)
12	__TwigTemplate_300e6b6062098d53ef741f0fb49b548a->doDisplay (line 48)
13	Twig\Template->yield (line 411)
14	Twig\Template->display (line 366)
15	Twig\Template->render (line 381)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Extension\CoreExtension->include (line 1522)
18	__TwigTemplate_573df7b29e764451d7c2f37440bbd420::block_content (line 145)
19	Twig\Template->yieldBlock (line 456)
20	Twig\Template->displayBlock (line 146)
21	Twig\Template->renderBlock (line 207)
22	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
23	Twig\Template->yieldBlock (line 456)
24	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
25	Twig\Template->yield (line 411)
26	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
27	Twig\Template->yield (line 411)
28	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
29	Twig\Template->yield (line 411)
30	Twig\Template->display (line 366)
31	Twig\Template->render (line 381)
32	Twig\TemplateWrapper->render (line 51)
33	Twig\Environment->render (line 333)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
37	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Component\HttpKernel\Kernel->handle (line 193)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
42	require_once (line 29)
43	require_once (line 5)

0.32 ms
(2.15%)

SELECT u0_.id AS id_0, u0_.type AS type_1 FROM upload_group u0_ LEFT JOIN product_upload_group p1_ ON u0_.id = p1_.upload_group_id WHERE p1_.product_id = ? AND u0_.type = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.type AS type_1
FROM
  upload_group u0_
  LEFT JOIN product_upload_group p1_ ON u0_.id = p1_.upload_group_id
WHERE
  p1_.product_id = ?
  AND u0_.type = ?

SELECT u0_.id AS id_0, u0_.type AS type_1 FROM upload_group u0_ LEFT JOIN product_upload_group p1_ ON u0_.id = p1_.upload_group_id WHERE p1_.product_id = 114 AND u0_.type = 0;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Greendot\EshopBundle\Repository\Project\UploadGroupRepository->getAllUploadGroupsForProduct (line 55)
7	Greendot\EshopBundle\Repository\Project\UploadRepository->getProductUploads (line 130)
8	Greendot\EshopBundle\Twig\AppExtension->getProductUploads (line 594)
9	__TwigTemplate_bbfed2c0828d4b59d426aa58430d96fe->doDisplay (line 85)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1522)
15	__TwigTemplate_573df7b29e764451d7c2f37440bbd420::block_content (line 153)
16	Twig\Template->yieldBlock (line 456)
17	Twig\Template->displayBlock (line 146)
18	Twig\Template->renderBlock (line 207)
19	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
20	Twig\Template->yieldBlock (line 456)
21	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
22	Twig\Template->yield (line 411)
23	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
24	Twig\Template->yield (line 411)
25	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
26	Twig\Template->yield (line 411)
27	Twig\Template->display (line 366)
28	Twig\Template->render (line 381)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
34	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 193)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 29)
40	require_once (line 5)

0.30 ms
(2.06%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?

Parameters:

[
  4088
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.extension AS extension_3,
  t0.mime AS mime_4,
  t0.title AS title_5,
  t0.short_description AS short_description_6,
  t0.description AS description_7,
  t0.created AS created_8,
  t0.path AS path_9,
  t0.original_name AS original_name_10,
  t0.width AS width_11,
  t0.height AS height_12,
  t0.sequence AS sequence_13,
  t0.restriction AS restriction_14,
  t0.upload_group_id AS upload_group_id_15,
  t0.upload_type_id AS upload_type_id_16
FROM
  upload t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = 4088;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\Greendot\EshopBundle\Entity\Project\Upload::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Greendot\EshopBundle\Entity\Project\Upload->__get (line 153)
7	Greendot\EshopBundle\Entity\Project\Upload->getPath (line 250)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_573df7b29e764451d7c2f37440bbd420::block_content (line 164)
10	Twig\Template->yieldBlock (line 456)
11	Twig\Template->displayBlock (line 146)
12	Twig\Template->renderBlock (line 207)
13	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
14	Twig\Template->yieldBlock (line 456)
15	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
18	Twig\Template->yield (line 411)
19	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
20	Twig\Template->yield (line 411)
21	Twig\Template->display (line 366)
22	Twig\Template->render (line 381)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
28	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.30 ms
(2.06%)

SELECT u0_.id AS id_0, u0_.type AS type_1 FROM upload_group u0_ LEFT JOIN product_variant_upload_group p1_ ON u0_.id = p1_.upload_group_id WHERE p1_.product_variant_id IN (?) AND u0_.type = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.type AS type_1
FROM
  upload_group u0_
  LEFT JOIN product_variant_upload_group p1_ ON u0_.id = p1_.upload_group_id
WHERE
  p1_.product_variant_id IN (?)
  AND u0_.type = ?

SELECT u0_.id AS id_0, u0_.type AS type_1 FROM upload_group u0_ LEFT JOIN product_variant_upload_group p1_ ON u0_.id = p1_.upload_group_id WHERE p1_.product_variant_id IN (140) AND u0_.type = 0;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Greendot\EshopBundle\Repository\Project\UploadGroupRepository->getAllUploadGroupsForProduct (line 66)
7	Greendot\EshopBundle\Repository\Project\UploadRepository->getProductUploads (line 130)
8	Greendot\EshopBundle\Twig\AppExtension->getProductUploads (line 594)
9	__TwigTemplate_bbfed2c0828d4b59d426aa58430d96fe->doDisplay (line 85)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1522)
15	__TwigTemplate_573df7b29e764451d7c2f37440bbd420::block_content (line 153)
16	Twig\Template->yieldBlock (line 456)
17	Twig\Template->displayBlock (line 146)
18	Twig\Template->renderBlock (line 207)
19	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
20	Twig\Template->yieldBlock (line 456)
21	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
22	Twig\Template->yield (line 411)
23	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
24	Twig\Template->yield (line 411)
25	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
26	Twig\Template->yield (line 411)
27	Twig\Template->display (line 366)
28	Twig\Template->render (line 381)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
34	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 193)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 29)
40	require_once (line 5)

0.30 ms
(2.06%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.expected_restock_date AS expected_restock_date_6, t0.is_active AS is_active_7, t0.is_deleted AS is_deleted_8, t0.product_id AS product_id_9, t0.availability_id AS availability_id_10, t0.upload_id AS upload_id_11 FROM product_variant t0 WHERE t0.product_id = ? AND ((t0.is_active = true))

Parameters:

[
  114
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.stock AS stock_3,
  t0.external_id AS external_id_4,
  t0.avg_restock_days AS avg_restock_days_5,
  t0.expected_restock_date AS expected_restock_date_6,
  t0.is_active AS is_active_7,
  t0.is_deleted AS is_deleted_8,
  t0.product_id AS product_id_9,
  t0.availability_id AS availability_id_10,
  t0.upload_id AS upload_id_11
FROM
  product_variant t0
WHERE
  t0.product_id = ?
  AND (
    (t0.is_active = true)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.expected_restock_date AS expected_restock_date_6, t0.is_active AS is_active_7, t0.is_deleted AS is_deleted_8, t0.product_id AS product_id_9, t0.availability_id AS availability_id_10, t0.upload_id AS upload_id_11 FROM product_variant t0 WHERE t0.product_id = 114 AND ((t0.is_active = true));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	iterator_to_array (line 359)
8	Doctrine\ORM\AbstractQuery::processParameterValue (line 359)
9	Doctrine\ORM\Query->resolveParameterValue (line 422)
10	Doctrine\ORM\Query->processParameterMappings (line 366)
11	Doctrine\ORM\Query->_doExecute (line 287)
12	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
13	Doctrine\ORM\AbstractQuery->execute (line 886)
14	Doctrine\ORM\AbstractQuery->getResult (line 688)
15	Greendot\EshopBundle\Repository\Project\UploadGroupRepository->getAllUploadGroupsForProduct (line 66)
16	Greendot\EshopBundle\Repository\Project\UploadRepository->getProductUploads (line 130)
17	Greendot\EshopBundle\Twig\AppExtension->getProductUploads (line 594)
18	__TwigTemplate_bbfed2c0828d4b59d426aa58430d96fe->doDisplay (line 85)
19	Twig\Template->yield (line 411)
20	Twig\Template->display (line 366)
21	Twig\Template->render (line 381)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Extension\CoreExtension->include (line 1522)
24	__TwigTemplate_573df7b29e764451d7c2f37440bbd420::block_content (line 153)
25	Twig\Template->yieldBlock (line 456)
26	Twig\Template->displayBlock (line 146)
27	Twig\Template->renderBlock (line 207)
28	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
29	Twig\Template->yieldBlock (line 456)
30	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
31	Twig\Template->yield (line 411)
32	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
33	Twig\Template->yield (line 411)
34	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
35	Twig\Template->yield (line 411)
36	Twig\Template->display (line 366)
37	Twig\Template->render (line 381)
38	Twig\TemplateWrapper->render (line 51)
39	Twig\Environment->render (line 333)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
43	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
46	Symfony\Component\HttpKernel\Kernel->handle (line 193)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
48	require_once (line 29)
49	require_once (line 5)

0.30 ms
(2.04%)

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.information_block_id AS information_block_id_3, t0.product_id AS product_id_4 FROM product_information_block t0 WHERE t0.product_id = ?

Parameters:

[
  114
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.information_block_id AS information_block_id_3,
  t0.product_id AS product_id_4
FROM
  product_information_block t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.information_block_id AS information_block_id_3, t0.product_id AS product_id_4 FROM product_information_block t0 WHERE t0.product_id = 114;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_573df7b29e764451d7c2f37440bbd420::block_content (line 289)
10	Twig\Template->yieldBlock (line 456)
11	Twig\Template->displayBlock (line 146)
12	Twig\Template->renderBlock (line 207)
13	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
14	Twig\Template->yieldBlock (line 456)
15	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
18	Twig\Template->yield (line 411)
19	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
20	Twig\Template->yield (line 411)
21	Twig\Template->display (line 366)
22	Twig\Template->render (line 381)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
28	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.30 ms
(2.01%)

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_main_category AS is_main_category_3, t0.product_id AS product_id_4, t0.category_id AS category_id_5 FROM category_product t0 WHERE t0.product_id = ?

Parameters:

[
  114
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_main_category AS is_main_category_3,
  t0.product_id AS product_id_4,
  t0.category_id AS category_id_5
FROM
  category_product t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_main_category AS is_main_category_3, t0.product_id AS product_id_4, t0.category_id AS category_id_5 FROM category_product t0 WHERE t0.product_id = 114;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->first (line 169)
7	Doctrine\ORM\PersistentCollection->first (line 518)
8	Greendot\EshopBundle\Service\BreadcrumbsMaker->makeProductBreadCrumbsArray (line 51)
9	Greendot\EshopBundle\Service\BreadcrumbsMaker->makeEntityBreadCrumbsArray (line 31)
10	App\Twig\BreadcrumbsExtension->getBreadcrumbs (line 25)
11	__TwigTemplate_300e6b6062098d53ef741f0fb49b548a->doDisplay (line 48)
12	Twig\Template->yield (line 411)
13	Twig\Template->display (line 366)
14	Twig\Template->render (line 381)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Extension\CoreExtension->include (line 1522)
17	__TwigTemplate_573df7b29e764451d7c2f37440bbd420::block_content (line 145)
18	Twig\Template->yieldBlock (line 456)
19	Twig\Template->displayBlock (line 146)
20	Twig\Template->renderBlock (line 207)
21	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
22	Twig\Template->yieldBlock (line 456)
23	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
24	Twig\Template->yield (line 411)
25	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
26	Twig\Template->yield (line 411)
27	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
28	Twig\Template->yield (line 411)
29	Twig\Template->display (line 366)
30	Twig\Template->render (line 381)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
36	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 193)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
41	require_once (line 29)
42	require_once (line 5)

0.28 ms
(1.87%)

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.restriction AS restriction_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ WHERE u0_.upload_group_id IN (NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.extension AS extension_2,
  u0_.mime AS mime_3,
  u0_.title AS title_4,
  u0_.short_description AS short_description_5,
  u0_.description AS description_6,
  u0_.created AS created_7,
  u0_.path AS path_8,
  u0_.original_name AS original_name_9,
  u0_.width AS width_10,
  u0_.height AS height_11,
  u0_.sequence AS sequence_12,
  u0_.restriction AS restriction_13,
  u0_.upload_group_id AS upload_group_id_14,
  u0_.upload_type_id AS upload_type_id_15
FROM
  upload u0_
WHERE
  u0_.upload_group_id IN (NULL)

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.restriction AS restriction_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ WHERE u0_.upload_group_id IN (NULL);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Greendot\EshopBundle\Repository\Project\UploadRepository->getProductUploads (line 138)
7	Greendot\EshopBundle\Twig\AppExtension->getProductUploads (line 594)
8	__TwigTemplate_bbfed2c0828d4b59d426aa58430d96fe->doDisplay (line 85)
9	Twig\Template->yield (line 411)
10	Twig\Template->display (line 366)
11	Twig\Template->render (line 381)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Extension\CoreExtension->include (line 1522)
14	__TwigTemplate_573df7b29e764451d7c2f37440bbd420::block_content (line 153)
15	Twig\Template->yieldBlock (line 456)
16	Twig\Template->displayBlock (line 146)
17	Twig\Template->renderBlock (line 207)
18	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
19	Twig\Template->yieldBlock (line 456)
20	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
21	Twig\Template->yield (line 411)
22	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
23	Twig\Template->yield (line 411)
24	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
25	Twig\Template->yield (line 411)
26	Twig\Template->display (line 366)
27	Twig\Template->render (line 381)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
33	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 193)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 29)
39	require_once (line 5)

0.26 ms
(1.77%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3 FROM product_view_type t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.template AS template_3
FROM
  product_view_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3 FROM product_view_type t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\Greendot\EshopBundle\Entity\Project\ProductViewType::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Greendot\EshopBundle\Entity\Project\ProductViewType->__get (line 153)
7	Greendot\EshopBundle\Entity\Project\ProductViewType->getTemplate (line 53)
8	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 84)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.26 ms
(1.73%)

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.discount AS discount_3, t0.parent_product_id AS parent_product_id_4, t0.children_product_id AS children_product_id_5, t0.product_product_type_id AS product_product_type_id_6 FROM product_product t0 WHERE t0.parent_product_id = ?

Parameters:

[
  114
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.discount AS discount_3,
  t0.parent_product_id AS parent_product_id_4,
  t0.children_product_id AS children_product_id_5,
  t0.product_product_type_id AS product_product_type_id_6
FROM
  product_product t0
WHERE
  t0.parent_product_id = ?

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.discount AS discount_3, t0.parent_product_id AS parent_product_id_4, t0.children_product_id AS children_product_id_5, t0.product_product_type_id AS product_product_type_id_6 FROM product_product t0 WHERE t0.parent_product_id = 114;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->block_content (line 332)
8	Twig\Template->yieldBlock (line 456)
9	Twig\Template->displayBlock (line 146)
10	Twig\Template->renderBlock (line 207)
11	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
18	Twig\Template->yield (line 411)
19	Twig\Template->display (line 366)
20	Twig\Template->render (line 381)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.25 ms
(1.70%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.title AS title_4, t0.description AS description_5, t0.html AS html_6, t0.is_menu AS is_menu_7, t0.slug AS slug_8, t0.upload_id AS upload_id_9 FROM producer t0 WHERE t0.id = ?

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.menu_name AS menu_name_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.html AS html_6,
  t0.is_menu AS is_menu_7,
  t0.slug AS slug_8,
  t0.upload_id AS upload_id_9
FROM
  producer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.title AS title_4, t0.description AS description_5, t0.html AS html_6, t0.is_menu AS is_menu_7, t0.slug AS slug_8, t0.upload_id AS upload_id_9 FROM producer t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\Greendot\EshopBundle\Entity\Project\Producer::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Greendot\EshopBundle\Entity\Project\Producer->__get (line 153)
7	Greendot\EshopBundle\Entity\Project\Producer->getUpload (line 212)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_573df7b29e764451d7c2f37440bbd420::block_content (line 164)
10	Twig\Template->yieldBlock (line 456)
11	Twig\Template->displayBlock (line 146)
12	Twig\Template->renderBlock (line 207)
13	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
14	Twig\Template->yieldBlock (line 456)
15	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
18	Twig\Template->yield (line 411)
19	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
20	Twig\Template->yield (line 411)
21	Twig\Template->display (line 366)
22	Twig\Template->render (line 381)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
28	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.24 ms
(1.65%)

SELECT t0.id AS id_1, t0.is_variant AS is_variant_2, t0.product_id AS product_id_3, t0.parameter_group_id AS parameter_group_id_4 FROM product_parameter_group t0 WHERE t0.product_id = ?

Parameters:

[
  114
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.is_variant AS is_variant_2,
  t0.product_id AS product_id_3,
  t0.parameter_group_id AS parameter_group_id_4
FROM
  product_parameter_group t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.is_variant AS is_variant_2, t0.product_id AS product_id_3, t0.parameter_group_id AS parameter_group_id_4 FROM product_parameter_group t0 WHERE t0.product_id = 114;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->block_content (line 436)
8	Twig\Template->yieldBlock (line 456)
9	Twig\Template->displayBlock (line 146)
10	Twig\Template->renderBlock (line 207)
11	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->block_body (line 165)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_14654c90fd88861836fb3d46d058efb3->doDisplay (line 56)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_573df7b29e764451d7c2f37440bbd420->doDisplay (line 55)
18	Twig\Template->yield (line 411)
19	Twig\Template->display (line 366)
20	Twig\Template->render (line 381)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 88)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
Greendot\EshopBundle\Entity\Project\Category	13
Greendot\EshopBundle\Entity\Project\CategoryType	4
Greendot\EshopBundle\Entity\Project\CategoryCategory	3
Greendot\EshopBundle\Entity\Project\Product	1
Greendot\EshopBundle\Entity\Project\Producer	1
Greendot\EshopBundle\Entity\Project\ProductViewType	1
Greendot\EshopBundle\Entity\Project\Currency	1
Greendot\EshopBundle\Entity\Project\Availability	1
Greendot\EshopBundle\Entity\Project\CategoryProduct	1
Greendot\EshopBundle\Entity\Project\ProductVariant	1
Greendot\EshopBundle\Entity\Project\Upload	1

Entities Mapping

Class	Mapping errors
Greendot\EshopBundle\Entity\Project\Settings	No errors.
Greendot\EshopBundle\Entity\Project\Product	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
Greendot\EshopBundle\Entity\Project\Producer	No errors.
Greendot\EshopBundle\Entity\Project\Upload	No errors.
Greendot\EshopBundle\Entity\Project\ProductType	No errors.
Greendot\EshopBundle\Entity\Project\ProductViewType	No errors.
Greendot\EshopBundle\Entity\Project\ProductVariant	No errors.
Greendot\EshopBundle\Entity\Project\Review	No errors.
Greendot\EshopBundle\Entity\Project\CategoryProduct	No errors.
Greendot\EshopBundle\Entity\Project\ProductUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProductPerson	No errors.
Greendot\EshopBundle\Entity\Project\Label	No errors.
Greendot\EshopBundle\Entity\Project\ProductParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProductProduct	No errors.
Greendot\EshopBundle\Entity\Project\Comment	No errors.
Greendot\EshopBundle\Entity\Project\ProductInformationBlock	No errors.
Greendot\EshopBundle\Entity\Project\Currency	No errors.
Greendot\EshopBundle\Entity\Project\ConversionRate	No errors.
Greendot\EshopBundle\Entity\Project\Availability	No errors.
Greendot\EshopBundle\Entity\Project\Parameter	No errors.
Greendot\EshopBundle\Entity\Project\ParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\Category	No errors.
Greendot\EshopBundle\Entity\Project\CategoryCategory	No errors.
Greendot\EshopBundle\Entity\Project\CategoryMenuType	No errors.
Greendot\EshopBundle\Entity\Project\CategoryType	No errors.
Greendot\EshopBundle\Entity\Project\CategoryFile	No errors.
Greendot\EshopBundle\Entity\Project\CategoryPerson	No errors.
Greendot\EshopBundle\Entity\Project\CategoryEvent	No errors.
Greendot\EshopBundle\Entity\Project\CategoryUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\SubMenuType	No errors.
Greendot\EshopBundle\Entity\Project\CategoryParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\UploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProductVariantUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\PurchaseProductVariant	No errors.
Greendot\EshopBundle\Entity\Project\Video	No errors.
Greendot\EshopBundle\Entity\Project\Price	No errors.
Greendot\EshopBundle\Entity\Project\UploadType	No errors.
Greendot\EshopBundle\Entity\Project\ProducerUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\Person	No errors.
Greendot\EshopBundle\Entity\Project\InformationBlock	No errors.
Greendot\EshopBundle\Entity\Project\ProductProductType	No errors.

Symfony Profiler

GET http://proklima.greendot.cz/textilni-paska-pro-vnitrni-zaluzie-climax-p

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping