Symfony Profiler

Query Metrics

138 Database Queries

12 Different statements

81.13 ms Query time

0 Invalid entities

93 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

55.22 ms
(68.07%)

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_8e46cc407d92bf2c638a46030f8310cc->doDisplay (line 55)
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\Web\HomeController->index (line 27)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

4.41 ms
(5.44%)

SELECT h0_.id AS id_0, h0_.is_active AS is_active_1, h0_.position AS position_2, h0_.name AS name_3, h0_.variables AS variables_4, h0_.created_at AS created_at_5, h0_.updated_at AS updated_at_6, h0_.type AS type_7, h0_.portal_settings_id AS portal_settings_id_8, h0_.created_by_id AS created_by_id_9, h0_.updated_by_id AS updated_by_id_10 FROM homepage_landing_section h0_ WHERE (h0_.is_active = 1) AND h0_.type IN ('counters_section', 'html_section', 'testimonial_section', 'knowledge_base_section', 'authors_carousel_section', 'category_carousel_section', 'courses_carousel_section', 'multi_courses_carousel_section', 'partners_carousel_section', 'partners_description_section') ORDER BY h0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.is_active AS is_active_1,
  h0_.position AS position_2,
  h0_.name AS name_3,
  h0_.variables AS variables_4,
  h0_.created_at AS created_at_5,
  h0_.updated_at AS updated_at_6,
  h0_.type AS type_7,
  h0_.portal_settings_id AS portal_settings_id_8,
  h0_.created_by_id AS created_by_id_9,
  h0_.updated_by_id AS updated_by_id_10
FROM
  homepage_landing_section h0_
WHERE
  (h0_.is_active = 1)
  AND h0_.type IN (
    'counters_section', 'html_section',
    'testimonial_section', 'knowledge_base_section',
    'authors_carousel_section', 'category_carousel_section',
    'courses_carousel_section', 'multi_courses_carousel_section',
    'partners_carousel_section', 'partners_description_section'
  )
ORDER BY
  h0_.position ASC

SELECT h0_.id AS id_0, h0_.is_active AS is_active_1, h0_.position AS position_2, h0_.name AS name_3, h0_.variables AS variables_4, h0_.created_at AS created_at_5, h0_.updated_at AS updated_at_6, h0_.type AS type_7, h0_.portal_settings_id AS portal_settings_id_8, h0_.created_by_id AS created_by_id_9, h0_.updated_by_id AS updated_by_id_10 FROM homepage_landing_section h0_ WHERE (h0_.is_active = 1) AND h0_.type IN ('counters_section', 'html_section', 'testimonial_section', 'knowledge_base_section', 'authors_carousel_section', 'category_carousel_section', 'courses_carousel_section', 'multi_courses_carousel_section', 'partners_carousel_section', 'partners_description_section') ORDER BY h0_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PortalSettings\HomepageLandingSectionRepository->findForDisplay (line 25)
7	App\Controller\Web\HomeController->index (line 28)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

3.73 ms
(4.59%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.image_id AS image_id_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM partner t0 WHERE t0.id = ?

Parameters:

[
  b"\x01šÙÂ\x18ýqµ‘æ,öÓØë–"
]

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.link AS link_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.image_id AS image_id_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  partner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.image_id AS image_id_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM partner t0 WHERE t0.id = 0x019AD9C218FD71B591E62CF6D3D8EB96;

#	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	App\Twig\LandingSectionExtension->convertToObjectFromVariable (line 67)
7	__TwigTemplate_101ec379d1b9c2f80571398404111310->doDisplay (line 60)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->block_page (line 129)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	App\Controller\Web\HomeController->index (line 27)
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.65 ms
(4.50%)

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

Parameters:

[
  b"\x01šÙÂ.„qÇ _ÚH’%¦å"
]

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
  partner_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 partner_image t0 WHERE t0.id = 0x019AD9C22E8471C7A05FDA489225A6E5;

#	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\Partner\PartnerImage::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Partner\PartnerImage->initializeLazyObject (line 106)
7	Proxies\__CG__\App\Entity\Partner\PartnerImage->__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_101ec379d1b9c2f80571398404111310->{closure} (line 113)
14	Twig\Extension\CoreExtension->captureOutput (line 2110)
15	__TwigTemplate_101ec379d1b9c2f80571398404111310::macro_partnerItem (line 98)
16	__TwigTemplate_101ec379d1b9c2f80571398404111310->doDisplay (line 64)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->block_page (line 129)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->doDisplay (line 55)
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\Web\HomeController->index (line 27)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 182)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 5)

2.84 ms
(3.50%)

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

Parameters:

[
  b"\x01œL´\x0FÕzÃ™Šj©.èªS"
]

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
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.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 WHERE t0.id = 0x019C4CB40FD57AC3998A6AA92EE8AA53;

#	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	App\Twig\LandingSectionExtension->convertToObjectFromVariable (line 67)
7	__TwigTemplate_1799810f71940e384d9dfe959c2e4a58->doDisplay (line 80)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->block_page (line 129)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	App\Controller\Web\HomeController->index (line 27)
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)

2.26 ms
(2.79%)

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_continuous AS is_continuous_3, t0.is_medical_product AS is_medical_product_4, t0.position AS position_5, t0.name AS name_6, t0.slug AS slug_7, t0.short_body AS short_body_8, t0.difficulty AS difficulty_9, t0.start_date AS start_date_10, t0.hide_date AS hide_date_11, t0.deactivation_date AS deactivation_date_12, t0.duration AS duration_13, t0.action_number AS action_number_14, t0.from_source AS from_source_15, t0.products_for_cos AS products_for_cos_16, t0.redirect_to_url AS redirect_to_url_17, t0.gos_id AS gos_id_18, t0.certificate_gos_id AS certificate_gos_id_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.seo_keywords AS seo_keywords_22, t0.seo_meta_title AS seo_meta_title_23, t0.seo_meta_description AS seo_meta_description_24, t0.seo_is_no_index AS seo_is_no_index_25, t0.beacon_name AS beacon_name_26, t0.category_id AS category_id_27, t0.image_id AS image_id_28, t0.created_by_id AS created_by_id_29, t0.updated_by_id AS updated_by_id_30, t0.type FROM course t0 WHERE t0.id = ? AND t0.type IN ('future_degree')

Parameters:

[
  b"\x01œÜkÞ\x12~¸p¶jÌiüP"
]

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.is_continuous AS is_continuous_3,
  t0.is_medical_product AS is_medical_product_4,
  t0.position AS position_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.short_body AS short_body_8,
  t0.difficulty AS difficulty_9,
  t0.start_date AS start_date_10,
  t0.hide_date AS hide_date_11,
  t0.deactivation_date AS deactivation_date_12,
  t0.duration AS duration_13,
  t0.action_number AS action_number_14,
  t0.from_source AS from_source_15,
  t0.products_for_cos AS products_for_cos_16,
  t0.redirect_to_url AS redirect_to_url_17,
  t0.gos_id AS gos_id_18,
  t0.certificate_gos_id AS certificate_gos_id_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.seo_keywords AS seo_keywords_22,
  t0.seo_meta_title AS seo_meta_title_23,
  t0.seo_meta_description AS seo_meta_description_24,
  t0.seo_is_no_index AS seo_is_no_index_25,
  t0.beacon_name AS beacon_name_26,
  t0.category_id AS category_id_27,
  t0.image_id AS image_id_28,
  t0.created_by_id AS created_by_id_29,
  t0.updated_by_id AS updated_by_id_30,
  t0.type
FROM
  course t0
WHERE
  t0.id = ?
  AND t0.type IN ('future_degree')

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_continuous AS is_continuous_3, t0.is_medical_product AS is_medical_product_4, t0.position AS position_5, t0.name AS name_6, t0.slug AS slug_7, t0.short_body AS short_body_8, t0.difficulty AS difficulty_9, t0.start_date AS start_date_10, t0.hide_date AS hide_date_11, t0.deactivation_date AS deactivation_date_12, t0.duration AS duration_13, t0.action_number AS action_number_14, t0.from_source AS from_source_15, t0.products_for_cos AS products_for_cos_16, t0.redirect_to_url AS redirect_to_url_17, t0.gos_id AS gos_id_18, t0.certificate_gos_id AS certificate_gos_id_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.seo_keywords AS seo_keywords_22, t0.seo_meta_title AS seo_meta_title_23, t0.seo_meta_description AS seo_meta_description_24, t0.seo_is_no_index AS seo_is_no_index_25, t0.beacon_name AS beacon_name_26, t0.category_id AS category_id_27, t0.image_id AS image_id_28, t0.created_by_id AS created_by_id_29, t0.updated_by_id AS updated_by_id_30, t0.type FROM course t0 WHERE t0.id = 0x019CDC6BDE127EB89D70B66ACC69FC50 AND t0.type IN ('future_degree');

#	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	App\Twig\LandingSectionExtension->convertToObjectFromVariable (line 67)
7	__TwigTemplate_19d66bf9a48f4aa237976c83320da4f3->doDisplay (line 70)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->block_page (line 129)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	App\Controller\Web\HomeController->index (line 27)
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)

2.26 ms
(2.78%)

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_8e46cc407d92bf2c638a46030f8310cc->doDisplay (line 55)
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\Web\HomeController->index (line 27)
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)

2.05 ms
(2.53%)

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

Parameters:

[
  b"\x01œL´išp¸¾\t^mB‘ùé"
]

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
  author_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 author_image t0 WHERE t0.id = 0x019C4CB4699A70B8BE095E6D4291F9E9;

#	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\Author\AuthorImage::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Author\AuthorImage->initializeLazyObject (line 106)
7	Proxies\__CG__\App\Entity\Author\AuthorImage->__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_1799810f71940e384d9dfe959c2e4a58->{closure} (line 135)
14	Twig\Extension\CoreExtension->captureOutput (line 2110)
15	__TwigTemplate_1799810f71940e384d9dfe959c2e4a58::macro_authorItem (line 120)
16	__TwigTemplate_1799810f71940e384d9dfe959c2e4a58->doDisplay (line 84)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->block_page (line 129)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->doDisplay (line 55)
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\Web\HomeController->index (line 27)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 182)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 5)

1.94 ms
(2.39%)

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œÜkÞ\x12~¸p¶jÌiüP"
]

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 = 0x019CDC6BDE127EB89D70B66ACC69FC50 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\SimpleObjectHydrator->hydrateRowData (line 176)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
9	Doctrine\ORM\EntityManager->find (line 366)
10	Doctrine\ORM\EntityRepository->find (line 86)
11	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
12	App\Twig\LandingSectionExtension->convertToObjectFromVariable (line 67)
13	__TwigTemplate_19d66bf9a48f4aa237976c83320da4f3->doDisplay (line 70)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->block_page (line 129)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->doDisplay (line 55)
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\Web\HomeController->index (line 27)
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)

1.45 ms
(1.79%)

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œÜr™Žp]–Ø¥¥§ŠX¥"
]

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 = 0x019CDC72998D705D96D8A5A5A78A58A5;

#	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_19d66bf9a48f4aa237976c83320da4f3->{closure} (line 143)
14	Twig\Extension\CoreExtension->captureOutput (line 2110)
15	__TwigTemplate_19d66bf9a48f4aa237976c83320da4f3::macro_courseItem (line 117)
16	__TwigTemplate_19d66bf9a48f4aa237976c83320da4f3->doDisplay (line 74)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->block_page (line 129)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_8e46cc407d92bf2c638a46030f8310cc->doDisplay (line 55)
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\Web\HomeController->index (line 27)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 182)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 5)

0.74 ms
(0.91%)

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_8e46cc407d92bf2c638a46030f8310cc->doDisplay (line 55)
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\Web\HomeController->index (line 27)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

0.57 ms
(0.71%)

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_8e46cc407d92bf2c638a46030f8310cc->doDisplay (line 55)
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\Web\HomeController->index (line 27)
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)

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\Partner\Partner	9
App\Entity\Partner\PartnerImage	9
App\Entity\PortalSettings\HomepageLandingSection	6
App\Entity\Author\Author	5
App\Entity\Author\AuthorImage	5
App\Entity\User\User	3
App\Entity\Education\Course\Course	3
App\Entity\Education\Course\CourseImage	3
App\Entity\PortalSettings\PortalSettings	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\PortalSettings\HomepageLandingSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\CountersSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\HtmlSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\TestimonialSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\KnowledgeBaseSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\AuthorsCarouselSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\CategoryCarouselSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\CoursesCarouselSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\MultiCoursesCarouselSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\PartnersCarouselSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\PartnersDescriptionSection	No errors.
App\Entity\Seo\Seo	No errors.
App\Entity\Social\Social	No errors.
App\Entity\PortalSettings\PortalSettings	No errors.
App\Entity\User\User	No errors.
App\Entity\User\Admin	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\Category\CategoryImage	No errors.
App\Entity\Category\CategoryDesktopBanner	No errors.
App\Entity\Category\CategoryMobileBanner	No errors.
App\Entity\Education\Course\Course	No errors.
App\Entity\KnowledgeBase\Category\Category	No errors.
App\Entity\KnowledgeBase\Article\Article	No errors.
App\Entity\Author\Author	No errors.
App\Entity\Author\AuthorImage	No errors.
App\Entity\Education\Lesson\Lesson	No errors.
App\Entity\Partner\Partner	No errors.
App\Entity\Partner\PartnerImage	No errors.
App\Entity\Education\Course\FutureDegreeCourse	No errors.
App\Entity\Education\Course\CourseImage	No errors.
App\Entity\Education\Test\Test	No errors.
App\Entity\Education\Test\CourseTest	No errors.
App\Entity\Education\Module\Module	No errors.
App\Entity\Education\CourseLandingSection\CourseLandingSection	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.

gos entity manager

No loaded entities.

Symfony Profiler

GET https://2.uniqskills.com/pl/

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