Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.hash AS hash_2,
  t0.status AS status_3,
  t0.weight AS weight_4,
  t0.extra AS extra_5,
  t0.weeknumber AS weeknumber_6,
  t0.flags AS flags_7,
  t0.address_id AS address_id_8,
  t9.id AS id_10,
  t9.sequence AS sequence_11,
  t9.travel_time AS travel_time_12,
  t9.travel_distance AS travel_distance_13,
  t9.type AS type_14,
  t9.routing AS routing_15,
  t9.start_time AS start_time_16,
  t9.delivery_duration AS delivery_duration_17,
  t9.extra AS extra_18,
  t9.notice AS notice_19,
  t9.route_id AS route_id_20,
  t9.day_id AS day_id_21,
  t9.location_id AS location_id_22,
  t9.collection_id AS collection_id_23,
  t0.src_address_id AS src_address_id_24
FROM
  delivery_collection t0
  LEFT JOIN route_element t9 ON t9.collection_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.status AS status_3, t0.weight AS weight_4, t0.extra AS extra_5, t0.weeknumber AS weeknumber_6, t0.flags AS flags_7, t0.address_id AS address_id_8, t9.id AS id_10, t9.sequence AS sequence_11, t9.travel_time AS travel_time_12, t9.travel_distance AS travel_distance_13, t9.type AS type_14, t9.routing AS routing_15, t9.start_time AS start_time_16, t9.delivery_duration AS delivery_duration_17, t9.extra AS extra_18, t9.notice AS notice_19, t9.route_id AS route_id_20, t9.day_id AS day_id_21, t9.location_id AS location_id_22, t9.collection_id AS collection_id_23, t0.src_address_id AS src_address_id_24 FROM delivery_collection t0 LEFT JOIN route_element t9 ON t9.collection_id = t0.id WHERE t0.id = 'e18b310d-85fc-4620-b599-30b7fc32405a';

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 = 'e18b310d-85fc-4620-b599-30b7fc32405a' ORDER BY t0.order_id ASC;

SELECT
  t0.id AS id_1,
  t0.company AS company_2,
  t0.responsible_person AS responsible_person_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.postalcode AS postalcode_6,
  t0.country AS country_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.nav_latitude AS nav_latitude_10,
  t0.nav_longitude AS nav_longitude_11,
  ST_AsBinary(t0.point) AS point_12
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company AS company_2, t0.responsible_person AS responsible_person_3, t0.address AS address_4, t0.city AS city_5, t0.postalcode AS postalcode_6, t0.country AS country_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.nav_latitude AS nav_latitude_10, t0.nav_longitude AS nav_longitude_11, ST_AsBinary(t0.point) AS point_12 FROM address t0 WHERE t0.id = '0c75c7df-96f3-4c41-b54a-0e00a656b50a';

SELECT
  r0_.id AS id_0,
  r0_.duration AS duration_1,
  r0_.start_date AS start_date_2,
  r0_.polygon AS polygon_3,
  r0_.destination_location_id AS destination_location_id_4,
  r0_.source_location_id AS source_location_id_5,
  r0_.title AS title_6,
  r0_.status AS status_7,
  v1_.id AS id_8,
  v1_.registration AS registration_9,
  v1_.brand AS brand_10,
  v1_.model AS model_11,
  v1_.max_payload_length AS max_payload_length_12,
  v1_.max_payload_weight AS max_payload_weight_13,
  v1_.max_range AS max_range_14,
  v1_.last_service AS last_service_15,
  v1_.height AS height_16,
  v1_.max_weight AS max_weight_17,
  v1_.max_axle_weight AS max_axle_weight_18,
  v1_.fleetmanager_id AS fleetmanager_id_19,
  v1_.deleted AS deleted_20,
  v1_.buildyear AS buildyear_21,
  l2_.id AS id_22,
  l2_.type AS type_23,
  l2_.title AS title_24,
  l2_.phone AS phone_25,
  l2_.marker_color AS marker_color_26,
  a3_.id AS id_27,
  a3_.company AS company_28,
  a3_.responsible_person AS responsible_person_29,
  a3_.address AS address_30,
  a3_.city AS city_31,
  a3_.postalcode AS postalcode_32,
  a3_.country AS country_33,
  a3_.latitude AS latitude_34,
  a3_.longitude AS longitude_35,
  a3_.nav_latitude AS nav_latitude_36,
  a3_.nav_longitude AS nav_longitude_37,
  ST_AsBinary(a3_.point) AS point_38,
  l4_.id AS id_39,
  l4_.type AS type_40,
  l4_.title AS title_41,
  l4_.phone AS phone_42,
  l4_.marker_color AS marker_color_43,
  a5_.id AS id_44,
  a5_.company AS company_45,
  a5_.responsible_person AS responsible_person_46,
  a5_.address AS address_47,
  a5_.city AS city_48,
  a5_.postalcode AS postalcode_49,
  a5_.country AS country_50,
  a5_.latitude AS latitude_51,
  a5_.longitude AS longitude_52,
  a5_.nav_latitude AS nav_latitude_53,
  a5_.nav_longitude AS nav_longitude_54,
  ST_AsBinary(a5_.point) AS point_55,
  r6_.id AS id_56,
  r6_.day_index AS day_index_57,
  r6_.start_time AS start_time_58,
  r6_.date AS date_59,
  r6_.travel_time AS travel_time_60,
  r6_.travel_distance AS travel_distance_61,
  r6_.delivery_time AS delivery_time_62,
  r6_.final_travel_time AS final_travel_time_63,
  r6_.final_travel_distance AS final_travel_distance_64,
  r6_.final_routing AS final_routing_65,
  r6_.final_start_time AS final_start_time_66,
  r6_.start_weight AS start_weight_67,
  r6_.end_weight AS end_weight_68,
  l7_.id AS id_69,
  l7_.type AS type_70,
  l7_.title AS title_71,
  l7_.phone AS phone_72,
  l7_.marker_color AS marker_color_73,
  l8_.id AS id_74,
  l8_.type AS type_75,
  l8_.title AS title_76,
  l8_.phone AS phone_77,
  l8_.marker_color AS marker_color_78,
  r9_.id AS id_79,
  r9_.sequence AS sequence_80,
  r9_.travel_time AS travel_time_81,
  r9_.travel_distance AS travel_distance_82,
  r9_.type AS type_83,
  r9_.routing AS routing_84,
  r9_.start_time AS start_time_85,
  r9_.delivery_duration AS delivery_duration_86,
  r9_.extra AS extra_87,
  r9_.notice AS notice_88,
  r0_.vehicle_id AS vehicle_id_89,
  r0_.source_location_id AS source_location_id_90,
  r0_.destination_location_id AS destination_location_id_91,
  l2_.address_id AS address_id_92,
  l4_.address_id AS address_id_93,
  r6_.route_id AS route_id_94,
  r6_.start_location_id AS start_location_id_95,
  r6_.end_location_id AS end_location_id_96,
  l7_.address_id AS address_id_97,
  l8_.address_id AS address_id_98,
  r9_.route_id AS route_id_99,
  r9_.day_id AS day_id_100,
  r9_.location_id AS location_id_101,
  r9_.collection_id AS collection_id_102
FROM
  route r0_
  LEFT JOIN vehicle v1_ ON r0_.vehicle_id = v1_.id
  INNER JOIN location l2_ ON r0_.source_location_id = l2_.id
  INNER JOIN address a3_ ON l2_.address_id = a3_.id
  INNER JOIN location l4_ ON r0_.destination_location_id = l4_.id
  INNER JOIN address a5_ ON l4_.address_id = a5_.id
  LEFT JOIN route_day r6_ ON r0_.id = r6_.route_id
  LEFT JOIN location l7_ ON r6_.start_location_id = l7_.id
  LEFT JOIN location l8_ ON r6_.end_location_id = l8_.id
  LEFT JOIN route_element r9_ ON r6_.id = r9_.day_id
WHERE
  r0_.id = ?
ORDER BY
  r6_.day_index ASC,
  r9_.sequence ASC

SELECT r0_.id AS id_0, r0_.duration AS duration_1, r0_.start_date AS start_date_2, r0_.polygon AS polygon_3, r0_.destination_location_id AS destination_location_id_4, r0_.source_location_id AS source_location_id_5, r0_.title AS title_6, r0_.status AS status_7, v1_.id AS id_8, v1_.registration AS registration_9, v1_.brand AS brand_10, v1_.model AS model_11, v1_.max_payload_length AS max_payload_length_12, v1_.max_payload_weight AS max_payload_weight_13, v1_.max_range AS max_range_14, v1_.last_service AS last_service_15, v1_.height AS height_16, v1_.max_weight AS max_weight_17, v1_.max_axle_weight AS max_axle_weight_18, v1_.fleetmanager_id AS fleetmanager_id_19, v1_.deleted AS deleted_20, v1_.buildyear AS buildyear_21, l2_.id AS id_22, l2_.type AS type_23, l2_.title AS title_24, l2_.phone AS phone_25, l2_.marker_color AS marker_color_26, a3_.id AS id_27, a3_.company AS company_28, a3_.responsible_person AS responsible_person_29, a3_.address AS address_30, a3_.city AS city_31, a3_.postalcode AS postalcode_32, a3_.country AS country_33, a3_.latitude AS latitude_34, a3_.longitude AS longitude_35, a3_.nav_latitude AS nav_latitude_36, a3_.nav_longitude AS nav_longitude_37, ST_AsBinary(a3_.point) AS point_38, l4_.id AS id_39, l4_.type AS type_40, l4_.title AS title_41, l4_.phone AS phone_42, l4_.marker_color AS marker_color_43, a5_.id AS id_44, a5_.company AS company_45, a5_.responsible_person AS responsible_person_46, a5_.address AS address_47, a5_.city AS city_48, a5_.postalcode AS postalcode_49, a5_.country AS country_50, a5_.latitude AS latitude_51, a5_.longitude AS longitude_52, a5_.nav_latitude AS nav_latitude_53, a5_.nav_longitude AS nav_longitude_54, ST_AsBinary(a5_.point) AS point_55, r6_.id AS id_56, r6_.day_index AS day_index_57, r6_.start_time AS start_time_58, r6_.date AS date_59, r6_.travel_time AS travel_time_60, r6_.travel_distance AS travel_distance_61, r6_.delivery_time AS delivery_time_62, r6_.final_travel_time AS final_travel_time_63, r6_.final_travel_distance AS final_travel_distance_64, r6_.final_routing AS final_routing_65, r6_.final_start_time AS final_start_time_66, r6_.start_weight AS start_weight_67, r6_.end_weight AS end_weight_68, l7_.id AS id_69, l7_.type AS type_70, l7_.title AS title_71, l7_.phone AS phone_72, l7_.marker_color AS marker_color_73, l8_.id AS id_74, l8_.type AS type_75, l8_.title AS title_76, l8_.phone AS phone_77, l8_.marker_color AS marker_color_78, r9_.id AS id_79, r9_.sequence AS sequence_80, r9_.travel_time AS travel_time_81, r9_.travel_distance AS travel_distance_82, r9_.type AS type_83, r9_.routing AS routing_84, r9_.start_time AS start_time_85, r9_.delivery_duration AS delivery_duration_86, r9_.extra AS extra_87, r9_.notice AS notice_88, r0_.vehicle_id AS vehicle_id_89, r0_.source_location_id AS source_location_id_90, r0_.destination_location_id AS destination_location_id_91, l2_.address_id AS address_id_92, l4_.address_id AS address_id_93, r6_.route_id AS route_id_94, r6_.start_location_id AS start_location_id_95, r6_.end_location_id AS end_location_id_96, l7_.address_id AS address_id_97, l8_.address_id AS address_id_98, r9_.route_id AS route_id_99, r9_.day_id AS day_id_100, r9_.location_id AS location_id_101, r9_.collection_id AS collection_id_102 FROM route r0_ LEFT JOIN vehicle v1_ ON r0_.vehicle_id = v1_.id INNER JOIN location l2_ ON r0_.source_location_id = l2_.id INNER JOIN address a3_ ON l2_.address_id = a3_.id INNER JOIN location l4_ ON r0_.destination_location_id = l4_.id INNER JOIN address a5_ ON l4_.address_id = a5_.id LEFT JOIN route_day r6_ ON r0_.id = r6_.route_id LEFT JOIN location l7_ ON r6_.start_location_id = l7_.id LEFT JOIN location l8_ ON r6_.end_location_id = l8_.id LEFT JOIN route_element r9_ ON r6_.id = r9_.day_id WHERE r0_.id = '50d23a7e-bb63-453b-bcb6-b46da3613308' ORDER BY r6_.day_index ASC, r9_.sequence ASC;

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