Symfony Profiler

"COMMIT"

"COMMIT";

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 = 'salles-de-quizz' AND t0.date = '2025-12-06' AND t0.deleted IS NULL ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.code_activity AS code_activity_2,
  t0.date AS date_3,
  t0.creneau AS creneau_4,
  t0.token AS token_5,
  t0.key_token AS key_token_6
FROM
  `operator_secure_action` t0
WHERE
  t0.key_token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code_activity AS code_activity_2, t0.date AS date_3, t0.creneau AS creneau_4, t0.token AS token_5, t0.key_token AS key_token_6 FROM `operator_secure_action` t0 WHERE t0.key_token = '' LIMIT 1;

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-12-06 00:00:00' AND b0_.code_activity = 'salles-de-quizz';

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.customer_number AS customer_number_3,
  t0.formule AS formule_4,
  t0.formule_code AS formule_code_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.company AS company_8,
  t0.email AS email_9,
  t0.phone AS phone_10,
  t0.phone_mobile AS phone_mobile_11,
  t0.billing_address AS billing_address_12,
  t0.comment AS comment_13,
  t0.date_add AS date_add_14,
  t0.date_resa AS date_resa_15,
  t0.numero_resa AS numero_resa_16,
  t0.invoice_number AS invoice_number_17,
  t0.sstotal_ht AS sstotal_ht_18,
  t0.tva AS tva_19,
  t0.total_ttc AS total_ttc_20,
  t0.history AS history_21,
  t0.date_upd AS date_upd_22,
  t0.statut AS statut_23,
  t0.active AS active_24,
  t0.confirmation AS confirmation_25,
  t0.deleted AS deleted_26,
  t0.composted AS composted_27,
  t0.ip AS ip_28,
  t0.payment_id AS payment_id_29,
  t0.child_name AS child_name_30,
  t0.child_birthday AS child_birthday_31,
  t0.child_age AS child_age_32,
  t0.birthday_customer_comment AS birthday_customer_comment_33
FROM
  `reservation` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.customer_number AS customer_number_3, t0.formule AS formule_4, t0.formule_code AS formule_code_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.company AS company_8, t0.email AS email_9, t0.phone AS phone_10, t0.phone_mobile AS phone_mobile_11, t0.billing_address AS billing_address_12, t0.comment AS comment_13, t0.date_add AS date_add_14, t0.date_resa AS date_resa_15, t0.numero_resa AS numero_resa_16, t0.invoice_number AS invoice_number_17, t0.sstotal_ht AS sstotal_ht_18, t0.tva AS tva_19, t0.total_ttc AS total_ttc_20, t0.history AS history_21, t0.date_upd AS date_upd_22, t0.statut AS statut_23, t0.active AS active_24, t0.confirmation AS confirmation_25, t0.deleted AS deleted_26, t0.composted AS composted_27, t0.ip AS ip_28, t0.payment_id AS payment_id_29, t0.child_name AS child_name_30, t0.child_birthday AS child_birthday_31, t0.child_age AS child_age_32, t0.birthday_customer_comment AS birthday_customer_comment_33 FROM `reservation` t0 WHERE t0.id = 2204;

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.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.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.is_creneau_activity = 1 AND t0.is_draft = 0;

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

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

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
  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 = 'salles-de-quizz' LIMIT 1;

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-12-06 00:00:00' AND c0_.to_date >= '2025-12-06 00:00:00') OR (c0_.from_date <= '2025-12-06 23:59:00' AND c0_.to_date >= '2025-12-06 23:59:00') OR (c0_.from_date <= '2025-12-06 00:00:00' AND c0_.to_date >= '2025-12-06 23:59:00') OR (c0_.from_date >= '2025-12-06 00:00:00' AND c0_.to_date <= '2025-12-06 23:59:00')) AND c0_.activity_closed = 'salles-de-quizz';

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.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.code_activity = ?
  AND t0.date = ?
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.code_activity = 'salles-de-quizz' AND t0.date = '2025-12-06 00:00:00' LIMIT 1;

INSERT INTO `operator_booking` (
  designation, code_activity, date,
  creneau, quantity, nbre_parties,
  id_customer, shortname, deleted,
  is_unavailable
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO `operator_booking` (designation, code_activity, date, creneau, quantity, nbre_parties, id_customer, shortname, deleted, is_unavailable) VALUES (NULL, 'salles-de-quizz', '2025-12-06', '18:00:00', 5, 1, 0, 'sabine', NULL, NULL);

"START TRANSACTION"

"START TRANSACTION";