Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

3.09 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.09 ms
(100.00%)

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.email = ? LIMIT 1

Parameters:

[
  "r.harmegnies@prepavenir.fr"
]

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.email = ?
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.email = 'r.harmegnies@prepavenir.fr' 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 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 101)
6	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
7	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
8	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 189)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
19	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
20	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	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\Utilisateur	1
App\Entity\Formateur	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.

Symfony Profiler

POST https://app.prepavenir.fr/connexion

Configuration Settings

Theme

Page Width