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 = 'xf034f27f3-f0dcf9a178-30339a4416-1d95396647-68d40cfb13';

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

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

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 = 2574 AND c0_.instance_id = 49;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.instance_id AS instance_id_3
FROM
  organisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.instance_id AS instance_id_3 FROM organisateur t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.dbname AS dbname_3,
  t0.host AS host_4,
  t0.password AS password_5,
  t0.dbuser AS dbuser_6,
  t0.site AS site_7,
  t0.allow_sync_commande AS allow_sync_commande_8
FROM
  instance t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.dbname AS dbname_3, t0.host AS host_4, t0.password AS password_5, t0.dbuser AS dbuser_6, t0.site AS site_7, t0.allow_sync_commande AS allow_sync_commande_8 FROM instance t0 WHERE t0.id = 3;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO commande (
  hash_value, execute, status, commande_id,
  allow_execute, sejour_id, instance_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO commande (hash_value, execute, status, commande_id, allow_execute, sejour_id, instance_id) VALUES ('{\"depart\":\"2026-07-052026-07-1817\",\"etat\":1,\"sejour\":\"268\",\"commentaire\":\"d41d8cd98f00b204e9800998ecf8427e\",\"option_echeance\":null,\"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\",\"Attestation d\'assurance maladie ou CMU en cours de validit\\u00e9 durant le s\\u00e9jour\",\"Charte du participant \\u00e0 accepter et signer\"],\"produitannexes\":[],\"commrepreparti\":[{\"parti\":\"KANDULALana2010-06-30\",\"repre\":\"HOME DES FLANDRESflocon@homedesflandres.fr\",\"options\":[],\"formalites\":[\"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\",\"Attestation d\'assurance maladie ou CMU en cours de validit\\u00e9 durant le s\\u00e9jour\",\"Charte du participant \\u00e0 accepter et signer\"]}]}', 0, 'NEW', 2574, 1, 268, 49);

"COMMIT"

"COMMIT";

"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 11:57:00', '/api/commande', 'POST', '10.42.95.235', 'xf034f27f3-f0dcf9a178-30339a4416-1d95396647-68d40cfb13', 1, 'commande', NULL, 'a:2:{s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}', 0, NULL, NULL, NULL, 99);

"COMMIT"

"COMMIT";