https://staging.bwire.io/admin/payments/?_=1769070413960&columns%5B0%5D%5Bdata%5D=internalId&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=externalId&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=site.name&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=site.paymentGatewayConfig.factoryName&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=userPaymentInfo.ipAddress&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=userPaymentInfo.name&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=true&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=pispStatus&columns%5B6%5D%5Bname%5D=&columns%5B6%5D%5Bsearchable%5D=true&columns%5B6%5D%5Borderable%5D=true&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B7%5D%5Bdata%5D=bankStatus&columns%5B7%5D%5Bname%5D=&columns%5B7%5D%5Bsearchable%5D=true&columns%5B7%5D%5Borderable%5D=true&columns%5B7%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B7%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B8%5D%5Bdata%5D=amount&columns%5B8%5D%5Bname%5D=&columns%5B8%5D%5Bsearchable%5D=false&columns%5B8%5D%5Borderable%5D=true&columns%5B8%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B8%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B9%5D%5Bdata%5D=currency&columns%5B9%5D%5Bname%5D=&columns%5B9%5D%5Bsearchable%5D=true&columns%5B9%5D%5Borderable%5D=true&columns%5B9%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B9%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B10%5D%5Bdata%5D=createdAt&columns%5B10%5D%5Bname%5D=&columns%5B10%5D%5Bsearchable%5D=true&columns%5B10%5D%5Borderable%5D=true&columns%5B10%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B10%5D%5Bsearch%5D%5Bregex%5D=false&draw=1&length=10&order%5B0%5D%5Bcolumn%5D=6&order%5B0%5D%5Bdir%5D=desc&search%5Bvalue%5D=&search%5Bregex%5D=false&start=0&tz=Asia%2FCalcutta

Query Metrics

6 Database Queries
5 Different statements
10.17 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

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
  • 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\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.