Symfony Profiler

Query Metrics

14 Database Queries

7 Different statements

4.96 ms Query time

0 Invalid entities

57 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.41 ms
(28.51%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.keywords AS keywords_13, t0.lead_image AS lead_image_14, t0.lead AS lead_15, t0.created AS created_16, t0.updated AS updated_17, t0.lead_home AS lead_home_18, t0.lead_color AS lead_color_19, t0.lead_icon AS lead_icon_20, t0.lead_hidden AS lead_hidden_21, t0.parent_id AS parent_id_22, t0.template_id AS template_id_23 FROM page t0 WHERE t0.parent_id = ? ORDER BY t0.position DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enabled AS enabled_4,
  t0.in_menu AS in_menu_5,
  t0.in_footer_menu AS in_footer_menu_6,
  t0.menu_name AS menu_name_7,
  t0.position AS position_8,
  t0.redirect AS redirect_9,
  t0.title AS title_10,
  t0.content AS content_11,
  t0.image AS image_12,
  t0.keywords AS keywords_13,
  t0.lead_image AS lead_image_14,
  t0.lead AS lead_15,
  t0.created AS created_16,
  t0.updated AS updated_17,
  t0.lead_home AS lead_home_18,
  t0.lead_color AS lead_color_19,
  t0.lead_icon AS lead_icon_20,
  t0.lead_hidden AS lead_hidden_21,
  t0.parent_id AS parent_id_22,
  t0.template_id AS template_id_23
FROM
  page t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.keywords AS keywords_13, t0.lead_image AS lead_image_14, t0.lead AS lead_15, t0.created AS created_16, t0.updated AS updated_17, t0.lead_home AS lead_home_18, t0.lead_color AS lead_color_19, t0.lead_icon AS lead_icon_20, t0.lead_hidden AS lead_hidden_21, t0.parent_id AS parent_id_22, t0.template_id AS template_id_23 FROM page t0 WHERE t0.parent_id = 1 ORDER BY t0.position DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 1241)
9	Twig\Extension\CoreExtension::length (line 77)
10	__TwigTemplate_60a2ce9a7754bb2f1cf4666333d24c3e->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 334)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 316)
19	App\Controller\PageController->_menu (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
23	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
24	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
25	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
26	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 348)
27	__TwigTemplate_9ad5cfbef0c2e6203a2efff19c430487->block_main (line 432)
28	Twig\Template->yieldBlock (line 147)
29	__TwigTemplate_9ad5cfbef0c2e6203a2efff19c430487->doDisplay (line 388)
30	Twig\Template->yield (line 55)
31	__TwigTemplate_ff9162c379b32f55dd6b4968e5adc3b9->doDisplay (line 388)
32	Twig\Template->yield (line 344)
33	Twig\Template->display (line 359)
34	Twig\Template->render (line 51)
35	Twig\TemplateWrapper->render (line 334)
36	Twig\Environment->render (line 448)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 262)
40	App\Controller\PageController->news (line 181)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
43	Symfony\Component\HttpKernel\Kernel->handle (line 86)
44	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
45	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
46	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
47	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
48	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
49	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
50	Symfony\Component\HttpKernel\Kernel->handle (line 35)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
52	require_once (line 5)

1.13 ms
(22.71%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4 FROM settings t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.description AS description_4
FROM
  settings t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4 FROM settings t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 25)
5	App\Service\SettingsService->get (line 1882)
6	Twig\Extension\CoreExtension::getAttribute (line 239)
7	__TwigTemplate_9ad5cfbef0c2e6203a2efff19c430487->block_main (line 432)
8	Twig\Template->yieldBlock (line 147)
9	__TwigTemplate_9ad5cfbef0c2e6203a2efff19c430487->doDisplay (line 388)
10	Twig\Template->yield (line 55)
11	__TwigTemplate_ff9162c379b32f55dd6b4968e5adc3b9->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 334)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 262)
20	App\Controller\PageController->news (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
26	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

1.07 ms
(21.60%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.url AS url_2, t0_.enabled AS enabled_3, t0_.promo AS promo_4, t0_.position AS position_5, t0_.start_date AS start_date_6, t0_.end_date AS end_date_7, t0_.lead AS lead_8, t0_.title AS title_9, t0_.content AS content_10, t0_.content2 AS content2_11, t0_.image AS image_12, t0_.schedule_name AS schedule_name_13, t0_.schedule AS schedule_14, t0_.schedule2_name AS schedule2_name_15, t0_.schedule2 AS schedule2_16, t0_.lead_image AS lead_image_17, t0_.nolink AS nolink_18, t0_.lead_color AS lead_color_19, t0_.keywords AS keywords_20, t0_.css AS css_21, t0_.redirect AS redirect_22, t0_.created AS created_23, t0_.updated AS updated_24, t0_.homepage AS homepage_25, t0_.private AS private_26 FROM tile t0_ INNER JOIN tiles_categories t2_ ON t0_.id = t2_.tile_id INNER JOIN category c1_ ON c1_.id = t2_.category_id WHERE t0_.enabled = 1 AND t0_.start_date <= ? AND (t0_.end_date >= ? OR t0_.end_date IS NULL) AND c1_.slug <> ? AND (t0_.private IS NULL OR t0_.private = 0) ORDER BY t0_.position DESC, t0_.start_date DESC LIMIT 10 OFFSET 40

Parameters:

[
  "2025-04-19 00:42:03"
  "2025-04-19 00:42:03"
  "konferencje-szkolenia-warsztaty"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.url AS url_2,
  t0_.enabled AS enabled_3,
  t0_.promo AS promo_4,
  t0_.position AS position_5,
  t0_.start_date AS start_date_6,
  t0_.end_date AS end_date_7,
  t0_.lead AS lead_8,
  t0_.title AS title_9,
  t0_.content AS content_10,
  t0_.content2 AS content2_11,
  t0_.image AS image_12,
  t0_.schedule_name AS schedule_name_13,
  t0_.schedule AS schedule_14,
  t0_.schedule2_name AS schedule2_name_15,
  t0_.schedule2 AS schedule2_16,
  t0_.lead_image AS lead_image_17,
  t0_.nolink AS nolink_18,
  t0_.lead_color AS lead_color_19,
  t0_.keywords AS keywords_20,
  t0_.css AS css_21,
  t0_.redirect AS redirect_22,
  t0_.created AS created_23,
  t0_.updated AS updated_24,
  t0_.homepage AS homepage_25,
  t0_.private AS private_26
FROM
  tile t0_
  INNER JOIN tiles_categories t2_ ON t0_.id = t2_.tile_id
  INNER JOIN category c1_ ON c1_.id = t2_.category_id
WHERE
  t0_.enabled = 1
  AND t0_.start_date <= ?
  AND (
    t0_.end_date >= ?
    OR t0_.end_date IS NULL
  )
  AND c1_.slug <> ?
  AND (
    t0_.private IS NULL
    OR t0_.private = 0
  )
ORDER BY
  t0_.position DESC,
  t0_.start_date DESC
LIMIT
  10
OFFSET
  40

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.url AS url_2, t0_.enabled AS enabled_3, t0_.promo AS promo_4, t0_.position AS position_5, t0_.start_date AS start_date_6, t0_.end_date AS end_date_7, t0_.lead AS lead_8, t0_.title AS title_9, t0_.content AS content_10, t0_.content2 AS content2_11, t0_.image AS image_12, t0_.schedule_name AS schedule_name_13, t0_.schedule AS schedule_14, t0_.schedule2_name AS schedule2_name_15, t0_.schedule2 AS schedule2_16, t0_.lead_image AS lead_image_17, t0_.nolink AS nolink_18, t0_.lead_color AS lead_color_19, t0_.keywords AS keywords_20, t0_.css AS css_21, t0_.redirect AS redirect_22, t0_.created AS created_23, t0_.updated AS updated_24, t0_.homepage AS homepage_25, t0_.private AS private_26 FROM tile t0_ INNER JOIN tiles_categories t2_ ON t0_.id = t2_.tile_id INNER JOIN category c1_ ON c1_.id = t2_.category_id WHERE t0_.enabled = 1 AND t0_.start_date <= '2025-04-19 00:42:03' AND (t0_.end_date >= '2025-04-19 00:42:03' OR t0_.end_date IS NULL) AND c1_.slug <> 'konferencje-szkolenia-warsztaty' AND (t0_.private IS NULL OR t0_.private = 0) ORDER BY t0_.position DESC, t0_.start_date DESC LIMIT 10 OFFSET 40;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 74)
7	App\Repository\TileRepository->getTiles (line 252)
8	App\Controller\PageController->news (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
14	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.49 ms
(9.86%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.keywords AS keywords_13, t0.lead_image AS lead_image_14, t0.lead AS lead_15, t0.created AS created_16, t0.updated AS updated_17, t0.lead_home AS lead_home_18, t0.lead_color AS lead_color_19, t0.lead_icon AS lead_icon_20, t0.lead_hidden AS lead_hidden_21, t0.parent_id AS parent_id_22, t0.template_id AS template_id_23 FROM page t0 WHERE t0.in_footer_menu = ? AND t0.enabled = ? ORDER BY t0.position DESC LIMIT 15

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enabled AS enabled_4,
  t0.in_menu AS in_menu_5,
  t0.in_footer_menu AS in_footer_menu_6,
  t0.menu_name AS menu_name_7,
  t0.position AS position_8,
  t0.redirect AS redirect_9,
  t0.title AS title_10,
  t0.content AS content_11,
  t0.image AS image_12,
  t0.keywords AS keywords_13,
  t0.lead_image AS lead_image_14,
  t0.lead AS lead_15,
  t0.created AS created_16,
  t0.updated AS updated_17,
  t0.lead_home AS lead_home_18,
  t0.lead_color AS lead_color_19,
  t0.lead_icon AS lead_icon_20,
  t0.lead_hidden AS lead_hidden_21,
  t0.parent_id AS parent_id_22,
  t0.template_id AS template_id_23
FROM
  page t0
WHERE
  t0.in_footer_menu = ?
  AND t0.enabled = ?
ORDER BY
  t0.position DESC
LIMIT
  15

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.keywords AS keywords_13, t0.lead_image AS lead_image_14, t0.lead AS lead_15, t0.created AS created_16, t0.updated AS updated_17, t0.lead_home AS lead_home_18, t0.lead_color AS lead_color_19, t0.lead_icon AS lead_icon_20, t0.lead_hidden AS lead_hidden_21, t0.parent_id AS parent_id_22, t0.template_id AS template_id_23 FROM page t0 WHERE t0.in_footer_menu = 1 AND t0.enabled = 1 ORDER BY t0.position DESC LIMIT 15;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 324)
4	App\Controller\PageController->_footerMenu (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 397)
12	__TwigTemplate_9ad5cfbef0c2e6203a2efff19c430487->block_main (line 432)
13	Twig\Template->yieldBlock (line 147)
14	__TwigTemplate_9ad5cfbef0c2e6203a2efff19c430487->doDisplay (line 388)
15	Twig\Template->yield (line 55)
16	__TwigTemplate_ff9162c379b32f55dd6b4968e5adc3b9->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 262)
25	App\Controller\PageController->news (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 86)
29	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
31	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

0.32 ms
(6.41%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.keywords AS keywords_13, t0.lead_image AS lead_image_14, t0.lead AS lead_15, t0.created AS created_16, t0.updated AS updated_17, t0.lead_home AS lead_home_18, t0.lead_color AS lead_color_19, t0.lead_icon AS lead_icon_20, t0.lead_hidden AS lead_hidden_21, t0.parent_id AS parent_id_22, t0.template_id AS template_id_23 FROM page t0 WHERE t0.in_menu = ? AND t0.parent_id IS NULL AND t0.enabled = ? ORDER BY t0.position DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enabled AS enabled_4,
  t0.in_menu AS in_menu_5,
  t0.in_footer_menu AS in_footer_menu_6,
  t0.menu_name AS menu_name_7,
  t0.position AS position_8,
  t0.redirect AS redirect_9,
  t0.title AS title_10,
  t0.content AS content_11,
  t0.image AS image_12,
  t0.keywords AS keywords_13,
  t0.lead_image AS lead_image_14,
  t0.lead AS lead_15,
  t0.created AS created_16,
  t0.updated AS updated_17,
  t0.lead_home AS lead_home_18,
  t0.lead_color AS lead_color_19,
  t0.lead_icon AS lead_icon_20,
  t0.lead_hidden AS lead_hidden_21,
  t0.parent_id AS parent_id_22,
  t0.template_id AS template_id_23
FROM
  page t0
WHERE
  t0.in_menu = ?
  AND t0.parent_id IS NULL
  AND t0.enabled = ?
ORDER BY
  t0.position DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.keywords AS keywords_13, t0.lead_image AS lead_image_14, t0.lead AS lead_15, t0.created AS created_16, t0.updated AS updated_17, t0.lead_home AS lead_home_18, t0.lead_color AS lead_color_19, t0.lead_icon AS lead_icon_20, t0.lead_hidden AS lead_hidden_21, t0.parent_id AS parent_id_22, t0.template_id AS template_id_23 FROM page t0 WHERE t0.in_menu = 1 AND t0.parent_id IS NULL AND t0.enabled = 1 ORDER BY t0.position DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 314)
4	App\Controller\PageController->_menu (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 348)
12	__TwigTemplate_9ad5cfbef0c2e6203a2efff19c430487->block_main (line 432)
13	Twig\Template->yieldBlock (line 147)
14	__TwigTemplate_9ad5cfbef0c2e6203a2efff19c430487->doDisplay (line 388)
15	Twig\Template->yield (line 55)
16	__TwigTemplate_ff9162c379b32f55dd6b4968e5adc3b9->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 262)
25	App\Controller\PageController->news (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 86)
29	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
31	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

0.30 ms
(6.15%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.slug AS slug_4, t0.description AS description_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.slug IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.enabled AS enabled_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.parent_id AS parent_id_6
FROM
  category t0
WHERE
  t0.slug IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.slug AS slug_4, t0.description AS description_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.slug IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 238)
4	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->findOneBy (line 93)
5	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->apply (line 84)
6	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->applyConverter (line 48)
7	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->apply (line 72)
8	Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener->onKernelController (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 86)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
18	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.24 ms
(4.76%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.slug AS slug_4, t0.description AS description_5, t0.parent_id AS parent_id_6 FROM category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.enabled AS enabled_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.parent_id AS parent_id_6
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.slug AS slug_4, t0.description AS description_5, t0.parent_id AS parent_id_6 FROM category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 250)
5	App\Controller\PageController->news (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 86)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
10	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
11	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Page	36
App\Entity\Settings	9
App\Entity\Category	6
App\Entity\Template	6

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\Tile	No errors.
App\Entity\Settings	No errors.
App\Entity\Page	No errors.
App\Entity\Template	No errors.
App\Entity\Attachment	No errors.
App\Entity\Tag	No errors.
App\Entity\Gallery	No errors.
App\Entity\Resolution	No errors.
App\Entity\Vote	No errors.
App\Entity\UserSubscription	No errors.
App\Entity\Journal	No errors.
App\Entity\Video	No errors.
App\Entity\Specialist	No errors.
App\Entity\Bulletin	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Newsletter	No errors.
App\Entity\Training	No errors.
App\Entity\Slide	No errors.
App\Entity\Message	No errors.
App\Entity\UserMessage	No errors.
App\Entity\User	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://moiib.dev.biolabs.pl/aktualnosci?p=5

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping