Query Metrics
6
Database Queries
5
Different statements
10.17 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.45 ms (33.93%) |
1 |
SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.pisp_status AS pisp_status_2 FROM payments p0_ LEFT JOIN sites s1_ ON p0_.site_id = s1_.id LEFT JOIN payment_gateway_configs p2_ ON s1_.payment_gateway_config_id = p2_.id LEFT JOIN user_payment_info u3_ ON p0_.id = u3_.payment_id ORDER BY p0_.created_at DESC, pisp_status_2 DESC LIMIT 10
Parameters:
[] |
|
2.31 ms (22.72%) |
1 |
SELECT p0_.id || '' AS sclr_0, p0_.external_id || '' AS sclr_1, p0_.pisp_status AS pisp_status_2, p0_.bank_status AS bank_status_3, p0_.id AS id_4, p0_.amount AS amount_5, p0_.currency AS currency_6, p0_.created_at AS created_at_7, s1_.id AS id_8, s1_.name AS name_9, p2_.id AS id_10, p2_.factory_name AS factory_name_11, u3_.id AS id_12, u3_.ip_address AS ip_address_13, u3_.name AS name_14 FROM payments p0_ LEFT JOIN sites s1_ ON p0_.site_id = s1_.id LEFT JOIN payment_gateway_configs p2_ ON s1_.payment_gateway_config_id = p2_.id LEFT JOIN user_payment_info u3_ ON p0_.id = u3_.payment_id WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.created_at DESC, pisp_status_2 DESC
Parameters:
[ "f818697d-ecc9-43fb-8ea6-4bad29b3afb3" "f52abb71-f426-49d6-b4bb-8e7ef982d5fb" "23d2e501-9216-4f52-9a3e-06a47bde60a7" "ae246e74-a149-4e9b-b614-419ff24dd0cb" "2a45d2c7-9f8a-4389-8225-5ebaf7f05813" "e1428adf-82a3-49aa-a5a4-8576f4c0359b" "2b7ae719-0819-40cc-ba84-a969942da7fd" "7c6fb4c1-3a0a-4416-8f3c-07c50e40abe5" "b0ebd3fd-0687-4951-ae31-64df8fd53ca5" "d34cad1d-2c0c-4baf-a426-af0a5db3a0db" ] |
|
2.19 ms (21.57%) |
2 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM payments p0_ LEFT JOIN sites s1_ ON p0_.site_id = s1_.id LEFT JOIN payment_gateway_configs p2_ ON s1_.payment_gateway_config_id = p2_.id LEFT JOIN user_payment_info u3_ ON p0_.id = u3_.payment_id
Parameters:
[] |
|
1.60 ms (15.69%) |
1 |
SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.password AS password_2, a0_.role AS role_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6 FROM administrators a0_ WHERE a0_.email = ?
Parameters:
[
"admin@admin.com"
]
|
|
0.62 ms (6.09%) |
1 |
SHOW TIME ZONE
Parameters:
[] |
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\Administrator\Model\Administrator | No errors. |
| App\Domain\Payment\Model\Payment |
|
| App\Domain\Site\Model\BillingInformation | No errors. |
| App\Domain\Site\Model\Site | No errors. |
| App\Domain\PaymentGateway\Model\PaymentGatewayConfig | No errors. |
| App\Domain\PaymentGateway\Model\UserPaymentInfo | No errors. |