Query Metrics
4
Database Queries
4
Different statements
2.57 ms
Query time
0
Invalid entities
4
Managed entities
Queries
| #▲ | 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. |