Symfony Profiler

"COMMIT"

"COMMIT";

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
  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.mobility_mode AS mobility_mode_2,
  t0.self_registration_enabled AS self_registration_enabled_3,
  t0.requires_plate AS requires_plate_4,
  t0.requires_crlv AS requires_crlv_5,
  t0.requires_ear AS requires_ear_6,
  t0.allows_shared_vehicle AS allows_shared_vehicle_7,
  t0.minimum_age_years AS minimum_age_years_8,
  t0.minimum_license_months AS minimum_license_months_9,
  t0.required_cnh_categories AS required_cnh_categories_10,
  t0.required_person_document_types AS required_person_document_types_11,
  t0.required_vehicle_document_types AS required_vehicle_document_types_12,
  t0.required_assignment_document_types AS required_assignment_document_types_13,
  t0.active AS active_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.vehicle_class_id AS vehicle_class_id_17
FROM
  vehicle_class_driver_policy t0
WHERE
  t0.vehicle_class_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.mobility_mode AS mobility_mode_2, t0.self_registration_enabled AS self_registration_enabled_3, t0.requires_plate AS requires_plate_4, t0.requires_crlv AS requires_crlv_5, t0.requires_ear AS requires_ear_6, t0.allows_shared_vehicle AS allows_shared_vehicle_7, t0.minimum_age_years AS minimum_age_years_8, t0.minimum_license_months AS minimum_license_months_9, t0.required_cnh_categories AS required_cnh_categories_10, t0.required_person_document_types AS required_person_document_types_11, t0.required_vehicle_document_types AS required_vehicle_document_types_12, t0.required_assignment_document_types AS required_assignment_document_types_13, t0.active AS active_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.vehicle_class_id AS vehicle_class_id_17 FROM vehicle_class_driver_policy t0 WHERE t0.vehicle_class_id = 1 LIMIT 1;

UPDATE
  delivery_agent
SET
  last_seen_at = ?,
  last_latitude = ?,
  last_longitude = ?,
  last_location_accuracy = ?,
  last_location_bearing = ?,
  last_location_speed = ?,
  last_location_at = ?
WHERE
  id = ?

UPDATE delivery_agent SET last_seen_at = '2026-07-23 09:37:11', last_latitude = -25.493285, last_longitude = -49.2806983, last_location_accuracy = 1.1, last_location_bearing = NULL, last_location_speed = 0, last_location_at = '2026-07-23 09:37:11' WHERE id = 44;

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

SELECT
  DATABASE()

SELECT DATABASE();

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

SELECT
  t0.id AS id_1,
  t0.scope AS scope_2,
  t0.document_type AS document_type_3,
  t0.version AS version_4,
  t0.storage_path AS storage_path_5,
  t0.original_name AS original_name_6,
  t0.mime_type AS mime_type_7,
  t0.size_bytes AS size_bytes_8,
  t0.sha256 AS sha256_9,
  t0.status AS status_10,
  t0.valid_until AS valid_until_11,
  t0.reviewed_at AS reviewed_at_12,
  t0.decision_reason AS decision_reason_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.delivery_agent_id AS delivery_agent_id_16,
  t0.driver_vehicle_id AS driver_vehicle_id_17,
  t0.driver_vehicle_assignment_id AS driver_vehicle_assignment_id_18,
  t0.vehicle_class_id AS vehicle_class_id_19,
  t0.reviewed_by_user_id AS reviewed_by_user_id_20
FROM
  driver_onboarding_document t0
WHERE
  t0.delivery_agent_id = ?
ORDER BY
  t0.created_at DESC,
  t0.id DESC

SELECT t0.id AS id_1, t0.scope AS scope_2, t0.document_type AS document_type_3, t0.version AS version_4, t0.storage_path AS storage_path_5, t0.original_name AS original_name_6, t0.mime_type AS mime_type_7, t0.size_bytes AS size_bytes_8, t0.sha256 AS sha256_9, t0.status AS status_10, t0.valid_until AS valid_until_11, t0.reviewed_at AS reviewed_at_12, t0.decision_reason AS decision_reason_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.delivery_agent_id AS delivery_agent_id_16, t0.driver_vehicle_id AS driver_vehicle_id_17, t0.driver_vehicle_assignment_id AS driver_vehicle_assignment_id_18, t0.vehicle_class_id AS vehicle_class_id_19, t0.reviewed_by_user_id AS reviewed_by_user_id_20 FROM driver_onboarding_document t0 WHERE t0.delivery_agent_id = 44 ORDER BY t0.created_at DESC, t0.id DESC;

SELECT
  s0_.id AS id_0,
  s0_.archive_invoices_after_days AS archive_invoices_after_days_1,
  s0_.google_api_key AS google_api_key_2,
  s0_.operator_menu_permissions AS operator_menu_permissions_3,
  s0_.src_email_hostname AS src_email_hostname_4,
  s0_.src_emailusername AS src_emailusername_5,
  s0_.src_email_password AS src_email_password_6,
  s0_.src_email_provider AS src_email_provider_7,
  s0_.invoice_pdf_retention_days AS invoice_pdf_retention_days_8,
  s0_.auto_delivery_revert_to_avulsa_minutes AS auto_delivery_revert_to_avulsa_minutes_9,
  s0_.driver_search_max_minutes AS driver_search_max_minutes_10,
  s0_.offer_timeout_seconds_auto AS offer_timeout_seconds_auto_11,
  s0_.offer_timeout_seconds_directed AS offer_timeout_seconds_directed_12,
  s0_.progressive_offer_enabled AS progressive_offer_enabled_13,
  s0_.progressive_offer_layer_count AS progressive_offer_layer_count_14,
  s0_.progressive_offer_layers AS progressive_offer_layers_15,
  s0_.presence_timeout_seconds AS presence_timeout_seconds_16,
  s0_.presence_web_notifications_enabled AS presence_web_notifications_enabled_17,
  s0_.invoice_created_web_notifications_enabled AS invoice_created_web_notifications_enabled_18,
  s0_.invoice_validated_web_notifications_enabled AS invoice_validated_web_notifications_enabled_19,
  s0_.delivery_accepted_web_notifications_enabled AS delivery_accepted_web_notifications_enabled_20,
  s0_.delivery_departed_web_notifications_enabled AS delivery_departed_web_notifications_enabled_21,
  s0_.delivery_delivered_web_notifications_enabled AS delivery_delivered_web_notifications_enabled_22,
  s0_.presence_web_poll_seconds AS presence_web_poll_seconds_23,
  s0_.operational_base_address AS operational_base_address_24,
  s0_.operational_flag_code AS operational_flag_code_25,
  s0_.green_flag_factor AS green_flag_factor_26,
  s0_.yellow_flag_factor AS yellow_flag_factor_27,
  s0_.orange_flag_factor AS orange_flag_factor_28,
  s0_.red_flag_factor AS red_flag_factor_29,
  s0_.black_flag_factor AS black_flag_factor_30,
  s0_.custom_shipper_adjustment_factor AS custom_shipper_adjustment_factor_31,
  s0_.custom_delivery_agent_adjustment_factor AS custom_delivery_agent_adjustment_factor_32,
  s0_.adjustment_reason_code AS adjustment_reason_code_33,
  s0_.adjustment_started_at AS adjustment_started_at_34,
  s0_.adjustment_ends_at AS adjustment_ends_at_35,
  s0_.daily_control_cutoff_time AS daily_control_cutoff_time_36,
  s0_.scheduled_routing_dispatch_time AS scheduled_routing_dispatch_time_37,
  s0_.direct_grouping_tolerance AS direct_grouping_tolerance_38,
  s0_.route_affinity_visual_tolerance AS route_affinity_visual_tolerance_39,
  s0_.daily_control_skip_saturday AS daily_control_skip_saturday_40,
  s0_.daily_control_skip_sunday AS daily_control_skip_sunday_41,
  s0_.daily_control_use_holiday_calendar AS daily_control_use_holiday_calendar_42,
  s0_.daily_control_holiday_dates AS daily_control_holiday_dates_43
FROM
  system_config s0_
LIMIT
  1

SELECT s0_.id AS id_0, s0_.archive_invoices_after_days AS archive_invoices_after_days_1, s0_.google_api_key AS google_api_key_2, s0_.operator_menu_permissions AS operator_menu_permissions_3, s0_.src_email_hostname AS src_email_hostname_4, s0_.src_emailusername AS src_emailusername_5, s0_.src_email_password AS src_email_password_6, s0_.src_email_provider AS src_email_provider_7, s0_.invoice_pdf_retention_days AS invoice_pdf_retention_days_8, s0_.auto_delivery_revert_to_avulsa_minutes AS auto_delivery_revert_to_avulsa_minutes_9, s0_.driver_search_max_minutes AS driver_search_max_minutes_10, s0_.offer_timeout_seconds_auto AS offer_timeout_seconds_auto_11, s0_.offer_timeout_seconds_directed AS offer_timeout_seconds_directed_12, s0_.progressive_offer_enabled AS progressive_offer_enabled_13, s0_.progressive_offer_layer_count AS progressive_offer_layer_count_14, s0_.progressive_offer_layers AS progressive_offer_layers_15, s0_.presence_timeout_seconds AS presence_timeout_seconds_16, s0_.presence_web_notifications_enabled AS presence_web_notifications_enabled_17, s0_.invoice_created_web_notifications_enabled AS invoice_created_web_notifications_enabled_18, s0_.invoice_validated_web_notifications_enabled AS invoice_validated_web_notifications_enabled_19, s0_.delivery_accepted_web_notifications_enabled AS delivery_accepted_web_notifications_enabled_20, s0_.delivery_departed_web_notifications_enabled AS delivery_departed_web_notifications_enabled_21, s0_.delivery_delivered_web_notifications_enabled AS delivery_delivered_web_notifications_enabled_22, s0_.presence_web_poll_seconds AS presence_web_poll_seconds_23, s0_.operational_base_address AS operational_base_address_24, s0_.operational_flag_code AS operational_flag_code_25, s0_.green_flag_factor AS green_flag_factor_26, s0_.yellow_flag_factor AS yellow_flag_factor_27, s0_.orange_flag_factor AS orange_flag_factor_28, s0_.red_flag_factor AS red_flag_factor_29, s0_.black_flag_factor AS black_flag_factor_30, s0_.custom_shipper_adjustment_factor AS custom_shipper_adjustment_factor_31, s0_.custom_delivery_agent_adjustment_factor AS custom_delivery_agent_adjustment_factor_32, s0_.adjustment_reason_code AS adjustment_reason_code_33, s0_.adjustment_started_at AS adjustment_started_at_34, s0_.adjustment_ends_at AS adjustment_ends_at_35, s0_.daily_control_cutoff_time AS daily_control_cutoff_time_36, s0_.scheduled_routing_dispatch_time AS scheduled_routing_dispatch_time_37, s0_.direct_grouping_tolerance AS direct_grouping_tolerance_38, s0_.route_affinity_visual_tolerance AS route_affinity_visual_tolerance_39, s0_.daily_control_skip_saturday AS daily_control_skip_saturday_40, s0_.daily_control_skip_sunday AS daily_control_skip_sunday_41, s0_.daily_control_use_holiday_calendar AS daily_control_use_holiday_calendar_42, s0_.daily_control_holiday_dates AS daily_control_holiday_dates_43 FROM system_config s0_ LIMIT 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.map_icon_key AS map_icon_key_34,
  t0.map_icon_path AS map_icon_path_35,
  t0.app_public_visible AS app_public_visible_36,
  t0.owner_shipper_id AS owner_shipper_id_37
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.map_icon_key AS map_icon_key_34, t0.map_icon_path AS map_icon_path_35, t0.app_public_visible AS app_public_visible_36, t0.owner_shipper_id AS owner_shipper_id_37 FROM vehicle_class t0 WHERE t0.id = 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 = ?
  AND t0.status = ?
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 AND t0.status = 'APPROVED' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.source AS source_3,
  t0.valid_from AS valid_from_4,
  t0.valid_until AS valid_until_5,
  t0.reviewed_at AS reviewed_at_6,
  t0.decision_reason AS decision_reason_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.delivery_agent_id AS delivery_agent_id_10,
  t0.vehicle_class_id AS vehicle_class_id_11,
  t0.reviewed_by_user_id AS reviewed_by_user_id_12
FROM
  driver_class_qualification t0
WHERE
  t0.delivery_agent_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.source AS source_3, t0.valid_from AS valid_from_4, t0.valid_until AS valid_until_5, t0.reviewed_at AS reviewed_at_6, t0.decision_reason AS decision_reason_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.delivery_agent_id AS delivery_agent_id_10, t0.vehicle_class_id AS vehicle_class_id_11, t0.reviewed_by_user_id AS reviewed_by_user_id_12 FROM driver_class_qualification t0 WHERE t0.delivery_agent_id = 44;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.valid_from AS valid_from_3,
  t0.valid_until AS valid_until_4,
  t0.reviewed_at AS reviewed_at_5,
  t0.decision_reason AS decision_reason_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.driver_vehicle_id AS driver_vehicle_id_9,
  t0.vehicle_class_id AS vehicle_class_id_10,
  t0.reviewed_by_user_id AS reviewed_by_user_id_11
FROM
  driver_vehicle_class_eligibility t0
WHERE
  t0.driver_vehicle_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.valid_from AS valid_from_3, t0.valid_until AS valid_until_4, t0.reviewed_at AS reviewed_at_5, t0.decision_reason AS decision_reason_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.driver_vehicle_id AS driver_vehicle_id_9, t0.vehicle_class_id AS vehicle_class_id_10, t0.reviewed_by_user_id AS reviewed_by_user_id_11 FROM driver_vehicle_class_eligibility t0 WHERE t0.driver_vehicle_id = 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;

UPDATE
  driver_active_vehicle_lease
SET
  heartbeat_at = ?,
  expires_at = ?
WHERE
  id = ?

UPDATE driver_active_vehicle_lease SET heartbeat_at = '2026-07-23 09:37:11', expires_at = '2026-07-23 09:41:11' WHERE id = 64;

SELECT
  t0.id AS id_1,
  t0.presence_session_id AS presence_session_id_2,
  t0.device_label AS device_label_3,
  t0.acquired_at AS acquired_at_4,
  t0.heartbeat_at AS heartbeat_at_5,
  t0.expires_at AS expires_at_6,
  t0.delivery_agent_id AS delivery_agent_id_7,
  t0.driver_vehicle_assignment_id AS driver_vehicle_assignment_id_8,
  t0.driver_vehicle_id AS driver_vehicle_id_9
FROM
  driver_active_vehicle_lease t0
WHERE
  t0.driver_vehicle_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.presence_session_id AS presence_session_id_2, t0.device_label AS device_label_3, t0.acquired_at AS acquired_at_4, t0.heartbeat_at AS heartbeat_at_5, t0.expires_at AS expires_at_6, t0.delivery_agent_id AS delivery_agent_id_7, t0.driver_vehicle_assignment_id AS driver_vehicle_assignment_id_8, t0.driver_vehicle_id AS driver_vehicle_id_9 FROM driver_active_vehicle_lease t0 WHERE t0.driver_vehicle_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.plate_normalized AS plate_normalized_2,
  t0.renavam_normalized AS renavam_normalized_3,
  t0.registration_identifier AS registration_identifier_4,
  t0.make AS make_5,
  t0.model AS model_6,
  t0.color AS color_7,
  t0.manufacture_year AS manufacture_year_8,
  t0.model_year AS model_year_9,
  t0.status AS status_10,
  t0.active AS active_11,
  t0.valid_until AS valid_until_12,
  t0.submitted_at AS submitted_at_13,
  t0.reviewed_at AS reviewed_at_14,
  t0.decision_reason AS decision_reason_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.created_by_delivery_agent_id AS created_by_delivery_agent_id_18,
  t0.reviewed_by_user_id AS reviewed_by_user_id_19
FROM
  driver_vehicle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.plate_normalized AS plate_normalized_2, t0.renavam_normalized AS renavam_normalized_3, t0.registration_identifier AS registration_identifier_4, t0.make AS make_5, t0.model AS model_6, t0.color AS color_7, t0.manufacture_year AS manufacture_year_8, t0.model_year AS model_year_9, t0.status AS status_10, t0.active AS active_11, t0.valid_until AS valid_until_12, t0.submitted_at AS submitted_at_13, t0.reviewed_at AS reviewed_at_14, t0.decision_reason AS decision_reason_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.created_by_delivery_agent_id AS created_by_delivery_agent_id_18, t0.reviewed_by_user_id AS reviewed_by_user_id_19 FROM driver_vehicle t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.relationship_type AS relationship_type_2,
  t0.status AS status_3,
  t0.active AS active_4,
  t0.valid_from AS valid_from_5,
  t0.valid_until AS valid_until_6,
  t0.submitted_at AS submitted_at_7,
  t0.reviewed_at AS reviewed_at_8,
  t0.decision_reason AS decision_reason_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.delivery_agent_id AS delivery_agent_id_12,
  t0.driver_vehicle_id AS driver_vehicle_id_13,
  t0.reviewed_by_user_id AS reviewed_by_user_id_14
FROM
  driver_vehicle_assignment t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.relationship_type AS relationship_type_2, t0.status AS status_3, t0.active AS active_4, t0.valid_from AS valid_from_5, t0.valid_until AS valid_until_6, t0.submitted_at AS submitted_at_7, t0.reviewed_at AS reviewed_at_8, t0.decision_reason AS decision_reason_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.delivery_agent_id AS delivery_agent_id_12, t0.driver_vehicle_id AS driver_vehicle_id_13, t0.reviewed_by_user_id AS reviewed_by_user_id_14 FROM driver_vehicle_assignment t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.presence_session_id AS presence_session_id_2,
  t0.device_label AS device_label_3,
  t0.acquired_at AS acquired_at_4,
  t0.heartbeat_at AS heartbeat_at_5,
  t0.expires_at AS expires_at_6,
  t0.delivery_agent_id AS delivery_agent_id_7,
  t0.driver_vehicle_assignment_id AS driver_vehicle_assignment_id_8,
  t0.driver_vehicle_id AS driver_vehicle_id_9
FROM
  driver_active_vehicle_lease t0
WHERE
  t0.delivery_agent_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.presence_session_id AS presence_session_id_2, t0.device_label AS device_label_3, t0.acquired_at AS acquired_at_4, t0.heartbeat_at AS heartbeat_at_5, t0.expires_at AS expires_at_6, t0.delivery_agent_id AS delivery_agent_id_7, t0.driver_vehicle_assignment_id AS driver_vehicle_assignment_id_8, t0.driver_vehicle_id AS driver_vehicle_id_9 FROM driver_active_vehicle_lease t0 WHERE t0.delivery_agent_id = 44 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";