Query Metrics
1
Database Queries
1
Different statements
1.56 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.56 ms |
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 |
|
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. |