Symfony Profiler

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

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 = 'open' ORDER BY d0_.id ASC LIMIT 100 OFFSET 700;

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

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 = 'efce2be0-cd1e-4803-a2bb-96010fa662ff' ORDER BY t0.order_id ASC;

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 = ?

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 = 'efce2be0-cd1e-4803-a2bb-96010fa662ff';

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 = ?

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 = 'open';

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

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 = '7b400796b66145700a155511240366fd897ac53a00e336fa3b58859894ed79d5' LIMIT 1;

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)
  )

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 = 17 AND ((t0.deleted IS NULL));