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

Query Metrics

14 Database Queries
11 Different statements
33.21 ms Query time
0 Invalid entities
481 Managed entities

Queries

Group similar statements

# Time Info
1 4.73 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 2.60 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.hashed_password AS hashed_password_3, t0.display_name AS display_name_4, t0.roles AS roles_5, t0.avatar_url AS avatar_url_6, t0.theme_config AS theme_config_7, t0.status AS status_8, t0.custom_status_text AS custom_status_text_9, t0.last_seen_at AS last_seen_at_10, t0.created_at AS created_at_11, t0.is_email_verified AS is_email_verified_12, t0.email_verification_token AS email_verification_token_13, t0.email_verification_token_expires_at AS email_verification_token_expires_at_14, t0.account_type AS account_type_15, t0.description AS description_16, t0.organization_category AS organization_category_17, t0.featured_channel_id AS featured_channel_id_18, t0.contact_email AS contact_email_19, t0.website_url AS website_url_20, t0.phone_number AS phone_number_21, t0.postal_address AS postal_address_22, t0.group_visibility AS group_visibility_23, t0.accepts_membership_requests AS accepts_membership_requests_24, t0.tutorial_completed AS tutorial_completed_25, t0.archived_at AS archived_at_26, t0.white_label_config AS white_label_config_27, t0.subdomain AS subdomain_28 FROM users t0 WHERE t0.id = ?
Parameters:
[
  "019fb2bc-b2eb-7992-9aae-e20ec409f1dd"
]
3 1.03 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"
]
4 3.62 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"
]
5 2.39 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"
]
6 2.26 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:
[]
7 1.92 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-a74d-7a13-bae8-d4f2724ff976"
]
8 2.51 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-a74d-7a13-bae8-d4f2724ff976"
]
9 3.91 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"
]
10 3.61 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"
]
11 2.19 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-a74d-7a13-bae8-d4f2724ff976"
]
12 0.64 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"
]
13 1.12 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"
]
14 0.68 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\Identity\Domain\Model\User 1
App\Fantasy\Domain\Model\FantasyLeague 1