Symfony Profiler

SELECT
  1
FROM
  customer_portal_session
LIMIT
  1

SELECT 1 FROM customer_portal_session LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.token_hash AS token_hash_1,
  c0_.issued_at AS issued_at_2,
  c0_.expires_at AS expires_at_3,
  c0_.revoked_at AS revoked_at_4,
  c0_.last_seen_at AS last_seen_at_5,
  c0_.ip_address AS ip_address_6,
  c0_.user_agent AS user_agent_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c1_.id AS id_10,
  c1_.email AS email_11,
  c1_.name AS name_12,
  c1_.phone_number AS phone_number_13,
  c1_.terms_accepted_at AS terms_accepted_at_14,
  c1_.terms_version AS terms_version_15,
  c1_.created_channel AS created_channel_16,
  c1_.password_hash AS password_hash_17,
  c1_.active AS active_18,
  c1_.api_token_hash AS api_token_hash_19,
  c1_.api_token_issued_at AS api_token_issued_at_20,
  c1_.api_token_expires_at AS api_token_expires_at_21,
  c1_.last_login_at AS last_login_at_22,
  c1_.created_at AS created_at_23,
  c1_.updated_at AS updated_at_24,
  s2_.id AS id_25,
  s2_.cnpj AS cnpj_26,
  s2_.company_name AS company_name_27,
  s2_.address AS address_28,
  s2_.district AS district_29,
  s2_.city AS city_30,
  s2_.zip_code AS zip_code_31,
  s2_.lat_lng AS lat_lng_32,
  s2_.email AS email_33,
  s2_.phone_number AS phone_number_34,
  s2_.person_type AS person_type_35,
  s2_.document_type AS document_type_36,
  s2_.document_digits AS document_digits_37,
  s2_.legal_name AS legal_name_38,
  s2_.trade_name AS trade_name_39,
  s2_.contact_name AS contact_name_40,
  s2_.contact_phone AS contact_phone_41,
  s2_.customer_origin AS customer_origin_42,
  s2_.customer_relationship AS customer_relationship_43,
  s2_.customer_status AS customer_status_44,
  s2_.registration_channel AS registration_channel_45,
  s2_.self_registered_at AS self_registered_at_46,
  s2_.review_status AS review_status_47,
  s2_.reviewed_at AS reviewed_at_48,
  s2_.reviewed_by AS reviewed_by_49,
  s2_.duplicate_of_shipper_id AS duplicate_of_shipper_id_50,
  s2_.blocked_reason AS blocked_reason_51,
  s2_.daily_control_applicable AS daily_control_applicable_52,
  s2_.charge_method AS charge_method_53,
  s2_.active AS active_54,
  s2_.rate_adjustment_percent AS rate_adjustment_percent_55,
  s2_.auto_assign_open_delivery_on_email_import AS auto_assign_open_delivery_on_email_import_56,
  s2_.uses_scheduled_routing_base AS uses_scheduled_routing_base_57,
  s2_.scheduled_routing_cutoff_time AS scheduled_routing_cutoff_time_58,
  s2_.scheduled_routing_use_ai AS scheduled_routing_use_ai_59,
  s2_.scheduled_base_daily_control_visibility AS scheduled_base_daily_control_visibility_60,
  s2_.operational_routing_policy AS operational_routing_policy_61,
  s2_.direct_auto_routing_window_minutes AS direct_auto_routing_window_minutes_62,
  s2_.direct_auto_routing_auto_approve AS direct_auto_routing_auto_approve_63,
  s2_.customer_portal_route_experience AS customer_portal_route_experience_64,
  s2_.customer_portal_feature_profile AS customer_portal_feature_profile_65,
  s2_.customer_default_order_responsibility AS customer_default_order_responsibility_66,
  s2_.route_grouping_policy AS route_grouping_policy_67,
  s2_.route_customer_financial_scope_override AS route_customer_financial_scope_override_68,
  s2_.fixed_post_enabled AS fixed_post_enabled_69,
  s2_.fixed_post_required_headcount AS fixed_post_required_headcount_70,
  s2_.fixed_post_shift_start_time AS fixed_post_shift_start_time_71,
  c0_.customer_user_id AS customer_user_id_72,
  c1_.shipper_id AS shipper_id_73,
  s2_.carrier_id AS carrier_id_74,
  s2_.rate_plan_id AS rate_plan_id_75
FROM
  customer_portal_session c0_
  INNER JOIN customer_user c1_ ON c0_.customer_user_id = c1_.id
  INNER JOIN shipper s2_ ON c1_.shipper_id = s2_.id
WHERE
  c0_.token_hash = ?
  AND c0_.revoked_at IS NULL
  AND c0_.expires_at > ?
  AND c1_.active = ?
  AND s2_.active = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.token_hash AS token_hash_1, c0_.issued_at AS issued_at_2, c0_.expires_at AS expires_at_3, c0_.revoked_at AS revoked_at_4, c0_.last_seen_at AS last_seen_at_5, c0_.ip_address AS ip_address_6, c0_.user_agent AS user_agent_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c1_.id AS id_10, c1_.email AS email_11, c1_.name AS name_12, c1_.phone_number AS phone_number_13, c1_.terms_accepted_at AS terms_accepted_at_14, c1_.terms_version AS terms_version_15, c1_.created_channel AS created_channel_16, c1_.password_hash AS password_hash_17, c1_.active AS active_18, c1_.api_token_hash AS api_token_hash_19, c1_.api_token_issued_at AS api_token_issued_at_20, c1_.api_token_expires_at AS api_token_expires_at_21, c1_.last_login_at AS last_login_at_22, c1_.created_at AS created_at_23, c1_.updated_at AS updated_at_24, s2_.id AS id_25, s2_.cnpj AS cnpj_26, s2_.company_name AS company_name_27, s2_.address AS address_28, s2_.district AS district_29, s2_.city AS city_30, s2_.zip_code AS zip_code_31, s2_.lat_lng AS lat_lng_32, s2_.email AS email_33, s2_.phone_number AS phone_number_34, s2_.person_type AS person_type_35, s2_.document_type AS document_type_36, s2_.document_digits AS document_digits_37, s2_.legal_name AS legal_name_38, s2_.trade_name AS trade_name_39, s2_.contact_name AS contact_name_40, s2_.contact_phone AS contact_phone_41, s2_.customer_origin AS customer_origin_42, s2_.customer_relationship AS customer_relationship_43, s2_.customer_status AS customer_status_44, s2_.registration_channel AS registration_channel_45, s2_.self_registered_at AS self_registered_at_46, s2_.review_status AS review_status_47, s2_.reviewed_at AS reviewed_at_48, s2_.reviewed_by AS reviewed_by_49, s2_.duplicate_of_shipper_id AS duplicate_of_shipper_id_50, s2_.blocked_reason AS blocked_reason_51, s2_.daily_control_applicable AS daily_control_applicable_52, s2_.charge_method AS charge_method_53, s2_.active AS active_54, s2_.rate_adjustment_percent AS rate_adjustment_percent_55, s2_.auto_assign_open_delivery_on_email_import AS auto_assign_open_delivery_on_email_import_56, s2_.uses_scheduled_routing_base AS uses_scheduled_routing_base_57, s2_.scheduled_routing_cutoff_time AS scheduled_routing_cutoff_time_58, s2_.scheduled_routing_use_ai AS scheduled_routing_use_ai_59, s2_.scheduled_base_daily_control_visibility AS scheduled_base_daily_control_visibility_60, s2_.operational_routing_policy AS operational_routing_policy_61, s2_.direct_auto_routing_window_minutes AS direct_auto_routing_window_minutes_62, s2_.direct_auto_routing_auto_approve AS direct_auto_routing_auto_approve_63, s2_.customer_portal_route_experience AS customer_portal_route_experience_64, s2_.customer_portal_feature_profile AS customer_portal_feature_profile_65, s2_.customer_default_order_responsibility AS customer_default_order_responsibility_66, s2_.route_grouping_policy AS route_grouping_policy_67, s2_.route_customer_financial_scope_override AS route_customer_financial_scope_override_68, s2_.fixed_post_enabled AS fixed_post_enabled_69, s2_.fixed_post_required_headcount AS fixed_post_required_headcount_70, s2_.fixed_post_shift_start_time AS fixed_post_shift_start_time_71, c0_.customer_user_id AS customer_user_id_72, c1_.shipper_id AS shipper_id_73, s2_.carrier_id AS carrier_id_74, s2_.rate_plan_id AS rate_plan_id_75 FROM customer_portal_session c0_ INNER JOIN customer_user c1_ ON c0_.customer_user_id = c1_.id INNER JOIN shipper s2_ ON c1_.shipper_id = s2_.id WHERE c0_.token_hash = '17caf743104e674f045fb8c9c966351739b1423b3b6b0d7afc69fbeb6fb9aafb' AND c0_.revoked_at IS NULL AND c0_.expires_at > '2026-07-02 17:27:53' AND c1_.active = 1 AND s2_.active = 1 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  customer_portal_session
SET
  last_seen_at = ?,
  ip_address = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE customer_portal_session SET last_seen_at = '2026-07-02 17:27:53', ip_address = '177.30.178.73', updated_at = '2026-07-02 17:27:53' WHERE id = 29;

"COMMIT"

"COMMIT";

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'app'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  i0_.id AS id_0,
  i0_.key_number AS key_number_1,
  i0_.pdf_filename AS pdf_filename_2,
  i0_.pod_filename AS pod_filename_3,
  i0_.number AS number_4,
  i0_.order_number AS order_number_5,
  i0_.fiscal_document_type AS fiscal_document_type_6,
  i0_.volume AS volume_7,
  i0_.weight AS weight_8,
  i0_.issue_date AS issue_date_9,
  i0_.cte AS cte_10,
  i0_.obs AS obs_11,
  i0_.total AS total_12,
  i0_.extra AS extra_13,
  i0_.items AS items_14,
  i0_.created_at AS created_at_15,
  i0_.updated_at AS updated_at_16,
  i0_.daily_control_date AS daily_control_date_17,
  i0_.daily_control_order AS daily_control_order_18,
  i0_.status AS status_19,
  i0_.routed_at AS routed_at_20,
  i0_.trip_planning_mode AS trip_planning_mode_21,
  i0_.routing_engine AS routing_engine_22,
  i0_.scheduled_routing_queued_at AS scheduled_routing_queued_at_23,
  i0_.scheduled_routing_ready_at AS scheduled_routing_ready_at_24,
  i0_.scheduled_routing_released_at AS scheduled_routing_released_at_25,
  i0_.active AS active_26,
  i0_.is_nfe AS is_nfe_27,
  i0_.auto_routing_suppressed AS auto_routing_suppressed_28,
  i0_.auto_routing_suppressed_at AS auto_routing_suppressed_at_29,
  i0_.auto_routing_suppressed_reason AS auto_routing_suppressed_reason_30,
  i0_.dropoff_override_location AS dropoff_override_location_31,
  i0_.dropoff_override_lat_lng AS dropoff_override_lat_lng_32,
  i0_.pickup_reference_location AS pickup_reference_location_33,
  i0_.pickup_reference_lat_lng AS pickup_reference_lat_lng_34,
  i0_.transport_carrier_cnpj_digits AS transport_carrier_cnpj_digits_35,
  i0_.transport_carrier_name AS transport_carrier_name_36,
  i0_.routing_responsibility AS routing_responsibility_37,
  i0_.routing_responsibility_source AS routing_responsibility_source_38,
  i0_.routing_responsibility_resolved_at AS routing_responsibility_resolved_at_39,
  i0_.routing_responsibility_overridden_at AS routing_responsibility_overridden_at_40,
  i0_.routing_responsibility_overridden_by AS routing_responsibility_overridden_by_41,
  c1_.id AS id_42,
  c1_.company_name AS company_name_43,
  c1_.cnpj AS cnpj_44,
  c1_.address AS address_45,
  c1_.street_number AS street_number_46,
  c1_.district AS district_47,
  c1_.city AS city_48,
  c1_.zip_code AS zip_code_49,
  c1_.alternate_addr AS alternate_addr_50,
  c1_.alternate_street_number AS alternate_street_number_51,
  c1_.alternate_district AS alternate_district_52,
  c1_.alternate_city AS alternate_city_53,
  c1_.alternate_zip_code AS alternate_zip_code_54,
  c1_.created_at AS created_at_55,
  c1_.updated_at AS updated_at_56,
  i0_.shipper_id AS shipper_id_57,
  i0_.consignee_id AS consignee_id_58,
  i0_.delivery_id AS delivery_id_59,
  i0_.route_id AS route_id_60,
  i0_.transport_carrier_id AS transport_carrier_id_61
FROM
  invoice i0_
  INNER JOIN consignee c1_ ON i0_.consignee_id = c1_.id
WHERE
  i0_.shipper_id = ?
  AND i0_.active = ?
ORDER BY
  i0_.created_at DESC,
  i0_.id DESC
LIMIT
  80

SELECT i0_.id AS id_0, i0_.key_number AS key_number_1, i0_.pdf_filename AS pdf_filename_2, i0_.pod_filename AS pod_filename_3, i0_.number AS number_4, i0_.order_number AS order_number_5, i0_.fiscal_document_type AS fiscal_document_type_6, i0_.volume AS volume_7, i0_.weight AS weight_8, i0_.issue_date AS issue_date_9, i0_.cte AS cte_10, i0_.obs AS obs_11, i0_.total AS total_12, i0_.extra AS extra_13, i0_.items AS items_14, i0_.created_at AS created_at_15, i0_.updated_at AS updated_at_16, i0_.daily_control_date AS daily_control_date_17, i0_.daily_control_order AS daily_control_order_18, i0_.status AS status_19, i0_.routed_at AS routed_at_20, i0_.trip_planning_mode AS trip_planning_mode_21, i0_.routing_engine AS routing_engine_22, i0_.scheduled_routing_queued_at AS scheduled_routing_queued_at_23, i0_.scheduled_routing_ready_at AS scheduled_routing_ready_at_24, i0_.scheduled_routing_released_at AS scheduled_routing_released_at_25, i0_.active AS active_26, i0_.is_nfe AS is_nfe_27, i0_.auto_routing_suppressed AS auto_routing_suppressed_28, i0_.auto_routing_suppressed_at AS auto_routing_suppressed_at_29, i0_.auto_routing_suppressed_reason AS auto_routing_suppressed_reason_30, i0_.dropoff_override_location AS dropoff_override_location_31, i0_.dropoff_override_lat_lng AS dropoff_override_lat_lng_32, i0_.pickup_reference_location AS pickup_reference_location_33, i0_.pickup_reference_lat_lng AS pickup_reference_lat_lng_34, i0_.transport_carrier_cnpj_digits AS transport_carrier_cnpj_digits_35, i0_.transport_carrier_name AS transport_carrier_name_36, i0_.routing_responsibility AS routing_responsibility_37, i0_.routing_responsibility_source AS routing_responsibility_source_38, i0_.routing_responsibility_resolved_at AS routing_responsibility_resolved_at_39, i0_.routing_responsibility_overridden_at AS routing_responsibility_overridden_at_40, i0_.routing_responsibility_overridden_by AS routing_responsibility_overridden_by_41, c1_.id AS id_42, c1_.company_name AS company_name_43, c1_.cnpj AS cnpj_44, c1_.address AS address_45, c1_.street_number AS street_number_46, c1_.district AS district_47, c1_.city AS city_48, c1_.zip_code AS zip_code_49, c1_.alternate_addr AS alternate_addr_50, c1_.alternate_street_number AS alternate_street_number_51, c1_.alternate_district AS alternate_district_52, c1_.alternate_city AS alternate_city_53, c1_.alternate_zip_code AS alternate_zip_code_54, c1_.created_at AS created_at_55, c1_.updated_at AS updated_at_56, i0_.shipper_id AS shipper_id_57, i0_.consignee_id AS consignee_id_58, i0_.delivery_id AS delivery_id_59, i0_.route_id AS route_id_60, i0_.transport_carrier_id AS transport_carrier_id_61 FROM invoice i0_ INNER JOIN consignee c1_ ON i0_.consignee_id = c1_.id WHERE i0_.shipper_id = 20 AND i0_.active = 1 ORDER BY i0_.created_at DESC, i0_.id DESC LIMIT 80;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.departed_at AS departed_at_3,
  t0.delivered_at AS delivered_at_4,
  t0.region_name AS region_name_5,
  t0.pickup_location AS pickup_location_6,
  t0.dropoff_location AS dropoff_location_7,
  t0.pickup_lat_lng AS pickup_lat_lng_8,
  t0.dropoff_lat_lng AS dropoff_lat_lng_9,
  t0.distance AS distance_10,
  t0.operational_order AS operational_order_11,
  t0.delivery_agent_payout AS delivery_agent_payout_12,
  t0.shipper_charge_total AS shipper_charge_total_13,
  t0.shipper_base_amount AS shipper_base_amount_14,
  t0.delivery_agent_base_amount AS delivery_agent_base_amount_15,
  t0.operational_adjustment_applied AS operational_adjustment_applied_16,
  t0.operational_flag_applied AS operational_flag_applied_17,
  t0.shipper_adjustment_factor_applied AS shipper_adjustment_factor_applied_18,
  t0.delivery_agent_adjustment_factor_applied AS delivery_agent_adjustment_factor_applied_19,
  t0.adjustment_reason_code_applied AS adjustment_reason_code_applied_20,
  t0.status AS status_21,
  t0.pod_filename AS pod_filename_22,
  t0.auto_assign_status AS auto_assign_status_23,
  t0.auto_assign_started_at AS auto_assign_started_at_24,
  t0.auto_assign_expires_at AS auto_assign_expires_at_25,
  t0.auto_assign_fail_reason AS auto_assign_fail_reason_26,
  t0.routing_responsibility AS routing_responsibility_27,
  t0.vehicle_catalog_scope AS vehicle_catalog_scope_28,
  t0.routing_context_source AS routing_context_source_29,
  t0.delivery_agent_id AS delivery_agent_id_30,
  t0.consignee_id AS consignee_id_31,
  t0.carrier_id AS carrier_id_32,
  t0.region_id AS region_id_33,
  t0.vehicle_class_id AS vehicle_class_id_34,
  t0.trip_id AS trip_id_35,
  t0.routing_owner_shipper_id AS routing_owner_shipper_id_36,
  t0.routing_driver_pool_id AS routing_driver_pool_id_37,
  t0.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_38
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.delivered_at AS delivered_at_4, t0.region_name AS region_name_5, t0.pickup_location AS pickup_location_6, t0.dropoff_location AS dropoff_location_7, t0.pickup_lat_lng AS pickup_lat_lng_8, t0.dropoff_lat_lng AS dropoff_lat_lng_9, t0.distance AS distance_10, t0.operational_order AS operational_order_11, t0.delivery_agent_payout AS delivery_agent_payout_12, t0.shipper_charge_total AS shipper_charge_total_13, t0.shipper_base_amount AS shipper_base_amount_14, t0.delivery_agent_base_amount AS delivery_agent_base_amount_15, t0.operational_adjustment_applied AS operational_adjustment_applied_16, t0.operational_flag_applied AS operational_flag_applied_17, t0.shipper_adjustment_factor_applied AS shipper_adjustment_factor_applied_18, t0.delivery_agent_adjustment_factor_applied AS delivery_agent_adjustment_factor_applied_19, t0.adjustment_reason_code_applied AS adjustment_reason_code_applied_20, t0.status AS status_21, t0.pod_filename AS pod_filename_22, t0.auto_assign_status AS auto_assign_status_23, t0.auto_assign_started_at AS auto_assign_started_at_24, t0.auto_assign_expires_at AS auto_assign_expires_at_25, t0.auto_assign_fail_reason AS auto_assign_fail_reason_26, t0.routing_responsibility AS routing_responsibility_27, t0.vehicle_catalog_scope AS vehicle_catalog_scope_28, t0.routing_context_source AS routing_context_source_29, t0.delivery_agent_id AS delivery_agent_id_30, t0.consignee_id AS consignee_id_31, t0.carrier_id AS carrier_id_32, t0.region_id AS region_id_33, t0.vehicle_class_id AS vehicle_class_id_34, t0.trip_id AS trip_id_35, t0.routing_owner_shipper_id AS routing_owner_shipper_id_36, t0.routing_driver_pool_id AS routing_driver_pool_id_37, t0.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_38 FROM delivery t0 WHERE t0.id = 168;

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 = 146;

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 = 168;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.departed_at AS departed_at_3,
  t0.delivered_at AS delivered_at_4,
  t0.region_name AS region_name_5,
  t0.pickup_location AS pickup_location_6,
  t0.dropoff_location AS dropoff_location_7,
  t0.pickup_lat_lng AS pickup_lat_lng_8,
  t0.dropoff_lat_lng AS dropoff_lat_lng_9,
  t0.distance AS distance_10,
  t0.operational_order AS operational_order_11,
  t0.delivery_agent_payout AS delivery_agent_payout_12,
  t0.shipper_charge_total AS shipper_charge_total_13,
  t0.shipper_base_amount AS shipper_base_amount_14,
  t0.delivery_agent_base_amount AS delivery_agent_base_amount_15,
  t0.operational_adjustment_applied AS operational_adjustment_applied_16,
  t0.operational_flag_applied AS operational_flag_applied_17,
  t0.shipper_adjustment_factor_applied AS shipper_adjustment_factor_applied_18,
  t0.delivery_agent_adjustment_factor_applied AS delivery_agent_adjustment_factor_applied_19,
  t0.adjustment_reason_code_applied AS adjustment_reason_code_applied_20,
  t0.status AS status_21,
  t0.pod_filename AS pod_filename_22,
  t0.auto_assign_status AS auto_assign_status_23,
  t0.auto_assign_started_at AS auto_assign_started_at_24,
  t0.auto_assign_expires_at AS auto_assign_expires_at_25,
  t0.auto_assign_fail_reason AS auto_assign_fail_reason_26,
  t0.routing_responsibility AS routing_responsibility_27,
  t0.vehicle_catalog_scope AS vehicle_catalog_scope_28,
  t0.routing_context_source AS routing_context_source_29,
  t0.delivery_agent_id AS delivery_agent_id_30,
  t0.consignee_id AS consignee_id_31,
  t0.carrier_id AS carrier_id_32,
  t0.region_id AS region_id_33,
  t0.vehicle_class_id AS vehicle_class_id_34,
  t0.trip_id AS trip_id_35,
  t0.routing_owner_shipper_id AS routing_owner_shipper_id_36,
  t0.routing_driver_pool_id AS routing_driver_pool_id_37,
  t0.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_38
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.delivered_at AS delivered_at_4, t0.region_name AS region_name_5, t0.pickup_location AS pickup_location_6, t0.dropoff_location AS dropoff_location_7, t0.pickup_lat_lng AS pickup_lat_lng_8, t0.dropoff_lat_lng AS dropoff_lat_lng_9, t0.distance AS distance_10, t0.operational_order AS operational_order_11, t0.delivery_agent_payout AS delivery_agent_payout_12, t0.shipper_charge_total AS shipper_charge_total_13, t0.shipper_base_amount AS shipper_base_amount_14, t0.delivery_agent_base_amount AS delivery_agent_base_amount_15, t0.operational_adjustment_applied AS operational_adjustment_applied_16, t0.operational_flag_applied AS operational_flag_applied_17, t0.shipper_adjustment_factor_applied AS shipper_adjustment_factor_applied_18, t0.delivery_agent_adjustment_factor_applied AS delivery_agent_adjustment_factor_applied_19, t0.adjustment_reason_code_applied AS adjustment_reason_code_applied_20, t0.status AS status_21, t0.pod_filename AS pod_filename_22, t0.auto_assign_status AS auto_assign_status_23, t0.auto_assign_started_at AS auto_assign_started_at_24, t0.auto_assign_expires_at AS auto_assign_expires_at_25, t0.auto_assign_fail_reason AS auto_assign_fail_reason_26, t0.routing_responsibility AS routing_responsibility_27, t0.vehicle_catalog_scope AS vehicle_catalog_scope_28, t0.routing_context_source AS routing_context_source_29, t0.delivery_agent_id AS delivery_agent_id_30, t0.consignee_id AS consignee_id_31, t0.carrier_id AS carrier_id_32, t0.region_id AS region_id_33, t0.vehicle_class_id AS vehicle_class_id_34, t0.trip_id AS trip_id_35, t0.routing_owner_shipper_id AS routing_owner_shipper_id_36, t0.routing_driver_pool_id AS routing_driver_pool_id_37, t0.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_38 FROM delivery t0 WHERE t0.trip_id = 146;

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
FROM
  delivery_agent t0
WHERE
  t0.id = ?

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 FROM delivery_agent t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.max_weight AS max_weight_3,
  t0.max_volume AS max_volume_4,
  t0.max_height AS max_height_5,
  t0.max_depth AS max_depth_6,
  t0.max_length AS max_length_7,
  t0.delivery_agent_payout_per_km AS delivery_agent_payout_per_km_8,
  t0.shipper_charge_per_km AS shipper_charge_per_km_9,
  t0.shipper_base_fare AS shipper_base_fare_10,
  t0.shipper_min_km AS shipper_min_km_11,
  t0.shipper_cancellation_fee AS shipper_cancellation_fee_12,
  t0.delivery_agent_base_fare AS delivery_agent_base_fare_13,
  t0.travel_threshold_km AS travel_threshold_km_14,
  t0.shipper_travel_charge_per_km AS shipper_travel_charge_per_km_15,
  t0.shipper_travel_base_fare AS shipper_travel_base_fare_16,
  t0.delivery_agent_travel_payout_per_km AS delivery_agent_travel_payout_per_km_17,
  t0.delivery_agent_travel_base_fare AS delivery_agent_travel_base_fare_18,
  t0.active AS active_19,
  t0.trip_customer_base_fare AS trip_customer_base_fare_20,
  t0.trip_customer_per_km AS trip_customer_per_km_21,
  t0.trip_customer_per_point AS trip_customer_per_point_22,
  t0.trip_driver_base_fare AS trip_driver_base_fare_23,
  t0.trip_driver_per_km AS trip_driver_per_km_24,
  t0.trip_driver_per_point AS trip_driver_per_point_25,
  t0.trip_driver_min_payout AS trip_driver_min_payout_26,
  t0.owner_scope AS owner_scope_27,
  t0.canonical_code AS canonical_code_28,
  t0.display_order AS display_order_29,
  t0.app_public_label AS app_public_label_30,
  t0.app_public_subtitle AS app_public_subtitle_31,
  t0.app_icon_key AS app_icon_key_32,
  t0.app_image_path AS app_image_path_33,
  t0.app_public_visible AS app_public_visible_34,
  t0.owner_shipper_id AS owner_shipper_id_35
FROM
  vehicle_class t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.max_weight AS max_weight_3, t0.max_volume AS max_volume_4, t0.max_height AS max_height_5, t0.max_depth AS max_depth_6, t0.max_length AS max_length_7, t0.delivery_agent_payout_per_km AS delivery_agent_payout_per_km_8, t0.shipper_charge_per_km AS shipper_charge_per_km_9, t0.shipper_base_fare AS shipper_base_fare_10, t0.shipper_min_km AS shipper_min_km_11, t0.shipper_cancellation_fee AS shipper_cancellation_fee_12, t0.delivery_agent_base_fare AS delivery_agent_base_fare_13, t0.travel_threshold_km AS travel_threshold_km_14, t0.shipper_travel_charge_per_km AS shipper_travel_charge_per_km_15, t0.shipper_travel_base_fare AS shipper_travel_base_fare_16, t0.delivery_agent_travel_payout_per_km AS delivery_agent_travel_payout_per_km_17, t0.delivery_agent_travel_base_fare AS delivery_agent_travel_base_fare_18, t0.active AS active_19, t0.trip_customer_base_fare AS trip_customer_base_fare_20, t0.trip_customer_per_km AS trip_customer_per_km_21, t0.trip_customer_per_point AS trip_customer_per_point_22, t0.trip_driver_base_fare AS trip_driver_base_fare_23, t0.trip_driver_per_km AS trip_driver_per_km_24, t0.trip_driver_per_point AS trip_driver_per_point_25, t0.trip_driver_min_payout AS trip_driver_min_payout_26, t0.owner_scope AS owner_scope_27, t0.canonical_code AS canonical_code_28, t0.display_order AS display_order_29, t0.app_public_label AS app_public_label_30, t0.app_public_subtitle AS app_public_subtitle_31, t0.app_icon_key AS app_icon_key_32, t0.app_image_path AS app_image_path_33, t0.app_public_visible AS app_public_visible_34, t0.owner_shipper_id AS owner_shipper_id_35 FROM vehicle_class t0 WHERE t0.id = 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_.status = ?
  AND t0_.mode <> ?
ORDER BY
  t0_.created_at ASC,
  t0_.id ASC

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_.status = 'PENDING_APPROVAL' AND t0_.mode <> 'SCHEDULED' ORDER BY t0_.created_at ASC, t0_.id ASC;