Symfony Profiler

Query Metrics

12 Database Queries

10 Different statements

26.09 ms Query time

0 Invalid entities

480 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.68 ms
(17.93%)

SELECT o0_.id AS id_0, o0_.organization_id AS organization_id_1, o0_.domain AS domain_2, o0_.verified AS verified_3, o0_.created_at AS created_at_4 FROM organization_domains o0_ WHERE o0_.domain = ?

Parameters:

[
  "fantasyleague.tokii.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.organization_id AS organization_id_1,
  o0_.domain AS domain_2,
  o0_.verified AS verified_3,
  o0_.created_at AS created_at_4
FROM
  organization_domains o0_
WHERE
  o0_.domain = ?

SELECT o0_.id AS id_0, o0_.organization_id AS organization_id_1, o0_.domain AS domain_2, o0_.verified AS verified_3, o0_.created_at AS created_at_4 FROM organization_domains o0_ WHERE o0_.domain = 'fantasyleague.tokii.fr';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Identity\Infrastructure\Persistence\Doctrine\DoctrineOrganizationDomainRepository->findByHost (line 37)
7	App\UI\Http\Web\FantasySiteController->requireLeague (line 170)
8	App\UI\Http\Web\FantasySiteController->gameweek (line 117)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

4.08 ms
(15.65%)

SELECT t0.id AS id_1, t0.league_id AS league_id_2, t0.user_id AS user_id_3, t0.name AS name_4, t0.picks AS picks_5, t0.locked_picks AS locked_picks_6, t0.free_transfers AS free_transfers_7, t0.total_points AS total_points_8, t0.created_at AS created_at_9 FROM fantasy_teams t0 WHERE t0.league_id = ? ORDER BY t0.total_points DESC, t0.created_at ASC

Parameters:

[
  "019fb2bc-b34e-7bd2-bdbf-797f08d5c576"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.league_id AS league_id_2,
  t0.user_id AS user_id_3,
  t0.name AS name_4,
  t0.picks AS picks_5,
  t0.locked_picks AS locked_picks_6,
  t0.free_transfers AS free_transfers_7,
  t0.total_points AS total_points_8,
  t0.created_at AS created_at_9
FROM
  fantasy_teams t0
WHERE
  t0.league_id = ?
ORDER BY
  t0.total_points DESC,
  t0.created_at ASC

SELECT t0.id AS id_1, t0.league_id AS league_id_2, t0.user_id AS user_id_3, t0.name AS name_4, t0.picks AS picks_5, t0.locked_picks AS locked_picks_6, t0.free_transfers AS free_transfers_7, t0.total_points AS total_points_8, t0.created_at AS created_at_9 FROM fantasy_teams t0 WHERE t0.league_id = '019fb2bc-b34e-7bd2-bdbf-797f08d5c576' ORDER BY t0.total_points DESC, t0.created_at ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Fantasy\Infrastructure\Persistence\Doctrine\DoctrineFantasyTeamRepository->findByLeague (line 36)
4	App\Fantasy\Application\Query\GetGameweekDetail\GetGameweekDetailHandler->__invoke (line 87)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
8	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
13	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
17	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
18	App\UI\Http\Web\FantasySiteController->gameweek (line 120)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

3.67 ms
(14.07%)

SELECT t0.id AS id_1, t0.organization_id AS organization_id_2, t0.conversation_id AS conversation_id_3, t0.name AS name_4, t0.season AS season_5, t0.is_public AS is_public_6, t0.created_by AS created_by_7, t0.version AS version_8, t0.created_at AS created_at_9 FROM fantasy_leagues t0 WHERE t0.organization_id = ? ORDER BY t0.created_at ASC LIMIT 1

Parameters:

[
  "019fb2bc-b2eb-7992-9aae-e20ec409f1dd"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.organization_id AS organization_id_2,
  t0.conversation_id AS conversation_id_3,
  t0.name AS name_4,
  t0.season AS season_5,
  t0.is_public AS is_public_6,
  t0.created_by AS created_by_7,
  t0.version AS version_8,
  t0.created_at AS created_at_9
FROM
  fantasy_leagues t0
WHERE
  t0.organization_id = ?
ORDER BY
  t0.created_at ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.organization_id AS organization_id_2, t0.conversation_id AS conversation_id_3, t0.name AS name_4, t0.season AS season_5, t0.is_public AS is_public_6, t0.created_by AS created_by_7, t0.version AS version_8, t0.created_at AS created_at_9 FROM fantasy_leagues t0 WHERE t0.organization_id = '019fb2bc-b2eb-7992-9aae-e20ec409f1dd' ORDER BY t0.created_at ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Fantasy\Infrastructure\Persistence\Doctrine\DoctrineFantasyLeagueRepository->findByOrganization (line 29)
4	App\UI\Http\Web\FantasySiteController->requireLeague (line 176)
5	App\UI\Http\Web\FantasySiteController->gameweek (line 117)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

2.95 ms
(11.33%)

SELECT t0.id AS id_1, t0.club_id AS club_id_2, t0.season AS season_3, t0.name AS name_4, t0.position AS position_5, t0.price_tenths AS price_tenths_6 FROM fantasy_real_players t0 WHERE t0.season = ? ORDER BY t0.name ASC

Parameters:

[
  "2025-26"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.club_id AS club_id_2,
  t0.season AS season_3,
  t0.name AS name_4,
  t0.position AS position_5,
  t0.price_tenths AS price_tenths_6
FROM
  fantasy_real_players t0
WHERE
  t0.season = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.club_id AS club_id_2, t0.season AS season_3, t0.name AS name_4, t0.position AS position_5, t0.price_tenths AS price_tenths_6 FROM fantasy_real_players t0 WHERE t0.season = '2025-26' ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Fantasy\Infrastructure\Persistence\Doctrine\DoctrineRealPlayerRepository->findBySeason (line 66)
4	App\Fantasy\Application\Query\GetGameweekDetail\GetGameweekDetailHandler->__invoke (line 99)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
8	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
13	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
17	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
18	App\UI\Http\Web\FantasySiteController->gameweek (line 120)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

2.32 ms
(8.88%)

SELECT t0.id AS id_1, t0.season AS season_2, t0.number AS number_3, t0.deadline_at AS deadline_at_4, t0.status AS status_5 FROM fantasy_gameweeks t0 WHERE t0.season = ? ORDER BY t0.number ASC

Parameters:

[
  "2025-26"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.season AS season_2,
  t0.number AS number_3,
  t0.deadline_at AS deadline_at_4,
  t0.status AS status_5
FROM
  fantasy_gameweeks t0
WHERE
  t0.season = ?
ORDER BY
  t0.number ASC

SELECT t0.id AS id_1, t0.season AS season_2, t0.number AS number_3, t0.deadline_at AS deadline_at_4, t0.status AS status_5 FROM fantasy_gameweeks t0 WHERE t0.season = '2025-26' ORDER BY t0.number ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Fantasy\Infrastructure\Persistence\Doctrine\DoctrineGameweekRepository->findBySeason (line 33)
4	App\Fantasy\Application\Query\GetGameweekDetail\GetGameweekDetailHandler->__invoke (line 47)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
8	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
13	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
17	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
18	App\UI\Http\Web\FantasySiteController->gameweek (line 120)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

2.00 ms
(7.65%)

SELECT t0.id AS id_1, t0.gameweek_id AS gameweek_id_2, t0.player_id AS player_id_3, t0.minutes AS minutes_4, t0.goals AS goals_5, t0.assists AS assists_6, t0.goals_conceded AS goals_conceded_7, t0.saves AS saves_8, t0.penalties_saved AS penalties_saved_9, t0.penalties_missed AS penalties_missed_10, t0.yellow_cards AS yellow_cards_11, t0.red_cards AS red_cards_12, t0.own_goals AS own_goals_13, t0.bonus AS bonus_14 FROM fantasy_player_performances t0 WHERE t0.gameweek_id = ?

Parameters:

[
  "019fb2bc-a742-7c72-be30-cd5d42498c19"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.gameweek_id AS gameweek_id_2,
  t0.player_id AS player_id_3,
  t0.minutes AS minutes_4,
  t0.goals AS goals_5,
  t0.assists AS assists_6,
  t0.goals_conceded AS goals_conceded_7,
  t0.saves AS saves_8,
  t0.penalties_saved AS penalties_saved_9,
  t0.penalties_missed AS penalties_missed_10,
  t0.yellow_cards AS yellow_cards_11,
  t0.red_cards AS red_cards_12,
  t0.own_goals AS own_goals_13,
  t0.bonus AS bonus_14
FROM
  fantasy_player_performances t0
WHERE
  t0.gameweek_id = ?

SELECT t0.id AS id_1, t0.gameweek_id AS gameweek_id_2, t0.player_id AS player_id_3, t0.minutes AS minutes_4, t0.goals AS goals_5, t0.assists AS assists_6, t0.goals_conceded AS goals_conceded_7, t0.saves AS saves_8, t0.penalties_saved AS penalties_saved_9, t0.penalties_missed AS penalties_missed_10, t0.yellow_cards AS yellow_cards_11, t0.red_cards AS red_cards_12, t0.own_goals AS own_goals_13, t0.bonus AS bonus_14 FROM fantasy_player_performances t0 WHERE t0.gameweek_id = '019fb2bc-a742-7c72-be30-cd5d42498c19';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Fantasy\Infrastructure\Persistence\Doctrine\DoctrinePlayerPerformanceRepository->findByGameweek (line 30)
4	App\Fantasy\Application\Query\GetGameweekDetail\GetGameweekDetailHandler->__invoke (line 105)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
8	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
13	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
17	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
18	App\UI\Http\Web\FantasySiteController->gameweek (line 120)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

1.84 ms
(7.04%)

SELECT t0.id AS id_1, t0.gameweek_id AS gameweek_id_2, t0.home_club_id AS home_club_id_3, t0.away_club_id AS away_club_id_4, t0.home_score AS home_score_5, t0.away_score AS away_score_6 FROM fantasy_fixtures t0 WHERE t0.gameweek_id = ?

Parameters:

[
  "019fb2bc-a742-7c72-be30-cd5d42498c19"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.gameweek_id AS gameweek_id_2,
  t0.home_club_id AS home_club_id_3,
  t0.away_club_id AS away_club_id_4,
  t0.home_score AS home_score_5,
  t0.away_score AS away_score_6
FROM
  fantasy_fixtures t0
WHERE
  t0.gameweek_id = ?

SELECT t0.id AS id_1, t0.gameweek_id AS gameweek_id_2, t0.home_club_id AS home_club_id_3, t0.away_club_id AS away_club_id_4, t0.home_score AS home_score_5, t0.away_score AS away_score_6 FROM fantasy_fixtures t0 WHERE t0.gameweek_id = '019fb2bc-a742-7c72-be30-cd5d42498c19';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Fantasy\Infrastructure\Persistence\Doctrine\DoctrineFixtureRepository->findByGameweek (line 27)
4	App\Fantasy\Application\Query\GetGameweekDetail\GetGameweekDetailHandler->__invoke (line 68)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
8	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
13	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
17	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
18	App\UI\Http\Web\FantasySiteController->gameweek (line 120)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

1.59 ms
(6.11%)

SELECT t0.id AS id_1, t0.team_id AS team_id_2, t0.gameweek_id AS gameweek_id_3, t0.picks AS picks_4, t0.transfer_penalty AS transfer_penalty_5, t0.points AS points_6, t0.created_at AS created_at_7 FROM fantasy_team_snapshots t0 WHERE t0.gameweek_id = ?

Parameters:

[
  "019fb2bc-a742-7c72-be30-cd5d42498c19"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.team_id AS team_id_2,
  t0.gameweek_id AS gameweek_id_3,
  t0.picks AS picks_4,
  t0.transfer_penalty AS transfer_penalty_5,
  t0.points AS points_6,
  t0.created_at AS created_at_7
FROM
  fantasy_team_snapshots t0
WHERE
  t0.gameweek_id = ?

SELECT t0.id AS id_1, t0.team_id AS team_id_2, t0.gameweek_id AS gameweek_id_3, t0.picks AS picks_4, t0.transfer_penalty AS transfer_penalty_5, t0.points AS points_6, t0.created_at AS created_at_7 FROM fantasy_team_snapshots t0 WHERE t0.gameweek_id = '019fb2bc-a742-7c72-be30-cd5d42498c19';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Fantasy\Infrastructure\Persistence\Doctrine\DoctrineTeamGameweekSnapshotRepository->findByGameweek (line 30)
4	App\Fantasy\Application\Query\GetGameweekDetail\GetGameweekDetailHandler->__invoke (line 81)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
8	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
13	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
17	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
18	App\UI\Http\Web\FantasySiteController->gameweek (line 120)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

1.50 ms
(5.76%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.short_name AS short_name_4 FROM fantasy_clubs t0 ORDER BY t0.name ASC

Parameters:

[]

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.short_name AS short_name_4
FROM
  fantasy_clubs t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.short_name AS short_name_4 FROM fantasy_clubs t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Fantasy\Infrastructure\Persistence\Doctrine\DoctrineClubRepository->findAll (line 31)
4	App\Fantasy\Application\Query\GetGameweekDetail\GetGameweekDetailHandler->__invoke (line 62)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
8	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
13	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
17	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
18	App\UI\Http\Web\FantasySiteController->gameweek (line 120)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

1.46 ms
(5.59%)

SELECT f0_.id AS id_0, f0_.season AS season_1, f0_.number AS number_2, f0_.deadline_at AS deadline_at_3, f0_.status AS status_4 FROM fantasy_gameweeks f0_ WHERE f0_.season = ? AND f0_.status <> ? ORDER BY f0_.number ASC LIMIT 1

Parameters:

[
  "2025-26"
  "finalized"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.season AS season_1,
  f0_.number AS number_2,
  f0_.deadline_at AS deadline_at_3,
  f0_.status AS status_4
FROM
  fantasy_gameweeks f0_
WHERE
  f0_.season = ?
  AND f0_.status <> ?
ORDER BY
  f0_.number ASC
LIMIT
  1

SELECT f0_.id AS id_0, f0_.season AS season_1, f0_.number AS number_2, f0_.deadline_at AS deadline_at_3, f0_.status AS status_4 FROM fantasy_gameweeks f0_ WHERE f0_.season = '2025-26' AND f0_.status <> 'finalized' ORDER BY f0_.number ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Fantasy\Infrastructure\Persistence\Doctrine\DoctrineGameweekRepository->findCurrent (line 49)
7	App\Fantasy\Application\Query\GetLeagueOverview\GetLeagueOverviewHandler->__invoke (line 34)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
10	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
11	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
12	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
13	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
14	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
15	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
16	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
17	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
18	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
19	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
20	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
21	App\UI\Http\Web\FantasySiteController->vars (line 200)
22	App\UI\Http\Web\FantasySiteController->gameweek (line 125)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 191)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Fantasy\Domain\Model\RealPlayer	414
App\Fantasy\Domain\Model\Gameweek	34
App\Fantasy\Domain\Model\Club	18
App\Fantasy\Domain\Model\Fixture	9
App\Fantasy\Domain\Model\FantasyTeam	3
App\Identity\Domain\Model\OrganizationDomain	1
App\Fantasy\Domain\Model\FantasyLeague	1

Entities Mapping

Class	Mapping errors
App\Identity\Domain\Model\OrganizationDomain	No errors.
App\Fantasy\Domain\Model\FantasyLeague	No errors.
App\Fantasy\Domain\Model\Gameweek	No errors.
App\Fantasy\Domain\Model\Club	No errors.
App\Fantasy\Domain\Model\Fixture	No errors.
App\Fantasy\Domain\Model\TeamGameweekSnapshot	No errors.
App\Fantasy\Domain\Model\FantasyTeam	No errors.
App\Fantasy\Domain\Model\RealPlayer	No errors.
App\Fantasy\Domain\Model\PlayerPerformance	No errors.

Symfony Profiler

GET https://fantasyleague.tokii.fr/journee/1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping