Symfony Profiler

Query Metrics

58 Database Queries

9 Different statements

32.32 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.09 ms
(25.03%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.about AS about_3, t0.our AS our_4, t0.logo AS logo_5, t0.photos AS photos_6, t0.domestic AS domestic_7, t0.bg AS bg_8, t0.beach AS beach_9, t0.rating AS rating_10, t0.hide_roster AS hide_roster_11, t0.captain_id AS captain_id_12, t0.coach_id AS coach_id_13, t0.head_id AS head_id_14 FROM team t0 WHERE t0.id = ?

Parameters:

[
  51
]

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.our AS our_4,
  t0.logo AS logo_5,
  t0.photos AS photos_6,
  t0.domestic AS domestic_7,
  t0.bg AS bg_8,
  t0.beach AS beach_9,
  t0.rating AS rating_10,
  t0.hide_roster AS hide_roster_11,
  t0.captain_id AS captain_id_12,
  t0.coach_id AS coach_id_13,
  t0.head_id AS head_id_14
FROM
  team t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.about AS about_3, t0.our AS our_4, t0.logo AS logo_5, t0.photos AS photos_6, t0.domestic AS domestic_7, t0.bg AS bg_8, t0.beach AS beach_9, t0.rating AS rating_10, t0.hide_roster AS hide_roster_11, t0.captain_id AS captain_id_12, t0.coach_id AS coach_id_13, t0.head_id AS head_id_14 FROM team t0 WHERE t0.id = 51;

#	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\Team::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Team->__get (line 344)
8	App\Entity\Team->isBeach (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 48)
10	__TwigTemplate_795c143c852d0faa122632c34681373d->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 48)
16	__TwigTemplate_5c8cdecca748b94336d926ad21c61c7a->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 314)
22	__TwigTemplate_2f98eb33305de1ada3a693efd0c71903->block_container (line 432)
23	Twig\Template->yieldBlock (line 138)
24	Twig\Template->displayBlock (line 199)
25	Twig\Template->renderBlock (line 79)
26	Twig\TemplateWrapper->renderBlock (line 428)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 239)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderBlockView (line 33)
29	App\Controller\SpaController->renderSpa (line 33)
30	App\Controller\TournamentController->tournaments (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

6.83 ms
(21.12%)

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

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

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;

#	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 26)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

6.50 ms
(20.11%)

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 INNER JOIN team_user ON t0.id = team_user.user_id WHERE team_user.team_id = ?

Parameters:

[
  51
]

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
  INNER JOIN team_user ON t0.id = team_user.user_id
WHERE
  team_user.team_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.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 INNER JOIN team_user ON t0.id = team_user.user_id WHERE team_user.team_id = 51;

#	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 84)
9	__TwigTemplate_795c143c852d0faa122632c34681373d->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 48)
15	__TwigTemplate_5c8cdecca748b94336d926ad21c61c7a->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 1493)
20	Twig\Extension\CoreExtension::include (line 314)
21	__TwigTemplate_2f98eb33305de1ada3a693efd0c71903->block_container (line 432)
22	Twig\Template->yieldBlock (line 138)
23	Twig\Template->displayBlock (line 199)
24	Twig\Template->renderBlock (line 79)
25	Twig\TemplateWrapper->renderBlock (line 428)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 239)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderBlockView (line 33)
28	App\Controller\SpaController->renderSpa (line 33)
29	App\Controller\TournamentController->tournaments (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

6.28 ms
(19.43%)

SELECT r0_.id AS id_0, r0_.entity AS entity_1, r0_.entity_id AS entity_id_2, r0_.date AS date_3, r0_.user_id AS user_id_4, r0_.emoji_id AS emoji_id_5 FROM reaction r0_ WHERE r0_.entity = ? AND r0_.entity_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.entity AS entity_1,
  r0_.entity_id AS entity_id_2,
  r0_.date AS date_3,
  r0_.user_id AS user_id_4,
  r0_.emoji_id AS emoji_id_5
FROM
  reaction r0_
WHERE
  r0_.entity = ?
  AND r0_.entity_id = ?

SELECT r0_.id AS id_0, r0_.entity AS entity_1, r0_.entity_id AS entity_id_2, r0_.date AS date_3, r0_.user_id AS user_id_4, r0_.emoji_id AS emoji_id_5 FROM reaction r0_ WHERE r0_.entity = 4 AND r0_.entity_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 31)
7	App\Repository\ReactionRepository->findByEntity (line 51)
8	App\Service\Reactions->getByEntity (line 35)
9	App\Service\Reactions->fillEntities (line 28)
10	App\Controller\TournamentController->tournaments (line 183)
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)

1.52 ms
(4.71%)

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 115)
8	App\Entity\Level->getBg (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 48)
10	__TwigTemplate_ccad9c7c793f438b8000a33ae670119f->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 92)
16	__TwigTemplate_795c143c852d0faa122632c34681373d->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 48)
22	__TwigTemplate_5c8cdecca748b94336d926ad21c61c7a->doDisplay (line 388)
23	Twig\Template->yield (line 344)
24	Twig\Template->display (line 359)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 1493)
27	Twig\Extension\CoreExtension::include (line 314)
28	__TwigTemplate_2f98eb33305de1ada3a693efd0c71903->block_container (line 432)
29	Twig\Template->yieldBlock (line 138)
30	Twig\Template->displayBlock (line 199)
31	Twig\Template->renderBlock (line 79)
32	Twig\TemplateWrapper->renderBlock (line 428)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 239)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderBlockView (line 33)
35	App\Controller\SpaController->renderSpa (line 33)
36	App\Controller\TournamentController->tournaments (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

1.23 ms
(3.81%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.criteria AS criteria_2, p0_.add_criteria AS add_criteria_3, p0_.type AS type_4, p0_.title AS title_5, p0_.default_location_id AS default_location_id_6, p0_.tournament_id AS tournament_id_7 FROM phase p0_ INNER JOIN tournament t1_ ON p0_.tournament_id = t1_.id WHERE t1_.archive = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.criteria AS criteria_2,
  p0_.add_criteria AS add_criteria_3,
  p0_.type AS type_4,
  p0_.title AS title_5,
  p0_.default_location_id AS default_location_id_6,
  p0_.tournament_id AS tournament_id_7
FROM
  phase p0_
  INNER JOIN tournament t1_ ON p0_.tournament_id = t1_.id
WHERE
  t1_.archive = 0

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.criteria AS criteria_2, p0_.add_criteria AS add_criteria_3, p0_.type AS type_4, p0_.title AS title_5, p0_.default_location_id AS default_location_id_6, p0_.tournament_id AS tournament_id_7 FROM phase p0_ INNER JOIN tournament t1_ ON p0_.tournament_id = t1_.id WHERE t1_.archive = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 43)
7	App\Repository\PhaseRepository->findActual (line 21)
8	App\Controller\TournamentController->tournaments (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.81 ms
(2.51%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.about AS about_2, t0_.logo AS logo_3, t0_.season AS season_4, t0_.archive AS archive_5, t0_.date AS date_6, t0_.beach AS beach_7, t0_.filter AS filter_8, t0_.place1_id AS place1_id_9, t0_.place2_id AS place2_id_10, t0_.place3_id AS place3_id_11, t0_.place4_id AS place4_id_12, t0_.tournament_group_id AS tournament_group_id_13 FROM tournament t0_ WHERE t0_.archive = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.about AS about_2,
  t0_.logo AS logo_3,
  t0_.season AS season_4,
  t0_.archive AS archive_5,
  t0_.date AS date_6,
  t0_.beach AS beach_7,
  t0_.filter AS filter_8,
  t0_.place1_id AS place1_id_9,
  t0_.place2_id AS place2_id_10,
  t0_.place3_id AS place3_id_11,
  t0_.place4_id AS place4_id_12,
  t0_.tournament_group_id AS tournament_group_id_13
FROM
  tournament t0_
WHERE
  t0_.archive = 0

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.about AS about_2, t0_.logo AS logo_3, t0_.season AS season_4, t0_.archive AS archive_5, t0_.date AS date_6, t0_.beach AS beach_7, t0_.filter AS filter_8, t0_.place1_id AS place1_id_9, t0_.place2_id AS place2_id_10, t0_.place3_id AS place3_id_11, t0_.place4_id AS place4_id_12, t0_.tournament_group_id AS tournament_group_id_13 FROM tournament t0_ WHERE t0_.archive = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 57)
7	App\Repository\TournamentRepository->findActual (line 27)
8	App\Controller\TournamentController->tournaments (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.58 ms
(1.80%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.about AS about_2, t0_.logo AS logo_3, t0_.season AS season_4, t0_.archive AS archive_5, t0_.date AS date_6, t0_.beach AS beach_7, t0_.filter AS filter_8, t0_.place1_id AS place1_id_9, t0_.place2_id AS place2_id_10, t0_.place3_id AS place3_id_11, t0_.place4_id AS place4_id_12, t0_.tournament_group_id AS tournament_group_id_13 FROM tournament t0_ WHERE t0_.archive = 1 ORDER BY t0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.about AS about_2,
  t0_.logo AS logo_3,
  t0_.season AS season_4,
  t0_.archive AS archive_5,
  t0_.date AS date_6,
  t0_.beach AS beach_7,
  t0_.filter AS filter_8,
  t0_.place1_id AS place1_id_9,
  t0_.place2_id AS place2_id_10,
  t0_.place3_id AS place3_id_11,
  t0_.place4_id AS place4_id_12,
  t0_.tournament_group_id AS tournament_group_id_13
FROM
  tournament t0_
WHERE
  t0_.archive = 1
ORDER BY
  t0_.id DESC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.about AS about_2, t0_.logo AS logo_3, t0_.season AS season_4, t0_.archive AS archive_5, t0_.date AS date_6, t0_.beach AS beach_7, t0_.filter AS filter_8, t0_.place1_id AS place1_id_9, t0_.place2_id AS place2_id_10, t0_.place3_id AS place3_id_11, t0_.place4_id AS place4_id_12, t0_.tournament_group_id AS tournament_group_id_13 FROM tournament t0_ WHERE t0_.archive = 1 ORDER BY t0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 72)
7	App\Repository\TournamentRepository->findArchive (line 30)
8	App\Controller\TournamentController->tournaments (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.48 ms
(1.49%)

SELECT e0_.id AS id_0, e0_.value AS value_1, e0_.active AS active_2 FROM emoji e0_ WHERE e0_.active = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.value AS value_1,
  e0_.active AS active_2
FROM
  emoji e0_
WHERE
  e0_.active = 1

SELECT e0_.id AS id_0, e0_.value AS value_1, e0_.active AS active_2 FROM emoji e0_ WHERE e0_.active = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 27)
7	App\Repository\EmojiRepository->findActive (line 37)
8	App\Controller\TournamentController->tournaments (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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.
App\Entity\Phase	No errors.
App\Entity\Tournament	No errors.
App\Entity\Location	No errors.
App\Entity\TournamentGroup	No errors.
App\Entity\Reaction	No errors.
App\Entity\Emoji	No errors.
App\Entity\TeamInPhase	No errors.

Symfony Profiler

POST https://volik.webtm.ru/tournament

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping