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 = 'cSlTLCL_Ez0s3goDHFdG3EU0dsJ2prn5uUD6x_gScqM';

UPDATE
  payments
SET
  details = ?
WHERE
  id = ?

UPDATE payments SET details = '{\"flowType\":\"PIS\",\"userId\":\"cus_NGtFgtM64R\",\"html\":\"<div class=\\\"ibanxs-main-container-wrapper\\\"><div class=\\\"ibanxs-default-outer-container\\\"><div style=\\\"width: 95%; max-width: 500px; margin: 20px auto;\\\"><div><img class=\\\"comp-logo\\\" src=\\\"https:\\/\\/app.bwire.io\\/static\\/logo.png\\\" style=\\\"display: block; margin: auto; max-width: 100%;\\\"><\\/div><div style=\\\"background-color: rgba(230, 233, 241, 0.95); border-radius: 15px; margin: 20px auto auto; padding: 60px 10px 40px;\\\">${ibanxs}<\\/div><\\/div><\\/div><\\/div>\",\"css\":\".ibanxs-default-outer-container {background-image: url(\\\"https:\\/\\/app.bwire.io\\/static\\/bg.jpg\\\"); background-position: top; background-repeat: no-repeat;background-size: cover; box-sizing: border-box; height: 100vh; padding-top: 150px;} .ibanxs-submit-button {background-color: #253266; border-radius: 10px} .ibanxs-field-validation-icon.correct {color: #253266;} .ibanxs-field-validation-icon.error {color: 800000;} .ibanxs-checkbox {border-color: #253266; border-radius: 10px;} .ibanxs-checkbox.checked {background-color: #253266} .ibanxs-text-input {border-radius: 10px; margin-bottom: 10px;} div.ibanxs-language-switch, div.ibanxs-language-switch-list {background-color: rgba(230, 233, 241, 0.95);} li.ibanxs-language-switch-list-element:hover {background-color: white; opacity: 0.7} .ibanxs-transaction-information { display: block; margin-bottom: 20px; margin-left: 55px; margin-right: 55px;} .ibanxs-transaction-information-field-title { display: inline; font-weight: bold; margin-right: 5px; } .ibanxs-transaction-information-field-value { display: inline; font-weight: 215; } .ibanxs-transaction-bulk-details-toggle { font-size: 12px; font-weight: 300; cursor: pointer; margin: 5px 0 15px 0; } .ibanxs-transaction-bulk-details-toggle:hover {opacity: 0.8} .ibanxs-transaction-bulk-details-container { display: none; } .ibanxs-transaction-bulk-details-container.display { display: block; height: max(200px, 20vh); overflow-y: scroll;} .ibanxs-transaction-bulk-details-element { padding-bottom: 5px; border-top: 1px solid rgb(249, 139, 28); } @media only screen and (max-width: 600px) {.ibanxs-default-outer-container {padding-top: 5px;} div.ibanxs-language-switch {top: 90vh;} div.ibanxs-language-switch-list {top: -115px; right: 70px;} div.ibanxs-form-field-container {padding: 5px 0 5px 0} div.ibanxs-transaction-information { margin: 10px; } .ibanxs-transaction-bulk-details-toggle {margin: 10px auto 10px auto; padding: 8px 0 8px 0; text-align: center; background-color: rgba(255, 255, 255, 0.4); border-radius: 8px;} .ibanxs-transaction-bulk-details-toggle:active {background-color: rgba(255, 255, 255, 0.8);} }\",\"params\":{\"redirectionUrl\":\"https:\\/\\/staging.bwire.io\\/payments\\/8f771bb9-9f32-4e2a-b580-7bf51a879111\",\"statusCallback\":\"https:\\/\\/staging.bwire.io\\/payment\\/notify\\/EAiBN6DnB0q4-cV8i5ah6ooUYuFazCsdDJy-8pL9bZI\",\"amountToPay\":\"25.00\",\"currency\":\"EUR\",\"description\":\"description\",\"endToEndIdentification\":\"description\",\"creditorName\":\"Gate2Way\",\"creditorStreet\":\"323\",\"creditorStreetNumber\":\"2\",\"creditorCity\":\"Strovolos\",\"creditorPostalCode\":\"11-111\",\"creditorCountry\":\"PL\",\"creditorIban\":\"PL61109010140000071219812874\",\"psuIpAddress\":\"80.94.24.121\"}}' WHERE id = '8f771bb9-9f32-4e2a-b580-7bf51a879111';

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 = '8f771bb9-9f32-4e2a-b580-7bf51a879111';

"COMMIT"

"COMMIT";

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 = 'gate2way';

"START TRANSACTION"

"START TRANSACTION";

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 ('EAiBN6DnB0q4-cV8i5ah6ooUYuFazCsdDJy-8pL9bZI', 'O:25:\"Payum\\Core\\Model\\Identity\":2:{i:0;s:36:\"8f771bb9-9f32-4e2a-b580-7bf51a879111\";i:1;s:32:\"App\\Domain\\Payment\\Model\\Payment\";}', NULL, 'https://staging.bwire.io/payment/notify/EAiBN6DnB0q4-cV8i5ah6ooUYuFazCsdDJy-8pL9bZI', 'gate2way');