Symfony Profiler

Query Metrics

45 Database Queries

12 Different statements

19.35 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.14 ms
(42.05%)

SELECT n0_.id AS id_0, n0_.full_title AS full_title_1, n0_.short_title AS short_title_2, n0_.preview_text AS preview_text_3, n0_.text AS text_4, n0_.show_in_slider AS show_in_slider_5, n0_.date_publication AS date_publication_6, n0_.priority AS priority_7, n0_.video_link AS video_link_8, n0_.is_draft AS is_draft_9, n0_.date_create AS date_create_10, n0_.date_update AS date_update_11, n0_.object_status AS object_status_12, n0_.preview_image_id AS preview_image_id_13, n0_.header_image_id AS header_image_id_14, n0_.player_id AS player_id_15, n0_.staff_id AS staff_id_16, n0_.personnel_id AS personnel_id_17 FROM news n0_ WHERE n0_.show_in_slider = 1 AND n0_.object_status = ? AND n0_.is_draft = 0

Parameters:

[
  "active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.full_title AS full_title_1,
  n0_.short_title AS short_title_2,
  n0_.preview_text AS preview_text_3,
  n0_.text AS text_4,
  n0_.show_in_slider AS show_in_slider_5,
  n0_.date_publication AS date_publication_6,
  n0_.priority AS priority_7,
  n0_.video_link AS video_link_8,
  n0_.is_draft AS is_draft_9,
  n0_.date_create AS date_create_10,
  n0_.date_update AS date_update_11,
  n0_.object_status AS object_status_12,
  n0_.preview_image_id AS preview_image_id_13,
  n0_.header_image_id AS header_image_id_14,
  n0_.player_id AS player_id_15,
  n0_.staff_id AS staff_id_16,
  n0_.personnel_id AS personnel_id_17
FROM
  news n0_
WHERE
  n0_.show_in_slider = 1
  AND n0_.object_status = ?
  AND n0_.is_draft = 0

SELECT n0_.id AS id_0, n0_.full_title AS full_title_1, n0_.short_title AS short_title_2, n0_.preview_text AS preview_text_3, n0_.text AS text_4, n0_.show_in_slider AS show_in_slider_5, n0_.date_publication AS date_publication_6, n0_.priority AS priority_7, n0_.video_link AS video_link_8, n0_.is_draft AS is_draft_9, n0_.date_create AS date_create_10, n0_.date_update AS date_update_11, n0_.object_status AS object_status_12, n0_.preview_image_id AS preview_image_id_13, n0_.header_image_id AS header_image_id_14, n0_.player_id AS player_id_15, n0_.staff_id AS staff_id_16, n0_.personnel_id AS personnel_id_17 FROM news n0_ WHERE n0_.show_in_slider = 1 AND n0_.object_status = 'active' AND n0_.is_draft = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 51)
7	App\Repository\Content\NewsRepository->getDataForSlider (line 168)
8	App\Managers\Site\MediaManager->slider (line 16)
9	App\Controller\Site\IndexController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

3.96 ms
(20.48%)

SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?

Parameters:

[
  43771
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.module AS module_2,
  t0.mime_type AS mime_type_3,
  t0.size AS size_4,
  t0.name AS name_5,
  t0.date_create AS date_create_6,
  t0.date_update AS date_update_7,
  t0.object_status AS object_status_8
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = 43771;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 792)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Service\File::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\Service\File->__get (line 93)
8	App\Entity\Service\File->getPath (line 46)
9	App\Dto\Site\Media\NewsListItemResponse->__construct (line 173)
10	App\Managers\Site\MediaManager->slider (line 16)
11	App\Controller\Site\IndexController->index (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

1.59 ms
(8.20%)

SELECT t0.id AS id_1, t0.date_create AS date_create_2, t0.date_update AS date_update_3, t0.object_status AS object_status_4, t0.news_id AS news_id_5, t0.tag_id AS tag_id_6 FROM news_tag t0 WHERE t0.news_id = ?

Parameters:

[
  2098
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_create AS date_create_2,
  t0.date_update AS date_update_3,
  t0.object_status AS object_status_4,
  t0.news_id AS news_id_5,
  t0.tag_id AS tag_id_6
FROM
  news_tag t0
WHERE
  t0.news_id = ?

SELECT t0.id AS id_1, t0.date_create AS date_create_2, t0.date_update AS date_update_3, t0.object_status AS object_status_4, t0.news_id AS news_id_5, t0.tag_id AS tag_id_6 FROM news_tag t0 WHERE t0.news_id = 2098;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1889)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1830)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 167)
7	Doctrine\Common\Collections\AbstractLazyCollection->first (line 380)
8	App\Entity\Content\News->getFirstTagNameOrDefaultTitle (line 45)
9	App\Dto\Site\Media\NewsListItemResponse->__construct (line 173)
10	App\Managers\Site\MediaManager->slider (line 16)
11	App\Controller\Site\IndexController->index (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.92 ms
(4.76%)

SELECT t0.id AS id_1, t0.points_for_win AS points_for_win_2, t0.points_for_defeat AS points_for_defeat_3, t0.points_for_draw AS points_for_draw_4, t0.points_for_shootout_win AS points_for_shootout_win_5, t0.points_for_shootout_defeat AS points_for_shootout_defeat_6, t0.tournament_type_id AS tournament_type_id_7, t0.tournament_id AS tournament_id_8 FROM tournament_setting t0 WHERE t0.tournament_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.points_for_win AS points_for_win_2,
  t0.points_for_defeat AS points_for_defeat_3,
  t0.points_for_draw AS points_for_draw_4,
  t0.points_for_shootout_win AS points_for_shootout_win_5,
  t0.points_for_shootout_defeat AS points_for_shootout_defeat_6,
  t0.tournament_type_id AS tournament_type_id_7,
  t0.tournament_id AS tournament_id_8
FROM
  tournament_setting t0
WHERE
  t0.tournament_id = ?

SELECT t0.id AS id_1, t0.points_for_win AS points_for_win_2, t0.points_for_defeat AS points_for_defeat_3, t0.points_for_draw AS points_for_draw_4, t0.points_for_shootout_win AS points_for_shootout_win_5, t0.points_for_shootout_defeat AS points_for_shootout_defeat_6, t0.tournament_type_id AS tournament_type_id_7, t0.tournament_id AS tournament_id_8 FROM tournament_setting t0 WHERE t0.tournament_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 846)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3030)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
10	Doctrine\ORM\AbstractQuery->execute (line 901)
11	Doctrine\ORM\AbstractQuery->getResult (line 89)
12	App\Repository\Tournament\TournamentRepository->getTournamentsListBySeasons (line 66)
13	App\Managers\Site\TournamentManager->getTournamentsList (line 17)
14	App\Controller\Site\IndexController->index (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.84 ms
(4.34%)

SELECT v0_.id AS id_0, v0_.full_title AS full_title_1, v0_.short_title AS short_title_2, v0_.show_in_slider AS show_in_slider_3, v0_.date_publication AS date_publication_4, v0_.link AS link_5, v0_.text AS text_6, v0_.priority AS priority_7, v0_.date_create AS date_create_8, v0_.date_update AS date_update_9, v0_.object_status AS object_status_10, v0_.preview_image_id AS preview_image_id_11, v0_.header_image_id AS header_image_id_12 FROM video v0_ WHERE v0_.show_in_slider = 1 AND v0_.object_status = ?

Parameters:

[
  "active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.full_title AS full_title_1,
  v0_.short_title AS short_title_2,
  v0_.show_in_slider AS show_in_slider_3,
  v0_.date_publication AS date_publication_4,
  v0_.link AS link_5,
  v0_.text AS text_6,
  v0_.priority AS priority_7,
  v0_.date_create AS date_create_8,
  v0_.date_update AS date_update_9,
  v0_.object_status AS object_status_10,
  v0_.preview_image_id AS preview_image_id_11,
  v0_.header_image_id AS header_image_id_12
FROM
  video v0_
WHERE
  v0_.show_in_slider = 1
  AND v0_.object_status = ?

SELECT v0_.id AS id_0, v0_.full_title AS full_title_1, v0_.short_title AS short_title_2, v0_.show_in_slider AS show_in_slider_3, v0_.date_publication AS date_publication_4, v0_.link AS link_5, v0_.text AS text_6, v0_.priority AS priority_7, v0_.date_create AS date_create_8, v0_.date_update AS date_update_9, v0_.object_status AS object_status_10, v0_.preview_image_id AS preview_image_id_11, v0_.header_image_id AS header_image_id_12 FROM video v0_ WHERE v0_.show_in_slider = 1 AND v0_.object_status = 'active';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 62)
7	App\Repository\Content\VideoRepository->getDataForSlider (line 168)
8	App\Managers\Site\MediaManager->slider (line 16)
9	App\Controller\Site\IndexController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.78 ms
(4.04%)

SELECT t0.id AS id_1, t0.tournament_id AS tournament_id_2, t0.tournament_group_id AS tournament_group_id_3, t0.team_id AS team_id_4 FROM tournament_team t0 WHERE t0.tournament_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.tournament_id AS tournament_id_2,
  t0.tournament_group_id AS tournament_group_id_3,
  t0.team_id AS team_id_4
FROM
  tournament_team t0
WHERE
  t0.tournament_id = ?

SELECT t0.id AS id_1, t0.tournament_id AS tournament_id_2, t0.tournament_group_id AS tournament_group_id_3, t0.team_id AS team_id_4 FROM tournament_team t0 WHERE t0.tournament_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1889)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1830)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 333)
8	App\Entity\Tournament\Tournament->isMain (line 45)
9	App\Dto\Site\Tournament\ListItemResponse->__construct (line 69)
10	App\Managers\Site\TournamentManager->getTournamentsList (line 17)
11	App\Controller\Site\IndexController->index (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.59 ms
(3.07%)

SELECT t0_.id AS id_0, t0_.full_name AS full_name_1, t0_.short_name AS short_name_2, t0_.yandex_id AS yandex_id_3, t0_.date_start AS date_start_4, t0_.date_end AS date_end_5, t0_.date_create AS date_create_6, t0_.date_update AS date_update_7, t0_.object_status AS object_status_8, t0_.type_id AS type_id_9, t0_.season_id AS season_id_10, t0_.logo_id AS logo_id_11 FROM tournament t0_ WHERE t0_.season_id IN (?, ?) AND t0_.object_status = ? ORDER BY t0_.id ASC

Parameters:

[
  6
  8
  "active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.full_name AS full_name_1,
  t0_.short_name AS short_name_2,
  t0_.yandex_id AS yandex_id_3,
  t0_.date_start AS date_start_4,
  t0_.date_end AS date_end_5,
  t0_.date_create AS date_create_6,
  t0_.date_update AS date_update_7,
  t0_.object_status AS object_status_8,
  t0_.type_id AS type_id_9,
  t0_.season_id AS season_id_10,
  t0_.logo_id AS logo_id_11
FROM
  tournament t0_
WHERE
  t0_.season_id IN (?, ?)
  AND t0_.object_status = ?
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.full_name AS full_name_1, t0_.short_name AS short_name_2, t0_.yandex_id AS yandex_id_3, t0_.date_start AS date_start_4, t0_.date_end AS date_end_5, t0_.date_create AS date_create_6, t0_.date_update AS date_update_7, t0_.object_status AS object_status_8, t0_.type_id AS type_id_9, t0_.season_id AS season_id_10, t0_.logo_id AS logo_id_11 FROM tournament t0_ WHERE t0_.season_id IN (6, 8) AND t0_.object_status = 'active' ORDER BY t0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 89)
7	App\Repository\Tournament\TournamentRepository->getTournamentsListBySeasons (line 66)
8	App\Managers\Site\TournamentManager->getTournamentsList (line 17)
9	App\Controller\Site\IndexController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.55 ms
(2.86%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.current AS current_3, t0.date_create AS date_create_4, t0.date_update AS date_update_5, t0.object_status AS object_status_6, t0.team_id AS team_id_7 FROM season t0 WHERE t0.current = ? AND t0.object_status = ?

Parameters:

[
  1
  "active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.current AS current_3,
  t0.date_create AS date_create_4,
  t0.date_update AS date_update_5,
  t0.object_status AS object_status_6,
  t0.team_id AS team_id_7
FROM
  season t0
WHERE
  t0.current = ?
  AND t0.object_status = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.current AS current_3, t0.date_create AS date_create_4, t0.date_update AS date_update_5, t0.object_status AS object_status_6, t0.team_id AS team_id_7 FROM season t0 WHERE t0.current = 1 AND t0.object_status = 'active';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 56)
4	App\Managers\Site\TournamentManager->getTournamentsList (line 17)
5	App\Controller\Site\IndexController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.52 ms
(2.71%)

SELECT p0_.id AS id_0, p0_.full_title AS full_title_1, p0_.short_title AS short_title_2, p0_.show_in_slider AS show_in_slider_3, p0_.date_publication AS date_publication_4, p0_.priority AS priority_5, p0_.date_create AS date_create_6, p0_.date_update AS date_update_7, p0_.object_status AS object_status_8, p0_.preview_image_id AS preview_image_id_9, p0_.header_image_id AS header_image_id_10 FROM photo p0_ WHERE p0_.show_in_slider = 1 AND p0_.object_status = ?

Parameters:

[
  "active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.full_title AS full_title_1,
  p0_.short_title AS short_title_2,
  p0_.show_in_slider AS show_in_slider_3,
  p0_.date_publication AS date_publication_4,
  p0_.priority AS priority_5,
  p0_.date_create AS date_create_6,
  p0_.date_update AS date_update_7,
  p0_.object_status AS object_status_8,
  p0_.preview_image_id AS preview_image_id_9,
  p0_.header_image_id AS header_image_id_10
FROM
  photo p0_
WHERE
  p0_.show_in_slider = 1
  AND p0_.object_status = ?

SELECT p0_.id AS id_0, p0_.full_title AS full_title_1, p0_.short_title AS short_title_2, p0_.show_in_slider AS show_in_slider_3, p0_.date_publication AS date_publication_4, p0_.priority AS priority_5, p0_.date_create AS date_create_6, p0_.date_update AS date_update_7, p0_.object_status AS object_status_8, p0_.preview_image_id AS preview_image_id_9, p0_.header_image_id AS header_image_id_10 FROM photo p0_ WHERE p0_.show_in_slider = 1 AND p0_.object_status = 'active';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 63)
7	App\Repository\Content\PhotoRepository->getDataForSlider (line 168)
8	App\Managers\Site\MediaManager->slider (line 16)
9	App\Controller\Site\IndexController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.49 ms
(2.54%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.line AS line_4, t0.link AS link_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8, t0.preview_image_id AS preview_image_id_9 FROM partner t0 WHERE t0.object_status = ? ORDER BY t0.line ASC, t0.priority ASC

Parameters:

[
  "active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.priority AS priority_3,
  t0.line AS line_4,
  t0.link AS link_5,
  t0.date_create AS date_create_6,
  t0.date_update AS date_update_7,
  t0.object_status AS object_status_8,
  t0.preview_image_id AS preview_image_id_9
FROM
  partner t0
WHERE
  t0.object_status = ?
ORDER BY
  t0.line ASC,
  t0.priority ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.line AS line_4, t0.link AS link_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8, t0.preview_image_id AS preview_image_id_9 FROM partner t0 WHERE t0.object_status = 'active' ORDER BY t0.line ASC, t0.priority ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 18)
4	App\Controller\Site\Content\PartnerController->footer (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 488)
12	__TwigTemplate_d53dece85589918dbeb201351010d90b->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 50)
15	__TwigTemplate_c69a6c1d3aa02b113a5fae8d10d7987c->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 243)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 20)
23	App\Controller\Site\IndexController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.48 ms
(2.50%)

SELECT t0.id AS id_1, t0.date_create AS date_create_2, t0.date_update AS date_update_3, t0.object_status AS object_status_4, t0.image_id AS image_id_5 FROM banner t0 WHERE t0.object_status = ? LIMIT 1

Parameters:

[
  "active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_create AS date_create_2,
  t0.date_update AS date_update_3,
  t0.object_status AS object_status_4,
  t0.image_id AS image_id_5
FROM
  banner t0
WHERE
  t0.object_status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_create AS date_create_2, t0.date_update AS date_update_3, t0.object_status AS object_status_4, t0.image_id AS image_id_5 FROM banner t0 WHERE t0.object_status = 'active' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 18)
4	App\Controller\Site\IndexController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.47 ms
(2.45%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.short_name AS short_name_3, t0.main AS main_4, t0.date_create AS date_create_5, t0.date_update AS date_update_6, t0.object_status AS object_status_7, t0.club_id AS club_id_8, t0.logo_id AS logo_id_9 FROM team t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.short_name AS short_name_3,
  t0.main AS main_4,
  t0.date_create AS date_create_5,
  t0.date_update AS date_update_6,
  t0.object_status AS object_status_7,
  t0.club_id AS club_id_8,
  t0.logo_id AS logo_id_9
FROM
  team t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.short_name AS short_name_3, t0.main AS main_4, t0.date_create AS date_create_5, t0.date_update AS date_update_6, t0.object_status AS object_status_7, t0.club_id AS club_id_8, t0.logo_id AS logo_id_9 FROM team t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 792)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Team\Team::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\Team\Team->__get (line 254)
8	App\Entity\Team\Team->isMain (line 334)
9	App\Entity\Tournament\Tournament->isMain (line 45)
10	App\Dto\Site\Tournament\ListItemResponse->__construct (line 69)
11	App\Managers\Site\TournamentManager->getTournamentsList (line 17)
12	App\Controller\Site\IndexController->index (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	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\Content\News	No errors.
App\Entity\Service\File	No errors.
App\Entity\Human\Player	No errors.
App\Entity\Human\Staff	No errors.
App\Entity\Human\Personnel	No errors.
App\Entity\Service\NewsImage	No errors.
App\Entity\Service\NewsTag	No errors.
App\Entity\Service\NewsGame	The association App\Entity\Service\NewsGame#game refers to the inverse side field App\Entity\Game\Game#news which does not exist.
App\Entity\Service\Tag	No errors.
App\Entity\Content\Photo	No errors.
App\Entity\Content\Video	No errors.
App\Entity\Tournament\Season	No errors.
App\Entity\Team\Team	No errors.
App\Entity\Tournament\Tournament	No errors.
App\Entity\Tournament\TournamentType	No errors.
App\Entity\Tournament\Group	No errors.
App\Entity\Tournament\TournamentTeam	No errors.
App\Entity\Tournament\Stage	No errors.
App\Entity\Tournament\TournamentSetting	No errors.
App\Entity\Tournament\Tour	No errors.
App\Entity\Team\Club	The association App\Entity\Team\Club#city refers to the inverse side field App\Entity\Reference\City#clubs which does not exist.
App\Entity\Team\TeamPlayer	No errors.
App\Entity\Team\TeamStaff	No errors.
App\Entity\Team\TeamPersonnel	No errors.
App\Entity\Game\Game	The field App\Entity\Game\Game#gameEvents is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Game\GameEvent#game does not contain the required 'inversedBy="gameEvents"' attribute. The mappings App\Entity\Game\Game#gameNews and App\Entity\Service\NewsGame#game are inconsistent with each other. The mappings App\Entity\Game\Game#gameVideos and App\Entity\Service\VideoGame#game are inconsistent with each other. The mappings App\Entity\Game\Game#gamePhotos and App\Entity\Service\PhotoGame#game are inconsistent with each other.
App\Entity\Content\Banner	No errors.
App\Entity\Content\Partner	No errors.

Symfony Profiler

GET https://test.fcakron.ru/_fragment?_path=_format%3Dhtml%26_locale%3Dru%26_controller%3DApp%255CController%255CSite%255CContent%255CPartnerController%253A%253Afoo…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping