Symfony Profiler

SELECT
  t0.hash AS hash_1,
  t0.details AS details_2,
  t0.after_url AS after_url_3,
  t0.target_url AS target_url_4,
  t0.gateway_name AS gateway_name_5
FROM
  payment_tokens t0
WHERE
  t0.hash = ?

SELECT t0.hash AS hash_1, t0.details AS details_2, t0.after_url AS after_url_3, t0.target_url AS target_url_4, t0.gateway_name AS gateway_name_5 FROM payment_tokens t0 WHERE t0.hash = 'sY-og7WiSA0pnyw9P19zHewjm5lcAFWKGModTuIUIT8';

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.description AS description_3,
  t0.amount AS amount_4,
  t0.currency AS currency_5,
  t0.success_url AS success_url_6,
  t0.failure_url AS failure_url_7,
  t0.pending_url AS pending_url_8,
  t0.notification_url AS notification_url_9,
  t0.customer_id AS customer_id_10,
  t0.details AS details_11,
  t0.status AS status_12,
  t0.pisp_status AS pisp_status_13,
  t0.bank_status AS bank_status_14,
  t0.mapping_id AS mapping_id_15,
  t0.payment_type AS payment_type_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t19.id AS id_20,
  t19.ip_address AS ip_address_21,
  t19.name AS name_22,
  t19.created_at AS created_at_23,
  t19.updated_at AS updated_at_24,
  t19.payment_id AS payment_id_25,
  t0.site_id AS site_id_26
FROM
  payments t0
  LEFT JOIN user_payment_info t19 ON t19.payment_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.description AS description_3, t0.amount AS amount_4, t0.currency AS currency_5, t0.success_url AS success_url_6, t0.failure_url AS failure_url_7, t0.pending_url AS pending_url_8, t0.notification_url AS notification_url_9, t0.customer_id AS customer_id_10, t0.details AS details_11, t0.status AS status_12, t0.pisp_status AS pisp_status_13, t0.bank_status AS bank_status_14, t0.mapping_id AS mapping_id_15, t0.payment_type AS payment_type_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t19.id AS id_20, t19.ip_address AS ip_address_21, t19.name AS name_22, t19.created_at AS created_at_23, t19.updated_at AS updated_at_24, t19.payment_id AS payment_id_25, t0.site_id AS site_id_26 FROM payments t0 LEFT JOIN user_payment_info t19 ON t19.payment_id = t0.id WHERE t0.id = 'd5a83a08-25f9-46ad-b51d-0ac552092a87';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.factory_name AS factory_name_3,
  t0.gateway_name AS gateway_name_4,
  t0.config AS config_5,
  t0.active AS active_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  payment_gateway_configs t0
WHERE
  t0.gateway_name = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.factory_name AS factory_name_3, t0.gateway_name AS gateway_name_4, t0.config AS config_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_gateway_configs t0 WHERE t0.gateway_name = 'livepoint_trading_ltd';

"COMMIT"

"COMMIT";

INSERT INTO payment_tokens (
  hash, details, after_url, target_url,
  gateway_name
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO payment_tokens (hash, details, after_url, target_url, gateway_name) VALUES ('0YjBl0_eGdRR82VfmNdc0PAhTUmOA96hkblLhtTMxpI', 'O:25:\"Payum\\Core\\Model\\Identity\":2:{i:0;s:36:\"d5a83a08-25f9-46ad-b51d-0ac552092a87\";i:1;s:32:\"App\\Domain\\Payment\\Model\\Payment\";}', NULL, 'https://staging.bwire.io/payment/notify/0YjBl0_eGdRR82VfmNdc0PAhTUmOA96hkblLhtTMxpI', 'livepoint_trading_ltd');

UPDATE
  payments
SET
  details = ?
WHERE
  id = ?

UPDATE payments SET details = '{\"flowType\":\"PIS\",\"userId\":\"51e4ef9b-9929-4fb0-86a3-689348f1871f212111131\",\"html\":\"<div class=\\\"ibanxs-main-container-wrapper\\\"><div class=\\\"ibanxs-default-outer-container\\\"><div class=\\\"ibanxs-payment-card\\\"><div class=\\\"ibanxs-logo-container\\\"><img class=\\\"comp-logo\\\" src=\\\"https:\\/\\/images.seeklogo.com\\/logo-png\\/38\\/1\\/company-logo-png_seeklogo-389186.png\\\" alt=\\\"Company Logo\\\"><\\/div><div class=\\\"ibanxs-payment-content\\\"><div class=\\\"ibanxs-test-header\\\"><h2>Secure Payment<\\/h2><p>Complete your payment securely<\\/p><\\/div>${ibanxs}<div class=\\\"ibanxs-test-footer\\\">Secure payment processing<\\/div><\\/div><\\/div><\\/div><\\/div>\",\"css\":\" * { box-sizing: border-box; } .ibanxs-main-container-wrapper { min-height: 100vh; font-family: Arial, sans-serif; color: #1e293b; } .ibanxs-default-outer-container { min-height: 100vh; padding: 50px 15px; background: linear-gradient(rgba(15, 23, 42, 0.65), rgba(37, 50, 102, 0.65)), url(\\\"https:\\/\\/images.unsplash.com\\/photo-1497366754035-f200968a6e72?auto=format&fit=crop&w=1920&q=80\\\") center \\/ cover no-repeat; } .ibanxs-payment-card { width: 95%; max-width: 500px; margin: 0 auto; overflow: hidden; background: #fff; border-radius: 18px; box-shadow: 0 20px 60px rgba(0, 0, 0, 0.25); } .ibanxs-logo-container { padding: 25px; text-align: center; } .comp-logo { display: block; max-width: 200px; max-height: 75px; margin: auto; object-fit: contain; } .ibanxs-payment-content { padding: 30px 25px; background: #fff; } .ibanxs-test-header { margin-bottom: 25px; text-align: center; } .ibanxs-test-header h2 { margin: 0 0 8px; color: #253266; font-size: 25px; } .ibanxs-test-header p { color: #64748b; font-size: 14px; } .ibanxs-text-input { width: 100%; padding: 12px; margin-bottom: 12px; border: 1px solid #cbd5e1; border-radius: 9px; } .ibanxs-text-input:focus { outline: 2px solid #c7d2fe; border-color: #253266; } .ibanxs-submit-button { width: 100%; padding: 14px; color: #fff; background: #253266; border: none; border-radius: 9px; font-weight: bold; cursor: pointer; } .ibanxs-submit-button:hover { background: #35488d; } .ibanxs-field-validation-icon.correct { color: #15803d; } .ibanxs-field-validation-icon.error { color: #b91c1c; } .ibanxs-checkbox { border: 1px solid #253266; border-radius: 5px; } .ibanxs-checkbox.checked { background: #253266; } div.ibanxs-language-switch, div.ibanxs-language-switch-list { background: #fff; border-radius: 8px; } li.ibanxs-language-switch-list-element:hover { background: #eef2ff; } .ibanxs-transaction-information { display: block; margin: 0 0 20px; padding: 15px; background: #f8fafc; border: 1px solid #e2e8f0; border-radius: 10px; } .ibanxs-transaction-information-field-title { display: inline; margin-right: 5px; font-weight: bold; } .ibanxs-transaction-information-field-value { display: inline; font-weight: normal; overflow-wrap: anywhere; } .ibanxs-transaction-bulk-details-toggle { margin: 10px 0; font-size: 12px; cursor: pointer; } .ibanxs-transaction-bulk-details-container { display: none; } .ibanxs-transaction-bulk-details-container.display { display: block; max-height: 250px; overflow-y: auto; } .ibanxs-transaction-bulk-details-element { padding: 8px 0; border-top: 1px solid #e2e8f0; overflow-wrap: anywhere; } .ibanxs-test-footer { padding-top: 20px; margin-top: 25px; border-top: 1px solid #e2e8f0; color: #64748b; font-size: 12px; text-align: center; } @media (max-width: 600px) { .ibanxs-default-outer-container { padding: 15px 8px; background-attachment: scroll; } .ibanxs-payment-card { width: 100%; border-radius: 14px; } .ibanxs-payment-content { padding: 22px 16px; } .ibanxs-test-header h2 { font-size: 22px; } .ibanxs-transaction-information { margin: 10px 0; } }\",\"params\":{\"redirectionUrl\":null,\"statusCallback\":\"https:\\/\\/staging.bwire.io\\/payment\\/notify\\/0YjBl0_eGdRR82VfmNdc0PAhTUmOA96hkblLhtTMxpI\",\"amountToPay\":\"1.00\",\"currency\":\"EUR\",\"description\":\"l6ndcxwz83nr7zbbuocdo8u8dd23\",\"endToEndIdentification\":\"l6ndcxwz83nr7zbbuocdo8u8dd23\",\"creditorName\":null,\"creditorStreet\":null,\"creditorStreetNumber\":null,\"creditorCity\":null,\"creditorPostalCode\":null,\"creditorCountry\":null,\"creditorIban\":null,\"psuIpAddress\":\"80.94.24.121\"}}' WHERE id = 'd5a83a08-25f9-46ad-b51d-0ac552092a87';

"START TRANSACTION"

"START TRANSACTION";