Symfony Profiler

Query Metrics

27 Database Queries

12 Different statements

2939.50 ms Query time

0 Invalid entities

82 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2731.41 ms
(92.92%)

SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.html) AS html_4, COALESCE(t5_.content, p0_.title) AS title_5, p0_.is_active AS is_active_6, COALESCE(t6_.content, p0_.slug) AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'html' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'title' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'slug' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_.foreign_key = p0_.id WHERE COALESCE(t6_.content, p0_.slug) = ?

Parameters:

[
  "vstupenky-na-msv-2018-zdarma-pro-nase-zakazniky"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  COALESCE(t1_.content, p0_.name) AS name_1,
  COALESCE(t2_.content, p0_.menu_name) AS menu_name_2,
  COALESCE(t3_.content, p0_.description) AS description_3,
  COALESCE(t4_.content, p0_.html) AS html_4,
  COALESCE(t5_.content, p0_.title) AS title_5,
  p0_.is_active AS is_active_6,
  COALESCE(t6_.content, p0_.slug) AS slug_7,
  p0_.javascript AS javascript_8,
  p0_.sequence AS sequence_9,
  p0_.is_menu AS is_menu_10,
  p0_.latitude AS latitude_11,
  p0_.longitude AS longitude_12,
  p0_.state AS state_13,
  p0_.has_comments AS has_comments_14,
  p0_.is_indexable AS is_indexable_15,
  p0_.created_at AS created_at_16,
  p0_.published_at AS published_at_17,
  p0_.category_type_id AS category_type_id_18,
  p0_.upload_id AS upload_id_19
FROM
  p_category p0_
  LEFT JOIN ext_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'name'
  AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t1_.foreign_key = p0_.id
  LEFT JOIN ext_translations t2_ ON t2_.locale = 'en'
  AND t2_.field = 'menu_name'
  AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t2_.foreign_key = p0_.id
  LEFT JOIN ext_translations t3_ ON t3_.locale = 'en'
  AND t3_.field = 'description'
  AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t3_.foreign_key = p0_.id
  LEFT JOIN ext_translations t4_ ON t4_.locale = 'en'
  AND t4_.field = 'html'
  AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t4_.foreign_key = p0_.id
  LEFT JOIN ext_translations t5_ ON t5_.locale = 'en'
  AND t5_.field = 'title'
  AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t5_.foreign_key = p0_.id
  LEFT JOIN ext_translations t6_ ON t6_.locale = 'en'
  AND t6_.field = 'slug'
  AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t6_.foreign_key = p0_.id
WHERE
  COALESCE(t6_.content, p0_.slug) = ?

SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.html) AS html_4, COALESCE(t5_.content, p0_.title) AS title_5, p0_.is_active AS is_active_6, COALESCE(t6_.content, p0_.slug) AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'html' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'title' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'slug' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_.foreign_key = p0_.id WHERE COALESCE(t6_.content, p0_.slug) = 'vstupenky-na-msv-2018-zdarma-pro-nase-zakazniky';

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

86.51 ms
(2.94%)

SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.html) AS html_4, COALESCE(t5_.content, p0_.title) AS title_5, p0_.is_active AS is_active_6, COALESCE(t6_.content, p0_.slug) AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p7_ ON p0_.id = p7_.category_sub_id LEFT JOIN category_menu_type c8_ ON p0_.id = c8_.category_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'html' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'title' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'slug' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_.foreign_key = p0_.id WHERE p0_.is_active = ? AND p0_.id >= ? AND p7_.id IS NULL AND c8_.menu_type_id = ? ORDER BY c8_.sequence ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  COALESCE(t1_.content, p0_.name) AS name_1,
  COALESCE(t2_.content, p0_.menu_name) AS menu_name_2,
  COALESCE(t3_.content, p0_.description) AS description_3,
  COALESCE(t4_.content, p0_.html) AS html_4,
  COALESCE(t5_.content, p0_.title) AS title_5,
  p0_.is_active AS is_active_6,
  COALESCE(t6_.content, p0_.slug) AS slug_7,
  p0_.javascript AS javascript_8,
  p0_.sequence AS sequence_9,
  p0_.is_menu AS is_menu_10,
  p0_.latitude AS latitude_11,
  p0_.longitude AS longitude_12,
  p0_.state AS state_13,
  p0_.has_comments AS has_comments_14,
  p0_.is_indexable AS is_indexable_15,
  p0_.created_at AS created_at_16,
  p0_.published_at AS published_at_17,
  p0_.category_type_id AS category_type_id_18,
  p0_.upload_id AS upload_id_19
FROM
  p_category p0_
  LEFT JOIN p_category_category p7_ ON p0_.id = p7_.category_sub_id
  LEFT JOIN category_menu_type c8_ ON p0_.id = c8_.category_id
  LEFT JOIN ext_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'name'
  AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t1_.foreign_key = p0_.id
  LEFT JOIN ext_translations t2_ ON t2_.locale = 'en'
  AND t2_.field = 'menu_name'
  AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t2_.foreign_key = p0_.id
  LEFT JOIN ext_translations t3_ ON t3_.locale = 'en'
  AND t3_.field = 'description'
  AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t3_.foreign_key = p0_.id
  LEFT JOIN ext_translations t4_ ON t4_.locale = 'en'
  AND t4_.field = 'html'
  AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t4_.foreign_key = p0_.id
  LEFT JOIN ext_translations t5_ ON t5_.locale = 'en'
  AND t5_.field = 'title'
  AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t5_.foreign_key = p0_.id
  LEFT JOIN ext_translations t6_ ON t6_.locale = 'en'
  AND t6_.field = 'slug'
  AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t6_.foreign_key = p0_.id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p7_.id IS NULL
  AND c8_.menu_type_id = ?
ORDER BY
  c8_.sequence ASC

SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.html) AS html_4, COALESCE(t5_.content, p0_.title) AS title_5, p0_.is_active AS is_active_6, COALESCE(t6_.content, p0_.slug) AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p7_ ON p0_.id = p7_.category_sub_id LEFT JOIN category_menu_type c8_ ON p0_.id = c8_.category_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'html' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'title' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'slug' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_.foreign_key = p0_.id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p7_.id IS NULL AND c8_.menu_type_id = 4 ORDER BY c8_.sequence ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Greendot\EshopBundle\Repository\Project\CategoryRepository->findMenuCategories (line 153)
7	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 23)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_a6e6be744958c446ee67cde7f012519f->doDisplay (line 180)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_10c22825f6b7153f8f7394c155a5d33a->doDisplay (line 57)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 102)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

79.99 ms
(2.72%)

SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.html) AS html_4, COALESCE(t5_.content, p0_.title) AS title_5, p0_.is_active AS is_active_6, COALESCE(t6_.content, 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, u7_.id AS id_18, u7_.name AS name_19, u7_.extension AS extension_20, u7_.mime AS mime_21, u7_.title AS title_22, u7_.short_description AS short_description_23, u7_.description AS description_24, u7_.created AS created_25, u7_.path AS path_26, u7_.original_name AS original_name_27, u7_.width AS width_28, u7_.height AS height_29, u7_.sequence AS sequence_30, u7_.restriction AS restriction_31, p0_.category_type_id AS category_type_id_32, p0_.upload_id AS upload_id_33, u7_.upload_group_id AS upload_group_id_34, u7_.upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u7_ ON p0_.upload_id = u7_.id LEFT JOIN category_sub_menu_type c9_ ON p0_.id = c9_.category_id LEFT JOIN sub_menu_type s8_ ON s8_.id = c9_.sub_menu_type_id LEFT JOIN p_category_category p10_ ON p0_.id = p10_.category_sub_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'html' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'title' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'slug' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_.foreign_key = p0_.id WHERE p0_.is_active = ? AND p0_.id >= ? AND p0_.id <> ? AND p10_.category_super_id = ? AND s8_.id = ? AND p0_.category_type_id IN (?) ORDER BY p10_.sequence ASC, p0_.sequence ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  COALESCE(t1_.content, p0_.name) AS name_1,
  COALESCE(t2_.content, p0_.menu_name) AS menu_name_2,
  COALESCE(t3_.content, p0_.description) AS description_3,
  COALESCE(t4_.content, p0_.html) AS html_4,
  COALESCE(t5_.content, p0_.title) AS title_5,
  p0_.is_active AS is_active_6,
  COALESCE(t6_.content, 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,
  u7_.id AS id_18,
  u7_.name AS name_19,
  u7_.extension AS extension_20,
  u7_.mime AS mime_21,
  u7_.title AS title_22,
  u7_.short_description AS short_description_23,
  u7_.description AS description_24,
  u7_.created AS created_25,
  u7_.path AS path_26,
  u7_.original_name AS original_name_27,
  u7_.width AS width_28,
  u7_.height AS height_29,
  u7_.sequence AS sequence_30,
  u7_.restriction AS restriction_31,
  p0_.category_type_id AS category_type_id_32,
  p0_.upload_id AS upload_id_33,
  u7_.upload_group_id AS upload_group_id_34,
  u7_.upload_type_id AS upload_type_id_35
FROM
  p_category p0_
  LEFT JOIN upload u7_ ON p0_.upload_id = u7_.id
  LEFT JOIN category_sub_menu_type c9_ ON p0_.id = c9_.category_id
  LEFT JOIN sub_menu_type s8_ ON s8_.id = c9_.sub_menu_type_id
  LEFT JOIN p_category_category p10_ ON p0_.id = p10_.category_sub_id
  LEFT JOIN ext_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'name'
  AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t1_.foreign_key = p0_.id
  LEFT JOIN ext_translations t2_ ON t2_.locale = 'en'
  AND t2_.field = 'menu_name'
  AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t2_.foreign_key = p0_.id
  LEFT JOIN ext_translations t3_ ON t3_.locale = 'en'
  AND t3_.field = 'description'
  AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t3_.foreign_key = p0_.id
  LEFT JOIN ext_translations t4_ ON t4_.locale = 'en'
  AND t4_.field = 'html'
  AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t4_.foreign_key = p0_.id
  LEFT JOIN ext_translations t5_ ON t5_.locale = 'en'
  AND t5_.field = 'title'
  AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t5_.foreign_key = p0_.id
  LEFT JOIN ext_translations t6_ ON t6_.locale = 'en'
  AND t6_.field = 'slug'
  AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t6_.foreign_key = p0_.id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p0_.id <> ?
  AND p10_.category_super_id = ?
  AND s8_.id = ?
  AND p0_.category_type_id IN (?)
ORDER BY
  p10_.sequence ASC,
  p0_.sequence ASC

SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.html) AS html_4, COALESCE(t5_.content, p0_.title) AS title_5, p0_.is_active AS is_active_6, COALESCE(t6_.content, 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, u7_.id AS id_18, u7_.name AS name_19, u7_.extension AS extension_20, u7_.mime AS mime_21, u7_.title AS title_22, u7_.short_description AS short_description_23, u7_.description AS description_24, u7_.created AS created_25, u7_.path AS path_26, u7_.original_name AS original_name_27, u7_.width AS width_28, u7_.height AS height_29, u7_.sequence AS sequence_30, u7_.restriction AS restriction_31, p0_.category_type_id AS category_type_id_32, p0_.upload_id AS upload_id_33, u7_.upload_group_id AS upload_group_id_34, u7_.upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u7_ ON p0_.upload_id = u7_.id LEFT JOIN category_sub_menu_type c9_ ON p0_.id = c9_.category_id LEFT JOIN sub_menu_type s8_ ON s8_.id = c9_.sub_menu_type_id LEFT JOIN p_category_category p10_ ON p0_.id = p10_.category_sub_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'html' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'title' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'slug' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_.foreign_key = p0_.id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p0_.id <> 2141 AND p10_.category_super_id = 2141 AND s8_.id = 1 AND p0_.category_type_id IN (2) ORDER BY p10_.sequence ASC, p0_.sequence ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Greendot\EshopBundle\Repository\Project\CategoryRepository->findSubMenuCategories (line 196)
7	App\Controller\Web\MenuController->generateProductsSubMenu (line 57)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_75c66d03ea1db351101e24f2ac6e79f2->doDisplay (line 116)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
32	__TwigTemplate_a6e6be744958c446ee67cde7f012519f->doDisplay (line 195)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_10c22825f6b7153f8f7394c155a5d33a->doDisplay (line 57)
35	Twig\Template->yield (line 402)
36	Twig\Template->display (line 358)
37	Twig\Template->render (line 373)
38	Twig\TemplateWrapper->render (line 51)
39	Twig\Environment->render (line 333)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
43	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 102)
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)

34.13 ms
(1.16%)

SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.html) AS html_4, COALESCE(t5_.content, p0_.title) AS title_5, p0_.is_active AS is_active_6, COALESCE(t6_.content, 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, u7_.id AS id_18, u7_.name AS name_19, u7_.extension AS extension_20, u7_.mime AS mime_21, u7_.title AS title_22, u7_.short_description AS short_description_23, u7_.description AS description_24, u7_.created AS created_25, u7_.path AS path_26, u7_.original_name AS original_name_27, u7_.width AS width_28, u7_.height AS height_29, u7_.sequence AS sequence_30, u7_.restriction AS restriction_31, p0_.category_type_id AS category_type_id_32, p0_.upload_id AS upload_id_33, u7_.upload_group_id AS upload_group_id_34, u7_.upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u7_ ON p0_.upload_id = u7_.id LEFT JOIN category_sub_menu_type c9_ ON p0_.id = c9_.category_id LEFT JOIN sub_menu_type s8_ ON s8_.id = c9_.sub_menu_type_id LEFT JOIN p_category_category p10_ ON p0_.id = p10_.category_sub_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'html' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'title' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'slug' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_.foreign_key = p0_.id WHERE p0_.is_active = ? AND p0_.id >= ? AND p0_.id <> ? AND p10_.category_super_id = ? AND s8_.id = ? AND p0_.category_type_id NOT IN (?) ORDER BY p10_.sequence ASC, p0_.sequence ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  COALESCE(t1_.content, p0_.name) AS name_1,
  COALESCE(t2_.content, p0_.menu_name) AS menu_name_2,
  COALESCE(t3_.content, p0_.description) AS description_3,
  COALESCE(t4_.content, p0_.html) AS html_4,
  COALESCE(t5_.content, p0_.title) AS title_5,
  p0_.is_active AS is_active_6,
  COALESCE(t6_.content, 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,
  u7_.id AS id_18,
  u7_.name AS name_19,
  u7_.extension AS extension_20,
  u7_.mime AS mime_21,
  u7_.title AS title_22,
  u7_.short_description AS short_description_23,
  u7_.description AS description_24,
  u7_.created AS created_25,
  u7_.path AS path_26,
  u7_.original_name AS original_name_27,
  u7_.width AS width_28,
  u7_.height AS height_29,
  u7_.sequence AS sequence_30,
  u7_.restriction AS restriction_31,
  p0_.category_type_id AS category_type_id_32,
  p0_.upload_id AS upload_id_33,
  u7_.upload_group_id AS upload_group_id_34,
  u7_.upload_type_id AS upload_type_id_35
FROM
  p_category p0_
  LEFT JOIN upload u7_ ON p0_.upload_id = u7_.id
  LEFT JOIN category_sub_menu_type c9_ ON p0_.id = c9_.category_id
  LEFT JOIN sub_menu_type s8_ ON s8_.id = c9_.sub_menu_type_id
  LEFT JOIN p_category_category p10_ ON p0_.id = p10_.category_sub_id
  LEFT JOIN ext_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'name'
  AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t1_.foreign_key = p0_.id
  LEFT JOIN ext_translations t2_ ON t2_.locale = 'en'
  AND t2_.field = 'menu_name'
  AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t2_.foreign_key = p0_.id
  LEFT JOIN ext_translations t3_ ON t3_.locale = 'en'
  AND t3_.field = 'description'
  AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t3_.foreign_key = p0_.id
  LEFT JOIN ext_translations t4_ ON t4_.locale = 'en'
  AND t4_.field = 'html'
  AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t4_.foreign_key = p0_.id
  LEFT JOIN ext_translations t5_ ON t5_.locale = 'en'
  AND t5_.field = 'title'
  AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t5_.foreign_key = p0_.id
  LEFT JOIN ext_translations t6_ ON t6_.locale = 'en'
  AND t6_.field = 'slug'
  AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t6_.foreign_key = p0_.id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p0_.id <> ?
  AND p10_.category_super_id = ?
  AND s8_.id = ?
  AND p0_.category_type_id NOT IN (?)
ORDER BY
  p10_.sequence ASC,
  p0_.sequence ASC

SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.html) AS html_4, COALESCE(t5_.content, p0_.title) AS title_5, p0_.is_active AS is_active_6, COALESCE(t6_.content, 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, u7_.id AS id_18, u7_.name AS name_19, u7_.extension AS extension_20, u7_.mime AS mime_21, u7_.title AS title_22, u7_.short_description AS short_description_23, u7_.description AS description_24, u7_.created AS created_25, u7_.path AS path_26, u7_.original_name AS original_name_27, u7_.width AS width_28, u7_.height AS height_29, u7_.sequence AS sequence_30, u7_.restriction AS restriction_31, p0_.category_type_id AS category_type_id_32, p0_.upload_id AS upload_id_33, u7_.upload_group_id AS upload_group_id_34, u7_.upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u7_ ON p0_.upload_id = u7_.id LEFT JOIN category_sub_menu_type c9_ ON p0_.id = c9_.category_id LEFT JOIN sub_menu_type s8_ ON s8_.id = c9_.sub_menu_type_id LEFT JOIN p_category_category p10_ ON p0_.id = p10_.category_sub_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'html' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'title' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'slug' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_.foreign_key = p0_.id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p0_.id <> 2141 AND p10_.category_super_id = 2141 AND s8_.id = 1 AND p0_.category_type_id NOT IN (2) ORDER BY p10_.sequence ASC, p0_.sequence ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Greendot\EshopBundle\Repository\Project\CategoryRepository->findSubMenuCategories (line 196)
7	App\Controller\Web\MenuController->generateProductsSubMenu (line 58)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_75c66d03ea1db351101e24f2ac6e79f2->doDisplay (line 116)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
32	__TwigTemplate_a6e6be744958c446ee67cde7f012519f->doDisplay (line 195)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_10c22825f6b7153f8f7394c155a5d33a->doDisplay (line 57)
35	Twig\Template->yield (line 402)
36	Twig\Template->display (line 358)
37	Twig\Template->render (line 373)
38	Twig\TemplateWrapper->render (line 51)
39	Twig\Environment->render (line 333)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
43	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 102)
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)

4.74 ms
(0.16%)

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

Parameters:

[
  "20"
  "en"
  "Greendot\EshopBundle\Entity\Project\Label"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '20' AND e0_.locale = 'en' AND e0_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Label';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 105)
7	Gedmo\Translatable\TranslatableListener->postLoad (line 529)
8	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
12	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
14	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 967)
15	Doctrine\ORM\EntityRepository->findBy (line 110)
16	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
17	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 99)
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)

0.85 ms
(0.03%)

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_a6e6be744958c446ee67cde7f012519f->doDisplay (line 180)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_10c22825f6b7153f8f7394c155a5d33a->doDisplay (line 57)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
29	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 102)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 5)

0.42 ms
(0.01%)

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 99)
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.36 ms
(0.01%)

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

Parameters:

[
  2141
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_75c66d03ea1db351101e24f2ac6e79f2::doDisplay (line 57)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
18	Greendot\EshopBundle\Controller\Web\MenuController->generateMenu (line 25)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
26	__TwigTemplate_a6e6be744958c446ee67cde7f012519f->doDisplay (line 195)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_10c22825f6b7153f8f7394c155a5d33a->doDisplay (line 57)
29	Twig\Template->yield (line 402)
30	Twig\Template->display (line 358)
31	Twig\Template->render (line 373)
32	Twig\TemplateWrapper->render (line 51)
33	Twig\Environment->render (line 333)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
37	Greendot\EshopBundle\Controller\Web\BlogController->blogDetail (line 102)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Component\HttpKernel\Kernel->handle (line 193)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
42	require_once (line 29)
43	require_once (line 5)

0.31 ms
(0.01%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2, c0_.rounding AS rounding_3, c0_.is_default AS is_default_4, c0_.default_locale AS default_locale_5, c0_.is_symbol_left AS is_symbol_left_6, c0_.is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_.default_locale = ? LIMIT 1

Parameters:

[
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.symbol AS symbol_2,
  c0_.rounding AS rounding_3,
  c0_.is_default AS is_default_4,
  c0_.default_locale AS default_locale_5,
  c0_.is_symbol_left AS is_symbol_left_6,
  c0_.is_deleted AS is_deleted_7
FROM
  currency c0_
WHERE
  c0_.default_locale = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2, c0_.rounding AS rounding_3, c0_.is_default AS is_default_4, c0_.default_locale AS default_locale_5, c0_.is_symbol_left AS is_symbol_left_6, c0_.is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_.default_locale = 'en' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Greendot\EshopBundle\Repository\Project\CurrencyRepository->findCurrencyByLocale (line 31)
7	Greendot\EshopBundle\Service\CurrencyManager->setByLocale (line 70)
8	Greendot\EshopBundle\Service\CurrencyManager->setLocale (line 96)
9	Symfony\Component\Translation\LocaleSwitcher->setLocale (line 49)
10	Symfony\Component\HttpKernel\EventListener\LocaleAwareListener->setLocale (line 68)
11	Symfony\Component\HttpKernel\EventListener\LocaleAwareListener->onKernelRequest (line 39)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.30 ms
(0.01%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.category_type_id AS category_type_id_19, t0.upload_id AS upload_id_20 FROM p_category t0 WHERE t0.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.category_type_id AS category_type_id_19,
  t0.upload_id AS upload_id_20
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.category_type_id AS category_type_id_19, t0.upload_id AS upload_id_20 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 100)
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.27 ms
(0.01%)

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 34)
9	ContainerKGzEc4C\App_KernelDevDebugContainer->getProductVariantPriceFactoryService (line 2110)
10	ContainerKGzEc4C\App_KernelDevDebugContainer::getPurchasePriceFactoryService (line 2126)
11	ContainerKGzEc4C\App_KernelDevDebugContainer::getAffiliateServiceService (line 1929)
12	ContainerKGzEc4C\App_KernelDevDebugContainer::getBeforeControllerListenerService (line 1614)
13	ContainerKGzEc4C\App_KernelDevDebugContainer::ContainerKGzEc4C\{closure} (line 1327)
14	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 221)
15	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 256)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 120)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.20 ms
(0.01%)

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.rounding AS rounding_4, t0.is_default AS is_default_5, t0.default_locale AS default_locale_6, t0.is_symbol_left AS is_symbol_left_7, t0.is_deleted AS is_deleted_8 FROM currency t0 WHERE t0.is_default = 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	Greendot\EshopBundle\Service\CurrencyManager->setByLocale (line 73)
5	Greendot\EshopBundle\Service\CurrencyManager->setLocale (line 96)
6	Symfony\Component\Translation\LocaleSwitcher->setLocale (line 49)
7	Symfony\Component\HttpKernel\EventListener\LocaleAwareListener->setLocale (line 68)
8	Symfony\Component\HttpKernel\EventListener\LocaleAwareListener->onKernelRequest (line 39)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	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	31
Greendot\EshopBundle\Entity\Project\Upload	19
Greendot\EshopBundle\Entity\Project\UploadGroup	15
Greendot\EshopBundle\Entity\Project\Label	7
Greendot\EshopBundle\Entity\Project\CategoryType	5
Greendot\EshopBundle\Entity\Project\MenuType	2
Greendot\EshopBundle\Entity\Project\Currency	1
Greendot\EshopBundle\Entity\Project\LabelType	1
Greendot\EshopBundle\Entity\Project\SubMenuType	1

Entities Mapping

Class	Mapping errors
Greendot\EshopBundle\Entity\Project\Currency	No errors.
Greendot\EshopBundle\Entity\Project\ConversionRate	No errors.
Greendot\EshopBundle\Entity\Project\Settings	No 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\Product	No errors.
Greendot\EshopBundle\Entity\Project\MenuType	No errors.
Greendot\EshopBundle\Entity\Project\UploadGroup	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\File	No errors.
Greendot\EshopBundle\Entity\Project\ParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\Client	No errors.
Greendot\EshopBundle\Entity\Project\Event	No errors.
Greendot\EshopBundle\Entity\Project\Review	No errors.
Greendot\EshopBundle\Entity\Project\ProductUploadGroup	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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping