Symfony Profiler

Query Metrics

40 Database Queries

9 Different statements

839.35 ms Query time

0 Invalid entities

81 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

763.47 ms
(90.96%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.public_date AS public_date_5, t0.deactivation_date AS deactivation_date_6, t0.hide_date AS hide_date_7, t0.redirect_to_url AS redirect_to_url_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.seo_keywords AS seo_keywords_11, t0.seo_meta_title AS seo_meta_title_12, t0.seo_meta_description AS seo_meta_description_13, t0.seo_open_graph_title AS seo_open_graph_title_14, t0.seo_open_graph_description AS seo_open_graph_description_15, t0.seo_open_graph_image_url AS seo_open_graph_image_url_16, t0.seo_is_no_index AS seo_is_no_index_17, t0.image_id AS image_id_18, t0.created_by_id AS created_by_id_19, t0.updated_by_id AS updated_by_id_20, t0.type, t0.description AS description_21, t0.audio_id AS audio_id_22, t0.description AS description_23, t0.file_id AS file_id_24, t0.lead AS lead_25, t0.table_of_contents AS table_of_contents_26, t0.content AS content_27, t0.video_url AS video_url_28, t0.description AS description_29 FROM article t0 INNER JOIN article_categories ON t0.id = article_categories.article_id WHERE article_categories.category_id = ? AND t0.type IN ('audio', 'download', 'text', 'video')

Parameters:

[
  b"\x01š^/°-y‹ŽK•/7¼F"
]

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.is_active AS is_active_4,
  t0.public_date AS public_date_5,
  t0.deactivation_date AS deactivation_date_6,
  t0.hide_date AS hide_date_7,
  t0.redirect_to_url AS redirect_to_url_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.seo_keywords AS seo_keywords_11,
  t0.seo_meta_title AS seo_meta_title_12,
  t0.seo_meta_description AS seo_meta_description_13,
  t0.seo_open_graph_title AS seo_open_graph_title_14,
  t0.seo_open_graph_description AS seo_open_graph_description_15,
  t0.seo_open_graph_image_url AS seo_open_graph_image_url_16,
  t0.seo_is_no_index AS seo_is_no_index_17,
  t0.image_id AS image_id_18,
  t0.created_by_id AS created_by_id_19,
  t0.updated_by_id AS updated_by_id_20,
  t0.type,
  t0.description AS description_21,
  t0.audio_id AS audio_id_22,
  t0.description AS description_23,
  t0.file_id AS file_id_24,
  t0.lead AS lead_25,
  t0.table_of_contents AS table_of_contents_26,
  t0.content AS content_27,
  t0.video_url AS video_url_28,
  t0.description AS description_29
FROM
  article t0
  INNER JOIN article_categories ON t0.id = article_categories.article_id
WHERE
  article_categories.category_id = ?
  AND t0.type IN (
    'audio', 'download', 'text', 'video'
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.public_date AS public_date_5, t0.deactivation_date AS deactivation_date_6, t0.hide_date AS hide_date_7, t0.redirect_to_url AS redirect_to_url_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.seo_keywords AS seo_keywords_11, t0.seo_meta_title AS seo_meta_title_12, t0.seo_meta_description AS seo_meta_description_13, t0.seo_open_graph_title AS seo_open_graph_title_14, t0.seo_open_graph_description AS seo_open_graph_description_15, t0.seo_open_graph_image_url AS seo_open_graph_image_url_16, t0.seo_is_no_index AS seo_is_no_index_17, t0.image_id AS image_id_18, t0.created_by_id AS created_by_id_19, t0.updated_by_id AS updated_by_id_20, t0.type, t0.description AS description_21, t0.audio_id AS audio_id_22, t0.description AS description_23, t0.file_id AS file_id_24, t0.lead AS lead_25, t0.table_of_contents AS table_of_contents_26, t0.content AS content_27, t0.video_url AS video_url_28, t0.description AS description_29 FROM article t0 INNER JOIN article_categories ON t0.id = article_categories.article_id WHERE article_categories.category_id = 0x019A5E2FB02D798B8E4B952F3781BC46 AND t0.type IN ('audio', 'download', 'text', 'video');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 237)
7	App\Entity\KnowledgeBase\Category\Category->getAvailableArticles (line 144)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d::{closure} (line 405)
10	Twig\Extension\CoreExtension->captureOutput (line 2110)
11	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d::macro_render_category_tree (line 376)
12	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d->block_page (line 229)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_c94078000445773482d0ae5dbe494a12->doDisplay (line 170)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d->doDisplay (line 59)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
25	App\Controller\Web\KnowledgeBase\CategoryController->index (line 51)
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)

43.89 ms
(5.23%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_open_graph_title AS seo_open_graph_title_13, a0_.seo_open_graph_description AS seo_open_graph_description_14, a0_.seo_open_graph_image_url AS seo_open_graph_image_url_15, a0_.seo_is_no_index AS seo_is_no_index_16, a0_.description AS description_17, a0_.description AS description_18, a0_.lead AS lead_19, a0_.table_of_contents AS table_of_contents_20, a0_.content AS content_21, a0_.video_url AS video_url_22, a0_.description AS description_23, a0_.type AS type_24, a0_.image_id AS image_id_25, a0_.created_by_id AS created_by_id_26, a0_.updated_by_id AS updated_by_id_27, a0_.audio_id AS audio_id_28, a0_.file_id AS file_id_29 FROM article a0_ WHERE (a0_.id IN (?, ?, ?)) AND a0_.type IN ('audio', 'download', 'text', 'video')

Parameters:

[
  b"\x01žË\x18¢\r~\x04¹(\x06ÞÏº<"
  b"\x01žË\x03Qo\x7F\x19·ØrÒËô¿Ÿ"
  b"\x01žÊ¬Ót{k½¸%8Ä¶\x06~"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.is_active AS is_active_3,
  a0_.public_date AS public_date_4,
  a0_.deactivation_date AS deactivation_date_5,
  a0_.hide_date AS hide_date_6,
  a0_.redirect_to_url AS redirect_to_url_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.seo_keywords AS seo_keywords_10,
  a0_.seo_meta_title AS seo_meta_title_11,
  a0_.seo_meta_description AS seo_meta_description_12,
  a0_.seo_open_graph_title AS seo_open_graph_title_13,
  a0_.seo_open_graph_description AS seo_open_graph_description_14,
  a0_.seo_open_graph_image_url AS seo_open_graph_image_url_15,
  a0_.seo_is_no_index AS seo_is_no_index_16,
  a0_.description AS description_17,
  a0_.description AS description_18,
  a0_.lead AS lead_19,
  a0_.table_of_contents AS table_of_contents_20,
  a0_.content AS content_21,
  a0_.video_url AS video_url_22,
  a0_.description AS description_23,
  a0_.type AS type_24,
  a0_.image_id AS image_id_25,
  a0_.created_by_id AS created_by_id_26,
  a0_.updated_by_id AS updated_by_id_27,
  a0_.audio_id AS audio_id_28,
  a0_.file_id AS file_id_29
FROM
  article a0_
WHERE
  (
    a0_.id IN (?, ?, ?)
  )
  AND a0_.type IN (
    'audio', 'download', 'text', 'video'
  )

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_open_graph_title AS seo_open_graph_title_13, a0_.seo_open_graph_description AS seo_open_graph_description_14, a0_.seo_open_graph_image_url AS seo_open_graph_image_url_15, a0_.seo_is_no_index AS seo_is_no_index_16, a0_.description AS description_17, a0_.description AS description_18, a0_.lead AS lead_19, a0_.table_of_contents AS table_of_contents_20, a0_.content AS content_21, a0_.video_url AS video_url_22, a0_.description AS description_23, a0_.type AS type_24, a0_.image_id AS image_id_25, a0_.created_by_id AS created_by_id_26, a0_.updated_by_id AS updated_by_id_27, a0_.audio_id AS audio_id_28, a0_.file_id AS file_id_29 FROM article a0_ WHERE (a0_.id IN (0x019ECB18A20D7E04B92806DECFBA3CAD, 0x019ECB03516F7F19B7D872D2CBF4BF9F, 0x019ECAACD3747B6BBDB82538C4B6067E)) AND a0_.type IN ('audio', 'download', 'text', 'video');

#	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\Services\Elastica\UuidElasticaToModelTransformer->findByIdentifiers (line 44)
7	App\Services\Elastica\UuidElasticaToModelTransformer->transform (line 62)
8	FOS\ElasticaBundle\Paginator\TransformedPartialResults->toArray (line 41)
9	FOS\ElasticaBundle\Subscriber\PaginateElasticaQuerySubscriber->items (line 43)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Knp\Component\Pager\Paginator->paginate (line 97)
15	ContainerYEORYVx\PaginatorProxyBa079e5->paginate (line 25)
16	App\Controller\Web\KnowledgeBase\CategoryController->index (line 35)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

14.08 ms
(1.68%)

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

Parameters:

[
  b"\x01š^/°-y‹ŽK•/7¼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
  article_category t0
WHERE
  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.parent_id = 0x019A5E2FB02D798B8E4B952F3781BC46;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1417)
9	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d::{closure} (line 411)
10	Twig\Extension\CoreExtension->captureOutput (line 2110)
11	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d::macro_render_category_tree (line 376)
12	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d->block_page (line 229)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_c94078000445773482d0ae5dbe494a12->doDisplay (line 170)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d->doDisplay (line 59)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
25	App\Controller\Web\KnowledgeBase\CategoryController->index (line 51)
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)

6.13 ms
(0.73%)

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š^/°-y‹ŽK•/7¼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
  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 = 0x019A5E2FB02D798B8E4B952F3781BC46);

#	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_6442dafcf4a3f9e22c3c23ec82286b2d->{closure} (line 173)
6	Twig\Extension\CoreExtension->captureOutput (line 2110)
7	__TwigTemplate_6442dafcf4a3f9e22c3c23ec82286b2d::macro_renderMegaMenu (line 122)
8	__TwigTemplate_d6fd1823cbd3ed8bf731baf739f49cf3->doDisplay (line 268)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_c94078000445773482d0ae5dbe494a12->doDisplay (line 167)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d->doDisplay (line 59)
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\KnowledgeBase\CategoryController->index (line 51)
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)

3.98 ms
(0.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.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 INNER JOIN article_categories ON t0.id = article_categories.category_id WHERE article_categories.article_id = ?

Parameters:

[
  b"\x01žË\x18¢\r~\x04¹(\x06ÞÏº<"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 INNER JOIN article_categories ON t0.id = article_categories.category_id WHERE article_categories.article_id = 0x019ECB18A20D7E04B92806DECFBA3CAD;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->first (line 167)
7	Doctrine\ORM\PersistentCollection->first (line 518)
8	App\Entity\KnowledgeBase\Article\Article->getCategory (line 268)
9	Twig\Extension\CoreExtension->getAttribute (line 1913)
10	__TwigTemplate_5c80e6629a1fef660f74f66ed737e90b::{closure} (line 100)
11	Twig\Extension\CoreExtension->captureOutput (line 2110)
12	__TwigTemplate_5c80e6629a1fef660f74f66ed737e90b::macro_articleItem (line 87)
13	__TwigTemplate_5c80e6629a1fef660f74f66ed737e90b->doDisplay (line 56)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d->block_page (line 316)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_c94078000445773482d0ae5dbe494a12->doDisplay (line 170)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d->doDisplay (line 59)
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\KnowledgeBase\CategoryController->index (line 51)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

2.93 ms
(0.35%)

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

Parameters:

[
  b"\x01žË%ýÊrº‰{Rþ\fËŽ"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\KnowledgeBase\Article\ArticleImage::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\KnowledgeBase\Article\ArticleImage->initializeLazyObject (line 106)
7	Proxies\__CG__\App\Entity\KnowledgeBase\Article\ArticleImage->__load (line 20)
8	Vich\UploaderBundle\Mapping\PropertyMappingFactory->fromFirstField (line 96)
9	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 143)
10	Vich\UploaderBundle\Storage\FileSystemStorage->resolveUri (line 68)
11	Vich\UploaderBundle\Templating\Helper\UploaderHelper->asset (line 35)
12	Vich\UploaderBundle\Twig\Extension\UploaderExtensionRuntime->asset (line 28)
13	__TwigTemplate_5c80e6629a1fef660f74f66ed737e90b->{closure} (line 108)
14	Twig\Extension\CoreExtension->captureOutput (line 2110)
15	__TwigTemplate_5c80e6629a1fef660f74f66ed737e90b::macro_articleItem (line 87)
16	__TwigTemplate_5c80e6629a1fef660f74f66ed737e90b->doDisplay (line 56)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d->block_page (line 316)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_c94078000445773482d0ae5dbe494a12->doDisplay (line 170)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d->doDisplay (line 59)
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\KnowledgeBase\CategoryController->index (line 51)
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.12 ms
(0.25%)

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\Controller\Web\KnowledgeBase\CategoryController->index (line 53)
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)

1.41 ms
(0.17%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c1_.id AS id_3, c1_.name AS name_4, c1_.slug AS slug_5 FROM course_category c0_ LEFT JOIN course_category c1_ ON c0_.parent_id = c1_.id WHERE c0_.is_active = 1 ORDER BY c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c1_.id AS id_3,
  c1_.name AS name_4,
  c1_.slug AS slug_5
FROM
  course_category c0_
  LEFT JOIN course_category c1_ ON c0_.parent_id = c1_.id
WHERE
  c0_.is_active = 1
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c1_.id AS id_3, c1_.name AS name_4, c1_.slug AS slug_5 FROM course_category c0_ LEFT JOIN course_category c1_ ON c0_.parent_id = c1_.id WHERE c0_.is_active = 1 ORDER BY c0_.name 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->getScalarResult (line 724)
6	App\Repository\Education\Category\CategoryRepository->findCategoryTreeRows (line 50)
7	App\Services\Education\Category\CategoryNavigationProvider->getCategoryTree (line 45)
8	App\Twig\Runtime\AppCourseCategoryTreeExtensionRuntime->loadCategoryHierarchy (line 18)
9	__TwigTemplate_6442dafcf4a3f9e22c3c23ec82286b2d->{closure} (line 167)
10	Twig\Extension\CoreExtension->captureOutput (line 2110)
11	__TwigTemplate_6442dafcf4a3f9e22c3c23ec82286b2d::macro_renderMegaMenu (line 122)
12	__TwigTemplate_d6fd1823cbd3ed8bf731baf739f49cf3->doDisplay (line 264)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_c94078000445773482d0ae5dbe494a12->doDisplay (line 167)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_a865e5cf99c5646c93fa30c2dddb866d->doDisplay (line 59)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
25	App\Controller\Web\KnowledgeBase\CategoryController->index (line 51)
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)

1.33 ms
(0.16%)

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.slug = ? LIMIT 1

Parameters:

[
  "inne"
]

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.slug = ?
LIMIT
  1

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.slug = 'inne' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
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)

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\KnowledgeBase\Article\Article	35
App\Entity\KnowledgeBase\Article\ArticleImage	35
App\Entity\KnowledgeBase\Category\Category	7
App\Entity\User\User	4

gos entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Category\BaseCategory	No errors.
App\Entity\KnowledgeBase\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\User\User	No errors.
App\Entity\User\Admin	No errors.
App\Entity\Seo\Seo	No errors.
App\Entity\KnowledgeBase\Article\Article	No errors.
App\Entity\KnowledgeBase\Article\AudioArticle	No errors.
App\Entity\KnowledgeBase\Article\DownloadArticle	No errors.
App\Entity\KnowledgeBase\Article\TextArticle	No errors.
App\Entity\KnowledgeBase\Article\VideoArticle	No errors.
App\Entity\KnowledgeBase\Article\ArticleImage	No errors.
App\Entity\File\AudioFile	No errors.
App\Entity\KnowledgeBase\Article\ArticleAudio	No errors.
App\Entity\KnowledgeBase\Article\ArticleFile	No errors.
App\Entity\Author\Author	No errors.
App\Entity\Education\Category\Category	No errors.

gos entity manager

No loaded entities.

Symfony Profiler

GET https://2.uniqskills.com/pl/baza-wiedzy/inne

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