Query Metrics
3
Database Queries
3
Different statements
29.12 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 27.80 ms |
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" ] |
| 2 | 0.60 ms |
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"
]
|
| 3 | 0.73 ms |
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
]
|
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. |