Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

5.46 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.21 ms

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.32 ms

"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)

1.25 ms

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":"Trop de tentatives. R\u00e9essayez dans 85 seconde(s).","last_username":"super@gmail.com"}"
  "app_login"
  "2026-08-03 18:23:41"
  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\":\"Trop de tentatives. R\\u00e9essayez dans 85 seconde(s).\",\"last_username\":\"super@gmail.com\"}', 'app_login', '2026-08-03 18:23:41', 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)

2.69 ms

"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)

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\Logs	1

Entities Mapping

Class	Mapping errors
App\Entity\SecuritySettings	No errors.
App\Entity\Logs	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping