Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

6.04 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.85 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 = ?

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 = ?

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

1.06 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.color AS color_4, t0.bg AS bg_5, t0.short AS short_6, t0.filter AS filter_7 FROM badge t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.color AS color_4,
  t0.bg AS bg_5,
  t0.short AS short_6,
  t0.filter AS filter_7
FROM
  badge t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.color AS color_4, t0.bg AS bg_5, t0.short AS short_6, t0.filter AS filter_7 FROM badge t0 WHERE t0.id = '1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.93 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.color AS color_4, t0.bg AS bg_5 FROM level t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.color AS color_4,
  t0.bg AS bg_5
FROM
  level t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.color AS color_4, t0.bg AS bg_5 FROM level t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Level::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Level->__get (line 103)
8	App\Entity\Level->getColor (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 51)
10	__TwigTemplate_d0180d31c9f58c8c7d53c6552210cdbf->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1493)
15	Twig\Extension\CoreExtension::include (line 110)
16	__TwigTemplate_dfd4e2bf5a25d2e1434ddd84cfbec56f->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1493)
21	Twig\Extension\CoreExtension::include (line 167)
22	__TwigTemplate_18eebe1a80d231430fe907abbb508d0a->doDisplay (line 388)
23	Twig\Template->yield (line 55)
24	__TwigTemplate_75ac485d16f6641a08be43be9cad702c->doDisplay (line 388)
25	Twig\Template->yield (line 344)
26	Twig\Template->display (line 359)
27	Twig\Template->render (line 51)
28	Twig\TemplateWrapper->render (line 334)
29	Twig\Environment->render (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
33	App\Controller\Admin\BadgeController->edit (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

1.21 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.color AS color_4, t0.bg AS bg_5, t0.short AS short_6, t0.filter AS filter_7 FROM badge t0 INNER JOIN user_badge ON t0.id = user_badge.badge_id WHERE user_badge.user_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.color AS color_4,
  t0.bg AS bg_5,
  t0.short AS short_6,
  t0.filter AS filter_7
FROM
  badge t0
  INNER JOIN user_badge ON t0.id = user_badge.badge_id
WHERE
  user_badge.user_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.color AS color_4, t0.bg AS bg_5, t0.short AS short_6, t0.filter AS filter_7 FROM badge t0 INNER JOIN user_badge ON t0.id = user_badge.badge_id WHERE user_badge.user_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 123)
9	__TwigTemplate_dfd4e2bf5a25d2e1434ddd84cfbec56f->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 1493)
14	Twig\Extension\CoreExtension::include (line 167)
15	__TwigTemplate_18eebe1a80d231430fe907abbb508d0a->doDisplay (line 388)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_75ac485d16f6641a08be43be9cad702c->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 334)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
26	App\Controller\Admin\BadgeController->edit (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/admin/badge/1/edit

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping