Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.13 ms Query time

1 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.13 ms
(100.00%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.EstActive AS EstActive_5, t0.NomPrenom AS NomPrenom_6, t0.Tel AS Tel_7, t0.Adresse AS Adresse_8, t0.Pays AS Pays_9, t0.PhotoProfil AS PhotoProfil_10, t0.IDVille AS IDVille_11, t0.isAdmin AS isAdmin_12, t0.Dateentrer AS Dateentrer_13, t0.Telurgence AS Telurgence_14, t0.IDProfil AS IDProfil_15, t0.IDAscensoriste AS IDAscensoriste_16, t0.TypeExperience AS TypeExperience_17 FROM user t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "contact-idf@sietram.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.EstActive AS EstActive_5,
  t0.NomPrenom AS NomPrenom_6,
  t0.Tel AS Tel_7,
  t0.Adresse AS Adresse_8,
  t0.Pays AS Pays_9,
  t0.PhotoProfil AS PhotoProfil_10,
  t0.IDVille AS IDVille_11,
  t0.isAdmin AS isAdmin_12,
  t0.Dateentrer AS Dateentrer_13,
  t0.Telurgence AS Telurgence_14,
  t0.IDProfil AS IDProfil_15,
  t0.IDAscensoriste AS IDAscensoriste_16,
  t0.TypeExperience AS TypeExperience_17
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.EstActive AS EstActive_5, t0.NomPrenom AS NomPrenom_6, t0.Tel AS Tel_7, t0.Adresse AS Adresse_8, t0.Pays AS Pays_9, t0.PhotoProfil AS PhotoProfil_10, t0.IDVille AS IDVille_11, t0.isAdmin AS isAdmin_12, t0.Dateentrer AS Dateentrer_13, t0.Telurgence AS Telurgence_14, t0.IDProfil AS IDProfil_15, t0.IDAscensoriste AS IDAscensoriste_16, t0.TypeExperience AS TypeExperience_17 FROM user t0 WHERE t0.username = 'contact-idf@sietram.fr' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
29	require_once (line 32)
30	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\User	1
App\Entity\Profil	1
App\Entity\Ascensoriste	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Profil	No errors.
App\Entity\Ascensoriste	No errors.
App\Entity\Scoring\TypeExperienceTechnicien	No errors.
App\Entity\PushToken	No errors.
App\Entity\Notification	No errors.
App\Entity\Typesecteur	No errors.
App\Entity\Typecompetence	No errors.
App\Entity\Typehabilitation	No errors.
App\Entity\Typepermis	No errors.
App\Entity\Documentuser	No errors.
App\Entity\Avancementtravaux	The field App\Entity\Avancementtravaux#avancementOperations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AvancementOperation#avancementtravaux does not contain the required 'inversedBy: "avancementOperations"' attribute. The field App\Entity\Avancementtravaux#travauxRealises is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Travauxrealisedansavancement#avancementtravaux does not contain the required 'inversedBy: "travauxRealises"' attribute. The field App\Entity\Avancementtravaux#travauxPrevus is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Travauxprevudansavancement#avancementtravaux does not contain the required 'inversedBy: "travauxPrevus"' attribute. The field App\Entity\Avancementtravaux#pointsBloquants is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Pointbloquantdansavancement#avancementtravaux does not contain the required 'inversedBy: "pointsBloquants"' attribute.

Symfony Profiler

POST https://arcadeapp.fr/login

Configuration Settings

Theme

Page Width