POST https://api.astro-otter.space/auth

Query Metrics

6 Database Queries
6 Different statements
7.73 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.77 ms
(35.90%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5 FROM api_user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "anonymous@astro-otter.space"
]
2.19 ms
(28.30%)
1
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:
[
  "dc611ff426cf40f6855c8d3f35a360df4008af5bc7afb0a0861966b82891a505cb4fe46fc9e85640cd04a9903fbe685d2b07d017213208539fa683ca500ab985"
]
1.26 ms
(16.26%)
1
SELECT NEXTVAL('refresh_tokens_id_seq')
Parameters:
[]
0.68 ms
(8.77%)
1
INSERT INTO refresh_tokens (refresh_token, username, valid, id) VALUES (?, ?, ?, ?)
Parameters:
[
  "dc611ff426cf40f6855c8d3f35a360df4008af5bc7afb0a0861966b82891a505cb4fe46fc9e85640cd04a9903fbe685d2b07d017213208539fa683ca500ab985"
  "anonymous@astro-otter.space"
  "2026-05-02 20:27:01"
  27480
]
0.64 ms
(8.26%)
1
"COMMIT"
Parameters:
[]
0.19 ms
(2.52%)
1
"START TRANSACTION"
Parameters:
[]

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.

Entities Mapping