POST https://sistema.xmoto.com.br/api/driver/ping

Response
200 OK
IP
177.4.64.20
Profiled on
Token
19a19c

Query Metrics

27 Database Queries
21 Different statements
8.84 ms Query time
0 Invalid entities
17 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.27 ms 
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
Parameters: 
[
  "32f5a164b8de806b9a986b69c7466e54bc186c95bb71fe37475d2ec744c302ac"
]
View formatted query    View runnable query    Explain query
2 0.25 ms 
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
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
3 0.25 ms 
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
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
4 0.32 ms 
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
Parameters: 
[
  "32f5a164b8de806b9a986b69c7466e54bc186c95bb71fe37475d2ec744c302ac"
]
View formatted query    View runnable query    Explain query
5 0.19 ms 
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
Parameters: 
[
  44
  "APPROVED"
]
View formatted query    View runnable query    Explain query
6 0.14 ms 
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
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
7 0.15 ms 
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 = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
8 0.14 ms 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
9 0.16 ms 
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 = ?
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
10 0.18 ms 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
11 0.14 ms 
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
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
12 0.16 ms 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
13 0.17 ms 
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
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
14 0.12 ms 
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
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
15 0.18 ms 
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
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
16 0.12 ms 
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
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
17 0.07 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
18 0.92 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "app"
]
View formatted query    View runnable query    Explain query
19 0.07 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
20 0.78 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "app"
]
View formatted query    View runnable query    Explain query
21 0.06 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
22 0.77 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "app"
]
View formatted query    View runnable query    Explain query
23 0.18 ms 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query
24 0.06 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
25 0.23 ms 
UPDATE delivery_agent SET last_seen_at = ?, last_latitude = ?, last_longitude = ?, last_location_speed = ?, last_location_at = ? WHERE id = ?
Parameters: 
[
  "2026-07-22 22:53:14"
  -25.5525312
  -49.2681065
  0.03493277
  "2026-07-22 22:53:14"
  44
]
View formatted query    View runnable query    Explain query
26 0.13 ms 
UPDATE driver_active_vehicle_lease SET heartbeat_at = ?, expires_at = ? WHERE id = ?
Parameters: 
[
  "2026-07-22 22:53:14"
  "2026-07-22 22:57:14"
  61
]
View formatted query    View runnable query    Explain query
27 2.64 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\DriverOnboardingDocument 5
App\Entity\DeliveryAgent 1
App\Entity\DriverVehicleAssignment 1
App\Entity\DriverOnboardingApplication 1
App\Entity\User 1
App\Entity\DriverAccountAccess 1
App\Entity\DriverActiveVehicleLease 1
App\Entity\DriverVehicle 1
App\Entity\DriverClassQualification 1
App\Entity\VehicleClass 1
App\Entity\VehicleClassDriverPolicy 1
App\Entity\DriverVehicleClassEligibility 1
App\Entity\SystemConfig 1

Entities Mapping

Class Mapping errors
App\Entity\DeliveryAgent No errors.
App\Entity\DriverVehicleAssignment No errors.
App\Entity\VehicleClass No errors.
App\Entity\DriverOnboardingApplication No errors.
App\Entity\User No errors.
App\Entity\DriverAccountAccess No errors.
App\Entity\DriverActiveVehicleLease No errors.
App\Entity\DriverVehicle No errors.
App\Entity\DriverClassQualification No errors.
App\Entity\Shipper No errors.
App\Entity\VehicleClassDriverPolicy No errors.
App\Entity\DriverVehicleClassEligibility No errors.
App\Entity\DriverOnboardingDocument No errors.
App\Entity\SystemConfig No errors.