Query Metrics

8 Database Queries
5 Different statements
2.45 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.66 ms
SELECT DISTINCT o0_.id AS id_0 FROM `order` o0_ LIMIT 20
Parameters:
[]
2 0.29 ms
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.tracking_number AS tracking_number_2, o0_.data AS data_3, o0_.api_status AS api_status_4, o0_.status AS status_5, o0_.previous_status AS previous_status_6, o0_.weight AS weight_7, o0_.previous_weight AS previous_weight_8, o0_.size AS size_9, o0_.previous_size AS previous_size_10, o0_.tracking_barcode AS tracking_barcode_11, o0_.manifest_id AS manifest_id_12 FROM `order` o0_ WHERE o0_.id IN (?, ?, ?, ?)
Parameters:
[
  216
  217
  218
  219
]
3 0.22 ms
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_
Parameters:
[]
4 0.24 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.reference AS reference_3, t0.data AS data_4, t0.file AS file_5, t0.direction_type AS direction_type_6, t0.status_import AS status_import_7 FROM manifest t0 WHERE t0.id = ?
Parameters:
[
  213
]
5 0.32 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.item_description AS item_description_13, t0.parent_order_id AS parent_order_id_14 FROM order_item t0 WHERE t0.parent_order_id = ?
Parameters:
[
  216
]
6 0.26 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.item_description AS item_description_13, t0.parent_order_id AS parent_order_id_14 FROM order_item t0 WHERE t0.parent_order_id = ?
Parameters:
[
  217
]
7 0.25 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.item_description AS item_description_13, t0.parent_order_id AS parent_order_id_14 FROM order_item t0 WHERE t0.parent_order_id = ?
Parameters:
[
  218
]
8 0.22 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.item_description AS item_description_13, t0.parent_order_id AS parent_order_id_14 FROM order_item t0 WHERE t0.parent_order_id = ?
Parameters:
[
  219
]

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