GET https://fanfinity.playerlink.online/

Query Metrics

24 Database Queries
10 Different statements
14.34 ms Query time
0 Invalid entities
17 Managed entities

Queries

Group similar statements

# Time Info
1 0.82 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pronouns AS pronouns_6, t0.magic_melee_email AS magic_melee_email_7, t0.birthdate AS birthdate_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.preferred_name AS preferred_name_11, t0.magic_wizards_email AS magic_wizards_email_12, t0.fab_gem_id AS fab_gem_id_13, t0.country AS country_14, t0.avatar AS avatar_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.last_login_attempt AS last_login_attempt_18, t0.last_login_code AS last_login_code_19, t0.fixture AS fixture_20, t0.pokemon_player_id AS pokemon_player_id_21, t0.is_login_restricted AS is_login_restricted_22, t0.tags AS tags_23, t0.konami_card_game_id AS konami_card_game_id_24, t0.jwt_token AS jwt_token_25 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  30060
]
2 0.70 ms
SELECT t0.id AS id_1, t0.role AS role_2, t0.user_id AS user_id_3, t0.event_id AS event_id_4, t0.convention_id AS convention_id_5 FROM user_role t0 WHERE t0.user_id = ?
Parameters:
[
  30060
]
3 0.70 ms
SELECT t0.id AS id_1, t0.is_child_relationship AS is_child_relationship_2, t0.parent_user_id AS parent_user_id_3, t0.child_user_id AS child_user_id_4 FROM user_relation t0 WHERE t0.parent_user_id = ?
Parameters:
[
  30060
]
4 0.69 ms
SELECT t0.id AS id_1, t0.is_child_relationship AS is_child_relationship_2, t0.parent_user_id AS parent_user_id_3, t0.child_user_id AS child_user_id_4 FROM user_relation t0 WHERE t0.child_user_id = ?
Parameters:
[
  30060
]
5 0.67 ms
SELECT t0.id AS id_1, t0.message AS message_2, t0.is_read AS is_read_3, t0.created_at AS created_at_4, t0.referrer_path AS referrer_path_5, t0.referrer_params AS referrer_params_6, t0.user_id AS user_id_7 FROM user_notification t0 WHERE t0.user_id = ?
Parameters:
[
  30060
]
6 0.91 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pronouns AS pronouns_6, t0.magic_melee_email AS magic_melee_email_7, t0.birthdate AS birthdate_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.preferred_name AS preferred_name_11, t0.magic_wizards_email AS magic_wizards_email_12, t0.fab_gem_id AS fab_gem_id_13, t0.country AS country_14, t0.avatar AS avatar_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.last_login_attempt AS last_login_attempt_18, t0.last_login_code AS last_login_code_19, t0.fixture AS fixture_20, t0.pokemon_player_id AS pokemon_player_id_21, t0.is_login_restricted AS is_login_restricted_22, t0.tags AS tags_23, t0.konami_card_game_id AS konami_card_game_id_24, t0.jwt_token AS jwt_token_25 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  32920
]
7 0.64 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pronouns AS pronouns_6, t0.magic_melee_email AS magic_melee_email_7, t0.birthdate AS birthdate_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.preferred_name AS preferred_name_11, t0.magic_wizards_email AS magic_wizards_email_12, t0.fab_gem_id AS fab_gem_id_13, t0.country AS country_14, t0.avatar AS avatar_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.last_login_attempt AS last_login_attempt_18, t0.last_login_code AS last_login_code_19, t0.fixture AS fixture_20, t0.pokemon_player_id AS pokemon_player_id_21, t0.is_login_restricted AS is_login_restricted_22, t0.tags AS tags_23, t0.konami_card_game_id AS konami_card_game_id_24, t0.jwt_token AS jwt_token_25 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  34777
]
8 0.51 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pronouns AS pronouns_6, t0.magic_melee_email AS magic_melee_email_7, t0.birthdate AS birthdate_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.preferred_name AS preferred_name_11, t0.magic_wizards_email AS magic_wizards_email_12, t0.fab_gem_id AS fab_gem_id_13, t0.country AS country_14, t0.avatar AS avatar_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.last_login_attempt AS last_login_attempt_18, t0.last_login_code AS last_login_code_19, t0.fixture AS fixture_20, t0.pokemon_player_id AS pokemon_player_id_21, t0.is_login_restricted AS is_login_restricted_22, t0.tags AS tags_23, t0.konami_card_game_id AS konami_card_game_id_24, t0.jwt_token AS jwt_token_25 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  35010
]
9 0.47 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pronouns AS pronouns_6, t0.magic_melee_email AS magic_melee_email_7, t0.birthdate AS birthdate_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.preferred_name AS preferred_name_11, t0.magic_wizards_email AS magic_wizards_email_12, t0.fab_gem_id AS fab_gem_id_13, t0.country AS country_14, t0.avatar AS avatar_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.last_login_attempt AS last_login_attempt_18, t0.last_login_code AS last_login_code_19, t0.fixture AS fixture_20, t0.pokemon_player_id AS pokemon_player_id_21, t0.is_login_restricted AS is_login_restricted_22, t0.tags AS tags_23, t0.konami_card_game_id AS konami_card_game_id_24, t0.jwt_token AS jwt_token_25 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  35064
]
10 0.44 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.user_id AS user_id_3, t0.ticket_id AS ticket_id_4 FROM user_ticket t0 WHERE t0.user_id = ?
Parameters:
[
  30060
]
11 0.64 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.data AS data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.checked_in AS checked_in_6, t0.notes AS notes_7, t0.redeemed_prize AS redeemed_prize_8, t0.tags AS tags_9, t0.user_id AS user_id_10, t0.event_id AS event_id_11, t0.tournament_queue_id AS tournament_queue_id_12, t0.payment_user_id AS payment_user_id_13 FROM registration t0 WHERE t0.user_id = ?
Parameters:
[
  30060
]
12 0.77 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.flags AS flags_7, t0.starts_at AS starts_at_8, t0.registration_fee AS registration_fee_9, t0.max_registration AS max_registration_10, t0.team_size AS team_size_11, t0.registration_open_at AS registration_open_at_12, t0.registration_closed_at AS registration_closed_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.format AS format_16, t0.game AS game_17, t0.tags AS tags_18, t0.prizes AS prizes_19, t0.required_data AS required_data_20, t0.player_note AS player_note_21, t0.public AS public_22, t0.starting_table AS starting_table_23, t0.additional_metadata AS additional_metadata_24, t0.event_timer AS event_timer_25, t0.event_color AS event_color_26, t0.external_registration_url AS external_registration_url_27, t0.featured AS featured_28, t0.image AS image_29, t0.queue_type AS queue_type_30, t0.convention_id AS convention_id_31 FROM event t0 WHERE t0.id = ?
Parameters:
[
  2207
]
13 0.79 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.enabled AS enabled_4, t0.location AS location_5, t0.currency AS currency_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.logo AS logo_9, t0.background AS background_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.country AS country_13, t0.timezone AS timezone_14, t0.public AS public_15, t0.game AS game_16, t0.flags AS flags_17, t0.tax_rate_id AS tax_rate_id_18 FROM convention t0 WHERE t0.id = ?
Parameters:
[
  58
]
14 0.77 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.maximum AS maximum_3, t0.data AS data_4, t0.is_complete AS is_complete_5, t0.starting_table AS starting_table_6, t0.state AS state_7, t0.event_id AS event_id_8 FROM tournament_queue t0 WHERE t0.id = ?
Parameters:
[
  67
]
15 0.67 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.user_id AS user_id_3, t0.ticket_id AS ticket_id_4 FROM user_ticket t0 WHERE t0.user_id = ?
Parameters:
[
  32920
]
16 0.49 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.data AS data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.checked_in AS checked_in_6, t0.notes AS notes_7, t0.redeemed_prize AS redeemed_prize_8, t0.tags AS tags_9, t0.user_id AS user_id_10, t0.event_id AS event_id_11, t0.tournament_queue_id AS tournament_queue_id_12, t0.payment_user_id AS payment_user_id_13 FROM registration t0 WHERE t0.user_id = ?
Parameters:
[
  32920
]
17 0.38 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.user_id AS user_id_3, t0.ticket_id AS ticket_id_4 FROM user_ticket t0 WHERE t0.user_id = ?
Parameters:
[
  34777
]
18 0.48 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.data AS data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.checked_in AS checked_in_6, t0.notes AS notes_7, t0.redeemed_prize AS redeemed_prize_8, t0.tags AS tags_9, t0.user_id AS user_id_10, t0.event_id AS event_id_11, t0.tournament_queue_id AS tournament_queue_id_12, t0.payment_user_id AS payment_user_id_13 FROM registration t0 WHERE t0.user_id = ?
Parameters:
[
  34777
]
19 0.46 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.user_id AS user_id_3, t0.ticket_id AS ticket_id_4 FROM user_ticket t0 WHERE t0.user_id = ?
Parameters:
[
  35010
]
20 0.44 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.data AS data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.checked_in AS checked_in_6, t0.notes AS notes_7, t0.redeemed_prize AS redeemed_prize_8, t0.tags AS tags_9, t0.user_id AS user_id_10, t0.event_id AS event_id_11, t0.tournament_queue_id AS tournament_queue_id_12, t0.payment_user_id AS payment_user_id_13 FROM registration t0 WHERE t0.user_id = ?
Parameters:
[
  35010
]
21 0.58 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.flags AS flags_7, t0.starts_at AS starts_at_8, t0.registration_fee AS registration_fee_9, t0.max_registration AS max_registration_10, t0.team_size AS team_size_11, t0.registration_open_at AS registration_open_at_12, t0.registration_closed_at AS registration_closed_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.format AS format_16, t0.game AS game_17, t0.tags AS tags_18, t0.prizes AS prizes_19, t0.required_data AS required_data_20, t0.player_note AS player_note_21, t0.public AS public_22, t0.starting_table AS starting_table_23, t0.additional_metadata AS additional_metadata_24, t0.event_timer AS event_timer_25, t0.event_color AS event_color_26, t0.external_registration_url AS external_registration_url_27, t0.featured AS featured_28, t0.image AS image_29, t0.queue_type AS queue_type_30, t0.convention_id AS convention_id_31 FROM event t0 WHERE t0.id = ?
Parameters:
[
  1999
]
22 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.enabled AS enabled_4, t0.location AS location_5, t0.currency AS currency_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.logo AS logo_9, t0.background AS background_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.country AS country_13, t0.timezone AS timezone_14, t0.public AS public_15, t0.game AS game_16, t0.flags AS flags_17, t0.tax_rate_id AS tax_rate_id_18 FROM convention t0 WHERE t0.id = ?
Parameters:
[
  54
]
23 0.43 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.user_id AS user_id_3, t0.ticket_id AS ticket_id_4 FROM user_ticket t0 WHERE t0.user_id = ?
Parameters:
[
  35064
]
24 0.42 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.data AS data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.checked_in AS checked_in_6, t0.notes AS notes_7, t0.redeemed_prize AS redeemed_prize_8, t0.tags AS tags_9, t0.user_id AS user_id_10, t0.event_id AS event_id_11, t0.tournament_queue_id AS tournament_queue_id_12, t0.payment_user_id AS payment_user_id_13 FROM registration t0 WHERE t0.user_id = ?
Parameters:
[
  35064
]

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\Entity\User 5
App\Entity\UserRelation 4
App\Entity\Registration 2
App\Entity\Event 2
App\Entity\Convention 2
App\Entity\TournamentQueue 1
App\Entity\TaxRate 1