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

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.code AS code_3,
  t0.url_formule AS url_formule_4,
  t0.temps_limite_resa AS temps_limite_resa_5,
  t0.nbre_mini AS nbre_mini_6,
  t0.nbre_maxi AS nbre_maxi_7,
  t0.presence_avant AS presence_avant_8,
  t0.is_creneau_activity AS is_creneau_activity_9,
  t0.heure_ouverture_creneau AS heure_ouverture_creneau_10,
  t0.heure_fermeture_creneau AS heure_fermeture_creneau_11,
  t0.temps_creneau AS temps_creneau_12,
  t0.priority AS priority_13,
  t0.actif AS actif_14,
  t0.description AS description_15,
  t0.image AS image_16,
  t0.updated_at AS updated_at_17
FROM
  `formule` t0
WHERE
  t0.is_creneau_activity = ?
  AND t0.actif = ?

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.code AS code_3, t0.url_formule AS url_formule_4, t0.temps_limite_resa AS temps_limite_resa_5, t0.nbre_mini AS nbre_mini_6, t0.nbre_maxi AS nbre_maxi_7, t0.presence_avant AS presence_avant_8, t0.is_creneau_activity AS is_creneau_activity_9, t0.heure_ouverture_creneau AS heure_ouverture_creneau_10, t0.heure_fermeture_creneau AS heure_fermeture_creneau_11, t0.temps_creneau AS temps_creneau_12, t0.priority AS priority_13, t0.actif AS actif_14, t0.description AS description_15, t0.image AS image_16, t0.updated_at AS updated_at_17 FROM `formule` t0 WHERE t0.is_creneau_activity = 1 AND t0.actif = 1;

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.code AS code_3,
  t0.url_formule AS url_formule_4,
  t0.temps_limite_resa AS temps_limite_resa_5,
  t0.nbre_mini AS nbre_mini_6,
  t0.nbre_maxi AS nbre_maxi_7,
  t0.presence_avant AS presence_avant_8,
  t0.is_creneau_activity AS is_creneau_activity_9,
  t0.heure_ouverture_creneau AS heure_ouverture_creneau_10,
  t0.heure_fermeture_creneau AS heure_fermeture_creneau_11,
  t0.temps_creneau AS temps_creneau_12,
  t0.priority AS priority_13,
  t0.actif AS actif_14,
  t0.description AS description_15,
  t0.image AS image_16,
  t0.updated_at AS updated_at_17
FROM
  `formule` t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.code AS code_3, t0.url_formule AS url_formule_4, t0.temps_limite_resa AS temps_limite_resa_5, t0.nbre_mini AS nbre_mini_6, t0.nbre_maxi AS nbre_maxi_7, t0.presence_avant AS presence_avant_8, t0.is_creneau_activity AS is_creneau_activity_9, t0.heure_ouverture_creneau AS heure_ouverture_creneau_10, t0.heure_fermeture_creneau AS heure_fermeture_creneau_11, t0.temps_creneau AS temps_creneau_12, t0.priority AS priority_13, t0.actif AS actif_14, t0.description AS description_15, t0.image AS image_16, t0.updated_at AS updated_at_17 FROM `formule` t0 WHERE t0.code = 'anniversaire' 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.billboard_libelle_slot AS billboard_libelle_slot_22,
  t0.waiting_time AS waiting_time_23,
  t0.espaces_jeu_reel AS espaces_jeu_reel_24,
  t0.jauge_maxi_reel AS jauge_maxi_reel_25,
  t0.temps_creneau_reel AS temps_creneau_reel_26,
  t0.ignored_creneau AS ignored_creneau_27,
  t0.temps_activite_joueur AS temps_activite_joueur_28
FROM
  `activity` t0
WHERE
  t0.is_creneau_activity = ?
  AND t0.is_draft = ?

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.billboard_libelle_slot AS billboard_libelle_slot_22, t0.waiting_time AS waiting_time_23, t0.espaces_jeu_reel AS espaces_jeu_reel_24, t0.jauge_maxi_reel AS jauge_maxi_reel_25, t0.temps_creneau_reel AS temps_creneau_reel_26, t0.ignored_creneau AS ignored_creneau_27, t0.temps_activite_joueur AS temps_activite_joueur_28 FROM `activity` t0 WHERE t0.is_creneau_activity = 1 AND t0.is_draft = 0;

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 <= '2026-05-13 00:00:00' AND c0_.to_date >= '2026-05-13 00:00:00') OR (c0_.from_date <= '2026-05-13 23:59:00' AND c0_.to_date >= '2026-05-13 23:59:00') OR (c0_.from_date <= '2026-05-13 00:00:00' AND c0_.to_date >= '2026-05-13 23:59:00') OR (c0_.from_date >= '2026-05-13 00:00:00' AND c0_.to_date <= '2026-05-13 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 <= '2026-05-13 00:00:00' AND c0_.to_date >= '2026-05-13 00:00:00') OR (c0_.from_date <= '2026-05-13 23:59:00' AND c0_.to_date >= '2026-05-13 23:59:00') OR (c0_.from_date <= '2026-05-13 00:00:00' AND c0_.to_date >= '2026-05-13 23:59:00') OR (c0_.from_date >= '2026-05-13 00:00:00' AND c0_.to_date <= '2026-05-13 23:59:00')) AND c0_.activity_closed = 'anniversaire';

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_.active = 1
  AND r0_.date_resa >= ?
  AND r0_.date_resa <= ?
  AND r0_.formule LIKE ?

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_.active = 1 AND r0_.date_resa >= '2026-05-13 00:00:00' AND r0_.date_resa <= '2026-05-13 23:59:00' AND r0_.formule LIKE '%anniversaire%';