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 = 1;

"COMMIT"

"COMMIT";

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 = 'c788a396-4d73-43a0-9fb3-a51e39cd42d4' LIMIT 1;

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

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 = 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
  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 = 55;

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

UPDATE `user` SET refresh_token = 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3OTQ1OTM2ODAsImV4cCI6MTc5NzE4NTY4MCwic3ViIjoiMDFhMDg2YmUtZTFkZC03ZDUzLTk0MzAtMTk2ZGIwYjBhODUzIiwidHlwZSI6InJlZnJlc2giLCJhY2kiOiJjNzg4YTM5Ni00ZDczLTQzYTAtOWZiMy1hNTFlMzljZDQyZDQifQ.fMKEVvjDW69G3obVtKsRYxj4EgtQsnTXfa6ro-Nscnmey4MMPjwtuUiuOTL0INKZ5SqBrS-xRkZUiUJDbKNkMREMoJC9sADT6wCQkG-hiRsCxYSNEkP7oX-IDIGaOmCAOapigPHSrNCSSy_gaLcodp1rsbmOrmkHh-tIHlPM13sQGffjgbnDM8SMLZpWaLPgfFDDQDamH9eNjKHPal32G9uEp8JP4_srZv_nbE0cnldjpRg7QUR6aSgOZ_TX9ITRdCCAMGQDMrYbcf41OqAhzZaJlp_-liS7bNTlD-AwO9T1d8d-6V6rshph9JzSVTnOlRyzC67LBXY4jsvLZlUJ3w', slug = 'allou-yao-1', updated_at = '2026-11-13 18:14:40' WHERE id = 55;

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 = 2;

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 'allou-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 = 55;

"START TRANSACTION"

"START TRANSACTION";