POST https://api.madex.mg/api/v1/otp/request/verify/d5afdbb17552aed24d3efcdefb568936c7997f52c722dc8c2940586280361353

Query Metrics

9 Database Queries
9 Different statements
7.91 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
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"
]
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"
]
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"
]
4 0.96 ms
"START TRANSACTION"
Parameters:
[]
5 1.09 ms
INSERT INTO refresh_tokens (refresh_token, username, valid) VALUES (?, ?, ?)
Parameters:
[
  "1b2284c0c980c60fba4851f2208670ac92461c7c213d8cf62a652b0e1f41dcbffa4285a999d110869a6001c0fafebdfc71d0022c631b301bd7059fb569944606"
  "340000001"
  "2026-10-08 13:35:43"
]
6 0.75 ms
UPDATE otp_request SET is_verified = ? WHERE id = ?
Parameters:
[
  1
  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
]
8 0.74 ms
"COMMIT"
Parameters:
[]
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 = ?
Parameters:
[
  2
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\OtpRequest 1
App\Entity\Utilisateur 1
App\Entity\UtilisateurRole 1
App\Entity\RefreshToken 1

Entities Mapping