Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.78 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.78 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.nom AS nom_5, t0.prenoms AS prenoms_6, t0.telephone AS telephone_7, t0.fonction AS fonction_8, t0.matricule AS matricule_9, t0.lieu_residence AS lieu_residence_10, t0.mot_de_passe_a_changer AS mot_de_passe_a_changer_11, t0.connexions_provisoires AS connexions_provisoires_12, t0.enable AS enable_13, t0.deleted AS deleted_14, t0.birth_date AS birth_date_15, t0.birth_place AS birth_place_16, t0.cnps AS cnps_17, t0.langue AS langue_18, t0.embauche_date AS embauche_date_19, t0.renvoi_date AS renvoi_date_20, t0.signature_url AS signature_url_21, t0.initiale AS initiale_22, t0.signature_data AS signature_data_23, t0.signature_name AS signature_name_24, t0.signature_size AS signature_size_25, t0.cv_name AS cv_name_26, t0.permis_name AS permis_name_27, t0.extrait_name AS extrait_name_28, t0.diplome_name AS diplome_name_29, t0.contrat_name AS contrat_name_30, t0.autre_name AS autre_name_31, t0.masque_le AS masque_le_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.service_id AS service_id_35, t0.lieu_affectation_id AS lieu_affectation_id_36, t0.departement_id AS departement_id_37, t0.superviseur_id AS superviseur_id_38, t0.responsable_id AS responsable_id_39 FROM `user` t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "carelle0327belle@gmail.com"
]

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.nom AS nom_5,
  t0.prenoms AS prenoms_6,
  t0.telephone AS telephone_7,
  t0.fonction AS fonction_8,
  t0.matricule AS matricule_9,
  t0.lieu_residence AS lieu_residence_10,
  t0.mot_de_passe_a_changer AS mot_de_passe_a_changer_11,
  t0.connexions_provisoires AS connexions_provisoires_12,
  t0.enable AS enable_13,
  t0.deleted AS deleted_14,
  t0.birth_date AS birth_date_15,
  t0.birth_place AS birth_place_16,
  t0.cnps AS cnps_17,
  t0.langue AS langue_18,
  t0.embauche_date AS embauche_date_19,
  t0.renvoi_date AS renvoi_date_20,
  t0.signature_url AS signature_url_21,
  t0.initiale AS initiale_22,
  t0.signature_data AS signature_data_23,
  t0.signature_name AS signature_name_24,
  t0.signature_size AS signature_size_25,
  t0.cv_name AS cv_name_26,
  t0.permis_name AS permis_name_27,
  t0.extrait_name AS extrait_name_28,
  t0.diplome_name AS diplome_name_29,
  t0.contrat_name AS contrat_name_30,
  t0.autre_name AS autre_name_31,
  t0.masque_le AS masque_le_32,
  t0.created_at AS created_at_33,
  t0.updated_at AS updated_at_34,
  t0.service_id AS service_id_35,
  t0.lieu_affectation_id AS lieu_affectation_id_36,
  t0.departement_id AS departement_id_37,
  t0.superviseur_id AS superviseur_id_38,
  t0.responsable_id AS responsable_id_39
FROM
  `user` t0
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.nom AS nom_5, t0.prenoms AS prenoms_6, t0.telephone AS telephone_7, t0.fonction AS fonction_8, t0.matricule AS matricule_9, t0.lieu_residence AS lieu_residence_10, t0.mot_de_passe_a_changer AS mot_de_passe_a_changer_11, t0.connexions_provisoires AS connexions_provisoires_12, t0.enable AS enable_13, t0.deleted AS deleted_14, t0.birth_date AS birth_date_15, t0.birth_place AS birth_place_16, t0.cnps AS cnps_17, t0.langue AS langue_18, t0.embauche_date AS embauche_date_19, t0.renvoi_date AS renvoi_date_20, t0.signature_url AS signature_url_21, t0.initiale AS initiale_22, t0.signature_data AS signature_data_23, t0.signature_name AS signature_name_24, t0.signature_size AS signature_size_25, t0.cv_name AS cv_name_26, t0.permis_name AS permis_name_27, t0.extrait_name AS extrait_name_28, t0.diplome_name AS diplome_name_29, t0.contrat_name AS contrat_name_30, t0.autre_name AS autre_name_31, t0.masque_le AS masque_le_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.service_id AS service_id_35, t0.lieu_affectation_id AS lieu_affectation_id_36, t0.departement_id AS departement_id_37, t0.superviseur_id AS superviseur_id_38, t0.responsable_id AS responsable_id_39 FROM `user` t0 WHERE t0.email = 'carelle0327belle@gmail.com' 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 57)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 97)
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 129)
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 70)
19	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 94)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 93)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 129)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 161)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
28	Symfony\Component\HttpKernel\Kernel->handle (line 31)
29	{closure} (line 25)
30	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 24)
31	require_once (line 11)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	1
App\Entity\Service	1
App\Entity\Ville	1
App\Entity\Departement	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Service	No errors.
App\Entity\Ville	No errors.
App\Entity\Departement	No errors.
App\Entity\Document	No errors.
App\Entity\Permission	No errors.
App\Entity\Notification	No errors.
App\Entity\DetailItineraire	No errors.
App\Entity\Message	No errors.
App\Entity\RapportTechnique	No errors.

Symfony Profiler

POST https://topexhub.com/login

Configuration Settings

Theme

Page Width