POST https://test.forca.run/auth

Query Metrics

9 Database Queries
8 Different statements
8.82 ms Query time
0 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 1.53 ms
SELECT 
                au.*
            FROM app_user au
            WHERE au.email = :username
Parameters:
[
  "username" => "vedran.hudec@gmail.com"
]
2 0.88 ms
SELECT 
                r.name
            FROM app_user_roles r
            INNER JOIN app_assigned_user_roles ar ON ar.role_id = r.id AND ar.user_id = :user_id
Parameters:
[
  "user_id" => "97205913-94aa-46fc-aa35-1c50704edfd6"
]
3 0.48 ms
SELECT a.password FROM app_user 
            INNER JOIN app_user_auth a on app_user.id = a.user_id
            WHERE app_user.id = :user_id and app_user.is_locked = false
Parameters:
[
  "user_id" => "97205913-94aa-46fc-aa35-1c50704edfd6"
]
4 0.48 ms
SELECT 
                r.name
            FROM app_user_roles r
            INNER JOIN app_assigned_user_roles ar ON ar.role_id = r.id AND ar.user_id = :user_id
Parameters:
[
  "user_id" => "97205913-94aa-46fc-aa35-1c50704edfd6"
]
5 0.60 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 app_refresh_token t0 WHERE t0.refresh_token = ? LIMIT 1
Parameters:
[
  "bc362025d0317a371451d426c2954640a3540db9a6386a2649e2a81eb57ed05a968b5c09b468520cf7a5ba6477426cc29e768740c40718c228de6212e06d77d5"
]
6 2.17 ms
SELECT NEXTVAL('app_refresh_token_id_seq')
Parameters:
[]
7 0.15 ms
"START TRANSACTION"
Parameters:
[]
8 0.57 ms
INSERT INTO app_refresh_token (refresh_token, username, valid, id) VALUES (?, ?, ?, ?)
Parameters:
[
  "bc362025d0317a371451d426c2954640a3540db9a6386a2649e2a81eb57ed05a968b5c09b468520cf7a5ba6477426cc29e768740c40718c228de6212e06d77d5"
  "vedran.hudec@gmail.com"
  "2026-09-18 15:15:27"
  2202
]
9 1.96 ms
"COMMIT"
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\RefreshToken 1

Entities Mapping