Query Metrics

5 Database Queries
4 Different statements
22.16 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 6.61 ms
SELECT DISTINCT o0_.id AS id_0 FROM `order` o0_ LIMIT 20
Parameters:
[]
2 6.15 ms
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
  ]
]
3 3.93 ms
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_
Parameters:
[]
4 3.48 ms
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
]
5 2.00 ms
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:
[
  172
]

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.