Symfony Profiler

Query Metrics

7 Database Queries

4 Different statements

14.22 ms Query time

1 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.85 ms
(48.19%)

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.is_valid AS is_valid_3, t0.email AS email_4, t0.auth_code AS auth_code_5, t0.password AS password_6, t0.password_requested_at AS password_requested_at_7, t0.password_changed_at AS password_changed_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.username_canonical AS username_canonical_11, t0.email_canonical AS email_canonical_12, t0.last_login AS last_login_13, t0.email_verified_at AS email_verified_at_14, t0.lastname AS lastname_15, t0.firstname AS firstname_16, t0.street AS street_17, t0.city AS city_18, t0.zipcode AS zipcode_19, t0.phone AS phone_20, t0.officephone AS officephone_21, t0.homephone AS homephone_22, t0.membercode AS membercode_23, t0.locale AS locale_24, t0.dpo AS dpo_25, t0.agree_sens_data AS agree_sens_data_26, t0.member AS member_27, t0.membername AS membername_28, t0.confirmation_token AS confirmation_token_29, t0.membership_reason AS membership_reason_30, t0.description AS description_31, t0.contact_email AS contact_email_32 FROM fos_user t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "spk@curia.europa.eu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.is_valid AS is_valid_3,
  t0.email AS email_4,
  t0.auth_code AS auth_code_5,
  t0.password AS password_6,
  t0.password_requested_at AS password_requested_at_7,
  t0.password_changed_at AS password_changed_at_8,
  t0.roles AS roles_9,
  t0.username AS username_10,
  t0.username_canonical AS username_canonical_11,
  t0.email_canonical AS email_canonical_12,
  t0.last_login AS last_login_13,
  t0.email_verified_at AS email_verified_at_14,
  t0.lastname AS lastname_15,
  t0.firstname AS firstname_16,
  t0.street AS street_17,
  t0.city AS city_18,
  t0.zipcode AS zipcode_19,
  t0.phone AS phone_20,
  t0.officephone AS officephone_21,
  t0.homephone AS homephone_22,
  t0.membercode AS membercode_23,
  t0.locale AS locale_24,
  t0.dpo AS dpo_25,
  t0.agree_sens_data AS agree_sens_data_26,
  t0.member AS member_27,
  t0.membername AS membername_28,
  t0.confirmation_token AS confirmation_token_29,
  t0.membership_reason AS membership_reason_30,
  t0.description AS description_31,
  t0.contact_email AS contact_email_32
FROM
  fos_user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.is_valid AS is_valid_3, t0.email AS email_4, t0.auth_code AS auth_code_5, t0.password AS password_6, t0.password_requested_at AS password_requested_at_7, t0.password_changed_at AS password_changed_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.username_canonical AS username_canonical_11, t0.email_canonical AS email_canonical_12, t0.last_login AS last_login_13, t0.email_verified_at AS email_verified_at_14, t0.lastname AS lastname_15, t0.firstname AS firstname_16, t0.street AS street_17, t0.city AS city_18, t0.zipcode AS zipcode_19, t0.phone AS phone_20, t0.officephone AS officephone_21, t0.homephone AS homephone_22, t0.membercode AS membercode_23, t0.locale AS locale_24, t0.dpo AS dpo_25, t0.agree_sens_data AS agree_sens_data_26, t0.member AS member_27, t0.membername AS membername_28, t0.confirmation_token AS confirmation_token_29, t0.membership_reason AS membership_reason_30, t0.description AS description_31, t0.contact_email AS contact_email_32 FROM fos_user t0 WHERE t0.username = 'spk@curia.europa.eu' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
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 87)
6	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
7	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
8	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
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 60)
20	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 11)

3.90 ms
(27.41%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

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

2.64 ms
(18.55%)

UPDATE fos_user SET last_login = ? WHERE id = ?

Parameters:

[
  "2026-05-13 18:37:58"
  4976
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  fos_user
SET
  last_login = ?
WHERE
  id = ?

UPDATE fos_user SET last_login = '2026-05-13 18:37:58' WHERE id = 4976;

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

0.83 ms
(5.85%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

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

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\ActivityInstance	No errors.
App\Entity\Language	No errors.
App\Entity\ActivityCategory	No errors.
App\Entity\Period	No errors.
App\Entity\TeacherWorkingHour	No errors.
App\Entity\Child	No errors.
App\Entity\Registration	The field App\Entity\Registration#registrationAcc is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Registration#registrationActivity does not contain the required 'inversedBy="registrationAcc"' attribute.

Symfony Profiler

POST http://periscolaire.apeeel1.lu/en/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping