Symfony Profiler

Query Metrics

53 Database Queries

6 Different statements

34.47 ms Query time

0 Invalid entities

53 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

27.20 ms
(78.89%)

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)

Parameters:

[
  1
  b"\x01š]cÌ%~Ž¹þ\x1E\e\x1D/áf"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  course_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019A5D63CC257E8DB9FE1E1B1D2FE166);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCriteria (line 888)
2	Doctrine\ORM\PersistentCollection->matching (line 610)
3	App\Entity\Education\Category\Category->getSubcategories (line 106)
4	App\Twig\Runtime\AppCourseCategoryTreeExtensionRuntime->loadCategoryHierarchy (line 30)
5	__TwigTemplate_fa87a9b655986bcfdc31b56684897e8b->{closure} (line 167)
6	Twig\Extension\CoreExtension->captureOutput (line 2110)
7	__TwigTemplate_fa87a9b655986bcfdc31b56684897e8b::macro_renderMegaMenu (line 122)
8	__TwigTemplate_a9bd57205075defe592e6ca1128aa44f->doDisplay (line 258)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 118)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_4722ed89106ee067de6d3b5c332b0a4c->doDisplay (line 58)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\UniqskillsAbstractController->render (line 38)
22	App\Controller\Web\Education\CourseLandingPageController->index (line 35)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

3.47 ms
(10.06%)

SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.is_continuous AS is_continuous_2, c0_.is_medical_product AS is_medical_product_3, c0_.position AS position_4, c0_.name AS name_5, c0_.slug AS slug_6, c0_.short_body AS short_body_7, c0_.difficulty AS difficulty_8, c0_.start_date AS start_date_9, c0_.hide_date AS hide_date_10, c0_.deactivation_date AS deactivation_date_11, c0_.duration AS duration_12, c0_.action_number AS action_number_13, c0_.from_source AS from_source_14, c0_.products_for_cos AS products_for_cos_15, c0_.redirect_to_url AS redirect_to_url_16, c0_.gos_id AS gos_id_17, c0_.certificate_gos_id AS certificate_gos_id_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.seo_keywords AS seo_keywords_21, c0_.seo_meta_title AS seo_meta_title_22, c0_.seo_meta_description AS seo_meta_description_23, c0_.seo_is_no_index AS seo_is_no_index_24, c0_.beacon_name AS beacon_name_25, c0_.type AS type_26, c0_.category_id AS category_id_27, c0_.image_id AS image_id_28, c0_.created_by_id AS created_by_id_29, c0_.updated_by_id AS updated_by_id_30 FROM course c0_ WHERE (c0_.slug = ?) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front') LIMIT 1

Parameters:

[
  "endometrioza-nowoczesna-diagnostyka-i-leczenie"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.is_active AS is_active_1,
  c0_.is_continuous AS is_continuous_2,
  c0_.is_medical_product AS is_medical_product_3,
  c0_.position AS position_4,
  c0_.name AS name_5,
  c0_.slug AS slug_6,
  c0_.short_body AS short_body_7,
  c0_.difficulty AS difficulty_8,
  c0_.start_date AS start_date_9,
  c0_.hide_date AS hide_date_10,
  c0_.deactivation_date AS deactivation_date_11,
  c0_.duration AS duration_12,
  c0_.action_number AS action_number_13,
  c0_.from_source AS from_source_14,
  c0_.products_for_cos AS products_for_cos_15,
  c0_.redirect_to_url AS redirect_to_url_16,
  c0_.gos_id AS gos_id_17,
  c0_.certificate_gos_id AS certificate_gos_id_18,
  c0_.created_at AS created_at_19,
  c0_.updated_at AS updated_at_20,
  c0_.seo_keywords AS seo_keywords_21,
  c0_.seo_meta_title AS seo_meta_title_22,
  c0_.seo_meta_description AS seo_meta_description_23,
  c0_.seo_is_no_index AS seo_is_no_index_24,
  c0_.beacon_name AS beacon_name_25,
  c0_.type AS type_26,
  c0_.category_id AS category_id_27,
  c0_.image_id AS image_id_28,
  c0_.created_by_id AS created_by_id_29,
  c0_.updated_by_id AS updated_by_id_30
FROM
  course c0_
WHERE
  (c0_.slug = ?)
  AND c0_.type IN (
    'academy', 'future_degree', 'webinar',
    'no_front'
  )
LIMIT
  1

SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.is_continuous AS is_continuous_2, c0_.is_medical_product AS is_medical_product_3, c0_.position AS position_4, c0_.name AS name_5, c0_.slug AS slug_6, c0_.short_body AS short_body_7, c0_.difficulty AS difficulty_8, c0_.start_date AS start_date_9, c0_.hide_date AS hide_date_10, c0_.deactivation_date AS deactivation_date_11, c0_.duration AS duration_12, c0_.action_number AS action_number_13, c0_.from_source AS from_source_14, c0_.products_for_cos AS products_for_cos_15, c0_.redirect_to_url AS redirect_to_url_16, c0_.gos_id AS gos_id_17, c0_.certificate_gos_id AS certificate_gos_id_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.seo_keywords AS seo_keywords_21, c0_.seo_meta_title AS seo_meta_title_22, c0_.seo_meta_description AS seo_meta_description_23, c0_.seo_is_no_index AS seo_is_no_index_24, c0_.beacon_name AS beacon_name_25, c0_.type AS type_26, c0_.category_id AS category_id_27, c0_.image_id AS image_id_28, c0_.created_by_id AS created_by_id_29, c0_.updated_by_id AS updated_by_id_30 FROM course c0_ WHERE (c0_.slug = 'endometrioza-nowoczesna-diagnostyka-i-leczenie') AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front') 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\Education\Course\CourseRepository->findOneBySlug (line 193)
7	App\Request\ParamConverter\CourseParamConverter->resolve (line 34)
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 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

1.78 ms
(5.17%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.gos_id AS gos_id_4, t0.is_visible AS is_visible_5, t0.is_optional AS is_optional_6, t0.minimum_score AS minimum_score_7, t0.good_answer_points AS good_answer_points_8, t0.wrong_answer_points AS wrong_answer_points_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.course_id AS course_id_14, t0.type FROM test t0 WHERE t0.course_id = ? AND t0.type IN ('course')

Parameters:

[
  b"\x01œæ£<ù|-˜`÷>ù\x16\x02J"
]

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.gos_id AS gos_id_4,
  t0.is_visible AS is_visible_5,
  t0.is_optional AS is_optional_6,
  t0.minimum_score AS minimum_score_7,
  t0.good_answer_points AS good_answer_points_8,
  t0.wrong_answer_points AS wrong_answer_points_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13,
  t0.course_id AS course_id_14,
  t0.type
FROM
  test t0
WHERE
  t0.course_id = ?
  AND t0.type IN ('course')

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.gos_id AS gos_id_4, t0.is_visible AS is_visible_5, t0.is_optional AS is_optional_6, t0.minimum_score AS minimum_score_7, t0.good_answer_points AS good_answer_points_8, t0.wrong_answer_points AS wrong_answer_points_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.course_id AS course_id_14, t0.type FROM test t0 WHERE t0.course_id = 0x019CE6A33CF97C2D9860F73EF916024A AND t0.type IN ('course');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Repository\Education\Course\CourseRepository->findOneBySlug (line 193)
12	App\Request\ParamConverter\CourseParamConverter->resolve (line 34)
13	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
14	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
15	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.84 ms
(2.42%)

SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.icon AS icon_4, c0_.color AS color_5, c0_.short_body AS short_body_6, c0_.body AS body_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.image_id AS image_id_10, c0_.desktop_banner_id AS desktop_banner_id_11, c0_.mobile_banner_id AS mobile_banner_id_12, c0_.created_by_id AS created_by_id_13, c0_.updated_by_id AS updated_by_id_14, c0_.parent_id AS parent_id_15 FROM course_category c0_ WHERE c0_.parent_id IS NULL AND c0_.is_active = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.is_active AS is_active_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.icon AS icon_4,
  c0_.color AS color_5,
  c0_.short_body AS short_body_6,
  c0_.body AS body_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.image_id AS image_id_10,
  c0_.desktop_banner_id AS desktop_banner_id_11,
  c0_.mobile_banner_id AS mobile_banner_id_12,
  c0_.created_by_id AS created_by_id_13,
  c0_.updated_by_id AS updated_by_id_14,
  c0_.parent_id AS parent_id_15
FROM
  course_category c0_
WHERE
  c0_.parent_id IS NULL
  AND c0_.is_active = 1

SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.icon AS icon_4, c0_.color AS color_5, c0_.short_body AS short_body_6, c0_.body AS body_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.image_id AS image_id_10, c0_.desktop_banner_id AS desktop_banner_id_11, c0_.mobile_banner_id AS mobile_banner_id_12, c0_.created_by_id AS created_by_id_13, c0_.updated_by_id AS updated_by_id_14, c0_.parent_id AS parent_id_15 FROM course_category c0_ WHERE c0_.parent_id IS NULL AND c0_.is_active = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Education\Category\CategoryRepository->findMainCategories (line 30)
7	App\Twig\Runtime\AppCourseCategoryTreeExtensionRuntime->loadCategoryHierarchy (line 18)
8	__TwigTemplate_fa87a9b655986bcfdc31b56684897e8b->{closure} (line 167)
9	Twig\Extension\CoreExtension->captureOutput (line 2110)
10	__TwigTemplate_fa87a9b655986bcfdc31b56684897e8b::macro_renderMegaMenu (line 122)
11	__TwigTemplate_a9bd57205075defe592e6ca1128aa44f->doDisplay (line 258)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 118)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_4722ed89106ee067de6d3b5c332b0a4c->doDisplay (line 58)
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	App\Controller\UniqskillsAbstractController->render (line 38)
25	App\Controller\Web\Education\CourseLandingPageController->index (line 35)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.65 ms
(1.88%)

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)

Parameters:

[
  1
  b"\x01œûÁ"\vuä¶\x18íyw\x0E`"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  article_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019CFBC1220B75E4B61881ED79770E60);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCriteria (line 888)
2	Doctrine\ORM\PersistentCollection->matching (line 610)
3	App\Entity\KnowledgeBase\Category\Category->getSubcategories (line 83)
4	App\Twig\Runtime\AppKnowledgeBaseCategoryTreeExtensionRuntime->loadCategoryHierarchy (line 30)
5	__TwigTemplate_fa87a9b655986bcfdc31b56684897e8b->{closure} (line 173)
6	Twig\Extension\CoreExtension->captureOutput (line 2110)
7	__TwigTemplate_fa87a9b655986bcfdc31b56684897e8b::macro_renderMegaMenu (line 122)
8	__TwigTemplate_a9bd57205075defe592e6ca1128aa44f->doDisplay (line 262)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 118)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_4722ed89106ee067de6d3b5c332b0a4c->doDisplay (line 58)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\UniqskillsAbstractController->render (line 38)
22	App\Controller\Web\Education\CourseLandingPageController->index (line 35)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.54 ms
(1.58%)

SELECT a0_.id AS id_0, a0_.is_active AS is_active_1, a0_.name AS name_2, a0_.slug AS slug_3, a0_.icon AS icon_4, a0_.color AS color_5, a0_.short_body AS short_body_6, a0_.body AS body_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.image_id AS image_id_10, a0_.desktop_banner_id AS desktop_banner_id_11, a0_.mobile_banner_id AS mobile_banner_id_12, a0_.created_by_id AS created_by_id_13, a0_.updated_by_id AS updated_by_id_14, a0_.parent_id AS parent_id_15 FROM article_category a0_ WHERE a0_.parent_id IS NULL AND a0_.is_active = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.is_active AS is_active_1,
  a0_.name AS name_2,
  a0_.slug AS slug_3,
  a0_.icon AS icon_4,
  a0_.color AS color_5,
  a0_.short_body AS short_body_6,
  a0_.body AS body_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.image_id AS image_id_10,
  a0_.desktop_banner_id AS desktop_banner_id_11,
  a0_.mobile_banner_id AS mobile_banner_id_12,
  a0_.created_by_id AS created_by_id_13,
  a0_.updated_by_id AS updated_by_id_14,
  a0_.parent_id AS parent_id_15
FROM
  article_category a0_
WHERE
  a0_.parent_id IS NULL
  AND a0_.is_active = 1

SELECT a0_.id AS id_0, a0_.is_active AS is_active_1, a0_.name AS name_2, a0_.slug AS slug_3, a0_.icon AS icon_4, a0_.color AS color_5, a0_.short_body AS short_body_6, a0_.body AS body_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.image_id AS image_id_10, a0_.desktop_banner_id AS desktop_banner_id_11, a0_.mobile_banner_id AS mobile_banner_id_12, a0_.created_by_id AS created_by_id_13, a0_.updated_by_id AS updated_by_id_14, a0_.parent_id AS parent_id_15 FROM article_category a0_ WHERE a0_.parent_id IS NULL AND a0_.is_active = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\KnowledgeBase\Category\CategoryRepository->findMainCategories (line 29)
7	App\Twig\Runtime\AppKnowledgeBaseCategoryTreeExtensionRuntime->loadCategoryHierarchy (line 18)
8	__TwigTemplate_fa87a9b655986bcfdc31b56684897e8b->{closure} (line 173)
9	Twig\Extension\CoreExtension->captureOutput (line 2110)
10	__TwigTemplate_fa87a9b655986bcfdc31b56684897e8b::macro_renderMegaMenu (line 122)
11	__TwigTemplate_a9bd57205075defe592e6ca1128aa44f->doDisplay (line 262)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 118)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_4722ed89106ee067de6d3b5c332b0a4c->doDisplay (line 58)
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	App\Controller\UniqskillsAbstractController->render (line 38)
25	App\Controller\Web\Education\CourseLandingPageController->index (line 35)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
gos	doctrine.dbal.gos_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
gos	doctrine.orm.gos_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Education\Category\Category	48
App\Entity\User\User	2
App\Entity\Education\Course\Course	1
App\Entity\Education\Course\CourseImage	1
App\Entity\KnowledgeBase\Category\Category	1

gos entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Seo\Seo	No errors.
App\Entity\Education\Course\Course	No errors.
App\Entity\Education\Course\AcademyCourse	No errors.
App\Entity\Education\Course\FutureDegreeCourse	No errors.
App\Entity\Education\Course\WebinarCourse	No errors.
App\Entity\Education\Course\NoFrontCourse	No errors.
App\Entity\Category\BaseCategory	No errors.
App\Entity\Education\Category\Category	No errors.
App\Entity\File\File	No errors.
App\Entity\File\ImageFile	No errors.
App\Entity\Education\Course\CourseImage	No errors.
App\Entity\User\User	No errors.
App\Entity\User\Admin	No errors.
App\Entity\Education\Module\Module	No errors.
App\Entity\Education\CourseLandingSection\CourseLandingSection	No errors.
App\Entity\Partner\Partner	No errors.
App\Entity\Education\Test\Test	No errors.
App\Entity\Education\Test\CourseTest	No errors.
App\Entity\Education\Course\UserCourse	No errors.
App\Entity\Access\BaseAccess	No errors.
App\Entity\Education\Course\CourseAccess	No errors.
App\Entity\Education\Course\Price\CoursePrice	No errors.
App\Entity\Category\CategoryImage	No errors.
App\Entity\Category\CategoryDesktopBanner	No errors.
App\Entity\Category\CategoryMobileBanner	No errors.
App\Entity\KnowledgeBase\Category\Category	No errors.
App\Entity\KnowledgeBase\Article\Article	No errors.

gos entity manager

No loaded entities.

Symfony Profiler

GET https://2.uniqskills.com/pl/kursy/medycyna/ginekologia/endometrioza-nowoczesna-diagnostyka-i-leczenie

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

gos entity manager

Entities Mapping

default entity manager

gos entity manager