GET https:///admin/order?filters%5Bstatus%5D%5Bcomparison%5D=%21%3D&filters%5Bstatus%5D%5Bvalue%5D=3

Query Metrics

10 Database Queries
6 Different statements
9.17 ms Query time
0 Invalid entities
13 Managed entities

Queries

Group similar statements

# Time Info
1 2.51 ms
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"
]
2 3.18 ms
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_ WHERE c0_.status <> (?) OR c0_.status IS NULL ORDER BY c0_.service_date DESC, c0_.created_at DESC LIMIT 20
Parameters:
[
  "cancelled"
]
3 0.79 ms
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_.status <> (?) OR c0_.status IS NULL) AND c0_.id IN (?, ?, ?) ORDER BY c0_.service_date DESC, c0_.created_at DESC
Parameters:
[
  "cancelled"
  "019ff512-3812-732e-bfe7-68f3f5f0d518"
  "019ff50d-5748-7046-aa6f-46230ca3def0"
  "019ff220-5000-7bbe-b1a6-2920bc4d5864"
]
4 0.46 ms
SELECT count(*) AS sclr_0 FROM customer_order c0_ WHERE c0_.status <> (?) OR c0_.status IS NULL
Parameters:
[
  "cancelled"
]
5 0.67 ms
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-7e9e-969b-15fc8d309a5e"
]
6 0.50 ms
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-7e8e-969b-15fc8c914f37"
]
7 0.31 ms
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-7c12-969b-15fc79b3e9e9"
]
8 0.26 ms
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-7aee-969b-15fc7202592b"
]
9 0.26 ms
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-3d60-7136-946b-628c18280598"
]
10 0.23 ms
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-3d60-7126-946b-628c17e2a592"
]

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 3
App\Customer\Domain\Entity\CustomerUnit 3
App\Tariff\Domain\Entity\Tariff 3
App\Customer\Domain\Entity\Customer 3
App\User\Domain\Entity\User 1