Symfony Profiler

"COMMIT"

"COMMIT";

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 = 'e71e147395-c57aab05e2-19623b479b-534c467c6f-bcac50c40e';

SELECT
  c0_.id AS id_0,
  c0_.hash_value AS hash_value_1,
  c0_.execute AS execute_2,
  c0_.status AS status_3,
  c0_.commande_id AS commande_id_4,
  c0_.allow_execute AS allow_execute_5,
  c0_.sejour_id AS sejour_id_6,
  c0_.instance_id AS instance_id_7
FROM
  commande c0_
WHERE
  c0_.commande_id = ?
  AND c0_.instance_id = ?

SELECT c0_.id AS id_0, c0_.hash_value AS hash_value_1, c0_.execute AS execute_2, c0_.status AS status_3, c0_.commande_id AS commande_id_4, c0_.allow_execute AS allow_execute_5, c0_.sejour_id AS sejour_id_6, c0_.instance_id AS instance_id_7 FROM commande c0_ WHERE c0_.commande_id = 14839 AND c0_.instance_id = 21;

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

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;

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-03 21:45:06', '/api/commande', 'POST', '10.42.158.133', 'e71e147395-c57aab05e2-19623b479b-534c467c6f-bcac50c40e', 1, 'commande', NULL, 'a:2:{s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}', 0, NULL, NULL, NULL, 63);

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;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  commande
SET
  hash_value = ?,
  execute = ?,
  status = ?
WHERE
  id = ?

UPDATE commande SET hash_value = '{\"depart\":\"2026-08-022026-08-0822\",\"etat\":5,\"sejour\":\"20\",\"commentaire\":\"d41d8cd98f00b204e9800998ecf8427e\",\"option_echeance\":\"2026-04-02\",\"formalite\":[\"Fiche Sanitaire\",\"Attestation m\\u00e9dicale des vaccinations ou copie du carnet de vaccination\",\"Attestation CMU ou PUMA en cours de validit\\u00e9\",\"Certificat m\\u00e9dical\"],\"produitannexes\":[{\"libelle\":\"Option Annulation\",\"prix\":41.200000000000003}],\"commrepreparti\":[{\"parti\":\"MOUNACTimoth\\u00e92011-08-22\",\"repre\":\"MOUNACSt\\u00e9phaniemounac.st@hotmail.com\",\"options\":[\"1 journ\\u00e9e au FUTUROSCOPE\"],\"formalites\":[]}]}', execute = 0, status = 'UPDATE' WHERE id = 9712;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.organisateur_id AS organisateur_id_3,
  t0.destination_id AS destination_id_4
FROM
  sejour t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.organisateur_id AS organisateur_id_3, t0.destination_id AS destination_id_4 FROM sejour t0 WHERE t0.id = '20';