Query Metrics
5
Database Queries
4
Different statements
22.16 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.61 ms (29.83%) |
1 |
SELECT DISTINCT o0_.id AS id_0 FROM `order` o0_ LIMIT 20
Parameters:
[] |
6.15 ms (27.75%) |
1 |
SELECT o0_.id AS id_0, o0_.order_id AS order_id_1, o0_.date AS date_2, o0_.total AS total_3, o0_.payment_status AS payment_status_4, o0_.draft_order_link AS draft_order_link_5, o0_.shipping_cost AS shipping_cost_6, o0_.customer_id AS customer_id_7, o0_.hcp_id AS hcp_id_8 FROM `order` o0_ WHERE o0_.id IN (?)
Parameters:
[ [ 268 269 270 271 272 273 274 275 276 277 278 279 ] ] |
5.47 ms (24.70%) |
2 |
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.name AS name_3, t0.email AS email_4, t0.hcp_id AS hcp_id_5 FROM customer t0 WHERE t0.id = ?
Parameters:
[
173
]
|
3.93 ms (17.72%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_
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\Entity\Order | No errors. |
App\Entity\Customer | No errors. |
App\Entity\Hcp | No errors. |
App\Entity\OrderItem | No errors. |