GET https:///admin/order

Query Metrics

16 Database Queries
6 Different statements
8.88 ms Query time
0 Invalid entities
29 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.19 ms
(24.72%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.address AS address_4, t0.archived_at AS archived_at_5, t0.customer_id AS customer_id_6 FROM customer_unit t0 WHERE t0.id = ?
Parameters:
[
  "019ff1a5-3d5f-7b9a-969b-15fc75079e1c"
]
1.85 ms
(20.84%)
1
SELECT DISTINCT c0_.id AS id_0, c0_.service_date AS service_date_1, c0_.created_at AS created_at_2 FROM customer_order c0_ ORDER BY c0_.service_date DESC, c0_.created_at DESC LIMIT 20
Parameters:
[]
1.79 ms
(20.16%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.tax_id AS tax_id_4, t0.archived_at AS archived_at_5 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  "019ff1a5-3d5f-7b8a-969b-15fc74e505ba"
]
1.46 ms
(16.45%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  "019fe74c-e07f-7b19-9238-0660fb6839f2"
]
1.04 ms
(11.74%)
1
SELECT c0_.id AS id_0, c0_.service_date AS service_date_1, c0_.status AS status_2, c0_.exact_weight AS exact_weight_3, c0_.billable_weight AS billable_weight_4, c0_.calculated_billable_weight AS calculated_billable_weight_5, c0_.billable_weight_override AS billable_weight_override_6, c0_.transport_price_per_trip AS transport_price_per_trip_7, c0_.trip_count AS trip_count_8, c0_.price_per_kg AS price_per_kg_9, c0_.laundry_amount AS laundry_amount_10, c0_.additional_amount AS additional_amount_11, c0_.transport_amount AS transport_amount_12, c0_.total_amount AS total_amount_13, c0_.calculated_at AS calculated_at_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.version AS version_17, c0_.customer_unit_id AS customer_unit_id_18, c0_.tariff_id AS tariff_id_19, c0_.created_by_id AS created_by_id_20 FROM customer_order c0_ WHERE c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.service_date DESC, c0_.created_at DESC
Parameters:
[
  "019ff73f-4717-709e-bf15-9f5472e475ea"
  "019ff25e-1cfd-75f0-8280-5105cd282d8e"
  "019ff22e-9005-70c8-a934-326a5405a943"
  "019ff22a-bcbd-724e-bbdf-9319d1d3bd3a"
  "019ff1cf-b609-787f-83ca-6799c608147a"
  "019ff739-1127-70bd-ae06-61bce6a0f8ef"
  "019ff512-3812-732e-bfe7-68f3f5f0d518"
  "019ff50d-5748-7046-aa6f-46230ca3def0"
  "019ff23e-719e-7b93-84b6-c3efea3326af"
  "019ff220-5000-7bbe-b1a6-2920bc4d5864"
]
0.54 ms
(6.09%)
1
SELECT count(*) AS sclr_0 FROM customer_order c0_
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Order\Domain\Entity\Order 10
App\Customer\Domain\Entity\CustomerUnit 6
App\Tariff\Domain\Entity\Tariff 6
App\Customer\Domain\Entity\Customer 6
App\User\Domain\Entity\User 1