Query Metrics
4
Database Queries
4
Different statements
65.73 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
49.98 ms (76.04%) |
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" ] |
|
7.56 ms (11.50%) |
1 |
SELECT e0_.id AS id_0, e0_.firstName AS firstName_1, e0_.lastName AS lastName_2, e0_.active AS active_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.user_id AS user_id_6, e0_.created_by_id AS created_by_id_7, e0_.updated_by_id AS updated_by_id_8 FROM employee e0_ WHERE e0_.user_id = ?
Parameters:
[
49240
]
|
|
5.68 ms (8.64%) |
1 |
SELECT c0_.id AS id_0, c0_.firstName AS firstName_1, c0_.lastName AS lastName_2, c0_.companyName AS companyName_3, c0_.email AS email_4, c0_.isWholesaler AS isWholesaler_5, c0_.active AS active_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.user_id AS user_id_9, c0_.created_by_id AS created_by_id_10, c0_.updated_by_id AS updated_by_id_11 FROM customer c0_ WHERE c0_.user_id = ?
Parameters:
[
49240
]
|
|
2.51 ms (3.82%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.salt AS salt_4, t0.email AS email_5, t0.name AS name_6, t0.roles AS roles_7, t0.verification_code AS verification_code_8, t0.is_verified AS is_verified_9, t0.is_active AS is_active_10 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"test@testuser.com"
]
|
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\Order\Entity\Cart |
|
| App\Core\Entity\Parameter | No errors. |
| App\Delivery\Entity\DeliveryZone | No errors. |
| App\Delivery\Entity\DeliverySchedule | No errors. |
| App\Stock\Entity\StockItem | No errors. |
| App\Stock\Entity\StockMovement | No errors. |
| App\Product\Entity\Product | No errors. |
| App\Employee\Entity\Employee | No errors. |
| App\Customer\Entity\StreetAddress | No errors. |
| App\Customer\Entity\BillingAddress | No errors. |
| App\Order\Entity\Order | No errors. |