5.44 ms (37.08%)
|
2 |
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.secret_hash AS secret_hash_3, t0.name AS name_4, t0.grant_types AS grant_types_5, t0.allowed_scopes AS allowed_scopes_6, t0.redirect_uris AS redirect_uris_7, t0.is_confidential AS is_confidential_8, t0.is_revoked AS is_revoked_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.device_id AS device_id_12 FROM oauth_client t0 WHERE t0.identifier = ? AND t0.is_revoked = ? LIMIT 1
Parameters: [
"59d9fe08dddbc916"
0
]
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.secret_hash AS secret_hash_3, t0.name AS name_4, t0.grant_types AS grant_types_5, t0.allowed_scopes AS allowed_scopes_6, t0.redirect_uris AS redirect_uris_7, t0.is_confidential AS is_confidential_8, t0.is_revoked AS is_revoked_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.device_id AS device_id_12 FROM oauth_client t0 WHERE t0.identifier = '59d9fe08dddbc916' AND t0.is_revoked = 0 LIMIT 1;
|
4.27 ms (29.11%)
|
1 |
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.name AS name_3, t0.avatar_name AS avatar_name_4, t0.status AS status_5, t0.paired_at AS paired_at_6, t0.geolocation_enabled AS geolocation_enabled_7, t0.is_enabled AS is_enabled_8, t0.internet_enabled AS internet_enabled_9, t0.curfew_start AS curfew_start_10, t0.curfew_end AS curfew_end_11, t0.config_version AS config_version_12, t0.installed_config_version AS installed_config_version_13, t0.last_seen_at AS last_seen_at_14, t0.fcm_token AS fcm_token_15, t0.fcm_token_updated_at AS fcm_token_updated_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.parent_id AS parent_id_19, t0.dns_provider_id AS dns_provider_id_20, t21.id AS id_22, t21.operator AS operator_23, t21.service_name AS service_name_24, t21.descriptions AS descriptions_25, t21.primary_address AS primary_address_26, t21.secondary_address AS secondary_address_27, t21.information_url AS information_url_28, t21.created_at AS created_at_29, t21.updated_at AS updated_at_30 FROM device t0 LEFT JOIN dns_provider t21 ON t0.dns_provider_id = t21.id WHERE t0.id = ?
Parameters: [
"019fb7de-9fa8-7912-a9af-bb0ca572e0c1"
]
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.name AS name_3, t0.avatar_name AS avatar_name_4, t0.status AS status_5, t0.paired_at AS paired_at_6, t0.geolocation_enabled AS geolocation_enabled_7, t0.is_enabled AS is_enabled_8, t0.internet_enabled AS internet_enabled_9, t0.curfew_start AS curfew_start_10, t0.curfew_end AS curfew_end_11, t0.config_version AS config_version_12, t0.installed_config_version AS installed_config_version_13, t0.last_seen_at AS last_seen_at_14, t0.fcm_token AS fcm_token_15, t0.fcm_token_updated_at AS fcm_token_updated_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.parent_id AS parent_id_19, t0.dns_provider_id AS dns_provider_id_20, t21.id AS id_22, t21.operator AS operator_23, t21.service_name AS service_name_24, t21.descriptions AS descriptions_25, t21.primary_address AS primary_address_26, t21.secondary_address AS secondary_address_27, t21.information_url AS information_url_28, t21.created_at AS created_at_29, t21.updated_at AS updated_at_30 FROM device t0 LEFT JOIN dns_provider t21 ON t0.dns_provider_id = t21.id WHERE t0.id = '019fb7de-9fa8-7912-a9af-bb0ca572e0c1';
|
2.86 ms (19.48%)
|
1 |
INSERT INTO oauth_access_token (id, identifier, user_identifier, scopes, expires_at, is_revoked, client_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: [
"01a08de1-056b-772b-876d-145d57c0a368"
"d66ab73c401a9e3775b5420ec8002335b861165204c9d5f2b3bf444cfab19b696927ecfe70721ad9"
null
"["device:runtime"]"
"2026-09-11 02:47:09"
0
"019fb7de-a07d-77b8-82ae-79094c83a5b0"
]
INSERT INTO oauth_access_token (id, identifier, user_identifier, scopes, expires_at, is_revoked, client_id) VALUES ('01a08de1-056b-772b-876d-145d57c0a368', 'd66ab73c401a9e3775b5420ec8002335b861165204c9d5f2b3bf444cfab19b696927ecfe70721ad9', NULL, '[\"device:runtime\"]', '2026-09-11 02:47:09', 0, '019fb7de-a07d-77b8-82ae-79094c83a5b0');
|