Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

9.09 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.98 ms
(43.79%)

"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 432)
3	Doctrine\ORM\UnitOfWork->commit (line 268)
4	Doctrine\ORM\EntityManager->flush (line 54)
5	App\Services\Services->log (line 110)
6	App\Security\AppAuthentificationAuthenticator->onAuthenticationFailure (line 102)
7	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationFailure (line 268)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationFailure (line 221)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
12	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
15	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
16	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

2.24 ms
(24.61%)

INSERT INTO logs (message, level, context, source, created_at, updated_at, is_notified) VALUES (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "Échec d’authentification"
  "ERROR"
  "{"ip":"143.105.75.57","message":"Email ou mot de passe invalid.","last_username":"super@gmail.com"}"
  "app_login"
  "2026-08-03 18:23:15"
  null
  "[]"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO logs (
  message, level, context, source, created_at,
  updated_at, is_notified
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO logs (message, level, context, source, created_at, updated_at, is_notified) VALUES ('Échec d’authentification', 'ERROR', '{\"ip\":\"143.105.75.57\",\"message\":\"Email ou mot de passe invalid.\",\"last_username\":\"super@gmail.com\"}', 'app_login', '2026-08-03 18:23:15', NULL, '[]');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 261)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1057)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 402)
5	Doctrine\ORM\UnitOfWork->commit (line 268)
6	Doctrine\ORM\EntityManager->flush (line 54)
7	App\Services\Services->log (line 110)
8	App\Security\AppAuthentificationAuthenticator->onAuthenticationFailure (line 102)
9	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationFailure (line 268)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationFailure (line 221)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
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 92)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

1.72 ms
(18.93%)

SELECT t0.id AS id_1, t0.login_max_attempts AS login_max_attempts_2, t0.login_attempts_window_minutes AS login_attempts_window_minutes_3, t0.password_min_length AS password_min_length_4, t0.password_require_uppercase AS password_require_uppercase_5, t0.password_require_digit AS password_require_digit_6, t0.password_require_special AS password_require_special_7, t0.session_timeout_minutes AS session_timeout_minutes_8, t0.enable_2fa AS enable_2fa_9, t0.password_expiration_days AS password_expiration_days_10, t0.token_lifetime AS token_lifetime_11, t0.token_stripe AS token_stripe_12, t0.token_stripe_pre AS token_stripe_pre_13, t0.url AS url_14, t0.port AS port_15, t0.username AS username_16, t0.password AS password_17 FROM security_settings t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.login_max_attempts AS login_max_attempts_2,
  t0.login_attempts_window_minutes AS login_attempts_window_minutes_3,
  t0.password_min_length AS password_min_length_4,
  t0.password_require_uppercase AS password_require_uppercase_5,
  t0.password_require_digit AS password_require_digit_6,
  t0.password_require_special AS password_require_special_7,
  t0.session_timeout_minutes AS session_timeout_minutes_8,
  t0.enable_2fa AS enable_2fa_9,
  t0.password_expiration_days AS password_expiration_days_10,
  t0.token_lifetime AS token_lifetime_11,
  t0.token_stripe AS token_stripe_12,
  t0.token_stripe_pre AS token_stripe_pre_13,
  t0.url AS url_14,
  t0.port AS port_15,
  t0.username AS username_16,
  t0.password AS password_17
FROM
  security_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.login_max_attempts AS login_max_attempts_2, t0.login_attempts_window_minutes AS login_attempts_window_minutes_3, t0.password_min_length AS password_min_length_4, t0.password_require_uppercase AS password_require_uppercase_5, t0.password_require_digit AS password_require_digit_6, t0.password_require_special AS password_require_special_7, t0.session_timeout_minutes AS session_timeout_minutes_8, t0.enable_2fa AS enable_2fa_9, t0.password_expiration_days AS password_expiration_days_10, t0.token_lifetime AS token_lifetime_11, t0.token_stripe AS token_stripe_12, t0.token_stripe_pre AS token_stripe_pre_13, t0.url AS url_14, t0.port AS port_15, t0.username AS username_16, t0.password AS password_17 FROM security_settings t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 19)
5	App\Services\SecuritySettingsProvider->getSettings (line 27)
6	App\Services\SecuritySettingsProvider->getLoginMaxAttempts (line 46)
7	App\Security\AppAuthentificationAuthenticator->authenticate (line 74)
8	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 185)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
12	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
15	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
16	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.83 ms
(9.10%)

SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.email AS email_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.last_login_at AS last_login_at_8, t0.first_connexion AS first_connexion_9, t0.reset_token AS reset_token_10, t0.reset_token_expires_at AS reset_token_expires_at_11, t0.role_id AS role_id_12, t0.statut_id AS statut_id_13 FROM `employee` t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "super@gmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.last_name AS last_name_2,
  t0.first_name AS first_name_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.last_login_at AS last_login_at_8,
  t0.first_connexion AS first_connexion_9,
  t0.reset_token AS reset_token_10,
  t0.reset_token_expires_at AS reset_token_expires_at_11,
  t0.role_id AS role_id_12,
  t0.statut_id AS statut_id_13
FROM
  `employee` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.email AS email_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.last_login_at AS last_login_at_8, t0.first_connexion AS first_connexion_9, t0.reset_token AS reset_token_10, t0.reset_token_expires_at AS reset_token_expires_at_11, t0.role_id AS role_id_12, t0.statut_id AS statut_id_13 FROM `employee` t0 WHERE t0.email = 'super@gmail.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 101)
6	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
7	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
8	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 189)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
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 92)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.32 ms
(3.58%)

"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 381)
2	Doctrine\ORM\UnitOfWork->commit (line 268)
3	Doctrine\ORM\EntityManager->flush (line 54)
4	App\Services\Services->log (line 110)
5	App\Security\AppAuthentificationAuthenticator->onAuthenticationFailure (line 102)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationFailure (line 268)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationFailure (line 221)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
11	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
12	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
13	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
14	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
15	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
16	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
17	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\SecuritySettings	1
App\Entity\Employee	1
App\Entity\Role	1
App\Entity\Statut	1
App\Entity\Logs	1

Entities Mapping

Class	Mapping errors
App\Entity\SecuritySettings	No errors.
App\Entity\Employee	No errors.
App\Entity\Role	No errors.
App\Entity\Statut	No errors.
App\Entity\Logs	No errors.

Symfony Profiler

POST https://reconciliation-form-uat.apps.maikhub.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping