Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

16 Database Queries

10 Different statements

16.61 ms Query time

1 Invalid entities

Queries

Group similar statements


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 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 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 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 = ?
"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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"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);
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 = ?
"START TRANSACTION"
INSERT INTO payment_tokens (hash, details, after_url, target_url, gateway_name) VALUES (?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO payment_tokens (hash, details, after_url, target_url, gateway_name) VALUES (?, ?, ?, ?, ?)
"COMMIT"
INSERT INTO payment_logs (payment_id, status_code, logs) VALUES (?, ?, ?)

#▲	Time	Info
1	1.53 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 {#560 __toString(): "297d4a3d-d5b8-41f2-b60e-a8f3c8864990" }`] View formatted query View runnable query 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';
2	0.89 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: [`"e97c9e1a-5829-4977-939f-a5921ea8f47c"`] View formatted query View runnable query Explain query 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';
3	1.88 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_.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 = ? Parameters: [`"l6ndcxwz83nr7zbbuocdo8u8dd_1231121" Symfony\Component\Uid\UuidV4 {#546 __toString(): "297d4a3d-d5b8-41f2-b60e-a8f3c8864990" }`] View formatted query View runnable query 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_1231121' AND p0_.site_id = '297d4a3d-d5b8-41f2-b60e-a8f3c8864990';
4	0.77 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 {#1509 __toString(): "297d4a3d-d5b8-41f2-b60e-a8f3c8864990" }`] View formatted query View runnable query 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';
5	0.36 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
6	2.19 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, payment_type, created_at, updated_at, site_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["14016d68-5b53-41a1-b30e-53c8a88aa08c" "l6ndcxwz83nr7zbbuocdo8u8dd_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" "51e4ef9b-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\/14016d68-5b53-41a1-b30e-53c8a88aa08c","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:00:10" null "297d4a3d-d5b8-41f2-b60e-a8f3c8864990"] View formatted query View runnable query Explain query 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 ('14016d68-5b53-41a1-b30e-53c8a88aa08c', 'l6ndcxwz83nr7zbbuocdo8u8dd_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', '51e4ef9b-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\\/14016d68-5b53-41a1-b30e-53c8a88aa08c\",\"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:00:10', NULL, '297d4a3d-d5b8-41f2-b60e-a8f3c8864990');
7	0.99 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
8	2.89 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: [`"49.205.38.85" null "14016d68-5b53-41a1-b30e-53c8a88aa08c" "14016d68-5b53-41a1-b30e-53c8a88aa08c" "49.205.38.85" null`] View formatted query View runnable query Explain query 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'14016d68-5b53-41a1-b30e-53c8a88aa08c''14016d68-5b53-41a1-b30e-53c8a88aa08c'') 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);;
9	0.68 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: [`"9fc2fe75-b87d-43e5-93d2-740916a7a409"`] View formatted query View runnable query Explain query 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';
10	0.37 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
11	0.68 ms	INSERT INTO payment_tokens (hash, details, after_url, target_url, gateway_name) VALUES (?, ?, ?, ?, ?) Parameters: [`"kzDGOZ8kE1L2mXkJj3DYJPQPXYrs7RGOHOkA3aSsG7s" "O:25:"Payum\Core\Model\Identity":2:{i:0;s:36:"14016d68-5b53-41a1-b30e-53c8a88aa08c";i:1;s:32:"App\Domain\Payment\Model\Payment";}" null "https://staging.bwire.io/payments/14016d68-5b53-41a1-b30e-53c8a88aa08c?payum_token=kzDGOZ8kE1L2mXkJj3DYJPQPXYrs7RGOHOkA3aSsG7s" "livepoint_trading_ltd"`] View formatted query View runnable query Explain query 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 ('kzDGOZ8kE1L2mXkJj3DYJPQPXYrs7RGOHOkA3aSsG7s', 'O:25:\"Payum\\Core\\Model\\Identity\":2:{i:0;s:36:\"14016d68-5b53-41a1-b30e-53c8a88aa08c\";i:1;s:32:\"App\\Domain\\Payment\\Model\\Payment\";}', NULL, 'https://staging.bwire.io/payments/14016d68-5b53-41a1-b30e-53c8a88aa08c?payum_token=kzDGOZ8kE1L2mXkJj3DYJPQPXYrs7RGOHOkA3aSsG7s', 'livepoint_trading_ltd');
12	0.69 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
13	0.31 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
14	0.45 ms	INSERT INTO payment_tokens (hash, details, after_url, target_url, gateway_name) VALUES (?, ?, ?, ?, ?) Parameters: [`"7gr9Z2Kgv_l6Qw6rAHa17EheHp_t9kfwDPAqKbFLXvA" "O:25:"Payum\Core\Model\Identity":2:{i:0;s:36:"14016d68-5b53-41a1-b30e-53c8a88aa08c";i:1;s:32:"App\Domain\Payment\Model\Payment";}" "https://staging.bwire.io/payments/14016d68-5b53-41a1-b30e-53c8a88aa08c?payum_token=kzDGOZ8kE1L2mXkJj3DYJPQPXYrs7RGOHOkA3aSsG7s" "https://staging.bwire.io/payment/capture/7gr9Z2Kgv_l6Qw6rAHa17EheHp_t9kfwDPAqKbFLXvA" "livepoint_trading_ltd"`] View formatted query View runnable query Explain query 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 ('7gr9Z2Kgv_l6Qw6rAHa17EheHp_t9kfwDPAqKbFLXvA', 'O:25:\"Payum\\Core\\Model\\Identity\":2:{i:0;s:36:\"14016d68-5b53-41a1-b30e-53c8a88aa08c\";i:1;s:32:\"App\\Domain\\Payment\\Model\\Payment\";}', 'https://staging.bwire.io/payments/14016d68-5b53-41a1-b30e-53c8a88aa08c?payum_token=kzDGOZ8kE1L2mXkJj3DYJPQPXYrs7RGOHOkA3aSsG7s', 'https://staging.bwire.io/payment/capture/7gr9Z2Kgv_l6Qw6rAHa17EheHp_t9kfwDPAqKbFLXvA', 'livepoint_trading_ltd');
15	0.80 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
16	1.11 ms	INSERT INTO payment_logs (payment_id, status_code, logs) VALUES (?, ?, ?) Parameters: [`Symfony\Component\Uid\UuidV4 {#1575 __toString(): "14016d68-5b53-41a1-b30e-53c8a88aa08c" } 200 ""{\"title\":\"Merchant requested for new payment\",\"details\":{\"paymentId\":\"l6ndcxwz83nr7zbbuocdo8u8dd_1231121\",\"amount\":1,\"currency\":\"EUR\",\"creditorName\":\"Livepoint Trading Ltd\",\"creditorIban\":\"PL92124049371831347560745013\",\"redirectUrl\":\"https:\/\/staging.bwire.io\/payments\/14016d68-5b53-41a1-b30e-53c8a88aa08c\",\"paymentProvider\":\"ibanxs\"}}""`] View formatted query View runnable query INSERT INTO payment_logs (payment_id, status_code, logs) VALUES (?, ?, ?) INSERT INTO payment_logs (payment_id, status_code, logs) VALUES ('14016d68-5b53-41a1-b30e-53c8a88aa08c', 200, '\"{\\\"title\\\":\\\"Merchant requested for new payment\\\",\\\"details\\\":{\\\"paymentId\\\":\\\"l6ndcxwz83nr7zbbuocdo8u8dd_1231121\\\",\\\"amount\\\":1,\\\"currency\\\":\\\"EUR\\\",\\\"creditorName\\\":\\\"Livepoint Trading Ltd\\\",\\\"creditorIban\\\":\\\"PL92124049371831347560745013\\\",\\\"redirectUrl\\\":\\\"https:\\/\\/staging.bwire.io\\/payments\\/14016d68-5b53-41a1-b30e-53c8a88aa08c\\\",\\\"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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping