GET https://auction.sa/ar/vehicleDocs/19422/edit

Query Metrics

1 Database Queries
1 Different statements
1.56 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.56 ms
(100.00%)
1
SELECT t0.vehicle_id AS vehicle_id_1, t0.state AS state_2, t0.vehicle_number AS vehicle_number_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.situation AS situation_6, t0.offerability_for_sale AS offerability_for_sale_7, t0.status AS status_8, t0.is_deleted AS is_deleted_9, t0.is_approved AS is_approved_10, t0.inspection_expiration_date AS inspection_expiration_date_11, t0.insurance_start_date AS insurance_start_date_12, t0.insurance_expiry_date AS insurance_expiry_date_13, t0.exit_date AS exit_date_14, t0.receiving_at AS receiving_at_15, t0.approved_by AS approved_by_16, t0.created_by AS created_by_17, t0.parent_vehicle_id AS parent_vehicle_id_18, t0.updated_by AS updated_by_19, t20.vin_number AS vin_number_21, t20.panel_numbers AS panel_numbers_22, t20.weight AS weight_23, t20.vehicle_load AS vehicle_load_24, t20.manufacturing_year AS manufacturing_year_25, t20.serial_number AS serial_number_26, t20.license_expiry_date AS license_expiry_date_27, t20.license_expiry_date_hijri AS license_expiry_date_hijri_28, t20.vehicle_id AS vehicle_id_29, t20.color_id AS color_id_30, t20.registration_doc_id AS registration_doc_id_31, t20.panel_letter1 AS panel_letter1_32, t20.panel_letter2 AS panel_letter2_33, t20.panel_letter3 AS panel_letter3_34, t20.model_id AS model_id_35, t20.registration_type_id AS registration_type_id_36, t20.vehicle_id AS vehicle_id_37, t20.vehicle_owner_id AS vehicle_owner_id_38, t20.vehicle_user_id AS vehicle_user_id_39, t40.historical_info AS historical_info_41, t40.description_ar AS description_ar_42, t40.description_en AS description_en_43, t40.body_type AS body_type_44, t40.vehicle_status AS vehicle_status_45, t40.vehicle_condition AS vehicle_condition_46, t40.transmission AS transmission_47, t40.fuel AS fuel_48, t40.condition_report_path AS condition_report_path_49, t40.estimate_value AS estimate_value_50, t40.is_repairable AS is_repairable_51, t40.repair_required_time AS repair_required_time_52, t40.repair_cost AS repair_cost_53, t40.value_after_repair AS value_after_repair_54, t40.created_at AS created_at_55, t40.updated_at AS updated_at_56, t40.old_panel_numbers AS old_panel_numbers_57, t40.manufacturer_country_id AS manufacturer_country_id_58, t40.odometer_range_id AS odometer_range_id_59, t40.vehicle_id AS vehicle_id_60, t40.created_by AS created_by_61, t40.updated_by AS updated_by_62, t40.old_panel_letter1 AS old_panel_letter1_63, t40.old_panel_letter2 AS old_panel_letter2_64, t40.old_panel_letter3 AS old_panel_letter3_65, t66.beneficiary_vehicle_number AS beneficiary_vehicle_number_67, t66.compensation_amount AS compensation_amount_68, t66.created_at AS created_at_69, t66.updated_at AS updated_at_70, t66.vehicle_id AS vehicle_id_71, t66.beneficiary_id AS beneficiary_id_72, t66.owner_payment_doc_id AS owner_payment_doc_id_73, t66.purchase_supplier_invoice_id AS purchase_supplier_invoice_id_74, t66.created_by AS created_by_75, t66.updated_by AS updated_by_76, t66.vehicle_id AS vehicle_id_77 FROM vehicles t0 LEFT JOIN vehicle_registrations t20 ON t20.vehicle_id = t0.vehicle_id LEFT JOIN vehicle_technical_specs t40 ON t40.vehicle_id = t0.vehicle_id LEFT JOIN vehicle_beneficiary_details t66 ON t66.vehicle_id = t0.vehicle_id WHERE t0.vehicle_id = ? LIMIT 1
Parameters:
[
  "19422"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Vehicles
  • The field App\Entity\Vehicles#vehicleSales is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\VehicleSales#vehicle does not contain the required 'inversedBy="vehicleSales"' attribute.
App\Entity\Users No errors.
App\Entity\VehicleRegistrations No errors.
App\Entity\VehicleColors No errors.
App\Entity\VehicleDocs No errors.
App\Entity\PanelLetters No errors.
App\Entity\VehicleModels No errors.
App\Entity\VehicleRegistrationTypes No errors.
App\Entity\VehicleClients No errors.
App\Entity\VehicleTechnicalSpecs No errors.
App\Entity\Countries No errors.
App\Entity\OdometerRanges No errors.
App\Entity\VehicleBeneficiaryDetails No errors.
App\Entity\SupplierInvoices No errors.
App\Entity\VehicleInventoryMissingParts No errors.
App\Entity\VehicleOtherMissingParts No errors.
App\Entity\VehicleInventoryImages No errors.
App\Entity\VehicleRevokeRequests No errors.
App\Entity\VehicleRtsActivitiesEstimateVal No errors.
App\Entity\VehicleSales No errors.