Symfony Profiler

Query Metrics

14 Database Queries

9 Different statements

17.14 ms Query time

0 Invalid entities

92 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.62 ms
(32.80%)

SELECT t0.id AS id_1, t0.td_groups AS td_groups_2, t0.tp_groups AS tp_groups_3, t0.academic_year_id AS academic_year_id_4, t0.career_id AS career_id_5, t0.semester_id AS semester_id_6 FROM career_semester_group t0 WHERE t0.academic_year_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.td_groups AS td_groups_2,
  t0.tp_groups AS tp_groups_3,
  t0.academic_year_id AS academic_year_id_4,
  t0.career_id AS career_id_5,
  t0.semester_id AS semester_id_6
FROM
  career_semester_group t0
WHERE
  t0.academic_year_id = ?

SELECT t0.id AS id_1, t0.td_groups AS td_groups_2, t0.tp_groups AS tp_groups_3, t0.academic_year_id AS academic_year_id_4, t0.career_id AS career_id_5, t0.semester_id AS semester_id_6 FROM career_semester_group t0 WHERE t0.academic_year_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Repository\CareerSemesterGroupRepository->mapForYear (line 30)
5	App\Controller\McccController->resolveModuleGroups (line 71)
6	App\Controller\McccController->manageModule (line 2533)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 185)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

5.22 ms
(30.48%)

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.cm AS cm_4, t0.td AS td_5, t0.tp AS tp_6, t0.ptut AS ptut_7, t0.vet AS vet_8, t0.codelement AS codelement_9, t0.comment AS comment_10, t0.edited AS edited_11, t0.blocked AS blocked_12, t0.excluded_from_service AS excluded_from_service_13, t0.progression AS progression_14, t0.cc_oral_pct AS cc_oral_pct_15, t0.cc_oral_nb AS cc_oral_nb_16, t0.cc_ecrit_pct AS cc_ecrit_pct_17, t0.cc_ecrit_nb AS cc_ecrit_nb_18, t0.cc_rapport_pct AS cc_rapport_pct_19, t0.cc_rapport_nb AS cc_rapport_nb_20, t0.cc_autre_pct AS cc_autre_pct_21, t0.cc_autre_nb AS cc_autre_nb_22, t0.promo_ecrit_pct AS promo_ecrit_pct_23, t0.promo_ecrit_nb AS promo_ecrit_nb_24, t0.promo_rapport_pct AS promo_rapport_pct_25, t0.promo_rapport_nb AS promo_rapport_nb_26, t0.sae_portfolio_pct AS sae_portfolio_pct_27, t0.sae_portfolio_nb AS sae_portfolio_nb_28, t0.sae_livrable_pct AS sae_livrable_pct_29, t0.sae_livrable_nb AS sae_livrable_nb_30, t0.sae_rapport_pct AS sae_rapport_pct_31, t0.sae_rapport_nb AS sae_rapport_nb_32, t0.sae_soutenance_pct AS sae_soutenance_pct_33, t0.sae_soutenance_nb AS sae_soutenance_nb_34, t0.ent_entreprise_pct AS ent_entreprise_pct_35, t0.ent_entreprise_nb AS ent_entreprise_nb_36, t0.ent_rapport_pct AS ent_rapport_pct_37, t0.ent_rapport_nb AS ent_rapport_nb_38, t0.ent_soutenance_pct AS ent_soutenance_pct_39, t0.ent_soutenance_nb AS ent_soutenance_nb_40, t0.coef_bc1 AS coef_bc1_41, t0.coef_bc2 AS coef_bc2_42, t0.coef_bc3 AS coef_bc3_43, t0.coef_bc4 AS coef_bc4_44, t0.coef_bc5 AS coef_bc5_45, t0.semester_id AS semester_id_46, t0.career_id AS career_id_47, t0.academic_year_id AS academic_year_id_48, t0.leader_id AS leader_id_49 FROM module t0 WHERE t0.id = ?

Parameters:

[
  "356"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.name AS name_3,
  t0.cm AS cm_4,
  t0.td AS td_5,
  t0.tp AS tp_6,
  t0.ptut AS ptut_7,
  t0.vet AS vet_8,
  t0.codelement AS codelement_9,
  t0.comment AS comment_10,
  t0.edited AS edited_11,
  t0.blocked AS blocked_12,
  t0.excluded_from_service AS excluded_from_service_13,
  t0.progression AS progression_14,
  t0.cc_oral_pct AS cc_oral_pct_15,
  t0.cc_oral_nb AS cc_oral_nb_16,
  t0.cc_ecrit_pct AS cc_ecrit_pct_17,
  t0.cc_ecrit_nb AS cc_ecrit_nb_18,
  t0.cc_rapport_pct AS cc_rapport_pct_19,
  t0.cc_rapport_nb AS cc_rapport_nb_20,
  t0.cc_autre_pct AS cc_autre_pct_21,
  t0.cc_autre_nb AS cc_autre_nb_22,
  t0.promo_ecrit_pct AS promo_ecrit_pct_23,
  t0.promo_ecrit_nb AS promo_ecrit_nb_24,
  t0.promo_rapport_pct AS promo_rapport_pct_25,
  t0.promo_rapport_nb AS promo_rapport_nb_26,
  t0.sae_portfolio_pct AS sae_portfolio_pct_27,
  t0.sae_portfolio_nb AS sae_portfolio_nb_28,
  t0.sae_livrable_pct AS sae_livrable_pct_29,
  t0.sae_livrable_nb AS sae_livrable_nb_30,
  t0.sae_rapport_pct AS sae_rapport_pct_31,
  t0.sae_rapport_nb AS sae_rapport_nb_32,
  t0.sae_soutenance_pct AS sae_soutenance_pct_33,
  t0.sae_soutenance_nb AS sae_soutenance_nb_34,
  t0.ent_entreprise_pct AS ent_entreprise_pct_35,
  t0.ent_entreprise_nb AS ent_entreprise_nb_36,
  t0.ent_rapport_pct AS ent_rapport_pct_37,
  t0.ent_rapport_nb AS ent_rapport_nb_38,
  t0.ent_soutenance_pct AS ent_soutenance_pct_39,
  t0.ent_soutenance_nb AS ent_soutenance_nb_40,
  t0.coef_bc1 AS coef_bc1_41,
  t0.coef_bc2 AS coef_bc2_42,
  t0.coef_bc3 AS coef_bc3_43,
  t0.coef_bc4 AS coef_bc4_44,
  t0.coef_bc5 AS coef_bc5_45,
  t0.semester_id AS semester_id_46,
  t0.career_id AS career_id_47,
  t0.academic_year_id AS academic_year_id_48,
  t0.leader_id AS leader_id_49
FROM
  module t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.cm AS cm_4, t0.td AS td_5, t0.tp AS tp_6, t0.ptut AS ptut_7, t0.vet AS vet_8, t0.codelement AS codelement_9, t0.comment AS comment_10, t0.edited AS edited_11, t0.blocked AS blocked_12, t0.excluded_from_service AS excluded_from_service_13, t0.progression AS progression_14, t0.cc_oral_pct AS cc_oral_pct_15, t0.cc_oral_nb AS cc_oral_nb_16, t0.cc_ecrit_pct AS cc_ecrit_pct_17, t0.cc_ecrit_nb AS cc_ecrit_nb_18, t0.cc_rapport_pct AS cc_rapport_pct_19, t0.cc_rapport_nb AS cc_rapport_nb_20, t0.cc_autre_pct AS cc_autre_pct_21, t0.cc_autre_nb AS cc_autre_nb_22, t0.promo_ecrit_pct AS promo_ecrit_pct_23, t0.promo_ecrit_nb AS promo_ecrit_nb_24, t0.promo_rapport_pct AS promo_rapport_pct_25, t0.promo_rapport_nb AS promo_rapport_nb_26, t0.sae_portfolio_pct AS sae_portfolio_pct_27, t0.sae_portfolio_nb AS sae_portfolio_nb_28, t0.sae_livrable_pct AS sae_livrable_pct_29, t0.sae_livrable_nb AS sae_livrable_nb_30, t0.sae_rapport_pct AS sae_rapport_pct_31, t0.sae_rapport_nb AS sae_rapport_nb_32, t0.sae_soutenance_pct AS sae_soutenance_pct_33, t0.sae_soutenance_nb AS sae_soutenance_nb_34, t0.ent_entreprise_pct AS ent_entreprise_pct_35, t0.ent_entreprise_nb AS ent_entreprise_nb_36, t0.ent_rapport_pct AS ent_rapport_pct_37, t0.ent_rapport_nb AS ent_rapport_nb_38, t0.ent_soutenance_pct AS ent_soutenance_pct_39, t0.ent_soutenance_nb AS ent_soutenance_nb_40, t0.coef_bc1 AS coef_bc1_41, t0.coef_bc2 AS coef_bc2_42, t0.coef_bc3 AS coef_bc3_43, t0.coef_bc4 AS coef_bc4_44, t0.coef_bc5 AS coef_bc5_45, t0.semester_id AS semester_id_46, t0.career_id AS career_id_47, t0.academic_year_id AS academic_year_id_48, t0.leader_id AS leader_id_49 FROM module t0 WHERE t0.id = '356';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 116)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 63)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 87)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 36)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 170)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 185)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

2.06 ms
(12.04%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.max_hours AS max_hours_3, t0.active AS active_4 FROM semester t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.max_hours AS max_hours_3,
  t0.active AS active_4
FROM
  semester t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.max_hours AS max_hours_3, t0.active AS active_4 FROM semester t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Semester::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\App\Entity\Semester->__get (line 120)
7	App\Entity\Semester->__toString (line 144)
8	Twig\Runtime\EscaperRuntime->escape (line 126)
9	__TwigTemplate_d2afe1bd832ed96341169bffd323baf7->block_content (line 134)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_15176bbd2d44b73de69c42673db18be5->block_body (line 344)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_6a9f19e863fd1e6989a07107ba428d6c->doDisplay (line 81)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_15176bbd2d44b73de69c42673db18be5->doDisplay (line 55)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_d2afe1bd832ed96341169bffd323baf7->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
26	App\Controller\McccController->manageModule (line 2535)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 185)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

1.91 ms
(11.15%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3 FROM academic_year t0 ORDER BY t0.label DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3
FROM
  academic_year t0
ORDER BY
  t0.label DESC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3 FROM academic_year t0 ORDER BY t0.label DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\McccController->manageModule (line 2532)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 185)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.06 ms
(6.17%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3 FROM academic_year t0 WHERE t0.active = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3
FROM
  academic_year t0
WHERE
  t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3 FROM academic_year t0 WHERE t0.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\AcademicYearRepository->findActive (line 21)
5	App\Service\YearContext->getActiveYear (line 31)
6	App\Service\YearContext->getSelectedYear (line 51)
7	Twig\Extension\CoreExtension->getAttribute (line 1919)
8	__TwigTemplate_15176bbd2d44b73de69c42673db18be5::block_body (line 236)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_6a9f19e863fd1e6989a07107ba428d6c->doDisplay (line 81)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_15176bbd2d44b73de69c42673db18be5->doDisplay (line 55)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_d2afe1bd832ed96341169bffd323baf7->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	App\Controller\McccController->manageModule (line 2535)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 185)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.49 ms
(2.87%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.service AS service_7, t0.other_charges AS other_charges_8, t0.other_charges_label AS other_charges_label_9, t0.allow_extra AS allow_extra_10, t0.nb_extra AS nb_extra_11, t0.current_service_hours AS current_service_hours_12, t0.code AS code_13, t0.type AS type_14, t0.rh AS rh_15, t0.part1 AS part1_16, t0.part2 AS part2_17 FROM `user` t0 ORDER BY t0.lastname ASC, t0.firstname ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.lastname AS lastname_5,
  t0.firstname AS firstname_6,
  t0.service AS service_7,
  t0.other_charges AS other_charges_8,
  t0.other_charges_label AS other_charges_label_9,
  t0.allow_extra AS allow_extra_10,
  t0.nb_extra AS nb_extra_11,
  t0.current_service_hours AS current_service_hours_12,
  t0.code AS code_13,
  t0.type AS type_14,
  t0.rh AS rh_15,
  t0.part1 AS part1_16,
  t0.part2 AS part2_17
FROM
  `user` t0
ORDER BY
  t0.lastname ASC,
  t0.firstname ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.service AS service_7, t0.other_charges AS other_charges_8, t0.other_charges_label AS other_charges_label_9, t0.allow_extra AS allow_extra_10, t0.nb_extra AS nb_extra_11, t0.current_service_hours AS current_service_hours_12, t0.code AS code_13, t0.type AS type_14, t0.rh AS rh_15, t0.part1 AS part1_16, t0.part2 AS part2_17 FROM `user` t0 ORDER BY t0.lastname ASC, t0.firstname ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\McccController->manageModule (line 2531)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 185)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.34 ms
(1.97%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.service AS service_7, t0.other_charges AS other_charges_8, t0.other_charges_label AS other_charges_label_9, t0.allow_extra AS allow_extra_10, t0.nb_extra AS nb_extra_11, t0.current_service_hours AS current_service_hours_12, t0.code AS code_13, t0.type AS type_14, t0.rh AS rh_15, t0.part1 AS part1_16, t0.part2 AS part2_17 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  266
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.lastname AS lastname_5,
  t0.firstname AS firstname_6,
  t0.service AS service_7,
  t0.other_charges AS other_charges_8,
  t0.other_charges_label AS other_charges_label_9,
  t0.allow_extra AS allow_extra_10,
  t0.nb_extra AS nb_extra_11,
  t0.current_service_hours AS current_service_hours_12,
  t0.code AS code_13,
  t0.type AS type_14,
  t0.rh AS rh_15,
  t0.part1 AS part1_16,
  t0.part2 AS part2_17
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.service AS service_7, t0.other_charges AS other_charges_8, t0.other_charges_label AS other_charges_label_9, t0.allow_extra AS allow_extra_10, t0.nb_extra AS nb_extra_11, t0.current_service_hours AS current_service_hours_12, t0.code AS code_13, t0.type AS type_14, t0.rh AS rh_15, t0.part1 AS part1_16, t0.part2 AS part2_17 FROM `user` t0 WHERE t0.id = 266;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 127)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 127)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 154)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 185)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.23 ms
(1.36%)

SELECT t0.id AS id_1, t0.block AS block_2, t0.cm AS cm_3, t0.td AS td_4, t0.tp AS tp_5, t0.gtd AS gtd_6, t0.gtp AS gtp_7, t0.ptut AS ptut_8, t0.total AS total_9, t0.user_id AS user_id_10, t0.module_id AS module_id_11, t0.academic_year_id AS academic_year_id_12 FROM predictive t0 WHERE t0.module_id = ?

Parameters:

[
  356
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.block AS block_2,
  t0.cm AS cm_3,
  t0.td AS td_4,
  t0.tp AS tp_5,
  t0.gtd AS gtd_6,
  t0.gtp AS gtp_7,
  t0.ptut AS ptut_8,
  t0.total AS total_9,
  t0.user_id AS user_id_10,
  t0.module_id AS module_id_11,
  t0.academic_year_id AS academic_year_id_12
FROM
  predictive t0
WHERE
  t0.module_id = ?

SELECT t0.id AS id_1, t0.block AS block_2, t0.cm AS cm_3, t0.td AS td_4, t0.tp AS tp_5, t0.gtd AS gtd_6, t0.gtp AS gtp_7, t0.ptut AS ptut_8, t0.total AS total_9, t0.user_id AS user_id_10, t0.module_id AS module_id_11, t0.academic_year_id AS academic_year_id_12 FROM predictive t0 WHERE t0.module_id = 356;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_d2afe1bd832ed96341169bffd323baf7->block_content (line 188)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_15176bbd2d44b73de69c42673db18be5->block_body (line 344)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_6a9f19e863fd1e6989a07107ba428d6c->doDisplay (line 81)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_15176bbd2d44b73de69c42673db18be5->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_d2afe1bd832ed96341169bffd323baf7->doDisplay (line 54)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\McccController->manageModule (line 2535)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 185)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.20 ms
(1.17%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.td AS td_3, t0.tp AS tp_4, t0.active AS active_5 FROM career t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.td AS td_3,
  t0.tp AS tp_4,
  t0.active AS active_5
FROM
  career t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.td AS td_3, t0.tp AS tp_4, t0.active AS active_5 FROM career t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Career::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\App\Entity\Career->__get (line 120)
7	App\Entity\Career->getTd (line 126)
8	App\Controller\McccController->resolveModuleGroups (line 63)
9	App\Controller\McccController->manageModule (line 2533)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 185)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	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\User	75
App\Entity\Semester	5
App\Entity\CareerSemesterGroup	5
App\Entity\Career	3
App\Entity\AcademicYear	2
App\Entity\Module	1
App\Entity\Predictive	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Predictive	No errors.
App\Entity\Module	No errors.
App\Entity\Ptut	No errors.
App\Entity\Semester	No errors.
App\Entity\Career	No errors.
App\Entity\AcademicYear	No errors.
App\Entity\McccChangeRequest	No errors.
App\Entity\ModuleOrder	No errors.
App\Entity\CareerSemesterGroup	No errors.

Symfony Profiler

GET https://mmi23x02.mmi-troyes.fr/mccc/module/356/gestion

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping