Symfony Profiler

SELECT
  d0_.id AS id_0,
  d0_.cpf AS cpf_1,
  d0_.name AS name_2,
  d0_.email AS email_3,
  d0_.password AS password_4,
  d0_.employment_type AS employment_type_5,
  d0_.is_active AS is_active_6,
  d0_.can_receive_auto_offers AS can_receive_auto_offers_7,
  d0_.api_token AS api_token_8,
  d0_.api_token_created_at AS api_token_created_at_9,
  d0_.presence_status AS presence_status_10,
  d0_.last_seen_at AS last_seen_at_11,
  d0_.last_latitude AS last_latitude_12,
  d0_.last_longitude AS last_longitude_13,
  d0_.last_location_accuracy AS last_location_accuracy_14,
  d0_.last_location_bearing AS last_location_bearing_15,
  d0_.last_location_speed AS last_location_speed_16,
  d0_.last_location_at AS last_location_at_17,
  d0_.presence_updated_at AS presence_updated_at_18,
  d0_.presence_effective_status AS presence_effective_status_19,
  d0_.created_at AS created_at_20,
  d0_.rate_payout_adjustment AS rate_payout_adjustment_21,
  d0_.last_selected_driver_vehicle_assignment_id AS last_selected_driver_vehicle_assignment_id_22
FROM
  delivery_agent d0_
WHERE
  d0_.api_token = ?
LIMIT
  1

SELECT d0_.id AS id_0, d0_.cpf AS cpf_1, d0_.name AS name_2, d0_.email AS email_3, d0_.password AS password_4, d0_.employment_type AS employment_type_5, d0_.is_active AS is_active_6, d0_.can_receive_auto_offers AS can_receive_auto_offers_7, d0_.api_token AS api_token_8, d0_.api_token_created_at AS api_token_created_at_9, d0_.presence_status AS presence_status_10, d0_.last_seen_at AS last_seen_at_11, d0_.last_latitude AS last_latitude_12, d0_.last_longitude AS last_longitude_13, d0_.last_location_accuracy AS last_location_accuracy_14, d0_.last_location_bearing AS last_location_bearing_15, d0_.last_location_speed AS last_location_speed_16, d0_.last_location_at AS last_location_at_17, d0_.presence_updated_at AS presence_updated_at_18, d0_.presence_effective_status AS presence_effective_status_19, d0_.created_at AS created_at_20, d0_.rate_payout_adjustment AS rate_payout_adjustment_21, d0_.last_selected_driver_vehicle_assignment_id AS last_selected_driver_vehicle_assignment_id_22 FROM delivery_agent d0_ WHERE d0_.api_token = '32f5a164b8de806b9a986b69c7466e54bc186c95bb71fe37475d2ec744c302ac' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.phone_e164 AS phone_e164_3,
  t0.phone_verified_at AS phone_verified_at_4,
  t0.birth_date AS birth_date_5,
  t0.driver_license_number AS driver_license_number_6,
  t0.driver_license_categories AS driver_license_categories_7,
  t0.driver_license_first_issued_at AS driver_license_first_issued_at_8,
  t0.driver_license_expires_at AS driver_license_expires_at_9,
  t0.driver_license_has_ear AS driver_license_has_ear_10,
  t0.operation_city AS operation_city_11,
  t0.operation_state AS operation_state_12,
  t0.terms_version AS terms_version_13,
  t0.terms_accepted_at AS terms_accepted_at_14,
  t0.privacy_notice_version AS privacy_notice_version_15,
  t0.privacy_notice_accepted_at AS privacy_notice_accepted_at_16,
  t0.biometric_notice_version AS biometric_notice_version_17,
  t0.biometric_notice_accepted_at AS biometric_notice_accepted_at_18,
  t0.submitted_at AS submitted_at_19,
  t0.reviewed_at AS reviewed_at_20,
  t0.approved_at AS approved_at_21,
  t0.rejected_at AS rejected_at_22,
  t0.suspended_at AS suspended_at_23,
  t0.cancelled_at AS cancelled_at_24,
  t0.cancelled_by_type AS cancelled_by_type_25,
  t0.cancellation_reason_code AS cancellation_reason_code_26,
  t0.cancellation_reason AS cancellation_reason_27,
  t0.closure_requested_at AS closure_requested_at_28,
  t0.closed_at AS closed_at_29,
  t0.deletion_scheduled_at AS deletion_scheduled_at_30,
  t0.review_reason AS review_reason_31,
  t0.internal_notes AS internal_notes_32,
  t0.created_at AS created_at_33,
  t0.updated_at AS updated_at_34,
  t0.delivery_agent_id AS delivery_agent_id_35,
  t0.reviewed_by_user_id AS reviewed_by_user_id_36,
  t0.cancelled_by_user_id AS cancelled_by_user_id_37
FROM
  driver_onboarding_application t0
WHERE
  t0.delivery_agent_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.status AS status_2, t0.phone_e164 AS phone_e164_3, t0.phone_verified_at AS phone_verified_at_4, t0.birth_date AS birth_date_5, t0.driver_license_number AS driver_license_number_6, t0.driver_license_categories AS driver_license_categories_7, t0.driver_license_first_issued_at AS driver_license_first_issued_at_8, t0.driver_license_expires_at AS driver_license_expires_at_9, t0.driver_license_has_ear AS driver_license_has_ear_10, t0.operation_city AS operation_city_11, t0.operation_state AS operation_state_12, t0.terms_version AS terms_version_13, t0.terms_accepted_at AS terms_accepted_at_14, t0.privacy_notice_version AS privacy_notice_version_15, t0.privacy_notice_accepted_at AS privacy_notice_accepted_at_16, t0.biometric_notice_version AS biometric_notice_version_17, t0.biometric_notice_accepted_at AS biometric_notice_accepted_at_18, t0.submitted_at AS submitted_at_19, t0.reviewed_at AS reviewed_at_20, t0.approved_at AS approved_at_21, t0.rejected_at AS rejected_at_22, t0.suspended_at AS suspended_at_23, t0.cancelled_at AS cancelled_at_24, t0.cancelled_by_type AS cancelled_by_type_25, t0.cancellation_reason_code AS cancellation_reason_code_26, t0.cancellation_reason AS cancellation_reason_27, t0.closure_requested_at AS closure_requested_at_28, t0.closed_at AS closed_at_29, t0.deletion_scheduled_at AS deletion_scheduled_at_30, t0.review_reason AS review_reason_31, t0.internal_notes AS internal_notes_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.delivery_agent_id AS delivery_agent_id_35, t0.reviewed_by_user_id AS reviewed_by_user_id_36, t0.cancelled_by_user_id AS cancelled_by_user_id_37 FROM driver_onboarding_application t0 WHERE t0.delivery_agent_id = 44 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.reason_code AS reason_code_3,
  t0.public_title AS public_title_4,
  t0.public_message AS public_message_5,
  t0.internal_note AS internal_note_6,
  t0.starts_at AS starts_at_7,
  t0.expires_at AS expires_at_8,
  t0.action_required AS action_required_9,
  t0.appeal_allowed AS appeal_allowed_10,
  t0.appeal_deadline AS appeal_deadline_11,
  t0.case_reference AS case_reference_12,
  t0.source AS source_13,
  t0.legacy_snapshot AS legacy_snapshot_14,
  t0.projection_hash AS projection_hash_15,
  t0.version AS version_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.delivery_agent_id AS delivery_agent_id_19,
  t0.created_by_user_id AS created_by_user_id_20,
  t0.updated_by_user_id AS updated_by_user_id_21
FROM
  driver_account_access t0
WHERE
  t0.delivery_agent_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.status AS status_2, t0.reason_code AS reason_code_3, t0.public_title AS public_title_4, t0.public_message AS public_message_5, t0.internal_note AS internal_note_6, t0.starts_at AS starts_at_7, t0.expires_at AS expires_at_8, t0.action_required AS action_required_9, t0.appeal_allowed AS appeal_allowed_10, t0.appeal_deadline AS appeal_deadline_11, t0.case_reference AS case_reference_12, t0.source AS source_13, t0.legacy_snapshot AS legacy_snapshot_14, t0.projection_hash AS projection_hash_15, t0.version AS version_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.delivery_agent_id AS delivery_agent_id_19, t0.created_by_user_id AS created_by_user_id_20, t0.updated_by_user_id AS updated_by_user_id_21 FROM driver_account_access t0 WHERE t0.delivery_agent_id = 44 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cpf AS cpf_2,
  t0.name AS name_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.employment_type AS employment_type_6,
  t0.is_active AS is_active_7,
  t0.can_receive_auto_offers AS can_receive_auto_offers_8,
  t0.api_token AS api_token_9,
  t0.api_token_created_at AS api_token_created_at_10,
  t0.presence_status AS presence_status_11,
  t0.last_seen_at AS last_seen_at_12,
  t0.last_latitude AS last_latitude_13,
  t0.last_longitude AS last_longitude_14,
  t0.last_location_accuracy AS last_location_accuracy_15,
  t0.last_location_bearing AS last_location_bearing_16,
  t0.last_location_speed AS last_location_speed_17,
  t0.last_location_at AS last_location_at_18,
  t0.presence_updated_at AS presence_updated_at_19,
  t0.presence_effective_status AS presence_effective_status_20,
  t0.created_at AS created_at_21,
  t0.rate_payout_adjustment AS rate_payout_adjustment_22,
  t0.last_selected_driver_vehicle_assignment_id AS last_selected_driver_vehicle_assignment_id_23
FROM
  delivery_agent t0
WHERE
  t0.api_token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cpf AS cpf_2, t0.name AS name_3, t0.email AS email_4, t0.password AS password_5, t0.employment_type AS employment_type_6, t0.is_active AS is_active_7, t0.can_receive_auto_offers AS can_receive_auto_offers_8, t0.api_token AS api_token_9, t0.api_token_created_at AS api_token_created_at_10, t0.presence_status AS presence_status_11, t0.last_seen_at AS last_seen_at_12, t0.last_latitude AS last_latitude_13, t0.last_longitude AS last_longitude_14, t0.last_location_accuracy AS last_location_accuracy_15, t0.last_location_bearing AS last_location_bearing_16, t0.last_location_speed AS last_location_speed_17, t0.last_location_at AS last_location_at_18, t0.presence_updated_at AS presence_updated_at_19, t0.presence_effective_status AS presence_effective_status_20, t0.created_at AS created_at_21, t0.rate_payout_adjustment AS rate_payout_adjustment_22, t0.last_selected_driver_vehicle_assignment_id AS last_selected_driver_vehicle_assignment_id_23 FROM delivery_agent t0 WHERE t0.api_token = '32f5a164b8de806b9a986b69c7466e54bc186c95bb71fe37475d2ec744c302ac' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.departed_at AS departed_at_3,
  t0.assigned_vehicle_snapshot AS assigned_vehicle_snapshot_4,
  t0.delivered_at AS delivered_at_5,
  t0.region_name AS region_name_6,
  t0.pickup_location AS pickup_location_7,
  t0.dropoff_location AS dropoff_location_8,
  t0.pickup_lat_lng AS pickup_lat_lng_9,
  t0.dropoff_lat_lng AS dropoff_lat_lng_10,
  t0.distance AS distance_11,
  t0.operational_order AS operational_order_12,
  t0.delivery_agent_payout AS delivery_agent_payout_13,
  t0.shipper_charge_total AS shipper_charge_total_14,
  t0.shipper_base_amount AS shipper_base_amount_15,
  t0.delivery_agent_base_amount AS delivery_agent_base_amount_16,
  t0.operational_adjustment_applied AS operational_adjustment_applied_17,
  t0.operational_flag_applied AS operational_flag_applied_18,
  t0.shipper_adjustment_factor_applied AS shipper_adjustment_factor_applied_19,
  t0.delivery_agent_adjustment_factor_applied AS delivery_agent_adjustment_factor_applied_20,
  t0.adjustment_reason_code_applied AS adjustment_reason_code_applied_21,
  t0.status AS status_22,
  t0.pod_filename AS pod_filename_23,
  t0.auto_assign_status AS auto_assign_status_24,
  t0.auto_assign_started_at AS auto_assign_started_at_25,
  t0.auto_assign_expires_at AS auto_assign_expires_at_26,
  t0.auto_assign_fail_reason AS auto_assign_fail_reason_27,
  t0.routing_responsibility AS routing_responsibility_28,
  t0.vehicle_catalog_scope AS vehicle_catalog_scope_29,
  t0.routing_context_source AS routing_context_source_30,
  t0.delivery_agent_id AS delivery_agent_id_31,
  t0.assigned_driver_vehicle_assignment_id AS assigned_driver_vehicle_assignment_id_32,
  t0.assigned_driver_vehicle_id AS assigned_driver_vehicle_id_33,
  t0.assigned_vehicle_class_id AS assigned_vehicle_class_id_34,
  t0.consignee_id AS consignee_id_35,
  t0.carrier_id AS carrier_id_36,
  t0.region_id AS region_id_37,
  t0.vehicle_class_id AS vehicle_class_id_38,
  t0.trip_id AS trip_id_39,
  t0.routing_owner_shipper_id AS routing_owner_shipper_id_40,
  t0.routing_driver_pool_id AS routing_driver_pool_id_41,
  t0.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_42
FROM
  delivery t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.departed_at AS departed_at_3, t0.assigned_vehicle_snapshot AS assigned_vehicle_snapshot_4, t0.delivered_at AS delivered_at_5, t0.region_name AS region_name_6, t0.pickup_location AS pickup_location_7, t0.dropoff_location AS dropoff_location_8, t0.pickup_lat_lng AS pickup_lat_lng_9, t0.dropoff_lat_lng AS dropoff_lat_lng_10, t0.distance AS distance_11, t0.operational_order AS operational_order_12, t0.delivery_agent_payout AS delivery_agent_payout_13, t0.shipper_charge_total AS shipper_charge_total_14, t0.shipper_base_amount AS shipper_base_amount_15, t0.delivery_agent_base_amount AS delivery_agent_base_amount_16, t0.operational_adjustment_applied AS operational_adjustment_applied_17, t0.operational_flag_applied AS operational_flag_applied_18, t0.shipper_adjustment_factor_applied AS shipper_adjustment_factor_applied_19, t0.delivery_agent_adjustment_factor_applied AS delivery_agent_adjustment_factor_applied_20, t0.adjustment_reason_code_applied AS adjustment_reason_code_applied_21, t0.status AS status_22, t0.pod_filename AS pod_filename_23, t0.auto_assign_status AS auto_assign_status_24, t0.auto_assign_started_at AS auto_assign_started_at_25, t0.auto_assign_expires_at AS auto_assign_expires_at_26, t0.auto_assign_fail_reason AS auto_assign_fail_reason_27, t0.routing_responsibility AS routing_responsibility_28, t0.vehicle_catalog_scope AS vehicle_catalog_scope_29, t0.routing_context_source AS routing_context_source_30, t0.delivery_agent_id AS delivery_agent_id_31, t0.assigned_driver_vehicle_assignment_id AS assigned_driver_vehicle_assignment_id_32, t0.assigned_driver_vehicle_id AS assigned_driver_vehicle_id_33, t0.assigned_vehicle_class_id AS assigned_vehicle_class_id_34, t0.consignee_id AS consignee_id_35, t0.carrier_id AS carrier_id_36, t0.region_id AS region_id_37, t0.vehicle_class_id AS vehicle_class_id_38, t0.trip_id AS trip_id_39, t0.routing_owner_shipper_id AS routing_owner_shipper_id_40, t0.routing_driver_pool_id AS routing_driver_pool_id_41, t0.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_42 FROM delivery t0 WHERE t0.id = 187;

SELECT
  t0.id AS id_1,
  t0.operational_route_number AS operational_route_number_2,
  t0.operational_route_code AS operational_route_code_3,
  t0.trip_kind AS trip_kind_4,
  t0.mode AS mode_5,
  t0.planning_source AS planning_source_6,
  t0.status AS status_7,
  t0.planned_date AS planned_date_8,
  t0.estimated_km AS estimated_km_9,
  t0.estimated_duration_minutes AS estimated_duration_minutes_10,
  t0.route_geometry_json AS route_geometry_json_11,
  t0.total_weight AS total_weight_12,
  t0.total_volume AS total_volume_13,
  t0.point_count AS point_count_14,
  t0.invoice_count AS invoice_count_15,
  t0.customer_charge_total AS customer_charge_total_16,
  t0.driver_payout_total AS driver_payout_total_17,
  t0.customer_financial_scope AS customer_financial_scope_18,
  t0.driver_financial_scope AS driver_financial_scope_19,
  t0.notes AS notes_20,
  t0.routing_responsibility AS routing_responsibility_21,
  t0.vehicle_catalog_scope AS vehicle_catalog_scope_22,
  t0.routing_context_source AS routing_context_source_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.route_id AS route_id_26,
  t0.operation_profile_id AS operation_profile_id_27,
  t0.vehicle_class_id AS vehicle_class_id_28,
  t0.delivery_agent_id AS delivery_agent_id_29,
  t0.routing_owner_shipper_id AS routing_owner_shipper_id_30,
  t0.routing_driver_pool_id AS routing_driver_pool_id_31,
  t0.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_32
FROM
  trip_run t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.operational_route_number AS operational_route_number_2, t0.operational_route_code AS operational_route_code_3, t0.trip_kind AS trip_kind_4, t0.mode AS mode_5, t0.planning_source AS planning_source_6, t0.status AS status_7, t0.planned_date AS planned_date_8, t0.estimated_km AS estimated_km_9, t0.estimated_duration_minutes AS estimated_duration_minutes_10, t0.route_geometry_json AS route_geometry_json_11, t0.total_weight AS total_weight_12, t0.total_volume AS total_volume_13, t0.point_count AS point_count_14, t0.invoice_count AS invoice_count_15, t0.customer_charge_total AS customer_charge_total_16, t0.driver_payout_total AS driver_payout_total_17, t0.customer_financial_scope AS customer_financial_scope_18, t0.driver_financial_scope AS driver_financial_scope_19, t0.notes AS notes_20, t0.routing_responsibility AS routing_responsibility_21, t0.vehicle_catalog_scope AS vehicle_catalog_scope_22, t0.routing_context_source AS routing_context_source_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.route_id AS route_id_26, t0.operation_profile_id AS operation_profile_id_27, t0.vehicle_class_id AS vehicle_class_id_28, t0.delivery_agent_id AS delivery_agent_id_29, t0.routing_owner_shipper_id AS routing_owner_shipper_id_30, t0.routing_driver_pool_id AS routing_driver_pool_id_31, t0.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_32 FROM trip_run t0 WHERE t0.id = 165;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.departed_at AS departed_at_3,
  t0.assigned_vehicle_snapshot AS assigned_vehicle_snapshot_4,
  t0.delivered_at AS delivered_at_5,
  t0.region_name AS region_name_6,
  t0.pickup_location AS pickup_location_7,
  t0.dropoff_location AS dropoff_location_8,
  t0.pickup_lat_lng AS pickup_lat_lng_9,
  t0.dropoff_lat_lng AS dropoff_lat_lng_10,
  t0.distance AS distance_11,
  t0.operational_order AS operational_order_12,
  t0.delivery_agent_payout AS delivery_agent_payout_13,
  t0.shipper_charge_total AS shipper_charge_total_14,
  t0.shipper_base_amount AS shipper_base_amount_15,
  t0.delivery_agent_base_amount AS delivery_agent_base_amount_16,
  t0.operational_adjustment_applied AS operational_adjustment_applied_17,
  t0.operational_flag_applied AS operational_flag_applied_18,
  t0.shipper_adjustment_factor_applied AS shipper_adjustment_factor_applied_19,
  t0.delivery_agent_adjustment_factor_applied AS delivery_agent_adjustment_factor_applied_20,
  t0.adjustment_reason_code_applied AS adjustment_reason_code_applied_21,
  t0.status AS status_22,
  t0.pod_filename AS pod_filename_23,
  t0.auto_assign_status AS auto_assign_status_24,
  t0.auto_assign_started_at AS auto_assign_started_at_25,
  t0.auto_assign_expires_at AS auto_assign_expires_at_26,
  t0.auto_assign_fail_reason AS auto_assign_fail_reason_27,
  t0.routing_responsibility AS routing_responsibility_28,
  t0.vehicle_catalog_scope AS vehicle_catalog_scope_29,
  t0.routing_context_source AS routing_context_source_30,
  t0.delivery_agent_id AS delivery_agent_id_31,
  t0.assigned_driver_vehicle_assignment_id AS assigned_driver_vehicle_assignment_id_32,
  t0.assigned_driver_vehicle_id AS assigned_driver_vehicle_id_33,
  t0.assigned_vehicle_class_id AS assigned_vehicle_class_id_34,
  t0.consignee_id AS consignee_id_35,
  t0.carrier_id AS carrier_id_36,
  t0.region_id AS region_id_37,
  t0.vehicle_class_id AS vehicle_class_id_38,
  t0.trip_id AS trip_id_39,
  t0.routing_owner_shipper_id AS routing_owner_shipper_id_40,
  t0.routing_driver_pool_id AS routing_driver_pool_id_41,
  t0.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_42
FROM
  delivery t0
WHERE
  t0.trip_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.departed_at AS departed_at_3, t0.assigned_vehicle_snapshot AS assigned_vehicle_snapshot_4, t0.delivered_at AS delivered_at_5, t0.region_name AS region_name_6, t0.pickup_location AS pickup_location_7, t0.dropoff_location AS dropoff_location_8, t0.pickup_lat_lng AS pickup_lat_lng_9, t0.dropoff_lat_lng AS dropoff_lat_lng_10, t0.distance AS distance_11, t0.operational_order AS operational_order_12, t0.delivery_agent_payout AS delivery_agent_payout_13, t0.shipper_charge_total AS shipper_charge_total_14, t0.shipper_base_amount AS shipper_base_amount_15, t0.delivery_agent_base_amount AS delivery_agent_base_amount_16, t0.operational_adjustment_applied AS operational_adjustment_applied_17, t0.operational_flag_applied AS operational_flag_applied_18, t0.shipper_adjustment_factor_applied AS shipper_adjustment_factor_applied_19, t0.delivery_agent_adjustment_factor_applied AS delivery_agent_adjustment_factor_applied_20, t0.adjustment_reason_code_applied AS adjustment_reason_code_applied_21, t0.status AS status_22, t0.pod_filename AS pod_filename_23, t0.auto_assign_status AS auto_assign_status_24, t0.auto_assign_started_at AS auto_assign_started_at_25, t0.auto_assign_expires_at AS auto_assign_expires_at_26, t0.auto_assign_fail_reason AS auto_assign_fail_reason_27, t0.routing_responsibility AS routing_responsibility_28, t0.vehicle_catalog_scope AS vehicle_catalog_scope_29, t0.routing_context_source AS routing_context_source_30, t0.delivery_agent_id AS delivery_agent_id_31, t0.assigned_driver_vehicle_assignment_id AS assigned_driver_vehicle_assignment_id_32, t0.assigned_driver_vehicle_id AS assigned_driver_vehicle_id_33, t0.assigned_vehicle_class_id AS assigned_vehicle_class_id_34, t0.consignee_id AS consignee_id_35, t0.carrier_id AS carrier_id_36, t0.region_id AS region_id_37, t0.vehicle_class_id AS vehicle_class_id_38, t0.trip_id AS trip_id_39, t0.routing_owner_shipper_id AS routing_owner_shipper_id_40, t0.routing_driver_pool_id AS routing_driver_pool_id_41, t0.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_42 FROM delivery t0 WHERE t0.trip_id = 165;

SELECT
  t0.id AS id_1,
  t0.key_number AS key_number_2,
  t0.pdf_filename AS pdf_filename_3,
  t0.pod_filename AS pod_filename_4,
  t0.number AS number_5,
  t0.order_number AS order_number_6,
  t0.fiscal_document_type AS fiscal_document_type_7,
  t0.volume AS volume_8,
  t0.weight AS weight_9,
  t0.issue_date AS issue_date_10,
  t0.cte AS cte_11,
  t0.obs AS obs_12,
  t0.total AS total_13,
  t0.extra AS extra_14,
  t0.items AS items_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.daily_control_date AS daily_control_date_18,
  t0.daily_control_order AS daily_control_order_19,
  t0.status AS status_20,
  t0.routed_at AS routed_at_21,
  t0.trip_planning_mode AS trip_planning_mode_22,
  t0.routing_engine AS routing_engine_23,
  t0.scheduled_routing_queued_at AS scheduled_routing_queued_at_24,
  t0.scheduled_routing_ready_at AS scheduled_routing_ready_at_25,
  t0.scheduled_routing_released_at AS scheduled_routing_released_at_26,
  t0.active AS active_27,
  t0.is_nfe AS is_nfe_28,
  t0.auto_routing_suppressed AS auto_routing_suppressed_29,
  t0.auto_routing_suppressed_at AS auto_routing_suppressed_at_30,
  t0.auto_routing_suppressed_reason AS auto_routing_suppressed_reason_31,
  t0.dropoff_override_location AS dropoff_override_location_32,
  t0.dropoff_override_lat_lng AS dropoff_override_lat_lng_33,
  t0.pickup_reference_location AS pickup_reference_location_34,
  t0.pickup_reference_lat_lng AS pickup_reference_lat_lng_35,
  t0.transport_carrier_cnpj_digits AS transport_carrier_cnpj_digits_36,
  t0.transport_carrier_name AS transport_carrier_name_37,
  t0.routing_responsibility AS routing_responsibility_38,
  t0.routing_responsibility_source AS routing_responsibility_source_39,
  t0.routing_responsibility_resolved_at AS routing_responsibility_resolved_at_40,
  t0.routing_responsibility_overridden_at AS routing_responsibility_overridden_at_41,
  t0.routing_responsibility_overridden_by AS routing_responsibility_overridden_by_42,
  t0.shipper_id AS shipper_id_43,
  t0.consignee_id AS consignee_id_44,
  t0.delivery_id AS delivery_id_45,
  t0.route_id AS route_id_46,
  t0.transport_carrier_id AS transport_carrier_id_47
FROM
  invoice t0
WHERE
  t0.delivery_id = ?

SELECT t0.id AS id_1, t0.key_number AS key_number_2, t0.pdf_filename AS pdf_filename_3, t0.pod_filename AS pod_filename_4, t0.number AS number_5, t0.order_number AS order_number_6, t0.fiscal_document_type AS fiscal_document_type_7, t0.volume AS volume_8, t0.weight AS weight_9, t0.issue_date AS issue_date_10, t0.cte AS cte_11, t0.obs AS obs_12, t0.total AS total_13, t0.extra AS extra_14, t0.items AS items_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.daily_control_date AS daily_control_date_18, t0.daily_control_order AS daily_control_order_19, t0.status AS status_20, t0.routed_at AS routed_at_21, t0.trip_planning_mode AS trip_planning_mode_22, t0.routing_engine AS routing_engine_23, t0.scheduled_routing_queued_at AS scheduled_routing_queued_at_24, t0.scheduled_routing_ready_at AS scheduled_routing_ready_at_25, t0.scheduled_routing_released_at AS scheduled_routing_released_at_26, t0.active AS active_27, t0.is_nfe AS is_nfe_28, t0.auto_routing_suppressed AS auto_routing_suppressed_29, t0.auto_routing_suppressed_at AS auto_routing_suppressed_at_30, t0.auto_routing_suppressed_reason AS auto_routing_suppressed_reason_31, t0.dropoff_override_location AS dropoff_override_location_32, t0.dropoff_override_lat_lng AS dropoff_override_lat_lng_33, t0.pickup_reference_location AS pickup_reference_location_34, t0.pickup_reference_lat_lng AS pickup_reference_lat_lng_35, t0.transport_carrier_cnpj_digits AS transport_carrier_cnpj_digits_36, t0.transport_carrier_name AS transport_carrier_name_37, t0.routing_responsibility AS routing_responsibility_38, t0.routing_responsibility_source AS routing_responsibility_source_39, t0.routing_responsibility_resolved_at AS routing_responsibility_resolved_at_40, t0.routing_responsibility_overridden_at AS routing_responsibility_overridden_at_41, t0.routing_responsibility_overridden_by AS routing_responsibility_overridden_by_42, t0.shipper_id AS shipper_id_43, t0.consignee_id AS consignee_id_44, t0.delivery_id AS delivery_id_45, t0.route_id AS route_id_46, t0.transport_carrier_id AS transport_carrier_id_47 FROM invoice t0 WHERE t0.delivery_id = 187;

SELECT
  t0_.id AS id_0,
  t0_.draft_key AS draft_key_1,
  t0_.operational_route_number AS operational_route_number_2,
  t0_.operational_route_code AS operational_route_code_3,
  t0_.mode AS mode_4,
  t0_.planning_source AS planning_source_5,
  t0_.status AS status_6,
  t0_.planned_date AS planned_date_7,
  t0_.payload_json AS payload_json_8,
  t0_.created_at AS created_at_9,
  t0_.updated_at AS updated_at_10,
  r1_.id AS id_11,
  r1_.name AS name_12,
  r1_.customer_financial_scope AS customer_financial_scope_13,
  r1_.driver_financial_scope AS driver_financial_scope_14,
  t0_.route_id AS route_id_15,
  t0_.trip_id AS trip_id_16,
  r1_.delivery_agent_id AS delivery_agent_id_17
FROM
  trip_approval_draft t0_
  LEFT JOIN route r1_ ON t0_.route_id = r1_.id
WHERE
  t0_.trip_id = ?
LIMIT
  1

SELECT t0_.id AS id_0, t0_.draft_key AS draft_key_1, t0_.operational_route_number AS operational_route_number_2, t0_.operational_route_code AS operational_route_code_3, t0_.mode AS mode_4, t0_.planning_source AS planning_source_5, t0_.status AS status_6, t0_.planned_date AS planned_date_7, t0_.payload_json AS payload_json_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, r1_.id AS id_11, r1_.name AS name_12, r1_.customer_financial_scope AS customer_financial_scope_13, r1_.driver_financial_scope AS driver_financial_scope_14, t0_.route_id AS route_id_15, t0_.trip_id AS trip_id_16, r1_.delivery_agent_id AS delivery_agent_id_17 FROM trip_approval_draft t0_ LEFT JOIN route r1_ ON t0_.route_id = r1_.id WHERE t0_.trip_id = 165 LIMIT 1;