Symfony Profiler

Query Metrics

8 Database Queries

5 Different statements

3.34 ms Query time

0 Invalid entities

Show all queries

Time▼

Count

Info

0.95 ms
(28.48%)

SELECT t0.id AS id_1, t0.time_from AS time_from_2, t0.time_to AS time_to_3, t0.name AS name_4, t0.slug AS slug_5, t0.enabled AS enabled_6, t0.repeat_for AS repeat_for_7, t0.startdate AS startdate_8, t0.members_limit AS members_limit_9, t0.created AS created_10, t0.updated AS updated_11, t0.booking_start_date AS booking_start_date_12, t0.nobooking AS nobooking_13, t0.image AS image_14, t0.content AS content_15, t0.color AS color_16, t0.inactive_to AS inactive_to_17, t0.inactive_from AS inactive_from_18, t0.type AS type_19 FROM event t0 WHERE t0.slug = ? LIMIT 1

Parameters:

  0 of 0   
[▼
  "kurs-przygotowawczy-do-egzaminow-elektroenergetycznych-grupa-i-2025-02-18-1000"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.time_from AS time_from_2,
  t0.time_to AS time_to_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.enabled AS enabled_6,
  t0.repeat_for AS repeat_for_7,
  t0.startdate AS startdate_8,
  t0.members_limit AS members_limit_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.booking_start_date AS booking_start_date_12,
  t0.nobooking AS nobooking_13,
  t0.image AS image_14,
  t0.content AS content_15,
  t0.color AS color_16,
  t0.inactive_to AS inactive_to_17,
  t0.inactive_from AS inactive_from_18,
  t0.type AS type_19
FROM
  event t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.time_from AS time_from_2, t0.time_to AS time_to_3, t0.name AS name_4, t0.slug AS slug_5, t0.enabled AS enabled_6, t0.repeat_for AS repeat_for_7, t0.startdate AS startdate_8, t0.members_limit AS members_limit_9, t0.created AS created_10, t0.updated AS updated_11, t0.booking_start_date AS booking_start_date_12, t0.nobooking AS nobooking_13, t0.image AS image_14, t0.content AS content_15, t0.color AS color_16, t0.inactive_to AS inactive_to_17, t0.inactive_from AS inactive_from_18, t0.type AS type_19 FROM event t0 WHERE t0.slug = 'kurs-przygotowawczy-do-egzaminow-elektroenergetycznych-grupa-i-2025-02-18-1000' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
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 473)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
18	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
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.86 ms
(25.75%)

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.image2 AS image2_13, t0.keywords AS keywords_14, t0.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 FROM PAGE t0 WHERE t0.parent_id = ? ORDER BY t0.position DESC

Parameters:

  0 of 0   
[▼
  4
]

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.image2 AS image2_13,
  t0.keywords AS keywords_14,
  t0.lead_image AS lead_image_15,
  t0.lead AS lead_16,
  t0.created AS created_17,
  t0.updated AS updated_18,
  t0.parent_id AS parent_id_19,
  t0.template_id AS template_id_20
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.image2 AS image2_13, t0.keywords AS keywords_14, t0.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 FROM PAGE t0 WHERE t0.parent_id = 4 ORDER BY t0.position DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3304)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 128)
8	__TwigTemplate_4dacd3495170ac8e41ecc91d4cad158b->doDisplay (line 360)
9	Twig\Template->yield (line 335)
10	Twig\Template->render (line 38)
11	Twig\TemplateWrapper->render (line 307)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 233)
16	App\Controller\PageController->_menu (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
20	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
21	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
22	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
23	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 556)
24	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->block_pageheader (line 430)
25	Twig\Template->yieldBlock (line 395)
26	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->block_main (line 430)
27	Twig\Template->yieldBlock (line 141)
28	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->doDisplay (line 360)
29	Twig\Template->yield (line 51)
30	__TwigTemplate_a3e6165cc54531f4d466111e96e439b1->doDisplay (line 360)
31	Twig\Template->yield (line 335)
32	Twig\Template->render (line 38)
33	Twig\TemplateWrapper->render (line 307)
34	Twig\Environment->render (line 448)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 288)
38	App\Controller\EventController->event (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
41	Symfony\Component\HttpKernel\Kernel->handle (line 86)
42	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
43	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
44	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
45	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
46	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
47	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
48	Symfony\Component\HttpKernel\Kernel->handle (line 35)
49	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
50	require_once (line 5)

0.82 ms
(24.64%)

SELECT COUNT(e0_.id) AS sclr_0 FROM event_member e0_ WHERE e0_.event_id = ? AND e0_.event_date = ?

Parameters:

  0 of 0   
[▼
  85
  "2025-03-18 10:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  event_member e0_
WHERE
  e0_.event_id = ?
  AND e0_.event_date = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM event_member e0_ WHERE e0_.event_id = 85 AND e0_.event_date = '2025-03-18 10:00:00';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 991)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1020)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 54)
8	App\Repository\EventMemberRepository->findMembersCount (line 217)
9	App\Controller\EventController->event (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
15	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.41 ms
(12.32%)

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 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 25)
5	App\Service\SettingsService->get (line 1629)
6	Twig\Extension\CoreExtension::getAttribute (line 300)
7	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->block_main (line 430)
8	Twig\Template->yieldBlock (line 141)
9	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->doDisplay (line 360)
10	Twig\Template->yield (line 51)
11	__TwigTemplate_a3e6165cc54531f4d466111e96e439b1->doDisplay (line 360)
12	Twig\Template->yield (line 335)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 307)
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 288)
19	App\Controller\EventController->event (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
25	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.29 ms
(8.81%)

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.image2 AS image2_13, t0.keywords AS keywords_14, t0.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 FROM PAGE t0 WHERE t0.in_menu = ? AND t0.parent_id IS NULL AND t0.enabled = ? ORDER BY t0.position DESC

Parameters:

  0 of 0   
[▼
  1
  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.image2 AS image2_13,
  t0.keywords AS keywords_14,
  t0.lead_image AS lead_image_15,
  t0.lead AS lead_16,
  t0.created AS created_17,
  t0.updated AS updated_18,
  t0.parent_id AS parent_id_19,
  t0.template_id AS template_id_20
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.image2 AS image2_13, t0.keywords AS keywords_14, t0.lead_image AS lead_image_15, t0.lead AS lead_16, t0.created AS created_17, t0.updated AS updated_18, t0.parent_id AS parent_id_19, t0.template_id AS template_id_20 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 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 229)
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 556)
12	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->block_pageheader (line 430)
13	Twig\Template->yieldBlock (line 395)
14	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->block_main (line 430)
15	Twig\Template->yieldBlock (line 141)
16	__TwigTemplate_d335d86ee731b161d66f195c88d5a5de->doDisplay (line 360)
17	Twig\Template->yield (line 51)
18	__TwigTemplate_a3e6165cc54531f4d466111e96e439b1->doDisplay (line 360)
19	Twig\Template->yield (line 335)
20	Twig\Template->render (line 38)
21	Twig\TemplateWrapper->render (line 307)
22	Twig\Environment->render (line 448)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 288)
26	App\Controller\EventController->event (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 86)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
32	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Class	Mapping errors
App\Entity\Event	No errors.
App\Entity\EventMember	No errors.
App\Entity\Settings	No errors.
App\Entity\Page	No errors.
App\Entity\Template	No errors.
App\Entity\Attachment	No errors.

Symfony Profiler

GET https://sep.dev.biolabs.pl/_fragment?_path=_format%3Dhtml%26_locale%3Dpl%26_controller%3DApp%255CController%255CPageController%253A%253A_menu

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

GET https://sep.dev.biolabs.pl/_fragment?_path=_format%3Dhtml%26_locale%3Dpl%26_controller%3DApp%255CController%255CPageController%253A%253A_menu

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping