Symfony Profiler

Query Metrics

83 Database Queries

16 Different statements

57.14 ms Query time

0 Invalid entities

72 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

30.43 ms
(53.26%)

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_08ca484fd2a8886bd68fbd912cc2733e->doDisplay (line 58)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_c68a71f7376a0f523984281cc424d8e6->doDisplay (line 53)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\UniqskillsAbstractController->render (line 38)
24	App\Controller\Web\KnowledgeBase\ArticleController->index (line 36)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

5.96 ms
(10.42%)

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.module_id AS module_id_14, t0.type FROM test t0 WHERE t0.module_id = ? AND t0.type IN ('module')

Parameters:

[
  b"\x01œÿÎdS{½œ·Cn\vK¦È"
]

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.module_id AS module_id_14,
  t0.type
FROM
  test t0
WHERE
  t0.module_id = ?
  AND t0.type IN ('module')

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.module_id AS module_id_14, t0.type FROM test t0 WHERE t0.module_id = 0x019CFFCE64537BBD9CB7436E0B4BA6C8 AND t0.type IN ('module');

#	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\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1026)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1819)
10	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
11	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
12	Doctrine\ORM\PersistentCollection->initialize (line 186)
13	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
14	Doctrine\ORM\PersistentCollection->count (line 391)
15	Twig\Extension\CoreExtension->length (line 1272)
16	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e::{closure} (line 549)
17	Twig\Extension\CoreExtension->captureOutput (line 2110)
18	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e::macro_popularCourse (line 509)
19	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e->block_page (line 413)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e->doDisplay (line 58)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_c68a71f7376a0f523984281cc424d8e6->doDisplay (line 53)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
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	App\Controller\UniqskillsAbstractController->render (line 38)
35	App\Controller\Web\KnowledgeBase\ArticleController->index (line 36)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 182)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 32)
41	require_once (line 5)

3.21 ms
(5.62%)

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.position AS position_3, t0.name AS name_4, t0.slug AS slug_5, t0.short_body AS short_body_6, t0.all_lessons_available AS all_lessons_available_7, t0.start_date AS start_date_8, t0.gos_id AS gos_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.course_id AS course_id_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14 FROM module t0 WHERE t0.course_id = ? ORDER BY t0.position ASC

Parameters:

[
  b"\x01œÿÎP!v¹°sž\x1AòóA‘"
]

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.position AS position_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.short_body AS short_body_6,
  t0.all_lessons_available AS all_lessons_available_7,
  t0.start_date AS start_date_8,
  t0.gos_id AS gos_id_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.course_id AS course_id_12,
  t0.created_by_id AS created_by_id_13,
  t0.updated_by_id AS updated_by_id_14
FROM
  module t0
WHERE
  t0.course_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.position AS position_3, t0.name AS name_4, t0.slug AS slug_5, t0.short_body AS short_body_6, t0.all_lessons_available AS all_lessons_available_7, t0.start_date AS start_date_8, t0.gos_id AS gos_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.course_id AS course_id_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14 FROM module t0 WHERE t0.course_id = 0x019CFFCE502176B9B0739E1AF2F34191 ORDER BY t0.position 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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e::{closure} (line 549)
10	Twig\Extension\CoreExtension->captureOutput (line 2110)
11	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e::macro_popularCourse (line 509)
12	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e->block_page (line 413)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e->doDisplay (line 58)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_c68a71f7376a0f523984281cc424d8e6->doDisplay (line 53)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
27	App\Controller\UniqskillsAbstractController->render (line 38)
28	App\Controller\Web\KnowledgeBase\ArticleController->index (line 36)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

2.76 ms
(4.84%)

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_.is_active = ? OR (c0_.is_active = ? AND c0_.hide_date > ?)) AND c0_.type IN ('future_degree') ORDER BY c0_.created_at DESC LIMIT 4

Parameters:

[
  1
  0
  "2026-03-30 18:54:29"
]

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_.is_active = ?
    OR (
      c0_.is_active = ?
      AND c0_.hide_date > ?
    )
  )
  AND c0_.type IN ('future_degree')
ORDER BY
  c0_.created_at DESC
LIMIT
  4

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_.is_active = 1 OR (c0_.is_active = 0 AND c0_.hide_date > '2026-03-30 18:54:29')) AND c0_.type IN ('future_degree') ORDER BY c0_.created_at DESC LIMIT 4;

#	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\Course\FutureDegreeCourseRepository->findNewestInCategory (line 50)
7	App\Services\Education\Course\PopularCoursesService->getPopularCourses (line 21)
8	App\Controller\Web\KnowledgeBase\ArticleController->index (line 31)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

2.60 ms
(4.55%)

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*v²|u\x12›n\x7FX\x0FÝ\x7F("
]

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 = 0x019D2A76B27C75129B6E7F580FDD7F28 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->getResult (line 688)
11	App\Repository\Education\Course\FutureDegreeCourseRepository->findNewestInCategory (line 50)
12	App\Services\Education\Course\PopularCoursesService->getPopularCourses (line 21)
13	App\Controller\Web\KnowledgeBase\ArticleController->index (line 31)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

2.31 ms
(4.04%)

SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.size AS size_3, t0.mime_type AS mime_type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dimensions AS dimensions_7, t0.id AS id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM course_image t0 WHERE t0.id = ?

Parameters:

[
  b"\x01\v¯xUwÌ§qS\f.‘ª¢"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.original_name AS original_name_2,
  t0.size AS size_3,
  t0.mime_type AS mime_type_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.dimensions AS dimensions_7,
  t0.id AS id_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10
FROM
  course_image t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.size AS size_3, t0.mime_type AS mime_type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dimensions AS dimensions_7, t0.id AS id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM course_image t0 WHERE t0.id = 0x019D0BAF785577CCA771530C2E91AAA2;

#	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__\App\Entity\Education\Course\CourseImage::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Education\Course\CourseImage->initializeLazyObject (line 106)
7	Proxies\__CG__\App\Entity\Education\Course\CourseImage->__load (line 20)
8	Vich\UploaderBundle\Mapping\PropertyMappingFactory->fromField (line 79)
9	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 144)
10	Vich\UploaderBundle\Storage\FileSystemStorage->resolveUri (line 68)
11	Vich\UploaderBundle\Templating\Helper\UploaderHelper->asset (line 35)
12	Vich\UploaderBundle\Twig\Extension\UploaderExtensionRuntime->asset (line 28)
13	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e->{closure} (line 528)
14	Twig\Extension\CoreExtension->captureOutput (line 2110)
15	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e::macro_popularCourse (line 509)
16	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e->block_page (line 413)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e->doDisplay (line 58)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_c68a71f7376a0f523984281cc424d8e6->doDisplay (line 53)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
31	App\Controller\UniqskillsAbstractController->render (line 38)
32	App\Controller\Web\KnowledgeBase\ArticleController->index (line 36)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 182)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 32)
38	require_once (line 5)

2.27 ms
(3.97%)

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_08ca484fd2a8886bd68fbd912cc2733e->doDisplay (line 58)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_c68a71f7376a0f523984281cc424d8e6->doDisplay (line 53)
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	App\Controller\UniqskillsAbstractController->render (line 38)
27	App\Controller\Web\KnowledgeBase\ArticleController->index (line 36)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

1.13 ms
(1.98%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_is_no_index AS seo_is_no_index_13, a0_.description AS description_14, a0_.description AS description_15, a0_.lead AS lead_16, a0_.content AS content_17, a0_.video_url AS video_url_18, a0_.description AS description_19, a0_.type AS type_20, a0_.image_id AS image_id_21, a0_.created_by_id AS created_by_id_22, a0_.updated_by_id AS updated_by_id_23, a0_.audio_id AS audio_id_24, a0_.file_id AS file_id_25 FROM article a0_ WHERE (a0_.slug = ?) AND a0_.type IN ('audio', 'download', 'text', 'video') LIMIT 1

Parameters:

[
  "co-musi-zawierac-szkolenie-bhp-by-bylo-zgodne-z-prawem-i-jednoczesnie-zrozumiale-dla-pracownikow"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.is_active AS is_active_3,
  a0_.public_date AS public_date_4,
  a0_.deactivation_date AS deactivation_date_5,
  a0_.hide_date AS hide_date_6,
  a0_.redirect_to_url AS redirect_to_url_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.seo_keywords AS seo_keywords_10,
  a0_.seo_meta_title AS seo_meta_title_11,
  a0_.seo_meta_description AS seo_meta_description_12,
  a0_.seo_is_no_index AS seo_is_no_index_13,
  a0_.description AS description_14,
  a0_.description AS description_15,
  a0_.lead AS lead_16,
  a0_.content AS content_17,
  a0_.video_url AS video_url_18,
  a0_.description AS description_19,
  a0_.type AS type_20,
  a0_.image_id AS image_id_21,
  a0_.created_by_id AS created_by_id_22,
  a0_.updated_by_id AS updated_by_id_23,
  a0_.audio_id AS audio_id_24,
  a0_.file_id AS file_id_25
FROM
  article a0_
WHERE
  (a0_.slug = ?)
  AND a0_.type IN (
    'audio', 'download', 'text', 'video'
  )
LIMIT
  1

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_is_no_index AS seo_is_no_index_13, a0_.description AS description_14, a0_.description AS description_15, a0_.lead AS lead_16, a0_.content AS content_17, a0_.video_url AS video_url_18, a0_.description AS description_19, a0_.type AS type_20, a0_.image_id AS image_id_21, a0_.created_by_id AS created_by_id_22, a0_.updated_by_id AS updated_by_id_23, a0_.audio_id AS audio_id_24, a0_.file_id AS file_id_25 FROM article a0_ WHERE (a0_.slug = 'co-musi-zawierac-szkolenie-bhp-by-bylo-zgodne-z-prawem-i-jednoczesnie-zrozumiale-dla-pracownikow') AND a0_.type IN ('audio', 'download', 'text', 'video') 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\KnowledgeBase\Article\ArticleRepository->findOneBySlug (line 28)
7	App\Request\ParamConverter\ArticleParamConverter->resolve (line 35)
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.11 ms
(1.95%)

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_08ca484fd2a8886bd68fbd912cc2733e->doDisplay (line 58)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_c68a71f7376a0f523984281cc424d8e6->doDisplay (line 53)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\UniqskillsAbstractController->render (line 38)
24	App\Controller\Web\KnowledgeBase\ArticleController->index (line 36)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

1.00 ms
(1.74%)

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_08ca484fd2a8886bd68fbd912cc2733e->doDisplay (line 58)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_c68a71f7376a0f523984281cc424d8e6->doDisplay (line 53)
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	App\Controller\UniqskillsAbstractController->render (line 38)
27	App\Controller\Web\KnowledgeBase\ArticleController->index (line 36)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

0.93 ms
(1.63%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_is_no_index AS seo_is_no_index_13, a0_.description AS description_14, a0_.description AS description_15, a0_.lead AS lead_16, a0_.content AS content_17, a0_.video_url AS video_url_18, a0_.description AS description_19, a0_.type AS type_20, a0_.image_id AS image_id_21, a0_.created_by_id AS created_by_id_22, a0_.updated_by_id AS updated_by_id_23, a0_.audio_id AS audio_id_24, a0_.file_id AS file_id_25 FROM article a0_ INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id INNER JOIN article_category a1_ ON a1_.id = a2_.category_id WHERE (a0_.is_active = ? AND a1_.id NOT IN (?)) AND a0_.type IN ('audio', 'download', 'text', 'video') LIMIT 4

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.is_active AS is_active_3,
  a0_.public_date AS public_date_4,
  a0_.deactivation_date AS deactivation_date_5,
  a0_.hide_date AS hide_date_6,
  a0_.redirect_to_url AS redirect_to_url_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.seo_keywords AS seo_keywords_10,
  a0_.seo_meta_title AS seo_meta_title_11,
  a0_.seo_meta_description AS seo_meta_description_12,
  a0_.seo_is_no_index AS seo_is_no_index_13,
  a0_.description AS description_14,
  a0_.description AS description_15,
  a0_.lead AS lead_16,
  a0_.content AS content_17,
  a0_.video_url AS video_url_18,
  a0_.description AS description_19,
  a0_.type AS type_20,
  a0_.image_id AS image_id_21,
  a0_.created_by_id AS created_by_id_22,
  a0_.updated_by_id AS updated_by_id_23,
  a0_.audio_id AS audio_id_24,
  a0_.file_id AS file_id_25
FROM
  article a0_
  INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id
  INNER JOIN article_category a1_ ON a1_.id = a2_.category_id
WHERE
  (
    a0_.is_active = ?
    AND a1_.id NOT IN (?)
  )
  AND a0_.type IN (
    'audio', 'download', 'text', 'video'
  )
LIMIT
  4

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_is_no_index AS seo_is_no_index_13, a0_.description AS description_14, a0_.description AS description_15, a0_.lead AS lead_16, a0_.content AS content_17, a0_.video_url AS video_url_18, a0_.description AS description_19, a0_.type AS type_20, a0_.image_id AS image_id_21, a0_.created_by_id AS created_by_id_22, a0_.updated_by_id AS updated_by_id_23, a0_.audio_id AS audio_id_24, a0_.file_id AS file_id_25 FROM article a0_ INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id INNER JOIN article_category a1_ ON a1_.id = a2_.category_id WHERE (a0_.is_active = 1 AND a1_.id NOT IN (0x019CFBC1220B75E4B61881ED79770E60)) AND a0_.type IN ('audio', 'download', 'text', 'video') LIMIT 4;

#	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\Article\ArticleRepository->findRelated (line 89)
7	App\Services\KnowledgeBase\Article\RelatedArticlesService->getRelatedArticles (line 23)
8	App\Controller\Web\KnowledgeBase\ArticleController->index (line 32)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.83 ms
(1.45%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_is_no_index AS seo_is_no_index_13, a0_.description AS description_14, a0_.description AS description_15, a0_.lead AS lead_16, a0_.content AS content_17, a0_.video_url AS video_url_18, a0_.description AS description_19, a0_.type AS type_20, a0_.image_id AS image_id_21, a0_.created_by_id AS created_by_id_22, a0_.updated_by_id AS updated_by_id_23, a0_.audio_id AS audio_id_24, a0_.file_id AS file_id_25 FROM article a0_ INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id INNER JOIN article_category a1_ ON a1_.id = a2_.category_id WHERE (a0_.is_active = ? AND a1_.id IN (?) AND a0_.id <> ?) AND a0_.type IN ('audio', 'download', 'text', 'video') LIMIT 4

Parameters:

[
  1
  b"\x01œûÁ"\vuä¶\x18íyw\x0E`"
  b"\x01œûÁt<~…m\x05\eäÙóœ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.is_active AS is_active_3,
  a0_.public_date AS public_date_4,
  a0_.deactivation_date AS deactivation_date_5,
  a0_.hide_date AS hide_date_6,
  a0_.redirect_to_url AS redirect_to_url_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.seo_keywords AS seo_keywords_10,
  a0_.seo_meta_title AS seo_meta_title_11,
  a0_.seo_meta_description AS seo_meta_description_12,
  a0_.seo_is_no_index AS seo_is_no_index_13,
  a0_.description AS description_14,
  a0_.description AS description_15,
  a0_.lead AS lead_16,
  a0_.content AS content_17,
  a0_.video_url AS video_url_18,
  a0_.description AS description_19,
  a0_.type AS type_20,
  a0_.image_id AS image_id_21,
  a0_.created_by_id AS created_by_id_22,
  a0_.updated_by_id AS updated_by_id_23,
  a0_.audio_id AS audio_id_24,
  a0_.file_id AS file_id_25
FROM
  article a0_
  INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id
  INNER JOIN article_category a1_ ON a1_.id = a2_.category_id
WHERE
  (
    a0_.is_active = ?
    AND a1_.id IN (?)
    AND a0_.id <> ?
  )
  AND a0_.type IN (
    'audio', 'download', 'text', 'video'
  )
LIMIT
  4

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_is_no_index AS seo_is_no_index_13, a0_.description AS description_14, a0_.description AS description_15, a0_.lead AS lead_16, a0_.content AS content_17, a0_.video_url AS video_url_18, a0_.description AS description_19, a0_.type AS type_20, a0_.image_id AS image_id_21, a0_.created_by_id AS created_by_id_22, a0_.updated_by_id AS updated_by_id_23, a0_.audio_id AS audio_id_24, a0_.file_id AS file_id_25 FROM article a0_ INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id INNER JOIN article_category a1_ ON a1_.id = a2_.category_id WHERE (a0_.is_active = 1 AND a1_.id IN (0x019CFBC1220B75E4B61881ED79770E60) AND a0_.id <> 0x019CFBC1743C7E9D856D051BE4D9F39C) AND a0_.type IN ('audio', 'download', 'text', 'video') LIMIT 4;

#	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\Article\ArticleRepository->findRelated (line 75)
7	App\Services\KnowledgeBase\Article\RelatedArticlesService->getRelatedArticles (line 23)
8	App\Controller\Web\KnowledgeBase\ArticleController->index (line 32)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.81 ms
(1.42%)

SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.size AS size_3, t0.mime_type AS mime_type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dimensions AS dimensions_7, t0.id AS id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM article_image t0 WHERE t0.id = ?

Parameters:

[
  b"\x01œûÄ\x1D\x08{Ð¦æ®vë¸ÚÖ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.original_name AS original_name_2,
  t0.size AS size_3,
  t0.mime_type AS mime_type_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.dimensions AS dimensions_7,
  t0.id AS id_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10
FROM
  article_image t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.size AS size_3, t0.mime_type AS mime_type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dimensions AS dimensions_7, t0.id AS id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM article_image t0 WHERE t0.id = 0x019CFBC41D087BD0A6E6AE76EBB8DAD6;

#	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__\App\Entity\KnowledgeBase\Article\ArticleImage::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\KnowledgeBase\Article\ArticleImage->initializeLazyObject (line 106)
7	Proxies\__CG__\App\Entity\KnowledgeBase\Article\ArticleImage->__load (line 20)
8	Vich\UploaderBundle\Mapping\PropertyMappingFactory->fromFirstField (line 96)
9	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 143)
10	Vich\UploaderBundle\Storage\FileSystemStorage->resolveUri (line 68)
11	Vich\UploaderBundle\Templating\Helper\UploaderHelper->asset (line 35)
12	Vich\UploaderBundle\Twig\Extension\UploaderExtensionRuntime->asset (line 28)
13	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e->block_page (line 257)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e->doDisplay (line 58)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_c68a71f7376a0f523984281cc424d8e6->doDisplay (line 53)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
28	App\Controller\UniqskillsAbstractController->render (line 38)
29	App\Controller\Web\KnowledgeBase\ArticleController->index (line 36)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	require_once (line 5)

0.64 ms
(1.11%)

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.profession AS profession_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.avatar_id AS avatar_id_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM author t0 INNER JOIN article_author ON t0.id = article_author.author_id WHERE article_author.article_id = ?

Parameters:

[
  b"\x01œûÁt<~…m\x05\eäÙóœ"
]

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.profession AS profession_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.avatar_id AS avatar_id_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11
FROM
  author t0
  INNER JOIN article_author ON t0.id = article_author.author_id
WHERE
  article_author.article_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.profession AS profession_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.avatar_id AS avatar_id_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM author t0 INNER JOIN article_author ON t0.id = article_author.author_id WHERE article_author.article_id = 0x019CFBC1743C7E9D856D051BE4D9F39C;

#	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 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1417)
9	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e::block_page (line 268)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e->doDisplay (line 58)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_c68a71f7376a0f523984281cc424d8e6->doDisplay (line 53)
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\KnowledgeBase\ArticleController->index (line 36)
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.62 ms
(1.09%)

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 INNER JOIN article_categories ON t0.id = article_categories.category_id WHERE article_categories.article_id = ?

Parameters:

[
  b"\x01œûÁt<~…m\x05\eäÙóœ"
]

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
  INNER JOIN article_categories ON t0.id = article_categories.category_id
WHERE
  article_categories.article_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 INNER JOIN article_categories ON t0.id = article_categories.category_id WHERE article_categories.article_id = 0x019CFBC1743C7E9D856D051BE4D9F39C;

#	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->map (line 257)
7	App\Repository\KnowledgeBase\Article\ArticleRepository->findRelated (line 68)
8	App\Services\KnowledgeBase\Article\RelatedArticlesService->getRelatedArticles (line 23)
9	App\Controller\Web\KnowledgeBase\ArticleController->index (line 32)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.52 ms
(0.92%)

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.id = ?

Parameters:

[
  b"\x01šÚ@ÇY{ð‡\x02ó_ŽU¾\x07"
]

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.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.id = 0x019ADA40C7597BF08702F35F8E55BE07;

#	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__\App\Entity\Education\Category\Category::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Education\Category\Category->__get (line 153)
7	App\Entity\Education\Category\Category->getParent (line 77)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e::{closure} (line 520)
10	Twig\Extension\CoreExtension->captureOutput (line 2110)
11	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e::macro_popularCourse (line 509)
12	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e->block_page (line 413)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_08ca484fd2a8886bd68fbd912cc2733e->doDisplay (line 58)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_c68a71f7376a0f523984281cc424d8e6->doDisplay (line 53)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
27	App\Controller\UniqskillsAbstractController->render (line 38)
28	App\Controller\Web\KnowledgeBase\ArticleController->index (line 36)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	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	49
App\Entity\Education\Module\Module	10
App\Entity\Education\Course\Course	4
App\Entity\Education\Course\CourseImage	4
App\Entity\KnowledgeBase\Article\Article	1
App\Entity\KnowledgeBase\Article\ArticleImage	1
App\Entity\User\User	1
App\Entity\KnowledgeBase\Category\Category	1
App\Entity\Author\Author	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\KnowledgeBase\Article\Article	No errors.
App\Entity\KnowledgeBase\Article\AudioArticle	No errors.
App\Entity\KnowledgeBase\Article\DownloadArticle	No errors.
App\Entity\KnowledgeBase\Article\TextArticle	No errors.
App\Entity\KnowledgeBase\Article\VideoArticle	No errors.
App\Entity\File\File	No errors.
App\Entity\File\ImageFile	No errors.
App\Entity\KnowledgeBase\Article\ArticleImage	No errors.
App\Entity\User\User	No errors.
App\Entity\User\Admin	No errors.
App\Entity\File\AudioFile	No errors.
App\Entity\KnowledgeBase\Article\ArticleAudio	No errors.
App\Entity\KnowledgeBase\Article\ArticleFile	No errors.
App\Entity\Category\BaseCategory	No errors.
App\Entity\KnowledgeBase\Category\Category	No errors.
App\Entity\Author\Author	No errors.
App\Entity\Education\Course\Course	No errors.
App\Entity\Education\Course\FutureDegreeCourse	No errors.
App\Entity\Education\Category\Category	No errors.
App\Entity\Education\Course\CourseImage	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\Author\AuthorImage	No errors.
App\Entity\Education\Lesson\Lesson	No errors.
App\Entity\Education\Test\ModuleTest	No errors.

gos entity manager

No loaded entities.

Symfony Profiler

GET https://2.uniqskills.com/pl/baza-wiedzy/bhp/co-musi-zawierac-szkolenie-bhp-by-bylo-zgodne-z-prawem-i-jednoczesnie-zrozumiale-dla-pracownikow

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