Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM `user` t0 WHERE t0.id = 9;

SELECT
  COUNT(DISTINCT r0_.id) AS sclr_0
FROM
  `reservation` r0_
WHERE
  r0_.date_resa = ?

SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM `reservation` r0_ WHERE r0_.date_resa = '2026-04-17';

SELECT
  DISTINCT r0_.id AS id_0,
  r0_.lastname AS lastname_1
FROM
  `reservation` r0_
WHERE
  r0_.date_resa = ?
ORDER BY
  r0_.lastname ASC
LIMIT
  19

SELECT DISTINCT r0_.id AS id_0, r0_.lastname AS lastname_1 FROM `reservation` r0_ WHERE r0_.date_resa = '2026-04-17' ORDER BY r0_.lastname ASC LIMIT 19;

SELECT
  r0_.id AS id_0,
  r0_.customer_id AS customer_id_1,
  r0_.customer_number AS customer_number_2,
  r0_.formule AS formule_3,
  r0_.formule_code AS formule_code_4,
  r0_.firstname AS firstname_5,
  r0_.lastname AS lastname_6,
  r0_.company AS company_7,
  r0_.email AS email_8,
  r0_.phone AS phone_9,
  r0_.phone_mobile AS phone_mobile_10,
  r0_.billing_address AS billing_address_11,
  r0_.comment AS comment_12,
  r0_.date_add AS date_add_13,
  r0_.date_resa AS date_resa_14,
  r0_.numero_resa AS numero_resa_15,
  r0_.invoice_number AS invoice_number_16,
  r0_.sstotal_ht AS sstotal_ht_17,
  r0_.tva AS tva_18,
  r0_.total_ttc AS total_ttc_19,
  r0_.history AS history_20,
  r0_.date_upd AS date_upd_21,
  r0_.statut AS statut_22,
  r0_.active AS active_23,
  r0_.confirmation AS confirmation_24,
  r0_.deleted AS deleted_25,
  r0_.composted AS composted_26,
  r0_.ip AS ip_27,
  r0_.payment_id AS payment_id_28,
  r0_.child_name AS child_name_29,
  r0_.child_birthday AS child_birthday_30,
  r0_.child_age AS child_age_31,
  r0_.birthday_customer_comment AS birthday_customer_comment_32
FROM
  `reservation` r0_
WHERE
  r0_.date_resa = ?
  AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  r0_.lastname ASC

SELECT r0_.id AS id_0, r0_.customer_id AS customer_id_1, r0_.customer_number AS customer_number_2, r0_.formule AS formule_3, r0_.formule_code AS formule_code_4, r0_.firstname AS firstname_5, r0_.lastname AS lastname_6, r0_.company AS company_7, r0_.email AS email_8, r0_.phone AS phone_9, r0_.phone_mobile AS phone_mobile_10, r0_.billing_address AS billing_address_11, r0_.comment AS comment_12, r0_.date_add AS date_add_13, r0_.date_resa AS date_resa_14, r0_.numero_resa AS numero_resa_15, r0_.invoice_number AS invoice_number_16, r0_.sstotal_ht AS sstotal_ht_17, r0_.tva AS tva_18, r0_.total_ttc AS total_ttc_19, r0_.history AS history_20, r0_.date_upd AS date_upd_21, r0_.statut AS statut_22, r0_.active AS active_23, r0_.confirmation AS confirmation_24, r0_.deleted AS deleted_25, r0_.composted AS composted_26, r0_.ip AS ip_27, r0_.payment_id AS payment_id_28, r0_.child_name AS child_name_29, r0_.child_birthday AS child_birthday_30, r0_.child_age AS child_age_31, r0_.birthday_customer_comment AS birthday_customer_comment_32 FROM `reservation` r0_ WHERE r0_.date_resa = '2026-04-17' AND r0_.id IN (4759, 4748, 4790, 4775, 4382, 4310, 4787, 4327, 4758, 4794, 4784, 4792, 4786, 4780, 4785) ORDER BY r0_.lastname ASC;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4759;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4748;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4790;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4775;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4382;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4310;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4787;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4327;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4758;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4794;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4784;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4792;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4786;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4780;

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.date AS date_3,
  t0.information AS information_4,
  t0.mouvement AS mouvement_5,
  t0.reservation_id AS reservation_id_6
FROM
  `history` t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = 4785;