POST https://axium.identity.optimumci.com/api/oauth/token

Query Metrics

36 Database Queries
12 Different statements
16.25 ms Query time
0 Invalid entities
65 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.58 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3, t0.name AS name_4, t0.description AS description_5, t0.active AS active_6, t0.slug AS slug_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM app_client t0 WHERE t0.client_id = ? LIMIT 1
Parameters:
[
  "3d665544-f341-43c1-a93d-d035ac52fd39"
]
2 1.31 ms
SELECT u0_.id AS id_0, u0_.keycloak_id AS keycloak_id_1, u0_.email AS email_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.phone AS phone_5, u0_.active AS active_6, u0_.refresh_token AS refresh_token_7, u0_.uuid AS uuid_8, u0_.avatar AS avatar_9, u0_.signature AS signature_10, u0_.stamp AS stamp_11, u0_.username AS username_12, u0_.slug AS slug_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.company_id AS company_id_16 FROM `user` u0_ WHERE u0_.keycloak_id = ? OR u0_.username = ?
Parameters:
[
  ""
  "byao"
]
3 1.20 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3, t0.name AS name_4, t0.description AS description_5, t0.active AS active_6, t0.slug AS slug_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM app_client t0 INNER JOIN user_app_clients ON t0.id = user_app_clients.app_client_id WHERE user_app_clients.user_id = ?
Parameters:
[
  2
]
4 0.50 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.client_id AS client_id_3, t0.name AS name_4, t0.description AS description_5, t0.active AS active_6, t0.slug AS slug_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM app_client t0 WHERE t0.client_id = ? LIMIT 1
Parameters:
[
  "3d665544-f341-43c1-a93d-d035ac52fd39"
]
5 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM role t0 INNER JOIN app_client_roles ON t0.id = app_client_roles.role_id WHERE app_client_roles.app_client_id = ?
Parameters:
[
  5
]
6 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM role t0 INNER JOIN user_roles ON t0.id = user_roles.role_id WHERE user_roles.user_id = ?
Parameters:
[
  2
]
7 0.62 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.permission_id AS permission_id_5, t0.role_id AS role_id_6, t0.app_client_id AS app_client_id_7 FROM permission_role t0 WHERE t0.role_id = ?
Parameters:
[
  1
]
8 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  121
]
9 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  122
]
10 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  106
]
11 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  90
]
12 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  128
]
13 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  1
]
14 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  26
]
15 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  43
]
16 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  39
]
17 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  40
]
18 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  38
]
19 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  91
]
20 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  92
]
21 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  93
]
22 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  94
]
23 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  44
]
24 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  45
]
25 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  101
]
26 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  102
]
27 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  103
]
28 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  104
]
29 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  42
]
30 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  95
]
31 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  18
]
32 0.40 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.email AS email_4, t0.phone AS phone_5, t0.active AS active_6, t0.stamp AS stamp_7, t0.slug AS slug_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM company t0 WHERE t0.id = ?
Parameters:
[
  1
]
33 0.78 ms
"START TRANSACTION"
Parameters:
[]
34 0.54 ms
SELECT u0_.slug AS slug_0 FROM `user` u0_ WHERE u0_.slug LIKE ?
Parameters:
[
  "benjamin-yao%"
]
35 0.76 ms
UPDATE `user` SET refresh_token = ?, slug = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3OTQ1OTM5NjQsImV4cCI6MTc5NzE4NTk2NCwic3ViIjoiMDFhMTg2ZTktOWQyNi03ZTg2LTllOTctN2MxZjU0M2U0ZWQxIiwidHlwZSI6InJlZnJlc2giLCJhY2kiOiIzZDY2NTU0NC1mMzQxLTQzYzEtYTkzZC1kMDM1YWM1MmZkMzkifQ.cMMNNajI9U_R7dcguMy2HeZTGaXtdpjQ4sTEfHGhP4UJLa5Qf7mirO1bQhFPLX26TLZZ-gaWOqpIfE5gi8u8_wTaOf2d9IrDCCkNdDS4Ifj20rttfSnLQ7d294EQt5K7LvRpJ1jSvrwOGer0dAVGTVsrBR5486kELa3q1i6MFFEhzl3ULpKvFA3UU-vBL1RTdeIx5XnFPQ75_lA6epnBleNH34VmyNb6E-3rpcyGpj09rQKe_Xil6l82uj62TIyrILyP7qkN2CoHSVJAnSPLBDpr14Ic_C2DV0STlziyD5OAEzPLHwFXr8lFjMnfdfThhxYlSemEJUSlyHhpMXXchQ"
  "benjamin-yao"
  "2026-11-13 18:19:24"
  2
]
36 2.51 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\PermissionRole 24
App\Entity\Permission 24
App\Entity\Role 10
App\Entity\AppClient 5
App\Entity\User 1
App\Entity\Company 1

Entities Mapping

Class Mapping errors
App\Entity\AppClient No errors.
App\Entity\Role No errors.
App\Entity\User No errors.
App\Entity\PermissionRole No errors.
App\Entity\Company No errors.
App\Entity\Permission No errors.