Symfony Profiler

Query Metrics

7 Database Queries

5 Different statements

10.04 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.72 ms
(27.07%)

SELECT COUNT(a0_.id) AS sclr_0 FROM auth_attempts a0_ WHERE a0_.ip_address = ? AND a0_.created_at > ?

Parameters:

[
  "46.138.242.130"
  "2026-10-22 20:57:38"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  auth_attempts a0_
WHERE
  a0_.ip_address = ?
  AND a0_.created_at > ?

SELECT COUNT(a0_.id) AS sclr_0 FROM auth_attempts a0_ WHERE a0_.ip_address = '46.138.242.130' AND a0_.created_at > '2026-10-22 20:57:38';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Security\LoginFormAuthenticator->getAuthAttemptsCount (line 110)
8	App\Security\LoginFormAuthenticator->authenticate (line 47)
9	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 178)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
13	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
14	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
16	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
25	Symfony\Component\HttpKernel\Kernel->handle (line 143)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

2.48 ms
(24.70%)

SELECT t0.login AS login_1, t0.password AS password_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM users t0 WHERE t0.login = ? LIMIT 1

Parameters:

[
  "acer"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.login AS login_1,
  t0.password AS password_2,
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  users t0
WHERE
  t0.login = ?
LIMIT
  1

SELECT t0.login AS login_1, t0.password AS password_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM users t0 WHERE t0.login = 'acer' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	App\Security\LoginFormAuthenticator->authenticate (line 53)
4	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
5	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 178)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
8	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
9	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
20	Symfony\Component\HttpKernel\Kernel->handle (line 143)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	require_once (line 5)

2.17 ms
(21.67%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 458)
2	Doctrine\ORM\EntityManager->flush (line 270)
3	App\Security\LoginFormAuthenticator->logAuth (line 84)
4	App\Security\LoginFormAuthenticator->authenticate (line 65)
5	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 178)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
21	Symfony\Component\HttpKernel\Kernel->handle (line 143)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 5)

2.09 ms
(20.81%)

INSERT INTO auth_logs (ip_address, message, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "46.138.242.130"
  "Пользователь вошел в систему"
  "2026-10-22 21:07:39"
  "2026-10-22 21:07:39"
  2
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO auth_logs (
  ip_address, message, created_at, updated_at,
  user_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO auth_logs (ip_address, message, created_at, updated_at, user_id) VALUES ('46.138.242.130', 'Пользователь вошел в систему', '2026-10-22 21:07:39', '2026-10-22 21:07:39', 2);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 255)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1144)
4	Doctrine\ORM\UnitOfWork->commit (line 426)
5	Doctrine\ORM\EntityManager->flush (line 270)
6	App\Security\LoginFormAuthenticator->logAuth (line 84)
7	App\Security\LoginFormAuthenticator->authenticate (line 65)
8	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 178)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
12	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
15	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
16	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
17	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
24	Symfony\Component\HttpKernel\Kernel->handle (line 143)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
26	require_once (line 32)
27	require_once (line 5)

0.58 ms
(5.75%)

"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 405)
2	Doctrine\ORM\EntityManager->flush (line 270)
3	App\Security\LoginFormAuthenticator->logAuth (line 84)
4	App\Security\LoginFormAuthenticator->authenticate (line 65)
5	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 178)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
21	Symfony\Component\HttpKernel\Kernel->handle (line 143)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	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\User	1
App\Entity\AuthLog	1

Entities Mapping

Class	Mapping errors
App\Entity\AuthAttempt	No errors.
App\Entity\User	No errors.
App\Entity\AuthLog	No errors.

POST https://nod-brotherhood.ru/account/logon

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping