Query Metrics
4
Database Queries
4
Different statements
9.57 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.90 ms |
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 | 1.08 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.gateway_name = ?
Parameters:
[
"power_of_one_hour"
]
|
| 3 | 1.97 ms |
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"
]
|
| 4 | 2.62 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_.id = ?
Parameters:
[ Symfony\Component\Uid\UuidV4 {#1305 : "42fea0ac-f660-47c1-87fd-4e62e3441c51" } ] |
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 |
|
| App\Domain\PaymentGateway\Model\UserPaymentInfo | No errors. |
| App\Domain\Site\Model\BillingInformation | No errors. |
| App\Domain\Site\Model\Site | No errors. |