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 = 'az984g27e3-f0dcf9b978-31339a4416-1d95396647-78d40cfb13';

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

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

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

SELECT
  count(p0_.id) AS sclr_0
FROM
  partage_sejour_alert p0_
  INNER JOIN organisateur o1_ ON p0_.organisateur_id = o1_.id
  INNER JOIN instance i2_ ON p0_.origin_instance_id = i2_.id
WHERE
  p0_.dest_instance_id = ?
  AND p0_.readed = 0

SELECT count(p0_.id) AS sclr_0 FROM partage_sejour_alert p0_ INNER JOIN organisateur o1_ ON p0_.organisateur_id = o1_.id INNER JOIN instance i2_ ON p0_.origin_instance_id = i2_.id WHERE p0_.dest_instance_id = 51 AND p0_.readed = 0;

SELECT
  count(p0_.id) AS sclr_0
FROM
  partage_sejour_alert p0_
  INNER JOIN organisateur o1_ ON p0_.organisateur_id = o1_.id
  INNER JOIN instance i2_ ON p0_.origin_instance_id = i2_.id
WHERE
  p0_.dest_instance_id = ?
  AND p0_.readed = 0

SELECT count(p0_.id) AS sclr_0 FROM partage_sejour_alert p0_ INNER JOIN organisateur o1_ ON p0_.organisateur_id = o1_.id INNER JOIN instance i2_ ON p0_.origin_instance_id = i2_.id WHERE p0_.dest_instance_id = 51 AND p0_.readed = 0;

SELECT
  o0_.nom AS nom_0,
  p1_.sujet AS sujet_1,
  i2_.name AS name_2,
  p1_.message AS message_3,
  DATE_FORMAT (
    p1_.date_create, '%d/%m/%Y %h:%i:%s'
  ) AS sclr_4,
  p1_.id AS id_5
FROM
  partage_sejour_alert p1_
  INNER JOIN organisateur o0_ ON p1_.organisateur_id = o0_.id
  INNER JOIN instance i2_ ON p1_.origin_instance_id = i2_.id
WHERE
  p1_.dest_instance_id = ?
  AND p1_.readed = 0
LIMIT
  10

SELECT o0_.nom AS nom_0, p1_.sujet AS sujet_1, i2_.name AS name_2, p1_.message AS message_3, DATE_FORMAT (p1_.date_create,'%d/%m/%Y %h:%i:%s') AS sclr_4, p1_.id AS id_5 FROM partage_sejour_alert p1_ INNER JOIN organisateur o0_ ON p1_.organisateur_id = o0_.id INNER JOIN instance i2_ ON p1_.origin_instance_id = i2_.id WHERE p1_.dest_instance_id = 51 AND p1_.readed = 0 LIMIT 10;

"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:33:24', '/api/partageSejourAlert?method=alert&length=10&start=0&alldisplay=0', 'GET', '10.42.154.147', 'az984g27e3-f0dcf9b978-31339a4416-1d95396647-78d40cfb13', 1, 'partageSejourAlert', NULL, 'a:2:{s:3:\"get\";a:4:{s:6:\"method\";s:5:\"alert\";s:6:\"length\";s:2:\"10\";s:5:\"start\";s:1:\"0\";s:10:\"alldisplay\";s:1:\"0\";}s:4:\"post\";a:0:{}}', 0, NULL, NULL, NULL, 101);

"COMMIT"

"COMMIT";