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 = 'YT109354' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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>YT109354</reference><response>approved</response><foliocpagos>498720279</foliocpagos><auth>040742</auth><cd_response>00</cd_response><cd_error/><nb_error/><time>23:28:02</time><date>21/03/2026</date><nb_company>YAMEVI TRAVEL</nb_company><nb_merchant>9171545 YAMEVITRAVEL MXN</nb_merchant><cc_type>CREDITO/INVEX/MasterCard</cc_type><tp_operation>VENTA</tp_operation><cc_name/><cc_number>4604</cc_number><cc_expmonth>01</cc_expmonth><cc_expyear>31</cc_expyear><amount>1116.00</amount><emv_key_date/><id_url>TSRHO6S4</id_url><email>dianagarsif@gmail.com</email><st_cr>0</st_cr><cc_mask>547613XXXXXX4604</cc_mask><datos_adicionales><data id=\"1\"><label>YameviTravel Transportation</label><value>Zenaida  Alvarez Cerrillos</value></data></datos_adicionales><promocion>C</promocion></CENTEROFPAYMENTS>', response_received_at = '2026-03-22 00:28:02', update_at = '2026-03-22 00:28:02' WHERE id = 3624;

"COMMIT"

"COMMIT";

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