Query Metrics
12
Database Queries
12
Different statements
2.71 ms
Query time
0
Invalid entities
17
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.33 ms (12.13%) |
1 |
SELECT d0_.id AS id_0, d0_.created_at AS created_at_1, d0_.departed_at AS departed_at_2, d0_.assigned_vehicle_snapshot AS assigned_vehicle_snapshot_3, d0_.delivered_at AS delivered_at_4, d0_.region_name AS region_name_5, d0_.pickup_location AS pickup_location_6, d0_.dropoff_location AS dropoff_location_7, d0_.pickup_lat_lng AS pickup_lat_lng_8, d0_.dropoff_lat_lng AS dropoff_lat_lng_9, d0_.distance AS distance_10, d0_.operational_order AS operational_order_11, d0_.delivery_agent_payout AS delivery_agent_payout_12, d0_.shipper_charge_total AS shipper_charge_total_13, d0_.shipper_base_amount AS shipper_base_amount_14, d0_.delivery_agent_base_amount AS delivery_agent_base_amount_15, d0_.operational_adjustment_applied AS operational_adjustment_applied_16, d0_.operational_flag_applied AS operational_flag_applied_17, d0_.shipper_adjustment_factor_applied AS shipper_adjustment_factor_applied_18, d0_.delivery_agent_adjustment_factor_applied AS delivery_agent_adjustment_factor_applied_19, d0_.adjustment_reason_code_applied AS adjustment_reason_code_applied_20, d0_.status AS status_21, d0_.pod_filename AS pod_filename_22, d0_.auto_assign_status AS auto_assign_status_23, d0_.auto_assign_started_at AS auto_assign_started_at_24, d0_.auto_assign_expires_at AS auto_assign_expires_at_25, d0_.auto_assign_fail_reason AS auto_assign_fail_reason_26, d0_.routing_responsibility AS routing_responsibility_27, d0_.vehicle_catalog_scope AS vehicle_catalog_scope_28, d0_.routing_context_source AS routing_context_source_29, t1_.id AS id_30, t1_.operational_route_number AS operational_route_number_31, t1_.operational_route_code AS operational_route_code_32, t1_.trip_kind AS trip_kind_33, t1_.mode AS mode_34, t1_.planning_source AS planning_source_35, t1_.status AS status_36, t1_.planned_date AS planned_date_37, t1_.estimated_km AS estimated_km_38, t1_.estimated_duration_minutes AS estimated_duration_minutes_39, t1_.route_geometry_json AS route_geometry_json_40, t1_.total_weight AS total_weight_41, t1_.total_volume AS total_volume_42, t1_.point_count AS point_count_43, t1_.invoice_count AS invoice_count_44, t1_.customer_charge_total AS customer_charge_total_45, t1_.driver_payout_total AS driver_payout_total_46, t1_.customer_financial_scope AS customer_financial_scope_47, t1_.driver_financial_scope AS driver_financial_scope_48, t1_.notes AS notes_49, t1_.routing_responsibility AS routing_responsibility_50, t1_.vehicle_catalog_scope AS vehicle_catalog_scope_51, t1_.routing_context_source AS routing_context_source_52, t1_.created_at AS created_at_53, t1_.updated_at AS updated_at_54, d0_.delivery_agent_id AS delivery_agent_id_55, d0_.assigned_driver_vehicle_assignment_id AS assigned_driver_vehicle_assignment_id_56, d0_.assigned_driver_vehicle_id AS assigned_driver_vehicle_id_57, d0_.assigned_vehicle_class_id AS assigned_vehicle_class_id_58, d0_.consignee_id AS consignee_id_59, d0_.carrier_id AS carrier_id_60, d0_.region_id AS region_id_61, d0_.vehicle_class_id AS vehicle_class_id_62, d0_.trip_id AS trip_id_63, d0_.routing_owner_shipper_id AS routing_owner_shipper_id_64, d0_.routing_driver_pool_id AS routing_driver_pool_id_65, d0_.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_66, t1_.route_id AS route_id_67, t1_.operation_profile_id AS operation_profile_id_68, t1_.vehicle_class_id AS vehicle_class_id_69, t1_.delivery_agent_id AS delivery_agent_id_70, t1_.routing_owner_shipper_id AS routing_owner_shipper_id_71, t1_.routing_driver_pool_id AS routing_driver_pool_id_72, t1_.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_73 FROM delivery d0_ LEFT JOIN trip_run t1_ ON d0_.trip_id = t1_.id WHERE d0_.delivery_agent_id = ? AND d0_.status IN (?, ?) AND ((t1_.id IS NULL OR t1_.status NOT IN (?, ?))) ORDER BY d0_.id DESC LIMIT 1
Parameters:
[ 44 "TO_PICKUP" "IN_TRANSIT" "CANCELLED" "FINISHED" ] |
|
0.31 ms (11.61%) |
1 |
SELECT t0_.id AS id_0, t0_.operational_route_number AS operational_route_number_1, t0_.operational_route_code AS operational_route_code_2, t0_.trip_kind AS trip_kind_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_.estimated_km AS estimated_km_8, t0_.estimated_duration_minutes AS estimated_duration_minutes_9, t0_.route_geometry_json AS route_geometry_json_10, t0_.total_weight AS total_weight_11, t0_.total_volume AS total_volume_12, t0_.point_count AS point_count_13, t0_.invoice_count AS invoice_count_14, t0_.customer_charge_total AS customer_charge_total_15, t0_.driver_payout_total AS driver_payout_total_16, t0_.customer_financial_scope AS customer_financial_scope_17, t0_.driver_financial_scope AS driver_financial_scope_18, t0_.notes AS notes_19, t0_.routing_responsibility AS routing_responsibility_20, t0_.vehicle_catalog_scope AS vehicle_catalog_scope_21, t0_.routing_context_source AS routing_context_source_22, t0_.created_at AS created_at_23, t0_.updated_at AS updated_at_24, r1_.id AS id_25, r1_.name AS name_26, r1_.customer_financial_scope AS customer_financial_scope_27, r1_.driver_financial_scope AS driver_financial_scope_28, d2_.id AS id_29, d2_.cpf AS cpf_30, d2_.name AS name_31, d2_.email AS email_32, d2_.password AS password_33, d2_.employment_type AS employment_type_34, d2_.is_active AS is_active_35, d2_.can_receive_auto_offers AS can_receive_auto_offers_36, d2_.api_token AS api_token_37, d2_.api_token_created_at AS api_token_created_at_38, d2_.presence_status AS presence_status_39, d2_.last_seen_at AS last_seen_at_40, d2_.last_latitude AS last_latitude_41, d2_.last_longitude AS last_longitude_42, d2_.last_location_accuracy AS last_location_accuracy_43, d2_.last_location_bearing AS last_location_bearing_44, d2_.last_location_speed AS last_location_speed_45, d2_.last_location_at AS last_location_at_46, d2_.presence_updated_at AS presence_updated_at_47, d2_.presence_effective_status AS presence_effective_status_48, d2_.created_at AS created_at_49, d2_.rate_payout_adjustment AS rate_payout_adjustment_50, t0_.route_id AS route_id_51, t0_.operation_profile_id AS operation_profile_id_52, t0_.vehicle_class_id AS vehicle_class_id_53, t0_.delivery_agent_id AS delivery_agent_id_54, t0_.routing_owner_shipper_id AS routing_owner_shipper_id_55, t0_.routing_driver_pool_id AS routing_driver_pool_id_56, t0_.vehicle_catalog_shipper_id AS vehicle_catalog_shipper_id_57, r1_.delivery_agent_id AS delivery_agent_id_58, d2_.last_selected_driver_vehicle_assignment_id AS last_selected_driver_vehicle_assignment_id_59 FROM trip_run t0_ LEFT JOIN route r1_ ON t0_.route_id = r1_.id LEFT JOIN delivery_agent d2_ ON t0_.delivery_agent_id = d2_.id WHERE t0_.delivery_agent_id = ? AND t0_.status IN (?) ORDER BY t0_.id DESC
Parameters:
[ 44 "IN_PROGRESS" ] |
|
0.28 ms (10.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 (8.85%) |
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.23 ms (8.37%) |
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.22 ms (8.29%) |
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.21 ms (7.67%) |
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.21 ms (7.56%) |
1 |
SELECT d0_.id AS id_0, d0_.offered_vehicle_snapshot AS offered_vehicle_snapshot_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.expires_at AS expires_at_4, d0_.responded_at AS responded_at_5, d0_.responded_type AS responded_type_6, d0_.attempt AS attempt_7, d0_.dispatch_round AS dispatch_round_8, d0_.offered_payout AS offered_payout_9, d0_.delivery_id AS delivery_id_10, d0_.delivery_agent_id AS delivery_agent_id_11, d0_.offered_driver_vehicle_assignment_id AS offered_driver_vehicle_assignment_id_12, d0_.offered_driver_vehicle_id AS offered_driver_vehicle_id_13, d0_.offered_vehicle_class_id AS offered_vehicle_class_id_14 FROM delivery_offer d0_ WHERE d0_.delivery_agent_id = ? AND d0_.status = ? ORDER BY d0_.responded_at DESC, d0_.id DESC LIMIT 1
Parameters:
[ 44 "RESERVED" ] |
|
0.20 ms (7.19%) |
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.19 ms (6.86%) |
1 |
SELECT t0.id AS id_1, t0.cnpj AS cnpj_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.district AS district_5, t0.city AS city_6, t0.zip_code AS zip_code_7, t0.lat_lng AS lat_lng_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.person_type AS person_type_11, t0.document_type AS document_type_12, t0.document_digits AS document_digits_13, t0.legal_name AS legal_name_14, t0.trade_name AS trade_name_15, t0.contact_name AS contact_name_16, t0.contact_phone AS contact_phone_17, t0.customer_origin AS customer_origin_18, t0.customer_relationship AS customer_relationship_19, t0.customer_status AS customer_status_20, t0.registration_channel AS registration_channel_21, t0.self_registered_at AS self_registered_at_22, t0.review_status AS review_status_23, t0.reviewed_at AS reviewed_at_24, t0.reviewed_by AS reviewed_by_25, t0.duplicate_of_shipper_id AS duplicate_of_shipper_id_26, t0.blocked_reason AS blocked_reason_27, t0.daily_control_applicable AS daily_control_applicable_28, t0.charge_method AS charge_method_29, t0.active AS active_30, t0.rate_adjustment_percent AS rate_adjustment_percent_31, t0.auto_assign_open_delivery_on_email_import AS auto_assign_open_delivery_on_email_import_32, t0.uses_scheduled_routing_base AS uses_scheduled_routing_base_33, t0.scheduled_routing_cutoff_time AS scheduled_routing_cutoff_time_34, t0.scheduled_routing_use_ai AS scheduled_routing_use_ai_35, t0.scheduled_base_daily_control_visibility AS scheduled_base_daily_control_visibility_36, t0.operational_routing_policy AS operational_routing_policy_37, t0.direct_auto_routing_window_minutes AS direct_auto_routing_window_minutes_38, t0.direct_auto_routing_auto_approve AS direct_auto_routing_auto_approve_39, t0.customer_portal_route_experience AS customer_portal_route_experience_40, t0.customer_portal_feature_profile AS customer_portal_feature_profile_41, t0.customer_default_order_responsibility AS customer_default_order_responsibility_42, t0.route_grouping_policy AS route_grouping_policy_43, t0.route_customer_financial_scope_override AS route_customer_financial_scope_override_44, t0.fixed_post_enabled AS fixed_post_enabled_45, t0.fixed_post_required_headcount AS fixed_post_required_headcount_46, t0.fixed_post_shift_start_time AS fixed_post_shift_start_time_47, t0.carrier_id AS carrier_id_48, t0.rate_plan_id AS rate_plan_id_49 FROM shipper t0 WHERE t0.id = ?
Parameters:
[
20
]
|
|
0.16 ms (5.86%) |
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 = ?
Parameters:
[
1
]
|
|
0.14 ms (5.35%) |
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\Shipper | 1 |
| App\Entity\Trip | 1 |
| App\Entity\Route | 1 |
| App\Entity\Invoice | 1 |
| App\Entity\TripApprovalDraft | 1 |
| App\Entity\RatePlan | 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\Trip | No errors. |
| App\Entity\Route | No errors. |
| App\Entity\RouteOperationProfile | No errors. |
| App\Entity\Shipper | No errors. |
| App\Entity\DriverPool | 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\Invoice | No errors. |
| App\Entity\TripApprovalDraft | No errors. |
| App\Entity\RatePlan | No errors. |
| App\Entity\DeliveryOffer | No errors. |