Symfony Profiler

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.numero_resa = ?
LIMIT
  1

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.numero_resa = 'STMCPJ' LIMIT 1;

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.pu_ttc AS pu_ttc_7,
  t0.taux_tva AS taux_tva_8,
  t0.total_ht AS total_ht_9,
  t0.montant_tva AS montant_tva_10,
  t0.total_ttc AS total_ttc_11,
  t0.reservation_id AS reservation_id_12,
  t0.parent_id AS parent_id_13
FROM
  reservation_details t0
WHERE
  t0.reservation_id = ?

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.pu_ttc AS pu_ttc_7, t0.taux_tva AS taux_tva_8, t0.total_ht AS total_ht_9, t0.montant_tva AS montant_tva_10, t0.total_ttc AS total_ttc_11, t0.reservation_id AS reservation_id_12, t0.parent_id AS parent_id_13 FROM reservation_details t0 WHERE t0.reservation_id = 15426;

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.forfait AS forfait_3,
  t0.formule AS formule_4,
  t0.code_activity AS code_activity_5,
  t0.date AS date_6,
  t0.creneau AS creneau_7,
  t0.nbre_parties AS nbre_parties_8,
  t0.quantity AS quantity_9,
  t0.pu_ttc AS pu_ttc_10,
  t0.taux_tva AS taux_tva_11,
  t0.total_ht AS total_ht_12,
  t0.montant_tva AS montant_tva_13,
  t0.total_ttc AS total_ttc_14,
  t0.admin AS admin_15,
  t0.reservation_id AS reservation_id_16
FROM
  booked_activity t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.forfait AS forfait_3, t0.formule AS formule_4, t0.code_activity AS code_activity_5, t0.date AS date_6, t0.creneau AS creneau_7, t0.nbre_parties AS nbre_parties_8, t0.quantity AS quantity_9, t0.pu_ttc AS pu_ttc_10, t0.taux_tva AS taux_tva_11, t0.total_ht AS total_ht_12, t0.montant_tva AS montant_tva_13, t0.total_ttc AS total_ttc_14, t0.admin AS admin_15, t0.reservation_id AS reservation_id_16 FROM booked_activity t0 WHERE t0.reservation_id = 15426;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  reservation
SET
  history = ?
WHERE
  id = ?

UPDATE reservation SET history = '
--------------------------
01/07/2025 23:00:25 : Paiement par bon numérique
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)
--------------------------
04/07/2025 03:37:17 : Paiement par bon numérique
' WHERE id = 15426;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.company AS company_4,
  t0.customer_number AS customer_number_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.email AS email_8,
  t0.phone AS phone_9,
  t0.phone_mobile AS phone_mobile_10,
  t0.address1 AS address1_11,
  t0.address2 AS address2_12,
  t0.postcode AS postcode_13,
  t0.city AS city_14,
  t0.country AS country_15,
  t0.birthday AS birthday_16,
  t0.gender AS gender_17,
  t0.solde AS solde_18,
  t0.date_add AS date_add_19,
  t0.date_upd AS date_upd_20,
  t0.comment AS comment_21,
  t0.statut AS statut_22,
  t0.active AS active_23,
  t0.deleted AS deleted_24,
  t0.reset_token AS reset_token_25
FROM
  customer t0
WHERE
  t0.customer_number = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.company AS company_4, t0.customer_number AS customer_number_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.email AS email_8, t0.phone AS phone_9, t0.phone_mobile AS phone_mobile_10, t0.address1 AS address1_11, t0.address2 AS address2_12, t0.postcode AS postcode_13, t0.city AS city_14, t0.country AS country_15, t0.birthday AS birthday_16, t0.gender AS gender_17, t0.solde AS solde_18, t0.date_add AS date_add_19, t0.date_upd AS date_upd_20, t0.comment AS comment_21, t0.statut AS statut_22, t0.active AS active_23, t0.deleted AS deleted_24, t0.reset_token AS reset_token_25 FROM customer t0 WHERE t0.customer_number = '056611' LIMIT 1;