Symfony Profiler

Query Metrics

38 Database Queries

10 Different statements

58.28 ms Query time

1 Invalid entities

57 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

20.20 ms
(34.66%)

SELECT t0.id AS id_1, t0.day_of_the_week AS day_of_the_week_2, t0.start_time AS start_time_3, t0.duration AS duration_4, t0.cost AS cost_5, t0.nb_child AS nb_child_6, t0.nb_waitinglist AS nb_waitinglist_7, t0.nb_participant AS nb_participant_8, t0.picture_src AS picture_src_9, t0.deletedAt AS deletedAt_10, t0.activity_category_id AS activity_category_id_11, t0.default_classroom_id AS default_classroom_id_12, t0.period_id AS period_id_13, t0.building_id AS building_id_14, t15.id AS id_16, t15.reg_val AS reg_val_17, t15.reg_pen AS reg_pen_18, t15.reg_wai AS reg_wai_19, t15.reg_req AS reg_req_20, t15.activity_instance_id AS activity_instance_id_21, t0.activity_instance_id_src_copy AS activity_instance_id_src_copy_22 FROM activity_instance t0 LEFT JOIN v_nb_participants_per_activity t15 ON t15.activity_instance_id = t0.id WHERE t0.id = ? AND ((t0.deletedAt IS NULL))

Parameters:

[
  "5317"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.day_of_the_week AS day_of_the_week_2,
  t0.start_time AS start_time_3,
  t0.duration AS duration_4,
  t0.cost AS cost_5,
  t0.nb_child AS nb_child_6,
  t0.nb_waitinglist AS nb_waitinglist_7,
  t0.nb_participant AS nb_participant_8,
  t0.picture_src AS picture_src_9,
  t0.deletedAt AS deletedAt_10,
  t0.activity_category_id AS activity_category_id_11,
  t0.default_classroom_id AS default_classroom_id_12,
  t0.period_id AS period_id_13,
  t0.building_id AS building_id_14,
  t15.id AS id_16,
  t15.reg_val AS reg_val_17,
  t15.reg_pen AS reg_pen_18,
  t15.reg_wai AS reg_wai_19,
  t15.reg_req AS reg_req_20,
  t15.activity_instance_id AS activity_instance_id_21,
  t0.activity_instance_id_src_copy AS activity_instance_id_src_copy_22
FROM
  activity_instance t0
  LEFT JOIN v_nb_participants_per_activity t15 ON t15.activity_instance_id = t0.id
WHERE
  t0.id = ?
  AND (
    (t0.deletedAt IS NULL)
  )

SELECT t0.id AS id_1, t0.day_of_the_week AS day_of_the_week_2, t0.start_time AS start_time_3, t0.duration AS duration_4, t0.cost AS cost_5, t0.nb_child AS nb_child_6, t0.nb_waitinglist AS nb_waitinglist_7, t0.nb_participant AS nb_participant_8, t0.picture_src AS picture_src_9, t0.deletedAt AS deletedAt_10, t0.activity_category_id AS activity_category_id_11, t0.default_classroom_id AS default_classroom_id_12, t0.period_id AS period_id_13, t0.building_id AS building_id_14, t15.id AS id_16, t15.reg_val AS reg_val_17, t15.reg_pen AS reg_pen_18, t15.reg_wai AS reg_wai_19, t15.reg_req AS reg_req_20, t15.activity_instance_id AS activity_instance_id_21, t0.activity_instance_id_src_copy AS activity_instance_id_src_copy_22 FROM activity_instance t0 LEFT JOIN v_nb_participants_per_activity t15 ON t15.activity_instance_id = t0.id WHERE t0.id = '5317' AND ((t0.deletedAt IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 11)

15.29 ms
(26.24%)

SELECT m0_.id AS id_0, m0_.route AS route_1, m0_.param_name AS param_name_2, m0_.param_value AS param_value_3, m0_.roles AS roles_4, m0_.public AS public_5, m0_.icon AS icon_6, m0_.order_ihm AS order_ihm_7, m0_.parent_id AS parent_id_8 FROM menu_item m0_ WHERE m0_.parent_id = ? AND (m0_.roles IN (?) OR m0_.public = 1) ORDER BY m0_.order_ihm ASC

Parameters:

[
  1
  "ROLE_PARENT"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.route AS route_1,
  m0_.param_name AS param_name_2,
  m0_.param_value AS param_value_3,
  m0_.roles AS roles_4,
  m0_.public AS public_5,
  m0_.icon AS icon_6,
  m0_.order_ihm AS order_ihm_7,
  m0_.parent_id AS parent_id_8
FROM
  menu_item m0_
WHERE
  m0_.parent_id = ?
  AND (
    m0_.roles IN (?)
    OR m0_.public = 1
  )
ORDER BY
  m0_.order_ihm ASC

SELECT m0_.id AS id_0, m0_.route AS route_1, m0_.param_name AS param_name_2, m0_.param_value AS param_value_3, m0_.roles AS roles_4, m0_.public AS public_5, m0_.icon AS icon_6, m0_.order_ihm AS order_ihm_7, m0_.parent_id AS parent_id_8 FROM menu_item m0_ WHERE m0_.parent_id = 1 AND (m0_.roles IN ('ROLE_PARENT') OR m0_.public = 1) ORDER BY m0_.order_ihm ASC;

#	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 60)
7	App\Repository\MenuItemRepository->findItemsByParentAndRole (line 87)
8	App\Menu\MenuBuilder->getMenuItems (line 48)
9	App\Menu\MenuBuilder->buildMenu (line 80)
10	App\Menu\MenuBuilder->buildMenu (line 38)
11	App\Menu\MenuBuilder->createMainMenu (line 41)
12	Knp\Menu\Provider\LazyProvider->get (line 29)
13	Knp\Menu\Provider\ChainProvider->get (line 43)
14	Knp\Menu\Twig\Helper->get (line 138)
15	Knp\Menu\Twig\Helper->castMenu (line 71)
16	Knp\Menu\Twig\Helper->render (line 45)
17	Knp\Menu\Twig\MenuRuntimeExtension->render (line 151)
18	__TwigTemplate_5f0d25271c01726ddbe50c1ba6b67b5f->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 13)
27	App\Controller\TemplateController->template (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
31	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
32	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
33	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
34	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 187)
35	__TwigTemplate_694646425ea428b0526066193de59e9f->block_header (line 432)
36	Twig\Template->yieldBlock (line 81)
37	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
38	Twig\Template->yield (line 58)
39	__TwigTemplate_40a07fb0ba92cc4ec4994337d805b21b->doDisplay (line 388)
40	Twig\Template->yield (line 344)
41	Twig\Template->display (line 359)
42	Twig\Template->render (line 51)
43	Twig\TemplateWrapper->render (line 334)
44	Twig\Environment->render (line 448)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 215)
48	App\Controller\Parent\ActivityParentController->subscribeAction (line 181)
49	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
50	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
51	Symfony\Component\HttpKernel\Kernel->handle (line 35)
52	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
53	require_once (line 11)

12.66 ms
(21.72%)

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

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.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  menu_item_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 menu_item_translation t0 WHERE t0.translatable_id = 1;

#	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\MenuItem->findTranslationByLocale (line 138)
10	App\Entity\MenuItem->doTranslate (line 75)
11	App\Entity\MenuItem->translate (line 55)
12	App\Entity\MenuItem->__call (line 59)
13	App\Menu\MenuBuilder->buildMenu (line 38)
14	App\Menu\MenuBuilder->createMainMenu (line 41)
15	Knp\Menu\Provider\LazyProvider->get (line 29)
16	Knp\Menu\Provider\ChainProvider->get (line 43)
17	Knp\Menu\Twig\Helper->get (line 138)
18	Knp\Menu\Twig\Helper->castMenu (line 71)
19	Knp\Menu\Twig\Helper->render (line 45)
20	Knp\Menu\Twig\MenuRuntimeExtension->render (line 151)
21	__TwigTemplate_5f0d25271c01726ddbe50c1ba6b67b5f->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 448)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 13)
30	App\Controller\TemplateController->template (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
33	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
34	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
35	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
36	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
37	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 187)
38	__TwigTemplate_694646425ea428b0526066193de59e9f->block_header (line 432)
39	Twig\Template->yieldBlock (line 81)
40	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
41	Twig\Template->yield (line 58)
42	__TwigTemplate_40a07fb0ba92cc4ec4994337d805b21b->doDisplay (line 388)
43	Twig\Template->yield (line 344)
44	Twig\Template->display (line 359)
45	Twig\Template->render (line 51)
46	Twig\TemplateWrapper->render (line 334)
47	Twig\Environment->render (line 448)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
49	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
50	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 215)
51	App\Controller\Parent\ActivityParentController->subscribeAction (line 181)
52	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
53	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
54	Symfony\Component\HttpKernel\Kernel->handle (line 35)
55	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
56	require_once (line 11)

2.30 ms
(3.95%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.firstname AS firstname_2, c0_.class AS class_3, c0_.teacher AS teacher_4, c0_.birthdate AS birthdate_5, c0_.data_valid AS data_valid_6, c0_.cycle_id AS cycle_id_7, c0_.fos_user_id AS fos_user_id_8 FROM child c0_ WHERE (c0_.id NOT IN (SELECT r1_.child_id AS sclr_9 FROM registration r1_, registration_status r2_ WHERE (r1_.activity_instance_id = ? AND r1_.registration_status_id = r2_.id AND r2_.code <> ?) AND (r1_.deletedAt IS NULL))) AND c0_.data_valid = ? AND c0_.fos_user_id = ? ORDER BY c0_.name ASC

Parameters:

[
  5317
  "CAN"
  1
  4976
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.firstname AS firstname_2,
  c0_.class AS class_3,
  c0_.teacher AS teacher_4,
  c0_.birthdate AS birthdate_5,
  c0_.data_valid AS data_valid_6,
  c0_.cycle_id AS cycle_id_7,
  c0_.fos_user_id AS fos_user_id_8
FROM
  child c0_
WHERE
  (
    c0_.id NOT IN (
      SELECT
        r1_.child_id AS sclr_9
      FROM
        registration r1_,
        registration_status r2_
      WHERE
        (
          r1_.activity_instance_id = ?
          AND r1_.registration_status_id = r2_.id
          AND r2_.code <> ?
        )
        AND (r1_.deletedAt IS NULL)
    )
  )
  AND c0_.data_valid = ?
  AND c0_.fos_user_id = ?
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.firstname AS firstname_2, c0_.class AS class_3, c0_.teacher AS teacher_4, c0_.birthdate AS birthdate_5, c0_.data_valid AS data_valid_6, c0_.cycle_id AS cycle_id_7, c0_.fos_user_id AS fos_user_id_8 FROM child c0_ WHERE (c0_.id NOT IN (SELECT r1_.child_id AS sclr_9 FROM registration r1_, registration_status r2_ WHERE (r1_.activity_instance_id = 5317 AND r1_.registration_status_id = r2_.id AND r2_.code <> 'CAN') AND (r1_.deletedAt IS NULL))) AND c0_.data_valid = 1 AND c0_.fos_user_id = 4976 ORDER BY c0_.name ASC;

#	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 64)
7	App\Repository\ChildRepository->getChildren (line 140)
8	App\Controller\Parent\ActivityParentController->subscribeAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 11)

1.66 ms
(2.84%)

SELECT t0.id AS id_1, t0.day_of_the_week AS day_of_the_week_2, t0.start_time AS start_time_3, t0.duration AS duration_4, t0.cost AS cost_5, t0.nb_child AS nb_child_6, t0.nb_waitinglist AS nb_waitinglist_7, t0.nb_participant AS nb_participant_8, t0.picture_src AS picture_src_9, t0.deletedAt AS deletedAt_10, t0.activity_category_id AS activity_category_id_11, t0.default_classroom_id AS default_classroom_id_12, t0.period_id AS period_id_13, t0.building_id AS building_id_14, t15.id AS id_16, t15.reg_val AS reg_val_17, t15.reg_pen AS reg_pen_18, t15.reg_wai AS reg_wai_19, t15.reg_req AS reg_req_20, t15.activity_instance_id AS activity_instance_id_21, t0.activity_instance_id_src_copy AS activity_instance_id_src_copy_22 FROM activity_instance t0 LEFT JOIN v_nb_participants_per_activity t15 ON t15.activity_instance_id = t0.id INNER JOIN support_activities ON t0.id = support_activities.support_activity_id WHERE support_activities.activity_id = ? AND ((t0.deletedAt IS NULL))

Parameters:

[
  5317
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.day_of_the_week AS day_of_the_week_2,
  t0.start_time AS start_time_3,
  t0.duration AS duration_4,
  t0.cost AS cost_5,
  t0.nb_child AS nb_child_6,
  t0.nb_waitinglist AS nb_waitinglist_7,
  t0.nb_participant AS nb_participant_8,
  t0.picture_src AS picture_src_9,
  t0.deletedAt AS deletedAt_10,
  t0.activity_category_id AS activity_category_id_11,
  t0.default_classroom_id AS default_classroom_id_12,
  t0.period_id AS period_id_13,
  t0.building_id AS building_id_14,
  t15.id AS id_16,
  t15.reg_val AS reg_val_17,
  t15.reg_pen AS reg_pen_18,
  t15.reg_wai AS reg_wai_19,
  t15.reg_req AS reg_req_20,
  t15.activity_instance_id AS activity_instance_id_21,
  t0.activity_instance_id_src_copy AS activity_instance_id_src_copy_22
FROM
  activity_instance t0
  LEFT JOIN v_nb_participants_per_activity t15 ON t15.activity_instance_id = t0.id
  INNER JOIN support_activities ON t0.id = support_activities.support_activity_id
WHERE
  support_activities.activity_id = ?
  AND (
    (t0.deletedAt IS NULL)
  )

SELECT t0.id AS id_1, t0.day_of_the_week AS day_of_the_week_2, t0.start_time AS start_time_3, t0.duration AS duration_4, t0.cost AS cost_5, t0.nb_child AS nb_child_6, t0.nb_waitinglist AS nb_waitinglist_7, t0.nb_participant AS nb_participant_8, t0.picture_src AS picture_src_9, t0.deletedAt AS deletedAt_10, t0.activity_category_id AS activity_category_id_11, t0.default_classroom_id AS default_classroom_id_12, t0.period_id AS period_id_13, t0.building_id AS building_id_14, t15.id AS id_16, t15.reg_val AS reg_val_17, t15.reg_pen AS reg_pen_18, t15.reg_wai AS reg_wai_19, t15.reg_req AS reg_req_20, t15.activity_instance_id AS activity_instance_id_21, t0.activity_instance_id_src_copy AS activity_instance_id_src_copy_22 FROM activity_instance t0 LEFT JOIN v_nb_participants_per_activity t15 ON t15.activity_instance_id = t0.id INNER JOIN support_activities ON t0.id = support_activities.support_activity_id WHERE support_activities.activity_id = 5317 AND ((t0.deletedAt IS NULL));

#	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 446)
9	Doctrine\ORM\PersistentCollection->isEmpty (line 36)
10	App\Form\Parent\SubscribeFormType->buildForm (line 102)
11	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
12	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
13	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
14	Symfony\Component\Form\FormFactory->createBuilder (line 28)
15	Symfony\Component\Form\FormFactory->create (line 340)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 143)
17	App\Controller\Parent\ActivityParentController->subscribeAction (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 11)

1.45 ms
(2.49%)

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.is_valid AS is_valid_3, t0.email AS email_4, t0.auth_code AS auth_code_5, t0.password AS password_6, t0.password_requested_at AS password_requested_at_7, t0.password_changed_at AS password_changed_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.username_canonical AS username_canonical_11, t0.email_canonical AS email_canonical_12, t0.last_login AS last_login_13, t0.email_verified_at AS email_verified_at_14, t0.lastname AS lastname_15, t0.firstname AS firstname_16, t0.street AS street_17, t0.city AS city_18, t0.zipcode AS zipcode_19, t0.phone AS phone_20, t0.officephone AS officephone_21, t0.homephone AS homephone_22, t0.membercode AS membercode_23, t0.locale AS locale_24, t0.dpo AS dpo_25, t0.agree_sens_data AS agree_sens_data_26, t0.member AS member_27, t0.membername AS membername_28, t0.confirmation_token AS confirmation_token_29, t0.membership_reason AS membership_reason_30, t0.description AS description_31, t0.contact_email AS contact_email_32 FROM fos_user t0 WHERE t0.id = ?

Parameters:

[
  4976
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.is_valid AS is_valid_3,
  t0.email AS email_4,
  t0.auth_code AS auth_code_5,
  t0.password AS password_6,
  t0.password_requested_at AS password_requested_at_7,
  t0.password_changed_at AS password_changed_at_8,
  t0.roles AS roles_9,
  t0.username AS username_10,
  t0.username_canonical AS username_canonical_11,
  t0.email_canonical AS email_canonical_12,
  t0.last_login AS last_login_13,
  t0.email_verified_at AS email_verified_at_14,
  t0.lastname AS lastname_15,
  t0.firstname AS firstname_16,
  t0.street AS street_17,
  t0.city AS city_18,
  t0.zipcode AS zipcode_19,
  t0.phone AS phone_20,
  t0.officephone AS officephone_21,
  t0.homephone AS homephone_22,
  t0.membercode AS membercode_23,
  t0.locale AS locale_24,
  t0.dpo AS dpo_25,
  t0.agree_sens_data AS agree_sens_data_26,
  t0.member AS member_27,
  t0.membername AS membername_28,
  t0.confirmation_token AS confirmation_token_29,
  t0.membership_reason AS membership_reason_30,
  t0.description AS description_31,
  t0.contact_email AS contact_email_32
FROM
  fos_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.is_valid AS is_valid_3, t0.email AS email_4, t0.auth_code AS auth_code_5, t0.password AS password_6, t0.password_requested_at AS password_requested_at_7, t0.password_changed_at AS password_changed_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.username_canonical AS username_canonical_11, t0.email_canonical AS email_canonical_12, t0.last_login AS last_login_13, t0.email_verified_at AS email_verified_at_14, t0.lastname AS lastname_15, t0.firstname AS firstname_16, t0.street AS street_17, t0.city AS city_18, t0.zipcode AS zipcode_19, t0.phone AS phone_20, t0.officephone AS officephone_21, t0.homephone AS homephone_22, t0.membercode AS membercode_23, t0.locale AS locale_24, t0.dpo AS dpo_25, t0.agree_sens_data AS agree_sens_data_26, t0.member AS member_27, t0.membername AS membername_28, t0.confirmation_token AS confirmation_token_29, t0.membership_reason AS membership_reason_30, t0.description AS description_31, t0.contact_email AS contact_email_32 FROM fos_user t0 WHERE t0.id = 4976;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 99)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 11)

1.42 ms
(2.44%)

SELECT m0_.id AS id_0, m0_.route AS route_1, m0_.param_name AS param_name_2, m0_.param_value AS param_value_3, m0_.roles AS roles_4, m0_.public AS public_5, m0_.icon AS icon_6, m0_.order_ihm AS order_ihm_7, m0_.parent_id AS parent_id_8 FROM menu_item m0_ WHERE m0_.parent_id IS NULL AND (m0_.roles IN (?) OR m0_.public = 1) ORDER BY m0_.order_ihm ASC

Parameters:

[
  "ROLE_PARENT"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.route AS route_1,
  m0_.param_name AS param_name_2,
  m0_.param_value AS param_value_3,
  m0_.roles AS roles_4,
  m0_.public AS public_5,
  m0_.icon AS icon_6,
  m0_.order_ihm AS order_ihm_7,
  m0_.parent_id AS parent_id_8
FROM
  menu_item m0_
WHERE
  m0_.parent_id IS NULL
  AND (
    m0_.roles IN (?)
    OR m0_.public = 1
  )
ORDER BY
  m0_.order_ihm ASC

SELECT m0_.id AS id_0, m0_.route AS route_1, m0_.param_name AS param_name_2, m0_.param_value AS param_value_3, m0_.roles AS roles_4, m0_.public AS public_5, m0_.icon AS icon_6, m0_.order_ihm AS order_ihm_7, m0_.parent_id AS parent_id_8 FROM menu_item m0_ WHERE m0_.parent_id IS NULL AND (m0_.roles IN ('ROLE_PARENT') OR m0_.public = 1) ORDER BY m0_.order_ihm ASC;

#	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 60)
7	App\Repository\MenuItemRepository->findItemsByParentAndRole (line 87)
8	App\Menu\MenuBuilder->getMenuItems (line 48)
9	App\Menu\MenuBuilder->buildMenu (line 38)
10	App\Menu\MenuBuilder->createMainMenu (line 41)
11	Knp\Menu\Provider\LazyProvider->get (line 29)
12	Knp\Menu\Provider\ChainProvider->get (line 43)
13	Knp\Menu\Twig\Helper->get (line 138)
14	Knp\Menu\Twig\Helper->castMenu (line 71)
15	Knp\Menu\Twig\Helper->render (line 45)
16	Knp\Menu\Twig\MenuRuntimeExtension->render (line 151)
17	__TwigTemplate_5f0d25271c01726ddbe50c1ba6b67b5f->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 334)
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 13)
26	App\Controller\TemplateController->template (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
29	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
30	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
31	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
32	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
33	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 187)
34	__TwigTemplate_694646425ea428b0526066193de59e9f->block_header (line 432)
35	Twig\Template->yieldBlock (line 81)
36	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
37	Twig\Template->yield (line 58)
38	__TwigTemplate_40a07fb0ba92cc4ec4994337d805b21b->doDisplay (line 388)
39	Twig\Template->yield (line 344)
40	Twig\Template->display (line 359)
41	Twig\Template->render (line 51)
42	Twig\TemplateWrapper->render (line 334)
43	Twig\Environment->render (line 448)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 215)
47	App\Controller\Parent\ActivityParentController->subscribeAction (line 181)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
50	Symfony\Component\HttpKernel\Kernel->handle (line 35)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
52	require_once (line 11)

1.39 ms
(2.39%)

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:

[
  5317
]

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 = 5317;

#	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 84)
14	__TwigTemplate_40a07fb0ba92cc4ec4994337d805b21b->block_title (line 432)
15	Twig\Template->yieldBlock (line 67)
16	__TwigTemplate_694646425ea428b0526066193de59e9f->doDisplay (line 388)
17	Twig\Template->yield (line 58)
18	__TwigTemplate_40a07fb0ba92cc4ec4994337d805b21b->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 215)
27	App\Controller\Parent\ActivityParentController->subscribeAction (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 11)

1.12 ms
(1.92%)

SELECT t0.id AS id_1, t0.type_activity AS type_activity_2, t0.order_ihm AS order_ihm_3, t0.level AS level_4 FROM activity_category t0 WHERE t0.id = ?

Parameters:

[
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type_activity AS type_activity_2,
  t0.order_ihm AS order_ihm_3,
  t0.level AS level_4
FROM
  activity_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type_activity AS type_activity_2, t0.order_ihm AS order_ihm_3, t0.level AS level_4 FROM activity_category t0 WHERE t0.id = 28;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\ActivityCategory::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\ActivityCategory->__get (line 59)
8	App\Entity\ActivityCategory->getTypeActivity (line 136)
9	App\Controller\Parent\ActivityParentController->subscribeAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 11)

0.79 ms
(1.35%)

SELECT t0.id AS id_1, t0.archived AS archived_2, t0.publicationDate AS publicationDate_3, t0.registration_start_date AS registration_start_date_4, t0.member_registration_start_date AS member_registration_start_date_5, t0.end_registration_date AS end_registration_date_6, t0.payment_delay AS payment_delay_7, t0.payment_delay_waiting_list AS payment_delay_waiting_list_8, t0.cost30min AS cost30min_9, t0.cost45min AS cost45min_10, t0.cost60min AS cost60min_11 FROM period t0 WHERE t0.id = ?

Parameters:

[
  82
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.archived AS archived_2,
  t0.publicationDate AS publicationDate_3,
  t0.registration_start_date AS registration_start_date_4,
  t0.member_registration_start_date AS member_registration_start_date_5,
  t0.end_registration_date AS end_registration_date_6,
  t0.payment_delay AS payment_delay_7,
  t0.payment_delay_waiting_list AS payment_delay_waiting_list_8,
  t0.cost30min AS cost30min_9,
  t0.cost45min AS cost45min_10,
  t0.cost60min AS cost60min_11
FROM
  period t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.archived AS archived_2, t0.publicationDate AS publicationDate_3, t0.registration_start_date AS registration_start_date_4, t0.member_registration_start_date AS member_registration_start_date_5, t0.end_registration_date AS end_registration_date_6, t0.payment_delay AS payment_delay_7, t0.payment_delay_waiting_list AS payment_delay_waiting_list_8, t0.cost30min AS cost30min_9, t0.cost45min AS cost45min_10, t0.cost60min AS cost60min_11 FROM period t0 WHERE t0.id = 82;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Period::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Period->__get (line 101)
8	App\Entity\Period->getPublicationDate (line 25)
9	App\Controller\StandardActivityController->canViewSubscribeAction (line 132)
10	App\Controller\Parent\ActivityParentController->subscribeAction (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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\MenuItemTranslation	30
App\Entity\MenuItem	15
App\Entity\ActivityInstance	2
App\Entity\ActivityInstanceTranslation	2
App\Entity\User	1
App\Entity\ActivityCategory	1
App\Entity\Classroom	1
App\Entity\Period	1
App\Entity\Building	1
App\Entity\VNbParticipantsPerActivity	1
App\Entity\Child	1
App\Entity\Cycle	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\ActivityInstance	No errors.
App\Entity\Language	No errors.
App\Entity\ActivityCategory	No errors.
App\Entity\Period	No errors.
App\Entity\TeacherWorkingHour	No errors.
App\Entity\Child	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\Classroom	No errors.
App\Entity\Building	No errors.
App\Entity\VNbParticipantsPerActivity	No errors.
App\Entity\Cycle	No errors.
App\Entity\ActivityInstanceTranslation	No errors.
App\Entity\PeriodDate	No errors.
App\Entity\PeriodTranslation	No errors.
App\Entity\ActivityCategoryTranslation	No errors.
App\Entity\RegistrationStatus	No errors.
App\Entity\Parameter	No errors.
App\Entity\MenuItem	No errors.
App\Entity\MenuItemTranslation	No errors.
App\Entity\Transaction	No errors.
App\Entity\ClassroomWorkingHour	No errors.
App\Entity\BuildingTranslation	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%255CProfileController%253A%253ApartialPasswordEx…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping