https://api.dev.talloverde.com/api/customers/49589/paymentMethods?q=%2Fapi%2Fcustomers%2F49589%2FpaymentMethods

Query Metrics

3 Database Queries
3 Different statements
29.12 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
27.80 ms
(95.44%)
1
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.salt AS salt_3, u0_.email AS email_4, u0_.name AS name_5, u0_.roles AS roles_6, u0_.verification_code AS verification_code_7, u0_.is_verified AS is_verified_8, u0_.is_active AS is_active_9 FROM users u0_ WHERE u0_.username = ? OR u0_.email = ?
Parameters:
[
  "test@testuser.com"
  "test@testuser.com"
]
0.73 ms
(2.50%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3 FROM payment_method t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  5
]
0.60 ms
(2.05%)
1
SELECT t0.id AS id_1, t0.firstName AS firstName_2, t0.lastName AS lastName_3, t0.companyName AS companyName_4, t0.email AS email_5, t0.isWholesaler AS isWholesaler_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  "49589"
]

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\Authentication\Entity\User No errors.
App\Customer\Entity\Customer No errors.
App\Customer\Entity\StreetAddress No errors.
App\Customer\Entity\BillingAddress No errors.
App\Order\Entity\Order No errors.
App\Payment\Entity\PaymentMethod No errors.
App\Payment\Entity\Payment No errors.
App\Payment\Entity\CashAccount No errors.
App\Payment\Entity\CashAccountMovement No errors.