Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.token AS token_1,
  a0_.expires_at AS expires_at_2,
  a0_.user_id AS user_id_3
FROM
  api_token a0_
WHERE
  a0_.token = ?

SELECT a0_.id AS id_0, a0_.token AS token_1, a0_.expires_at AS expires_at_2, a0_.user_id AS user_id_3 FROM api_token a0_ WHERE a0_.token = 'ef034f27f3-f0dcf9a178-30339a4416-1d95196647-62d40cfb13';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.username AS username_4,
  t0.email AS email_5,
  t0.password AS password_6,
  t0.salt AS salt_7,
  t0.last_link_requested_at AS last_link_requested_at_8,
  t0.instance_id AS instance_id_9,
  t0.role_group_id AS role_group_id_10
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.username AS username_4, t0.email AS email_5, t0.password AS password_6, t0.salt AS salt_7, t0.last_link_requested_at AS last_link_requested_at_8, t0.instance_id AS instance_id_9, t0.role_group_id AS role_group_id_10 FROM user t0 WHERE t0.id = 57;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.rolename AS rolename_3
FROM
  role_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.rolename AS rolename_3 FROM role_group t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.module AS module_3
FROM
  role t0
  INNER JOIN role_role_group ON t0.id = role_role_group.role_id
WHERE
  role_role_group.role_group_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.module AS module_3 FROM role t0 INNER JOIN role_role_group ON t0.id = role_role_group.role_id WHERE role_role_group.role_group_id = 1;

SELECT
  i0_.name AS name_0,
  i0_.site AS site_1
FROM
  sejour s1_
  INNER JOIN organisateur o2_ ON s1_.organisateur_id = o2_.id
  INNER JOIN instance i0_ ON o2_.instance_id = i0_.id
WHERE
  s1_.id = ?
ORDER BY
  i0_.name ASC

SELECT i0_.name AS name_0, i0_.site AS site_1 FROM sejour s1_ INNER JOIN organisateur o2_ ON s1_.organisateur_id = o2_.id INNER JOIN instance i0_ ON o2_.instance_id = i0_.id WHERE s1_.id = '8' ORDER BY i0_.name ASC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO api_logs (
  date_time, url, method, request_ip,
  api_key, authenticated, ressource,
  ressource_id, params, has_exception,
  exception_class, exception_message,
  exception_code, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO api_logs (date_time, url, method, request_ip, api_key, authenticated, ressource, ressource_id, params, has_exception, exception_class, exception_message, exception_code, user_id) VALUES ('2026-04-01 09:01:42', '/api/instance?getInstanceBySejour=8', 'GET', '10.42.158.175', 'ef034f27f3-f0dcf9a178-30339a4416-1d95196647-62d40cfb13', 1, 'instance', NULL, 'a:2:{s:3:\"get\";a:1:{s:19:\"getInstanceBySejour\";s:1:\"8\";}s:4:\"post\";a:0:{}}', 0, NULL, NULL, NULL, 57);

"COMMIT"

"COMMIT";