Symfony Profiler

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.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 FROM delivery_agent t0 WHERE t0.api_token = '26d7582d0036a6b731a34e79f92dacc4bae3ecef13f4ac71de5968982eed8cfd' LIMIT 1;

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

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE delivery_agent SET last_seen_at = '2026-07-02 18:47:56', last_latitude = -25.5525938, last_longitude = -49.2681129, last_location_at = '2026-07-02 18:47:56' WHERE id = 1;

"COMMIT"

"COMMIT";