Symfony Profiler

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

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
  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 = 'l6ndcx1wz83nr7zbbuocdo8u8dd_1231121' AND p0_.site_id = '297d4a3d-d5b8-41f2-b60e-a8f3c8864990';

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";

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 ('b70d70cd-b761-427a-a343-ad585307ff43', 'l6ndcx1wz83nr7zbbuocdo8u8dd_1231121', 'l6ndcxwz83nr7zbbuocdo8u8dd23', 100, 'EUR', 'https://hr.iglulabs.com/', 'https://google.com/', 'https://iglulabs.com/', 'https://bin.webhookrelay.com/v1/webhooks/5cd647fd-7c52-43ea-95fe-49aa29f7bd6e', '51e4ef9b1-9929-4fb0-86a3-689348f1871f212131', '{\"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\\/b70d70cd-b761-427a-a343-ad585307ff43\"}', 'initiated', 'initiated', 'initiated', 'l6ndcxwz83nr7zbbuocdo8u8dd23', NULL, '2026-10-23 15:01:16', NULL, '297d4a3d-d5b8-41f2-b60e-a8f3c8864990');

"COMMIT"

"COMMIT";

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'b70d70cd-b761-427a-a343-ad585307ff43''b70d70cd-b761-427a-a343-ad585307ff43'')
        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);;

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

"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 ('KA6_8BLNpeoKexOCaX4p050gsYs64kjA0n5qFE6I7Hc', 'O:25:\"Payum\\Core\\Model\\Identity\":2:{i:0;s:36:\"b70d70cd-b761-427a-a343-ad585307ff43\";i:1;s:32:\"App\\Domain\\Payment\\Model\\Payment\";}', NULL, 'https://staging.bwire.io/payments/b70d70cd-b761-427a-a343-ad585307ff43?payum_token=KA6_8BLNpeoKexOCaX4p050gsYs64kjA0n5qFE6I7Hc', 'livepoint_trading_ltd');

"COMMIT"

"COMMIT";

"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 ('ZTMFP2Ke_PjqNCZFuSSIl98mS9vtDO70_WhhSpTZQPI', 'O:25:\"Payum\\Core\\Model\\Identity\":2:{i:0;s:36:\"b70d70cd-b761-427a-a343-ad585307ff43\";i:1;s:32:\"App\\Domain\\Payment\\Model\\Payment\";}', 'https://staging.bwire.io/payments/b70d70cd-b761-427a-a343-ad585307ff43?payum_token=KA6_8BLNpeoKexOCaX4p050gsYs64kjA0n5qFE6I7Hc', 'https://staging.bwire.io/payment/capture/ZTMFP2Ke_PjqNCZFuSSIl98mS9vtDO70_WhhSpTZQPI', 'livepoint_trading_ltd');

"COMMIT"

"COMMIT";

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

INSERT INTO payment_logs (payment_id, status_code, logs) VALUES ('b70d70cd-b761-427a-a343-ad585307ff43', 200, '\"{\\\"title\\\":\\\"Merchant requested for new payment\\\",\\\"details\\\":{\\\"paymentId\\\":\\\"l6ndcx1wz83nr7zbbuocdo8u8dd_1231121\\\",\\\"amount\\\":1,\\\"currency\\\":\\\"EUR\\\",\\\"creditorName\\\":\\\"Livepoint Trading Ltd\\\",\\\"creditorIban\\\":\\\"PL92124049371831347560745013\\\",\\\"redirectUrl\\\":\\\"https:\\/\\/staging.bwire.io\\/payments\\/b70d70cd-b761-427a-a343-ad585307ff43\\\",\\\"paymentProvider\\\":\\\"ibanxs\\\"}}\"');