Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

10.36 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.57 ms
(34.43%)

"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 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 109)
5	App\Security\UserProvider->saveTsX (line 54)
6	App\EventListener\UserActivitySubscriber->onController (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

3.26 ms
(31.48%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.photo AS photo_6, t0.auth_date AS auth_date_7, t0.theme AS theme_8, t0.birthday AS birthday_9, t0.phone AS phone_10, t0.about AS about_11, t0.custom_photo AS custom_photo_12, t0.male AS male_13, t0.coach AS coach_14, t0.captain AS captain_15, t0.ts_x AS ts_x_16, t0.register_date AS register_date_17, t0.telegram_id AS telegram_id_18, t0.notification AS notification_19, t0.trainings_filter AS trainings_filter_20, t0.show_year AS show_year_21, t0.verified AS verified_22, t0.account_balance AS account_balance_23, t0.discount AS discount_24, t0.patronymic AS patronymic_25, t0.beach_rating AS beach_rating_26, t0.beach_games AS beach_games_27, t0.child AS child_28, t0.level_id AS level_id_29 FROM user t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.photo AS photo_6,
  t0.auth_date AS auth_date_7,
  t0.theme AS theme_8,
  t0.birthday AS birthday_9,
  t0.phone AS phone_10,
  t0.about AS about_11,
  t0.custom_photo AS custom_photo_12,
  t0.male AS male_13,
  t0.coach AS coach_14,
  t0.captain AS captain_15,
  t0.ts_x AS ts_x_16,
  t0.register_date AS register_date_17,
  t0.telegram_id AS telegram_id_18,
  t0.notification AS notification_19,
  t0.trainings_filter AS trainings_filter_20,
  t0.show_year AS show_year_21,
  t0.verified AS verified_22,
  t0.account_balance AS account_balance_23,
  t0.discount AS discount_24,
  t0.patronymic AS patronymic_25,
  t0.beach_rating AS beach_rating_26,
  t0.beach_games AS beach_games_27,
  t0.child AS child_28,
  t0.level_id AS level_id_29
FROM
  user t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.photo AS photo_6, t0.auth_date AS auth_date_7, t0.theme AS theme_8, t0.birthday AS birthday_9, t0.phone AS phone_10, t0.about AS about_11, t0.custom_photo AS custom_photo_12, t0.male AS male_13, t0.coach AS coach_14, t0.captain AS captain_15, t0.ts_x AS ts_x_16, t0.register_date AS register_date_17, t0.telegram_id AS telegram_id_18, t0.notification AS notification_19, t0.trainings_filter AS trainings_filter_20, t0.show_year AS show_year_21, t0.verified AS verified_22, t0.account_balance AS account_balance_23, t0.discount AS discount_24, t0.patronymic AS patronymic_25, t0.beach_rating AS beach_rating_26, t0.beach_games AS beach_games_27, t0.child AS child_28, t0.level_id AS level_id_29 FROM user t0 WHERE t0.id = '1' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
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 60)
6	Symfony\Component\Security\Http\RememberMe\AbstractRememberMeHandler->consumeRememberMeCookie (line 64)
7	Symfony\Component\Security\Http\RememberMe\SignatureRememberMeHandler->consumeRememberMeCookie (line 105)
8	Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator->Symfony\Component\Security\Http\Authenticator\{closure} (line 91)
9	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
10	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
11	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
19	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
20	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
21	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 74)
22	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
23	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 42)
24	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 68)
25	Symfony\Bundle\SecurityBundle\Security->getToken (line 50)
26	Symfony\Bundle\SecurityBundle\Security->getUser (line 49)
27	App\EventListener\UserActivitySubscriber->onController (line 115)
28	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
30	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
31	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

2.90 ms
(27.96%)

UPDATE user SET ts_x = ? WHERE id = ?

Parameters:

[
  "2025-07-07 19:12:41"
  1
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  user
SET
  ts_x = ?
WHERE
  id = ?

UPDATE user SET ts_x = '2025-07-07 19:12:41' WHERE id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 109)
7	App\Security\UserProvider->saveTsX (line 54)
8	App\EventListener\UserActivitySubscriber->onController (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 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.64 ms
(6.13%)

"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 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 109)
4	App\Security\UserProvider->saveTsX (line 54)
5	App\EventListener\UserActivitySubscriber->onController (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Level	No errors.
App\Entity\Team	No errors.
App\Entity\Badge	No errors.
App\Entity\Schedule	No errors.
App\Entity\TrainingUserLink	No errors.
App\Entity\Transaction	No errors.

Symfony Profiler

GET https://volik.webtm.ru/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping