https://back.dotoast.com/api/v2/apple/membership/by-receipt

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

Show all queries

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