https://staging.bwire.io/payment/capture/yVb5PQwn02kZEB-0JG0S0mJiQBHevxJuCaEH5Z_TjcI

Query Metrics

4 Database Queries
4 Different statements
9.57 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
3.90 ms
(40.76%)
1
SELECT t0.hash AS hash_1, t0.details AS details_2, t0.after_url AS after_url_3, t0.target_url AS target_url_4, t0.gateway_name AS gateway_name_5 FROM payment_tokens t0 WHERE t0.hash = ?
Parameters:
[
  "yVb5PQwn02kZEB-0JG0S0mJiQBHevxJuCaEH5Z_TjcI"
]
2.62 ms
(27.36%)
1
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_.id = ?
Parameters:
[
  Symfony\Component\Uid\UuidV4 {#1305
    __toString(): "42fea0ac-f660-47c1-87fd-4e62e3441c51"
  }
]
1.97 ms
(20.61%)
1
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.description AS description_3, t0.amount AS amount_4, t0.currency AS currency_5, t0.success_url AS success_url_6, t0.failure_url AS failure_url_7, t0.pending_url AS pending_url_8, t0.notification_url AS notification_url_9, t0.customer_id AS customer_id_10, t0.details AS details_11, t0.status AS status_12, t0.pisp_status AS pisp_status_13, t0.bank_status AS bank_status_14, t0.mapping_id AS mapping_id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t18.id AS id_19, t18.ip_address AS ip_address_20, t18.name AS name_21, t18.created_at AS created_at_22, t18.updated_at AS updated_at_23, t18.payment_id AS payment_id_24, t0.site_id AS site_id_25 FROM payments t0 LEFT JOIN user_payment_info t18 ON t18.payment_id = t0.id WHERE t0.id = ?
Parameters:
[
  "42fea0ac-f660-47c1-87fd-4e62e3441c51"
]
1.08 ms
(11.28%)
1
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.gateway_name = ?
Parameters:
[
  "power_of_one_hour"
]

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\Payment\Model\PaymentToken No errors.
App\Domain\PaymentGateway\Model\PaymentGatewayConfig 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\PaymentGateway\Model\UserPaymentInfo No errors.
App\Domain\Site\Model\BillingInformation No errors.
App\Domain\Site\Model\Site No errors.