Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

18.34 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

16.65 ms
(90.81%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\EventSubscriber\AuditSubscriber->onLogout (line 48)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
8	Symfony\Component\Security\Http\Firewall\LogoutListener->authenticate (line 80)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.84 ms
(4.58%)

INSERT INTO audit_log (action, entity_type, entity_id, details, ip_address, created_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "logout"
  "User"
  1
  "{"email":"chereau.steven@lycee-sacrecoeur-beziers.com"}"
  "172.20.0.1"
  "2026-02-02 15:32:07"
  1
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO audit_log (
  action, entity_type, entity_id, details,
  ip_address, created_at, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO audit_log (action, entity_type, entity_id, details, ip_address, created_at, user_id) VALUES ('logout', 'User', 1, '{\"email\":\"chereau.steven@lycee-sacrecoeur-beziers.com\"}', '172.20.0.1', '2026-02-02 15:32:07', 1);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
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\EventSubscriber\AuditSubscriber->onLogout (line 48)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
11	Symfony\Component\Security\Http\Firewall\LogoutListener->authenticate (line 80)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
13	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
14	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
15	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.51 ms
(2.78%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.google_id AS google_id_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.display_name AS display_name_6, t0.avatar AS avatar_7, t0.roles AS roles_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10, t0.is_active AS is_active_11 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.google_id AS google_id_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.display_name AS display_name_6,
  t0.avatar AS avatar_7,
  t0.roles AS roles_8,
  t0.last_login_at AS last_login_at_9,
  t0.created_at AS created_at_10,
  t0.is_active AS is_active_11
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.google_id AS google_id_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.display_name AS display_name_6, t0.avatar AS avatar_7, t0.roles AS roles_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10, t0.is_active AS is_active_11 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.34 ms
(1.84%)

"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\EventSubscriber\AuditSubscriber->onLogout (line 48)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
8	Symfony\Component\Security\Http\Firewall\LogoutListener->authenticate (line 80)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
readonly	doctrine.dbal.readonly_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
readonly	doctrine.orm.readonly_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\AuditLog	1

readonly entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\AuditLog	No errors.

readonly entity manager

No loaded entities.

Symfony Profiler

GET https://edunexus.lycee-sacrecoeur-beziers.com/logout

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

readonly entity manager

Entities Mapping

default entity manager

readonly entity manager