Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

6.01 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.43 ms
(40.43%)

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.level_id AS level_id_22 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.level_id AS level_id_22
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.level_id AS level_id_22 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.76 ms
(29.24%)

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 90)
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 169)
22	__TwigTemplate_18eebe1a80d231430fe907abbb508d0a->doDisplay (line 388)
23	Twig\Template->yield (line 55)
24	__TwigTemplate_3586545e9baeda0f202323d33bc83562->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 17)
33	App\Controller\TournamentController->tournamentsAction (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.01 ms
(16.83%)

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 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
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 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 103)
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 169)
15	__TwigTemplate_18eebe1a80d231430fe907abbb508d0a->doDisplay (line 388)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_3586545e9baeda0f202323d33bc83562->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 17)
26	App\Controller\TournamentController->tournamentsAction (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)

0.81 ms
(13.49%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.about AS about_3, t0.logo AS logo_4, t0.season AS season_5, t0.criteria AS criteria_6, t0.add_criteria AS add_criteria_7 FROM tournament t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.about AS about_3,
  t0.logo AS logo_4,
  t0.season AS season_5,
  t0.criteria AS criteria_6,
  t0.add_criteria AS add_criteria_7
FROM
  tournament t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.about AS about_3, t0.logo AS logo_4, t0.season AS season_5, t0.criteria AS criteria_6, t0.add_criteria AS add_criteria_7 FROM tournament t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 18)
6	App\Controller\TournamentController->tournamentsAction (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\Tournament	No errors.
App\Entity\Duel	No errors.
App\Entity\TeamInTournament	No errors.

Symfony Profiler

GET https://volik.online/tournament

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping