Symfony Profiler

Query Metrics

117 Database Queries

26 Different statements

50.70 ms Query time

0 Invalid entities

117 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.58 ms
(16.93%)

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

Parameters:

[
  369
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	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 2737)
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	App\Controller\Web\MenuController->submenuAside (line 69)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
16	__TwigTemplate_f0c4e29e682f2b00aade522e3453ace3->doDisplay (line 102)
17	Twig\Template->yield (line 411)
18	Twig\Template->display (line 366)
19	Twig\Template->render (line 381)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
25	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
29	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
30	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
31	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
32	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
33	__TwigTemplate_0ba6dbae426bb8cc4c73bd7c97380d20->doDisplay (line 68)
34	Twig\Template->yield (line 411)
35	__TwigTemplate_8422e11e49bd35c29a896854615e3968->block_header (line 407)
36	Twig\Template->yieldBlock (line 456)
37	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
38	Twig\Template->yield (line 411)
39	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
40	Twig\Template->yield (line 411)
41	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
42	Twig\Template->yield (line 411)
43	Twig\Template->display (line 366)
44	Twig\Template->render (line 381)
45	Twig\TemplateWrapper->render (line 51)
46	Twig\Environment->render (line 333)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
49	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
50	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
51	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
52	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
53	Symfony\Component\HttpKernel\Kernel->handle (line 193)
54	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
55	require_once (line 29)
56	require_once (line 5)

8.37 ms
(16.52%)

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:

[
  5447
]

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\Greendot\EshopBundle\Entity\Project\Upload::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Greendot\EshopBundle\Entity\Project\Upload->__get (line 153)
7	Greendot\EshopBundle\Entity\Project\Upload->getPath (line 250)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_5e721c4f68a325ac4af17ebbc32427be::doDisplay (line 77)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\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->submenuAside (line 78)
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_f0c4e29e682f2b00aade522e3453ace3->doDisplay (line 102)
27	Twig\Template->yield (line 411)
28	Twig\Template->display (line 366)
29	Twig\Template->render (line 381)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
35	Greendot\EshopBundle\Controller\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_0ba6dbae426bb8cc4c73bd7c97380d20->doDisplay (line 68)
44	Twig\Template->yield (line 411)
45	__TwigTemplate_8422e11e49bd35c29a896854615e3968->block_header (line 407)
46	Twig\Template->yieldBlock (line 456)
47	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
48	Twig\Template->yield (line 411)
49	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
50	Twig\Template->yield (line 411)
51	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
52	Twig\Template->yield (line 411)
53	Twig\Template->display (line 366)
54	Twig\Template->render (line 381)
55	Twig\TemplateWrapper->render (line 51)
56	Twig\Environment->render (line 333)
57	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
58	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
59	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
60	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
61	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
62	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
63	Symfony\Component\HttpKernel\Kernel->handle (line 193)
64	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
65	require_once (line 29)
66	require_once (line 5)

7.56 ms
(14.91%)

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

Parameters:

[
  "cs"
  "Greendot\EshopBundle\Entity\Project\Category"
  "slug"
  "navsteva-u-makhmuda-muradova-o-kariere-bydleni-a-sitich-proti-hmyzu"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT e0_.foreign_key AS foreign_key_0 FROM ext_translations e0_ WHERE e0_.locale = 'cs' AND e0_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND e0_.field = 'slug' AND e0_.content = 'navsteva-u-makhmuda-muradova-o-kariere-bydleni-a-sitich-proti-hmyzu' LIMIT 1;

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

4.15 ms
(8.19%)

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

Parameters:

[
  420
  "Greendot\EshopBundle\Entity\Project\Category"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->toIterable (line 867)
4	Doctrine\ORM\Query->toIterable (line 606)
5	Gedmo\Translatable\Entity\Repository\TranslationRepository->findTranslations (line 151)
6	Greendot\EshopBundle\Repository\HintedRepositoryBase->findPropertyInLocale (line 115)
7	Greendot\EshopBundle\I18n\RouteTranslator->resolveTranslatableAttributeForClass (line 188)
8	Greendot\EshopBundle\I18n\RouteTranslator->getByRequest (line 82)
9	Greendot\EshopBundle\I18n\RouteTranslator->getByRequestStack (line 40)
10	Greendot\EshopBundle\Twig\AppExtension->localeMenu (line 167)
11	__TwigTemplate_b2f5f43a9d1a10eb581d0cb2adb15479->doDisplay (line 49)
12	Twig\Template->yield (line 411)
13	Twig\Template->display (line 366)
14	Twig\Template->render (line 381)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
20	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
24	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
25	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
26	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
27	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
28	__TwigTemplate_0ba6dbae426bb8cc4c73bd7c97380d20->doDisplay (line 62)
29	Twig\Template->yield (line 411)
30	__TwigTemplate_8422e11e49bd35c29a896854615e3968->block_header (line 407)
31	Twig\Template->yieldBlock (line 456)
32	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
33	Twig\Template->yield (line 411)
34	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
35	Twig\Template->yield (line 411)
36	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
37	Twig\Template->yield (line 411)
38	Twig\Template->display (line 366)
39	Twig\Template->render (line 381)
40	Twig\TemplateWrapper->render (line 51)
41	Twig\Environment->render (line 333)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
45	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
46	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
47	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
48	Symfony\Component\HttpKernel\Kernel->handle (line 193)
49	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
50	require_once (line 29)
51	require_once (line 5)

2.86 ms
(5.65%)

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

Parameters:

[
  "navsteva-u-makhmuda-muradova-o-kariere-bydleni-a-sitich-proti-hmyzu"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.additional_data AS additional_data_19, t0.special_category_code AS special_category_code_20, t0.category_type_id AS category_type_id_21, t0.upload_id AS upload_id_22 FROM p_category t0 WHERE t0.slug = 'navsteva-u-makhmuda-muradova-o-kariere-bydleni-a-sitich-proti-hmyzu' LIMIT 1;

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

2.70 ms
(5.32%)

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

Parameters:

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CategoryRepository->findSubMenuCategoriesProject (line 222)
7	App\Controller\Web\MenuController->submenuAside (line 64)
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_f0c4e29e682f2b00aade522e3453ace3->doDisplay (line 102)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
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_0ba6dbae426bb8cc4c73bd7c97380d20->doDisplay (line 68)
33	Twig\Template->yield (line 411)
34	__TwigTemplate_8422e11e49bd35c29a896854615e3968->block_header (line 407)
35	Twig\Template->yieldBlock (line 456)
36	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
37	Twig\Template->yield (line 411)
38	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
39	Twig\Template->yield (line 411)
40	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
41	Twig\Template->yield (line 411)
42	Twig\Template->display (line 366)
43	Twig\Template->render (line 381)
44	Twig\TemplateWrapper->render (line 51)
45	Twig\Environment->render (line 333)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
49	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
50	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
51	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
52	Symfony\Component\HttpKernel\Kernel->handle (line 193)
53	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
54	require_once (line 29)
55	require_once (line 5)

2.26 ms
(4.45%)

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:

[
  58
]

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

#	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 2737)
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_f0c4e29e682f2b00aade522e3453ace3::doDisplay (line 61)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\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_0ba6dbae426bb8cc4c73bd7c97380d20->doDisplay (line 68)
27	Twig\Template->yield (line 411)
28	__TwigTemplate_8422e11e49bd35c29a896854615e3968->block_header (line 407)
29	Twig\Template->yieldBlock (line 456)
30	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
31	Twig\Template->yield (line 411)
32	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
33	Twig\Template->yield (line 411)
34	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
35	Twig\Template->yield (line 411)
36	Twig\Template->display (line 366)
37	Twig\Template->render (line 381)
38	Twig\TemplateWrapper->render (line 51)
39	Twig\Environment->render (line 333)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
43	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
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.85 ms
(3.65%)

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->getSlugPrefix (line 133)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_b2f5f43a9d1a10eb581d0cb2adb15479::doDisplay (line 63)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\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_0ba6dbae426bb8cc4c73bd7c97380d20->doDisplay (line 62)
27	Twig\Template->yield (line 411)
28	__TwigTemplate_8422e11e49bd35c29a896854615e3968->block_header (line 407)
29	Twig\Template->yieldBlock (line 456)
30	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
31	Twig\Template->yield (line 411)
32	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
33	Twig\Template->yield (line 411)
34	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
35	Twig\Template->yield (line 411)
36	Twig\Template->display (line 366)
37	Twig\Template->render (line 381)
38	Twig\TemplateWrapper->render (line 51)
39	Twig\Environment->render (line 333)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
43	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
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.74 ms
(3.43%)

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

Parameters:

[
  420
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ WHERE p0_.id = 420;

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

1.56 ms
(3.08%)

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

Parameters:

View formatted query View runnable query Explain query View query backtrace

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

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p1_.id IS NULL AND c2_.menu_type_id = 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 154)
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_0ba6dbae426bb8cc4c73bd7c97380d20->doDisplay (line 62)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_8422e11e49bd35c29a896854615e3968->block_header (line 407)
18	Twig\Template->yieldBlock (line 456)
19	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
20	Twig\Template->yield (line 411)
21	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
22	Twig\Template->yield (line 411)
23	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
24	Twig\Template->yield (line 411)
25	Twig\Template->display (line 366)
26	Twig\Template->render (line 381)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
32	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	require_once (line 5)

1.49 ms
(2.94%)

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

Parameters:

[
  58
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_f0c4e29e682f2b00aade522e3453ace3->doDisplay (line 102)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
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_0ba6dbae426bb8cc4c73bd7c97380d20->doDisplay (line 68)
33	Twig\Template->yield (line 411)
34	__TwigTemplate_8422e11e49bd35c29a896854615e3968->block_header (line 407)
35	Twig\Template->yieldBlock (line 456)
36	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
37	Twig\Template->yield (line 411)
38	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
39	Twig\Template->yield (line 411)
40	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
41	Twig\Template->yield (line 411)
42	Twig\Template->display (line 366)
43	Twig\Template->render (line 381)
44	Twig\TemplateWrapper->render (line 51)
45	Twig\Environment->render (line 333)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
49	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
50	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
51	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
52	Symfony\Component\HttpKernel\Kernel->handle (line 193)
53	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
54	require_once (line 29)
55	require_once (line 5)

0.96 ms
(1.90%)

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

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_f0c4e29e682f2b00aade522e3453ace3->doDisplay (line 102)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
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_0ba6dbae426bb8cc4c73bd7c97380d20->doDisplay (line 68)
33	Twig\Template->yield (line 411)
34	__TwigTemplate_8422e11e49bd35c29a896854615e3968->block_header (line 407)
35	Twig\Template->yieldBlock (line 456)
36	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
37	Twig\Template->yield (line 411)
38	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
39	Twig\Template->yield (line 411)
40	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
41	Twig\Template->yield (line 411)
42	Twig\Template->display (line 366)
43	Twig\Template->render (line 381)
44	Twig\TemplateWrapper->render (line 51)
45	Twig\Environment->render (line 333)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
49	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
50	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
51	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
52	Symfony\Component\HttpKernel\Kernel->handle (line 193)
53	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
54	require_once (line 29)
55	require_once (line 5)

0.90 ms
(1.77%)

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

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_f0c4e29e682f2b00aade522e3453ace3->doDisplay (line 102)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
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_0ba6dbae426bb8cc4c73bd7c97380d20->doDisplay (line 68)
33	Twig\Template->yield (line 411)
34	__TwigTemplate_8422e11e49bd35c29a896854615e3968->block_header (line 407)
35	Twig\Template->yieldBlock (line 456)
36	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
37	Twig\Template->yield (line 411)
38	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
39	Twig\Template->yield (line 411)
40	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
41	Twig\Template->yield (line 411)
42	Twig\Template->display (line 366)
43	Twig\Template->render (line 381)
44	Twig\TemplateWrapper->render (line 51)
45	Twig\Environment->render (line 333)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
49	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
50	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
51	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
52	Symfony\Component\HttpKernel\Kernel->handle (line 193)
53	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
54	require_once (line 29)
55	require_once (line 5)

0.67 ms
(1.33%)

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_0ba6dbae426bb8cc4c73bd7c97380d20->doDisplay (line 62)
19	Twig\Template->yield (line 411)
20	__TwigTemplate_8422e11e49bd35c29a896854615e3968->block_header (line 407)
21	Twig\Template->yieldBlock (line 456)
22	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
23	Twig\Template->yield (line 411)
24	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
25	Twig\Template->yield (line 411)
26	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
27	Twig\Template->yield (line 411)
28	Twig\Template->display (line 366)
29	Twig\Template->render (line 381)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
35	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 193)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 29)
41	require_once (line 5)

0.67 ms
(1.32%)

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

Parameters:

[
  420
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT p0_.slug AS slug_0 FROM p_category p0_ WHERE p0_.id = 420;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Greendot\EshopBundle\Repository\HintedRepositoryBase->findPropertyInLocale (line 126)
8	Greendot\EshopBundle\I18n\RouteTranslator->resolveTranslatableAttributeForClass (line 188)
9	Greendot\EshopBundle\I18n\RouteTranslator->getByRequest (line 82)
10	Greendot\EshopBundle\I18n\RouteTranslator->getByRequestStack (line 40)
11	Greendot\EshopBundle\Twig\AppExtension->localeMenu (line 167)
12	__TwigTemplate_b2f5f43a9d1a10eb581d0cb2adb15479->doDisplay (line 49)
13	Twig\Template->yield (line 411)
14	Twig\Template->display (line 366)
15	Twig\Template->render (line 381)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
25	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
26	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
27	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
28	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
29	__TwigTemplate_0ba6dbae426bb8cc4c73bd7c97380d20->doDisplay (line 62)
30	Twig\Template->yield (line 411)
31	__TwigTemplate_8422e11e49bd35c29a896854615e3968->block_header (line 407)
32	Twig\Template->yieldBlock (line 456)
33	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 193)
34	Twig\Template->yield (line 411)
35	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
36	Twig\Template->yield (line 411)
37	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
38	Twig\Template->yield (line 411)
39	Twig\Template->display (line 366)
40	Twig\Template->render (line 381)
41	Twig\TemplateWrapper->render (line 51)
42	Twig\Environment->render (line 333)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
46	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
49	Symfony\Component\HttpKernel\Kernel->handle (line 193)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
51	require_once (line 29)
52	require_once (line 5)

0.61 ms
(1.19%)

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

Parameters:

[
  420
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Greendot\EshopBundle\Service\CategoryInfoGetter->getCategoryBreadCrumbsArray (line 28)
9	Greendot\EshopBundle\Controller\FragmentController->fragmentBreadCrumbs (line 44)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
13	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
14	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
15	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
16	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
17	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->block_breadcrumbs (line 139)
18	Twig\Template->yieldBlock (line 456)
19	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->block_body (line 106)
20	Twig\Template->yieldBlock (line 456)
21	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
22	Twig\Template->yield (line 411)
23	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
24	Twig\Template->yield (line 411)
25	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
26	Twig\Template->yield (line 411)
27	Twig\Template->display (line 366)
28	Twig\Template->render (line 381)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
34	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 193)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 29)
40	require_once (line 5)

0.60 ms
(1.19%)

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

Parameters:

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CategoryRepository->findSubCategoriesWithType (line 142)
7	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->block_content (line 148)
8	Twig\Template->yieldBlock (line 456)
9	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->block_body (line 109)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
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\BlogController->blogDetail (line 116)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.49 ms
(0.97%)

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

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.additional_data AS additional_data_19, t0.special_category_code AS special_category_code_20, t0.category_type_id AS category_type_id_21, t0.upload_id AS upload_id_22 FROM p_category t0 WHERE t0.id = 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\Schema\SchemaTwigExtension->collectBreadcrumbsSchema (line 63)
7	__TwigTemplate_e7e22ab591fcec696e3dfe691590e4b5->doDisplay (line 48)
8	Twig\Template->yield (line 411)
9	Twig\Template->display (line 366)
10	Twig\Template->render (line 381)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
16	Greendot\EshopBundle\Controller\FragmentController->fragmentBreadCrumbs (line 51)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
20	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
21	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
22	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
23	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
24	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->block_breadcrumbs (line 139)
25	Twig\Template->yieldBlock (line 456)
26	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->block_body (line 106)
27	Twig\Template->yieldBlock (line 456)
28	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
29	Twig\Template->yield (line 411)
30	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
31	Twig\Template->yield (line 411)
32	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
33	Twig\Template->yield (line 411)
34	Twig\Template->display (line 366)
35	Twig\Template->render (line 381)
36	Twig\TemplateWrapper->render (line 51)
37	Twig\Environment->render (line 333)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
41	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
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.46 ms
(0.91%)

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

Parameters:

[
  "%Datum vydání%"
  420
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT p0_.id AS id_0, p0_.data AS data_1, p0_.sequence AS sequence_2, p0_.parameter_group_id AS parameter_group_id_3, p0_.category_id AS category_id_4, p0_.product_variant_id AS product_variant_id_5, p0_.person_id AS person_id_6 FROM parameter p0_ LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p1_.name LIKE '%Datum vydání%' AND p0_.category_id = 420;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Greendot\EshopBundle\Repository\Project\ParameterRepository->getSingleParameterByParameterGroupForCategory (line 379)
7	Greendot\EshopBundle\Twig\AppExtension->getBlogArticlePublishDate (line 508)
8	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->block_content (line 132)
9	Twig\Template->yieldBlock (line 456)
10	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->block_body (line 109)
11	Twig\Template->yieldBlock (line 456)
12	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
17	Twig\Template->yield (line 411)
18	Twig\Template->display (line 366)
19	Twig\Template->render (line 381)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
25	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

0.35 ms
(0.70%)

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

Parameters:

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\UploadRepository->getCategoryUploadByUploadType (line 73)
7	__TwigTemplate_02a778ad313039ca9be69c1999d9db36->doDisplay (line 69)
8	Twig\Template->yield (line 411)
9	Twig\Template->display (line 366)
10	Twig\Template->render (line 381)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Extension\CoreExtension->include (line 1522)
13	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7::block_content (line 160)
14	Twig\Template->yieldBlock (line 456)
15	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->block_body (line 109)
16	Twig\Template->yieldBlock (line 456)
17	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
18	Twig\Template->yield (line 411)
19	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
20	Twig\Template->yield (line 411)
21	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
22	Twig\Template->yield (line 411)
23	Twig\Template->display (line 366)
24	Twig\Template->render (line 381)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
30	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
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.33 ms
(0.65%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->block_breadcrumbs (line 139)
16	Twig\Template->yieldBlock (line 456)
17	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->block_body (line 106)
18	Twig\Template->yieldBlock (line 456)
19	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
20	Twig\Template->yield (line 411)
21	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
22	Twig\Template->yield (line 411)
23	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
24	Twig\Template->yield (line 411)
25	Twig\Template->display (line 366)
26	Twig\Template->render (line 381)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
32	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	require_once (line 5)

0.32 ms
(0.64%)

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

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 114)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.32 ms
(0.64%)

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

Parameters:

[
  420
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Greendot\EshopBundle\Repository\Project\CategoryCategoryRepository->getMainCategoryForSubCategory (line 38)
7	Greendot\EshopBundle\Service\CategoryInfoGetter->getCategoryBreadCrumbsArray (line 29)
8	Greendot\EshopBundle\Controller\FragmentController->fragmentBreadCrumbs (line 44)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
16	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->block_breadcrumbs (line 139)
17	Twig\Template->yieldBlock (line 456)
18	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->block_body (line 106)
19	Twig\Template->yieldBlock (line 456)
20	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
21	Twig\Template->yield (line 411)
22	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
23	Twig\Template->yield (line 411)
24	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
25	Twig\Template->yield (line 411)
26	Twig\Template->display (line 366)
27	Twig\Template->render (line 381)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
33	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
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.32 ms
(0.64%)

SELECT u0_.id AS id_0 FROM upload_group u0_ LEFT JOIN category_upload_group c1_ ON u0_.id = c1_.upload_group_id WHERE c1_.category_id = ?

Parameters:

[
  105
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0
FROM
  upload_group u0_
  LEFT JOIN category_upload_group c1_ ON u0_.id = c1_.upload_group_id
WHERE
  c1_.category_id = ?

SELECT u0_.id AS id_0 FROM upload_group u0_ LEFT JOIN category_upload_group c1_ ON u0_.id = c1_.upload_group_id WHERE c1_.category_id = 105;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\UploadRepository->getCategoryUploadByUploadType (line 63)
7	__TwigTemplate_02a778ad313039ca9be69c1999d9db36->doDisplay (line 69)
8	Twig\Template->yield (line 411)
9	Twig\Template->display (line 366)
10	Twig\Template->render (line 381)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Extension\CoreExtension->include (line 1522)
13	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7::block_content (line 160)
14	Twig\Template->yieldBlock (line 456)
15	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->block_body (line 109)
16	Twig\Template->yieldBlock (line 456)
17	__TwigTemplate_8422e11e49bd35c29a896854615e3968->doDisplay (line 227)
18	Twig\Template->yield (line 411)
19	__TwigTemplate_1e6cbf6d4c2ff1082f46d8852b21f1ea->doDisplay (line 57)
20	Twig\Template->yield (line 411)
21	__TwigTemplate_5af2caa5c69877b63f24c373b7a7f3a7->doDisplay (line 55)
22	Twig\Template->yield (line 411)
23	Twig\Template->display (line 366)
24	Twig\Template->render (line 381)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
30	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
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.28 ms
(0.55%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sequence AS sequence_5, t0.label_type_id AS label_type_id_6 FROM p_label t0 WHERE t0.label_type_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.sequence AS sequence_5,
  t0.label_type_id AS label_type_id_6
FROM
  p_label t0
WHERE
  t0.label_type_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sequence AS sequence_5, t0.label_type_id AS label_type_id_6 FROM p_label t0 WHERE t0.label_type_id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 113)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.28 ms
(0.55%)

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

Parameters:

[
  "after_registration_discount"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Greendot\EshopBundle\Repository\Project\SettingsRepository->findParameterValueWithName (line 55)
8	Greendot\EshopBundle\Service\Price\ProductVariantPriceFactory->__construct (line 41)
9	ContainerXoUkwCr\App_KernelDevDebugContainer->getProductVariantPriceFactoryService (line 2339)
10	ContainerXoUkwCr\App_KernelDevDebugContainer::getCalculatedPricesServiceService (line 2296)
11	ContainerXoUkwCr\App_KernelDevDebugContainer::getTwigService (line 4637)
12	Symfony\Component\DependencyInjection\Container::getService (line 399)
13	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
17	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 116)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

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	46
Greendot\EshopBundle\Entity\Project\Upload	30
Greendot\EshopBundle\Entity\Project\UploadGroup	26
Greendot\EshopBundle\Entity\Project\CategoryType	9
Greendot\EshopBundle\Entity\Project\MenuType	2
Greendot\EshopBundle\Entity\Project\SubMenuType	2
Greendot\EshopBundle\Entity\Project\Label	1
Greendot\EshopBundle\Entity\Project\CategoryCategory	1

Entities Mapping

Class	Mapping errors
Greendot\EshopBundle\Entity\Project\Category	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	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\LabelType	No errors.
Greendot\EshopBundle\Entity\Project\Settings	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\InformationBlock	No errors.
Greendot\EshopBundle\Entity\Project\File	No errors.
Greendot\EshopBundle\Entity\Project\ParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\ParameterType	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\InformationBlockUploadGroup	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\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\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.
Greendot\EshopBundle\Entity\Project\ReviewPoints	No errors.
Greendot\EshopBundle\Entity\Project\ProductProductType	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\PaymentAction	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\BranchType	No errors.
Greendot\EshopBundle\Entity\Project\BranchOpeningHours	No errors.

Symfony Profiler

GET https://proklima.greendot.cz/novinky/navsteva-u-makhmuda-muradova-o-kariere-bydleni-a-sitich-proti-hmyzu

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping