Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.designation AS designation_1,
  c0_.type AS type_2,
  c0_.from_date AS from_date_3,
  c0_.to_date AS to_date_4,
  c0_.priority AS priority_5,
  c0_.activity_closed AS activity_closed_6,
  c0_.type AS type_7
FROM
  calendar c0_
WHERE
  c0_.from_date <= ?
  AND c0_.to_date > ?
  AND c0_.to_date > ?
ORDER BY
  c0_.priority ASC

SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.from_date AS from_date_3, c0_.to_date AS to_date_4, c0_.priority AS priority_5, c0_.activity_closed AS activity_closed_6, c0_.type AS type_7 FROM calendar c0_ WHERE c0_.from_date <= '2025-07-29 00:00:00' AND c0_.to_date > '2025-07-29 00:00:00' AND c0_.to_date > '2025-07-29 00:00:00' ORDER BY c0_.priority ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3,
  t0.mention AS mention_4,
  t0.mention_anniversaire AS mention_anniversaire_5,
  t0.url_activity AS url_activity_6,
  t0.temps_limite_resa AS temps_limite_resa_7,
  t0.jauge_mini AS jauge_mini_8,
  t0.jauge_maxi AS jauge_maxi_9,
  t0.temps_activite AS temps_activite_10,
  t0.presence_avant AS presence_avant_11,
  t0.espaces_jeu AS espaces_jeu_12,
  t0.is_creneau_activity AS is_creneau_activity_13,
  t0.is_tarification_multiple AS is_tarification_multiple_14,
  t0.heure_ouverture_creneau AS heure_ouverture_creneau_15,
  t0.heure_fermeture_creneau AS heure_fermeture_creneau_16,
  t0.temps_creneau AS temps_creneau_17,
  t0.creneau_obligatoire AS creneau_obligatoire_18,
  t0.block_room AS block_room_19,
  t0.is_draft AS is_draft_20,
  t0.billboard_type AS billboard_type_21,
  t0.espaces_jeu_reel AS espaces_jeu_reel_22,
  t0.jauge_maxi_reel AS jauge_maxi_reel_23,
  t0.temps_creneau_reel AS temps_creneau_reel_24,
  t0.ignored_creneau AS ignored_creneau_25,
  t0.temps_activite_joueur AS temps_activite_joueur_26
FROM
  activity t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.mention AS mention_4, t0.mention_anniversaire AS mention_anniversaire_5, t0.url_activity AS url_activity_6, t0.temps_limite_resa AS temps_limite_resa_7, t0.jauge_mini AS jauge_mini_8, t0.jauge_maxi AS jauge_maxi_9, t0.temps_activite AS temps_activite_10, t0.presence_avant AS presence_avant_11, t0.espaces_jeu AS espaces_jeu_12, t0.is_creneau_activity AS is_creneau_activity_13, t0.is_tarification_multiple AS is_tarification_multiple_14, t0.heure_ouverture_creneau AS heure_ouverture_creneau_15, t0.heure_fermeture_creneau AS heure_fermeture_creneau_16, t0.temps_creneau AS temps_creneau_17, t0.creneau_obligatoire AS creneau_obligatoire_18, t0.block_room AS block_room_19, t0.is_draft AS is_draft_20, t0.billboard_type AS billboard_type_21, t0.espaces_jeu_reel AS espaces_jeu_reel_22, t0.jauge_maxi_reel AS jauge_maxi_reel_23, t0.temps_creneau_reel AS temps_creneau_reel_24, t0.ignored_creneau AS ignored_creneau_25, t0.temps_activite_joueur AS temps_activite_joueur_26 FROM activity t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.code_activity AS code_activity_2,
  t0.date AS date_3,
  t0.slot_unavailable AS slot_unavailable_4
FROM
  activity_unavailable_slot t0
WHERE
  t0.date = ?
  AND t0.code_activity = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code_activity AS code_activity_2, t0.date AS date_3, t0.slot_unavailable AS slot_unavailable_4 FROM activity_unavailable_slot t0 WHERE t0.date = '2025-07-29 00:00:00' AND t0.code_activity = 'laser-game' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.day AS day_2,
  t0.opening_time AS opening_time_3,
  t0.closing_time AS closing_time_4,
  t0.is_holidays AS is_holidays_5,
  t0.is_public_holiday AS is_public_holiday_6,
  t0.activity_id AS activity_id_7
FROM
  opening_days t0
WHERE
  t0.activity_id = ?

SELECT t0.id AS id_1, t0.day AS day_2, t0.opening_time AS opening_time_3, t0.closing_time AS closing_time_4, t0.is_holidays AS is_holidays_5, t0.is_public_holiday AS is_public_holiday_6, t0.activity_id AS activity_id_7 FROM opening_days t0 WHERE t0.activity_id = 4;

SELECT
  b0_.id AS id_0,
  b0_.designation AS designation_1,
  b0_.forfait AS forfait_2,
  b0_.formule AS formule_3,
  b0_.code_activity AS code_activity_4,
  b0_.date AS date_5,
  b0_.creneau AS creneau_6,
  b0_.nbre_parties AS nbre_parties_7,
  b0_.quantity AS quantity_8,
  b0_.pu_ttc AS pu_ttc_9,
  b0_.taux_tva AS taux_tva_10,
  b0_.total_ht AS total_ht_11,
  b0_.montant_tva AS montant_tva_12,
  b0_.total_ttc AS total_ttc_13,
  b0_.admin AS admin_14,
  b0_.reservation_id AS reservation_id_15
FROM
  booked_activity b0_
WHERE
  b0_.code_activity = ?
  AND b0_.date = ?
  AND b0_.creneau = ?
ORDER BY
  b0_.id ASC

SELECT b0_.id AS id_0, b0_.designation AS designation_1, b0_.forfait AS forfait_2, b0_.formule AS formule_3, b0_.code_activity AS code_activity_4, b0_.date AS date_5, b0_.creneau AS creneau_6, b0_.nbre_parties AS nbre_parties_7, b0_.quantity AS quantity_8, b0_.pu_ttc AS pu_ttc_9, b0_.taux_tva AS taux_tva_10, b0_.total_ht AS total_ht_11, b0_.montant_tva AS montant_tva_12, b0_.total_ttc AS total_ttc_13, b0_.admin AS admin_14, b0_.reservation_id AS reservation_id_15 FROM booked_activity b0_ WHERE b0_.code_activity = 'laser-game' AND b0_.date = '2025-07-29' AND b0_.creneau = '10:00:00' ORDER BY b0_.id ASC;

SELECT
  o0_.id AS id_0,
  o0_.designation AS designation_1,
  o0_.code_activity AS code_activity_2,
  o0_.date AS date_3,
  o0_.creneau AS creneau_4,
  o0_.quantity AS quantity_5,
  o0_.nbre_parties AS nbre_parties_6,
  o0_.id_customer AS id_customer_7,
  o0_.shortname AS shortname_8,
  o0_.deleted AS deleted_9,
  o0_.is_unavailable AS is_unavailable_10
FROM
  operator_booking o0_
WHERE
  o0_.code_activity = ?
  AND o0_.date = ?
ORDER BY
  o0_.id ASC

SELECT o0_.id AS id_0, o0_.designation AS designation_1, o0_.code_activity AS code_activity_2, o0_.date AS date_3, o0_.creneau AS creneau_4, o0_.quantity AS quantity_5, o0_.nbre_parties AS nbre_parties_6, o0_.id_customer AS id_customer_7, o0_.shortname AS shortname_8, o0_.deleted AS deleted_9, o0_.is_unavailable AS is_unavailable_10 FROM operator_booking o0_ WHERE o0_.code_activity = 'laser-game' AND o0_.date = '2025-07-29' ORDER BY o0_.id ASC;

SELECT
  c0_.id AS id_0,
  c0_.designation AS designation_1,
  c0_.type AS type_2,
  c0_.from_date AS from_date_3,
  c0_.to_date AS to_date_4,
  c0_.priority AS priority_5,
  c0_.activity_closed AS activity_closed_6,
  c0_.designation AS designation_7,
  c0_.from_date AS from_date_8,
  c0_.to_date AS to_date_9
FROM
  calendar c0_
WHERE
  c0_.to_date >= ?
  AND (
    c0_.type = ?
    OR c0_.type = ?
  )
ORDER BY
  c0_.priority ASC

SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.from_date AS from_date_3, c0_.to_date AS to_date_4, c0_.priority AS priority_5, c0_.activity_closed AS activity_closed_6, c0_.designation AS designation_7, c0_.from_date AS from_date_8, c0_.to_date AS to_date_9 FROM calendar c0_ WHERE c0_.to_date >= '2025-07-04 01:16:34' AND (c0_.type = 'fermeture' OR c0_.type = 'indisponible') ORDER BY c0_.priority ASC;

SELECT
  c0_.id AS id_0,
  c0_.designation AS designation_1,
  c0_.type AS type_2,
  c0_.from_date AS from_date_3,
  c0_.to_date AS to_date_4,
  c0_.priority AS priority_5,
  c0_.activity_closed AS activity_closed_6,
  c0_.type AS type_7
FROM
  calendar c0_
WHERE
  c0_.from_date <= ?
  AND c0_.to_date > ?
  AND c0_.to_date > ?
ORDER BY
  c0_.priority ASC

SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.from_date AS from_date_3, c0_.to_date AS to_date_4, c0_.priority AS priority_5, c0_.activity_closed AS activity_closed_6, c0_.type AS type_7 FROM calendar c0_ WHERE c0_.from_date <= '2025-07-29' AND c0_.to_date > '2025-07-29' AND c0_.to_date > '2025-07-29' ORDER BY c0_.priority ASC;

SELECT
  p0_.id AS id_0,
  p0_.designation AS designation_1,
  p0_.information AS information_2,
  p0_.heure_debut AS heure_debut_3,
  p0_.heure_fin AS heure_fin_4,
  p0_.jours AS jours_5,
  p0_.nbre_parties AS nbre_parties_6,
  p0_.date_debut AS date_debut_7,
  p0_.date_fin AS date_fin_8,
  p0_.type_reduction AS type_reduction_9,
  p0_.price_ttc AS price_ttc_10,
  p0_.percent AS percent_11,
  p0_.priority AS priority_12,
  p0_.id AS id_13,
  p0_.forfait_id AS forfait_id_14,
  p0_.groupby_id AS groupby_id_15
FROM
  promos p0_
WHERE
  p0_.forfait_id = ?
  AND p0_.jours LIKE ?
  AND (
    p0_.date_debut <= ?
    OR p0_.date_debut IS NULL
  )
  AND (
    p0_.date_fin > ?
    OR p0_.date_fin IS NULL
  )
  AND (
    p0_.heure_debut <= ?
    OR p0_.heure_debut IS NULL
  )
  AND (
    p0_.heure_fin > ?
    OR p0_.heure_fin IS NULL
  )

SELECT p0_.id AS id_0, p0_.designation AS designation_1, p0_.information AS information_2, p0_.heure_debut AS heure_debut_3, p0_.heure_fin AS heure_fin_4, p0_.jours AS jours_5, p0_.nbre_parties AS nbre_parties_6, p0_.date_debut AS date_debut_7, p0_.date_fin AS date_fin_8, p0_.type_reduction AS type_reduction_9, p0_.price_ttc AS price_ttc_10, p0_.percent AS percent_11, p0_.priority AS priority_12, p0_.id AS id_13, p0_.forfait_id AS forfait_id_14, p0_.groupby_id AS groupby_id_15 FROM promos p0_ WHERE p0_.forfait_id = 18 AND p0_.jours LIKE '%vacances%' AND (p0_.date_debut <= '2025-07-29 00:00:00' OR p0_.date_debut IS NULL) AND (p0_.date_fin > '2025-07-29 00:00:00' OR p0_.date_fin IS NULL) AND (p0_.heure_debut <= '10:00:00' OR p0_.heure_debut IS NULL) AND (p0_.heure_fin > '10:00:00' OR p0_.heure_fin IS NULL);

SELECT
  b0_.id AS id_0,
  b0_.designation AS designation_1,
  b0_.forfait AS forfait_2,
  b0_.formule AS formule_3,
  b0_.code_activity AS code_activity_4,
  b0_.date AS date_5,
  b0_.creneau AS creneau_6,
  b0_.nbre_parties AS nbre_parties_7,
  b0_.quantity AS quantity_8,
  b0_.pu_ttc AS pu_ttc_9,
  b0_.taux_tva AS taux_tva_10,
  b0_.total_ht AS total_ht_11,
  b0_.montant_tva AS montant_tva_12,
  b0_.total_ttc AS total_ttc_13,
  b0_.admin AS admin_14,
  b0_.reservation_id AS reservation_id_15
FROM
  booked_activity b0_
WHERE
  b0_.code_activity = ?
  AND b0_.date = ?
  AND b0_.creneau = ?
ORDER BY
  b0_.id ASC

SELECT b0_.id AS id_0, b0_.designation AS designation_1, b0_.forfait AS forfait_2, b0_.formule AS formule_3, b0_.code_activity AS code_activity_4, b0_.date AS date_5, b0_.creneau AS creneau_6, b0_.nbre_parties AS nbre_parties_7, b0_.quantity AS quantity_8, b0_.pu_ttc AS pu_ttc_9, b0_.taux_tva AS taux_tva_10, b0_.total_ht AS total_ht_11, b0_.montant_tva AS montant_tva_12, b0_.total_ttc AS total_ttc_13, b0_.admin AS admin_14, b0_.reservation_id AS reservation_id_15 FROM booked_activity b0_ WHERE b0_.code_activity = 'laser-game' AND b0_.date = '2025-07-29' AND b0_.creneau = '10:30:00' ORDER BY b0_.id ASC;

SELECT
  o0_.id AS id_0,
  o0_.designation AS designation_1,
  o0_.code_activity AS code_activity_2,
  o0_.date AS date_3,
  o0_.creneau AS creneau_4,
  o0_.quantity AS quantity_5,
  o0_.nbre_parties AS nbre_parties_6,
  o0_.id_customer AS id_customer_7,
  o0_.shortname AS shortname_8,
  o0_.deleted AS deleted_9,
  o0_.is_unavailable AS is_unavailable_10
FROM
  operator_booking o0_
WHERE
  o0_.code_activity = ?
  AND o0_.date = ?
ORDER BY
  o0_.id ASC

SELECT o0_.id AS id_0, o0_.designation AS designation_1, o0_.code_activity AS code_activity_2, o0_.date AS date_3, o0_.creneau AS creneau_4, o0_.quantity AS quantity_5, o0_.nbre_parties AS nbre_parties_6, o0_.id_customer AS id_customer_7, o0_.shortname AS shortname_8, o0_.deleted AS deleted_9, o0_.is_unavailable AS is_unavailable_10 FROM operator_booking o0_ WHERE o0_.code_activity = 'laser-game' AND o0_.date = '2025-07-29' ORDER BY o0_.id ASC;

SELECT
  c0_.id AS id_0,
  c0_.designation AS designation_1,
  c0_.type AS type_2,
  c0_.from_date AS from_date_3,
  c0_.to_date AS to_date_4,
  c0_.priority AS priority_5,
  c0_.activity_closed AS activity_closed_6,
  c0_.designation AS designation_7,
  c0_.from_date AS from_date_8,
  c0_.to_date AS to_date_9
FROM
  calendar c0_
WHERE
  c0_.to_date >= ?
  AND (
    c0_.type = ?
    OR c0_.type = ?
  )
ORDER BY
  c0_.priority ASC

SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.from_date AS from_date_3, c0_.to_date AS to_date_4, c0_.priority AS priority_5, c0_.activity_closed AS activity_closed_6, c0_.designation AS designation_7, c0_.from_date AS from_date_8, c0_.to_date AS to_date_9 FROM calendar c0_ WHERE c0_.to_date >= '2025-07-04 01:16:34' AND (c0_.type = 'fermeture' OR c0_.type = 'indisponible') ORDER BY c0_.priority ASC;

SELECT
  c0_.id AS id_0,
  c0_.designation AS designation_1,
  c0_.type AS type_2,
  c0_.from_date AS from_date_3,
  c0_.to_date AS to_date_4,
  c0_.priority AS priority_5,
  c0_.activity_closed AS activity_closed_6,
  c0_.type AS type_7
FROM
  calendar c0_
WHERE
  c0_.from_date <= ?
  AND c0_.to_date > ?
  AND c0_.to_date > ?
ORDER BY
  c0_.priority ASC

SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.from_date AS from_date_3, c0_.to_date AS to_date_4, c0_.priority AS priority_5, c0_.activity_closed AS activity_closed_6, c0_.type AS type_7 FROM calendar c0_ WHERE c0_.from_date <= '2025-07-29' AND c0_.to_date > '2025-07-29' AND c0_.to_date > '2025-07-29' ORDER BY c0_.priority ASC;

SELECT
  p0_.id AS id_0,
  p0_.designation AS designation_1,
  p0_.information AS information_2,
  p0_.heure_debut AS heure_debut_3,
  p0_.heure_fin AS heure_fin_4,
  p0_.jours AS jours_5,
  p0_.nbre_parties AS nbre_parties_6,
  p0_.date_debut AS date_debut_7,
  p0_.date_fin AS date_fin_8,
  p0_.type_reduction AS type_reduction_9,
  p0_.price_ttc AS price_ttc_10,
  p0_.percent AS percent_11,
  p0_.priority AS priority_12,
  p0_.id AS id_13,
  p0_.forfait_id AS forfait_id_14,
  p0_.groupby_id AS groupby_id_15
FROM
  promos p0_
WHERE
  p0_.forfait_id = ?
  AND p0_.jours LIKE ?
  AND (
    p0_.date_debut <= ?
    OR p0_.date_debut IS NULL
  )
  AND (
    p0_.date_fin > ?
    OR p0_.date_fin IS NULL
  )
  AND (
    p0_.heure_debut <= ?
    OR p0_.heure_debut IS NULL
  )
  AND (
    p0_.heure_fin > ?
    OR p0_.heure_fin IS NULL
  )

SELECT p0_.id AS id_0, p0_.designation AS designation_1, p0_.information AS information_2, p0_.heure_debut AS heure_debut_3, p0_.heure_fin AS heure_fin_4, p0_.jours AS jours_5, p0_.nbre_parties AS nbre_parties_6, p0_.date_debut AS date_debut_7, p0_.date_fin AS date_fin_8, p0_.type_reduction AS type_reduction_9, p0_.price_ttc AS price_ttc_10, p0_.percent AS percent_11, p0_.priority AS priority_12, p0_.id AS id_13, p0_.forfait_id AS forfait_id_14, p0_.groupby_id AS groupby_id_15 FROM promos p0_ WHERE p0_.forfait_id = 18 AND p0_.jours LIKE '%vacances%' AND (p0_.date_debut <= '2025-07-29 00:00:00' OR p0_.date_debut IS NULL) AND (p0_.date_fin > '2025-07-29 00:00:00' OR p0_.date_fin IS NULL) AND (p0_.heure_debut <= '10:30:00' OR p0_.heure_debut IS NULL) AND (p0_.heure_fin > '10:30:00' OR p0_.heure_fin IS NULL);

SELECT
  b0_.id AS id_0,
  b0_.designation AS designation_1,
  b0_.forfait AS forfait_2,
  b0_.formule AS formule_3,
  b0_.code_activity AS code_activity_4,
  b0_.date AS date_5,
  b0_.creneau AS creneau_6,
  b0_.nbre_parties AS nbre_parties_7,
  b0_.quantity AS quantity_8,
  b0_.pu_ttc AS pu_ttc_9,
  b0_.taux_tva AS taux_tva_10,
  b0_.total_ht AS total_ht_11,
  b0_.montant_tva AS montant_tva_12,
  b0_.total_ttc AS total_ttc_13,
  b0_.admin AS admin_14,
  b0_.reservation_id AS reservation_id_15
FROM
  booked_activity b0_
WHERE
  b0_.code_activity = ?
  AND b0_.date = ?
  AND b0_.creneau = ?
ORDER BY
  b0_.id ASC

SELECT b0_.id AS id_0, b0_.designation AS designation_1, b0_.forfait AS forfait_2, b0_.formule AS formule_3, b0_.code_activity AS code_activity_4, b0_.date AS date_5, b0_.creneau AS creneau_6, b0_.nbre_parties AS nbre_parties_7, b0_.quantity AS quantity_8, b0_.pu_ttc AS pu_ttc_9, b0_.taux_tva AS taux_tva_10, b0_.total_ht AS total_ht_11, b0_.montant_tva AS montant_tva_12, b0_.total_ttc AS total_ttc_13, b0_.admin AS admin_14, b0_.reservation_id AS reservation_id_15 FROM booked_activity b0_ WHERE b0_.code_activity = 'laser-game' AND b0_.date = '2025-07-29' AND b0_.creneau = '11:00:00' ORDER BY b0_.id ASC;

SELECT
  o0_.id AS id_0,
  o0_.designation AS designation_1,
  o0_.code_activity AS code_activity_2,
  o0_.date AS date_3,
  o0_.creneau AS creneau_4,
  o0_.quantity AS quantity_5,
  o0_.nbre_parties AS nbre_parties_6,
  o0_.id_customer AS id_customer_7,
  o0_.shortname AS shortname_8,
  o0_.deleted AS deleted_9,
  o0_.is_unavailable AS is_unavailable_10
FROM
  operator_booking o0_
WHERE
  o0_.code_activity = ?
  AND o0_.date = ?
ORDER BY
  o0_.id ASC

SELECT o0_.id AS id_0, o0_.designation AS designation_1, o0_.code_activity AS code_activity_2, o0_.date AS date_3, o0_.creneau AS creneau_4, o0_.quantity AS quantity_5, o0_.nbre_parties AS nbre_parties_6, o0_.id_customer AS id_customer_7, o0_.shortname AS shortname_8, o0_.deleted AS deleted_9, o0_.is_unavailable AS is_unavailable_10 FROM operator_booking o0_ WHERE o0_.code_activity = 'laser-game' AND o0_.date = '2025-07-29' ORDER BY o0_.id ASC;

SELECT
  c0_.id AS id_0,
  c0_.designation AS designation_1,
  c0_.type AS type_2,
  c0_.from_date AS from_date_3,
  c0_.to_date AS to_date_4,
  c0_.priority AS priority_5,
  c0_.activity_closed AS activity_closed_6,
  c0_.designation AS designation_7,
  c0_.from_date AS from_date_8,
  c0_.to_date AS to_date_9
FROM
  calendar c0_
WHERE
  c0_.to_date >= ?
  AND (
    c0_.type = ?
    OR c0_.type = ?
  )
ORDER BY
  c0_.priority ASC

SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.from_date AS from_date_3, c0_.to_date AS to_date_4, c0_.priority AS priority_5, c0_.activity_closed AS activity_closed_6, c0_.designation AS designation_7, c0_.from_date AS from_date_8, c0_.to_date AS to_date_9 FROM calendar c0_ WHERE c0_.to_date >= '2025-07-04 01:16:34' AND (c0_.type = 'fermeture' OR c0_.type = 'indisponible') ORDER BY c0_.priority ASC;

SELECT
  c0_.id AS id_0,
  c0_.designation AS designation_1,
  c0_.type AS type_2,
  c0_.from_date AS from_date_3,
  c0_.to_date AS to_date_4,
  c0_.priority AS priority_5,
  c0_.activity_closed AS activity_closed_6,
  c0_.type AS type_7
FROM
  calendar c0_
WHERE
  c0_.from_date <= ?
  AND c0_.to_date > ?
  AND c0_.to_date > ?
ORDER BY
  c0_.priority ASC

SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.from_date AS from_date_3, c0_.to_date AS to_date_4, c0_.priority AS priority_5, c0_.activity_closed AS activity_closed_6, c0_.type AS type_7 FROM calendar c0_ WHERE c0_.from_date <= '2025-07-29' AND c0_.to_date > '2025-07-29' AND c0_.to_date > '2025-07-29' ORDER BY c0_.priority ASC;

SELECT
  p0_.id AS id_0,
  p0_.designation AS designation_1,
  p0_.information AS information_2,
  p0_.heure_debut AS heure_debut_3,
  p0_.heure_fin AS heure_fin_4,
  p0_.jours AS jours_5,
  p0_.nbre_parties AS nbre_parties_6,
  p0_.date_debut AS date_debut_7,
  p0_.date_fin AS date_fin_8,
  p0_.type_reduction AS type_reduction_9,
  p0_.price_ttc AS price_ttc_10,
  p0_.percent AS percent_11,
  p0_.priority AS priority_12,
  p0_.id AS id_13,
  p0_.forfait_id AS forfait_id_14,
  p0_.groupby_id AS groupby_id_15
FROM
  promos p0_
WHERE
  p0_.forfait_id = ?
  AND p0_.jours LIKE ?
  AND (
    p0_.date_debut <= ?
    OR p0_.date_debut IS NULL
  )
  AND (
    p0_.date_fin > ?
    OR p0_.date_fin IS NULL
  )
  AND (
    p0_.heure_debut <= ?
    OR p0_.heure_debut IS NULL
  )
  AND (
    p0_.heure_fin > ?
    OR p0_.heure_fin IS NULL
  )

SELECT p0_.id AS id_0, p0_.designation AS designation_1, p0_.information AS information_2, p0_.heure_debut AS heure_debut_3, p0_.heure_fin AS heure_fin_4, p0_.jours AS jours_5, p0_.nbre_parties AS nbre_parties_6, p0_.date_debut AS date_debut_7, p0_.date_fin AS date_fin_8, p0_.type_reduction AS type_reduction_9, p0_.price_ttc AS price_ttc_10, p0_.percent AS percent_11, p0_.priority AS priority_12, p0_.id AS id_13, p0_.forfait_id AS forfait_id_14, p0_.groupby_id AS groupby_id_15 FROM promos p0_ WHERE p0_.forfait_id = 18 AND p0_.jours LIKE '%vacances%' AND (p0_.date_debut <= '2025-07-29 00:00:00' OR p0_.date_debut IS NULL) AND (p0_.date_fin > '2025-07-29 00:00:00' OR p0_.date_fin IS NULL) AND (p0_.heure_debut <= '11:00:00' OR p0_.heure_debut IS NULL) AND (p0_.heure_fin > '11:00:00' OR p0_.heure_fin IS NULL);

SELECT
  b0_.id AS id_0,
  b0_.designation AS designation_1,
  b0_.forfait AS forfait_2,
  b0_.formule AS formule_3,
  b0_.code_activity AS code_activity_4,
  b0_.date AS date_5,
  b0_.creneau AS creneau_6,
  b0_.nbre_parties AS nbre_parties_7,
  b0_.quantity AS quantity_8,
  b0_.pu_ttc AS pu_ttc_9,
  b0_.taux_tva AS taux_tva_10,
  b0_.total_ht AS total_ht_11,
  b0_.montant_tva AS montant_tva_12,
  b0_.total_ttc AS total_ttc_13,
  b0_.admin AS admin_14,
  b0_.reservation_id AS reservation_id_15
FROM
  booked_activity b0_
WHERE
  b0_.code_activity = ?
  AND b0_.date = ?
  AND b0_.creneau = ?
ORDER BY
  b0_.id ASC

SELECT b0_.id AS id_0, b0_.designation AS designation_1, b0_.forfait AS forfait_2, b0_.formule AS formule_3, b0_.code_activity AS code_activity_4, b0_.date AS date_5, b0_.creneau AS creneau_6, b0_.nbre_parties AS nbre_parties_7, b0_.quantity AS quantity_8, b0_.pu_ttc AS pu_ttc_9, b0_.taux_tva AS taux_tva_10, b0_.total_ht AS total_ht_11, b0_.montant_tva AS montant_tva_12, b0_.total_ttc AS total_ttc_13, b0_.admin AS admin_14, b0_.reservation_id AS reservation_id_15 FROM booked_activity b0_ WHERE b0_.code_activity = 'laser-game' AND b0_.date = '2025-07-29' AND b0_.creneau = '11:30:00' ORDER BY b0_.id ASC;

SELECT
  o0_.id AS id_0,
  o0_.designation AS designation_1,
  o0_.code_activity AS code_activity_2,
  o0_.date AS date_3,
  o0_.creneau AS creneau_4,
  o0_.quantity AS quantity_5,
  o0_.nbre_parties AS nbre_parties_6,
  o0_.id_customer AS id_customer_7,
  o0_.shortname AS shortname_8,
  o0_.deleted AS deleted_9,
  o0_.is_unavailable AS is_unavailable_10
FROM
  operator_booking o0_
WHERE
  o0_.code_activity = ?
  AND o0_.date = ?
ORDER BY
  o0_.id ASC

SELECT o0_.id AS id_0, o0_.designation AS designation_1, o0_.code_activity AS code_activity_2, o0_.date AS date_3, o0_.creneau AS creneau_4, o0_.quantity AS quantity_5, o0_.nbre_parties AS nbre_parties_6, o0_.id_customer AS id_customer_7, o0_.shortname AS shortname_8, o0_.deleted AS deleted_9, o0_.is_unavailable AS is_unavailable_10 FROM operator_booking o0_ WHERE o0_.code_activity = 'laser-game' AND o0_.date = '2025-07-29' ORDER BY o0_.id ASC;

SELECT
  c0_.id AS id_0,
  c0_.designation AS designation_1,
  c0_.type AS type_2,
  c0_.from_date AS from_date_3,
  c0_.to_date AS to_date_4,
  c0_.priority AS priority_5,
  c0_.activity_closed AS activity_closed_6,
  c0_.designation AS designation_7,
  c0_.from_date AS from_date_8,
  c0_.to_date AS to_date_9
FROM
  calendar c0_
WHERE
  c0_.to_date >= ?
  AND (
    c0_.type = ?
    OR c0_.type = ?
  )
ORDER BY
  c0_.priority ASC

SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.from_date AS from_date_3, c0_.to_date AS to_date_4, c0_.priority AS priority_5, c0_.activity_closed AS activity_closed_6, c0_.designation AS designation_7, c0_.from_date AS from_date_8, c0_.to_date AS to_date_9 FROM calendar c0_ WHERE c0_.to_date >= '2025-07-04 01:16:34' AND (c0_.type = 'fermeture' OR c0_.type = 'indisponible') ORDER BY c0_.priority ASC;

SELECT
  c0_.id AS id_0,
  c0_.designation AS designation_1,
  c0_.type AS type_2,
  c0_.from_date AS from_date_3,
  c0_.to_date AS to_date_4,
  c0_.priority AS priority_5,
  c0_.activity_closed AS activity_closed_6,
  c0_.type AS type_7
FROM
  calendar c0_
WHERE
  c0_.from_date <= ?
  AND c0_.to_date > ?
  AND c0_.to_date > ?
ORDER BY
  c0_.priority ASC

SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.from_date AS from_date_3, c0_.to_date AS to_date_4, c0_.priority AS priority_5, c0_.activity_closed AS activity_closed_6, c0_.type AS type_7 FROM calendar c0_ WHERE c0_.from_date <= '2025-07-29' AND c0_.to_date > '2025-07-29' AND c0_.to_date > '2025-07-29' ORDER BY c0_.priority ASC;

SELECT
  p0_.id AS id_0,
  p0_.designation AS designation_1,
  p0_.information AS information_2,
  p0_.heure_debut AS heure_debut_3,
  p0_.heure_fin AS heure_fin_4,
  p0_.jours AS jours_5,
  p0_.nbre_parties AS nbre_parties_6,
  p0_.date_debut AS date_debut_7,
  p0_.date_fin AS date_fin_8,
  p0_.type_reduction AS type_reduction_9,
  p0_.price_ttc AS price_ttc_10,
  p0_.percent AS percent_11,
  p0_.priority AS priority_12,
  p0_.id AS id_13,
  p0_.forfait_id AS forfait_id_14,
  p0_.groupby_id AS groupby_id_15
FROM
  promos p0_
WHERE
  p0_.forfait_id = ?
  AND p0_.jours LIKE ?
  AND (
    p0_.date_debut <= ?
    OR p0_.date_debut IS NULL
  )
  AND (
    p0_.date_fin > ?
    OR p0_.date_fin IS NULL
  )
  AND (
    p0_.heure_debut <= ?
    OR p0_.heure_debut IS NULL
  )
  AND (
    p0_.heure_fin > ?
    OR p0_.heure_fin IS NULL
  )