| 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"
]
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 = '3d665544-f341-43c1-a93d-d035ac52fd39' LIMIT 1;
|
| 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"
]
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 = '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 = ?
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 = 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"
]
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 = '3d665544-f341-43c1-a93d-d035ac52fd39' LIMIT 1;
|
| 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 1;
|
| 33 |
0.78 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 34 |
0.54 ms |
SELECT u0_.slug AS slug_0 FROM `user` u0_ WHERE u0_.slug LIKE ?
Parameters: [
"benjamin-yao%"
]
SELECT u0_.slug AS slug_0 FROM `user` u0_ WHERE u0_.slug LIKE '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
]
UPDATE `user` SET refresh_token = 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3OTQ1OTM5NjQsImV4cCI6MTc5NzE4NTk2NCwic3ViIjoiMDFhMTg2ZTktOWQyNi03ZTg2LTllOTctN2MxZjU0M2U0ZWQxIiwidHlwZSI6InJlZnJlc2giLCJhY2kiOiIzZDY2NTU0NC1mMzQxLTQzYzEtYTkzZC1kMDM1YWM1MmZkMzkifQ.cMMNNajI9U_R7dcguMy2HeZTGaXtdpjQ4sTEfHGhP4UJLa5Qf7mirO1bQhFPLX26TLZZ-gaWOqpIfE5gi8u8_wTaOf2d9IrDCCkNdDS4Ifj20rttfSnLQ7d294EQt5K7LvRpJ1jSvrwOGer0dAVGTVsrBR5486kELa3q1i6MFFEhzl3ULpKvFA3UU-vBL1RTdeIx5XnFPQ75_lA6epnBleNH34VmyNb6E-3rpcyGpj09rQKe_Xil6l82uj62TIyrILyP7qkN2CoHSVJAnSPLBDpr14Ic_C2DV0STlziyD5OAEzPLHwFXr8lFjMnfdfThhxYlSemEJUSlyHhpMXXchQ', slug = 'benjamin-yao', updated_at = '2026-11-13 18:19:24' WHERE id = 2;
|
| 36 |
2.51 ms |
"COMMIT"
|