GET https://fantasyleague.tokii.fr/

Query Metrics

12 Database Queries
6 Different statements
23.18 ms Query time
0 Invalid entities
43 Managed entities

Queries

Group similar statements

# Time Info
1 5.09 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.93 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 0.53 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.11 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.22 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.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"
]
7 0.68 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:
[
  "019e650b-3a60-7455-b3f0-38bbc242bd88"
]
8 0.68 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:
[
  "019e650b-3bff-72dc-a0d3-78c358294797"
]
9 0.68 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:
[
  "019e650b-3d96-7219-ba87-8e78dd34fc25"
]
10 2.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"
]
11 1.64 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 0.95 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\Gameweek 34
App\Identity\Domain\Model\User 4
App\Fantasy\Domain\Model\FantasyTeam 3
App\Identity\Domain\Model\OrganizationDomain 1
App\Fantasy\Domain\Model\FantasyLeague 1