https://staging.bwire.io/api/payments

Query Metrics

16 Database Queries
10 Different statements
18.34 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.97 ms
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 = ?
Parameters:
[
  Symfony\Component\Uid\UuidV4 {#548
    __toString(): "7802b489-0af0-477f-be7e-0b5cb13ff427"
  }
]
2 1.02 ms
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 = ?
Parameters:
[
  "f45c9d36-19a8-45a0-bf06-f917478055c7"
]
3 1.70 ms
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 = ?
Parameters:
[
  "injukqh0ze8yfe5zbikvsittdd_1"
  Symfony\Component\Uid\UuidV4 {#613
    __toString(): "7802b489-0af0-477f-be7e-0b5cb13ff427"
  }
]
4 0.60 ms
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 = ?
Parameters:
[
  Symfony\Component\Uid\UuidV4 {#1378
    __toString(): "7802b489-0af0-477f-be7e-0b5cb13ff427"
  }
]
5 0.36 ms
"START TRANSACTION"
Parameters:
[]
6 2.86 ms
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "65689b06-bbce-40cb-b3a9-5313b02a00d6"
  "injukqh0ze8yfe5zbikvsittdd_1"
  "Bwire deposit"
  1234
  "EUR"
  "https://callback.dev.spini.ws/callback/90f002bf-6bc2-4b89-994e-a1ef6339e485-success_url"
  "https://callback.dev.spini.ws/callback/90f002bf-6bc2-4b89-994e-a1ef6339e485-fail_url"
  "https://callback.dev.spini.ws/callback/90f002bf-6bc2-4b89-994e-a1ef6339e485-pending_url"
  "https://dev.moneypit.dev/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\/65689b06-bbce-40cb-b3a9-5313b02a00d6","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 06:05:44"
  null
  "7802b489-0af0-477f-be7e-0b5cb13ff427"
]
7 1.05 ms
"COMMIT"
Parameters:
[]
8 2.17 ms
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);
Parameters:
[
  "34.88.155.202"
  null
  "65689b06-bbce-40cb-b3a9-5313b02a00d6"
  "65689b06-bbce-40cb-b3a9-5313b02a00d6"
  "34.88.155.202"
  null
]
9 0.69 ms
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 = ?
Parameters:
[
  "b18a64e0-5784-4401-8315-53257c2eb644"
]
10 0.40 ms
"START TRANSACTION"
Parameters:
[]
11 0.72 ms
INSERT INTO payment_tokens (hash, details, after_url, target_url, gateway_name) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "MvtxP2TW96g-nzzT1S4KjMD-dD1do3kRrJehEPR00i0"
  "O:25:"Payum\Core\Model\Identity":2:{i:0;s:36:"65689b06-bbce-40cb-b3a9-5313b02a00d6";i:1;s:32:"App\Domain\Payment\Model\Payment";}"
  null
  "https://staging.bwire.io/payments/65689b06-bbce-40cb-b3a9-5313b02a00d6?payum_token=MvtxP2TW96g-nzzT1S4KjMD-dD1do3kRrJehEPR00i0"
  "zepllin_ltd"
]
12 0.83 ms
"COMMIT"
Parameters:
[]
13 0.35 ms
"START TRANSACTION"
Parameters:
[]
14 1.45 ms
INSERT INTO payment_tokens (hash, details, after_url, target_url, gateway_name) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "O1Hu-dTNUDTvaNeBXmpuWmJ6P688rLYMWrQ0af6i54s"
  "O:25:"Payum\Core\Model\Identity":2:{i:0;s:36:"65689b06-bbce-40cb-b3a9-5313b02a00d6";i:1;s:32:"App\Domain\Payment\Model\Payment";}"
  "https://staging.bwire.io/payments/65689b06-bbce-40cb-b3a9-5313b02a00d6?payum_token=MvtxP2TW96g-nzzT1S4KjMD-dD1do3kRrJehEPR00i0"
  "https://staging.bwire.io/payment/capture/O1Hu-dTNUDTvaNeBXmpuWmJ6P688rLYMWrQ0af6i54s"
  "zepllin_ltd"
]
15 0.85 ms
"COMMIT"
Parameters:
[]
16 1.32 ms
INSERT INTO payment_logs (payment_id, status_code, logs) VALUES (?, ?, ?)
Parameters:
[
  Symfony\Component\Uid\UuidV4 {#1437
    __toString(): "65689b06-bbce-40cb-b3a9-5313b02a00d6"
  }
  200
  ""{\"title\":\"Merchant requested for new payment\",\"details\":{\"paymentId\":\"injukqh0ze8yfe5zbikvsittdd_1\",\"amount\":12.34,\"currency\":\"EUR\",\"creditorName\":\"ZEPPLIN LTD\",\"creditorIban\":\"LT593420001000085727\",\"redirectUrl\":\"https:\/\/staging.bwire.io\/payments\/65689b06-bbce-40cb-b3a9-5313b02a00d6\",\"paymentProvider\":\"ibanxs\"}}""
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Domain\Site\Model\BillingInformation No errors.
App\Domain\Site\Model\Site No errors.
App\Domain\PaymentGateway\Model\PaymentGatewayConfig No errors.
App\Domain\Merchant\Model\Merchant No errors.
App\Domain\Payment\Model\Payment
  • The field App\Domain\Payment\Model\Payment#userPaymentInfo is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\PaymentGateway\Model\UserPaymentInfo#payment does not contain the required 'inversedBy="userPaymentInfo"' attribute.
App\Domain\Merchant\Model\MerchantResetPasswordToken No errors.
App\Domain\Payment\Model\PaymentToken No errors.