Query Metrics
9
Database Queries
9
Different statements
2.11 ms
Query time
0
Invalid entities
16
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.28 ms (13.38%) |
1 |
SELECT t0.id AS id_1, t0.cpf AS cpf_2, t0.name AS name_3, t0.email AS email_4, t0.password AS password_5, t0.employment_type AS employment_type_6, t0.is_active AS is_active_7, t0.can_receive_auto_offers AS can_receive_auto_offers_8, t0.api_token AS api_token_9, t0.api_token_created_at AS api_token_created_at_10, t0.presence_status AS presence_status_11, t0.last_seen_at AS last_seen_at_12, t0.last_latitude AS last_latitude_13, t0.last_longitude AS last_longitude_14, t0.last_location_accuracy AS last_location_accuracy_15, t0.last_location_bearing AS last_location_bearing_16, t0.last_location_speed AS last_location_speed_17, t0.last_location_at AS last_location_at_18, t0.presence_updated_at AS presence_updated_at_19, t0.presence_effective_status AS presence_effective_status_20, t0.created_at AS created_at_21, t0.rate_payout_adjustment AS rate_payout_adjustment_22, t0.last_selected_driver_vehicle_assignment_id AS last_selected_driver_vehicle_assignment_id_23 FROM delivery_agent t0 WHERE t0.api_token = ? LIMIT 1
Parameters:
[
"32f5a164b8de806b9a986b69c7466e54bc186c95bb71fe37475d2ec744c302ac"
]
|
|
0.28 ms (13.06%) |
1 |
SELECT t0.id AS id_1, t0.status AS status_2, t0.phone_e164 AS phone_e164_3, t0.phone_verified_at AS phone_verified_at_4, t0.birth_date AS birth_date_5, t0.driver_license_number AS driver_license_number_6, t0.driver_license_categories AS driver_license_categories_7, t0.driver_license_first_issued_at AS driver_license_first_issued_at_8, t0.driver_license_expires_at AS driver_license_expires_at_9, t0.driver_license_has_ear AS driver_license_has_ear_10, t0.operation_city AS operation_city_11, t0.operation_state AS operation_state_12, t0.terms_version AS terms_version_13, t0.terms_accepted_at AS terms_accepted_at_14, t0.privacy_notice_version AS privacy_notice_version_15, t0.privacy_notice_accepted_at AS privacy_notice_accepted_at_16, t0.biometric_notice_version AS biometric_notice_version_17, t0.biometric_notice_accepted_at AS biometric_notice_accepted_at_18, t0.submitted_at AS submitted_at_19, t0.reviewed_at AS reviewed_at_20, t0.approved_at AS approved_at_21, t0.rejected_at AS rejected_at_22, t0.suspended_at AS suspended_at_23, t0.cancelled_at AS cancelled_at_24, t0.cancelled_by_type AS cancelled_by_type_25, t0.cancellation_reason_code AS cancellation_reason_code_26, t0.cancellation_reason AS cancellation_reason_27, t0.closure_requested_at AS closure_requested_at_28, t0.closed_at AS closed_at_29, t0.deletion_scheduled_at AS deletion_scheduled_at_30, t0.review_reason AS review_reason_31, t0.internal_notes AS internal_notes_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.delivery_agent_id AS delivery_agent_id_35, t0.reviewed_by_user_id AS reviewed_by_user_id_36, t0.cancelled_by_user_id AS cancelled_by_user_id_37 FROM driver_onboarding_application t0 WHERE t0.delivery_agent_id = ? LIMIT 1
Parameters:
[
44
]
|
|
0.27 ms (12.63%) |
1 |
SELECT t0_.id AS id_0, t0_.draft_key AS draft_key_1, t0_.operational_route_number AS operational_route_number_2, t0_.operational_route_code AS operational_route_code_3, t0_.mode AS mode_4, t0_.planning_source AS planning_source_5, t0_.status AS status_6, t0_.planned_date AS planned_date_7, t0_.payload_json AS payload_json_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, r1_.id AS id_11, r1_.name AS name_12, r1_.customer_financial_scope AS customer_financial_scope_13, r1_.driver_financial_scope AS driver_financial_scope_14, t0_.route_id AS route_id_15, t0_.trip_id AS trip_id_16, r1_.delivery_agent_id AS delivery_agent_id_17 FROM trip_approval_draft t0_ LEFT JOIN route r1_ ON t0_.route_id = r1_.id WHERE t0_.trip_id = ? LIMIT 1
Parameters:
[
165
]
|
|
0.24 ms (11.25%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.departed_at AS departed_at_3, t0.assigned_vehicle_snapshot AS assigned_vehicle_snapshot_4, t0.delivered_at AS delivered_at_5, t0.region_name AS region_name_6, t0.pickup_location AS pickup_location_7, t0.dropoff_location AS dropoff_location_8, t0.pickup_lat_lng AS pickup_lat_lng_9, t0.dropoff_lat_lng AS dropoff_lat_lng_10, t0.distance AS distance_11, t0.operational_order AS operational_order_12, t0.delivery_agent_payout AS delivery_agent_payout_13, t0.shipper_charge_total AS shipper_charge_total_14, t0.shipper_base_amount AS shipper_base_amount_15, t0.delivery_agent_base_amount AS delivery_agent_base_amount_16, t0.operational_adjustment_applied AS operational_adjustment_applied_17, t0.operational_flag_applied AS operational_flag_applied_18, t0.shipper_adjustment_factor_applied AS shipper_adjustment_factor_applied_19, t0.delivery_agent_adjustment_factor_applied AS delivery_agent_adjustment_factor_applied_20, t0.adjustment_reason_code_applied AS adjustment_reason_code_applied_21, t0.status AS status_22, t0.pod_filename AS pod_filename_23, t0.auto_assign_status AS auto_assign_status_24, t0.auto_assign_started_at AS auto_assign_started_at_25, t0.auto_assign_expires_at AS auto_assign_expires_at_26, t0.auto_assign_fail_reason AS auto_assign_fail_reason_27, t0.routing_responsibility AS routing_responsibility_28, t0.vehicle_catalog_scope AS vehicle_catalog_scope_29, t0.routing_context_source AS routing_context_source_30, t0.delivery_agent_id AS delivery_agent_id_31, t0.assigned_driver_vehicle_assignment_id AS assigned_driver_vehicle_assignment_id_32, t0.assigned_driver_vehicle_id AS assigned_driver_vehicle_id_33, t0.assigned_vehicle_class_id AS assigned_vehicle_class_id_34, t0.consignee_id AS consignee_id_35, t0.carrier_id AS carrier_id_36, t0.region_id AS region_id_37, t0.vehicle_class_id AS vehicle_class_id_38, t0.trip_id AS trip_id_39, t0.routing_owner_shipper_id AS routing_owner_shipper_id_40, t0.routing_driver_pool_id AS routing_driver_pool_id_41, t0.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_42 FROM delivery t0 WHERE t0.trip_id = ?
Parameters:
[
165
]
|
|
0.24 ms (11.20%) |
1 |
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 = ?
Parameters:
[
187
]
|
|
0.23 ms (10.83%) |
1 |
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 = ?
Parameters:
[
165
]
|
|
0.20 ms (9.58%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.departed_at AS departed_at_3, t0.assigned_vehicle_snapshot AS assigned_vehicle_snapshot_4, t0.delivered_at AS delivered_at_5, t0.region_name AS region_name_6, t0.pickup_location AS pickup_location_7, t0.dropoff_location AS dropoff_location_8, t0.pickup_lat_lng AS pickup_lat_lng_9, t0.dropoff_lat_lng AS dropoff_lat_lng_10, t0.distance AS distance_11, t0.operational_order AS operational_order_12, t0.delivery_agent_payout AS delivery_agent_payout_13, t0.shipper_charge_total AS shipper_charge_total_14, t0.shipper_base_amount AS shipper_base_amount_15, t0.delivery_agent_base_amount AS delivery_agent_base_amount_16, t0.operational_adjustment_applied AS operational_adjustment_applied_17, t0.operational_flag_applied AS operational_flag_applied_18, t0.shipper_adjustment_factor_applied AS shipper_adjustment_factor_applied_19, t0.delivery_agent_adjustment_factor_applied AS delivery_agent_adjustment_factor_applied_20, t0.adjustment_reason_code_applied AS adjustment_reason_code_applied_21, t0.status AS status_22, t0.pod_filename AS pod_filename_23, t0.auto_assign_status AS auto_assign_status_24, t0.auto_assign_started_at AS auto_assign_started_at_25, t0.auto_assign_expires_at AS auto_assign_expires_at_26, t0.auto_assign_fail_reason AS auto_assign_fail_reason_27, t0.routing_responsibility AS routing_responsibility_28, t0.vehicle_catalog_scope AS vehicle_catalog_scope_29, t0.routing_context_source AS routing_context_source_30, t0.delivery_agent_id AS delivery_agent_id_31, t0.assigned_driver_vehicle_assignment_id AS assigned_driver_vehicle_assignment_id_32, t0.assigned_driver_vehicle_id AS assigned_driver_vehicle_id_33, t0.assigned_vehicle_class_id AS assigned_vehicle_class_id_34, t0.consignee_id AS consignee_id_35, t0.carrier_id AS carrier_id_36, t0.region_id AS region_id_37, t0.vehicle_class_id AS vehicle_class_id_38, t0.trip_id AS trip_id_39, t0.routing_owner_shipper_id AS routing_owner_shipper_id_40, t0.routing_driver_pool_id AS routing_driver_pool_id_41, t0.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_42 FROM delivery t0 WHERE t0.id = ?
Parameters:
[
187
]
|
|
0.19 ms (9.15%) |
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 = ? LIMIT 1
Parameters:
[
"32f5a164b8de806b9a986b69c7466e54bc186c95bb71fe37475d2ec744c302ac"
]
|
|
0.19 ms (8.93%) |
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
Parameters:
[
44
]
|
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\DeliveryAgent | 1 |
| App\Entity\DriverVehicleAssignment | 1 |
| App\Entity\DriverOnboardingApplication | 1 |
| App\Entity\User | 1 |
| App\Entity\DriverAccountAccess | 1 |
| App\Entity\Delivery | 1 |
| App\Entity\DriverVehicle | 1 |
| App\Entity\VehicleClass | 1 |
| App\Entity\Consignee | 1 |
| App\Entity\Carrier | 1 |
| App\Entity\Region | 1 |
| App\Entity\Trip | 1 |
| App\Entity\Shipper | 1 |
| App\Entity\Route | 1 |
| App\Entity\Invoice | 1 |
| App\Entity\TripApprovalDraft | 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\Delivery | No errors. |
| App\Entity\DriverVehicle | No errors. |
| App\Entity\Consignee | No errors. |
| App\Entity\Carrier | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\Trip | No errors. |
| App\Entity\Shipper | No errors. |
| App\Entity\DriverPool | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\Route | No errors. |
| App\Entity\RouteOperationProfile | No errors. |
| App\Entity\TripApprovalDraft | No errors. |