Symfony Profiler

"COMMIT"

"COMMIT";

INSERT INTO vehicle_rts_activities_inventories_images (image_path, inventory_id)
VALUES
  (?, ?)

INSERT INTO vehicle_rts_activities_inventories_images (image_path, inventory_id) VALUES ('7781885043db99e48a69715a489262d9.jpg', 19246);

INSERT INTO vehicle_rts_activity_transports (
  transport_date, driver_id, rts_invoice_id,
  transporter_id, transport_activity_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO vehicle_rts_activity_transports (transport_date, driver_id, rts_invoice_id, transporter_id, transport_activity_id) VALUES (NULL, 1, NULL, 2, 19246);

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO vehicle_rts_activities_inventories_missing_parts (inventory_id, part_id)
VALUES
  (?, ?)

INSERT INTO vehicle_rts_activities_inventories_missing_parts (inventory_id, part_id) VALUES (19246, 4);

INSERT INTO vehicle_situation_log (
  situation, created_at, transition,
  created_by, vehicle_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO vehicle_situation_log (situation, created_at, transition, created_by, vehicle_id) VALUES (NULL, '2025-06-14 09:49:59', 'Add_Transport_And_Storage_Activity_To_Requested_For_Transportation', '0b0913e6-2202-11ed-aa65-0a343ee84526', 19642);

INSERT INTO vehicle_rts_activities (
  activity_type, is_include_revoke,
  notes, activity_date, created_at,
  updated_at, is_deleted, created_by,
  updated_by, revoke_request_id, vehicle_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO vehicle_rts_activities (activity_type, is_include_revoke, notes, activity_date, created_at, updated_at, is_deleted, created_by, updated_by, revoke_request_id, vehicle_id) VALUES ('Transport_And_Store', NULL, NULL, '2025-06-14 12:48:00', '2025-06-14 09:49:59', NULL, NULL, '0b0913e6-2202-11ed-aa65-0a343ee84526', NULL, 11014, NULL);

INSERT INTO vehicle_rts_activity_storage (
  storage_activity_id, warehouse_id
)
VALUES
  (?, ?)

INSERT INTO vehicle_rts_activity_storage (storage_activity_id, warehouse_id) VALUES (19246, 14);

SELECT
  t0.request_id AS request_id_1,
  t0.request_type AS request_type_2,
  t0.is_estimate_val_requested AS is_estimate_val_requested_3,
  t0.request_date AS request_date_4,
  t0.revoke_cancellation_notes AS revoke_cancellation_notes_5,
  t0.is_rejected AS is_rejected_6,
  t0.rejection_reason AS rejection_reason_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_10,
  t0.auth_image_path AS auth_image_path_11,
  t0.estimate_image_path AS estimate_image_path_12,
  t0.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_13,
  t0.created_by AS created_by_14,
  t0.updated_by AS updated_by_15,
  t0.vehicle_id AS vehicle_id_16,
  t17.address AS address_18,
  t17.responsible_person_name AS responsible_person_name_19,
  t17.responsible_person_mob_num AS responsible_person_mob_num_20,
  t17.responsible_person_mob_num2 AS responsible_person_mob_num2_21,
  t17.responsible_person_mob_num3 AS responsible_person_mob_num3_22,
  t17.request_id AS request_id_23,
  t17.city_id AS city_id_24,
  t17.request_id AS request_id_25,
  t26.address AS address_27,
  t26.responsible_person_name AS responsible_person_name_28,
  t26.responsible_person_mob_num AS responsible_person_mob_num_29,
  t26.request_id AS request_id_30,
  t26.city_id AS city_id_31,
  t26.request_id AS request_id_32
FROM
  vehicle_revoke_requests t0
  LEFT JOIN vehicle_revoke_request_source t17 ON t17.request_id = t0.request_id
  LEFT JOIN vehicle_revoke_request_destination t26 ON t26.request_id = t0.request_id
WHERE
  t0.request_id = ?

SELECT t0.request_id AS request_id_1, t0.request_type AS request_type_2, t0.is_estimate_val_requested AS is_estimate_val_requested_3, t0.request_date AS request_date_4, t0.revoke_cancellation_notes AS revoke_cancellation_notes_5, t0.is_rejected AS is_rejected_6, t0.rejection_reason AS rejection_reason_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_10, t0.auth_image_path AS auth_image_path_11, t0.estimate_image_path AS estimate_image_path_12, t0.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.vehicle_id AS vehicle_id_16, t17.address AS address_18, t17.responsible_person_name AS responsible_person_name_19, t17.responsible_person_mob_num AS responsible_person_mob_num_20, t17.responsible_person_mob_num2 AS responsible_person_mob_num2_21, t17.responsible_person_mob_num3 AS responsible_person_mob_num3_22, t17.request_id AS request_id_23, t17.city_id AS city_id_24, t17.request_id AS request_id_25, t26.address AS address_27, t26.responsible_person_name AS responsible_person_name_28, t26.responsible_person_mob_num AS responsible_person_mob_num_29, t26.request_id AS request_id_30, t26.city_id AS city_id_31, t26.request_id AS request_id_32 FROM vehicle_revoke_requests t0 LEFT JOIN vehicle_revoke_request_source t17 ON t17.request_id = t0.request_id LEFT JOIN vehicle_revoke_request_destination t26 ON t26.request_id = t0.request_id WHERE t0.request_id = '11014';

UPDATE
  vehicles
SET
  state = ?
WHERE
  vehicle_id = ?

UPDATE vehicles SET state = '{\"Not_Sold\":1,\"Not_Transferred\":1,\"Not_Permitted_To_Exit\":1,\"Under_Transportation\":1}' WHERE vehicle_id = 19642;

INSERT INTO vehicle_rts_activities_inventories (
  inventory_notes, inventory_activity_id
)
VALUES
  (?, ?)

INSERT INTO vehicle_rts_activities_inventories (inventory_notes, inventory_activity_id) VALUES (NULL, 19246);

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 = '0b0913e6-2202-11ed-aa65-0a343ee84526';

SELECT
  t0.part_id AS part_id_1,
  t0.name_ar AS name_ar_2,
  t0.name_en AS name_en_3
FROM
  inventory_parts t0

SELECT t0.part_id AS part_id_1, t0.name_ar AS name_ar_2, t0.name_en AS name_en_3 FROM inventory_parts t0;

SELECT
  t0_.transporter_id AS transporter_id_0,
  t0_.name_ar AS name_ar_1,
  t0_.name_en AS name_en_2,
  t0_.agreement_type AS agreement_type_3,
  t0_.is_active AS is_active_4,
  t0_.company_id AS company_id_5
FROM
  transporters t0_
WHERE
  t0_.transporter_id IN (?)

SELECT t0_.transporter_id AS transporter_id_0, t0_.name_ar AS name_ar_1, t0_.name_en AS name_en_2, t0_.agreement_type AS agreement_type_3, t0_.is_active AS is_active_4, t0_.company_id AS company_id_5 FROM transporters t0_ WHERE t0_.transporter_id IN ('2');

SELECT
  r0_.region_id AS region_id_0,
  r0_.name_ar AS name_ar_1,
  r0_.name_en AS name_en_2
FROM
  regions r0_
WHERE
  r0_.region_id IN (?)

SELECT r0_.region_id AS region_id_0, r0_.name_ar AS name_ar_1, r0_.name_en AS name_en_2 FROM regions r0_ WHERE r0_.region_id IN ('1');

SELECT
  v0_.vat_ratio AS vat_ratio_0,
  v0_.vat_text AS vat_text_1,
  v0_.is_the_effective AS is_the_effective_2,
  v0_.vat_rate_id AS vat_rate_id_3
FROM
  vat_rate v0_
WHERE
  v0_.is_the_effective = 1
LIMIT
  1

SELECT v0_.vat_ratio AS vat_ratio_0, v0_.vat_text AS vat_text_1, v0_.is_the_effective AS is_the_effective_2, v0_.vat_rate_id AS vat_rate_id_3 FROM vat_rate v0_ WHERE v0_.is_the_effective = 1 LIMIT 1;

SELECT
  t0_.driver_id AS driver_id_0,
  t0_.is_active AS is_active_1,
  t0_.transporter_id AS transporter_id_2,
  t0_.user_id AS user_id_3
FROM
  transporter_drivers t0_
WHERE
  t0_.is_active = 1
  AND t0_.driver_id IN (?)

SELECT t0_.driver_id AS driver_id_0, t0_.is_active AS is_active_1, t0_.transporter_id AS transporter_id_2, t0_.user_id AS user_id_3 FROM transporter_drivers t0_ WHERE t0_.is_active = 1 AND t0_.driver_id IN ('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 = ?

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 = 19642;

SELECT
  t0.inventory_notes AS inventory_notes_1,
  t0.inventory_activity_id AS inventory_activity_id_2,
  t0.inventory_activity_id AS inventory_activity_id_3
FROM
  vehicle_rts_activities_inventories t0
WHERE
  t0.inventory_activity_id = ?

SELECT t0.inventory_notes AS inventory_notes_1, t0.inventory_activity_id AS inventory_activity_id_2, t0.inventory_activity_id AS inventory_activity_id_3 FROM vehicle_rts_activities_inventories t0 WHERE t0.inventory_activity_id = 19246;

SELECT
  w0_.warehouse_id AS warehouse_id_0,
  w0_.name AS name_1,
  w0_.address AS address_2,
  w0_.telephone AS telephone_3,
  w0_.is_active AS is_active_4,
  w0_.city_id AS city_id_5,
  w0_.company_id AS company_id_6
FROM
  warehouses w0_
WHERE
  w0_.is_active = 1
  AND w0_.warehouse_id IN (?)

SELECT w0_.warehouse_id AS warehouse_id_0, w0_.name AS name_1, w0_.address AS address_2, w0_.telephone AS telephone_3, w0_.is_active AS is_active_4, w0_.city_id AS city_id_5, w0_.company_id AS company_id_6 FROM warehouses w0_ WHERE w0_.is_active = 1 AND w0_.warehouse_id IN ('14');