Query Metrics
96
Database Queries
6
Different statements
117.99 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.96 ms |
SELECT t0.token AS token_1, t0.expire AS expire_2, t0.lifetime AS lifetime_3, t0.user_id AS user_id_4, t0.tablet_id AS tablet_id_5 FROM api_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
"7b400796b66145700a155511240366fd897ac53a00e336fa3b58859894ed79d5"
]
|
| 2 | 0.59 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.status AS status_5, t0.deleted AS deleted_6 FROM `user` t0 WHERE t0.id = ? AND ((t0.deleted IS NULL))
Parameters:
[
17
]
|
| 3 | 56.25 ms |
SELECT d0_.id AS id_0, d0_.hash AS hash_1, d0_.status AS status_2, d0_.weight AS weight_3, d0_.extra AS extra_4, d0_.weeknumber AS weeknumber_5, d0_.flags AS flags_6, a1_.id AS id_7, a1_.company AS company_8, a1_.responsible_person AS responsible_person_9, a1_.address AS address_10, a1_.city AS city_11, a1_.postalcode AS postalcode_12, a1_.country AS country_13, a1_.latitude AS latitude_14, a1_.longitude AS longitude_15, a1_.nav_latitude AS nav_latitude_16, a1_.nav_longitude AS nav_longitude_17, ST_AsBinary(a1_.point) AS point_18, d0_.address_id AS address_id_19, d0_.src_address_id AS src_address_id_20 FROM delivery_collection d0_ INNER JOIN address a1_ ON d0_.address_id = a1_.id WHERE d0_.status = ? ORDER BY d0_.id ASC LIMIT 100 OFFSET 700
Parameters:
[
"open"
]
|
| 4 | 0.96 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"efce2be0-cd1e-4803-a2bb-96010fa662ff"
]
|
| 5 | 0.48 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f0006917-2b62-46cc-b104-3abbeb01e2b4"
]
|
| 6 | 0.51 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f0514131-45e0-4fce-9d81-0d0f72ee962c"
]
|
| 7 | 0.47 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f0a80c98-83f9-4704-a9f6-132071b2353a"
]
|
| 8 | 0.45 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f17cdaff-73a8-4fa2-8f54-0399f22a10db"
]
|
| 9 | 0.47 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f23783c1-fa36-4fd1-8b0c-7f89053c7659"
]
|
| 10 | 0.45 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f2cfac03-e1cb-4a3b-a248-8f2870d6faa5"
]
|
| 11 | 0.46 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f3537640-faf9-4cbe-80e2-07ab4d470c91"
]
|
| 12 | 0.40 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f363a371-440d-4871-ab6e-1d815a59d2ab"
]
|
| 13 | 0.40 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f3940190-b4c4-44f9-86bb-15549527c6a6"
]
|
| 14 | 0.44 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f3bbb702-c950-4f27-b98f-cc69a466fa60"
]
|
| 15 | 0.55 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f4132865-a651-45fc-a912-570c309e036e"
]
|
| 16 | 0.45 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f4780274-3ebf-42de-ba7d-12fffc729d45"
]
|
| 17 | 0.38 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f4c51711-7bf3-430a-aaa9-1503995c81f6"
]
|
| 18 | 0.36 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f5b41273-083a-434e-af18-ebaea12d6e5e"
]
|
| 19 | 0.38 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f5f29da5-719a-4e74-8ea4-00a0f285bab1"
]
|
| 20 | 0.38 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f725fd4e-cbe5-4011-81cc-4af6b8c83aa6"
]
|
| 21 | 0.45 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f7641733-afba-4ab4-a561-1e03b4c9ba3a"
]
|
| 22 | 0.42 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f7f76937-0a39-4e95-a997-574415647b0c"
]
|
| 23 | 0.46 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f861527f-7875-4212-8075-f132b43da4b0"
]
|
| 24 | 0.49 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f86ceabc-3eaf-4017-8250-bed7530b567d"
]
|
| 25 | 0.42 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f8a8a06f-a8f8-4c38-81c0-084fbeda9ade"
]
|
| 26 | 0.42 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f8d2e23e-6dd8-4d54-800e-5678fd839e05"
]
|
| 27 | 0.38 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f9346e22-b585-4b85-bd30-fea4dc1f7f88"
]
|
| 28 | 0.36 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f9aca21d-111f-4b83-afb8-b30d5a4ba4f8"
]
|
| 29 | 0.36 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"f9fce64f-7d10-4d9d-a0a4-1e85547bf353"
]
|
| 30 | 0.45 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"fa244418-4c46-49be-95b6-f725727f0038"
]
|
| 31 | 0.35 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"fa453e4b-e269-4c9c-ab4a-66d989294cdc"
]
|
| 32 | 0.38 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"faaab68b-c9b7-45a5-b25f-82c90dc0aa8d"
]
|
| 33 | 0.41 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"faeae26c-a407-49c3-b3a1-c794051784e3"
]
|
| 34 | 0.36 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"fb9a1334-8e70-4e20-a568-8746210e610f"
]
|
| 35 | 0.37 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"fc16a931-2bb2-4b9e-af6b-7b86e862d38c"
]
|
| 36 | 0.36 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"fc3d2719-17d9-4a42-87b0-5f54b2b0337b"
]
|
| 37 | 0.37 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"fcc690fc-6247-4623-8a50-d41293cc1fee"
]
|
| 38 | 0.35 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"fd124150-69c7-44c2-ad2c-5e1f9f7f88d2"
]
|
| 39 | 0.37 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"fd5c73e2-b4fa-42f6-aec1-f91210a3957f"
]
|
| 40 | 0.40 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"fd6bb3fd-446c-433e-bc2d-69d6a150c34d"
]
|
| 41 | 0.35 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"fd6f9783-1205-492a-8f1a-a14a7930425d"
]
|
| 42 | 0.39 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"fe0d08a5-0d7a-45c2-9601-92a7e0ae6a00"
]
|
| 43 | 0.38 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"fe2b6b81-8325-4f4e-97ae-c375b2e46cf7"
]
|
| 44 | 0.39 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"fe6ea2d6-e909-4a55-b76e-ced11cc533e0"
]
|
| 45 | 0.37 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"feb5c006-f543-4b44-8bcc-a5b2b3c6478d"
]
|
| 46 | 0.36 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"feeb3f21-a923-4853-8bf9-18d52b4105f7"
]
|
| 47 | 0.36 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"ff492b93-a883-4b88-ad24-f40fe0a1efe2"
]
|
| 48 | 0.36 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"ffb98120-4d73-4d93-9ea3-832e1049bc5e"
]
|
| 49 | 0.37 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.travel_time AS travel_time_3, t0.travel_distance AS travel_distance_4, t0.type AS type_5, t0.routing AS routing_6, t0.start_time AS start_time_7, t0.delivery_duration AS delivery_duration_8, t0.extra AS extra_9, t0.notice AS notice_10, t0.route_id AS route_id_11, t0.day_id AS day_id_12, t0.location_id AS location_id_13, t0.collection_id AS collection_id_14 FROM route_element t0 WHERE t0.collection_id = ?
Parameters:
[
"ffe84e40-0a50-4ea7-91c9-2d50524424bc"
]
|
| 50 | 0.73 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"efce2be0-cd1e-4803-a2bb-96010fa662ff"
]
|
| 51 | 0.56 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f0006917-2b62-46cc-b104-3abbeb01e2b4"
]
|
| 52 | 0.53 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f0514131-45e0-4fce-9d81-0d0f72ee962c"
]
|
| 53 | 0.49 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f0a80c98-83f9-4704-a9f6-132071b2353a"
]
|
| 54 | 0.50 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f17cdaff-73a8-4fa2-8f54-0399f22a10db"
]
|
| 55 | 0.48 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f23783c1-fa36-4fd1-8b0c-7f89053c7659"
]
|
| 56 | 0.49 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f2cfac03-e1cb-4a3b-a248-8f2870d6faa5"
]
|
| 57 | 0.49 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f3537640-faf9-4cbe-80e2-07ab4d470c91"
]
|
| 58 | 0.47 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f363a371-440d-4871-ab6e-1d815a59d2ab"
]
|
| 59 | 0.47 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f3940190-b4c4-44f9-86bb-15549527c6a6"
]
|
| 60 | 0.64 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f3bbb702-c950-4f27-b98f-cc69a466fa60"
]
|
| 61 | 0.64 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f4132865-a651-45fc-a912-570c309e036e"
]
|
| 62 | 0.63 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f4780274-3ebf-42de-ba7d-12fffc729d45"
]
|
| 63 | 0.59 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f4c51711-7bf3-430a-aaa9-1503995c81f6"
]
|
| 64 | 0.60 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f5b41273-083a-434e-af18-ebaea12d6e5e"
]
|
| 65 | 0.59 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f5f29da5-719a-4e74-8ea4-00a0f285bab1"
]
|
| 66 | 0.66 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f725fd4e-cbe5-4011-81cc-4af6b8c83aa6"
]
|
| 67 | 0.64 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f7641733-afba-4ab4-a561-1e03b4c9ba3a"
]
|
| 68 | 0.60 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f7f76937-0a39-4e95-a997-574415647b0c"
]
|
| 69 | 0.55 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f861527f-7875-4212-8075-f132b43da4b0"
]
|
| 70 | 0.60 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f86ceabc-3eaf-4017-8250-bed7530b567d"
]
|
| 71 | 0.51 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f8a8a06f-a8f8-4c38-81c0-084fbeda9ade"
]
|
| 72 | 0.50 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f8d2e23e-6dd8-4d54-800e-5678fd839e05"
]
|
| 73 | 0.51 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f9346e22-b585-4b85-bd30-fea4dc1f7f88"
]
|
| 74 | 0.49 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f9aca21d-111f-4b83-afb8-b30d5a4ba4f8"
]
|
| 75 | 0.46 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"f9fce64f-7d10-4d9d-a0a4-1e85547bf353"
]
|
| 76 | 0.49 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"fa244418-4c46-49be-95b6-f725727f0038"
]
|
| 77 | 0.48 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"fa453e4b-e269-4c9c-ab4a-66d989294cdc"
]
|
| 78 | 0.46 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"faaab68b-c9b7-45a5-b25f-82c90dc0aa8d"
]
|
| 79 | 0.48 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"faeae26c-a407-49c3-b3a1-c794051784e3"
]
|
| 80 | 0.45 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"fb9a1334-8e70-4e20-a568-8746210e610f"
]
|
| 81 | 0.47 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"fc16a931-2bb2-4b9e-af6b-7b86e862d38c"
]
|
| 82 | 0.48 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"fc3d2719-17d9-4a42-87b0-5f54b2b0337b"
]
|
| 83 | 0.48 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"fcc690fc-6247-4623-8a50-d41293cc1fee"
]
|
| 84 | 0.52 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"fd124150-69c7-44c2-ad2c-5e1f9f7f88d2"
]
|
| 85 | 0.47 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"fd5c73e2-b4fa-42f6-aec1-f91210a3957f"
]
|
| 86 | 0.49 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"fd6bb3fd-446c-433e-bc2d-69d6a150c34d"
]
|
| 87 | 0.49 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"fd6f9783-1205-492a-8f1a-a14a7930425d"
]
|
| 88 | 0.49 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"fe0d08a5-0d7a-45c2-9601-92a7e0ae6a00"
]
|
| 89 | 0.49 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"fe2b6b81-8325-4f4e-97ae-c375b2e46cf7"
]
|
| 90 | 0.51 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"fe6ea2d6-e909-4a55-b76e-ced11cc533e0"
]
|
| 91 | 0.51 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"feb5c006-f543-4b44-8bcc-a5b2b3c6478d"
]
|
| 92 | 0.49 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"feeb3f21-a923-4853-8bf9-18d52b4105f7"
]
|
| 93 | 0.48 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"ff492b93-a883-4b88-ad24-f40fe0a1efe2"
]
|
| 94 | 0.46 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"ffb98120-4d73-4d93-9ea3-832e1049bc5e"
]
|
| 95 | 0.47 ms |
SELECT t0.id AS id_1, t0.planned AS planned_2, t0.order_id AS order_id_3, t0.ordertext AS ordertext_4, t0.planned_date AS planned_date_5, t0.planned_time AS planned_time_6, t0.delivery_duration AS delivery_duration_7, t0.payload_weight AS payload_weight_8, t0.notice AS notice_9, t0.status AS status_10, t0.done_date AS done_date_11, t0.done_time AS done_time_12, t0.order_date AS order_date_13, t0.extra_text AS extra_text_14, t0.customer AS customer_15, t0.money AS money_16, t0.payment_type AS payment_type_17, t0.phone AS phone_18, t0.weeknumber AS weeknumber_19, t0.flags AS flags_20, t0.url AS url_21, t0.not_merge_to_container AS not_merge_to_container_22, t0.single_delivery_information AS single_delivery_information_23, t0.phone2 AS phone2_24, t0.delivery_notice AS delivery_notice_25, t0.balance AS balance_26, t0.invoice_number AS invoice_number_27, t0.vehicle_id AS vehicle_id_28, t0.dest_address_id AS dest_address_id_29, t0.source_address_id AS source_address_id_30, t0.collection_id AS collection_id_31 FROM delivery t0 WHERE t0.collection_id = ? ORDER BY t0.order_id ASC
Parameters:
[
"ffe84e40-0a50-4ea7-91c9-2d50524424bc"
]
|
| 96 | 15.86 ms |
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM delivery_collection d0_ INNER JOIN address a1_ ON d0_.address_id = a1_.id WHERE d0_.status = ?
Parameters:
[
"open"
]
|
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\DeliveryCollection | No errors. |
| App\Entity\ApiToken | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Tablet | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\Delivery | No errors. |
| App\Entity\RouteElement | No errors. |
| App\Entity\Route | No errors. |
| App\Entity\RouteDay | No errors. |
| App\Entity\Location | No errors. |
| App\Entity\Vehicle | No errors. |