Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

37.91 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

20.24 ms
(53.38%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.is_active AS is_active_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.gender AS gender_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.position_id AS position_id_11, t0.department_id AS department_id_12 FROM users t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "admin@example.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.is_active AS is_active_4,
  t0.password AS password_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.gender AS gender_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.position_id AS position_id_11,
  t0.department_id AS department_id_12
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.is_active AS is_active_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.gender AS gender_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.position_id AS position_id_11, t0.department_id AS department_id_12 FROM users t0 WHERE t0.email = 'admin@example.com' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\LoginController->authenticateUser (line 84)
5	App\Controller\LoginController->login (line 50)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

9.27 ms
(24.46%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM roles t0 INNER JOIN user_roles ON t0.id = user_roles.role_id WHERE user_roles.user_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  roles t0
  INNER JOIN user_roles ON t0.id = user_roles.role_id
WHERE
  user_roles.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM roles t0 INNER JOIN user_roles ON t0.id = user_roles.role_id WHERE user_roles.user_id = 1;

#	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 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\User->getRoles (line 114)
8	Symfony\Component\Security\Http\Authenticator\AbstractAuthenticator->createToken (line 31)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateUser (line 89)
10	Symfony\Bundle\SecurityBundle\Security->login (line 134)
11	App\Controller\LoginController->login (line 54)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

6.53 ms
(17.22%)

INSERT INTO login_logs (email, ip_address, logged_at, user_id) VALUES (?, ?, ?, ?)

Parameters:

[
  "admin@example.com"
  "178.125.210.13"
  "2026-07-06 16:40:56"
  1
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO login_logs (
  email, ip_address, logged_at, user_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO login_logs (email, ip_address, logged_at, user_id) VALUES ('admin@example.com', '178.125.210.13', '2026-07-06 16:40:56', 1);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1061)
4	Doctrine\ORM\UnitOfWork->commit (line 404)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\EventSubscriber\LoginLogSubscriber->onLoginSuccess (line 41)
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->handleAuthenticationSuccess (line 250)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateUser (line 95)
13	Symfony\Bundle\SecurityBundle\Security->login (line 134)
14	App\Controller\LoginController->login (line 54)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

1.52 ms
(4.01%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 434)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\EventSubscriber\LoginLogSubscriber->onLoginSuccess (line 41)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 250)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateUser (line 95)
10	Symfony\Bundle\SecurityBundle\Security->login (line 134)
11	App\Controller\LoginController->login (line 54)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.35 ms
(0.92%)

"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 383)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\EventSubscriber\LoginLogSubscriber->onLoginSuccess (line 41)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 250)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateUser (line 95)
10	Symfony\Bundle\SecurityBundle\Security->login (line 134)
11	App\Controller\LoginController->login (line 54)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	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\LoginLog	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Position	No errors.
App\Entity\Department	No errors.
App\Entity\Role	No errors.
App\Entity\Permission	No errors.
App\Entity\LoginLog	No errors.

Symfony Profiler

POST https://fin.dostavka24.by/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping