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

Query Metrics

12 Database Queries
10 Different statements
26.09 ms Query time
0 Invalid entities
480 Managed entities

Queries

Group similar statements

# Time Info
1 4.68 ms
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"
]
2 3.00 ms
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"
]
3 2.32 ms
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"
]
4 1.50 ms
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:
[]
5 1.84 ms
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"
]
6 1.59 ms
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"
]
7 2.24 ms
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"
]
8 2.95 ms
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"
]
9 2.00 ms
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"
]
10 0.67 ms
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"
]
11 1.46 ms
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"
]
12 1.84 ms
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"
]

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