Symfony Profiler

Query Metrics

44 Database Queries

7 Different statements

54.46 ms Query time

1 Invalid entities

97 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.58 ms
(28.61%)

SELECT t0.id AS id_1, t0.reg_val AS reg_val_2, t0.reg_pen AS reg_pen_3, t0.reg_wai AS reg_wai_4, t0.reg_req AS reg_req_5, t0.activity_instance_id AS activity_instance_id_6 FROM v_nb_participants_per_activity t0 WHERE t0.activity_instance_id = ?

Parameters:

[
  5321
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reg_val AS reg_val_2,
  t0.reg_pen AS reg_pen_3,
  t0.reg_wai AS reg_wai_4,
  t0.reg_req AS reg_req_5,
  t0.activity_instance_id AS activity_instance_id_6
FROM
  v_nb_participants_per_activity t0
WHERE
  t0.activity_instance_id = ?

SELECT t0.id AS id_1, t0.reg_val AS reg_val_2, t0.reg_pen AS reg_pen_3, t0.reg_wai AS reg_wai_4, t0.reg_req AS reg_req_5, t0.activity_instance_id AS activity_instance_id_6 FROM v_nb_participants_per_activity t0 WHERE t0.activity_instance_id = 5321;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 145)
12	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
13	iterator_to_array (line 45)
14	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
19	Knp\Component\Pager\Paginator->paginate (line 25)
20	ContainerV2f6585\PaginatorProxy9cc2a8f->paginate (line 255)
21	App\Controller\Parent\ActivityParentController->partialActivitiesHomepageAction (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
25	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
26	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
27	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
28	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 85)
29	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->block_body (line 432)
30	Twig\Template->yieldBlock (line 90)
31	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
32	Twig\Template->yield (line 54)
33	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->doDisplay (line 388)
34	Twig\Template->yield (line 344)
35	Twig\Template->display (line 359)
36	Twig\Template->render (line 51)
37	Twig\TemplateWrapper->render (line 334)
38	Twig\Environment->render (line 49)
39	Symfony\Bundle\FrameworkBundle\Controller\TemplateController->templateAction (line 181)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	require_once (line 11)

11.78 ms
(21.62%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM cycle_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  41
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  cycle_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM cycle_translation t0 WHERE t0.translatable_id = 41;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 120)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\Cycle->findTranslationByLocale (line 138)
10	App\Entity\Cycle->doTranslate (line 75)
11	App\Entity\Cycle->translate (line 31)
12	App\Entity\Cycle->__call (line 53)
13	App\Entity\Cycle->__toString (line 1)
14	implode (line 808)
15	Twig\Extension\CoreExtension::join (line 149)
16	__TwigTemplate_59f20f8e0b9374bc4738fa28aefcd10c->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 266)
25	App\Controller\Parent\ActivityParentController->partialActivitiesHomepageAction (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
28	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
29	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
30	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
31	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
32	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 85)
33	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->block_body (line 432)
34	Twig\Template->yieldBlock (line 90)
35	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
36	Twig\Template->yield (line 54)
37	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->doDisplay (line 388)
38	Twig\Template->yield (line 344)
39	Twig\Template->display (line 359)
40	Twig\Template->render (line 51)
41	Twig\TemplateWrapper->render (line 334)
42	Twig\Environment->render (line 49)
43	Symfony\Bundle\FrameworkBundle\Controller\TemplateController->templateAction (line 181)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
46	Symfony\Component\HttpKernel\Kernel->handle (line 35)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
48	require_once (line 11)

10.50 ms
(19.28%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.addInfo AS addInfo_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM activity_instance_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  5321
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.addInfo AS addInfo_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  activity_instance_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.addInfo AS addInfo_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM activity_instance_translation t0 WHERE t0.translatable_id = 5321;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 120)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\ActivityInstance->findTranslationByLocale (line 138)
10	App\Entity\ActivityInstance->doTranslate (line 75)
11	App\Entity\ActivityInstance->translate (line 147)
12	App\Entity\ActivityInstance->__call (line 1882)
13	Twig\Extension\CoreExtension::getAttribute (line 138)
14	__TwigTemplate_59f20f8e0b9374bc4738fa28aefcd10c->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 266)
23	App\Controller\Parent\ActivityParentController->partialActivitiesHomepageAction (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
27	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
28	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
29	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
30	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 85)
31	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->block_body (line 432)
32	Twig\Template->yieldBlock (line 90)
33	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
34	Twig\Template->yield (line 54)
35	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->doDisplay (line 388)
36	Twig\Template->yield (line 344)
37	Twig\Template->display (line 359)
38	Twig\Template->render (line 51)
39	Twig\TemplateWrapper->render (line 334)
40	Twig\Environment->render (line 49)
41	Symfony\Bundle\FrameworkBundle\Controller\TemplateController->templateAction (line 181)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
44	Symfony\Component\HttpKernel\Kernel->handle (line 35)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
46	require_once (line 11)

10.23 ms
(18.78%)

SELECT t0.id AS id_1, t0.order_ihm AS order_ihm_2 FROM cycle t0 INNER JOIN activity_cycle ON t0.id = activity_cycle.cycle_id WHERE activity_cycle.activity_instance_id = ?

Parameters:

[
  5321
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.order_ihm AS order_ihm_2
FROM
  cycle t0
  INNER JOIN activity_cycle ON t0.id = activity_cycle.cycle_id
WHERE
  activity_cycle.activity_instance_id = ?

SELECT t0.id AS id_1, t0.order_ihm AS order_ihm_2 FROM cycle t0 INNER JOIN activity_cycle ON t0.id = activity_cycle.cycle_id WHERE activity_cycle.activity_instance_id = 5321;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 41)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1241)
9	Twig\Extension\CoreExtension::length (line 148)
10	__TwigTemplate_59f20f8e0b9374bc4738fa28aefcd10c->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 266)
19	App\Controller\Parent\ActivityParentController->partialActivitiesHomepageAction (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 85)
27	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->block_body (line 432)
28	Twig\Template->yieldBlock (line 90)
29	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
30	Twig\Template->yield (line 54)
31	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->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 49)
37	Symfony\Bundle\FrameworkBundle\Controller\TemplateController->templateAction (line 181)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 11)

3.27 ms
(6.01%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.day_of_the_week AS day_of_the_week_1, a0_.start_time AS start_time_2, a0_.duration AS duration_3, a0_.cost AS cost_4, a0_.nb_child AS nb_child_5, a0_.nb_waitinglist AS nb_waitinglist_6, a0_.nb_participant AS nb_participant_7, a0_.picture_src AS picture_src_8, a0_.deletedAt AS deletedAt_9 FROM activity_instance a0_ LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id LEFT JOIN period p2_ ON a0_.period_id = p2_.id WHERE (a1_.type_activity = ? AND (? BETWEEN p2_.publicationDate AND p2_.end_registration_date) AND p2_.archived = 0) AND (a0_.deletedAt IS NULL) ORDER BY a0_.id DESC) dctrn_result) dctrn_table

Parameters:

[
  "GRP"
  "2026-05-13 12:47:24"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.day_of_the_week AS day_of_the_week_1,
          a0_.start_time AS start_time_2,
          a0_.duration AS duration_3,
          a0_.cost AS cost_4,
          a0_.nb_child AS nb_child_5,
          a0_.nb_waitinglist AS nb_waitinglist_6,
          a0_.nb_participant AS nb_participant_7,
          a0_.picture_src AS picture_src_8,
          a0_.deletedAt AS deletedAt_9
        FROM
          activity_instance a0_
          LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id
          LEFT JOIN period p2_ ON a0_.period_id = p2_.id
        WHERE
          (
            a1_.type_activity = ?
            AND (
              ? BETWEEN p2_.publicationDate
              AND p2_.end_registration_date
            )
            AND p2_.archived = 0
          )
          AND (a0_.deletedAt IS NULL)
        ORDER BY
          a0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.day_of_the_week AS day_of_the_week_1, a0_.start_time AS start_time_2, a0_.duration AS duration_3, a0_.cost AS cost_4, a0_.nb_child AS nb_child_5, a0_.nb_waitinglist AS nb_waitinglist_6, a0_.nb_participant AS nb_participant_7, a0_.picture_src AS picture_src_8, a0_.deletedAt AS deletedAt_9 FROM activity_instance a0_ LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id LEFT JOIN period p2_ ON a0_.period_id = p2_.id WHERE (a1_.type_activity = 'GRP' AND ('2026-05-13 12:47:24' BETWEEN p2_.publicationDate AND p2_.end_registration_date) AND p2_.archived = 0) AND (a0_.deletedAt IS NULL) ORDER BY a0_.id DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerV2f6585\PaginatorProxy9cc2a8f->paginate (line 255)
16	App\Controller\Parent\ActivityParentController->partialActivitiesHomepageAction (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 85)
24	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->block_body (line 432)
25	Twig\Template->yieldBlock (line 90)
26	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->doDisplay (line 388)
29	Twig\Template->yield (line 344)
30	Twig\Template->display (line 359)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 334)
33	Twig\Environment->render (line 49)
34	Symfony\Bundle\FrameworkBundle\Controller\TemplateController->templateAction (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 11)

1.84 ms
(3.38%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.day_of_the_week AS day_of_the_week_1, a0_.start_time AS start_time_2, a0_.duration AS duration_3, a0_.cost AS cost_4, a0_.nb_child AS nb_child_5, a0_.nb_waitinglist AS nb_waitinglist_6, a0_.nb_participant AS nb_participant_7, a0_.picture_src AS picture_src_8, a0_.deletedAt AS deletedAt_9, a1_.id AS id_10, a1_.type_activity AS type_activity_11, a1_.order_ihm AS order_ihm_12, a1_.level AS level_13, p2_.id AS id_14, p2_.archived AS archived_15, p2_.publicationDate AS publicationDate_16, p2_.registration_start_date AS registration_start_date_17, p2_.member_registration_start_date AS member_registration_start_date_18, p2_.end_registration_date AS end_registration_date_19, p2_.payment_delay AS payment_delay_20, p2_.payment_delay_waiting_list AS payment_delay_waiting_list_21, p2_.cost30min AS cost30min_22, p2_.cost45min AS cost45min_23, p2_.cost60min AS cost60min_24 FROM activity_instance a0_ LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id LEFT JOIN period p2_ ON a0_.period_id = p2_.id WHERE (a1_.type_activity = ? AND (? BETWEEN p2_.publicationDate AND p2_.end_registration_date) AND p2_.archived = 0) AND (a0_.deletedAt IS NULL)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 500

Parameters:

[
  "GRP"
  "2026-05-13 12:47:24"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.day_of_the_week AS day_of_the_week_1,
          a0_.start_time AS start_time_2,
          a0_.duration AS duration_3,
          a0_.cost AS cost_4,
          a0_.nb_child AS nb_child_5,
          a0_.nb_waitinglist AS nb_waitinglist_6,
          a0_.nb_participant AS nb_participant_7,
          a0_.picture_src AS picture_src_8,
          a0_.deletedAt AS deletedAt_9,
          a1_.id AS id_10,
          a1_.type_activity AS type_activity_11,
          a1_.order_ihm AS order_ihm_12,
          a1_.level AS level_13,
          p2_.id AS id_14,
          p2_.archived AS archived_15,
          p2_.publicationDate AS publicationDate_16,
          p2_.registration_start_date AS registration_start_date_17,
          p2_.member_registration_start_date AS member_registration_start_date_18,
          p2_.end_registration_date AS end_registration_date_19,
          p2_.payment_delay AS payment_delay_20,
          p2_.payment_delay_waiting_list AS payment_delay_waiting_list_21,
          p2_.cost30min AS cost30min_22,
          p2_.cost45min AS cost45min_23,
          p2_.cost60min AS cost60min_24
        FROM
          activity_instance a0_
          LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id
          LEFT JOIN period p2_ ON a0_.period_id = p2_.id
        WHERE
          (
            a1_.type_activity = ?
            AND (
              ? BETWEEN p2_.publicationDate
              AND p2_.end_registration_date
            )
            AND p2_.archived = 0
          )
          AND (a0_.deletedAt IS NULL)
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  500

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.day_of_the_week AS day_of_the_week_1, a0_.start_time AS start_time_2, a0_.duration AS duration_3, a0_.cost AS cost_4, a0_.nb_child AS nb_child_5, a0_.nb_waitinglist AS nb_waitinglist_6, a0_.nb_participant AS nb_participant_7, a0_.picture_src AS picture_src_8, a0_.deletedAt AS deletedAt_9, a1_.id AS id_10, a1_.type_activity AS type_activity_11, a1_.order_ihm AS order_ihm_12, a1_.level AS level_13, p2_.id AS id_14, p2_.archived AS archived_15, p2_.publicationDate AS publicationDate_16, p2_.registration_start_date AS registration_start_date_17, p2_.member_registration_start_date AS member_registration_start_date_18, p2_.end_registration_date AS end_registration_date_19, p2_.payment_delay AS payment_delay_20, p2_.payment_delay_waiting_list AS payment_delay_waiting_list_21, p2_.cost30min AS cost30min_22, p2_.cost45min AS cost45min_23, p2_.cost60min AS cost60min_24 FROM activity_instance a0_ LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id LEFT JOIN period p2_ ON a0_.period_id = p2_.id WHERE (a1_.type_activity = 'GRP' AND ('2026-05-13 12:47:24' BETWEEN p2_.publicationDate AND p2_.end_registration_date) AND p2_.archived = 0) AND (a0_.deletedAt IS NULL)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 500;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerV2f6585\PaginatorProxy9cc2a8f->paginate (line 255)
16	App\Controller\Parent\ActivityParentController->partialActivitiesHomepageAction (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 85)
24	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->block_body (line 432)
25	Twig\Template->yieldBlock (line 90)
26	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->doDisplay (line 388)
29	Twig\Template->yield (line 344)
30	Twig\Template->display (line 359)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 334)
33	Twig\Environment->render (line 49)
34	Symfony\Bundle\FrameworkBundle\Controller\TemplateController->templateAction (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 11)

1.26 ms
(2.31%)

SELECT a0_.id AS id_0, a0_.day_of_the_week AS day_of_the_week_1, a0_.start_time AS start_time_2, a0_.duration AS duration_3, a0_.cost AS cost_4, a0_.nb_child AS nb_child_5, a0_.nb_waitinglist AS nb_waitinglist_6, a0_.nb_participant AS nb_participant_7, a0_.picture_src AS picture_src_8, a0_.deletedAt AS deletedAt_9, a0_.activity_category_id AS activity_category_id_10, a0_.default_classroom_id AS default_classroom_id_11, a0_.period_id AS period_id_12, a0_.building_id AS building_id_13, a0_.activity_instance_id_src_copy AS activity_instance_id_src_copy_14 FROM activity_instance a0_ LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id LEFT JOIN period p2_ ON a0_.period_id = p2_.id WHERE (a1_.type_activity = ? AND (? BETWEEN p2_.publicationDate AND p2_.end_registration_date) AND p2_.archived = 0 AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (a0_.deletedAt IS NULL) ORDER BY a0_.id DESC

Parameters:

[
  "GRP"
  "2026-05-13 12:47:24"
  5321
  5320
  5319
  5318
  5317
  5315
  5313
  5312
  5311
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.day_of_the_week AS day_of_the_week_1,
  a0_.start_time AS start_time_2,
  a0_.duration AS duration_3,
  a0_.cost AS cost_4,
  a0_.nb_child AS nb_child_5,
  a0_.nb_waitinglist AS nb_waitinglist_6,
  a0_.nb_participant AS nb_participant_7,
  a0_.picture_src AS picture_src_8,
  a0_.deletedAt AS deletedAt_9,
  a0_.activity_category_id AS activity_category_id_10,
  a0_.default_classroom_id AS default_classroom_id_11,
  a0_.period_id AS period_id_12,
  a0_.building_id AS building_id_13,
  a0_.activity_instance_id_src_copy AS activity_instance_id_src_copy_14
FROM
  activity_instance a0_
  LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id
  LEFT JOIN period p2_ ON a0_.period_id = p2_.id
WHERE
  (
    a1_.type_activity = ?
    AND (
      ? BETWEEN p2_.publicationDate
      AND p2_.end_registration_date
    )
    AND p2_.archived = 0
    AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND (a0_.deletedAt IS NULL)
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.day_of_the_week AS day_of_the_week_1, a0_.start_time AS start_time_2, a0_.duration AS duration_3, a0_.cost AS cost_4, a0_.nb_child AS nb_child_5, a0_.nb_waitinglist AS nb_waitinglist_6, a0_.nb_participant AS nb_participant_7, a0_.picture_src AS picture_src_8, a0_.deletedAt AS deletedAt_9, a0_.activity_category_id AS activity_category_id_10, a0_.default_classroom_id AS default_classroom_id_11, a0_.period_id AS period_id_12, a0_.building_id AS building_id_13, a0_.activity_instance_id_src_copy AS activity_instance_id_src_copy_14 FROM activity_instance a0_ LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id LEFT JOIN period p2_ ON a0_.period_id = p2_.id WHERE (a1_.type_activity = 'GRP' AND ('2026-05-13 12:47:24' BETWEEN p2_.publicationDate AND p2_.end_registration_date) AND p2_.archived = 0 AND a0_.id IN (5321, 5320, 5319, 5318, 5317, 5315, 5313, 5312, 5311)) AND (a0_.deletedAt IS NULL) ORDER BY a0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerV2f6585\PaginatorProxy9cc2a8f->paginate (line 255)
16	App\Controller\Parent\ActivityParentController->partialActivitiesHomepageAction (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 85)
24	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->block_body (line 432)
25	Twig\Template->yieldBlock (line 90)
26	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_8512d5a1d01be837b138c136033d2fac->doDisplay (line 388)
29	Twig\Template->yield (line 344)
30	Twig\Template->display (line 359)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 334)
33	Twig\Environment->render (line 49)
34	Symfony\Bundle\FrameworkBundle\Controller\TemplateController->templateAction (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 11)

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\CycleTranslation	28
App\Entity\ActivityInstanceTranslation	18
App\Entity\ActivityInstance	16
App\Entity\Cycle	14
App\Entity\VNbParticipantsPerActivity	9
App\Entity\Classroom	7
App\Entity\Period	2
App\Entity\Building	2
App\Entity\ActivityCategory	1

Entities Mapping

Class	Mapping errors
App\Entity\ActivityInstance	No errors.
App\Entity\ActivityCategory	No errors.
App\Entity\Classroom	No errors.
App\Entity\Period	No errors.
App\Entity\Building	No errors.
App\Entity\Registration	The field App\Entity\Registration#registrationAcc is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Registration#registrationActivity does not contain the required 'inversedBy="registrationAcc"' attribute.
App\Entity\VNbParticipantsPerActivity	No errors.
App\Entity\User	No errors.
App\Entity\Language	No errors.
App\Entity\Cycle	No errors.
App\Entity\ActivityInstanceTranslation	No errors.
App\Entity\CycleTranslation	No errors.

Symfony Profiler

GET http://periscolaire.apeeel1.lu/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CParent%255CActivityParentController%253A%253…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping