Symfony Profiler

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_.reservation_id AS reservation_id_14
FROM
  `booked_activity` b0_
  INNER JOIN `reservation` r1_ ON (b0_.reservation_id = r1_.id)
WHERE
  r1_.active = 1
  AND b0_.date = ?
  AND b0_.code_activity = ?

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_.reservation_id AS reservation_id_14 FROM `booked_activity` b0_ INNER JOIN `reservation` r1_ ON (b0_.reservation_id = r1_.id) WHERE r1_.active = 1 AND b0_.date = '2025-09-06 00:00:00' AND b0_.code_activity = 'tac-tic-room';

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.code_activity AS code_activity_3,
  t0.date AS date_4,
  t0.creneau AS creneau_5,
  t0.quantity AS quantity_6,
  t0.nbre_parties AS nbre_parties_7,
  t0.id_customer AS id_customer_8,
  t0.shortname AS shortname_9,
  t0.deleted AS deleted_10,
  t0.is_unavailable AS is_unavailable_11
FROM
  `operator_booking` t0
WHERE
  t0.code_activity = ?
  AND t0.date = ?
  AND t0.deleted IS NULL
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.code_activity AS code_activity_3, t0.date AS date_4, t0.creneau AS creneau_5, t0.quantity AS quantity_6, t0.nbre_parties AS nbre_parties_7, t0.id_customer AS id_customer_8, t0.shortname AS shortname_9, t0.deleted AS deleted_10, t0.is_unavailable AS is_unavailable_11 FROM `operator_booking` t0 WHERE t0.code_activity = 'tac-tic-room' AND t0.date = '2025-09-06' AND t0.deleted IS NULL ORDER BY t0.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
FROM
  `calendar` c0_
WHERE
  (
    (
      c0_.from_date <= ?
      AND c0_.to_date >= ?
    )
    OR (
      c0_.from_date <= ?
      AND c0_.to_date >= ?
    )
    OR (
      c0_.from_date <= ?
      AND c0_.to_date >= ?
    )
    OR (
      c0_.from_date >= ?
      AND c0_.to_date <= ?
    )
  )
  AND c0_.type <> ?
  AND c0_.type <> ?
  AND c0_.type <> ?
  AND c0_.activity_closed IS NULL

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 FROM `calendar` c0_ WHERE ((c0_.from_date <= '2025-09-06 00:00:00' AND c0_.to_date >= '2025-09-06 00:00:00') OR (c0_.from_date <= '2025-09-06 23:59:00' AND c0_.to_date >= '2025-09-06 23:59:00') OR (c0_.from_date <= '2025-09-06 00:00:00' AND c0_.to_date >= '2025-09-06 23:59:00') OR (c0_.from_date >= '2025-09-06 00:00:00' AND c0_.to_date <= '2025-09-06 23:59:00')) AND c0_.type <> 'vacances' AND c0_.type <> 'veille' AND c0_.type <> 'feries' AND c0_.activity_closed IS NULL;

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
FROM
  `calendar` c0_
WHERE
  (
    (
      c0_.from_date <= ?
      AND c0_.to_date >= ?
    )
    OR (
      c0_.from_date <= ?
      AND c0_.to_date >= ?
    )
    OR (
      c0_.from_date <= ?
      AND c0_.to_date >= ?
    )
    OR (
      c0_.from_date >= ?
      AND c0_.to_date <= ?
    )
  )
  AND c0_.activity_closed = ?

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 FROM `calendar` c0_ WHERE ((c0_.from_date <= '2025-09-06 00:00:00' AND c0_.to_date >= '2025-09-06 00:00:00') OR (c0_.from_date <= '2025-09-06 23:59:00' AND c0_.to_date >= '2025-09-06 23:59:00') OR (c0_.from_date <= '2025-09-06 00:00:00' AND c0_.to_date >= '2025-09-06 23:59:00') OR (c0_.from_date >= '2025-09-06 00:00:00' AND c0_.to_date <= '2025-09-06 23:59:00')) AND c0_.activity_closed = 'tac-tic-room';

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3,
  t0.mention_anniversaire AS mention_anniversaire_4,
  t0.url_activity AS url_activity_5,
  t0.temps_limite_resa AS temps_limite_resa_6,
  t0.jauge_mini AS jauge_mini_7,
  t0.mention AS mention_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.waiting_time AS waiting_time_22,
  t0.espaces_jeu_reel AS espaces_jeu_reel_23,
  t0.jauge_maxi_reel AS jauge_maxi_reel_24,
  t0.temps_creneau_reel AS temps_creneau_reel_25,
  t0.ignored_creneau AS ignored_creneau_26,
  t0.temps_activite_joueur AS temps_activite_joueur_27
FROM
  `activity` t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.mention_anniversaire AS mention_anniversaire_4, t0.url_activity AS url_activity_5, t0.temps_limite_resa AS temps_limite_resa_6, t0.jauge_mini AS jauge_mini_7, t0.mention AS mention_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.waiting_time AS waiting_time_22, t0.espaces_jeu_reel AS espaces_jeu_reel_23, t0.jauge_maxi_reel AS jauge_maxi_reel_24, t0.temps_creneau_reel AS temps_creneau_reel_25, t0.ignored_creneau AS ignored_creneau_26, t0.temps_activite_joueur AS temps_activite_joueur_27 FROM `activity` t0 WHERE t0.code = 'tac-tic-room' LIMIT 1;