Symfony Profiler

"COMMIT"

"COMMIT";

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 = 31057 AND c0_.instance_id = 3;

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 = 'o56dfg9s6p-pfrtn58d63-utr5d8r669-0dpm56q3e7-8v5f2g6s48';

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

"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 16:22:20', '/api/commande', 'POST', '10.42.253.227', 'o56dfg9s6p-pfrtn58d63-utr5d8r669-0dpm56q3e7-8v5f2g6s48', 1, 'commande', NULL, 'a:2:{s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}', 0, NULL, NULL, NULL, 44);

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

UPDATE commande SET hash_value = '{\"depart\":\"2026-07-202026-07-2919\",\"etat\":5,\"sejour\":\"141\",\"commentaire\":\"d41d8cd98f00b204e9800998ecf8427e\",\"option_echeance\":\"2026-03-31\",\"formalite\":[\"Fiche Sanitaire et informations compl\\u00e9mentaires\",\"Attestation m\\u00e9dicale de vaccination \\u00e0 jour ou copie du carnet de vaccination avec NOM et PRENOM de l\'enfant\",\"Test pr\\u00e9alable aux activit\\u00e9s nautiques ou attestation scolaire savoir nager\",\"Carte d\'identit\\u00e9 ou passeport valide\",\"Autorisation de sortie du territoire\",\"Carte europ\\u00e9enne d\'assurance maladie\",\"Attestation d\'assurance maladie ou CMU en cours de validit\\u00e9 durant le s\\u00e9jour\",\"Photocopie ou scan recto\\/verso de la carte de votre Mutuelle\"],\"produitannexes\":[{\"libelle\":\"Frais de dossier\",\"prix\":20}],\"commrepreparti\":[{\"parti\":\"FLEURANT--DIOUFKahynna2010-08-21\",\"repre\":\"DIOUFNathalienathaliediouf@orange.fr\",\"options\":[],\"formalites\":[\"Test pr\\u00e9alable aux activit\\u00e9s nautiques ou attestation scolaire savoir nager\",\"Carte d\'identit\\u00e9 ou passeport valide\",\"Carte europ\\u00e9enne d\'assurance maladie\"]}]}', execute = 0 WHERE id = 9661;

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
  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.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 = '141';