Query Metrics

7 Database Queries
3 Different statements
14.37 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.89 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_
Parameters:
[]
2 2.84 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.name AS name_3, t0.price AS price_4, t0.quantity AS quantity_5, t0.order_parent_id AS order_parent_id_6 FROM order_item t0 WHERE t0.order_parent_id = ?
Parameters:
[
  268
]
3 2.97 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
]
4 1.51 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.name AS name_3, t0.price AS price_4, t0.quantity AS quantity_5, t0.order_parent_id AS order_parent_id_6 FROM order_item t0 WHERE t0.order_parent_id = ?
Parameters:
[
  269
]
5 1.42 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.name AS name_3, t0.price AS price_4, t0.quantity AS quantity_5, t0.order_parent_id AS order_parent_id_6 FROM order_item t0 WHERE t0.order_parent_id = ?
Parameters:
[
  270
]
6 1.46 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
]
7 1.28 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.name AS name_3, t0.price AS price_4, t0.quantity AS quantity_5, t0.order_parent_id AS order_parent_id_6 FROM order_item t0 WHERE t0.order_parent_id = ?
Parameters:
[
  271
]

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\OrderItem No errors.
App\Entity\Customer No errors.
App\Entity\Hcp No errors.