Symfony Profiler

Query Metrics

30 Database Queries

25 Different statements

8.45 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.73 ms
(8.66%)

SELECT t0_.quotite_direction AS quotite_direction_0, t0_.quotite_co_direction AS quotite_co_direction_1, t0_.quotite_encadrement AS quotite_encadrement_2, t0_.id AS id_3, t0_.personnel_id AS personnel_id_4, t0_.these_id AS these_id_5 FROM these_encadrant t0_ LEFT JOIN personnel p1_ ON t0_.personnel_id = p1_.id LEFT JOIN these t2_ ON t0_.these_id = t2_.id LEFT JOIN personnel p3_ ON t2_.personnel_id = p3_.id WHERE p1_.id = ? ORDER BY p3_.nom_usuel ASC

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.quotite_direction AS quotite_direction_0,
  t0_.quotite_co_direction AS quotite_co_direction_1,
  t0_.quotite_encadrement AS quotite_encadrement_2,
  t0_.id AS id_3,
  t0_.personnel_id AS personnel_id_4,
  t0_.these_id AS these_id_5
FROM
  these_encadrant t0_
  LEFT JOIN personnel p1_ ON t0_.personnel_id = p1_.id
  LEFT JOIN these t2_ ON t0_.these_id = t2_.id
  LEFT JOIN personnel p3_ ON t2_.personnel_id = p3_.id
WHERE
  p1_.id = ?
ORDER BY
  p3_.nom_usuel ASC

SELECT t0_.quotite_direction AS quotite_direction_0, t0_.quotite_co_direction AS quotite_co_direction_1, t0_.quotite_encadrement AS quotite_encadrement_2, t0_.id AS id_3, t0_.personnel_id AS personnel_id_4, t0_.these_id AS these_id_5 FROM these_encadrant t0_ LEFT JOIN personnel p1_ ON t0_.personnel_id = p1_.id LEFT JOIN these t2_ ON t0_.these_id = t2_.id LEFT JOIN personnel p3_ ON t2_.personnel_id = p3_.id WHERE p1_.id = 299 ORDER BY p3_.nom_usuel ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 29)
6	App\Repository\EncadrantTheseRepository->getEncadrementTheseFromPersonnel (line 355)
7	App\Controller\PersonnelController->show (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 7)

0.56 ms
(6.58%)

SELECT t0.nom AS nom_1, t0.commentaire AS commentaire_2, t0.pays AS pays_3, t0.adresse AS adresse_4, t0.entite AS entite_5, t0.autre_categorie_partenaire AS autre_categorie_partenaire_6, t0.cree_le AS cree_le_7, t0.tutelle AS tutelle_8, t0.id AS id_9, t0.categorie_partenaire_id AS categorie_partenaire_id_10, t0.rattachement_partenaire_id AS rattachement_partenaire_id_11, t0.createur_id AS createur_id_12 FROM partenaire t0 WHERE t0.id = ?

Parameters:

[
  246
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.nom AS nom_1,
  t0.commentaire AS commentaire_2,
  t0.pays AS pays_3,
  t0.adresse AS adresse_4,
  t0.entite AS entite_5,
  t0.autre_categorie_partenaire AS autre_categorie_partenaire_6,
  t0.cree_le AS cree_le_7,
  t0.tutelle AS tutelle_8,
  t0.id AS id_9,
  t0.categorie_partenaire_id AS categorie_partenaire_id_10,
  t0.rattachement_partenaire_id AS rattachement_partenaire_id_11,
  t0.createur_id AS createur_id_12
FROM
  partenaire t0
WHERE
  t0.id = ?

SELECT t0.nom AS nom_1, t0.commentaire AS commentaire_2, t0.pays AS pays_3, t0.adresse AS adresse_4, t0.entite AS entite_5, t0.autre_categorie_partenaire AS autre_categorie_partenaire_6, t0.cree_le AS cree_le_7, t0.tutelle AS tutelle_8, t0.id AS id_9, t0.categorie_partenaire_id AS categorie_partenaire_id_10, t0.rattachement_partenaire_id AS rattachement_partenaire_id_11, t0.createur_id AS createur_id_12 FROM partenaire t0 WHERE t0.id = 246;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Partenaire::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Partenaire->__get (line 298)
8	App\Entity\Partenaire->__toString (line 120)
9	Twig\Runtime\EscaperRuntime->escape (line 117)
10	__TwigTemplate_b50aa76ba402a5e560dfcda6b976dedf->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 310)
16	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
17	Twig\Template->yieldBlock (line 269)
18	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
19	Twig\Template->yield (line 99)
20	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
29	App\Controller\PersonnelController->show (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 7)

0.54 ms
(6.41%)

SELECT t0.autre_categorie_personnel AS autre_categorie_personnel_1, t0.mail AS mail_2, t0.telephone_fixe AS telephone_fixe_3, t0.telephone_mobile AS telephone_mobile_4, t0.autre_type_contrat_travail AS autre_type_contrat_travail_5, t0.cout_total_charge AS cout_total_charge_6, t0.id AS id_7, t0.type_statut_id AS type_statut_id_8, t0.type_activite_id AS type_activite_id_9, t0.categorie_personnel_id AS categorie_personnel_id_10, t0.grade_id AS grade_id_11, t0.partenaire_id AS partenaire_id_12, t0.type_contrat_travail_id AS type_contrat_travail_id_13, t0.section_cnu_id AS section_cnu_id_14, t0.section_cnrs_id AS section_cnrs_id_15, t0.site_id AS site_id_16 FROM position t0 WHERE t0.id = ?

Parameters:

[
  864
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.autre_categorie_personnel AS autre_categorie_personnel_1,
  t0.mail AS mail_2,
  t0.telephone_fixe AS telephone_fixe_3,
  t0.telephone_mobile AS telephone_mobile_4,
  t0.autre_type_contrat_travail AS autre_type_contrat_travail_5,
  t0.cout_total_charge AS cout_total_charge_6,
  t0.id AS id_7,
  t0.type_statut_id AS type_statut_id_8,
  t0.type_activite_id AS type_activite_id_9,
  t0.categorie_personnel_id AS categorie_personnel_id_10,
  t0.grade_id AS grade_id_11,
  t0.partenaire_id AS partenaire_id_12,
  t0.type_contrat_travail_id AS type_contrat_travail_id_13,
  t0.section_cnu_id AS section_cnu_id_14,
  t0.section_cnrs_id AS section_cnrs_id_15,
  t0.site_id AS site_id_16
FROM
  position t0
WHERE
  t0.id = ?

SELECT t0.autre_categorie_personnel AS autre_categorie_personnel_1, t0.mail AS mail_2, t0.telephone_fixe AS telephone_fixe_3, t0.telephone_mobile AS telephone_mobile_4, t0.autre_type_contrat_travail AS autre_type_contrat_travail_5, t0.cout_total_charge AS cout_total_charge_6, t0.id AS id_7, t0.type_statut_id AS type_statut_id_8, t0.type_activite_id AS type_activite_id_9, t0.categorie_personnel_id AS categorie_personnel_id_10, t0.grade_id AS grade_id_11, t0.partenaire_id AS partenaire_id_12, t0.type_contrat_travail_id AS type_contrat_travail_id_13, t0.section_cnu_id AS section_cnu_id_14, t0.section_cnrs_id AS section_cnrs_id_15, t0.site_id AS site_id_16 FROM position t0 WHERE t0.id = 864;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Position::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Position->__get (line 96)
8	App\Entity\Position->getTypeStatut (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 101)
10	__TwigTemplate_b50aa76ba402a5e560dfcda6b976dedf->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 310)
16	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
17	Twig\Template->yieldBlock (line 269)
18	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
19	Twig\Template->yield (line 99)
20	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
29	App\Controller\PersonnelController->show (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 7)

0.52 ms
(6.15%)

SELECT t0.autre_type_autre_activite AS autre_type_autre_activite_1, t0.quotite AS quotite_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.id AS id_5, t0.type_autre_activite_id AS type_autre_activite_id_6, t0.partenaire_id AS partenaire_id_7, t0.position_id AS position_id_8 FROM autre_activite t0 WHERE t0.position_id = ?

Parameters:

[
  864
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.autre_type_autre_activite AS autre_type_autre_activite_1,
  t0.quotite AS quotite_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.id AS id_5,
  t0.type_autre_activite_id AS type_autre_activite_id_6,
  t0.partenaire_id AS partenaire_id_7,
  t0.position_id AS position_id_8
FROM
  autre_activite t0
WHERE
  t0.position_id = ?

SELECT t0.autre_type_autre_activite AS autre_type_autre_activite_1, t0.quotite AS quotite_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.id AS id_5, t0.type_autre_activite_id AS type_autre_activite_id_6, t0.partenaire_id AS partenaire_id_7, t0.position_id AS position_id_8 FROM autre_activite t0 WHERE t0.position_id = 864;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 336)
8	App\Entity\Position->getAutreActivites (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 59)
10	__TwigTemplate_7e87de557ab9cc4275e02caf96ece453->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 48)
16	__TwigTemplate_ed1e22098224df519270dd5907c9eb9a->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1482)
21	Twig\Extension\CoreExtension::include (line 369)
22	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
23	Twig\Template->yieldBlock (line 269)
24	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
25	Twig\Template->yield (line 99)
26	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
27	Twig\Template->yield (line 343)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 320)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
35	App\Controller\PersonnelController->show (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 7)

0.48 ms
(5.73%)

SELECT t0.nom_usuel AS nom_usuel_1, t0.prenom AS prenom_2, t0.commentaire AS commentaire_3, t0.annee_naissance AS annee_naissance_4, t0.docteur_ietr AS docteur_ietr_5, t0.hdr AS hdr_6, t0.annee_obtention_hdr AS annee_obtention_hdr_7, t0.cree_le AS cree_le_8, t0.id AS id_9, t0.genre_id AS genre_id_10, t0.nationalite_id AS nationalite_id_11, t12.titre AS titre_13, t12.personnel_id AS personnel_id_14, t12.autre_ecole_doctorale AS autre_ecole_doctorale_15, t12.autre_specialite AS autre_specialite_16, t12.co_tutelle AS co_tutelle_17, t12.date_premiere_inscription AS date_premiere_inscription_18, t12.date_soutenance AS date_soutenance_19, t12.duree AS duree_20, t12.abandon AS abandon_21, t12.commentaire AS commentaire_22, t12.cree_le AS cree_le_23, t12.id AS id_24, t12.ecole_doctorale_id AS ecole_doctorale_id_25, t12.specialite_id AS specialite_id_26, t12.mot_cle_pincipal_id AS mot_cle_pincipal_id_27, t12.mot_cle_secondaire_id AS mot_cle_secondaire_id_28, t12.personnel_id AS personnel_id_29, t12.createur_id AS createur_id_30, t0.createur_id AS createur_id_31 FROM personnel t0 LEFT JOIN these t12 ON t12.personnel_id = t0.id WHERE t0.id = ?

Parameters:

[
  "299"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.nom_usuel AS nom_usuel_1,
  t0.prenom AS prenom_2,
  t0.commentaire AS commentaire_3,
  t0.annee_naissance AS annee_naissance_4,
  t0.docteur_ietr AS docteur_ietr_5,
  t0.hdr AS hdr_6,
  t0.annee_obtention_hdr AS annee_obtention_hdr_7,
  t0.cree_le AS cree_le_8,
  t0.id AS id_9,
  t0.genre_id AS genre_id_10,
  t0.nationalite_id AS nationalite_id_11,
  t12.titre AS titre_13,
  t12.personnel_id AS personnel_id_14,
  t12.autre_ecole_doctorale AS autre_ecole_doctorale_15,
  t12.autre_specialite AS autre_specialite_16,
  t12.co_tutelle AS co_tutelle_17,
  t12.date_premiere_inscription AS date_premiere_inscription_18,
  t12.date_soutenance AS date_soutenance_19,
  t12.duree AS duree_20,
  t12.abandon AS abandon_21,
  t12.commentaire AS commentaire_22,
  t12.cree_le AS cree_le_23,
  t12.id AS id_24,
  t12.ecole_doctorale_id AS ecole_doctorale_id_25,
  t12.specialite_id AS specialite_id_26,
  t12.mot_cle_pincipal_id AS mot_cle_pincipal_id_27,
  t12.mot_cle_secondaire_id AS mot_cle_secondaire_id_28,
  t12.personnel_id AS personnel_id_29,
  t12.createur_id AS createur_id_30,
  t0.createur_id AS createur_id_31
FROM
  personnel t0
  LEFT JOIN these t12 ON t12.personnel_id = t0.id
WHERE
  t0.id = ?

SELECT t0.nom_usuel AS nom_usuel_1, t0.prenom AS prenom_2, t0.commentaire AS commentaire_3, t0.annee_naissance AS annee_naissance_4, t0.docteur_ietr AS docteur_ietr_5, t0.hdr AS hdr_6, t0.annee_obtention_hdr AS annee_obtention_hdr_7, t0.cree_le AS cree_le_8, t0.id AS id_9, t0.genre_id AS genre_id_10, t0.nationalite_id AS nationalite_id_11, t12.titre AS titre_13, t12.personnel_id AS personnel_id_14, t12.autre_ecole_doctorale AS autre_ecole_doctorale_15, t12.autre_specialite AS autre_specialite_16, t12.co_tutelle AS co_tutelle_17, t12.date_premiere_inscription AS date_premiere_inscription_18, t12.date_soutenance AS date_soutenance_19, t12.duree AS duree_20, t12.abandon AS abandon_21, t12.commentaire AS commentaire_22, t12.cree_le AS cree_le_23, t12.id AS id_24, t12.ecole_doctorale_id AS ecole_doctorale_id_25, t12.specialite_id AS specialite_id_26, t12.mot_cle_pincipal_id AS mot_cle_pincipal_id_27, t12.mot_cle_secondaire_id AS mot_cle_secondaire_id_28, t12.personnel_id AS personnel_id_29, t12.createur_id AS createur_id_30, t0.createur_id AS createur_id_31 FROM personnel t0 LEFT JOIN these t12 ON t12.personnel_id = t0.id WHERE t0.id = '299';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 119)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 7)

0.46 ms
(5.48%)

SELECT t0.nom AS nom_1, t0.thematique AS thematique_2, t0.commentaire AS commentaire_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.cree_le AS cree_le_6, t0.id AS id_7, t0.departement_id AS departement_id_8, t0.createur_id AS createur_id_9 FROM equipe t0 WHERE t0.id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.nom AS nom_1,
  t0.thematique AS thematique_2,
  t0.commentaire AS commentaire_3,
  t0.date_debut AS date_debut_4,
  t0.date_fin AS date_fin_5,
  t0.cree_le AS cree_le_6,
  t0.id AS id_7,
  t0.departement_id AS departement_id_8,
  t0.createur_id AS createur_id_9
FROM
  equipe t0
WHERE
  t0.id = ?

SELECT t0.nom AS nom_1, t0.thematique AS thematique_2, t0.commentaire AS commentaire_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.cree_le AS cree_le_6, t0.id AS id_7, t0.departement_id AS departement_id_8, t0.createur_id AS createur_id_9 FROM equipe t0 WHERE t0.id = 13;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Equipe::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Equipe->__get (line 112)
8	App\Entity\Equipe->getNom (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 89)
10	__TwigTemplate_d152cb25ff58d4dee35615dd943e7bff->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 330)
16	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
17	Twig\Template->yieldBlock (line 269)
18	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
19	Twig\Template->yield (line 99)
20	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
29	App\Controller\PersonnelController->show (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 7)

0.44 ms
(5.21%)

SELECT p0_.date_debut AS date_debut_0, p0_.date_fin AS date_fin_1, p0_.id AS id_2, p0_.position_id AS position_id_3, p0_.personnel_id AS personnel_id_4 FROM personnel_position p0_ INNER JOIN position p1_ ON p0_.position_id = p1_.id WHERE p0_.personnel_id = ? AND p1_.categorie_personnel_id = 16

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.date_debut AS date_debut_0,
  p0_.date_fin AS date_fin_1,
  p0_.id AS id_2,
  p0_.position_id AS position_id_3,
  p0_.personnel_id AS personnel_id_4
FROM
  personnel_position p0_
  INNER JOIN position p1_ ON p0_.position_id = p1_.id
WHERE
  p0_.personnel_id = ?
  AND p1_.categorie_personnel_id = 16

SELECT p0_.date_debut AS date_debut_0, p0_.date_fin AS date_fin_1, p0_.id AS id_2, p0_.position_id AS position_id_3, p0_.personnel_id AS personnel_id_4 FROM personnel_position p0_ INNER JOIN position p1_ ON p0_.position_id = p1_.id WHERE p0_.personnel_id = 299 AND p1_.categorie_personnel_id = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 31)
7	App\Repository\PersonnelPositionRepository->isDoctorant (line 351)
8	App\Controller\PersonnelController->show (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 7)

0.38 ms
(4.51%)

SELECT p0_.date_debut AS date_debut_0, p0_.date_fin AS date_fin_1, p0_.quotite AS quotite_2, p0_.responsable AS responsable_3, p0_.id AS id_4, p0_.plateforme_plateau_technique_id AS plateforme_plateau_technique_id_5, p0_.personnel_id AS personnel_id_6 FROM personnel_plateforme_plateau_technique p0_ WHERE p0_.personnel_id = ?

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.date_debut AS date_debut_0,
  p0_.date_fin AS date_fin_1,
  p0_.quotite AS quotite_2,
  p0_.responsable AS responsable_3,
  p0_.id AS id_4,
  p0_.plateforme_plateau_technique_id AS plateforme_plateau_technique_id_5,
  p0_.personnel_id AS personnel_id_6
FROM
  personnel_plateforme_plateau_technique p0_
WHERE
  p0_.personnel_id = ?

SELECT p0_.date_debut AS date_debut_0, p0_.date_fin AS date_fin_1, p0_.quotite AS quotite_2, p0_.responsable AS responsable_3, p0_.id AS id_4, p0_.plateforme_plateau_technique_id AS plateforme_plateau_technique_id_5, p0_.personnel_id AS personnel_id_6 FROM personnel_plateforme_plateau_technique p0_ WHERE p0_.personnel_id = 299;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 43)
6	App\Repository\PersonnelPlateformePlateauTechniqueRepository->getByPersonnel (line 28)
7	App\Service\PersonnelPlateformePlateauTechniqueService->getByPersonnel (line 347)
8	App\Controller\PersonnelController->show (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 7)

0.34 ms
(4.08%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom_usuel AS nom_usuel_3, t0.prenom AS prenom_4, t0.roles AS roles_5, t0.reset_password_token AS reset_password_token_6, t0.reset_password_token_expire_at AS reset_password_token_expire_at_7, t0.password AS password_8 FROM utilisateur t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nom_usuel AS nom_usuel_3,
  t0.prenom AS prenom_4,
  t0.roles AS roles_5,
  t0.reset_password_token AS reset_password_token_6,
  t0.reset_password_token_expire_at AS reset_password_token_expire_at_7,
  t0.password AS password_8
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom_usuel AS nom_usuel_3, t0.prenom AS prenom_4, t0.roles AS roles_5, t0.reset_password_token AS reset_password_token_6, t0.reset_password_token_expire_at AS reset_password_token_expire_at_7, t0.password AS password_8 FROM utilisateur t0 WHERE t0.id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 205)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 125)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 7)

0.30 ms
(3.56%)

SELECT p0_.date_debut AS date_debut_0, p0_.date_fin AS date_fin_1, p0_.quotite AS quotite_2, p0_.responsable AS responsable_3, p0_.id AS id_4, p0_.equipe_id AS equipe_id_5, p0_.personnel_id AS personnel_id_6 FROM personnel_equipe p0_ WHERE p0_.personnel_id = ? AND p0_.responsable = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.date_debut AS date_debut_0,
  p0_.date_fin AS date_fin_1,
  p0_.quotite AS quotite_2,
  p0_.responsable AS responsable_3,
  p0_.id AS id_4,
  p0_.equipe_id AS equipe_id_5,
  p0_.personnel_id AS personnel_id_6
FROM
  personnel_equipe p0_
WHERE
  p0_.personnel_id = ?
  AND p0_.responsable = ?

SELECT p0_.date_debut AS date_debut_0, p0_.date_fin AS date_fin_1, p0_.quotite AS quotite_2, p0_.responsable AS responsable_3, p0_.id AS id_4, p0_.equipe_id AS equipe_id_5, p0_.personnel_id AS personnel_id_6 FROM personnel_equipe p0_ WHERE p0_.personnel_id = 299 AND p0_.responsable = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 45)
6	App\Repository\PersonnelEquipeRepository->getByPersonnel (line 26)
7	App\Service\PersonnelEquipeService->getByPersonnelResponsable (line 349)
8	App\Controller\PersonnelController->show (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 7)

0.29 ms
(3.45%)

SELECT t0.quotite AS quotite_1, t0.id AS id_2, t0.bap_id AS bap_id_3, t0.personnel_id AS personnel_id_4 FROM personnel_bap t0 WHERE t0.personnel_id = ?

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.quotite AS quotite_1,
  t0.id AS id_2,
  t0.bap_id AS bap_id_3,
  t0.personnel_id AS personnel_id_4
FROM
  personnel_bap t0
WHERE
  t0.personnel_id = ?

SELECT t0.quotite AS quotite_1, t0.id AS id_2, t0.bap_id AS bap_id_3, t0.personnel_id AS personnel_id_4 FROM personnel_bap t0 WHERE t0.personnel_id = 299;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 339)
8	App\Entity\Personnel->getBaps (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 58)
10	__TwigTemplate_58635f9a8e4da832bb1becf9ea9f3d43->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 53)
16	__TwigTemplate_ed1e22098224df519270dd5907c9eb9a->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1482)
21	Twig\Extension\CoreExtension::include (line 369)
22	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
23	Twig\Template->yieldBlock (line 269)
24	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
25	Twig\Template->yield (line 99)
26	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
27	Twig\Template->yield (line 343)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 320)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
35	App\Controller\PersonnelController->show (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 7)

0.28 ms
(3.34%)

SELECT t0.annee_debut AS annee_debut_1, t0.annee_fin AS annee_fin_2, t0.intitule AS intitule_3, t0.autre_type_employeur AS autre_type_employeur_4, t0.type_formation AS type_formation_5, t0.pays AS pays_6, t0.id AS id_7, t0.personnel_id AS personnel_id_8, t0.type_experience_id AS type_experience_id_9, t0.periode_experience_id AS periode_experience_id_10, t0.tutelle_id AS tutelle_id_11, t0.type_employeur_id AS type_employeur_id_12, t0.niveau_diplome_id AS niveau_diplome_id_13 FROM personnel_experience t0 WHERE t0.personnel_id = ?

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.annee_debut AS annee_debut_1,
  t0.annee_fin AS annee_fin_2,
  t0.intitule AS intitule_3,
  t0.autre_type_employeur AS autre_type_employeur_4,
  t0.type_formation AS type_formation_5,
  t0.pays AS pays_6,
  t0.id AS id_7,
  t0.personnel_id AS personnel_id_8,
  t0.type_experience_id AS type_experience_id_9,
  t0.periode_experience_id AS periode_experience_id_10,
  t0.tutelle_id AS tutelle_id_11,
  t0.type_employeur_id AS type_employeur_id_12,
  t0.niveau_diplome_id AS niveau_diplome_id_13
FROM
  personnel_experience t0
WHERE
  t0.personnel_id = ?

SELECT t0.annee_debut AS annee_debut_1, t0.annee_fin AS annee_fin_2, t0.intitule AS intitule_3, t0.autre_type_employeur AS autre_type_employeur_4, t0.type_formation AS type_formation_5, t0.pays AS pays_6, t0.id AS id_7, t0.personnel_id AS personnel_id_8, t0.type_experience_id AS type_experience_id_9, t0.periode_experience_id AS periode_experience_id_10, t0.tutelle_id AS tutelle_id_11, t0.type_employeur_id AS type_employeur_id_12, t0.niveau_diplome_id AS niveau_diplome_id_13 FROM personnel_experience t0 WHERE t0.personnel_id = 299;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 355)
8	App\Entity\Personnel->getExperiences (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 58)
10	__TwigTemplate_113e9baadfec69fb65dd510147121ac9->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 68)
16	__TwigTemplate_ed1e22098224df519270dd5907c9eb9a->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1482)
21	Twig\Extension\CoreExtension::include (line 369)
22	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
23	Twig\Template->yieldBlock (line 269)
24	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
25	Twig\Template->yield (line 99)
26	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
27	Twig\Template->yield (line 343)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 320)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
35	App\Controller\PersonnelController->show (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 7)

0.27 ms
(3.21%)

SELECT t0.date_debut AS date_debut_1, t0.date_fin AS date_fin_2, t0.id AS id_3, t0.position_id AS position_id_4, t0.personnel_id AS personnel_id_5 FROM personnel_position t0 WHERE t0.personnel_id = ? ORDER BY t0.date_debut DESC

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.date_debut AS date_debut_1,
  t0.date_fin AS date_fin_2,
  t0.id AS id_3,
  t0.position_id AS position_id_4,
  t0.personnel_id AS personnel_id_5
FROM
  personnel_position t0
WHERE
  t0.personnel_id = ?
ORDER BY
  t0.date_debut DESC

SELECT t0.date_debut AS date_debut_1, t0.date_fin AS date_fin_2, t0.id AS id_3, t0.position_id AS position_id_4, t0.personnel_id AS personnel_id_5 FROM personnel_position t0 WHERE t0.personnel_id = 299 ORDER BY t0.date_debut DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 291)
8	App\Entity\Personnel->getPositions (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 310)
10	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
11	Twig\Template->yieldBlock (line 269)
12	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
13	Twig\Template->yield (line 99)
14	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
23	App\Controller\PersonnelController->show (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 7)

0.26 ms
(3.09%)

SELECT t0.date_debut AS date_debut_1, t0.date_fin AS date_fin_2, t0.quotite AS quotite_3, t0.responsable AS responsable_4, t0.id AS id_5, t0.equipe_id AS equipe_id_6, t0.personnel_id AS personnel_id_7 FROM personnel_equipe t0 WHERE t0.personnel_id = ?

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.date_debut AS date_debut_1,
  t0.date_fin AS date_fin_2,
  t0.quotite AS quotite_3,
  t0.responsable AS responsable_4,
  t0.id AS id_5,
  t0.equipe_id AS equipe_id_6,
  t0.personnel_id AS personnel_id_7
FROM
  personnel_equipe t0
WHERE
  t0.personnel_id = ?

SELECT t0.date_debut AS date_debut_1, t0.date_fin AS date_fin_2, t0.quotite AS quotite_3, t0.responsable AS responsable_4, t0.id AS id_5, t0.equipe_id AS equipe_id_6, t0.personnel_id AS personnel_id_7 FROM personnel_equipe t0 WHERE t0.personnel_id = 299;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 396)
8	App\Entity\Personnel->getEquipes (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 65)
10	__TwigTemplate_d152cb25ff58d4dee35615dd943e7bff->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 330)
16	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
17	Twig\Template->yieldBlock (line 269)
18	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
19	Twig\Template->yield (line 99)
20	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
29	App\Controller\PersonnelController->show (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 7)

0.26 ms
(3.08%)

SELECT p0_.position AS position_0, p0_.date_debut AS date_debut_1, p0_.date_fin AS date_fin_2, p0_.responsable AS responsable_3, p0_.id AS id_4, p0_.contrat_id AS contrat_id_5, p0_.personnel_id AS personnel_id_6 FROM personnel_participe_contrat p0_ WHERE p0_.personnel_id = ?

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.position AS position_0,
  p0_.date_debut AS date_debut_1,
  p0_.date_fin AS date_fin_2,
  p0_.responsable AS responsable_3,
  p0_.id AS id_4,
  p0_.contrat_id AS contrat_id_5,
  p0_.personnel_id AS personnel_id_6
FROM
  personnel_participe_contrat p0_
WHERE
  p0_.personnel_id = ?

SELECT p0_.position AS position_0, p0_.date_debut AS date_debut_1, p0_.date_fin AS date_fin_2, p0_.responsable AS responsable_3, p0_.id AS id_4, p0_.contrat_id AS contrat_id_5, p0_.personnel_id AS personnel_id_6 FROM personnel_participe_contrat p0_ WHERE p0_.personnel_id = 299;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 42)
6	App\Repository\PersonnelParticipeContratRepository->getByPersonnel (line 25)
7	App\Service\PersonnelParticipeContratService->getByPersonnel (line 348)
8	App\Controller\PersonnelController->show (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 7)

0.26 ms
(3.02%)

SELECT r0_.date_debut AS date_debut_0, r0_.date_fin AS date_fin_1, r0_.id AS id_2, r0_.departement_id AS departement_id_3, r0_.personnel_id AS personnel_id_4 FROM responsable_departement r0_ WHERE r0_.personnel_id = ?

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.date_debut AS date_debut_0,
  r0_.date_fin AS date_fin_1,
  r0_.id AS id_2,
  r0_.departement_id AS departement_id_3,
  r0_.personnel_id AS personnel_id_4
FROM
  responsable_departement r0_
WHERE
  r0_.personnel_id = ?

SELECT r0_.date_debut AS date_debut_0, r0_.date_fin AS date_fin_1, r0_.id AS id_2, r0_.departement_id AS departement_id_3, r0_.personnel_id AS personnel_id_4 FROM responsable_departement r0_ WHERE r0_.personnel_id = 299;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 40)
6	App\Repository\ResponsableDepartementRepository->getByPersonnel (line 25)
7	App\Service\ResponsableDepartementService->getByPersonnel (line 350)
8	App\Controller\PersonnelController->show (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 7)

0.25 ms
(2.96%)

SELECT t0.annee_obtention AS annee_obtention_1, t0.commentaire AS commentaire_2, t0.id AS id_3, t0.distinction_id AS distinction_id_4, t0.personnel_id AS personnel_id_5 FROM personnel_distinction t0 WHERE t0.personnel_id = ?

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.annee_obtention AS annee_obtention_1,
  t0.commentaire AS commentaire_2,
  t0.id AS id_3,
  t0.distinction_id AS distinction_id_4,
  t0.personnel_id AS personnel_id_5
FROM
  personnel_distinction t0
WHERE
  t0.personnel_id = ?

SELECT t0.annee_obtention AS annee_obtention_1, t0.commentaire AS commentaire_2, t0.id AS id_3, t0.distinction_id AS distinction_id_4, t0.personnel_id AS personnel_id_5 FROM personnel_distinction t0 WHERE t0.personnel_id = 299;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 307)
8	App\Entity\Personnel->getDistinctions (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 58)
10	__TwigTemplate_44f7b68938acd0688e5b1ca97afdcb58->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 63)
16	__TwigTemplate_ed1e22098224df519270dd5907c9eb9a->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1482)
21	Twig\Extension\CoreExtension::include (line 369)
22	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
23	Twig\Template->yieldBlock (line 269)
24	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
25	Twig\Template->yield (line 99)
26	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
27	Twig\Template->yield (line 343)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 320)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
35	App\Controller\PersonnelController->show (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 7)

0.25 ms
(2.93%)

SELECT t0.date_debut AS date_debut_1, t0.date_fin AS date_fin_2, t0.commentaire AS commentaire_3, t0.id AS id_4, t0.mandat_id AS mandat_id_5, t0.personnel_id AS personnel_id_6 FROM personnel_mandat t0 WHERE t0.personnel_id = ?

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.date_debut AS date_debut_1,
  t0.date_fin AS date_fin_2,
  t0.commentaire AS commentaire_3,
  t0.id AS id_4,
  t0.mandat_id AS mandat_id_5,
  t0.personnel_id AS personnel_id_6
FROM
  personnel_mandat t0
WHERE
  t0.personnel_id = ?

SELECT t0.date_debut AS date_debut_1, t0.date_fin AS date_fin_2, t0.commentaire AS commentaire_3, t0.id AS id_4, t0.mandat_id AS mandat_id_5, t0.personnel_id AS personnel_id_6 FROM personnel_mandat t0 WHERE t0.personnel_id = 299;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 323)
8	App\Entity\Personnel->getMandats (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 58)
10	__TwigTemplate_f30764cdba989314ea90f46ebbe6bc16->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 58)
16	__TwigTemplate_ed1e22098224df519270dd5907c9eb9a->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1482)
21	Twig\Extension\CoreExtension::include (line 369)
22	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
23	Twig\Template->yieldBlock (line 269)
24	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
25	Twig\Template->yield (line 99)
26	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
27	Twig\Template->yield (line 343)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 320)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
35	App\Controller\PersonnelController->show (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 7)

0.25 ms
(2.92%)

SELECT t0.quotite_direction AS quotite_direction_1, t0.quotite_co_direction AS quotite_co_direction_2, t0.quotite_encadrement AS quotite_encadrement_3, t0.id AS id_4, t0.personnel_id AS personnel_id_5, t0.these_id AS these_id_6 FROM these_encadrant t0 WHERE t0.personnel_id = ?

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.quotite_direction AS quotite_direction_1,
  t0.quotite_co_direction AS quotite_co_direction_2,
  t0.quotite_encadrement AS quotite_encadrement_3,
  t0.id AS id_4,
  t0.personnel_id AS personnel_id_5,
  t0.these_id AS these_id_6
FROM
  these_encadrant t0
WHERE
  t0.personnel_id = ?

SELECT t0.quotite_direction AS quotite_direction_1, t0.quotite_co_direction AS quotite_co_direction_2, t0.quotite_encadrement AS quotite_encadrement_3, t0.id AS id_4, t0.personnel_id AS personnel_id_5, t0.these_id AS these_id_6 FROM these_encadrant t0 WHERE t0.personnel_id = 299;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 509)
8	App\Entity\Personnel->getEncadrementsTheses (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 48)
10	__TwigTemplate_1eca1682c4a0a56d484c5a8f4ba918da->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 71)
16	__TwigTemplate_0a1358b4755baf1439ac7fb73dfc3477->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1482)
21	Twig\Extension\CoreExtension::include (line 319)
22	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
23	Twig\Template->yieldBlock (line 269)
24	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
25	Twig\Template->yield (line 99)
26	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
27	Twig\Template->yield (line 343)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 320)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
35	App\Controller\PersonnelController->show (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 7)

0.24 ms
(2.89%)

SELECT t0.date_debut AS date_debut_1, t0.date_fin AS date_fin_2, t0.quotite AS quotite_3, t0.responsable AS responsable_4, t0.id AS id_5, t0.plateforme_plateau_technique_id AS plateforme_plateau_technique_id_6, t0.personnel_id AS personnel_id_7 FROM personnel_plateforme_plateau_technique t0 WHERE t0.personnel_id = ?

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.date_debut AS date_debut_1,
  t0.date_fin AS date_fin_2,
  t0.quotite AS quotite_3,
  t0.responsable AS responsable_4,
  t0.id AS id_5,
  t0.plateforme_plateau_technique_id AS plateforme_plateau_technique_id_6,
  t0.personnel_id AS personnel_id_7
FROM
  personnel_plateforme_plateau_technique t0
WHERE
  t0.personnel_id = ?

SELECT t0.date_debut AS date_debut_1, t0.date_fin AS date_fin_2, t0.quotite AS quotite_3, t0.responsable AS responsable_4, t0.id AS id_5, t0.plateforme_plateau_technique_id AS plateforme_plateau_technique_id_6, t0.personnel_id AS personnel_id_7 FROM personnel_plateforme_plateau_technique t0 WHERE t0.personnel_id = 299;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 371)
8	App\Entity\Personnel->getPlateformePlateauTechniques (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 339)
10	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
11	Twig\Template->yieldBlock (line 269)
12	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
13	Twig\Template->yield (line 99)
14	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
23	App\Controller\PersonnelController->show (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 7)

0.22 ms
(2.62%)

SELECT t0.id AS id_1, t0.valeur AS valeur_2 FROM etablissement t0 WHERE t0.id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.valeur AS valeur_2
FROM
  etablissement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.valeur AS valeur_2 FROM etablissement t0 WHERE t0.id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Etablissement::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Etablissement->__get (line 22)
8	App\Entity\Etablissement->getValeur (line 117)
9	App\Entity\Site->__toString (line 120)
10	Twig\Runtime\EscaperRuntime->escape (line 109)
11	__TwigTemplate_b50aa76ba402a5e560dfcda6b976dedf->doDisplay (line 387)
12	Twig\Template->yield (line 343)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 1482)
16	Twig\Extension\CoreExtension::include (line 310)
17	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
18	Twig\Template->yieldBlock (line 269)
19	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
20	Twig\Template->yield (line 99)
21	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
22	Twig\Template->yield (line 343)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 320)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
30	App\Controller\PersonnelController->show (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 7)

0.22 ms
(2.60%)

SELECT t0.batiment AS batiment_1, t0.adresse_postale AS adresse_postale_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4 FROM site t0 WHERE t0.id = ?

Parameters:

[
  26
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.batiment AS batiment_1,
  t0.adresse_postale AS adresse_postale_2,
  t0.id AS id_3,
  t0.etablissement_id AS etablissement_id_4
FROM
  site t0
WHERE
  t0.id = ?

SELECT t0.batiment AS batiment_1, t0.adresse_postale AS adresse_postale_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4 FROM site t0 WHERE t0.id = 26;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Site::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Site->__get (line 116)
8	App\Entity\Site->__toString (line 120)
9	Twig\Runtime\EscaperRuntime->escape (line 109)
10	__TwigTemplate_b50aa76ba402a5e560dfcda6b976dedf->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 310)
16	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
17	Twig\Template->yieldBlock (line 269)
18	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
19	Twig\Template->yield (line 99)
20	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
29	App\Controller\PersonnelController->show (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 7)

0.22 ms
(2.55%)

SELECT t0.id AS id_1, t0.valeur AS valeur_2 FROM type_statut t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.valeur AS valeur_2
FROM
  type_statut t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.valeur AS valeur_2 FROM type_statut t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\TypeStatut::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\TypeStatut->__get (line 35)
8	App\Entity\TypeStatut->__toString (line 120)
9	Twig\Runtime\EscaperRuntime->escape (line 101)
10	__TwigTemplate_b50aa76ba402a5e560dfcda6b976dedf->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 310)
16	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
17	Twig\Template->yieldBlock (line 269)
18	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
19	Twig\Template->yield (line 99)
20	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
29	App\Controller\PersonnelController->show (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 7)

0.21 ms
(2.50%)

SELECT t0.id AS id_1, t0.valeur AS valeur_2 FROM nationalite t0 WHERE t0.id = ?

Parameters:

[
  64
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.valeur AS valeur_2
FROM
  nationalite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.valeur AS valeur_2 FROM nationalite t0 WHERE t0.id = 64;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Nationalite::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Nationalite->__get (line 35)
8	App\Entity\Nationalite->__toString (line 120)
9	Twig\Runtime\EscaperRuntime->escape (line 75)
10	__TwigTemplate_92baa7f93b101813f38c492356c1dbf7->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 301)
16	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
17	Twig\Template->yieldBlock (line 269)
18	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
19	Twig\Template->yield (line 99)
20	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
29	App\Controller\PersonnelController->show (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 7)

0.21 ms
(2.46%)

SELECT t0.permanente AS permanente_1, t0.id AS id_2, t0.valeur AS valeur_3 FROM categorie_personnel t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.permanente AS permanente_1,
  t0.id AS id_2,
  t0.valeur AS valeur_3
FROM
  categorie_personnel t0
WHERE
  t0.id = ?

SELECT t0.permanente AS permanente_1, t0.id AS id_2, t0.valeur AS valeur_3 FROM categorie_personnel t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\CategoriePersonnel::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\CategoriePersonnel->__get (line 35)
8	App\Entity\CategoriePersonnel->__toString (line 120)
9	Twig\Runtime\EscaperRuntime->escape (line 105)
10	__TwigTemplate_b50aa76ba402a5e560dfcda6b976dedf->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1482)
15	Twig\Extension\CoreExtension::include (line 310)
16	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->block_body (line 431)
17	Twig\Template->yieldBlock (line 269)
18	__TwigTemplate_d851f6cf57e8db25c8c3c4471175fc08->doDisplay (line 387)
19	Twig\Template->yield (line 99)
20	__TwigTemplate_72917d8d58fe6c218d2a7973e8af7c90->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
29	App\Controller\PersonnelController->show (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 7)

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.

Entities Mapping

Class	Mapping errors
App\Entity\Utilisateur	No errors.
App\Entity\Equipe	No errors.
App\Entity\PlateformePlateauTechnique	No errors.
App\Entity\Personnel	No errors.
App\Entity\Position	No errors.
App\Entity\PersonnelBap	No errors.
App\Entity\PersonnelDistinction	No errors.
App\Entity\PersonnelExperience	No errors.
App\Entity\PersonnelMandat	No errors.
App\Entity\PersonnelPlateformePlateauTechnique	No errors.
App\Entity\PersonnelParticipeContrat	No errors.
App\Entity\PersonnelEquipe	No errors.
App\Entity\ResponsableDepartement	No errors.
App\Entity\Genre	No errors.
App\Entity\Nationalite	No errors.
App\Entity\These	No errors.
App\Entity\EcoleDoctorale	No errors.
App\Entity\Specialite	No errors.
App\Entity\MotClePrincipal	No errors.
App\Entity\MotCleSecondaire	No errors.
App\Entity\PersonnelPosition	No errors.
App\Entity\TheseEncadrant	No errors.
App\Entity\Contrat	No errors.
App\Entity\Departement	No errors.
App\Entity\TypeStatut	No errors.
App\Entity\TypeActivite	No errors.
App\Entity\CategoriePersonnel	The field App\Entity\CategoriePersonnel#grades is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Grade#categoriePersonnels does not contain the required 'mappedBy="grades"' attribute.
App\Entity\Grade	The field App\Entity\Grade#categoriePersonnels is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\CategoriePersonnel#grades does not contain the required 'mappedBy="categoriePersonnels"' attribute.
App\Entity\Partenaire	No errors.
App\Entity\TypeContratTravail	No errors.
App\Entity\SectionCnu	No errors.
App\Entity\SectionCnrs	No errors.
App\Entity\Site	No errors.
App\Entity\AutreActivite	No errors.
App\Entity\Quotite	No errors.
App\Entity\Etablissement	No errors.
App\Entity\Equipement	No errors.
App\Entity\CategoriePartenaire	No errors.
App\Entity\RattachementPartenaire	No errors.
App\Entity\AppelAProjet	No errors.
App\Entity\BudgetAnnuelMutualise	No errors.
App\Entity\EncadrantExterne	No errors.
App\Entity\TheseMobilite	No errors.
App\Entity\TypeAutreActivite	No errors.
App\Entity\TypeBap	No errors.
App\Entity\Mandat	No errors.
App\Entity\Distinction	No errors.
App\Entity\TypeExperience	No errors.
App\Entity\PeriodeExperience	No errors.
App\Entity\Tutelle	No errors.
App\Entity\TypeEmployeur	No errors.
App\Entity\NiveauDiplome	No errors.

Symfony Profiler

GET https://asterias.rennes.centralesupelec.fr/personnel/299

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping