Symfony Profiler

Query Metrics

15 Database Queries

11 Different statements

35.98 ms Query time

0 Invalid entities

21 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.55 ms
(32.11%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.type AS type_5, t0.image AS image_6, t0.prenom AS prenom_7, t0.nom AS nom_8, t0.ref AS ref_9, t0.organisme AS organisme_10, t0.archive AS archive_11, t0.cree_le AS cree_le_12, t0.modifie_le AS modifie_le_13, t0.alerte AS alerte_14, t15.id AS id_16, t15.cree_le AS cree_le_17, t15.modifie_le AS modifie_le_18, t15.civilite AS civilite_19, t15.nom_usage AS nom_usage_20, t15.identifiant_externe AS identifiant_externe_21, t15.date_naissance AS date_naissance_22, t15.ville_naissance AS ville_naissance_23, t15.dept_naissance AS dept_naissance_24, t15.pays_naissance AS pays_naissance_25, t15.nationalite AS nationalite_26, t15.telephone AS telephone_27, t15.email AS email_28, t15.adresse AS adresse_29, t15.ville AS ville_30, t15.code_postal AS code_postal_31, t15.pays AS pays_32, t15.contact_nom AS contact_nom_33, t15.contact_telephone AS contact_telephone_34, t15.niveau_etudes AS niveau_etudes_35, t15.dernier_diplome AS dernier_diplome_36, t15.dernier_emploi AS dernier_emploi_37, t15.dernier_emploi_date AS dernier_emploi_date_38, t15.dernier_emploi_fonction AS dernier_emploi_fonction_39, t15.exp_pro AS exp_pro_40, t15.exp_pro_date AS exp_pro_date_41, t15.exp_pro_fonction AS exp_pro_fonction_42, t15.securite_sociale AS securite_sociale_43, t15.archive AS archive_44, t15.handicap AS handicap_45, t15.is_facturation AS is_facturation_46, t15.utilisateur_id AS utilisateur_id_47, t15.formation_id AS formation_id_48, t15.suivi_id AS suivi_id_49, t50.id AS id_51, t50.cree_le AS cree_le_52, t50.modifie_le AS modifie_le_53, t50.denomination AS denomination_54, t50.siret AS siret_55, t50.siege AS siege_56, t50.ville AS ville_57, t50.telephone AS telephone_58, t50.code_postal AS code_postal_59, t50.cv AS cv_60, t50.urssaf AS urssaf_61, t50.rcpro AS rcpro_62, t50.niveau_etude AS niveau_etude_63, t50.banni AS banni_64, t50.archive AS archive_65, t50.utilisateur_id AS utilisateur_id_66 FROM utilisateur t0 LEFT JOIN fiche t15 ON t15.utilisateur_id = t0.id LEFT JOIN formateur t50 ON t50.utilisateur_id = t0.id WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.type AS type_5,
  t0.image AS image_6,
  t0.prenom AS prenom_7,
  t0.nom AS nom_8,
  t0.ref AS ref_9,
  t0.organisme AS organisme_10,
  t0.archive AS archive_11,
  t0.cree_le AS cree_le_12,
  t0.modifie_le AS modifie_le_13,
  t0.alerte AS alerte_14,
  t15.id AS id_16,
  t15.cree_le AS cree_le_17,
  t15.modifie_le AS modifie_le_18,
  t15.civilite AS civilite_19,
  t15.nom_usage AS nom_usage_20,
  t15.identifiant_externe AS identifiant_externe_21,
  t15.date_naissance AS date_naissance_22,
  t15.ville_naissance AS ville_naissance_23,
  t15.dept_naissance AS dept_naissance_24,
  t15.pays_naissance AS pays_naissance_25,
  t15.nationalite AS nationalite_26,
  t15.telephone AS telephone_27,
  t15.email AS email_28,
  t15.adresse AS adresse_29,
  t15.ville AS ville_30,
  t15.code_postal AS code_postal_31,
  t15.pays AS pays_32,
  t15.contact_nom AS contact_nom_33,
  t15.contact_telephone AS contact_telephone_34,
  t15.niveau_etudes AS niveau_etudes_35,
  t15.dernier_diplome AS dernier_diplome_36,
  t15.dernier_emploi AS dernier_emploi_37,
  t15.dernier_emploi_date AS dernier_emploi_date_38,
  t15.dernier_emploi_fonction AS dernier_emploi_fonction_39,
  t15.exp_pro AS exp_pro_40,
  t15.exp_pro_date AS exp_pro_date_41,
  t15.exp_pro_fonction AS exp_pro_fonction_42,
  t15.securite_sociale AS securite_sociale_43,
  t15.archive AS archive_44,
  t15.handicap AS handicap_45,
  t15.is_facturation AS is_facturation_46,
  t15.utilisateur_id AS utilisateur_id_47,
  t15.formation_id AS formation_id_48,
  t15.suivi_id AS suivi_id_49,
  t50.id AS id_51,
  t50.cree_le AS cree_le_52,
  t50.modifie_le AS modifie_le_53,
  t50.denomination AS denomination_54,
  t50.siret AS siret_55,
  t50.siege AS siege_56,
  t50.ville AS ville_57,
  t50.telephone AS telephone_58,
  t50.code_postal AS code_postal_59,
  t50.cv AS cv_60,
  t50.urssaf AS urssaf_61,
  t50.rcpro AS rcpro_62,
  t50.niveau_etude AS niveau_etude_63,
  t50.banni AS banni_64,
  t50.archive AS archive_65,
  t50.utilisateur_id AS utilisateur_id_66
FROM
  utilisateur t0
  LEFT JOIN fiche t15 ON t15.utilisateur_id = t0.id
  LEFT JOIN formateur t50 ON t50.utilisateur_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.type AS type_5, t0.image AS image_6, t0.prenom AS prenom_7, t0.nom AS nom_8, t0.ref AS ref_9, t0.organisme AS organisme_10, t0.archive AS archive_11, t0.cree_le AS cree_le_12, t0.modifie_le AS modifie_le_13, t0.alerte AS alerte_14, t15.id AS id_16, t15.cree_le AS cree_le_17, t15.modifie_le AS modifie_le_18, t15.civilite AS civilite_19, t15.nom_usage AS nom_usage_20, t15.identifiant_externe AS identifiant_externe_21, t15.date_naissance AS date_naissance_22, t15.ville_naissance AS ville_naissance_23, t15.dept_naissance AS dept_naissance_24, t15.pays_naissance AS pays_naissance_25, t15.nationalite AS nationalite_26, t15.telephone AS telephone_27, t15.email AS email_28, t15.adresse AS adresse_29, t15.ville AS ville_30, t15.code_postal AS code_postal_31, t15.pays AS pays_32, t15.contact_nom AS contact_nom_33, t15.contact_telephone AS contact_telephone_34, t15.niveau_etudes AS niveau_etudes_35, t15.dernier_diplome AS dernier_diplome_36, t15.dernier_emploi AS dernier_emploi_37, t15.dernier_emploi_date AS dernier_emploi_date_38, t15.dernier_emploi_fonction AS dernier_emploi_fonction_39, t15.exp_pro AS exp_pro_40, t15.exp_pro_date AS exp_pro_date_41, t15.exp_pro_fonction AS exp_pro_fonction_42, t15.securite_sociale AS securite_sociale_43, t15.archive AS archive_44, t15.handicap AS handicap_45, t15.is_facturation AS is_facturation_46, t15.utilisateur_id AS utilisateur_id_47, t15.formation_id AS formation_id_48, t15.suivi_id AS suivi_id_49, t50.id AS id_51, t50.cree_le AS cree_le_52, t50.modifie_le AS modifie_le_53, t50.denomination AS denomination_54, t50.siret AS siret_55, t50.siege AS siege_56, t50.ville AS ville_57, t50.telephone AS telephone_58, t50.code_postal AS code_postal_59, t50.cv AS cv_60, t50.urssaf AS urssaf_61, t50.rcpro AS rcpro_62, t50.niveau_etude AS niveau_etude_63, t50.banni AS banni_64, t50.archive AS archive_65, t50.utilisateur_id AS utilisateur_id_66 FROM utilisateur t0 LEFT JOIN fiche t15 ON t15.utilisateur_id = t0.id LEFT JOIN formateur t50 ON t50.utilisateur_id = t0.id WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
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 5)

5.13 ms
(14.25%)

SELECT t0.id AS id_1, t0.cree_le AS cree_le_2, t0.modifie_le AS modifie_le_3, t0.nom AS nom_4, t0.code AS code_5, t0.description AS description_6, t0.archive AS archive_7, t0.diplome_id AS diplome_id_8 FROM formation t0 WHERE t0.id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cree_le AS cree_le_2,
  t0.modifie_le AS modifie_le_3,
  t0.nom AS nom_4,
  t0.code AS code_5,
  t0.description AS description_6,
  t0.archive AS archive_7,
  t0.diplome_id AS diplome_id_8
FROM
  formation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cree_le AS cree_le_2, t0.modifie_le AS modifie_le_3, t0.nom AS nom_4, t0.code AS code_5, t0.description AS description_6, t0.archive AS archive_7, t0.diplome_id AS diplome_id_8 FROM formation t0 WHERE t0.id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():280} (line 359)
5	Proxies\__CG__\App\Entity\Formation::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():357}:358} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Formation->__get (line 112)
8	App\Entity\Formation->getDiplome (line 513)
9	App\Controller\FicheController->buildLivretEvaluationData (line 264)
10	App\Controller\FicheController->voirDocumentSession (line 183)
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 5)

4.38 ms
(12.16%)

SELECT t0.id AS id_1, t0.cree_le AS cree_le_2, t0.modifie_le AS modifie_le_3, t0.nom AS nom_4, t0.debut AS debut_5, t0.fin AS fin_6, t0.duree_formation AS duree_formation_7, t0.debut_stage AS debut_stage_8, t0.fin_stage AS fin_stage_9, t0.duree_stage AS duree_stage_10, t0.archive AS archive_11, t0.type AS type_12, t0.formation_id AS formation_id_13 FROM session t0 INNER JOIN session_utilisateur ON t0.id = session_utilisateur.session_id WHERE session_utilisateur.utilisateur_id = ?

Parameters:

[
  279
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cree_le AS cree_le_2,
  t0.modifie_le AS modifie_le_3,
  t0.nom AS nom_4,
  t0.debut AS debut_5,
  t0.fin AS fin_6,
  t0.duree_formation AS duree_formation_7,
  t0.debut_stage AS debut_stage_8,
  t0.fin_stage AS fin_stage_9,
  t0.duree_stage AS duree_stage_10,
  t0.archive AS archive_11,
  t0.type AS type_12,
  t0.formation_id AS formation_id_13
FROM
  session t0
  INNER JOIN session_utilisateur ON t0.id = session_utilisateur.session_id
WHERE
  session_utilisateur.utilisateur_id = ?

SELECT t0.id AS id_1, t0.cree_le AS cree_le_2, t0.modifie_le AS modifie_le_3, t0.nom AS nom_4, t0.debut AS debut_5, t0.fin AS fin_6, t0.duree_formation AS duree_formation_7, t0.debut_stage AS debut_stage_8, t0.fin_stage AS fin_stage_9, t0.duree_stage AS duree_stage_10, t0.archive AS archive_11, t0.type AS type_12, t0.formation_id AS formation_id_13 FROM session t0 INNER JOIN session_utilisateur ON t0.id = session_utilisateur.session_id WHERE session_utilisateur.utilisateur_id = 279;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2724)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 237)
7	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 249)
8	App\Controller\FicheController->voirDocumentSession (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 5)

2.64 ms
(7.34%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_cp AS numero_cp_3, t0.description AS description_4, t0.cree_le AS cree_le_5, t0.modifie_le AS modifie_le_6, t0.archive AS archive_7, t0.bloc_id AS bloc_id_8 FROM competence t0 INNER JOIN evaluation_competence ON t0.id = evaluation_competence.competence_id WHERE evaluation_competence.evaluation_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.numero_cp AS numero_cp_3,
  t0.description AS description_4,
  t0.cree_le AS cree_le_5,
  t0.modifie_le AS modifie_le_6,
  t0.archive AS archive_7,
  t0.bloc_id AS bloc_id_8
FROM
  competence t0
  INNER JOIN evaluation_competence ON t0.id = evaluation_competence.competence_id
WHERE
  evaluation_competence.evaluation_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_cp AS numero_cp_3, t0.description AS description_4, t0.cree_le AS cree_le_5, t0.modifie_le AS modifie_le_6, t0.archive AS archive_7, t0.bloc_id AS bloc_id_8 FROM competence t0 INNER JOIN evaluation_competence ON t0.id = evaluation_competence.competence_id WHERE evaluation_competence.evaluation_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2724)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 535)
8	App\Controller\FicheController->buildLivretEvaluationData (line 264)
9	App\Controller\FicheController->voirDocumentSession (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

2.53 ms
(7.03%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.type AS type_5, t0.image AS image_6, t0.prenom AS prenom_7, t0.nom AS nom_8, t0.ref AS ref_9, t0.organisme AS organisme_10, t0.archive AS archive_11, t0.cree_le AS cree_le_12, t0.modifie_le AS modifie_le_13, t0.alerte AS alerte_14, t15.id AS id_16, t15.cree_le AS cree_le_17, t15.modifie_le AS modifie_le_18, t15.civilite AS civilite_19, t15.nom_usage AS nom_usage_20, t15.identifiant_externe AS identifiant_externe_21, t15.date_naissance AS date_naissance_22, t15.ville_naissance AS ville_naissance_23, t15.dept_naissance AS dept_naissance_24, t15.pays_naissance AS pays_naissance_25, t15.nationalite AS nationalite_26, t15.telephone AS telephone_27, t15.email AS email_28, t15.adresse AS adresse_29, t15.ville AS ville_30, t15.code_postal AS code_postal_31, t15.pays AS pays_32, t15.contact_nom AS contact_nom_33, t15.contact_telephone AS contact_telephone_34, t15.niveau_etudes AS niveau_etudes_35, t15.dernier_diplome AS dernier_diplome_36, t15.dernier_emploi AS dernier_emploi_37, t15.dernier_emploi_date AS dernier_emploi_date_38, t15.dernier_emploi_fonction AS dernier_emploi_fonction_39, t15.exp_pro AS exp_pro_40, t15.exp_pro_date AS exp_pro_date_41, t15.exp_pro_fonction AS exp_pro_fonction_42, t15.securite_sociale AS securite_sociale_43, t15.archive AS archive_44, t15.handicap AS handicap_45, t15.is_facturation AS is_facturation_46, t15.utilisateur_id AS utilisateur_id_47, t15.formation_id AS formation_id_48, t15.suivi_id AS suivi_id_49, t50.id AS id_51, t50.cree_le AS cree_le_52, t50.modifie_le AS modifie_le_53, t50.denomination AS denomination_54, t50.siret AS siret_55, t50.siege AS siege_56, t50.ville AS ville_57, t50.telephone AS telephone_58, t50.code_postal AS code_postal_59, t50.cv AS cv_60, t50.urssaf AS urssaf_61, t50.rcpro AS rcpro_62, t50.niveau_etude AS niveau_etude_63, t50.banni AS banni_64, t50.archive AS archive_65, t50.utilisateur_id AS utilisateur_id_66 FROM utilisateur t0 LEFT JOIN fiche t15 ON t15.utilisateur_id = t0.id LEFT JOIN formateur t50 ON t50.utilisateur_id = t0.id WHERE t0.ref = ? LIMIT 1

Parameters:

[
  "USR-694be9ded80f0"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.type AS type_5,
  t0.image AS image_6,
  t0.prenom AS prenom_7,
  t0.nom AS nom_8,
  t0.ref AS ref_9,
  t0.organisme AS organisme_10,
  t0.archive AS archive_11,
  t0.cree_le AS cree_le_12,
  t0.modifie_le AS modifie_le_13,
  t0.alerte AS alerte_14,
  t15.id AS id_16,
  t15.cree_le AS cree_le_17,
  t15.modifie_le AS modifie_le_18,
  t15.civilite AS civilite_19,
  t15.nom_usage AS nom_usage_20,
  t15.identifiant_externe AS identifiant_externe_21,
  t15.date_naissance AS date_naissance_22,
  t15.ville_naissance AS ville_naissance_23,
  t15.dept_naissance AS dept_naissance_24,
  t15.pays_naissance AS pays_naissance_25,
  t15.nationalite AS nationalite_26,
  t15.telephone AS telephone_27,
  t15.email AS email_28,
  t15.adresse AS adresse_29,
  t15.ville AS ville_30,
  t15.code_postal AS code_postal_31,
  t15.pays AS pays_32,
  t15.contact_nom AS contact_nom_33,
  t15.contact_telephone AS contact_telephone_34,
  t15.niveau_etudes AS niveau_etudes_35,
  t15.dernier_diplome AS dernier_diplome_36,
  t15.dernier_emploi AS dernier_emploi_37,
  t15.dernier_emploi_date AS dernier_emploi_date_38,
  t15.dernier_emploi_fonction AS dernier_emploi_fonction_39,
  t15.exp_pro AS exp_pro_40,
  t15.exp_pro_date AS exp_pro_date_41,
  t15.exp_pro_fonction AS exp_pro_fonction_42,
  t15.securite_sociale AS securite_sociale_43,
  t15.archive AS archive_44,
  t15.handicap AS handicap_45,
  t15.is_facturation AS is_facturation_46,
  t15.utilisateur_id AS utilisateur_id_47,
  t15.formation_id AS formation_id_48,
  t15.suivi_id AS suivi_id_49,
  t50.id AS id_51,
  t50.cree_le AS cree_le_52,
  t50.modifie_le AS modifie_le_53,
  t50.denomination AS denomination_54,
  t50.siret AS siret_55,
  t50.siege AS siege_56,
  t50.ville AS ville_57,
  t50.telephone AS telephone_58,
  t50.code_postal AS code_postal_59,
  t50.cv AS cv_60,
  t50.urssaf AS urssaf_61,
  t50.rcpro AS rcpro_62,
  t50.niveau_etude AS niveau_etude_63,
  t50.banni AS banni_64,
  t50.archive AS archive_65,
  t50.utilisateur_id AS utilisateur_id_66
FROM
  utilisateur t0
  LEFT JOIN fiche t15 ON t15.utilisateur_id = t0.id
  LEFT JOIN formateur t50 ON t50.utilisateur_id = t0.id
WHERE
  t0.ref = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.type AS type_5, t0.image AS image_6, t0.prenom AS prenom_7, t0.nom AS nom_8, t0.ref AS ref_9, t0.organisme AS organisme_10, t0.archive AS archive_11, t0.cree_le AS cree_le_12, t0.modifie_le AS modifie_le_13, t0.alerte AS alerte_14, t15.id AS id_16, t15.cree_le AS cree_le_17, t15.modifie_le AS modifie_le_18, t15.civilite AS civilite_19, t15.nom_usage AS nom_usage_20, t15.identifiant_externe AS identifiant_externe_21, t15.date_naissance AS date_naissance_22, t15.ville_naissance AS ville_naissance_23, t15.dept_naissance AS dept_naissance_24, t15.pays_naissance AS pays_naissance_25, t15.nationalite AS nationalite_26, t15.telephone AS telephone_27, t15.email AS email_28, t15.adresse AS adresse_29, t15.ville AS ville_30, t15.code_postal AS code_postal_31, t15.pays AS pays_32, t15.contact_nom AS contact_nom_33, t15.contact_telephone AS contact_telephone_34, t15.niveau_etudes AS niveau_etudes_35, t15.dernier_diplome AS dernier_diplome_36, t15.dernier_emploi AS dernier_emploi_37, t15.dernier_emploi_date AS dernier_emploi_date_38, t15.dernier_emploi_fonction AS dernier_emploi_fonction_39, t15.exp_pro AS exp_pro_40, t15.exp_pro_date AS exp_pro_date_41, t15.exp_pro_fonction AS exp_pro_fonction_42, t15.securite_sociale AS securite_sociale_43, t15.archive AS archive_44, t15.handicap AS handicap_45, t15.is_facturation AS is_facturation_46, t15.utilisateur_id AS utilisateur_id_47, t15.formation_id AS formation_id_48, t15.suivi_id AS suivi_id_49, t50.id AS id_51, t50.cree_le AS cree_le_52, t50.modifie_le AS modifie_le_53, t50.denomination AS denomination_54, t50.siret AS siret_55, t50.siege AS siege_56, t50.ville AS ville_57, t50.telephone AS telephone_58, t50.code_postal AS code_postal_59, t50.cv AS cv_60, t50.urssaf AS urssaf_61, t50.rcpro AS rcpro_62, t50.niveau_etude AS niveau_etude_63, t50.banni AS banni_64, t50.archive AS archive_65, t50.utilisateur_id AS utilisateur_id_66 FROM utilisateur t0 LEFT JOIN fiche t15 ON t15.utilisateur_id = t0.id LEFT JOIN formateur t50 ON t50.utilisateur_id = t0.id WHERE t0.ref = 'USR-694be9ded80f0' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 242)
5	App\Controller\FicheController->voirDocumentSession (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

2.36 ms
(6.57%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_cp AS numero_cp_3, t0.description AS description_4, t0.cree_le AS cree_le_5, t0.modifie_le AS modifie_le_6, t0.archive AS archive_7, t0.bloc_id AS bloc_id_8 FROM competence t0 INNER JOIN note_evaluation_competence ON t0.id = note_evaluation_competence.competence_id WHERE note_evaluation_competence.note_evaluation_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.numero_cp AS numero_cp_3,
  t0.description AS description_4,
  t0.cree_le AS cree_le_5,
  t0.modifie_le AS modifie_le_6,
  t0.archive AS archive_7,
  t0.bloc_id AS bloc_id_8
FROM
  competence t0
  INNER JOIN note_evaluation_competence ON t0.id = note_evaluation_competence.competence_id
WHERE
  note_evaluation_competence.note_evaluation_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_cp AS numero_cp_3, t0.description AS description_4, t0.cree_le AS cree_le_5, t0.modifie_le AS modifie_le_6, t0.archive AS archive_7, t0.bloc_id AS bloc_id_8 FROM competence t0 INNER JOIN note_evaluation_competence ON t0.id = note_evaluation_competence.competence_id WHERE note_evaluation_competence.note_evaluation_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2724)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 349)
8	__TwigTemplate_f26f39e2248a45a03064457038831dac->{closure:__TwigTemplate_f26f39e2248a45a03064457038831dac::doDisplay():66} (line 2106)
9	Twig\Extension\CoreExtension::captureOutput (line 66)
10	__TwigTemplate_f26f39e2248a45a03064457038831dac->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 267)
19	App\Controller\FicheController->voirDocumentSession (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

2.25 ms
(6.27%)

SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.date AS date_2, e0_.rattrapage AS rattrapage_3, e0_.description AS description_4, e0_.cree_le AS cree_le_5, e0_.modifie_le AS modifie_le_6, e0_.archive AS archive_7, e0_.formateur_id AS formateur_id_8 FROM evaluation e0_ INNER JOIN evaluation_session e2_ ON e0_.id = e2_.evaluation_id INNER JOIN session s1_ ON s1_.id = e2_.session_id WHERE s1_.id = ? ORDER BY e0_.date ASC

Parameters:

[
  467
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.nom AS nom_1,
  e0_.date AS date_2,
  e0_.rattrapage AS rattrapage_3,
  e0_.description AS description_4,
  e0_.cree_le AS cree_le_5,
  e0_.modifie_le AS modifie_le_6,
  e0_.archive AS archive_7,
  e0_.formateur_id AS formateur_id_8
FROM
  evaluation e0_
  INNER JOIN evaluation_session e2_ ON e0_.id = e2_.evaluation_id
  INNER JOIN session s1_ ON s1_.id = e2_.session_id
WHERE
  s1_.id = ?
ORDER BY
  e0_.date ASC

SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.date AS date_2, e0_.rattrapage AS rattrapage_3, e0_.description AS description_4, e0_.cree_le AS cree_le_5, e0_.modifie_le AS modifie_le_6, e0_.archive AS archive_7, e0_.formateur_id AS formateur_id_8 FROM evaluation e0_ INNER JOIN evaluation_session e2_ ON e0_.id = e2_.evaluation_id INNER JOIN session s1_ ON s1_.id = e2_.session_id WHERE s1_.id = 467 ORDER BY e0_.date ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 30)
7	App\Repository\EvaluationRepository->findBySession (line 524)
8	App\Controller\FicheController->buildLivretEvaluationData (line 264)
9	App\Controller\FicheController->voirDocumentSession (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.59 ms
(4.42%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contenu AS contenu_3, t0.cree_le AS cree_le_4, t0.modifie_le AS modifie_le_5, t0.archive AS archive_6, t0.diplome_id AS diplome_id_7 FROM bloc t0 WHERE t0.diplome_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.contenu AS contenu_3,
  t0.cree_le AS cree_le_4,
  t0.modifie_le AS modifie_le_5,
  t0.archive AS archive_6,
  t0.diplome_id AS diplome_id_7
FROM
  bloc t0
WHERE
  t0.diplome_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contenu AS contenu_3, t0.cree_le AS cree_le_4, t0.modifie_le AS modifie_le_5, t0.archive AS archive_6, t0.diplome_id AS diplome_id_7 FROM bloc t0 WHERE t0.diplome_id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 237)
7	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 518)
8	App\Controller\FicheController->buildLivretEvaluationData (line 264)
9	App\Controller\FicheController->voirDocumentSession (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.46 ms
(4.06%)

SELECT t0.id AS id_1, t0.numero_fiche AS numero_fiche_2, t0.intitule AS intitule_3, t0.abrege_libelle AS abrege_libelle_4, t0.abrege_intitule AS abrege_intitule_5, t0.nomenclature_europe_niveau AS nomenclature_europe_niveau_6, t0.nomenclature_europe_intitule AS nomenclature_europe_intitule_7, t0.date_decision AS date_decision_8, t0.date_fin_enregistrement AS date_fin_enregistrement_9, t0.date_effet AS date_effet_10, t0.actif AS actif_11, t0.archive AS archive_12, t0.cree_le AS cree_le_13, t0.modifie_le AS modifie_le_14, t0.referent_id AS referent_id_15 FROM diplome t0 WHERE t0.id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.numero_fiche AS numero_fiche_2,
  t0.intitule AS intitule_3,
  t0.abrege_libelle AS abrege_libelle_4,
  t0.abrege_intitule AS abrege_intitule_5,
  t0.nomenclature_europe_niveau AS nomenclature_europe_niveau_6,
  t0.nomenclature_europe_intitule AS nomenclature_europe_intitule_7,
  t0.date_decision AS date_decision_8,
  t0.date_fin_enregistrement AS date_fin_enregistrement_9,
  t0.date_effet AS date_effet_10,
  t0.actif AS actif_11,
  t0.archive AS archive_12,
  t0.cree_le AS cree_le_13,
  t0.modifie_le AS modifie_le_14,
  t0.referent_id AS referent_id_15
FROM
  diplome t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numero_fiche AS numero_fiche_2, t0.intitule AS intitule_3, t0.abrege_libelle AS abrege_libelle_4, t0.abrege_intitule AS abrege_intitule_5, t0.nomenclature_europe_niveau AS nomenclature_europe_niveau_6, t0.nomenclature_europe_intitule AS nomenclature_europe_intitule_7, t0.date_decision AS date_decision_8, t0.date_fin_enregistrement AS date_fin_enregistrement_9, t0.date_effet AS date_effet_10, t0.actif AS actif_11, t0.archive AS archive_12, t0.cree_le AS cree_le_13, t0.modifie_le AS modifie_le_14, t0.referent_id AS referent_id_15 FROM diplome t0 WHERE t0.id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():280} (line 359)
5	Proxies\__CG__\App\Entity\Diplome::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():357}:358} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Diplome->__get (line 234)
8	App\Entity\Diplome->getBlocs (line 518)
9	App\Controller\FicheController->buildLivretEvaluationData (line 264)
10	App\Controller\FicheController->voirDocumentSession (line 183)
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 5)

1.07 ms
(2.98%)

SELECT t0.id AS id_1, t0.note AS note_2, t0.appreciation AS appreciation_3, t0.cree_le AS cree_le_4, t0.modifie_le AS modifie_le_5, t0.evaluation_id AS evaluation_id_6, t0.apprenant_id AS apprenant_id_7 FROM note_evaluation t0 WHERE t0.evaluation_id = ? AND t0.apprenant_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.note AS note_2,
  t0.appreciation AS appreciation_3,
  t0.cree_le AS cree_le_4,
  t0.modifie_le AS modifie_le_5,
  t0.evaluation_id AS evaluation_id_6,
  t0.apprenant_id AS apprenant_id_7
FROM
  note_evaluation t0
WHERE
  t0.evaluation_id = ?
  AND t0.apprenant_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.note AS note_2, t0.appreciation AS appreciation_3, t0.cree_le AS cree_le_4, t0.modifie_le AS modifie_le_5, t0.evaluation_id AS evaluation_id_6, t0.apprenant_id AS apprenant_id_7 FROM note_evaluation t0 WHERE t0.evaluation_id = 2 AND t0.apprenant_id = 279 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 29)
5	App\Repository\NoteEvaluationRepository->findOneByEvaluationAndApprenant (line 555)
6	App\Controller\FicheController->buildLivretEvaluationData (line 264)
7	App\Controller\FicheController->voirDocumentSession (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 5)

1.01 ms
(2.82%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_cp AS numero_cp_3, t0.description AS description_4, t0.cree_le AS cree_le_5, t0.modifie_le AS modifie_le_6, t0.archive AS archive_7, t0.bloc_id AS bloc_id_8 FROM competence t0 WHERE t0.bloc_id = ?

Parameters:

[
  84
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.numero_cp AS numero_cp_3,
  t0.description AS description_4,
  t0.cree_le AS cree_le_5,
  t0.modifie_le AS modifie_le_6,
  t0.archive AS archive_7,
  t0.bloc_id AS bloc_id_8
FROM
  competence t0
WHERE
  t0.bloc_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_cp AS numero_cp_3, t0.description AS description_4, t0.cree_le AS cree_le_5, t0.modifie_le AS modifie_le_6, t0.archive AS archive_7, t0.bloc_id AS bloc_id_8 FROM competence t0 WHERE t0.bloc_id = 84;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 1)
8	IteratorIterator->__construct (line 1970)
9	Twig\Extension\CoreExtension::filter (line 228)
10	__TwigTemplate_f26f39e2248a45a03064457038831dac->{closure:__TwigTemplate_f26f39e2248a45a03064457038831dac::doDisplay():66} (line 2106)
11	Twig\Extension\CoreExtension::captureOutput (line 66)
12	__TwigTemplate_f26f39e2248a45a03064457038831dac->doDisplay (line 402)
13	Twig\Template->yield (line 358)
14	Twig\Template->display (line 373)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 333)
17	Twig\Environment->render (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 267)
21	App\Controller\FicheController->voirDocumentSession (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\Competence	8
App\Entity\Utilisateur	2
App\Entity\Bloc	2
App\Entity\Evaluation	2
App\Entity\NoteEvaluation	2
App\Entity\Formateur	1
App\Entity\Fiche	1
App\Entity\Formation	1
App\Entity\Session	1
App\Entity\Diplome	1

Entities Mapping

Class	Mapping errors
App\Entity\Utilisateur	No errors.
App\Entity\Fiche	No errors.
App\Entity\Formation	No errors.
App\Entity\Formateur	No errors.
App\Entity\Bug	No errors.
App\Entity\Session	No errors.
App\Entity\Document	No errors.
App\Entity\CompteRendu	No errors.
App\Entity\Entretien	No errors.
App\Entity\Notification	No errors.
App\Entity\Module	No errors.
App\Entity\Cours	No errors.
App\Entity\Evaluation	No errors.
App\Entity\Positionnement	No errors.
App\Entity\Devis	No errors.
App\Entity\Diplome	No errors.
App\Entity\Bloc	No errors.
App\Entity\Competence	No errors.
App\Entity\NoteEvaluation	No errors.

Symfony Profiler

GET https://app.prepavenir.fr/fiche/v/USR-694be9ded80f0/session/467/document/livret-evaluation

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping