| 1 |
0.89 ms
|
SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.otp_code AS otp_code_4, t0.token AS token_5, t0.created_at AS created_at_6, t0.expires_at AS expires_at_7, t0.is_verified AS is_verified_8, t0.attempt AS attempt_9 FROM otp_request t0 WHERE t0.token = ? LIMIT 1
Parameters: [
"d5afdbb17552aed24d3efcdefb568936c7997f52c722dc8c2940586280361353"
]
SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.otp_code AS otp_code_4, t0.token AS token_5, t0.created_at AS created_at_6, t0.expires_at AS expires_at_7, t0.is_verified AS is_verified_8, t0.attempt AS attempt_9 FROM otp_request t0 WHERE t0.token = 'd5afdbb17552aed24d3efcdefb568936c7997f52c722dc8c2940586280361353' LIMIT 1;
|
| 2 |
0.92 ms
|
SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.last_connection_at AS last_connection_at_9, t0.last_activity_at AS last_activity_at_10, t0.utilisateur_role_id AS utilisateur_role_id_11 FROM utilisateur t0 WHERE t0.username = ? LIMIT 1
Parameters: [
"340000001"
]
SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.last_connection_at AS last_connection_at_9, t0.last_activity_at AS last_activity_at_10, t0.utilisateur_role_id AS utilisateur_role_id_11 FROM utilisateur t0 WHERE t0.username = '340000001' LIMIT 1;
|
| 3 |
0.88 ms
|
SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = ? LIMIT 1
Parameters: [
"1b2284c0c980c60fba4851f2208670ac92461c7c213d8cf62a652b0e1f41dcbffa4285a999d110869a6001c0fafebdfc71d0022c631b301bd7059fb569944606"
]
SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = '1b2284c0c980c60fba4851f2208670ac92461c7c213d8cf62a652b0e1f41dcbffa4285a999d110869a6001c0fafebdfc71d0022c631b301bd7059fb569944606' LIMIT 1;
|
| 4 |
0.96 ms
|
"START TRANSACTION"
"START TRANSACTION";
|
| 5 |
1.09 ms
|
INSERT INTO refresh_tokens (refresh_token, username, valid) VALUES (?, ?, ?)
Parameters: [
"1b2284c0c980c60fba4851f2208670ac92461c7c213d8cf62a652b0e1f41dcbffa4285a999d110869a6001c0fafebdfc71d0022c631b301bd7059fb569944606"
"340000001"
"2026-10-08 13:35:43"
]
INSERT INTO refresh_tokens (refresh_token, username, valid) VALUES ('1b2284c0c980c60fba4851f2208670ac92461c7c213d8cf62a652b0e1f41dcbffa4285a999d110869a6001c0fafebdfc71d0022c631b301bd7059fb569944606', '340000001', '2026-10-08 13:35:43');
|
| 6 |
0.75 ms
|
UPDATE otp_request SET is_verified = ? WHERE id = ?
UPDATE otp_request SET is_verified = 1 WHERE id = 7;
|
| 7 |
0.75 ms
|
UPDATE utilisateur SET last_connection_at = ?, updated_at = ? WHERE id = ?
Parameters: [
"2026-09-08 13:35:43"
"2026-09-08 13:35:43"
2
]
UPDATE utilisateur SET last_connection_at = '2026-09-08 13:35:43', updated_at = '2026-09-08 13:35:43' WHERE id = 2;
|
| 8 |
0.74 ms
|
"COMMIT"
|
| 9 |
0.94 ms
|
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM utilisateur_role t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM utilisateur_role t0 WHERE t0.id = 2;
|