Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

25.41 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.27 ms

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.prenom AS prenom_6, t0.photo AS photo_7, t0.tel_mobile AS tel_mobile_8, t0.last_login AS last_login_9, t0.last_login_ip AS last_login_ip_10, t0.is_actif AS is_actif_11, t0.uuid AS uuid_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.site_id AS site_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "bnicolas@betterb.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.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.photo AS photo_7,
  t0.tel_mobile AS tel_mobile_8,
  t0.last_login AS last_login_9,
  t0.last_login_ip AS last_login_ip_10,
  t0.is_actif AS is_actif_11,
  t0.uuid AS uuid_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.site_id AS site_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.updated_by_id AS updated_by_id_17
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.prenom AS prenom_6, t0.photo AS photo_7, t0.tel_mobile AS tel_mobile_8, t0.last_login AS last_login_9, t0.last_login_ip AS last_login_ip_10, t0.is_actif AS is_actif_11, t0.uuid AS uuid_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.site_id AS site_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.email = 'bnicolas@betterb.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 87)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 42)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 180)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
18	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
19	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 80)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 208)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

0.69 ms

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\EventListener\LoginListener->onSecurityInteractiveLogin (line 38)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 238)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 221)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
12	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
15	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
16	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 80)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

7.81 ms

INSERT INTO user_session (date, ip, infos, user_fullname, action, user_id) VALUES (?, ?, ?, ?, ?, ?)

Parameters:

[
  "2026-02-07 21:40:39"
  "128.78.83.60"
  null
  "Benoit NICOLAS"
  "login"
  2
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO user_session (
  date, ip, infos, user_fullname, action,
  user_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO user_session (date, ip, infos, user_fullname, action, user_id) VALUES ('2026-02-07 21:40:39', '128.78.83.60', NULL, 'Benoit NICOLAS', 'login', 2);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\EventListener\LoginListener->onSecurityInteractiveLogin (line 38)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 238)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 221)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
18	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
19	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 80)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 208)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

15.63 ms

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 433)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\EventListener\LoginListener->onSecurityInteractiveLogin (line 38)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 238)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 221)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
13	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
14	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
16	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
17	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 80)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 208)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	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\Base\User	2
App\Entity\Base\Site	1
App\Entity\Base\UserSession	1

Entities Mapping

Class	Mapping errors
App\Entity\Base\User	No errors.
App\Entity\Base\Site	No errors.
App\Entity\Base\Ticket	No errors.
App\Entity\Devis	No errors.
App\Entity\Email	No errors.
App\Entity\Contrat	No errors.
App\Entity\Compte	No errors.
App\Entity\Notification	No errors.
App\Entity\Base\UserSession	No errors.

Symfony Profiler

POST https://dev.chevaux-assurances.fr/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping