Query Metrics
10
Database Queries
10
Different statements
1.07 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
0.26 ms (24.24%) |
1 |
UPDATE user SET last_activity = ? WHERE id = ?
Parameters:
[ "2025-08-12" "957256226360716" ] |
0.14 ms (13.57%) |
1 |
SELECT t0.token AS token_1, t0.expires_at AS expires_at_2, t0.id AS id_3, t0.user_id AS user_id_4 FROM user_access_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
"752b2bd91878bf758f9cc35db60c4aefed095363fef84087"
]
|
0.11 ms (10.40%) |
1 |
"START TRANSACTION"
Parameters:
[] |
0.10 ms (9.73%) |
1 |
SELECT t0.receipt AS receipt_1, t0.sign_in_sub AS sign_in_sub_2, t0.transaction_id AS transaction_id_3, t0.original_transaction_id AS original_transaction_id_4, t0.id AS id_5, t6.password AS password_7, t6.username AS username_8, t6.roles AS roles_9, t6.user_agent AS user_agent_10, t6.are_notifications_enabled AS are_notifications_enabled_11, t6.not_registered_token AS not_registered_token_12, t6.migrated_from_not_registered AS migrated_from_not_registered_13, t6.migrate_code AS migrate_code_14, t6.last_activity AS last_activity_15, t6.id AS id_16, t6.creation_date AS creation_date_17, t6.apple_data_id AS apple_data_id_18, t6.membership_id AS membership_id_19, t6.avatar_id AS avatar_id_20, t6.profile_id AS profile_id_21, t6.stripe_member_id AS stripe_member_id_22 FROM user_apple_data t0 LEFT JOIN user t6 ON t6.apple_data_id = t0.id WHERE t0.id = ?
Parameters:
[
"311856357623119"
]
|
0.09 ms (8.53%) |
1 |
"COMMIT"
Parameters:
[] |
0.08 ms (7.41%) |
1 |
SELECT t0.name AS name_1, t0.browser_id AS browser_id_2, t0.is_enabled AS is_enabled_3, t0.share_slug AS share_slug_4, t0.enabled_for_collaboration AS enabled_for_collaboration_5, t0.emoji AS emoji_6, t0.id AS id_7, t0.creation_date AS creation_date_8, t0.order_index AS order_index_9, t0.user_id AS user_id_10, t0.section_id AS section_id_11 FROM toast_session t0 WHERE t0.is_enabled = ?
Parameters:
[
0
]
|
0.08 ms (7.30%) |
1 |
SELECT t0.email AS email_1, t0.email_confirmed AS email_confirmed_2, t0.registration_type AS registration_type_3, t0.name AS name_4, t0.surname AS surname_5, t0.profession AS profession_6, t0.id AS id_7 FROM user_profile t0 WHERE t0.id = ?
Parameters:
[
"195070210225886"
]
|
0.07 ms (7.01%) |
1 |
SELECT t0.password AS password_1, t0.username AS username_2, t0.roles AS roles_3, t0.user_agent AS user_agent_4, t0.are_notifications_enabled AS are_notifications_enabled_5, t0.not_registered_token AS not_registered_token_6, t0.migrated_from_not_registered AS migrated_from_not_registered_7, t0.migrate_code AS migrate_code_8, t0.last_activity AS last_activity_9, t0.id AS id_10, t0.creation_date AS creation_date_11, t0.apple_data_id AS apple_data_id_12, t0.membership_id AS membership_id_13, t0.avatar_id AS avatar_id_14, t0.profile_id AS profile_id_15, t0.stripe_member_id AS stripe_member_id_16 FROM user t0 WHERE t0.id = ?
Parameters:
[
"957256226360716"
]
|
0.06 ms (6.00%) |
1 |
SELECT t0.asset_path AS asset_path_1, t0.url AS url_2, t0.id AS id_3 FROM user_avatar t0 WHERE t0.id = ?
Parameters:
[
"523111394225072"
]
|
0.06 ms (5.80%) |
1 |
SELECT t0.premium_expires AS premium_expires_1, t0.subscription_type AS subscription_type_2, t0.allowed_trial AS allowed_trial_3, t0.cancelled_subscription AS cancelled_subscription_4, t0.id AS id_5 FROM user_membership t0 WHERE t0.id = ?
Parameters:
[
"407097339216915"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
remote | doctrine.dbal.remote_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Entities Mapping
Class | Mapping errors |
---|---|
App\Database\Domain\Entity\AbstractEntity | No errors. |
App\Database\Domain\Entity\User\UserAccessToken | No errors. |
App\Database\Domain\Entity\User\User | No errors. |
App\Database\Domain\Entity\User\UserAppleData | No errors. |
App\Database\Domain\Entity\User\UserMembership | No errors. |
App\Database\Domain\Entity\User\UserAvatar | No errors. |
App\Database\Domain\Entity\User\UserProfile | No errors. |
App\Database\Domain\Entity\User\UserStripeMember | No errors. |
App\Database\Domain\Entity\User\UserNotification | No errors. |
App\Database\Domain\Entity\Sessions\ToastSession | No errors. |
App\Database\Domain\Entity\Sessions\ToastSessionSection | No errors. |