Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

9.77 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.74 ms
(38.30%)

INSERT INTO trackings (action, entity_type, entity_id, details, old_value, new_value, ip_address, user_agent, id, created_at, updated_at, establishment_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "LOGIN"
  "auth"
  "019cd0ec-7eee-7412-9ac2-b8f3d874390d"
  null
  null
  null
  "102.17.37.153"
  "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 Edg/148.0.0.0"
  "019ecec6-724a-7034-84fb-ec62325297e7"
  "2026-06-16 04:52:52"
  "2026-06-16 04:52:52"
  "019c6bc6-7a9f-74a1-8839-c09403fb8f9b"
  "019cd0ec-7eee-7412-9ac2-b8f3d874390d"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO trackings (
  action, entity_type, entity_id, details,
  old_value, new_value, ip_address,
  user_agent, id, created_at, updated_at,
  establishment_id, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO trackings (action, entity_type, entity_id, details, old_value, new_value, ip_address, user_agent, id, created_at, updated_at, establishment_id, user_id) VALUES ('LOGIN', 'auth', '019cd0ec-7eee-7412-9ac2-b8f3d874390d', NULL, NULL, NULL, '102.17.37.153', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 Edg/148.0.0.0', '019ecec6-724a-7034-84fb-ec62325297e7', '2026-06-16 04:52:52', '2026-06-16 04:52:52', '019c6bc6-7a9f-74a1-8839-c09403fb8f9b', '019cd0ec-7eee-7412-9ac2-b8f3d874390d');

#	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\Adapters\Secondary\Doctrine\Repository\Tracking\TrackingRepository->save (line 53)
7	App\Adapters\Secondary\Service\TrackingManager->track (line 66)
8	App\Adapters\Primary\Http\EventSubscriber\LoginTrackingSubscriber->onLoginSuccess (line 28)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 250)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

2.23 ms
(22.83%)

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.gender AS gender_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.is_active AS is_active_12 FROM users t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "ndrinamitia@gmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.phone AS phone_6,
  t0.gender AS gender_7,
  t0.id AS id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11,
  t0.is_active AS is_active_12
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.gender AS gender_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.is_active AS is_active_12 FROM users t0 WHERE t0.email = 'ndrinamitia@gmail.com' LIMIT 1;

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

2.14 ms
(21.86%)

SELECT t0.name AS name_1, t0.code AS code_2, t0.types AS types_3, t0.address AS address_4, t0.city AS city_5, t0.postal_code AS postal_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.website AS website_9, t0.logo AS logo_10, t0.director AS director_11, t0.slogan AS slogan_12, t0.tenant_key AS tenant_key_13, t0.due_day_at AS due_day_at_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18, t0.is_active AS is_active_19 FROM establishments t0 INNER JOIN user_establishments ON t0.id = user_establishments.establishment_id WHERE user_establishments.user_id = ?

Parameters:

[
  "019cd0ec-7eee-7412-9ac2-b8f3d874390d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.code AS code_2,
  t0.types AS types_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.postal_code AS postal_code_6,
  t0.phone AS phone_7,
  t0.email AS email_8,
  t0.website AS website_9,
  t0.logo AS logo_10,
  t0.director AS director_11,
  t0.slogan AS slogan_12,
  t0.tenant_key AS tenant_key_13,
  t0.due_day_at AS due_day_at_14,
  t0.id AS id_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.deleted_at AS deleted_at_18,
  t0.is_active AS is_active_19
FROM
  establishments t0
  INNER JOIN user_establishments ON t0.id = user_establishments.establishment_id
WHERE
  user_establishments.user_id = ?

SELECT t0.name AS name_1, t0.code AS code_2, t0.types AS types_3, t0.address AS address_4, t0.city AS city_5, t0.postal_code AS postal_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.website AS website_9, t0.logo AS logo_10, t0.director AS director_11, t0.slogan AS slogan_12, t0.tenant_key AS tenant_key_13, t0.due_day_at AS due_day_at_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18, t0.is_active AS is_active_19 FROM establishments t0 INNER JOIN user_establishments ON t0.id = user_establishments.establishment_id WHERE user_establishments.user_id = '019cd0ec-7eee-7412-9ac2-b8f3d874390d';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Adapters\Secondary\Service\TrackingManager->track (line 57)
9	App\Adapters\Primary\Http\EventSubscriber\LoginTrackingSubscriber->onLoginSuccess (line 28)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 250)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
21	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

0.98 ms
(10.01%)

"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\Adapters\Secondary\Doctrine\Repository\Tracking\TrackingRepository->save (line 53)
4	App\Adapters\Secondary\Service\TrackingManager->track (line 66)
5	App\Adapters\Primary\Http\EventSubscriber\LoginTrackingSubscriber->onLoginSuccess (line 28)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 250)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.68 ms
(6.99%)

"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\Adapters\Secondary\Doctrine\Repository\Tracking\TrackingRepository->save (line 53)
4	App\Adapters\Secondary\Service\TrackingManager->track (line 66)
5	App\Adapters\Primary\Http\EventSubscriber\LoginTrackingSubscriber->onLoginSuccess (line 28)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 250)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
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\Adapters\Secondary\Doctrine\Entity\User	1
App\Adapters\Secondary\Doctrine\Entity\Establishment	1
App\Adapters\Secondary\Doctrine\Entity\Tracking	1

Entities Mapping

Class	Mapping errors
App\Adapters\Secondary\Doctrine\Entity\User	No errors.
App\Adapters\Secondary\Doctrine\Entity\Establishment	No errors.
App\Adapters\Secondary\Doctrine\Entity\AcademicYear	No errors.
App\Adapters\Secondary\Doctrine\Entity\Tracking	No errors.

Symfony Profiler

POST https://ianatra.mypreprod.xyz/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping