Symfony Profiler

Query Metrics

178 Database Queries

41 Different statements

64.91 ms Query time

0 Invalid entities

212 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.23 ms
(14.21%)

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:

[
  4151
]

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

#	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 225)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_ae9e3c222c5002640c9fe569edb9f827::doDisplay (line 86)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
18	App\Controller\Web\MenuController->submenuProduct (line 47)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
26	__TwigTemplate_ec5203657a1243d887dc58880d801801->doDisplay (line 102)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
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\Web\MenuController->generateMenu (line 25)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
39	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
40	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
41	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
42	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
43	__TwigTemplate_ab84d24f8e799e2c4dad1187cc977d13->doDisplay (line 68)
44	Twig\Template->yield (line 402)
45	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->block_header (line 403)
46	Twig\Template->yieldBlock (line 446)
47	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 193)
48	Twig\Template->yield (line 402)
49	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
50	Twig\Template->yield (line 402)
51	Twig\Template->display (line 358)
52	Twig\Template->render (line 373)
53	Twig\TemplateWrapper->render (line 51)
54	Twig\Environment->render (line 333)
55	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
56	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
57	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
58	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
59	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
60	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
61	Symfony\Component\HttpKernel\Kernel->handle (line 193)
62	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
63	require_once (line 29)
64	require_once (line 5)

8.37 ms
(12.89%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sequence AS sequence_5, t0.label_type_id AS label_type_id_6 FROM p_label t0 INNER JOIN category_label ON t0.id = category_label.label_id WHERE category_label.category_id = ?

Parameters:

[
  72
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.sequence AS sequence_5,
  t0.label_type_id AS label_type_id_6
FROM
  p_label t0
  INNER JOIN category_label ON t0.id = category_label.label_id
WHERE
  category_label.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sequence AS sequence_5, t0.label_type_id AS label_type_id_6 FROM p_label t0 INNER JOIN category_label ON t0.id = category_label.label_id WHERE category_label.category_id = 72;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
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_ae9e3c222c5002640c9fe569edb9f827->doDisplay (line 143)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
16	App\Controller\Web\MenuController->submenuProduct (line 47)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
20	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
21	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
22	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
23	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
24	__TwigTemplate_ec5203657a1243d887dc58880d801801->doDisplay (line 102)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
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\Web\MenuController->generateMenu (line 25)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
37	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
38	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
39	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
40	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
41	__TwigTemplate_ab84d24f8e799e2c4dad1187cc977d13->doDisplay (line 68)
42	Twig\Template->yield (line 402)
43	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->block_header (line 403)
44	Twig\Template->yieldBlock (line 446)
45	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 193)
46	Twig\Template->yield (line 402)
47	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
48	Twig\Template->yield (line 402)
49	Twig\Template->display (line 358)
50	Twig\Template->render (line 373)
51	Twig\TemplateWrapper->render (line 51)
52	Twig\Environment->render (line 333)
53	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
54	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
55	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
56	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
57	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
58	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
59	Symfony\Component\HttpKernel\Kernel->handle (line 193)
60	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
61	require_once (line 29)
62	require_once (line 5)

4.49 ms
(6.91%)

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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_product c1_ ON p0_.id = c1_.category_id WHERE c1_.product_id = ? AND p0_.is_active = ? AND p0_.category_type_id = ? AND p0_.id > 10 ORDER BY 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_.category_type_id AS category_type_id_18,
  p0_.upload_id AS upload_id_19
FROM
  p_category p0_
  LEFT JOIN category_product c1_ ON p0_.id = c1_.category_id
WHERE
  c1_.product_id = ?
  AND p0_.is_active = ?
  AND p0_.category_type_id = ?
  AND p0_.id > 10
ORDER BY
  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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_product c1_ ON p0_.id = c1_.category_id WHERE c1_.product_id = 10 AND p0_.is_active = 1 AND p0_.category_type_id = 11 AND p0_.id > 10 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\Repository\CategoryRepository->findProductCategoriesWithType (line 78)
7	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 147)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
20	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

4.17 ms
(6.42%)

SELECT e0_.content AS content_0, e0_.field AS field_1, e0_.locale AS locale_2 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.object_class = ? ORDER BY e0_.locale ASC

Parameters:

[
  10
  "Greendot\EshopBundle\Entity\Project\Product"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1,
  e0_.locale AS locale_2
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.object_class = ?
ORDER BY
  e0_.locale ASC

SELECT e0_.content AS content_0, e0_.field AS field_1, e0_.locale AS locale_2 FROM ext_translations e0_ WHERE e0_.foreign_key = 10 AND e0_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' ORDER BY e0_.locale ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->toIterable (line 867)
4	Doctrine\ORM\Query->toIterable (line 606)
5	Gedmo\Translatable\Entity\Repository\TranslationRepository->findTranslations (line 151)
6	Greendot\EshopBundle\Repository\HintedRepositoryBase->findPropertyInLocale (line 66)
7	Greendot\EshopBundle\I18n\RouteTranslator->resolveTranslatableAttributeForClass (line 188)
8	Greendot\EshopBundle\I18n\RouteTranslator->getByRequest (line 82)
9	Greendot\EshopBundle\I18n\RouteTranslator->getByRequestStack (line 40)
10	Greendot\EshopBundle\Twig\AppExtension->localeMenu (line 163)
11	__TwigTemplate_d0c3317f744ffa57cb38131dd1e9c263->doDisplay (line 49)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
20	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
24	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
25	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
26	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
27	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
28	__TwigTemplate_ab84d24f8e799e2c4dad1187cc977d13->doDisplay (line 62)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->block_header (line 403)
31	Twig\Template->yieldBlock (line 446)
32	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 193)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
35	Twig\Template->yield (line 402)
36	Twig\Template->display (line 358)
37	Twig\Template->render (line 373)
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 76)
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)

3.50 ms
(5.39%)

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_sub_id = ? ORDER BY t0.sequence ASC

Parameters:

[
  74
]

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.category_super_id AS category_super_id_4,
  t0.category_sub_id AS category_sub_id_5
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.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_sub_id = 74 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 2729)
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 27)
9	App\Service\CustomProductInfoGetter->getProductBreadCrumbsArray (line 40)
10	Greendot\EshopBundle\Controller\FragmentController->fragmentBreadCrumbs (line 35)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
18	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 189)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
31	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 193)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 29)
37	require_once (line 5)

2.83 ms
(4.36%)

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.title AS title_2, i0_.text AS text_3, i0_.is_active AS is_active_4, i0_.state AS state_5, i0_.is_reusable AS is_reusable_6, i0_.information_block_type_id AS information_block_type_id_7 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id LEFT JOIN product_information_block p2_ ON i0_.id = p2_.information_block_id WHERE i0_.is_active = ? AND i1_.id = ? AND p2_.product_id = ? ORDER BY p2_.sequence ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.title AS title_2,
  i0_.text AS text_3,
  i0_.is_active AS is_active_4,
  i0_.state AS state_5,
  i0_.is_reusable AS is_reusable_6,
  i0_.information_block_type_id AS information_block_type_id_7
FROM
  information_block i0_
  LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id
  LEFT JOIN product_information_block p2_ ON i0_.id = p2_.information_block_id
WHERE
  i0_.is_active = ?
  AND i1_.id = ?
  AND p2_.product_id = ?
ORDER BY
  p2_.sequence ASC

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.title AS title_2, i0_.text AS text_3, i0_.is_active AS is_active_4, i0_.state AS state_5, i0_.is_reusable AS is_reusable_6, i0_.information_block_type_id AS information_block_type_id_7 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id LEFT JOIN product_information_block p2_ ON i0_.id = p2_.information_block_id WHERE i0_.is_active = 1 AND i1_.id = 11 AND p2_.product_id = 10 ORDER BY p2_.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\InformationBlockRepository->getInformationBlocksForEntity (line 76)
7	Greendot\EshopBundle\Service\InformationBlockService->getInformationBlocksForEntity (line 21)
8	Greendot\EshopBundle\Twig\AppExtension->getInformationBlocksForEntity (line 557)
9	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 141)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

2.65 ms
(4.08%)

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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_menu_type c1_ ON p0_.id = c1_.category_id LEFT JOIN p_category_category p2_ ON p0_.id = p2_.category_sub_id WHERE p0_.is_active = ? AND p0_.id >= ? AND p0_.id <> ? AND p2_.category_super_id = ? AND c1_.menu_type_id = ? ORDER BY p2_.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_.category_type_id AS category_type_id_18,
  p0_.upload_id AS upload_id_19
FROM
  p_category p0_
  LEFT JOIN category_menu_type c1_ ON p0_.id = c1_.category_id
  LEFT JOIN p_category_category p2_ ON p0_.id = p2_.category_sub_id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p0_.id <> ?
  AND p2_.category_super_id = ?
  AND c1_.menu_type_id = ?
ORDER BY
  p2_.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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_menu_type c1_ ON p0_.id = c1_.category_id LEFT JOIN p_category_category p2_ ON p0_.id = p2_.category_sub_id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p0_.id <> 68 AND p2_.category_super_id = 68 AND c1_.menu_type_id = 1 ORDER BY p2_.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->findSubMenuCategoriesProject (line 229)
7	App\Controller\Web\MenuController->submenuProduct (line 46)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_ec5203657a1243d887dc58880d801801->doDisplay (line 102)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
32	__TwigTemplate_ab84d24f8e799e2c4dad1187cc977d13->doDisplay (line 68)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->block_header (line 403)
35	Twig\Template->yieldBlock (line 446)
36	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 193)
37	Twig\Template->yield (line 402)
38	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
39	Twig\Template->yield (line 402)
40	Twig\Template->display (line 358)
41	Twig\Template->render (line 373)
42	Twig\TemplateWrapper->render (line 51)
43	Twig\Environment->render (line 333)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
47	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
50	Symfony\Component\HttpKernel\Kernel->handle (line 193)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
52	require_once (line 29)
53	require_once (line 5)

2.07 ms
(3.19%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0.id = category_sub_menu_type.sub_menu_type_id WHERE category_sub_menu_type.category_id = ?

Parameters:

[
  68
]

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,
  t0.controller_name AS controller_name_4
FROM
  sub_menu_type t0
  INNER JOIN category_sub_menu_type ON t0.id = category_sub_menu_type.sub_menu_type_id
WHERE
  category_sub_menu_type.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0.id = category_sub_menu_type.sub_menu_type_id WHERE category_sub_menu_type.category_id = 68;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
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_ec5203657a1243d887dc58880d801801::doDisplay (line 61)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
18	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
26	__TwigTemplate_ab84d24f8e799e2c4dad1187cc977d13->doDisplay (line 68)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->block_header (line 403)
29	Twig\Template->yieldBlock (line 446)
30	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 193)
31	Twig\Template->yield (line 402)
32	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
33	Twig\Template->yield (line 402)
34	Twig\Template->display (line 358)
35	Twig\Template->render (line 373)
36	Twig\TemplateWrapper->render (line 51)
37	Twig\Environment->render (line 333)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
41	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
44	Symfony\Component\HttpKernel\Kernel->handle (line 193)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
46	require_once (line 29)
47	require_once (line 5)

2.01 ms
(3.10%)

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_.producer_id AS producer_id_17, p0_.upload_id AS upload_id_18, p0_.product_type_id AS product_type_id_19, p0_.product_view_type_id AS product_view_type_id_20 FROM product p0_ WHERE p0_.slug = ?

Parameters:

[
  "venkovni-rolety-predokenni"
]

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_.producer_id AS producer_id_17,
  p0_.upload_id AS upload_id_18,
  p0_.product_type_id AS product_type_id_19,
  p0_.product_view_type_id AS product_view_type_id_20
FROM
  product p0_
WHERE
  p0_.slug = ?

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_.producer_id AS producer_id_17, p0_.upload_id AS upload_id_18, p0_.product_type_id AS product_type_id_19, p0_.product_view_type_id AS product_view_type_id_20 FROM product p0_ WHERE p0_.slug = 'venkovni-rolety-predokenni';

#	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->findOneByHinted (line 36)
7	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

1.85 ms
(2.85%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.slug_prefix AS slug_prefix_4, t0.controller_name AS controller_name_5 FROM category_type t0 WHERE t0.id = ?

Parameters:

[
  4
]

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,
  t0.slug_prefix AS slug_prefix_4,
  t0.controller_name AS controller_name_5
FROM
  category_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.slug_prefix AS slug_prefix_4, t0.controller_name AS controller_name_5 FROM category_type t0 WHERE t0.id = 4;

#	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\CategoryType::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Greendot\EshopBundle\Entity\Project\CategoryType->__get (line 153)
7	Greendot\EshopBundle\Entity\Project\CategoryType->getSlugPrefix (line 133)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_d0c3317f744ffa57cb38131dd1e9c263::doDisplay (line 63)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
18	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
26	__TwigTemplate_ab84d24f8e799e2c4dad1187cc977d13->doDisplay (line 62)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->block_header (line 403)
29	Twig\Template->yieldBlock (line 446)
30	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 193)
31	Twig\Template->yield (line 402)
32	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
33	Twig\Template->yield (line 402)
34	Twig\Template->display (line 358)
35	Twig\Template->render (line 373)
36	Twig\TemplateWrapper->render (line 51)
37	Twig\Environment->render (line 333)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
41	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
44	Symfony\Component\HttpKernel\Kernel->handle (line 193)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
46	require_once (line 29)
47	require_once (line 5)

1.70 ms
(2.62%)

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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 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 = ? 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_.category_type_id AS category_type_id_18,
  p0_.upload_id AS upload_id_19
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 = ?
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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 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 = 4 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 153)
7	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 23)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_ab84d24f8e799e2c4dad1187cc977d13->doDisplay (line 62)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->block_header (line 403)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 193)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
22	Twig\Template->yield (line 402)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
30	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 193)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	require_once (line 5)

1.55 ms
(2.38%)

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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ WHERE p0_.category_type_id = ? AND p0_.is_active = 1 ORDER BY p0_.sequence ASC

Parameters:

[
  13
]

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_.category_type_id AS category_type_id_18,
  p0_.upload_id AS upload_id_19
FROM
  p_category p0_
WHERE
  p0_.category_type_id = ?
  AND p0_.is_active = 1
ORDER BY
  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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ WHERE p0_.category_type_id = 13 AND p0_.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\Repository\CategoryRepository->findByCategoryType (line 41)
7	App\Form\HelpWithChoiceInquiryFormType->buildForm (line 56)
8	Symfony\Component\Form\ResolvedFormType->buildForm (line 96)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 56)
11	Symfony\Component\Form\FormFactory->createBuilder (line 41)
12	Symfony\Component\Form\FormFactory->create (line 26)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 355)
14	App\Controller\Global\InquiryController->inquiryForm (line 43)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
18	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
19	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
20	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
21	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
22	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 375)
23	Twig\Template->yieldBlock (line 446)
24	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
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 76)
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)

1.44 ms
(2.22%)

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 = 10 AND u0_.type = 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->getResult (line 688)
6	Greendot\EshopBundle\Repository\Project\UploadGroupRepository->getAllUploadGroupsForProduct (line 55)
7	App\Twig\AppExtension->getProductUploads (line 109)
8	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 1146)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

1.42 ms
(2.19%)

SELECT DISTINCT p0_.minimal_amount AS minimal_amount_0 FROM price p0_ WHERE p0_.product_variant_id = ? AND p0_.valid_from <= ? AND (p0_.valid_until IS NULL OR p0_.valid_until >= ?) ORDER BY p0_.minimal_amount ASC

Parameters:

[
  10
  "2026-03-29 22:12:25"
  "2026-03-29 22:12:25"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.minimal_amount AS minimal_amount_0
FROM
  price p0_
WHERE
  p0_.product_variant_id = ?
  AND p0_.valid_from <= ?
  AND (
    p0_.valid_until IS NULL
    OR p0_.valid_until >= ?
  )
ORDER BY
  p0_.minimal_amount ASC

SELECT DISTINCT p0_.minimal_amount AS minimal_amount_0 FROM price p0_ WHERE p0_.product_variant_id = 10 AND p0_.valid_from <= '2026-03-29 22:12:25' AND (p0_.valid_until IS NULL OR p0_.valid_until >= '2026-03-29 22:12:25') ORDER BY p0_.minimal_amount 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->getSingleColumnResult (line 712)
6	Greendot\EshopBundle\Service\Price\CalculatedPricesService->makeCalculatedPricesForProductVariant (line 42)
7	Greendot\EshopBundle\EventSubscriber\ProductVariantEventListener->postLoad (line 28)
8	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
9	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
10	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
11	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
12	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1026)
14	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1819)
15	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
16	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
17	Doctrine\ORM\PersistentCollection->initialize (line 186)
18	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
19	Greendot\EshopBundle\Repository\Project\ProductRepository->findAvailabilityByProduct (line 78)
20	Greendot\EshopBundle\EventSubscriber\ProductEventListener->postLoad (line 34)
21	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
22	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
23	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
24	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
25	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->doCleanupWithCompat (line 51)
26	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->cleanup (line 46)
27	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
28	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
29	Doctrine\ORM\AbstractQuery->execute (line 886)
30	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
31	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 36)
32	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
33	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
34	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
35	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
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)

1.30 ms
(2.00%)

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 (?) AND u0_.id <> ? AND u0_.upload_type_id = ?

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 (?)
  AND u0_.id <> ?
  AND u0_.upload_type_id = ?

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 (370) AND u0_.id <> 4166 AND u0_.upload_type_id = 2;

#	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->getProductUploads (line 127)
7	__TwigTemplate_75de0ef3112d902452dccd36fcb91de7->doDisplay (line 80)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Extension\CoreExtension->include (line 1526)
13	__TwigTemplate_d926ced1853152153e4148a86a0762f3::doDisplay (line 69)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Extension\CoreExtension->include (line 1526)
19	__TwigTemplate_aadee3769e33878e1008219665ba40c3::block_body (line 1211)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
32	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	require_once (line 5)

1.24 ms
(1.90%)

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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_product c1_ ON p0_.id = c1_.category_id WHERE p0_.is_active = 1 AND c1_.product_id = ? AND p0_.category_type_id IN (?, ?) LIMIT 1

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_.category_type_id AS category_type_id_18,
  p0_.upload_id AS upload_id_19
FROM
  p_category p0_
  LEFT JOIN category_product c1_ ON p0_.id = c1_.category_id
WHERE
  p0_.is_active = 1
  AND c1_.product_id = ?
  AND p0_.category_type_id IN (?, ?)
LIMIT
  1

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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_product c1_ ON p0_.id = c1_.category_id WHERE p0_.is_active = 1 AND c1_.product_id = 10 AND p0_.category_type_id IN (5, 6) 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	App\Repository\CategoryRepository->getProductEshopCategory (line 169)
7	App\Form\HelpWithChoiceInquiryFormType->resolveSelectedCategory (line 14)
8	App\Form\HelpWithChoiceInquiryFormType->buildForm (line 50)
9	Symfony\Component\Form\ResolvedFormType->buildForm (line 96)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
11	Symfony\Component\Form\FormFactory->createNamedBuilder (line 56)
12	Symfony\Component\Form\FormFactory->createBuilder (line 41)
13	Symfony\Component\Form\FormFactory->create (line 26)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 355)
15	App\Controller\Global\InquiryController->inquiryForm (line 43)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
20	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
21	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
22	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
23	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 375)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
28	Twig\Template->yield (line 402)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 373)
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 76)
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)

1.21 ms
(1.86%)

SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, p0_.product_variant_id AS product_variant_id_10, p0_.event_id AS event_id_11 FROM price p0_ WHERE p0_.product_variant_id = ? AND p0_.valid_from <= ? AND (p0_.valid_until >= ? OR p0_.valid_until IS NULL) ORDER BY p0_.minimal_amount ASC LIMIT 1

Parameters:

[
  10
  "2026-03-29 22:12:25"
  "2026-03-29 22:12:25"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.price AS price_1,
  p0_.vat AS vat_2,
  p0_.minimal_amount AS minimal_amount_3,
  p0_.discount AS discount_4,
  p0_.valid_from AS valid_from_5,
  p0_.valid_until AS valid_until_6,
  p0_.created AS created_7,
  p0_.is_package AS is_package_8,
  p0_.min_price AS min_price_9,
  p0_.product_variant_id AS product_variant_id_10,
  p0_.event_id AS event_id_11
FROM
  price p0_
WHERE
  p0_.product_variant_id = ?
  AND p0_.valid_from <= ?
  AND (
    p0_.valid_until >= ?
    OR p0_.valid_until IS NULL
  )
ORDER BY
  p0_.minimal_amount ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, p0_.product_variant_id AS product_variant_id_10, p0_.event_id AS event_id_11 FROM price p0_ WHERE p0_.product_variant_id = 10 AND p0_.valid_from <= '2026-03-29 22:12:25' AND (p0_.valid_until >= '2026-03-29 22:12:25' OR p0_.valid_until IS NULL) ORDER BY p0_.minimal_amount 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	Greendot\EshopBundle\Repository\Project\PriceRepository->getMinimalAmount (line 172)
7	Greendot\EshopBundle\Service\Price\ProductVariantPrice->constructForProductVariant (line 342)
8	Greendot\EshopBundle\Service\Price\ProductVariantPrice->loadPrice (line 292)
9	Greendot\EshopBundle\Service\Price\ProductVariantPrice->__construct (line 80)
10	Greendot\EshopBundle\Service\Price\ProductVariantPriceFactory->create (line 56)
11	Greendot\EshopBundle\Service\Price\CalculatedPricesService->makeCalculatedPricesForProductVariant (line 49)
12	Greendot\EshopBundle\EventSubscriber\ProductVariantEventListener->postLoad (line 28)
13	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
14	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
15	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
16	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
17	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
18	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1026)
19	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1819)
20	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
21	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
22	Doctrine\ORM\PersistentCollection->initialize (line 186)
23	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
24	Greendot\EshopBundle\Repository\Project\ProductRepository->findAvailabilityByProduct (line 78)
25	Greendot\EshopBundle\EventSubscriber\ProductEventListener->postLoad (line 34)
26	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
27	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
28	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
29	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
30	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->doCleanupWithCompat (line 51)
31	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->cleanup (line 46)
32	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
33	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
34	Doctrine\ORM\AbstractQuery->execute (line 886)
35	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
36	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 36)
37	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
38	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
39	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
40	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
45	require_once (line 29)
46	require_once (line 5)

1.15 ms
(1.77%)

SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1

Parameters:

[
  1
  "2026-03-29 22:12:25"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.created AS created_1,
  c0_.valid_from AS valid_from_2,
  c0_.rate AS rate_3,
  c0_.currency_id AS currency_id_4
FROM
  conversion_rate c0_
WHERE
  c0_.currency_id = ?
  AND c0_.valid_from <= ?
ORDER BY
  c0_.valid_from DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = 1 AND c0_.valid_from <= '2026-03-29 22:12:25' ORDER BY c0_.valid_from DESC 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\ConversionRateRepository->getByDate (line 55)
7	Greendot\EshopBundle\Service\Price\PriceUtils->getConversionRate (line 60)
8	Greendot\EshopBundle\Service\Price\ProductVariantPriceFactory->create (line 53)
9	Greendot\EshopBundle\Service\Price\CalculatedPricesService->makeCalculatedPricesForProductVariant (line 49)
10	Greendot\EshopBundle\EventSubscriber\ProductVariantEventListener->postLoad (line 28)
11	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
12	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
13	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
14	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
15	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
16	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1026)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1819)
18	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
19	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
20	Doctrine\ORM\PersistentCollection->initialize (line 186)
21	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
22	Greendot\EshopBundle\Repository\Project\ProductRepository->findAvailabilityByProduct (line 78)
23	Greendot\EshopBundle\EventSubscriber\ProductEventListener->postLoad (line 34)
24	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
25	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
26	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
27	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
28	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->doCleanupWithCompat (line 51)
29	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->cleanup (line 46)
30	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
31	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
32	Doctrine\ORM\AbstractQuery->execute (line 886)
33	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
34	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 36)
35	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
36	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
37	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
38	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
41	Symfony\Component\HttpKernel\Kernel->handle (line 193)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
43	require_once (line 29)
44	require_once (line 5)

1.13 ms
(1.74%)

SELECT DISTINCT p0_.id AS id_0, p0_.data AS data_1, p0_.sequence AS sequence_2, p0_.parameter_group_id AS parameter_group_id_3, p0_.category_id AS category_id_4, p0_.product_variant_id AS product_variant_id_5, p0_.person_id AS person_id_6 FROM parameter p0_ LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p1_.id = ? AND p0_.product_variant_id IN (?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.data AS data_1,
  p0_.sequence AS sequence_2,
  p0_.parameter_group_id AS parameter_group_id_3,
  p0_.category_id AS category_id_4,
  p0_.product_variant_id AS product_variant_id_5,
  p0_.person_id AS person_id_6
FROM
  parameter p0_
  LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id
WHERE
  p1_.id = ?
  AND p0_.product_variant_id IN (?)

SELECT DISTINCT p0_.id AS id_0, p0_.data AS data_1, p0_.sequence AS sequence_2, p0_.parameter_group_id AS parameter_group_id_3, p0_.category_id AS category_id_4, p0_.product_variant_id AS product_variant_id_5, p0_.person_id AS person_id_6 FROM parameter p0_ LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p1_.id = 3 AND p0_.product_variant_id IN (82);

#	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\ParameterRepository->findProductParametersByGroupID (line 55)
7	__TwigTemplate_75de0ef3112d902452dccd36fcb91de7->doDisplay (line 199)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Extension\CoreExtension->include (line 1526)
13	__TwigTemplate_d926ced1853152153e4148a86a0762f3::doDisplay (line 69)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Extension\CoreExtension->include (line 1526)
19	__TwigTemplate_aadee3769e33878e1008219665ba40c3::block_body (line 1211)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
32	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	require_once (line 5)

1.12 ms
(1.73%)

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.category_type_id AS category_type_id_19, t0.upload_id AS upload_id_20 FROM p_category t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  68
]

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.category_type_id AS category_type_id_19,
  t0.upload_id AS upload_id_20
FROM
  p_category t0
WHERE
  t0.id = ?
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.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.category_type_id AS category_type_id_19, t0.upload_id AS upload_id_20 FROM p_category t0 WHERE t0.id = 68 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	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_ec5203657a1243d887dc58880d801801->doDisplay (line 102)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
32	__TwigTemplate_ab84d24f8e799e2c4dad1187cc977d13->doDisplay (line 68)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->block_header (line 403)
35	Twig\Template->yieldBlock (line 446)
36	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 193)
37	Twig\Template->yield (line 402)
38	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
39	Twig\Template->yield (line 402)
40	Twig\Template->display (line 358)
41	Twig\Template->render (line 373)
42	Twig\TemplateWrapper->render (line 51)
43	Twig\Environment->render (line 333)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
47	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
50	Symfony\Component\HttpKernel\Kernel->handle (line 193)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
52	require_once (line 29)
53	require_once (line 5)

0.95 ms
(1.47%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM sub_menu_type t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  6
]

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,
  t0.controller_name AS controller_name_4
FROM
  sub_menu_type t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM sub_menu_type t0 WHERE t0.id = 6 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	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_ec5203657a1243d887dc58880d801801->doDisplay (line 102)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
32	__TwigTemplate_ab84d24f8e799e2c4dad1187cc977d13->doDisplay (line 68)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->block_header (line 403)
35	Twig\Template->yieldBlock (line 446)
36	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 193)
37	Twig\Template->yield (line 402)
38	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
39	Twig\Template->yield (line 402)
40	Twig\Template->display (line 358)
41	Twig\Template->render (line 373)
42	Twig\TemplateWrapper->render (line 51)
43	Twig\Environment->render (line 333)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
47	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
50	Symfony\Component\HttpKernel\Kernel->handle (line 193)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
52	require_once (line 29)
53	require_once (line 5)

0.82 ms
(1.26%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM menu_type t0 WHERE t0.id = ? LIMIT 1

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.template AS template_3,
  t0.controller_name AS controller_name_4
FROM
  menu_type t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM menu_type t0 WHERE t0.id = 1 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	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_ec5203657a1243d887dc58880d801801->doDisplay (line 102)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
32	__TwigTemplate_ab84d24f8e799e2c4dad1187cc977d13->doDisplay (line 68)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->block_header (line 403)
35	Twig\Template->yieldBlock (line 446)
36	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 193)
37	Twig\Template->yield (line 402)
38	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
39	Twig\Template->yield (line 402)
40	Twig\Template->display (line 358)
41	Twig\Template->render (line 373)
42	Twig\TemplateWrapper->render (line 51)
43	Twig\Environment->render (line 333)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
47	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
50	Symfony\Component\HttpKernel\Kernel->handle (line 193)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
52	require_once (line 29)
53	require_once (line 5)

0.79 ms
(1.21%)

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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_product c1_ ON p0_.id = c1_.category_id WHERE c1_.product_id = ? AND p0_.category_type_id IS NOT NULL AND p0_.category_type_id NOT IN (?, ?, ?) ORDER BY p0_.category_type_id 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_.category_type_id AS category_type_id_18,
  p0_.upload_id AS upload_id_19
FROM
  p_category p0_
  LEFT JOIN category_product c1_ ON p0_.id = c1_.category_id
WHERE
  c1_.product_id = ?
  AND p0_.category_type_id IS NOT NULL
  AND p0_.category_type_id NOT IN (?, ?, ?)
ORDER BY
  p0_.category_type_id 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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_product c1_ ON p0_.id = c1_.category_id WHERE c1_.product_id = 10 AND p0_.category_type_id IS NOT NULL AND p0_.category_type_id NOT IN (10, 8, 11) ORDER BY p0_.category_type_id 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\Service\CustomProductInfoGetter->getProductCategoriesForBreadCrumbs (line 72)
7	App\Service\CustomProductInfoGetter->getProductBreadCrumbsArray (line 38)
8	Greendot\EshopBundle\Controller\FragmentController->fragmentBreadCrumbs (line 35)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
16	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 189)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
29	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 5)

0.71 ms
(1.09%)

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

Parameters:

[
  26
]

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.upload_group_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.upload_group_id = 26;

#	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 2729)
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_aadee3769e33878e1008219665ba40c3::block_body (line 696)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.67 ms
(1.03%)

SELECT p0_.slug AS slug_0 FROM product p0_ WHERE p0_.id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.slug AS slug_0
FROM
  product p0_
WHERE
  p0_.id = ?

SELECT p0_.slug AS slug_0 FROM product p0_ WHERE p0_.id = 10;

#	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\HintedRepositoryBase->findPropertyInLocale (line 77)
8	Greendot\EshopBundle\I18n\RouteTranslator->resolveTranslatableAttributeForClass (line 188)
9	Greendot\EshopBundle\I18n\RouteTranslator->getByRequest (line 82)
10	Greendot\EshopBundle\I18n\RouteTranslator->getByRequestStack (line 40)
11	Greendot\EshopBundle\Twig\AppExtension->localeMenu (line 163)
12	__TwigTemplate_d0c3317f744ffa57cb38131dd1e9c263->doDisplay (line 49)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
25	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
26	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
27	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
28	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
29	__TwigTemplate_ab84d24f8e799e2c4dad1187cc977d13->doDisplay (line 62)
30	Twig\Template->yield (line 402)
31	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->block_header (line 403)
32	Twig\Template->yieldBlock (line 446)
33	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 193)
34	Twig\Template->yield (line 402)
35	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
36	Twig\Template->yield (line 402)
37	Twig\Template->display (line 358)
38	Twig\Template->render (line 373)
39	Twig\TemplateWrapper->render (line 51)
40	Twig\Environment->render (line 333)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
44	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
45	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
46	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
47	Symfony\Component\HttpKernel\Kernel->handle (line 193)
48	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
49	require_once (line 29)
50	require_once (line 5)

0.65 ms
(1.00%)

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.product_id AS product_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10 FROM product_variant t0 WHERE t0.product_id = ?

Parameters:

[
  10
]

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.product_id AS product_id_8,
  t0.availability_id AS availability_id_9,
  t0.upload_id AS upload_id_10
FROM
  product_variant t0
WHERE
  t0.product_id = ?

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.product_id AS product_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10 FROM product_variant t0 WHERE t0.product_id = 10;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Greendot\EshopBundle\Repository\Project\ProductRepository->findAvailabilityByProduct (line 78)
8	Greendot\EshopBundle\EventSubscriber\ProductEventListener->postLoad (line 34)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->doCleanupWithCompat (line 51)
14	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->cleanup (line 46)
15	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
16	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
17	Doctrine\ORM\AbstractQuery->execute (line 886)
18	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
19	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 36)
20	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
21	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
22	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
23	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.64 ms
(0.99%)

SELECT DISTINCT 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_.producer_id AS producer_id_17, p0_.upload_id AS upload_id_18, p0_.product_type_id AS product_type_id_19, p0_.product_view_type_id AS product_view_type_id_20 FROM product p0_ LEFT JOIN category_product c1_ ON p0_.id = c1_.product_id WHERE c1_.category_id IN (?) AND p0_.is_active = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT 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_.producer_id AS producer_id_17,
  p0_.upload_id AS upload_id_18,
  p0_.product_type_id AS product_type_id_19,
  p0_.product_view_type_id AS product_view_type_id_20
FROM
  product p0_
  LEFT JOIN category_product c1_ ON p0_.id = c1_.product_id
WHERE
  c1_.category_id IN (?)
  AND p0_.is_active = ?

SELECT DISTINCT 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_.producer_id AS producer_id_17, p0_.upload_id AS upload_id_18, p0_.product_type_id AS product_type_id_19, p0_.product_view_type_id AS product_view_type_id_20 FROM product p0_ LEFT JOIN category_product c1_ ON p0_.id = c1_.product_id WHERE c1_.category_id IN (74) AND p0_.is_active = 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->getResult (line 688)
6	App\Repository\ProductRepository->findCategoryProducts (line 71)
7	App\Twig\AppExtension->findRelatedProducts (line 81)
8	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 1198)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.63 ms
(0.97%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM menu_type t0 WHERE t0.id = ?

Parameters:

[
  "4"
]

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,
  t0.controller_name AS controller_name_4
FROM
  menu_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM menu_type t0 WHERE t0.id = '4';

#	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	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
18	__TwigTemplate_ab84d24f8e799e2c4dad1187cc977d13->doDisplay (line 62)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->block_header (line 403)
21	Twig\Template->yieldBlock (line 446)
22	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 193)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
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 76)
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.59 ms
(0.90%)

SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.data AS data_2,
  t0.sequence AS sequence_3,
  t0.parameter_group_id AS parameter_group_id_4,
  t0.category_id AS category_id_5,
  t0.product_variant_id AS product_variant_id_6,
  t0.person_id AS person_id_7
FROM
  parameter t0
WHERE
  t0.product_variant_id = ?

SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = 10;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Greendot\EshopBundle\Repository\Project\ProductRepository->calculateParameters (line 51)
8	Greendot\EshopBundle\EventSubscriber\ProductEventListener->postLoad (line 35)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->doCleanupWithCompat (line 51)
14	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->cleanup (line 46)
15	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
16	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
17	Doctrine\ORM\AbstractQuery->execute (line 886)
18	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
19	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 36)
20	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
21	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
22	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
23	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.52 ms
(0.80%)

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.upload_group_id AS upload_group_id_3, t0.category_id AS category_id_4 FROM category_upload_group t0 WHERE t0.category_id = ?

Parameters:

[
  96
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.upload_group_id AS upload_group_id_3,
  t0.category_id AS category_id_4
FROM
  category_upload_group t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.upload_group_id AS upload_group_id_3, t0.category_id AS category_id_4 FROM category_upload_group t0 WHERE t0.category_id = 96;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 693)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
20	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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.48 ms
(0.73%)

SELECT t0.id AS id_1, t0.type AS type_2 FROM upload_group t0 WHERE t0.id = ?

Parameters:

[
  26
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2
FROM
  upload_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2 FROM upload_group t0 WHERE t0.id = 26;

#	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\UploadGroup::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Greendot\EshopBundle\Entity\Project\UploadGroup->__get (line 153)
7	Greendot\EshopBundle\Entity\Project\UploadGroup->getUpload (line 73)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_aadee3769e33878e1008219665ba40c3::block_body (line 696)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.44 ms
(0.68%)

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 3210)
11	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
12	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->doCleanupWithCompat (line 51)
13	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->cleanup (line 46)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
15	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
16	Doctrine\ORM\AbstractQuery->execute (line 886)
17	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
18	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 36)
19	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
20	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
21	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
22	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.37 ms
(0.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 31)
9	ContainerN4qy7ai\App_KernelDevDebugContainer->getProductVariantPriceFactoryService (line 2139)
10	ContainerN4qy7ai\App_KernelDevDebugContainer::getPurchasePriceFactoryService (line 2155)
11	ContainerN4qy7ai\App_KernelDevDebugContainer::getAffiliateServiceService (line 1974)
12	ContainerN4qy7ai\App_KernelDevDebugContainer::getBeforeControllerListenerService (line 1658)
13	ContainerN4qy7ai\App_KernelDevDebugContainer::ContainerN4qy7ai\{closure} (line 1288)
14	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 221)
15	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 256)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 120)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.35 ms
(0.54%)

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.producer_id AS producer_id_18, t0.upload_id AS upload_id_19, t0.product_type_id AS product_type_id_20, t0.product_view_type_id AS product_view_type_id_21 FROM product t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  "10"
]

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.producer_id AS producer_id_18,
  t0.upload_id AS upload_id_19,
  t0.product_type_id AS product_type_id_20,
  t0.product_view_type_id AS product_view_type_id_21
FROM
  product t0
WHERE
  t0.id = ?
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.producer_id AS producer_id_18, t0.upload_id AS upload_id_19, t0.product_type_id AS product_type_id_20, t0.product_view_type_id AS product_view_type_id_21 FROM product t0 WHERE t0.id = '10' 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	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 189)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
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 76)
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.31 ms
(0.47%)

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_super_id = ? ORDER BY t0.sequence ASC

Parameters:

[
  74
]

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.category_super_id AS category_super_id_4,
  t0.category_sub_id AS category_sub_id_5
FROM
  p_category_category t0
WHERE
  t0.category_super_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.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_super_id = 74 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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Repository\ProductRepository->findCategoryProducts (line 48)
8	App\Twig\AppExtension->findRelatedProducts (line 81)
9	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 1198)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.30 ms
(0.45%)

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.category_type_id AS category_type_id_19, t0.upload_id AS upload_id_20 FROM p_category t0 WHERE t0.id IS NULL LIMIT 1

Parameters:

[]

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.category_type_id AS category_type_id_19,
  t0.upload_id AS upload_id_20
FROM
  p_category t0
WHERE
  t0.id IS NULL
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.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.category_type_id AS category_type_id_19, t0.upload_id AS upload_id_20 FROM p_category t0 WHERE t0.id IS NULL 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	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 189)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
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 76)
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.29 ms
(0.44%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.class AS class_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6, t0.parameter_group_filter_type_id AS parameter_group_filter_type_id_7, t0.parameter_group_format_id AS parameter_group_format_id_8 FROM parameter_group t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.unit AS unit_3,
  t0.class AS class_4,
  t0.is_filter AS is_filter_5,
  t0.type_id AS type_id_6,
  t0.parameter_group_filter_type_id AS parameter_group_filter_type_id_7,
  t0.parameter_group_format_id AS parameter_group_format_id_8
FROM
  parameter_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.class AS class_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6, t0.parameter_group_filter_type_id AS parameter_group_filter_type_id_7, t0.parameter_group_format_id AS parameter_group_format_id_8 FROM parameter_group t0 WHERE t0.id = 3;

#	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\ParameterGroup::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Greendot\EshopBundle\Entity\Project\ParameterGroup->__get (line 153)
7	Greendot\EshopBundle\Entity\Project\ParameterGroup->getName (line 127)
8	Greendot\EshopBundle\Repository\Project\ProductRepository->calculateParameters (line 53)
9	Greendot\EshopBundle\EventSubscriber\ProductEventListener->postLoad (line 35)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
11	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
12	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
13	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
14	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->doCleanupWithCompat (line 51)
15	Gedmo\Translatable\Hydrator\ORM\ObjectHydrator->cleanup (line 46)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
17	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
18	Doctrine\ORM\AbstractQuery->execute (line 886)
19	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
20	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 36)
21	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
22	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
23	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
24	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.28 ms
(0.43%)

SELECT p0_.data AS data_0, p1_.name AS name_1, p1_.unit AS unit_2, p2_.name AS name_3 FROM parameter p0_ LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id LEFT JOIN parameter_group_filter_type p2_ ON p1_.parameter_group_filter_type_id = p2_.id WHERE p1_.type_id = ? AND p0_.product_variant_id IN (?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.data AS data_0,
  p1_.name AS name_1,
  p1_.unit AS unit_2,
  p2_.name AS name_3
FROM
  parameter p0_
  LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id
  LEFT JOIN parameter_group_filter_type p2_ ON p1_.parameter_group_filter_type_id = p2_.id
WHERE
  p1_.type_id = ?
  AND p0_.product_variant_id IN (?)

SELECT p0_.data AS data_0, p1_.name AS name_1, p1_.unit AS unit_2, p2_.name AS name_3 FROM parameter p0_ LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id LEFT JOIN parameter_group_filter_type p2_ ON p1_.parameter_group_filter_type_id = p2_.id WHERE p1_.type_id = 8 AND p0_.product_variant_id IN (10);

#	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\ParameterRepository->getFormattedParameters (line 466)
7	App\Twig\AppExtension->getFormatedParametersProduct (line 71)
8	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 254)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.26 ms
(0.40%)

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->getSlug (line 223)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_aadee3769e33878e1008219665ba40c3::block_body (line 625)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.25 ms
(0.38%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3 FROM parameter_group_type t0 WHERE t0.id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sequence AS sequence_3
FROM
  parameter_group_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3 FROM parameter_group_type t0 WHERE t0.id = 8;

#	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	App\Twig\AppExtension->getFormatedParametersProduct (line 69)
7	__TwigTemplate_aadee3769e33878e1008219665ba40c3->block_body (line 254)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_c1fb7a33a5eed358949c6123e00e09b0->doDisplay (line 227)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_aadee3769e33878e1008219665ba40c3->doDisplay (line 57)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
20	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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.22 ms
(0.34%)

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:

[
  1
]

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 = 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\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 72)
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)

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\Upload	77
Greendot\EshopBundle\Entity\Project\Category	53
Greendot\EshopBundle\Entity\Project\UploadGroup	30
Greendot\EshopBundle\Entity\Project\CategoryCategory	13
Greendot\EshopBundle\Entity\Project\CategoryType	9
Greendot\EshopBundle\Entity\Project\InformationBlock	5
Greendot\EshopBundle\Entity\Project\InformationBlockType	4
Greendot\EshopBundle\Entity\Project\Product	2
Greendot\EshopBundle\Entity\Project\ProductVariant	2
Greendot\EshopBundle\Entity\Project\Parameter	2
Greendot\EshopBundle\Entity\Project\ParameterGroupType	2
Greendot\EshopBundle\Entity\Project\MenuType	2
Greendot\EshopBundle\Entity\Project\SubMenuType	2
Greendot\EshopBundle\Entity\Project\CategoryUploadGroup	2
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\ParameterGroup	1
Greendot\EshopBundle\Entity\Project\Label	1
Greendot\EshopBundle\Entity\Project\UploadType	1

Entities Mapping

Class	Mapping errors
Greendot\EshopBundle\Entity\Project\Settings	No errors.
Greendot\EshopBundle\Entity\Project\Product	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\PurchaseProductVariant	No errors.
Greendot\EshopBundle\Entity\Project\Video	No errors.
Greendot\EshopBundle\Entity\Project\Parameter	No errors.
Greendot\EshopBundle\Entity\Project\Price	No errors.
Greendot\EshopBundle\Entity\Project\ProductVariantUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\Event	No errors.
Greendot\EshopBundle\Entity\Project\ParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\Category	No errors.
Greendot\EshopBundle\Entity\Project\Person	No errors.
Greendot\EshopBundle\Entity\Project\ParameterGroupType	No errors.
Greendot\EshopBundle\Entity\Project\ParameterGroupFilterType	No errors.
Greendot\EshopBundle\Entity\Project\ParameterGroupFormat	No errors.
Greendot\EshopBundle\Entity\Project\CategoryParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\MenuType	No errors.
Greendot\EshopBundle\Entity\Project\CategoryMenuType	No errors.
Greendot\EshopBundle\Entity\Project\CategoryCategory	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.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
Greendot\EshopBundle\Entity\Project\ProducerUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\UploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\UploadType	No errors.
Greendot\EshopBundle\Entity\Project\File	No errors.
Greendot\EshopBundle\Entity\Project\ReviewPoints	No errors.
Greendot\EshopBundle\Entity\Project\LabelType	No errors.
Greendot\EshopBundle\Entity\Project\ProductProductType	No errors.
Greendot\EshopBundle\Entity\Project\Client	No errors.
Greendot\EshopBundle\Entity\Project\InformationBlock	No errors.
Greendot\EshopBundle\Entity\Project\Purchase	No errors.
Greendot\EshopBundle\Entity\Project\EventType	No errors.
Greendot\EshopBundle\Entity\Project\PurchaseEvent	No errors.
Greendot\EshopBundle\Entity\Project\EventUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\PersonUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\ClientDiscount	No errors.
Greendot\EshopBundle\Entity\Project\Address	No errors.
Greendot\EshopBundle\Entity\Project\ClientAddress	No errors.
Greendot\EshopBundle\Entity\Project\InformationBlockType	No errors.
Greendot\EshopBundle\Entity\Project\CategoryInformationBlock	No errors.
Greendot\EshopBundle\Entity\Project\EventInformationBlock	No errors.
Greendot\EshopBundle\Entity\Project\PersonInformationBlock	No errors.
Greendot\EshopBundle\Entity\Project\PaymentType	No errors.
Greendot\EshopBundle\Entity\Project\Transportation	No errors.
Greendot\EshopBundle\Entity\PurchaseTracking	No errors.
Greendot\EshopBundle\Entity\Project\Voucher	No errors.
Greendot\EshopBundle\Entity\Project\Consent	No errors.
Greendot\EshopBundle\Entity\Project\PurchaseAddress	No errors.
Greendot\EshopBundle\Entity\Project\Payment	No errors.
Greendot\EshopBundle\Entity\Project\Message	No errors.
Greendot\EshopBundle\Entity\Project\PurchaseDiscussion	No errors.
Greendot\EshopBundle\Entity\Project\Branch	No errors.
Greendot\EshopBundle\Entity\Project\TransportationEvent	No errors.
Greendot\EshopBundle\Entity\Project\HandlingPrice	No errors.
Greendot\EshopBundle\Entity\Project\TransportationGroup	No errors.
Greendot\EshopBundle\Entity\Project\PaymentAction	No errors.
Greendot\EshopBundle\Entity\Project\BranchType	No errors.
Greendot\EshopBundle\Entity\Project\BranchOpeningHours	No errors.

Symfony Profiler

GET https://proklima.greendot.cz/poptavka/non_binding_inquiry/10

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping