Symfony Profiler

WITH
  updated AS (
    UPDATE
      user_payment_info
    SET
      ip_address = COALESCE(?, ip_address),
      name = COALESCE(?, name),
      updated_at = to_char(
        now(),
        'YYYY-MM-DD"T"HH24:MI:SSOF'
      )
    WHERE
      id = (
        SELECT
          id
        FROM
          user_payment_info
        WHERE
          payment_id = ?
        ORDER BY
          id DESC
        LIMIT
          1
      ) RETURNING id
  ) INSERT INTO user_payment_info (
    payment_id, ip_address, name, created_at,
    updated_at
  )
SELECT
  ?,
  ?,
  ?,
  to_char(
    now(),
    'YYYY-MM-DD"T"HH24:MI:SSOF'
  ),
  to_char(
    now(),
    'YYYY-MM-DD"T"HH24:MI:SSOF'
  )
WHERE
  NOT EXISTS (
    SELECT
      1
    FROM
      updated
  );

WITH updated AS (
        UPDATE user_payment_info
        SET
            ip_address = COALESCE('87.99.94.38', ip_address),
            name       = COALESCE(NULL, name),
            updated_at = to_char(now(), 'YYYY-MM-DD"T"HH24'c4d794d9-e6ad-4f1e-8bc8-84f0e0c8468c''c4d794d9-e6ad-4f1e-8bc8-84f0e0c8468c'')
        WHERE id = (
            SELECT id
            FROM user_payment_info
            WHERE payment_id = '87.99.94.38'
            ORDER BY id DESC
            LIMIT 1
        )
        RETURNING id
    )
    INSERT INTO user_payment_info (payment_id, ip_address, name, created_at, updated_at)
    SELECT
        NULL,
        ?,
        ?,
        to_char(now(), 'YYYY-MM-DD"T"HH24:MI:SSOF'),
        to_char(now(), 'YYYY-MM-DD"T"HH24:MI:SSOF')
    WHERE NOT EXISTS (SELECT 1 FROM updated);;

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.external_id AS external_id_1,
  p0_.description AS description_2,
  p0_.amount AS amount_3,
  p0_.currency AS currency_4,
  p0_.success_url AS success_url_5,
  p0_.failure_url AS failure_url_6,
  p0_.pending_url AS pending_url_7,
  p0_.notification_url AS notification_url_8,
  p0_.customer_id AS customer_id_9,
  p0_.details AS details_10,
  p0_.status AS status_11,
  p0_.pisp_status AS pisp_status_12,
  p0_.bank_status AS bank_status_13,
  p0_.mapping_id AS mapping_id_14,
  p0_.created_at AS created_at_15,
  p0_.updated_at AS updated_at_16,
  p0_.site_id AS site_id_17
FROM
  payments p0_
WHERE
  p0_.external_id = ?
  AND p0_.site_id = ?

SELECT p0_.id AS id_0, p0_.external_id AS external_id_1, p0_.description AS description_2, p0_.amount AS amount_3, p0_.currency AS currency_4, p0_.success_url AS success_url_5, p0_.failure_url AS failure_url_6, p0_.pending_url AS pending_url_7, p0_.notification_url AS notification_url_8, p0_.customer_id AS customer_id_9, p0_.details AS details_10, p0_.status AS status_11, p0_.pisp_status AS pisp_status_12, p0_.bank_status AS bank_status_13, p0_.mapping_id AS mapping_id_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p0_.site_id AS site_id_17 FROM payments p0_ WHERE p0_.external_id = 'k45zy3pboarqip7xvchzu94xdd_1' AND p0_.site_id = '7802b489-0af0-477f-be7e-0b5cb13ff427';

INSERT INTO payments (
  id, external_id, description, amount,
  currency, success_url, failure_url,
  pending_url, notification_url, customer_id,
  details, status, pisp_status, bank_status,
  mapping_id, created_at, updated_at,
  site_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO payments (id, external_id, description, amount, currency, success_url, failure_url, pending_url, notification_url, customer_id, details, status, pisp_status, bank_status, mapping_id, created_at, updated_at, site_id) VALUES ('c4d794d9-e6ad-4f1e-8bc8-84f0e0c8468c', 'k45zy3pboarqip7xvchzu94xdd_1', 'Bwire deposit', 1234, 'EUR', 'https://callback.dev.spini.ws/callback/58fc3078-8c55-44b1-a730-1ddcaa67dfa0-success_url', 'https://callback.dev.spini.ws/callback/58fc3078-8c55-44b1-a730-1ddcaa67dfa0-fail_url', 'https://callback.dev.spini.ws/callback/58fc3078-8c55-44b1-a730-1ddcaa67dfa0-pending_url', 'https://e102-87-99-94-38.ngrok-free.app/bwire/deposit/callback', 'testid', '{\"backgroundImageUrl\":\"https:\\/\\/app.bwire.io\\/static\\/bg.jpg\",\"logoImageUrl\":\"https:\\/\\/app.bwire.io\\/static\\/logo.png\",\"creditorName\":\"ZEPPLIN LTD\",\"creditorStreet\":\"Spaudos street\",\"creditorStreetNumber\":\"6-1\",\"creditorCity\":\"Vilnius\",\"creditorPostalCode\":\"LT-05132\",\"creditorCountry\":\"LT\",\"creditorIban\":\"LT593420001000085727\",\"redirectUrl\":\"https:\\/\\/staging.bwire.io\\/payments\\/c4d794d9-e6ad-4f1e-8bc8-84f0e0c8468c\",\"countryId\":\"FR\",\"bankId\":\"creditmutuel\",\"debtorIban\":\"FR7630066109720002000100130\",\"debtorName\":\"J\\u00f6rgen H\\u00e5kansson\",\"html\":\"<div class=\\\"wrapper\\\">${ibanxs}<\\/div>\",\"css\":\"body{background:#0a0e0a !important;}.ibanxs-main-container-wrapper{display:flex;align-items:center;justify-content:center;min-height:100vh;}.ibanXS-main-container{position:relative;background:#141714;border:1px solid rgba(255,255,255,0.08);border-radius:16px;padding:clamp(20px,6vw,36px);max-width:min(94vw,480px);min-width:280px;box-shadow:0 24px 70px rgba(0,0,0,0.55);font-family:-apple-system,BlinkMacSystemFont,\'Segoe UI\',Roboto,sans-serif;}.form-container{padding:0;width:auto;max-width:100%;}.main-form,.ibanxs-transaction-information{display:block;}.ibanxs-transaction-information{margin-bottom:clamp(16px,4vw,24px);max-height:60vh;overflow-y:auto;}.ibanxs-transaction-information-field{display:flex;justify-content:flex-start;align-items:baseline;flex-wrap:wrap;gap:clamp(6px,2vw,10px);padding:6px 0;font-size:clamp(12px,3vw,13px);border-bottom:1px solid rgba(255,255,255,0.06);}.ibanxs-transaction-information-field:last-child{border-bottom:none !important;}.ibanxs-transaction-information-field-title{color:#8a8f8a;font-weight:500;}.ibanxs-transaction-information-field-value{color:#e5e5e5;font-weight:600;text-align:left;}.ibanxs-form-field-container{margin-bottom:clamp(12px,3vw,16px);padding:0;}.ibanxs-text-input{background:#1a1d1a;border:1px solid rgba(255,255,255,0.12);box-shadow:none;}.ibanxs-text-input label{color:#8a8f8a;}.ibanxs-text-input:not(.active) label{top:50%;left:clamp(12px,4vw,16px);line-height:normal;transform:translateY(-50%) !important;}.ibanxs-text-input input{color:#e5e5e5;padding:clamp(12px,3.5vw,14px) clamp(32px,9vw,40px) clamp(12px,3.5vw,14px) clamp(12px,4vw,16px);font-size:clamp(14px,4vw,16px);}.ibanxs-text-input.active label{display:none;}.field-validation-icon.correct{color:#a3e635;}.field-validation-icon.error{color:#5a5f5a !important;}.autocomplete-items{background:#1a1d1a;border:1px solid rgba(255,255,255,0.12);border-radius:12px;margin-top:4px;box-shadow:0 12px 30px rgba(0,0,0,0.4);}.ibanXS-main-container .autocomplete-items{overflow-x:hidden;}.ibanXS-main-container .autocomplete-items > div{background:#1a1d1a;color:#cfd2cf;border-bottom:1px solid rgba(255,255,255,0.06);}.ibanXS-main-container .autocomplete-items > div:hover{background:rgba(163,230,53,0.15) !important;}.ibanxs-submit-button{width:100% !important;box-sizing:border-box;background:#a3e635;color:#0a0e0a;border:none;border-radius:26px;padding:clamp(12px,3.5vw,14px);font-size:clamp(14px,4vw,16px);font-weight:700;transition:opacity .15s ease, transform .1s ease;}.ibanxs-submit-button:hover{opacity:0.92;}.ibanxs-submit-button:active{transform:scale(0.98) !important;}.main-form:has(#countryId:invalid) .ibanxs-submit-button,.main-form:has(#bankId:invalid) .ibanxs-submit-button{opacity:0.35;pointer-events:none;cursor:not-allowed;}.container{color:#e5e5e5;font-size:clamp(13px,3.5vw,14px);}.container input:not(:checked) ~ .ibanxs-checkbox-checkmark::after{display:none;}.container input:checked ~ .ibanxs-checkbox-checkmark{background:#a3e635;border-color:#a3e635;}.ibanxs-language-switch{position:absolute !important;top:clamp(10px,3vw,16px) !important;right:clamp(10px,3vw,16px) !important;background:#1a1d1a !important;border:1px solid rgba(255,255,255,0.12);border-radius:20px !important;color:#e5e5e5;padding:clamp(4px,1.5vw,6px) clamp(8px,3vw,12px);z-index:10;}.ibanxs-language-switch-list{background:#141714 !important;border:1px solid rgba(255,255,255,0.12);border-radius:12px;overflow:hidden;box-shadow:0 12px 30px rgba(0,0,0,0.4) !important;}.ibanxs-language-switch-list-element{padding:8px 12px !important;}.ibanxs-language-switch-list-element:hover{background:rgba(163,230,53,0.12) !important;}.MuiCircularProgress-svg{color:#a3e635 !important;}.MuiCircularProgress-svg circle{stroke:#a3e635 !important;}.ibanxs-transaction-information-field.ibanxs-error-field{min-width:0px;background-color:rgba(163,230,53,0.08);color:rgb(163,230,53);border:1px solid rgba(163,230,53,0.3);border-radius:8px;padding:clamp(12px,4vw,16px) clamp(14px,4vw,18px) !important;margin-top:28px;}.ibanxs-error-field svg{stroke:rgb(163,230,53);fill:rgb(163,230,53);flex-shrink:0;}.ibanxs-error-field a{color:rgb(163,230,53);}\"}', 'initiated', 'initiated', 'initiated', 'Bwire deposit', '2026-08-26 08:14:13', NULL, '7802b489-0af0-477f-be7e-0b5cb13ff427');

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.description AS description_2,
  s0_.password AS password_3,
  s0_.secret AS secret_4,
  s0_.active AS active_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7,
  s0_.billing_information_name AS billing_information_name_8,
  s0_.billing_information_country AS billing_information_country_9,
  s0_.billing_information_city AS billing_information_city_10,
  s0_.billing_information_street AS billing_information_street_11,
  s0_.billing_information_street_number AS billing_information_street_number_12,
  s0_.billing_information_postal_code AS billing_information_postal_code_13,
  s0_.billing_information_iban AS billing_information_iban_14,
  s0_.billing_information_is_bank_webhook AS billing_information_is_bank_webhook_15,
  s0_.payment_gateway_config_id AS payment_gateway_config_id_16,
  s0_.merchant_id AS merchant_id_17
FROM
  sites s0_
WHERE
  s0_.id = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.password AS password_3, s0_.secret AS secret_4, s0_.active AS active_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.billing_information_name AS billing_information_name_8, s0_.billing_information_country AS billing_information_country_9, s0_.billing_information_city AS billing_information_city_10, s0_.billing_information_street AS billing_information_street_11, s0_.billing_information_street_number AS billing_information_street_number_12, s0_.billing_information_postal_code AS billing_information_postal_code_13, s0_.billing_information_iban AS billing_information_iban_14, s0_.billing_information_is_bank_webhook AS billing_information_is_bank_webhook_15, s0_.payment_gateway_config_id AS payment_gateway_config_id_16, s0_.merchant_id AS merchant_id_17 FROM sites s0_ WHERE s0_.id = '7802b489-0af0-477f-be7e-0b5cb13ff427';

INSERT INTO payment_logs (payment_id, status_code, logs)
VALUES
  (?, ?, ?)

INSERT INTO payment_logs (payment_id, status_code, logs) VALUES ('c4d794d9-e6ad-4f1e-8bc8-84f0e0c8468c', 200, '\"{\\\"title\\\":\\\"Merchant requested for new payment\\\",\\\"details\\\":{\\\"paymentId\\\":\\\"k45zy3pboarqip7xvchzu94xdd_1\\\",\\\"amount\\\":12.34,\\\"currency\\\":\\\"EUR\\\",\\\"creditorName\\\":\\\"ZEPPLIN LTD\\\",\\\"creditorIban\\\":\\\"LT593420001000085727\\\",\\\"redirectUrl\\\":\\\"https:\\/\\/staging.bwire.io\\/payments\\/c4d794d9-e6ad-4f1e-8bc8-84f0e0c8468c\\\",\\\"paymentProvider\\\":\\\"ibanxs\\\"}}\"');

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 ('Fm6m5qh3drwWnuZGevXren2qWMXV9haR1ck41-zF3BY', 'O:25:\"Payum\\Core\\Model\\Identity\":2:{i:0;s:36:\"c4d794d9-e6ad-4f1e-8bc8-84f0e0c8468c\";i:1;s:32:\"App\\Domain\\Payment\\Model\\Payment\";}', NULL, 'https://staging.bwire.io/payments/c4d794d9-e6ad-4f1e-8bc8-84f0e0c8468c?payum_token=Fm6m5qh3drwWnuZGevXren2qWMXV9haR1ck41-zF3BY', 'zepllin_ltd');

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.password AS password_5,
  t0.role AS role_6,
  t0.payment_provider AS payment_provider_7,
  t0.active AS active_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  merchants t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.password AS password_5, t0.role AS role_6, t0.payment_provider AS payment_provider_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM merchants t0 WHERE t0.id = 'f45c9d36-19a8-45a0-bf06-f917478055c7';

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.id = ?

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.id = 'b18a64e0-5784-4401-8315-53257c2eb644';