GET https://frankie.thurston.pw/api/player?id=76561199609363574

Query Metrics

4 Database Queries
4 Different statements
2.57 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
1 0.84 ms
SELECT t0.id AS id_1, t0.steam_id AS steam_id_2, t0.username AS username_3, t0.avatar AS avatar_4, t0.email AS email_5, t0.roles AS roles_6, t0.discord_id AS discord_id_7, t0.discord_username AS discord_username_8, t0.created_at AS created_at_9, t0.checkout_blocked AS checkout_blocked_10 FROM `user` t0 WHERE t0.steam_id = ? LIMIT 1
Parameters:
[
  "76561199609363574"
]
2 0.52 ms
SELECT t0.id AS id_1, t0.member_rank AS member_rank_2, t0.joined_at AS joined_at_3, t0.faction_id AS faction_id_4, t0.user_id AS user_id_5 FROM faction_member t0 WHERE t0.user_id = ?
Parameters:
[
  2
]
3 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.description AS description_4, t0.motd AS motd_5, t0.icon_path AS icon_path_6, t0.asset_paths AS asset_paths_7, t0.status AS status_8, t0.is_system AS is_system_9, t0.discord_role_id AS discord_role_id_10, t0.discord_category_id AS discord_category_id_11, t0.discord_general_channel_id AS discord_general_channel_id_12, t0.discord_officer_channel_id AS discord_officer_channel_id_13, t0.rejection_reason AS rejection_reason_14, t0.created_at AS created_at_15, t0.approved_at AS approved_at_16, t0.discord_faction_pending_message_id AS discord_faction_pending_message_id_17, t0.discord_faction_approved_message_id AS discord_faction_approved_message_id_18, t0.is_recruiting AS is_recruiting_19, t0.leader_id AS leader_id_20, t0.game_role_id AS game_role_id_21, t0.approved_by_id AS approved_by_id_22 FROM faction t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.color AS color_4, t0.is_system_role AS is_system_role_5, t0.priority AS priority_6, t0.created_at AS created_at_7 FROM role t0 WHERE t0.id = ?
Parameters:
[
  2
]

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 1
App\Entity\FactionMember 1
App\Entity\Faction 1
App\Entity\Role 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Role No errors.
App\Entity\Order No errors.
App\Entity\FactionMember No errors.
App\Entity\Faction No errors.