Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.amount AS amount_3,
  t0.moneda AS moneda_4,
  t0.promociones AS promociones_5,
  t0.fh_vigencia AS fh_vigencia_6,
  t0.payment_status AS payment_status_7,
  t0.xml_request AS xml_request_8,
  t0.original_xml_request AS original_xml_request_9,
  t0.original_xml_response AS original_xml_response_10,
  t0.response_received_at AS response_received_at_11,
  t0.create_at AS create_at_12,
  t0.update_at AS update_at_13,
  t0.consumer_web_service_id AS consumer_web_service_id_14
FROM
  payment_intention t0
WHERE
  t0.reference = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.amount AS amount_3, t0.moneda AS moneda_4, t0.promociones AS promociones_5, t0.fh_vigencia AS fh_vigencia_6, t0.payment_status AS payment_status_7, t0.xml_request AS xml_request_8, t0.original_xml_request AS original_xml_request_9, t0.original_xml_response AS original_xml_response_10, t0.response_received_at AS response_received_at_11, t0.create_at AS create_at_12, t0.update_at AS update_at_13, t0.consumer_web_service_id AS consumer_web_service_id_14 FROM payment_intention t0 WHERE t0.reference = 'YTA2336' LIMIT 1;

"COMMIT"

"COMMIT";

UPDATE
  payment_intention
SET
  payment_status = ?,
  original_xml_response = ?,
  response_received_at = ?,
  update_at = ?
WHERE
  id = ?

UPDATE payment_intention SET payment_status = 1, original_xml_response = '<?xml version=\"1.0\" encoding=\"ISO-8859-15\" standalone=\'yes\'?><CENTEROFPAYMENTS><reference>YTA2336</reference><response>approved</response><foliocpagos>585393100</foliocpagos><auth>579398</auth><cd_response>00</cd_response><cd_error/><nb_error/><time>15:11:32</time><date>08/07/2026</date><nb_company>YAMEVI TRAVEL</nb_company><nb_merchant>9171545 YAMEVITRAVEL MXN</nb_merchant><cc_type>CREDITO/BANREGIO/Visa</cc_type><tp_operation>VENTA</tp_operation><cc_name>Erika Minerva Pérez Salazar </cc_name><cc_number>8360</cc_number><cc_expmonth>03</cc_expmonth><cc_expyear>29</cc_expyear><amount>6900.00</amount><emv_key_date/><id_url>NML9Y8WH</id_url><email>erika_p_s@hotmail.com</email><st_cr>0</st_cr><cc_mask>417968XXXXXX8360</cc_mask><datos_adicionales><data id=\"1\"><label>YameviTravel Tours</label><value>Erika  Minerva Perez</value></data></datos_adicionales><promocion>C</promocion></CENTEROFPAYMENTS>', response_received_at = '2026-07-08 16:11:35', update_at = '2026-07-08 16:11:35' WHERE id = 4098;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.webhook AS webhook_3,
  t0.create_at AS create_at_4,
  t0.update_at AS update_at_5
FROM
  consumer_web_service t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.webhook AS webhook_3, t0.create_at AS create_at_4, t0.update_at AS update_at_5 FROM consumer_web_service t0 WHERE t0.id = 5;

"START TRANSACTION"

"START TRANSACTION";