Symfony Profiler

Query Metrics

92 Database Queries

14 Different statements

51.59 ms Query time

0 Invalid entities

104 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

24.00 ms
(46.53%)

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_d404c6a4808d4e84599f8d1cebce0402->doDisplay (line 58)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\UniqskillsAbstractController->render (line 38)
22	App\Controller\Web\Education\CourseLandingPageController->index (line 38)
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)

6.43 ms
(12.47%)

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œöCp\wØ»é((rŽùœ"
]

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

#	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_7528be61a2f9eaf5b249f525a680194e->doDisplay (line 86)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->block_page (line 223)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->doDisplay (line 58)
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\UniqskillsAbstractController->render (line 38)
23	App\Controller\Web\Education\CourseLandingPageController->index (line 38)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

5.12 ms
(9.93%)

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œöC”øp“\x1A\x16ìíHs‹"
]

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

#	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_7528be61a2f9eaf5b249f525a680194e->{closure} (line 149)
14	Twig\Extension\CoreExtension->captureOutput (line 2110)
15	__TwigTemplate_7528be61a2f9eaf5b249f525a680194e::macro_authorItem (line 133)
16	__TwigTemplate_7528be61a2f9eaf5b249f525a680194e->doDisplay (line 93)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->block_page (line 223)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->doDisplay (line 58)
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\Education\CourseLandingPageController->index (line 38)
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)

3.89 ms
(7.54%)

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

Parameters:

[
  b"\x01œ÷8Gxs ª°Ýïí\x16dÒ"
]

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_landing_section_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_landing_section_image t0 WHERE t0.id = 0x019CF738477873A0AAB0DDEFED1664D2;

#	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->getCourseLandingSectionImage (line 25)
7	__TwigTemplate_4d3787fed6d8e2aeae61ed47cd96035a->doDisplay (line 55)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->block_page (line 223)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->doDisplay (line 58)
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\UniqskillsAbstractController->render (line 38)
23	App\Controller\Web\Education\CourseLandingPageController->index (line 38)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

3.38 ms
(6.56%)

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

Parameters:

[
  "wspolczesne-zaburzenia-i-problemy-wychowawcze-uczniow-dysfunkcje-rozwojowe-zachowania-agresywne-zaburzenia-nastroju-nowe-uzaleznienia"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\Education\Course\CourseRepository->findOneBySlug (line 193)
7	App\Request\ParamConverter\CourseParamConverter->resolve (line 34)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

2.70 ms
(5.24%)

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.context AS context_3, t0.coupon_code AS coupon_code_4, t0.price_net AS price_net_5, t0.price_gross AS price_gross_6, t0.price_net_discounted AS price_net_discounted_7, t0.price_gross_discounted AS price_gross_discounted_8, t0.valid_until AS valid_until_9, t0.main_promo_text AS main_promo_text_10, t0.sub_promo_text AS sub_promo_text_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.course_id AS course_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.type FROM course_price t0 WHERE (t0.is_active = ? AND t0.course_id = ?) AND t0.type IN ('variant', 'pack')

Parameters:

[
  1
  b"\x01œõÚ$í|3“kÈà{>è\r"
]

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.context AS context_3,
  t0.coupon_code AS coupon_code_4,
  t0.price_net AS price_net_5,
  t0.price_gross AS price_gross_6,
  t0.price_net_discounted AS price_net_discounted_7,
  t0.price_gross_discounted AS price_gross_discounted_8,
  t0.valid_until AS valid_until_9,
  t0.main_promo_text AS main_promo_text_10,
  t0.sub_promo_text AS sub_promo_text_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.course_id AS course_id_14,
  t0.created_by_id AS created_by_id_15,
  t0.updated_by_id AS updated_by_id_16,
  t0.type
FROM
  course_price t0
WHERE
  (
    t0.is_active = ?
    AND t0.course_id = ?
  )
  AND t0.type IN ('variant', 'pack')

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.context AS context_3, t0.coupon_code AS coupon_code_4, t0.price_net AS price_net_5, t0.price_gross AS price_gross_6, t0.price_net_discounted AS price_net_discounted_7, t0.price_gross_discounted AS price_gross_discounted_8, t0.valid_until AS valid_until_9, t0.main_promo_text AS main_promo_text_10, t0.sub_promo_text AS sub_promo_text_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.course_id AS course_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.type FROM course_price t0 WHERE (t0.is_active = 1 AND t0.course_id = 0x019CF5DA24ED7C33936BC8E07B3EE80D) AND t0.type IN ('variant', 'pack');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCriteria (line 888)
2	Doctrine\ORM\PersistentCollection->matching (line 610)
3	App\Entity\Education\Course\Course->getCoursePrices (line 714)
4	App\Entity\Education\Course\Course->hasDiscountedVariants (line 832)
5	Twig\Extension\CoreExtension->getAttribute (line 1913)
6	__TwigTemplate_4d3787fed6d8e2aeae61ed47cd96035a::doDisplay (line 68)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->block_page (line 223)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->doDisplay (line 58)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\UniqskillsAbstractController->render (line 38)
22	App\Controller\Web\Education\CourseLandingPageController->index (line 38)
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)

1.58 ms
(3.06%)

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_d404c6a4808d4e84599f8d1cebce0402->doDisplay (line 58)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	App\Controller\UniqskillsAbstractController->render (line 38)
25	App\Controller\Web\Education\CourseLandingPageController->index (line 38)
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.94 ms
(1.82%)

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œæ3—›pPG˜èø\x17\e"
]

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

#	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_525f12c94804ce5510803dd327ea0166->doDisplay (line 84)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->block_page (line 223)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->doDisplay (line 58)
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\Education\CourseLandingPageController->index (line 38)
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.93 ms
(1.81%)

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.position AS position_3, t0.name AS name_4, t0.variables AS variables_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.course_id AS course_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.type FROM course_landing_section t0 WHERE t0.course_id = ? AND t0.type IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10a', '10b', '11', '11b', '12', '13', '14', '15', '15b', '16', '17', '18', 'HTML') ORDER BY t0.position ASC

Parameters:

[
  b"\x01œõÚ$í|3“kÈà{>è\r"
]

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.variables AS variables_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.course_id AS course_id_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10,
  t0.type
FROM
  course_landing_section t0
WHERE
  t0.course_id = ?
  AND t0.type IN (
    '1', '2', '3', '4', '5', '6', '7', '8',
    '9', '10a', '10b', '11', '11b', '12',
    '13', '14', '15', '15b', '16', '17',
    '18', 'HTML'
  )
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.variables AS variables_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.course_id AS course_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.type FROM course_landing_section t0 WHERE t0.course_id = 0x019CF5DA24ED7C33936BC8E07B3EE80D AND t0.type IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10a', '10b', '11', '11b', '12', '13', '14', '15', '15b', '16', '17', '18', 'HTML') 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	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->block_page (line 211)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->doDisplay (line 58)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\UniqskillsAbstractController->render (line 38)
22	App\Controller\Web\Education\CourseLandingPageController->index (line 38)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.68 ms
(1.31%)

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œõÚ$í|3“kÈà{>è\r"
]

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 = 0x019CF5DA24ED7C33936BC8E07B3EE80D AND t0.type IN ('course');

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

0.60 ms
(1.16%)

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œæ3j©{3²Åò\x00\x08ëÕŠ"
]

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

#	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->findObjectByUuid (line 55)
7	__TwigTemplate_525f12c94804ce5510803dd327ea0166->doDisplay (line 54)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->block_page (line 223)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->doDisplay (line 58)
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\UniqskillsAbstractController->render (line 38)
23	App\Controller\Web\Education\CourseLandingPageController->index (line 38)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.57 ms
(1.10%)

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œ÷€'«}Æ•\x04X¦¶ŒN"
]

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

#	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\Category\BaseCategory->getColor (line 162)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_4d3787fed6d8e2aeae61ed47cd96035a::doDisplay (line 62)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->block_page (line 223)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_b7c23f438634d722ee07d966d1dba7ea->doDisplay (line 121)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_d404c6a4808d4e84599f8d1cebce0402->doDisplay (line 58)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	App\Controller\UniqskillsAbstractController->render (line 38)
25	App\Controller\Web\Education\CourseLandingPageController->index (line 38)
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.42 ms
(0.82%)

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_d404c6a4808d4e84599f8d1cebce0402->doDisplay (line 58)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	App\Controller\UniqskillsAbstractController->render (line 38)
25	App\Controller\Web\Education\CourseLandingPageController->index (line 38)
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.34 ms
(0.66%)

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_d404c6a4808d4e84599f8d1cebce0402->doDisplay (line 58)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\UniqskillsAbstractController->render (line 38)
22	App\Controller\Web\Education\CourseLandingPageController->index (line 38)
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)

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\CourseLandingSection\CourseLandingSection	15
App\Entity\Author\Author	12
App\Entity\Author\AuthorImage	12
App\Entity\Education\CourseLandingSection\CourseLandingSectionImage	7
App\Entity\User\User	2
App\Entity\Education\Course\Course	1
App\Entity\Education\Course\CourseImage	1
App\Entity\Education\Test\Test	1
App\Entity\KnowledgeBase\Category\Category	1
App\Entity\Education\Course\Price\CoursePrice	1
App\Entity\Partner\Partner	1
App\Entity\Partner\PartnerImage	1

gos entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Seo\Seo	No errors.
App\Entity\Education\Course\Course	No errors.
App\Entity\Education\Course\AcademyCourse	No errors.
App\Entity\Education\Course\FutureDegreeCourse	No errors.
App\Entity\Education\Course\WebinarCourse	No errors.
App\Entity\Education\Course\NoFrontCourse	No errors.
App\Entity\Category\BaseCategory	No errors.
App\Entity\Education\Category\Category	No errors.
App\Entity\File\File	No errors.
App\Entity\File\ImageFile	No errors.
App\Entity\Education\Course\CourseImage	No errors.
App\Entity\User\User	No errors.
App\Entity\User\Admin	No errors.
App\Entity\Education\Module\Module	No errors.
App\Entity\Education\CourseLandingSection\CourseLandingSection	No errors.
App\Entity\Partner\Partner	No errors.
App\Entity\Education\Test\Test	No errors.
App\Entity\Education\Test\CourseTest	No errors.
App\Entity\Education\Test\Question	No errors.
App\Entity\Education\Test\UserTest	No errors.
App\Entity\Education\Course\UserCourse	No errors.
App\Entity\Access\BaseAccess	No errors.
App\Entity\Education\Course\CourseAccess	No errors.
App\Entity\Education\Course\Price\CoursePrice	No errors.
App\Entity\Category\CategoryImage	No errors.
App\Entity\Category\CategoryDesktopBanner	No errors.
App\Entity\Category\CategoryMobileBanner	No errors.
App\Entity\KnowledgeBase\Category\Category	No errors.
App\Entity\KnowledgeBase\Article\Article	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section1Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section2Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section3Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section4Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section5Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section6Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section7Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section8Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section9Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section10aTemplate	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section10bTemplate	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section11Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section11bTemplate	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section12Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section13Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section14Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section15Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section15bTemplate	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section16Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section17Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section18Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\SectionHtmlTemplate	No errors.
App\Entity\Education\CourseLandingSection\CourseLandingSectionImage	No errors.
App\Entity\Education\Course\Price\VariantPrice	No errors.
App\Entity\Education\Course\Price\PackPrice	No errors.
App\Entity\Partner\PartnerImage	No errors.
App\Entity\Author\Author	No errors.
App\Entity\Author\AuthorImage	No errors.
App\Entity\Education\Lesson\Lesson	No errors.

gos entity manager

No loaded entities.

Symfony Profiler

GET https://2.uniqskills.com/pl/kursy/oswiata/edukacja-podstawowa/wspolczesne-zaburzenia-i-problemy-wychowawcze-uczniow-dysfunkcje-rozwojowe-zachowania-agresywne-za…

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