Symfony Profiler

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

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 = '19422' LIMIT 1;

SELECT
  t0.user_id AS user_id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.telephone AS telephone_4,
  t0.roles AS roles_5,
  t0.mobile_number AS mobile_number_6,
  t0.mobile_number2 AS mobile_number2_7,
  t0.is_mobile_number2_verified AS is_mobile_number2_verified_8,
  t0.email AS email_9,
  t0.email_verified AS email_verified_10,
  t0.verify_token AS verify_token_11,
  t0.balance AS balance_12,
  t0.locked_ot_security AS locked_ot_security_13,
  t0.is_verified AS is_verified_14,
  t0.is_deleted AS is_deleted_15,
  t0.is_receive_sms AS is_receive_sms_16,
  t0.last_login AS last_login_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.profile_origin AS profile_origin_20,
  t0.signature_path AS signature_path_21,
  t0.balance_amount AS balance_amount_22,
  t0.pledge_amount AS pledge_amount_23,
  t0.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_24,
  t0.balance_due AS balance_due_25,
  t0.client_id AS client_id_26,
  t0.category_id AS category_id_27,
  t0.company_id AS company_id_28,
  t0.created_by AS created_by_29,
  t0.updated_by AS updated_by_30,
  t31.firstname_ar AS firstname_ar_32,
  t31.secondname_ar AS secondname_ar_33,
  t31.thirdname_ar AS thirdname_ar_34,
  t31.fourthname_ar AS fourthname_ar_35,
  t31.firstname_en AS firstname_en_36,
  t31.secondname_en AS secondname_en_37,
  t31.thirdname_en AS thirdname_en_38,
  t31.fourthname_en AS fourthname_en_39,
  t31.identification_number AS identification_number_40,
  t31.gender AS gender_41,
  t31.expiration_date AS expiration_date_42,
  t31.expiration_date_hijri AS expiration_date_hijri_43,
  t31.version_number AS version_number_44,
  t31.issuer AS issuer_45,
  t31.date_of_birth AS date_of_birth_46,
  t31.date_of_birth_hijri AS date_of_birth_hijri_47,
  t31.occupation AS occupation_48,
  t31.religion AS religion_49,
  t31.registry_number AS registry_number_50,
  t31.registry_authority AS registry_authority_51,
  t31.registry_hijri_date AS registry_hijri_date_52,
  t31.employer AS employer_53,
  t31.image_path AS image_path_54,
  t31.employer_letter_path AS employer_letter_path_55,
  t31.country_id AS country_id_56,
  t31.user_id AS user_id_57,
  t58.prefix AS prefix_59,
  t58.suffix AS suffix_60,
  t58.home_phone AS home_phone_61,
  t58.business_phone AS business_phone_62,
  t58.business_fax AS business_fax_63,
  t58.business_phone2 AS business_phone2_64,
  t58.company_main_phone AS company_main_phone_65,
  t58.email2 AS email2_66,
  t58.web_page AS web_page_67,
  t58.department AS department_68,
  t58.job_title AS job_title_69,
  t58.manager_name AS manager_name_70,
  t58.business_city AS business_city_71,
  t58.po_box AS po_box_72,
  t58.postal_code AS postal_code_73,
  t58.trn AS trn_74,
  t58.building_no AS building_no_75,
  t58.business_street AS business_street_76,
  t58.district_name AS district_name_77,
  t58.zip_code AS zip_code_78,
  t58.additional_no AS additional_no_79,
  t58.unit_no AS unit_no_80,
  t58.issue_date_hijri AS issue_date_hijri_81,
  t58.issue_date AS issue_date_82,
  t58.birth_city AS birth_city_83,
  t58.passport_no AS passport_no_84,
  t58.passport_expiry_date AS passport_expiry_date_85,
  t58.passport_issue_date AS passport_issue_date_86,
  t58.soc_insrnc_no AS soc_insrnc_no_87,
  t58.join_date AS join_date_88,
  t58.basic_salary AS basic_salary_89,
  t58.housing_allowance AS housing_allowance_90,
  t58.soc_insrnc_amount AS soc_insrnc_amount_91,
  t58.other_allowances AS other_allowances_92,
  t58.labor_no AS labor_no_93,
  t58.labor_start_date AS labor_start_date_94,
  t58.ksa_entry_date AS ksa_entry_date_95,
  t58.border_no AS border_no_96,
  t58.work_permit_start_date AS work_permit_start_date_97,
  t58.work_permit_end_date AS work_permit_end_date_98,
  t58.med_insrnc_mem_no AS med_insrnc_mem_no_99,
  t58.national_address_path AS national_address_path_100,
  t58.passport_path AS passport_path_101,
  t58.med_insrnc_path AS med_insrnc_path_102,
  t58.med_insrnc_expiry_date AS med_insrnc_expiry_date_103,
  t58.classification_id AS classification_id_104,
  t58.city_id AS city_id_105,
  t58.user_id AS user_id_106,
  t107.client_id AS client_id_108,
  t107.is_active AS is_active_109,
  t107.company_id AS company_id_110,
  t107.user_id AS user_id_111
FROM
  users t0
  LEFT JOIN user_identity_info t31 ON t31.user_id = t0.user_id
  LEFT JOIN user_additional_details t58 ON t58.user_id = t0.user_id
  LEFT JOIN vehicle_clients t107 ON t107.user_id = t0.user_id
WHERE
  t0.user_id = ?

SELECT t0.user_id AS user_id_1, t0.username AS username_2, t0.password AS password_3, t0.telephone AS telephone_4, t0.roles AS roles_5, t0.mobile_number AS mobile_number_6, t0.mobile_number2 AS mobile_number2_7, t0.is_mobile_number2_verified AS is_mobile_number2_verified_8, t0.email AS email_9, t0.email_verified AS email_verified_10, t0.verify_token AS verify_token_11, t0.balance AS balance_12, t0.locked_ot_security AS locked_ot_security_13, t0.is_verified AS is_verified_14, t0.is_deleted AS is_deleted_15, t0.is_receive_sms AS is_receive_sms_16, t0.last_login AS last_login_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.profile_origin AS profile_origin_20, t0.signature_path AS signature_path_21, t0.balance_amount AS balance_amount_22, t0.pledge_amount AS pledge_amount_23, t0.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_24, t0.balance_due AS balance_due_25, t0.client_id AS client_id_26, t0.category_id AS category_id_27, t0.company_id AS company_id_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t31.firstname_ar AS firstname_ar_32, t31.secondname_ar AS secondname_ar_33, t31.thirdname_ar AS thirdname_ar_34, t31.fourthname_ar AS fourthname_ar_35, t31.firstname_en AS firstname_en_36, t31.secondname_en AS secondname_en_37, t31.thirdname_en AS thirdname_en_38, t31.fourthname_en AS fourthname_en_39, t31.identification_number AS identification_number_40, t31.gender AS gender_41, t31.expiration_date AS expiration_date_42, t31.expiration_date_hijri AS expiration_date_hijri_43, t31.version_number AS version_number_44, t31.issuer AS issuer_45, t31.date_of_birth AS date_of_birth_46, t31.date_of_birth_hijri AS date_of_birth_hijri_47, t31.occupation AS occupation_48, t31.religion AS religion_49, t31.registry_number AS registry_number_50, t31.registry_authority AS registry_authority_51, t31.registry_hijri_date AS registry_hijri_date_52, t31.employer AS employer_53, t31.image_path AS image_path_54, t31.employer_letter_path AS employer_letter_path_55, t31.country_id AS country_id_56, t31.user_id AS user_id_57, t58.prefix AS prefix_59, t58.suffix AS suffix_60, t58.home_phone AS home_phone_61, t58.business_phone AS business_phone_62, t58.business_fax AS business_fax_63, t58.business_phone2 AS business_phone2_64, t58.company_main_phone AS company_main_phone_65, t58.email2 AS email2_66, t58.web_page AS web_page_67, t58.department AS department_68, t58.job_title AS job_title_69, t58.manager_name AS manager_name_70, t58.business_city AS business_city_71, t58.po_box AS po_box_72, t58.postal_code AS postal_code_73, t58.trn AS trn_74, t58.building_no AS building_no_75, t58.business_street AS business_street_76, t58.district_name AS district_name_77, t58.zip_code AS zip_code_78, t58.additional_no AS additional_no_79, t58.unit_no AS unit_no_80, t58.issue_date_hijri AS issue_date_hijri_81, t58.issue_date AS issue_date_82, t58.birth_city AS birth_city_83, t58.passport_no AS passport_no_84, t58.passport_expiry_date AS passport_expiry_date_85, t58.passport_issue_date AS passport_issue_date_86, t58.soc_insrnc_no AS soc_insrnc_no_87, t58.join_date AS join_date_88, t58.basic_salary AS basic_salary_89, t58.housing_allowance AS housing_allowance_90, t58.soc_insrnc_amount AS soc_insrnc_amount_91, t58.other_allowances AS other_allowances_92, t58.labor_no AS labor_no_93, t58.labor_start_date AS labor_start_date_94, t58.ksa_entry_date AS ksa_entry_date_95, t58.border_no AS border_no_96, t58.work_permit_start_date AS work_permit_start_date_97, t58.work_permit_end_date AS work_permit_end_date_98, t58.med_insrnc_mem_no AS med_insrnc_mem_no_99, t58.national_address_path AS national_address_path_100, t58.passport_path AS passport_path_101, t58.med_insrnc_path AS med_insrnc_path_102, t58.med_insrnc_expiry_date AS med_insrnc_expiry_date_103, t58.classification_id AS classification_id_104, t58.city_id AS city_id_105, t58.user_id AS user_id_106, t107.client_id AS client_id_108, t107.is_active AS is_active_109, t107.company_id AS company_id_110, t107.user_id AS user_id_111 FROM users t0 LEFT JOIN user_identity_info t31 ON t31.user_id = t0.user_id LEFT JOIN user_additional_details t58 ON t58.user_id = t0.user_id LEFT JOIN vehicle_clients t107 ON t107.user_id = t0.user_id WHERE t0.user_id = 'ebadd9a0-41d8-11e9-bfae-0242ac110002';

SELECT
  t0.doc_id AS doc_id_1,
  t0.received_doc_type AS received_doc_type_2,
  t0.image_path AS image_path_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.created_by AS created_by_6,
  t0.doc_type_id AS doc_type_id_7,
  t0.updated_by AS updated_by_8,
  t0.vehicle_id AS vehicle_id_9,
  t10.vin_number AS vin_number_11,
  t10.panel_numbers AS panel_numbers_12,
  t10.weight AS weight_13,
  t10.vehicle_load AS vehicle_load_14,
  t10.manufacturing_year AS manufacturing_year_15,
  t10.serial_number AS serial_number_16,
  t10.license_expiry_date AS license_expiry_date_17,
  t10.license_expiry_date_hijri AS license_expiry_date_hijri_18,
  t10.vehicle_id AS vehicle_id_19,
  t10.color_id AS color_id_20,
  t10.registration_doc_id AS registration_doc_id_21,
  t10.panel_letter1 AS panel_letter1_22,
  t10.panel_letter2 AS panel_letter2_23,
  t10.panel_letter3 AS panel_letter3_24,
  t10.model_id AS model_id_25,
  t10.registration_type_id AS registration_type_id_26,
  t10.vehicle_id AS vehicle_id_27,
  t10.vehicle_owner_id AS vehicle_owner_id_28,
  t10.vehicle_user_id AS vehicle_user_id_29
FROM
  vehicle_docs t0
  LEFT JOIN vehicle_registrations t10 ON t10.registration_doc_id = t0.doc_id
WHERE
  t0.doc_id = ?

SELECT t0.doc_id AS doc_id_1, t0.received_doc_type AS received_doc_type_2, t0.image_path AS image_path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.doc_type_id AS doc_type_id_7, t0.updated_by AS updated_by_8, t0.vehicle_id AS vehicle_id_9, t10.vin_number AS vin_number_11, t10.panel_numbers AS panel_numbers_12, t10.weight AS weight_13, t10.vehicle_load AS vehicle_load_14, t10.manufacturing_year AS manufacturing_year_15, t10.serial_number AS serial_number_16, t10.license_expiry_date AS license_expiry_date_17, t10.license_expiry_date_hijri AS license_expiry_date_hijri_18, t10.vehicle_id AS vehicle_id_19, t10.color_id AS color_id_20, t10.registration_doc_id AS registration_doc_id_21, t10.panel_letter1 AS panel_letter1_22, t10.panel_letter2 AS panel_letter2_23, t10.panel_letter3 AS panel_letter3_24, t10.model_id AS model_id_25, t10.registration_type_id AS registration_type_id_26, t10.vehicle_id AS vehicle_id_27, t10.vehicle_owner_id AS vehicle_owner_id_28, t10.vehicle_user_id AS vehicle_user_id_29 FROM vehicle_docs t0 LEFT JOIN vehicle_registrations t10 ON t10.registration_doc_id = t0.doc_id WHERE t0.doc_id = 121484;

SELECT
  t0.notice_id AS notice_id_1,
  t0.notice_type AS notice_type_2,
  t0.notice_date AS notice_date_3,
  t0.notice_date_hijri AS notice_date_hijri_4,
  t0.revocation_date AS revocation_date_5,
  t0.revocation_date_hijri AS revocation_date_hijri_6,
  t0.is_effective AS is_effective_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.Followup_date AS Followup_date_10,
  t0.created_by AS created_by_11,
  t0.note_doc_id AS note_doc_id_12,
  t0.updated_by AS updated_by_13,
  t0.vehicle_id AS vehicle_id_14
FROM
  vehicle_security_notices t0
WHERE
  t0.vehicle_id = ?

SELECT t0.notice_id AS notice_id_1, t0.notice_type AS notice_type_2, t0.notice_date AS notice_date_3, t0.notice_date_hijri AS notice_date_hijri_4, t0.revocation_date AS revocation_date_5, t0.revocation_date_hijri AS revocation_date_hijri_6, t0.is_effective AS is_effective_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.Followup_date AS Followup_date_10, t0.created_by AS created_by_11, t0.note_doc_id AS note_doc_id_12, t0.updated_by AS updated_by_13, t0.vehicle_id AS vehicle_id_14 FROM vehicle_security_notices t0 WHERE t0.vehicle_id = 19422;

SELECT
  v0_.doc_id AS doc_id_0,
  v0_.received_doc_type AS received_doc_type_1,
  v0_.image_path AS image_path_2,
  v0_.created_at AS created_at_3,
  v0_.updated_at AS updated_at_4,
  v0_.created_by AS created_by_5,
  v0_.doc_type_id AS doc_type_id_6,
  v0_.updated_by AS updated_by_7,
  v0_.vehicle_id AS vehicle_id_8
FROM
  vehicle_docs v0_
WHERE
  v0_.doc_type_id = ?
  AND v0_.vehicle_id = ?
ORDER BY
  v0_.doc_id DESC
LIMIT
  1

SELECT v0_.doc_id AS doc_id_0, v0_.received_doc_type AS received_doc_type_1, v0_.image_path AS image_path_2, v0_.created_at AS created_at_3, v0_.updated_at AS updated_at_4, v0_.created_by AS created_by_5, v0_.doc_type_id AS doc_type_id_6, v0_.updated_by AS updated_by_7, v0_.vehicle_id AS vehicle_id_8 FROM vehicle_docs v0_ WHERE v0_.doc_type_id = 4 AND v0_.vehicle_id = '19422' ORDER BY v0_.doc_id DESC LIMIT 1;

SELECT
  t0.vin_number AS vin_number_1,
  t0.panel_numbers AS panel_numbers_2,
  t0.weight AS weight_3,
  t0.vehicle_load AS vehicle_load_4,
  t0.manufacturing_year AS manufacturing_year_5,
  t0.serial_number AS serial_number_6,
  t0.license_expiry_date AS license_expiry_date_7,
  t0.license_expiry_date_hijri AS license_expiry_date_hijri_8,
  t0.vehicle_id AS vehicle_id_9,
  t0.color_id AS color_id_10,
  t0.registration_doc_id AS registration_doc_id_11,
  t0.panel_letter1 AS panel_letter1_12,
  t0.panel_letter2 AS panel_letter2_13,
  t0.panel_letter3 AS panel_letter3_14,
  t0.model_id AS model_id_15,
  t0.registration_type_id AS registration_type_id_16,
  t0.vehicle_id AS vehicle_id_17,
  t0.vehicle_owner_id AS vehicle_owner_id_18,
  t0.vehicle_user_id AS vehicle_user_id_19
FROM
  vehicle_registrations t0
WHERE
  t0.registration_doc_id = ?

SELECT t0.vin_number AS vin_number_1, t0.panel_numbers AS panel_numbers_2, t0.weight AS weight_3, t0.vehicle_load AS vehicle_load_4, t0.manufacturing_year AS manufacturing_year_5, t0.serial_number AS serial_number_6, t0.license_expiry_date AS license_expiry_date_7, t0.license_expiry_date_hijri AS license_expiry_date_hijri_8, t0.vehicle_id AS vehicle_id_9, t0.color_id AS color_id_10, t0.registration_doc_id AS registration_doc_id_11, t0.panel_letter1 AS panel_letter1_12, t0.panel_letter2 AS panel_letter2_13, t0.panel_letter3 AS panel_letter3_14, t0.model_id AS model_id_15, t0.registration_type_id AS registration_type_id_16, t0.vehicle_id AS vehicle_id_17, t0.vehicle_owner_id AS vehicle_owner_id_18, t0.vehicle_user_id AS vehicle_user_id_19 FROM vehicle_registrations t0 WHERE t0.registration_doc_id = 121485;

SELECT
  v0_.doc_id AS doc_id_0,
  v0_.received_doc_type AS received_doc_type_1,
  v0_.image_path AS image_path_2,
  v0_.created_at AS created_at_3,
  v0_.updated_at AS updated_at_4,
  v0_.created_by AS created_by_5,
  v0_.doc_type_id AS doc_type_id_6,
  v0_.updated_by AS updated_by_7,
  v0_.vehicle_id AS vehicle_id_8
FROM
  vehicle_docs v0_
WHERE
  v0_.doc_type_id = ?
  AND v0_.vehicle_id = ?
ORDER BY
  v0_.doc_id DESC
LIMIT
  1

SELECT v0_.doc_id AS doc_id_0, v0_.received_doc_type AS received_doc_type_1, v0_.image_path AS image_path_2, v0_.created_at AS created_at_3, v0_.updated_at AS updated_at_4, v0_.created_by AS created_by_5, v0_.doc_type_id AS doc_type_id_6, v0_.updated_by AS updated_by_7, v0_.vehicle_id AS vehicle_id_8 FROM vehicle_docs v0_ WHERE v0_.doc_type_id = 2 AND v0_.vehicle_id = '19422' ORDER BY v0_.doc_id DESC LIMIT 1;

SELECT
  t0.vin_number AS vin_number_1,
  t0.panel_numbers AS panel_numbers_2,
  t0.weight AS weight_3,
  t0.vehicle_load AS vehicle_load_4,
  t0.manufacturing_year AS manufacturing_year_5,
  t0.serial_number AS serial_number_6,
  t0.license_expiry_date AS license_expiry_date_7,
  t0.license_expiry_date_hijri AS license_expiry_date_hijri_8,
  t0.vehicle_id AS vehicle_id_9,
  t0.color_id AS color_id_10,
  t0.registration_doc_id AS registration_doc_id_11,
  t0.panel_letter1 AS panel_letter1_12,
  t0.panel_letter2 AS panel_letter2_13,
  t0.panel_letter3 AS panel_letter3_14,
  t0.model_id AS model_id_15,
  t0.registration_type_id AS registration_type_id_16,
  t0.vehicle_id AS vehicle_id_17,
  t0.vehicle_owner_id AS vehicle_owner_id_18,
  t0.vehicle_user_id AS vehicle_user_id_19
FROM
  vehicle_registrations t0
WHERE
  t0.registration_doc_id = ?

SELECT t0.vin_number AS vin_number_1, t0.panel_numbers AS panel_numbers_2, t0.weight AS weight_3, t0.vehicle_load AS vehicle_load_4, t0.manufacturing_year AS manufacturing_year_5, t0.serial_number AS serial_number_6, t0.license_expiry_date AS license_expiry_date_7, t0.license_expiry_date_hijri AS license_expiry_date_hijri_8, t0.vehicle_id AS vehicle_id_9, t0.color_id AS color_id_10, t0.registration_doc_id AS registration_doc_id_11, t0.panel_letter1 AS panel_letter1_12, t0.panel_letter2 AS panel_letter2_13, t0.panel_letter3 AS panel_letter3_14, t0.model_id AS model_id_15, t0.registration_type_id AS registration_type_id_16, t0.vehicle_id AS vehicle_id_17, t0.vehicle_owner_id AS vehicle_owner_id_18, t0.vehicle_user_id AS vehicle_user_id_19 FROM vehicle_registrations t0 WHERE t0.registration_doc_id = 121486;

SELECT
  v0_.doc_id AS doc_id_0,
  v0_.received_doc_type AS received_doc_type_1,
  v0_.image_path AS image_path_2,
  v0_.created_at AS created_at_3,
  v0_.updated_at AS updated_at_4,
  v0_.created_by AS created_by_5,
  v0_.doc_type_id AS doc_type_id_6,
  v0_.updated_by AS updated_by_7,
  v0_.vehicle_id AS vehicle_id_8
FROM
  vehicle_docs v0_
WHERE
  v0_.doc_type_id = ?
  AND v0_.vehicle_id = ?
ORDER BY
  v0_.doc_id DESC
LIMIT
  1

SELECT v0_.doc_id AS doc_id_0, v0_.received_doc_type AS received_doc_type_1, v0_.image_path AS image_path_2, v0_.created_at AS created_at_3, v0_.updated_at AS updated_at_4, v0_.created_by AS created_by_5, v0_.doc_type_id AS doc_type_id_6, v0_.updated_by AS updated_by_7, v0_.vehicle_id AS vehicle_id_8 FROM vehicle_docs v0_ WHERE v0_.doc_type_id = 3 AND v0_.vehicle_id = '19422' ORDER BY v0_.doc_id DESC LIMIT 1;

SELECT
  t0.vin_number AS vin_number_1,
  t0.panel_numbers AS panel_numbers_2,
  t0.weight AS weight_3,
  t0.vehicle_load AS vehicle_load_4,
  t0.manufacturing_year AS manufacturing_year_5,
  t0.serial_number AS serial_number_6,
  t0.license_expiry_date AS license_expiry_date_7,
  t0.license_expiry_date_hijri AS license_expiry_date_hijri_8,
  t0.vehicle_id AS vehicle_id_9,
  t0.color_id AS color_id_10,
  t0.registration_doc_id AS registration_doc_id_11,
  t0.panel_letter1 AS panel_letter1_12,
  t0.panel_letter2 AS panel_letter2_13,
  t0.panel_letter3 AS panel_letter3_14,
  t0.model_id AS model_id_15,
  t0.registration_type_id AS registration_type_id_16,
  t0.vehicle_id AS vehicle_id_17,
  t0.vehicle_owner_id AS vehicle_owner_id_18,
  t0.vehicle_user_id AS vehicle_user_id_19
FROM
  vehicle_registrations t0
WHERE
  t0.registration_doc_id = ?

SELECT t0.vin_number AS vin_number_1, t0.panel_numbers AS panel_numbers_2, t0.weight AS weight_3, t0.vehicle_load AS vehicle_load_4, t0.manufacturing_year AS manufacturing_year_5, t0.serial_number AS serial_number_6, t0.license_expiry_date AS license_expiry_date_7, t0.license_expiry_date_hijri AS license_expiry_date_hijri_8, t0.vehicle_id AS vehicle_id_9, t0.color_id AS color_id_10, t0.registration_doc_id AS registration_doc_id_11, t0.panel_letter1 AS panel_letter1_12, t0.panel_letter2 AS panel_letter2_13, t0.panel_letter3 AS panel_letter3_14, t0.model_id AS model_id_15, t0.registration_type_id AS registration_type_id_16, t0.vehicle_id AS vehicle_id_17, t0.vehicle_owner_id AS vehicle_owner_id_18, t0.vehicle_user_id AS vehicle_user_id_19 FROM vehicle_registrations t0 WHERE t0.registration_doc_id = 121487;

SELECT
  v0_.doc_id AS doc_id_0,
  v0_.received_doc_type AS received_doc_type_1,
  v0_.image_path AS image_path_2,
  v0_.created_at AS created_at_3,
  v0_.updated_at AS updated_at_4,
  v0_.created_by AS created_by_5,
  v0_.doc_type_id AS doc_type_id_6,
  v0_.updated_by AS updated_by_7,
  v0_.vehicle_id AS vehicle_id_8
FROM
  vehicle_docs v0_
WHERE
  v0_.doc_type_id = ?
  AND v0_.vehicle_id = ?
ORDER BY
  v0_.doc_id DESC
LIMIT
  1

SELECT v0_.doc_id AS doc_id_0, v0_.received_doc_type AS received_doc_type_1, v0_.image_path AS image_path_2, v0_.created_at AS created_at_3, v0_.updated_at AS updated_at_4, v0_.created_by AS created_by_5, v0_.doc_type_id AS doc_type_id_6, v0_.updated_by AS updated_by_7, v0_.vehicle_id AS vehicle_id_8 FROM vehicle_docs v0_ WHERE v0_.doc_type_id = 6 AND v0_.vehicle_id = '19422' ORDER BY v0_.doc_id DESC LIMIT 1;

SELECT
  t0.vin_number AS vin_number_1,
  t0.panel_numbers AS panel_numbers_2,
  t0.weight AS weight_3,
  t0.vehicle_load AS vehicle_load_4,
  t0.manufacturing_year AS manufacturing_year_5,
  t0.serial_number AS serial_number_6,
  t0.license_expiry_date AS license_expiry_date_7,
  t0.license_expiry_date_hijri AS license_expiry_date_hijri_8,
  t0.vehicle_id AS vehicle_id_9,
  t0.color_id AS color_id_10,
  t0.registration_doc_id AS registration_doc_id_11,
  t0.panel_letter1 AS panel_letter1_12,
  t0.panel_letter2 AS panel_letter2_13,
  t0.panel_letter3 AS panel_letter3_14,
  t0.model_id AS model_id_15,
  t0.registration_type_id AS registration_type_id_16,
  t0.vehicle_id AS vehicle_id_17,
  t0.vehicle_owner_id AS vehicle_owner_id_18,
  t0.vehicle_user_id AS vehicle_user_id_19
FROM
  vehicle_registrations t0
WHERE
  t0.registration_doc_id = ?

SELECT t0.vin_number AS vin_number_1, t0.panel_numbers AS panel_numbers_2, t0.weight AS weight_3, t0.vehicle_load AS vehicle_load_4, t0.manufacturing_year AS manufacturing_year_5, t0.serial_number AS serial_number_6, t0.license_expiry_date AS license_expiry_date_7, t0.license_expiry_date_hijri AS license_expiry_date_hijri_8, t0.vehicle_id AS vehicle_id_9, t0.color_id AS color_id_10, t0.registration_doc_id AS registration_doc_id_11, t0.panel_letter1 AS panel_letter1_12, t0.panel_letter2 AS panel_letter2_13, t0.panel_letter3 AS panel_letter3_14, t0.model_id AS model_id_15, t0.registration_type_id AS registration_type_id_16, t0.vehicle_id AS vehicle_id_17, t0.vehicle_owner_id AS vehicle_owner_id_18, t0.vehicle_user_id AS vehicle_user_id_19 FROM vehicle_registrations t0 WHERE t0.registration_doc_id = 121488;

SELECT
  v0_.doc_id AS doc_id_0,
  v0_.received_doc_type AS received_doc_type_1,
  v0_.image_path AS image_path_2,
  v0_.created_at AS created_at_3,
  v0_.updated_at AS updated_at_4,
  v0_.created_by AS created_by_5,
  v0_.doc_type_id AS doc_type_id_6,
  v0_.updated_by AS updated_by_7,
  v0_.vehicle_id AS vehicle_id_8
FROM
  vehicle_docs v0_
WHERE
  v0_.doc_type_id = ?
  AND v0_.vehicle_id = ?
ORDER BY
  v0_.doc_id DESC
LIMIT
  1

SELECT v0_.doc_id AS doc_id_0, v0_.received_doc_type AS received_doc_type_1, v0_.image_path AS image_path_2, v0_.created_at AS created_at_3, v0_.updated_at AS updated_at_4, v0_.created_by AS created_by_5, v0_.doc_type_id AS doc_type_id_6, v0_.updated_by AS updated_by_7, v0_.vehicle_id AS vehicle_id_8 FROM vehicle_docs v0_ WHERE v0_.doc_type_id = 5 AND v0_.vehicle_id = '19422' ORDER BY v0_.doc_id DESC LIMIT 1;

SELECT
  t0.vin_number AS vin_number_1,
  t0.panel_numbers AS panel_numbers_2,
  t0.weight AS weight_3,
  t0.vehicle_load AS vehicle_load_4,
  t0.manufacturing_year AS manufacturing_year_5,
  t0.serial_number AS serial_number_6,
  t0.license_expiry_date AS license_expiry_date_7,
  t0.license_expiry_date_hijri AS license_expiry_date_hijri_8,
  t0.vehicle_id AS vehicle_id_9,
  t0.color_id AS color_id_10,
  t0.registration_doc_id AS registration_doc_id_11,
  t0.panel_letter1 AS panel_letter1_12,
  t0.panel_letter2 AS panel_letter2_13,
  t0.panel_letter3 AS panel_letter3_14,
  t0.model_id AS model_id_15,
  t0.registration_type_id AS registration_type_id_16,
  t0.vehicle_id AS vehicle_id_17,
  t0.vehicle_owner_id AS vehicle_owner_id_18,
  t0.vehicle_user_id AS vehicle_user_id_19
FROM
  vehicle_registrations t0
WHERE
  t0.registration_doc_id = ?

SELECT t0.vin_number AS vin_number_1, t0.panel_numbers AS panel_numbers_2, t0.weight AS weight_3, t0.vehicle_load AS vehicle_load_4, t0.manufacturing_year AS manufacturing_year_5, t0.serial_number AS serial_number_6, t0.license_expiry_date AS license_expiry_date_7, t0.license_expiry_date_hijri AS license_expiry_date_hijri_8, t0.vehicle_id AS vehicle_id_9, t0.color_id AS color_id_10, t0.registration_doc_id AS registration_doc_id_11, t0.panel_letter1 AS panel_letter1_12, t0.panel_letter2 AS panel_letter2_13, t0.panel_letter3 AS panel_letter3_14, t0.model_id AS model_id_15, t0.registration_type_id AS registration_type_id_16, t0.vehicle_id AS vehicle_id_17, t0.vehicle_owner_id AS vehicle_owner_id_18, t0.vehicle_user_id AS vehicle_user_id_19 FROM vehicle_registrations t0 WHERE t0.registration_doc_id = 121489;