5.54 ms (27.58%)
|
1 |
INSERT INTO security_event (id, event_type, ip_address, user_agent, details, created_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: [
"019ebacd-c733-733a-ac10-46186718b0e4"
"mfa_code_sent"
"88.188.104.86"
"ktor-client"
"[]"
"2026-06-12 09:48:28"
"019e1fdf-3da9-71cb-b195-c6c4c6513e7f"
]
INSERT INTO security_event (id, event_type, ip_address, user_agent, details, created_at, user_id) VALUES ('019ebacd-c733-733a-ac10-46186718b0e4', 'mfa_code_sent', '88.188.104.86', 'ktor-client', '[]', '2026-06-12 09:48:28', '019e1fdf-3da9-71cb-b195-c6c4c6513e7f');
|
4.57 ms (22.78%)
|
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 = ? 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:28' ORDER BY m0_.created_at DESC LIMIT 1;
|
4.30 ms (21.40%)
|
1 |
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.31 ms (11.53%)
|
1 |
INSERT INTO mfa_challenge (id, code_hash, expires_at, attempts, is_used, created_at, last_sent_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
"019ebacd-c731-7532-844c-43a757fba125"
"549fb9ea411f828857e740b2862761252954f335f10ce19a7da5f14b7c5e440c"
"2026-06-12 09:58:28"
0
0
"2026-06-12 09:48:28"
"2026-06-12 09:48:28"
"019e1fdf-3da9-71cb-b195-c6c4c6513e7f"
]
INSERT INTO mfa_challenge (id, code_hash, expires_at, attempts, is_used, created_at, last_sent_at, user_id) VALUES ('019ebacd-c731-7532-844c-43a757fba125', '549fb9ea411f828857e740b2862761252954f335f10ce19a7da5f14b7c5e440c', '2026-06-12 09:58:28', 0, 0, '2026-06-12 09:48:28', '2026-06-12 09:48:28', '019e1fdf-3da9-71cb-b195-c6c4c6513e7f');
|
1.71 ms (8.51%)
|
1 |
"COMMIT"
|
1.19 ms (5.95%)
|
1 |
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;
|
0.34 ms (1.68%)
|
1 |
UPDATE mfa_challenge SET is_used = true WHERE user_id = ? AND is_used = false
UPDATE mfa_challenge SET is_used = true WHERE user_id = '019e1fdf-3da9-71cb-b195-c6c4c6513e7f' AND is_used = false;
|
0.11 ms (0.56%)
|
1 |
"START TRANSACTION"
"START TRANSACTION";
|