Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

5.15 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.42 ms

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.46 ms

SELECT p0_.nom_usuel AS nom_usuel_0, p0_.prenom AS prenom_1, p0_.commentaire AS commentaire_2, p0_.annee_naissance AS annee_naissance_3, p0_.docteur_ietr AS docteur_ietr_4, p0_.hdr AS hdr_5, p0_.annee_obtention_hdr AS annee_obtention_hdr_6, p0_.cree_le AS cree_le_7, p0_.id AS id_8, p0_.genre_id AS genre_id_9, p0_.nationalite_id AS nationalite_id_10, p0_.createur_id AS createur_id_11 FROM personnel p0_ WHERE p0_.id IN (?) ORDER BY p0_.nom_usuel ASC

Parameters:

[
  "299"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.nom_usuel AS nom_usuel_0,
  p0_.prenom AS prenom_1,
  p0_.commentaire AS commentaire_2,
  p0_.annee_naissance AS annee_naissance_3,
  p0_.docteur_ietr AS docteur_ietr_4,
  p0_.hdr AS hdr_5,
  p0_.annee_obtention_hdr AS annee_obtention_hdr_6,
  p0_.cree_le AS cree_le_7,
  p0_.id AS id_8,
  p0_.genre_id AS genre_id_9,
  p0_.nationalite_id AS nationalite_id_10,
  p0_.createur_id AS createur_id_11
FROM
  personnel p0_
WHERE
  p0_.id IN (?)
ORDER BY
  p0_.nom_usuel ASC

SELECT p0_.nom_usuel AS nom_usuel_0, p0_.prenom AS prenom_1, p0_.commentaire AS commentaire_2, p0_.annee_naissance AS annee_naissance_3, p0_.docteur_ietr AS docteur_ietr_4, p0_.hdr AS hdr_5, p0_.annee_obtention_hdr AS annee_obtention_hdr_6, p0_.cree_le AS cree_le_7, p0_.id AS id_8, p0_.genre_id AS genre_id_9, p0_.nationalite_id AS nationalite_id_10, p0_.createur_id AS createur_id_11 FROM personnel p0_ WHERE p0_.id IN ('299') ORDER BY p0_.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 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 99)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 92)
8	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 76)
10	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 41)
11	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 1002)
12	Symfony\Component\Form\Form->viewToNorm (line 552)
13	Symfony\Component\Form\Form->submit (line 493)
14	Symfony\Component\Form\Form->submit (line 107)
15	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 414)
16	Symfony\Component\Form\Form->handleRequest (line 131)
17	App\Controller\PersonnelController->index (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 7)

1.09 ms

SELECT t0.titre AS titre_1, t0.personnel_id AS personnel_id_2, t0.autre_ecole_doctorale AS autre_ecole_doctorale_3, t0.autre_specialite AS autre_specialite_4, t0.co_tutelle AS co_tutelle_5, t0.date_premiere_inscription AS date_premiere_inscription_6, t0.date_soutenance AS date_soutenance_7, t0.duree AS duree_8, t0.abandon AS abandon_9, t0.commentaire AS commentaire_10, t0.cree_le AS cree_le_11, t0.id AS id_12, t0.ecole_doctorale_id AS ecole_doctorale_id_13, t0.specialite_id AS specialite_id_14, t0.mot_cle_pincipal_id AS mot_cle_pincipal_id_15, t0.mot_cle_secondaire_id AS mot_cle_secondaire_id_16, t0.personnel_id AS personnel_id_17, t0.createur_id AS createur_id_18 FROM these t0 WHERE t0.personnel_id = ?

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.titre AS titre_1,
  t0.personnel_id AS personnel_id_2,
  t0.autre_ecole_doctorale AS autre_ecole_doctorale_3,
  t0.autre_specialite AS autre_specialite_4,
  t0.co_tutelle AS co_tutelle_5,
  t0.date_premiere_inscription AS date_premiere_inscription_6,
  t0.date_soutenance AS date_soutenance_7,
  t0.duree AS duree_8,
  t0.abandon AS abandon_9,
  t0.commentaire AS commentaire_10,
  t0.cree_le AS cree_le_11,
  t0.id AS id_12,
  t0.ecole_doctorale_id AS ecole_doctorale_id_13,
  t0.specialite_id AS specialite_id_14,
  t0.mot_cle_pincipal_id AS mot_cle_pincipal_id_15,
  t0.mot_cle_secondaire_id AS mot_cle_secondaire_id_16,
  t0.personnel_id AS personnel_id_17,
  t0.createur_id AS createur_id_18
FROM
  these t0
WHERE
  t0.personnel_id = ?

SELECT t0.titre AS titre_1, t0.personnel_id AS personnel_id_2, t0.autre_ecole_doctorale AS autre_ecole_doctorale_3, t0.autre_specialite AS autre_specialite_4, t0.co_tutelle AS co_tutelle_5, t0.date_premiere_inscription AS date_premiere_inscription_6, t0.date_soutenance AS date_soutenance_7, t0.duree AS duree_8, t0.abandon AS abandon_9, t0.commentaire AS commentaire_10, t0.cree_le AS cree_le_11, t0.id AS id_12, t0.ecole_doctorale_id AS ecole_doctorale_id_13, t0.specialite_id AS specialite_id_14, t0.mot_cle_pincipal_id AS mot_cle_pincipal_id_15, t0.mot_cle_secondaire_id AS mot_cle_secondaire_id_16, t0.personnel_id AS personnel_id_17, t0.createur_id AS createur_id_18 FROM these t0 WHERE t0.personnel_id = 299;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 876)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3027)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 502)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 272)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1231)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
10	Doctrine\ORM\AbstractQuery->execute (line 907)
11	Doctrine\ORM\AbstractQuery->getResult (line 99)
12	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 92)
13	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 38)
14	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 76)
15	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 41)
16	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 1002)
17	Symfony\Component\Form\Form->viewToNorm (line 552)
18	Symfony\Component\Form\Form->submit (line 493)
19	Symfony\Component\Form\Form->submit (line 107)
20	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 414)
21	Symfony\Component\Form\Form->handleRequest (line 131)
22	App\Controller\PersonnelController->index (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 7)

3.19 ms

SELECT p0_.nom_usuel AS nom_usuel_0, p0_.prenom AS prenom_1, p0_.commentaire AS commentaire_2, p0_.annee_naissance AS annee_naissance_3, p0_.docteur_ietr AS docteur_ietr_4, p0_.hdr AS hdr_5, p0_.annee_obtention_hdr AS annee_obtention_hdr_6, p0_.cree_le AS cree_le_7, p0_.id AS id_8, p0_.genre_id AS genre_id_9, p0_.nationalite_id AS nationalite_id_10, p0_.createur_id AS createur_id_11 FROM personnel p0_ LEFT JOIN personnel_equipe p1_ ON p0_.id = p1_.personnel_id LEFT JOIN equipe e2_ ON p1_.equipe_id = e2_.id LEFT JOIN personnel_position p3_ ON p0_.id = p3_.personnel_id LEFT JOIN position p4_ ON p3_.position_id = p4_.id LEFT JOIN categorie_personnel c5_ ON p4_.categorie_personnel_id = c5_.id LEFT JOIN partenaire p6_ ON p4_.partenaire_id = p6_.id LEFT JOIN responsable_departement r7_ ON p0_.id = r7_.personnel_id LEFT JOIN personnel_plateforme_plateau_technique p8_ ON p0_.id = p8_.personnel_id LEFT JOIN plateforme_plateau_technique p9_ ON p8_.plateforme_plateau_technique_id = p9_.id LEFT JOIN personnel_participe_contrat p10_ ON p0_.id = p10_.personnel_id LEFT JOIN site s11_ ON p4_.site_id = s11_.id LEFT JOIN etablissement e12_ ON s11_.etablissement_id = e12_.id WHERE p0_.id = ? ORDER BY p0_.nom_usuel ASC

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.nom_usuel AS nom_usuel_0,
  p0_.prenom AS prenom_1,
  p0_.commentaire AS commentaire_2,
  p0_.annee_naissance AS annee_naissance_3,
  p0_.docteur_ietr AS docteur_ietr_4,
  p0_.hdr AS hdr_5,
  p0_.annee_obtention_hdr AS annee_obtention_hdr_6,
  p0_.cree_le AS cree_le_7,
  p0_.id AS id_8,
  p0_.genre_id AS genre_id_9,
  p0_.nationalite_id AS nationalite_id_10,
  p0_.createur_id AS createur_id_11
FROM
  personnel p0_
  LEFT JOIN personnel_equipe p1_ ON p0_.id = p1_.personnel_id
  LEFT JOIN equipe e2_ ON p1_.equipe_id = e2_.id
  LEFT JOIN personnel_position p3_ ON p0_.id = p3_.personnel_id
  LEFT JOIN position p4_ ON p3_.position_id = p4_.id
  LEFT JOIN categorie_personnel c5_ ON p4_.categorie_personnel_id = c5_.id
  LEFT JOIN partenaire p6_ ON p4_.partenaire_id = p6_.id
  LEFT JOIN responsable_departement r7_ ON p0_.id = r7_.personnel_id
  LEFT JOIN personnel_plateforme_plateau_technique p8_ ON p0_.id = p8_.personnel_id
  LEFT JOIN plateforme_plateau_technique p9_ ON p8_.plateforme_plateau_technique_id = p9_.id
  LEFT JOIN personnel_participe_contrat p10_ ON p0_.id = p10_.personnel_id
  LEFT JOIN site s11_ ON p4_.site_id = s11_.id
  LEFT JOIN etablissement e12_ ON s11_.etablissement_id = e12_.id
WHERE
  p0_.id = ?
ORDER BY
  p0_.nom_usuel ASC

SELECT p0_.nom_usuel AS nom_usuel_0, p0_.prenom AS prenom_1, p0_.commentaire AS commentaire_2, p0_.annee_naissance AS annee_naissance_3, p0_.docteur_ietr AS docteur_ietr_4, p0_.hdr AS hdr_5, p0_.annee_obtention_hdr AS annee_obtention_hdr_6, p0_.cree_le AS cree_le_7, p0_.id AS id_8, p0_.genre_id AS genre_id_9, p0_.nationalite_id AS nationalite_id_10, p0_.createur_id AS createur_id_11 FROM personnel p0_ LEFT JOIN personnel_equipe p1_ ON p0_.id = p1_.personnel_id LEFT JOIN equipe e2_ ON p1_.equipe_id = e2_.id LEFT JOIN personnel_position p3_ ON p0_.id = p3_.personnel_id LEFT JOIN position p4_ ON p3_.position_id = p4_.id LEFT JOIN categorie_personnel c5_ ON p4_.categorie_personnel_id = c5_.id LEFT JOIN partenaire p6_ ON p4_.partenaire_id = p6_.id LEFT JOIN responsable_departement r7_ ON p0_.id = r7_.personnel_id LEFT JOIN personnel_plateforme_plateau_technique p8_ ON p0_.id = p8_.personnel_id LEFT JOIN plateforme_plateau_technique p9_ ON p8_.plateforme_plateau_technique_id = p9_.id LEFT JOIN personnel_participe_contrat p10_ ON p0_.id = p10_.personnel_id LEFT JOIN site s11_ ON p4_.site_id = s11_.id LEFT JOIN etablissement e12_ ON s11_.etablissement_id = e12_.id WHERE p0_.id = 299 ORDER BY p0_.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 48)
6	App\Repository\PersonnelRepository->getAll (line 33)
7	App\Service\PersonnelService->getAll (line 134)
8	App\Controller\PersonnelController->index (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)

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\Departement	No errors.
App\Entity\Etablissement	No errors.
App\Entity\Contrat	No errors.
App\Entity\PerimetreContrat	No errors.
App\Entity\TypeContrat	No errors.
App\Entity\MotClePrincipal	No errors.
App\Entity\MotCleSecondaire	No errors.
App\Entity\Dis	No errors.
App\Entity\Trl	No errors.
App\Entity\AppelAProjet	No errors.
App\Entity\Partenaire	No errors.
App\Entity\Genre	No errors.
App\Entity\Nationalite	No errors.
App\Entity\CategoriePartenaire	No errors.
App\Entity\RattachementPartenaire	No errors.
App\Entity\PersonnelPosition	No errors.
App\Entity\These	No errors.
App\Entity\EcoleDoctorale	No errors.
App\Entity\Specialite	No errors.
App\Entity\TheseEncadrant	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\Site	No errors.

Symfony Profiler

GET https://asterias.rennes.centralesupelec.fr/personnel/?personnel_search%5Bequipe%5D=&personnel_search%5Betablissement%5D=&personnel_search%5Bdepartement%5D=&pers…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping