Symfony Profiler

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;

"COMMIT"

"COMMIT";

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 = ?

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';

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;

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

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;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  `user`
SET
  refresh_token = ?,
  slug = ?,
  updated_at = ?
WHERE
  id = ?

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;

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;

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;

SELECT
  u0_.slug AS slug_0
FROM
  `user` u0_
WHERE
  u0_.slug LIKE ?

SELECT u0_.slug AS slug_0 FROM `user` u0_ WHERE u0_.slug LIKE 'benjamin-yao%';

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;

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;