Symfony Profiler

Query Metrics

13 Database Queries

9 Different statements

7.93 ms Query time

0 Invalid entities

105 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.03 ms
(25.63%)

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_.slug = ?

Parameters:

[
  "gdpr"
]

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_.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_.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_.slug = 'gdpr';

#	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.02 ms
(12.85%)

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_82acc7cc1fa68bd03c810f5706a46afc->doDisplay (line 56)
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\Web\GeneralPageController->getPage (line 44)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->forward (line 120)
30	Greendot\EshopBundle\Controller\MasterController->index (line 23)
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)

0.98 ms
(12.41%)

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 56)
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_82acc7cc1fa68bd03c810f5706a46afc->doDisplay (line 56)
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\Web\GeneralPageController->getPage (line 44)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->forward (line 120)
47	Greendot\EshopBundle\Controller\MasterController->index (line 23)
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.92 ms
(11.56%)

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 36)
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_82acc7cc1fa68bd03c810f5706a46afc->doDisplay (line 56)
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\Web\GeneralPageController->getPage (line 44)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->forward (line 120)
47	Greendot\EshopBundle\Controller\MasterController->index (line 23)
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.83 ms
(10.46%)

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 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_82acc7cc1fa68bd03c810f5706a46afc->doDisplay (line 56)
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\Web\GeneralPageController->getPage (line 44)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->forward (line 120)
47	Greendot\EshopBundle\Controller\MasterController->index (line 23)
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.75 ms
(9.40%)

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_82acc7cc1fa68bd03c810f5706a46afc->doDisplay (line 56)
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\Web\GeneralPageController->getPage (line 44)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->forward (line 120)
41	Greendot\EshopBundle\Controller\MasterController->index (line 23)
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)

0.72 ms
(9.07%)

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_82acc7cc1fa68bd03c810f5706a46afc->doDisplay (line 56)
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\Web\GeneralPageController->getPage (line 44)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->forward (line 120)
33	Greendot\EshopBundle\Controller\MasterController->index (line 23)
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.39 ms
(4.87%)

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	ContainerZtwvQf8\App_KernelDevDebugContainer->getProductVariantPriceFactoryService (line 2095)
10	ContainerZtwvQf8\App_KernelDevDebugContainer::getPurchasePriceFactoryService (line 2111)
11	ContainerZtwvQf8\App_KernelDevDebugContainer::getAffiliateServiceService (line 1930)
12	ContainerZtwvQf8\App_KernelDevDebugContainer::getBeforeControllerListenerService (line 1614)
13	ContainerZtwvQf8\App_KernelDevDebugContainer::ContainerZtwvQf8\{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.30 ms
(3.76%)

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:

[
  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.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 = 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\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->getControllerName (line 131)
8	Greendot\EshopBundle\Controller\MasterController->index (line 22)
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	41
Greendot\EshopBundle\Entity\Project\Upload	27
Greendot\EshopBundle\Entity\Project\UploadGroup	27
Greendot\EshopBundle\Entity\Project\CategoryType	6
Greendot\EshopBundle\Entity\Project\MenuType	2
Greendot\EshopBundle\Entity\Project\SubMenuType	2

Entities Mapping

Class	Mapping errors
Greendot\EshopBundle\Entity\Project\Settings	No errors.
Greendot\EshopBundle\Entity\Project\Category	No errors.
Greendot\EshopBundle\Entity\Project\CategoryType	No errors.
Greendot\EshopBundle\Entity\Project\Upload	No errors.
Greendot\EshopBundle\Entity\Project\Label	No errors.
Greendot\EshopBundle\Entity\Project\CategoryFile	No errors.
Greendot\EshopBundle\Entity\Project\CategoryCategory	No errors.
Greendot\EshopBundle\Entity\Project\Parameter	No errors.
Greendot\EshopBundle\Entity\Project\CategoryProduct	No errors.
Greendot\EshopBundle\Entity\Project\Comment	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\CategoryMenuType	No errors.
Greendot\EshopBundle\Entity\Project\SubMenuType	No errors.
Greendot\EshopBundle\Entity\Project\CategoryParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\MenuType	No errors.
Greendot\EshopBundle\Entity\Project\UploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\Product	No errors.
Greendot\EshopBundle\Entity\Project\ProductVariant	No errors.
Greendot\EshopBundle\Entity\Project\Producer	No errors.
Greendot\EshopBundle\Entity\Project\Person	No errors.
Greendot\EshopBundle\Entity\Project\UploadType	No errors.
Greendot\EshopBundle\Entity\Project\LabelType	No errors.
Greendot\EshopBundle\Entity\Project\File	No errors.
Greendot\EshopBundle\Entity\Project\ParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\Client	No errors.
Greendot\EshopBundle\Entity\Project\Event	No errors.
Greendot\EshopBundle\Entity\Project\PersonUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProductVariantUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProductUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\EventUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProducerUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\Review	No errors.
Greendot\EshopBundle\Entity\Project\ProductPerson	No errors.
Greendot\EshopBundle\Entity\Project\ProductParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProductProduct	No errors.
Greendot\EshopBundle\Entity\Project\ProductType	No errors.
Greendot\EshopBundle\Entity\Project\ProductInformationBlock	No errors.
Greendot\EshopBundle\Entity\Project\ProductViewType	No errors.
Greendot\EshopBundle\Entity\Project\PurchaseProductVariant	No errors.
Greendot\EshopBundle\Entity\Project\Video	No errors.
Greendot\EshopBundle\Entity\Project\Availability	No errors.
Greendot\EshopBundle\Entity\Project\Price	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\Purchase	No errors.
Greendot\EshopBundle\Entity\Project\EventType	No errors.
Greendot\EshopBundle\Entity\Project\PurchaseEvent	No errors.

Symfony Profiler

GET https://optixs-2014.greendot.cz/_fragment?_path=_format%3Dhtml%26_locale%3Dcs%26_controller%3DApp%255CController%255CWeb%255CMenuController%253A%253AgenerateSub…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping