Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.15 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.15 ms

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.level_id AS level_id_24 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.level_id AS level_id_24
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.level_id AS level_id_24 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 347)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 15)
26	App\Controller\PublicController->login (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	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