| 1 |
4.69 ms |
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.is_confidential AS is_confidential_7, t0.is_revoked AS is_revoked_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.device_id AS device_id_11 FROM oauth_client t0 WHERE t0.identifier = ? AND t0.is_revoked = ? LIMIT 1
Parameters: [
"neow-parent-app"
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.is_confidential AS is_confidential_7, t0.is_revoked AS is_revoked_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.device_id AS device_id_11 FROM oauth_client t0 WHERE t0.identifier = 'neow-parent-app' AND t0.is_revoked = 0 LIMIT 1;
|
| 2 |
1.28 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.is_email_verified AS is_email_verified_5, t0.is_active AS is_active_6, t0.failed_login_attempts AS failed_login_attempts_7, t0.locked_until AS locked_until_8, t0.pending_email AS pending_email_9, t0.pending_email_requested_at AS pending_email_requested_at_10, t0.scheduled_for_deletion_at AS scheduled_for_deletion_at_11, t0.age_verified_at AS age_verified_at_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM "user" t0 WHERE t0.email = ? LIMIT 1
Parameters: [
"jonathan@neopixl.com"
]
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.is_email_verified AS is_email_verified_5, t0.is_active AS is_active_6, t0.failed_login_attempts AS failed_login_attempts_7, t0.locked_until AS locked_until_8, t0.pending_email AS pending_email_9, t0.pending_email_requested_at AS pending_email_requested_at_10, t0.scheduled_for_deletion_at AS scheduled_for_deletion_at_11, t0.age_verified_at AS age_verified_at_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM "user" t0 WHERE t0.email = 'jonathan@neopixl.com' LIMIT 1;
|
| 3 |
3.59 ms |
SELECT m0_.id AS id_0, m0_.code_hash AS code_hash_1, m0_.expires_at AS expires_at_2, m0_.attempts AS attempts_3, m0_.is_used AS is_used_4, m0_.created_at AS created_at_5, m0_.last_sent_at AS last_sent_at_6, m0_.user_id AS user_id_7 FROM mfa_challenge m0_ WHERE m0_.user_id = ? AND m0_.is_used = false AND m0_.expires_at > ? ORDER BY m0_.created_at DESC LIMIT 1
SELECT m0_.id AS id_0, m0_.code_hash AS code_hash_1, m0_.expires_at AS expires_at_2, m0_.attempts AS attempts_3, m0_.is_used AS is_used_4, m0_.created_at AS created_at_5, m0_.last_sent_at AS last_sent_at_6, m0_.user_id AS user_id_7 FROM mfa_challenge m0_ WHERE m0_.user_id = '019e1fdf-3da9-71cb-b195-c6c4c6513e7f' AND m0_.is_used = false AND m0_.expires_at > '2026-06-12 09:48:42' ORDER BY m0_.created_at DESC LIMIT 1;
|
| 4 |
0.14 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 5 |
1.80 ms |
INSERT INTO security_event (id, event_type, ip_address, user_agent, details, created_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: [
"019ebacd-fc53-7e85-b21e-97797971e500"
"mfa_success"
"88.188.104.86"
"ktor-client"
"[]"
"2026-06-12 09:48:42"
"019e1fdf-3da9-71cb-b195-c6c4c6513e7f"
]
INSERT INTO security_event (id, event_type, ip_address, user_agent, details, created_at, user_id) VALUES ('019ebacd-fc53-7e85-b21e-97797971e500', 'mfa_success', '88.188.104.86', 'ktor-client', '[]', '2026-06-12 09:48:42', '019e1fdf-3da9-71cb-b195-c6c4c6513e7f');
|
| 6 |
0.38 ms |
UPDATE mfa_challenge SET is_used = ? WHERE id = ?
Parameters: [
1
"019ebacd-c731-7532-844c-43a757fba125"
]
UPDATE mfa_challenge SET is_used = 1 WHERE id = '019ebacd-c731-7532-844c-43a757fba125';
|
| 7 |
0.58 ms |
"COMMIT"
|
| 8 |
0.08 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 9 |
0.24 ms |
INSERT INTO security_event (id, event_type, ip_address, user_agent, details, created_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: [
"019ebacd-fc58-7079-930a-ad2e352e5f8e"
"login_success"
"88.188.104.86"
"ktor-client"
null
"2026-06-12 09:48:42"
"019e1fdf-3da9-71cb-b195-c6c4c6513e7f"
]
INSERT INTO security_event (id, event_type, ip_address, user_agent, details, created_at, user_id) VALUES ('019ebacd-fc58-7079-930a-ad2e352e5f8e', 'login_success', '88.188.104.86', 'ktor-client', NULL, '2026-06-12 09:48:42', '019e1fdf-3da9-71cb-b195-c6c4c6513e7f');
|
| 10 |
0.40 ms |
"COMMIT"
|
| 11 |
0.14 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 12 |
7.08 ms |
INSERT INTO oauth_access_token (id, identifier, user_identifier, scopes, expires_at, is_revoked, client_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: [
"019ebacd-fc5b-73d3-bc9c-15d498d9b969"
"908df6106de4057d4fc9990963bbbcec4f68b6e5461514fe50d649f52b6c669fbf79d8b56e06c88f"
"019e1fdf-3da9-71cb-b195-c6c4c6513e7f"
"["parent"]"
"2026-06-12 10:03:42"
0
"019da900-0000-7000-8000-000000000090"
]
INSERT INTO oauth_access_token (id, identifier, user_identifier, scopes, expires_at, is_revoked, client_id) VALUES ('019ebacd-fc5b-73d3-bc9c-15d498d9b969', '908df6106de4057d4fc9990963bbbcec4f68b6e5461514fe50d649f52b6c669fbf79d8b56e06c88f', '019e1fdf-3da9-71cb-b195-c6c4c6513e7f', '[\"parent\"]', '2026-06-12 10:03:42', 0, '019da900-0000-7000-8000-000000000090');
|
| 13 |
1.47 ms |
"COMMIT"
|
| 14 |
2.74 ms |
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.expires_at AS expires_at_5, t0.is_revoked AS is_revoked_6, t0.client_id AS client_id_7 FROM oauth_access_token t0 WHERE t0.identifier = ? LIMIT 1
Parameters: [
"908df6106de4057d4fc9990963bbbcec4f68b6e5461514fe50d649f52b6c669fbf79d8b56e06c88f"
]
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.expires_at AS expires_at_5, t0.is_revoked AS is_revoked_6, t0.client_id AS client_id_7 FROM oauth_access_token t0 WHERE t0.identifier = '908df6106de4057d4fc9990963bbbcec4f68b6e5461514fe50d649f52b6c669fbf79d8b56e06c88f' LIMIT 1;
|
| 15 |
0.12 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 16 |
4.12 ms |
INSERT INTO oauth_refresh_token (id, identifier, expires_at, is_revoked, access_token_id) VALUES (?, ?, ?, ?, ?)
Parameters: [
"019ebacd-fc69-7c77-8166-56b4117736ab"
"5e6e40a1ff53600062f02d31aa8d47bcdc885cecd98782b116ef50e34848019ef0e69809a45498fe"
"2026-06-19 09:48:42"
0
"019ebacd-fc5b-73d3-bc9c-15d498d9b969"
]
INSERT INTO oauth_refresh_token (id, identifier, expires_at, is_revoked, access_token_id) VALUES ('019ebacd-fc69-7c77-8166-56b4117736ab', '5e6e40a1ff53600062f02d31aa8d47bcdc885cecd98782b116ef50e34848019ef0e69809a45498fe', '2026-06-19 09:48:42', 0, '019ebacd-fc5b-73d3-bc9c-15d498d9b969');
|
| 17 |
1.48 ms |
"COMMIT"
|