Symfony Profiler

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_.payment_type AS payment_type_15,
  p0_.created_at AS created_at_16,
  p0_.updated_at AS updated_at_17,
  p0_.site_id AS site_id_18
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_.payment_type AS payment_type_15, p0_.created_at AS created_at_16, p0_.updated_at AS updated_at_17, p0_.site_id AS site_id_18 FROM payments p0_ WHERE p0_.external_id = 'l6ndcxwz83nr7zbbuocdo8u8dd_1231121111' AND p0_.site_id = '297d4a3d-d5b8-41f2-b60e-a8f3c8864990';

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('49.205.38.85', ip_address),
            name       = COALESCE(NULL, name),
            updated_at = to_char(now(), 'YYYY-MM-DD"T"HH24'd5a83a08-25f9-46ad-b51d-0ac552092a87''d5a83a08-25f9-46ad-b51d-0ac552092a87'')
        WHERE id = (
            SELECT id
            FROM user_payment_info
            WHERE payment_id = '49.205.38.85'
            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);;

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

INSERT INTO payment_logs (payment_id, status_code, logs) VALUES ('d5a83a08-25f9-46ad-b51d-0ac552092a87', 200, '\"{\\\"title\\\":\\\"Merchant requested for new payment\\\",\\\"details\\\":{\\\"paymentId\\\":\\\"l6ndcxwz83nr7zbbuocdo8u8dd_1231121111\\\",\\\"amount\\\":1,\\\"currency\\\":\\\"EUR\\\",\\\"creditorName\\\":\\\"Livepoint Trading Ltd\\\",\\\"creditorIban\\\":\\\"PL92124049371831347560745013\\\",\\\"redirectUrl\\\":\\\"https:\\/\\/staging.bwire.io\\/payments\\/d5a83a08-25f9-46ad-b51d-0ac552092a87\\\",\\\"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 ('5i2p9uDmx861l4XN1hbz1-fZsEFwtXpc0s0eHFulYz0', '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/payments/d5a83a08-25f9-46ad-b51d-0ac552092a87?payum_token=5i2p9uDmx861l4XN1hbz1-fZsEFwtXpc0s0eHFulYz0', 'livepoint_trading_ltd');

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, payment_type, 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, payment_type, created_at, updated_at, site_id) VALUES ('d5a83a08-25f9-46ad-b51d-0ac552092a87', 'l6ndcxwz83nr7zbbuocdo8u8dd_1231121111', 'l6ndcxwz83nr7zbbuocdo8u8dd23', 100, 'EUR', 'https://hr.iglulabs.com/', 'https://google.com/', 'https://iglulabs.com/', 'https://bin.webhookrelay.com/v1/webhooks/5cd647fd-7c52-43ea-95fe-49aa29f7bd6e', '51e4ef9b-9929-4fb0-86a3-689348f1871f212111131', '{\"backgroundImageUrl\":\"https:\\/\\/app.bwire.io\\/static\\/bg.jpg\",\"logoImageUrl\":\"https:\\/\\/app.bwire.io\\/static\\/logo.png\",\"creditorName\":\"Livepoint Trading Ltd\",\"creditorStreet\":\"Mickiewicza\",\"creditorStreetNumber\":\"19a\",\"creditorCity\":\"Strovolos\",\"creditorPostalCode\":\"11-111\",\"creditorCountry\":\"PL\",\"creditorIban\":\"PL92124049371831347560745013\",\"redirectUrl\":\"https:\\/\\/staging.bwire.io\\/payments\\/d5a83a08-25f9-46ad-b51d-0ac552092a87\",\"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; } }\"}', 'initiated', 'initiated', 'initiated', 'l6ndcxwz83nr7zbbuocdo8u8dd23', NULL, '2026-10-23 15:06:37', NULL, '297d4a3d-d5b8-41f2-b60e-a8f3c8864990');

"COMMIT"

"COMMIT";

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 = '297d4a3d-d5b8-41f2-b60e-a8f3c8864990';

"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 = 'e97c9e1a-5829-4977-939f-a5921ea8f47c';

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 = '9fc2fe75-b87d-43e5-93d2-740916a7a409';