Symfony Profiler

Query Metrics

19 Database Queries

13 Different statements

16.27 ms Query time

0 Invalid entities

121 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.81 ms
(35.68%)

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_ LEFT JOIN category_product c1_ ON p0_.id = c1_.product_id LEFT JOIN p_category p2_ ON c1_.category_id = p2_.id LEFT JOIN p_category_category p3_ ON p2_.id = p3_.category_sub_id WHERE (c1_.category_id = ? OR p3_.category_super_id = ?) AND (p0_.is_active = true)

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_.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
  LEFT JOIN p_category p2_ ON c1_.category_id = p2_.id
  LEFT JOIN p_category_category p3_ ON p2_.id = p3_.category_sub_id
WHERE
  (
    c1_.category_id = ?
    OR p3_.category_super_id = ?
  )
  AND (p0_.is_active = true)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.title AS title_4, p0_.slug AS slug_5, p0_.is_active AS is_active_6, p0_.is_visible AS is_visible_7, p0_.sequence AS sequence_8, p0_.javascript AS javascript_9, p0_.text_general AS text_general_10, p0_.state AS state_11, p0_.external_id AS external_id_12, p0_.is_indexable AS is_indexable_13, p0_.meta_description AS meta_description_14, p0_.has_variant_picture AS has_variant_picture_15, p0_.sold_amount AS sold_amount_16, p0_.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 LEFT JOIN p_category p2_ ON c1_.category_id = p2_.id LEFT JOIN p_category_category p3_ ON p2_.id = p3_.category_sub_id WHERE (c1_.category_id = 3836 OR p3_.category_super_id = 3836) AND (p0_.is_active = true);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\Web\MenuController->generateLaserSafetySubMenu (line 86)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
10	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
11	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
12	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
13	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
14	__TwigTemplate_ec5203657a1243d887dc58880d801801->doDisplay (line 116)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
27	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
28	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
29	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
30	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
31	__TwigTemplate_69fe3f9c30c53fd78606a3932393aa79->doDisplay (line 188)
32	Twig\Template->yield (line 402)
33	__TwigTemplate_32efc201dda7e50e9dd461476e37181c->doDisplay (line 57)
34	Twig\Template->yield (line 402)
35	Twig\Template->display (line 358)
36	Twig\Template->render (line 373)
37	Twig\TemplateWrapper->render (line 51)
38	Twig\Environment->render (line 333)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
42	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
45	Symfony\Component\HttpKernel\Kernel->handle (line 193)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
47	require_once (line 29)
48	require_once (line 5)

1.81 ms
(11.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_.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, u1_.id AS id_18, u1_.name AS name_19, u1_.extension AS extension_20, u1_.mime AS mime_21, u1_.title AS title_22, u1_.short_description AS short_description_23, u1_.description AS description_24, u1_.created AS created_25, u1_.path AS path_26, u1_.original_name AS original_name_27, u1_.width AS width_28, u1_.height AS height_29, u1_.sequence AS sequence_30, u1_.restriction AS restriction_31, p0_.category_type_id AS category_type_id_32, p0_.upload_id AS upload_id_33, u1_.upload_group_id AS upload_group_id_34, u1_.upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id LEFT JOIN category_sub_menu_type c3_ ON p0_.id = c3_.category_id LEFT JOIN sub_menu_type s2_ ON s2_.id = c3_.sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_.id = p4_.category_sub_id WHERE p0_.is_active = ? AND p0_.id >= ? AND p0_.id <> ? AND p4_.category_super_id = ? AND s2_.id = ? ORDER BY p4_.sequence ASC, p0_.sequence ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.html AS html_4,
  p0_.title AS title_5,
  p0_.is_active AS is_active_6,
  p0_.slug AS slug_7,
  p0_.javascript AS javascript_8,
  p0_.sequence AS sequence_9,
  p0_.is_menu AS is_menu_10,
  p0_.latitude AS latitude_11,
  p0_.longitude AS longitude_12,
  p0_.state AS state_13,
  p0_.has_comments AS has_comments_14,
  p0_.is_indexable AS is_indexable_15,
  p0_.created_at AS created_at_16,
  p0_.published_at AS published_at_17,
  u1_.id AS id_18,
  u1_.name AS name_19,
  u1_.extension AS extension_20,
  u1_.mime AS mime_21,
  u1_.title AS title_22,
  u1_.short_description AS short_description_23,
  u1_.description AS description_24,
  u1_.created AS created_25,
  u1_.path AS path_26,
  u1_.original_name AS original_name_27,
  u1_.width AS width_28,
  u1_.height AS height_29,
  u1_.sequence AS sequence_30,
  u1_.restriction AS restriction_31,
  p0_.category_type_id AS category_type_id_32,
  p0_.upload_id AS upload_id_33,
  u1_.upload_group_id AS upload_group_id_34,
  u1_.upload_type_id AS upload_type_id_35
FROM
  p_category p0_
  LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id
  LEFT JOIN category_sub_menu_type c3_ ON p0_.id = c3_.category_id
  LEFT JOIN sub_menu_type s2_ ON s2_.id = c3_.sub_menu_type_id
  LEFT JOIN p_category_category p4_ ON p0_.id = p4_.category_sub_id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p0_.id <> ?
  AND p4_.category_super_id = ?
  AND s2_.id = ?
ORDER BY
  p4_.sequence ASC,
  p0_.sequence ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, u1_.id AS id_18, u1_.name AS name_19, u1_.extension AS extension_20, u1_.mime AS mime_21, u1_.title AS title_22, u1_.short_description AS short_description_23, u1_.description AS description_24, u1_.created AS created_25, u1_.path AS path_26, u1_.original_name AS original_name_27, u1_.width AS width_28, u1_.height AS height_29, u1_.sequence AS sequence_30, u1_.restriction AS restriction_31, p0_.category_type_id AS category_type_id_32, p0_.upload_id AS upload_id_33, u1_.upload_group_id AS upload_group_id_34, u1_.upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id LEFT JOIN category_sub_menu_type c3_ ON p0_.id = c3_.category_id LEFT JOIN sub_menu_type s2_ ON s2_.id = c3_.sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_.id = p4_.category_sub_id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p0_.id <> 2143 AND p4_.category_super_id = 2143 AND s2_.id = 3 ORDER BY p4_.sequence ASC, p0_.sequence ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Greendot\EshopBundle\Repository\Project\CategoryRepository->findSubMenuCategories (line 196)
7	App\Controller\Web\MenuController->generateSubMenu (line 37)
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 116)
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_69fe3f9c30c53fd78606a3932393aa79->doDisplay (line 188)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_32efc201dda7e50e9dd461476e37181c->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)

1.71 ms
(10.52%)

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:

[
  2141
]

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

#	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 57)
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_69fe3f9c30c53fd78606a3932393aa79->doDisplay (line 188)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_32efc201dda7e50e9dd461476e37181c->doDisplay (line 57)
29	Twig\Template->yield (line 402)
30	Twig\Template->display (line 358)
31	Twig\Template->render (line 373)
32	Twig\TemplateWrapper->render (line 51)
33	Twig\Environment->render (line 333)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
37	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Component\HttpKernel\Kernel->handle (line 193)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
42	require_once (line 29)
43	require_once (line 5)

1.15 ms
(7.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_.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_69fe3f9c30c53fd78606a3932393aa79->doDisplay (line 171)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_32efc201dda7e50e9dd461476e37181c->doDisplay (line 57)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

1.11 ms
(6.82%)

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, u1_.id AS id_18, u1_.name AS name_19, u1_.extension AS extension_20, u1_.mime AS mime_21, u1_.title AS title_22, u1_.short_description AS short_description_23, u1_.description AS description_24, u1_.created AS created_25, u1_.path AS path_26, u1_.original_name AS original_name_27, u1_.width AS width_28, u1_.height AS height_29, u1_.sequence AS sequence_30, u1_.restriction AS restriction_31, p0_.category_type_id AS category_type_id_32, p0_.upload_id AS upload_id_33, u1_.upload_group_id AS upload_group_id_34, u1_.upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id LEFT JOIN category_sub_menu_type c3_ ON p0_.id = c3_.category_id LEFT JOIN sub_menu_type s2_ ON s2_.id = c3_.sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_.id = p4_.category_sub_id WHERE p0_.is_active = ? AND p0_.id >= ? AND p0_.id <> ? AND p4_.category_super_id = ? AND s2_.id = ? AND p0_.category_type_id IN (?) ORDER BY p4_.sequence ASC, p0_.sequence ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.html AS html_4,
  p0_.title AS title_5,
  p0_.is_active AS is_active_6,
  p0_.slug AS slug_7,
  p0_.javascript AS javascript_8,
  p0_.sequence AS sequence_9,
  p0_.is_menu AS is_menu_10,
  p0_.latitude AS latitude_11,
  p0_.longitude AS longitude_12,
  p0_.state AS state_13,
  p0_.has_comments AS has_comments_14,
  p0_.is_indexable AS is_indexable_15,
  p0_.created_at AS created_at_16,
  p0_.published_at AS published_at_17,
  u1_.id AS id_18,
  u1_.name AS name_19,
  u1_.extension AS extension_20,
  u1_.mime AS mime_21,
  u1_.title AS title_22,
  u1_.short_description AS short_description_23,
  u1_.description AS description_24,
  u1_.created AS created_25,
  u1_.path AS path_26,
  u1_.original_name AS original_name_27,
  u1_.width AS width_28,
  u1_.height AS height_29,
  u1_.sequence AS sequence_30,
  u1_.restriction AS restriction_31,
  p0_.category_type_id AS category_type_id_32,
  p0_.upload_id AS upload_id_33,
  u1_.upload_group_id AS upload_group_id_34,
  u1_.upload_type_id AS upload_type_id_35
FROM
  p_category p0_
  LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id
  LEFT JOIN category_sub_menu_type c3_ ON p0_.id = c3_.category_id
  LEFT JOIN sub_menu_type s2_ ON s2_.id = c3_.sub_menu_type_id
  LEFT JOIN p_category_category p4_ ON p0_.id = p4_.category_sub_id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p0_.id <> ?
  AND p4_.category_super_id = ?
  AND s2_.id = ?
  AND p0_.category_type_id IN (?)
ORDER BY
  p4_.sequence ASC,
  p0_.sequence ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, u1_.id AS id_18, u1_.name AS name_19, u1_.extension AS extension_20, u1_.mime AS mime_21, u1_.title AS title_22, u1_.short_description AS short_description_23, u1_.description AS description_24, u1_.created AS created_25, u1_.path AS path_26, u1_.original_name AS original_name_27, u1_.width AS width_28, u1_.height AS height_29, u1_.sequence AS sequence_30, u1_.restriction AS restriction_31, p0_.category_type_id AS category_type_id_32, p0_.upload_id AS upload_id_33, u1_.upload_group_id AS upload_group_id_34, u1_.upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id LEFT JOIN category_sub_menu_type c3_ ON p0_.id = c3_.category_id LEFT JOIN sub_menu_type s2_ ON s2_.id = c3_.sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_.id = p4_.category_sub_id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p0_.id <> 2141 AND p4_.category_super_id = 2141 AND s2_.id = 1 AND p0_.category_type_id IN (2) ORDER BY p4_.sequence ASC, p0_.sequence ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Greendot\EshopBundle\Repository\Project\CategoryRepository->findSubMenuCategories (line 196)
7	App\Controller\Web\MenuController->generateProductsSubMenu (line 57)
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 116)
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_69fe3f9c30c53fd78606a3932393aa79->doDisplay (line 188)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_32efc201dda7e50e9dd461476e37181c->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)

1.02 ms
(6.30%)

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, u1_.id AS id_18, u1_.name AS name_19, u1_.extension AS extension_20, u1_.mime AS mime_21, u1_.title AS title_22, u1_.short_description AS short_description_23, u1_.description AS description_24, u1_.created AS created_25, u1_.path AS path_26, u1_.original_name AS original_name_27, u1_.width AS width_28, u1_.height AS height_29, u1_.sequence AS sequence_30, u1_.restriction AS restriction_31, p0_.category_type_id AS category_type_id_32, p0_.upload_id AS upload_id_33, u1_.upload_group_id AS upload_group_id_34, u1_.upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id LEFT JOIN category_sub_menu_type c3_ ON p0_.id = c3_.category_id LEFT JOIN sub_menu_type s2_ ON s2_.id = c3_.sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_.id = p4_.category_sub_id WHERE p0_.is_active = ? AND p0_.id >= ? AND p0_.id <> ? AND p4_.category_super_id = ? AND s2_.id = ? AND p0_.category_type_id NOT IN (?) ORDER BY p4_.sequence ASC, p0_.sequence ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.html AS html_4,
  p0_.title AS title_5,
  p0_.is_active AS is_active_6,
  p0_.slug AS slug_7,
  p0_.javascript AS javascript_8,
  p0_.sequence AS sequence_9,
  p0_.is_menu AS is_menu_10,
  p0_.latitude AS latitude_11,
  p0_.longitude AS longitude_12,
  p0_.state AS state_13,
  p0_.has_comments AS has_comments_14,
  p0_.is_indexable AS is_indexable_15,
  p0_.created_at AS created_at_16,
  p0_.published_at AS published_at_17,
  u1_.id AS id_18,
  u1_.name AS name_19,
  u1_.extension AS extension_20,
  u1_.mime AS mime_21,
  u1_.title AS title_22,
  u1_.short_description AS short_description_23,
  u1_.description AS description_24,
  u1_.created AS created_25,
  u1_.path AS path_26,
  u1_.original_name AS original_name_27,
  u1_.width AS width_28,
  u1_.height AS height_29,
  u1_.sequence AS sequence_30,
  u1_.restriction AS restriction_31,
  p0_.category_type_id AS category_type_id_32,
  p0_.upload_id AS upload_id_33,
  u1_.upload_group_id AS upload_group_id_34,
  u1_.upload_type_id AS upload_type_id_35
FROM
  p_category p0_
  LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id
  LEFT JOIN category_sub_menu_type c3_ ON p0_.id = c3_.category_id
  LEFT JOIN sub_menu_type s2_ ON s2_.id = c3_.sub_menu_type_id
  LEFT JOIN p_category_category p4_ ON p0_.id = p4_.category_sub_id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p0_.id <> ?
  AND p4_.category_super_id = ?
  AND s2_.id = ?
  AND p0_.category_type_id NOT IN (?)
ORDER BY
  p4_.sequence ASC,
  p0_.sequence ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, u1_.id AS id_18, u1_.name AS name_19, u1_.extension AS extension_20, u1_.mime AS mime_21, u1_.title AS title_22, u1_.short_description AS short_description_23, u1_.description AS description_24, u1_.created AS created_25, u1_.path AS path_26, u1_.original_name AS original_name_27, u1_.width AS width_28, u1_.height AS height_29, u1_.sequence AS sequence_30, u1_.restriction AS restriction_31, p0_.category_type_id AS category_type_id_32, p0_.upload_id AS upload_id_33, u1_.upload_group_id AS upload_group_id_34, u1_.upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id LEFT JOIN category_sub_menu_type c3_ ON p0_.id = c3_.category_id LEFT JOIN sub_menu_type s2_ ON s2_.id = c3_.sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_.id = p4_.category_sub_id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p0_.id <> 2141 AND p4_.category_super_id = 2141 AND s2_.id = 1 AND p0_.category_type_id NOT IN (2) ORDER BY p4_.sequence ASC, p0_.sequence ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Greendot\EshopBundle\Repository\Project\CategoryRepository->findSubMenuCategories (line 196)
7	App\Controller\Web\MenuController->generateProductsSubMenu (line 58)
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 116)
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_69fe3f9c30c53fd78606a3932393aa79->doDisplay (line 188)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_32efc201dda7e50e9dd461476e37181c->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)

0.77 ms
(4.74%)

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_69fe3f9c30c53fd78606a3932393aa79->doDisplay (line 171)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_32efc201dda7e50e9dd461476e37181c->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.76 ms
(4.65%)

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 = ?) AND (p0_.is_active = true)

Parameters:

[
  "ochranna-laserova-bunka"
]

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 = ?)
  AND (p0_.is_active = true)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.title AS title_4, p0_.slug AS slug_5, p0_.is_active AS is_active_6, p0_.is_visible AS is_visible_7, p0_.sequence AS sequence_8, p0_.javascript AS javascript_9, p0_.text_general AS text_general_10, p0_.state AS state_11, p0_.external_id AS external_id_12, p0_.is_indexable AS is_indexable_13, p0_.meta_description AS meta_description_14, p0_.has_variant_picture AS has_variant_picture_15, p0_.sold_amount AS sold_amount_16, p0_.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 = 'ochranna-laserova-bunka') AND (p0_.is_active = true);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Greendot\EshopBundle\Repository\HintedRepositoryBase->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)

0.75 ms
(4.60%)

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	ContainerA6NJVIk\App_KernelDevDebugContainer->getProductVariantPriceFactoryService (line 2095)
10	ContainerA6NJVIk\App_KernelDevDebugContainer::getPurchasePriceFactoryService (line 2111)
11	ContainerA6NJVIk\App_KernelDevDebugContainer::getAffiliateServiceService (line 1930)
12	ContainerA6NJVIk\App_KernelDevDebugContainer::getBeforeControllerListenerService (line 1614)
13	ContainerA6NJVIk\App_KernelDevDebugContainer::ContainerA6NJVIk\{closure} (line 1322)
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.38 ms
(2.33%)

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:

[
  67825
]

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

#	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_aa4ecd931ebf7ed07bcafa8547d32efc::doDisplay (line 154)
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->generateLaserSafetySubMenu (line 87)
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 116)
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_69fe3f9c30c53fd78606a3932393aa79->doDisplay (line 188)
44	Twig\Template->yield (line 402)
45	__TwigTemplate_32efc201dda7e50e9dd461476e37181c->doDisplay (line 57)
46	Twig\Template->yield (line 402)
47	Twig\Template->display (line 358)
48	Twig\Template->render (line 373)
49	Twig\TemplateWrapper->render (line 51)
50	Twig\Environment->render (line 333)
51	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
52	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
53	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
54	Greendot\EshopBundle\Controller\Shop\ProductController->index (line 76)
55	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
56	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
57	Symfony\Component\HttpKernel\Kernel->handle (line 193)
58	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
59	require_once (line 29)
60	require_once (line 5)

0.37 ms
(2.26%)

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.35 ms
(2.18%)

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 = ? AND ((t0.is_active = true))

Parameters:

[
  56001
]

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 = ?
  AND (
    (t0.is_active = true)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.expected_restock_date AS expected_restock_date_6, t0.is_active AS is_active_7, t0.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 = 56001 AND ((t0.is_active = true));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 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.28 ms
(1.71%)

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\Category	43
Greendot\EshopBundle\Entity\Project\Upload	31
Greendot\EshopBundle\Entity\Project\UploadGroup	31
Greendot\EshopBundle\Entity\Project\CategoryType	7
Greendot\EshopBundle\Entity\Project\SubMenuType	3
Greendot\EshopBundle\Entity\Project\MenuType	2
Greendot\EshopBundle\Entity\Project\Product	1
Greendot\EshopBundle\Entity\Project\ProductType	1
Greendot\EshopBundle\Entity\Project\ProductViewType	1
Greendot\EshopBundle\Entity\Project\Currency	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\MenuType	No errors.
Greendot\EshopBundle\Entity\Project\CategoryMenuType	No errors.
Greendot\EshopBundle\Entity\Project\Category	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\Parameter	No errors.
Greendot\EshopBundle\Entity\Project\CategoryPerson	No errors.
Greendot\EshopBundle\Entity\Project\CategoryEvent	No errors.
Greendot\EshopBundle\Entity\Project\CategoryUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\SubMenuType	No errors.
Greendot\EshopBundle\Entity\Project\CategoryParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProducerUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\UploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\Person	No errors.
Greendot\EshopBundle\Entity\Project\UploadType	No errors.
Greendot\EshopBundle\Entity\Project\PurchaseProductVariant	No errors.
Greendot\EshopBundle\Entity\Project\Video	No errors.
Greendot\EshopBundle\Entity\Project\Price	No errors.
Greendot\EshopBundle\Entity\Project\ProductVariantUploadGroup	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\ParameterGroup	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\Event	No errors.
Greendot\EshopBundle\Entity\Project\PersonUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\EventUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\Purchase	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\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\EventType	No errors.
Greendot\EshopBundle\Entity\Project\PurchaseEvent	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://optixs-2014.greendot.cz/_fragment/generate-menu/1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping