Symfony Profiler

SELECT
  count(DISTINCT v0_.vehicle_id) AS sclr_0
FROM
  vehicles v0_
  INNER JOIN vehicle_registrations v1_ ON v0_.vehicle_id = v1_.vehicle_id
  LEFT JOIN panel_letters p2_ ON v1_.panel_letter1 = p2_.letter_code
  LEFT JOIN vehicle_beneficiary_details v3_ ON v0_.vehicle_id = v3_.vehicle_id
  LEFT JOIN vehicle_technical_specs v4_ ON v0_.vehicle_id = v4_.vehicle_id
WHERE
  1 = 1
  AND (
    v1_.panel_numbers LIKE ?
    OR v4_.old_panel_numbers LIKE ?
  )
  AND (
    v1_.panel_letter1 = ?
    OR v4_.old_panel_letter1 = ?
  )
  AND (
    v1_.panel_letter2 = ?
    OR v4_.old_panel_letter2 = ?
  )
  AND (
    v1_.panel_letter3 = ?
    OR v4_.old_panel_letter3 = ?
  )

SELECT count(DISTINCT v0_.vehicle_id) AS sclr_0 FROM vehicles v0_ INNER JOIN vehicle_registrations v1_ ON v0_.vehicle_id = v1_.vehicle_id LEFT JOIN panel_letters p2_ ON v1_.panel_letter1 = p2_.letter_code LEFT JOIN vehicle_beneficiary_details v3_ ON v0_.vehicle_id = v3_.vehicle_id LEFT JOIN vehicle_technical_specs v4_ ON v0_.vehicle_id = v4_.vehicle_id WHERE 1 = 1 AND (v1_.panel_numbers LIKE '%3898%' OR v4_.old_panel_numbers LIKE '%3898%') AND (v1_.panel_letter1 = '2' OR v4_.old_panel_letter1 = '2') AND (v1_.panel_letter2 = '9' OR v4_.old_panel_letter2 = '9') AND (v1_.panel_letter3 = '8' OR v4_.old_panel_letter3 = '8');

SELECT
  DISTINCT v0_.vehicle_id AS vehicle_id_0,
  v0_.vehicle_id AS vehicle_id_1
FROM
  vehicles v0_
  INNER JOIN vehicle_registrations v1_ ON v0_.vehicle_id = v1_.vehicle_id
  LEFT JOIN panel_letters p2_ ON v1_.panel_letter1 = p2_.letter_code
  LEFT JOIN vehicle_beneficiary_details v3_ ON v0_.vehicle_id = v3_.vehicle_id
  LEFT JOIN vehicle_technical_specs v4_ ON v0_.vehicle_id = v4_.vehicle_id
WHERE
  1 = 1
  AND (
    v1_.panel_numbers LIKE ?
    OR v4_.old_panel_numbers LIKE ?
  )
  AND (
    v1_.panel_letter1 = ?
    OR v4_.old_panel_letter1 = ?
  )
  AND (
    v1_.panel_letter2 = ?
    OR v4_.old_panel_letter2 = ?
  )
  AND (
    v1_.panel_letter3 = ?
    OR v4_.old_panel_letter3 = ?
  )
ORDER BY
  v0_.vehicle_id DESC
LIMIT
  20

SELECT DISTINCT v0_.vehicle_id AS vehicle_id_0, v0_.vehicle_id AS vehicle_id_1 FROM vehicles v0_ INNER JOIN vehicle_registrations v1_ ON v0_.vehicle_id = v1_.vehicle_id LEFT JOIN panel_letters p2_ ON v1_.panel_letter1 = p2_.letter_code LEFT JOIN vehicle_beneficiary_details v3_ ON v0_.vehicle_id = v3_.vehicle_id LEFT JOIN vehicle_technical_specs v4_ ON v0_.vehicle_id = v4_.vehicle_id WHERE 1 = 1 AND (v1_.panel_numbers LIKE '%3898%' OR v4_.old_panel_numbers LIKE '%3898%') AND (v1_.panel_letter1 = '2' OR v4_.old_panel_letter1 = '2') AND (v1_.panel_letter2 = '9' OR v4_.old_panel_letter2 = '9') AND (v1_.panel_letter3 = '8' OR v4_.old_panel_letter3 = '8') ORDER BY v0_.vehicle_id DESC LIMIT 20;

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 = '88cb9365-e99f-11ec-aa65-0a343ee84526';

SELECT
  p0_.letter_code AS letter_code_0,
  p0_.letter_ar AS letter_ar_1,
  p0_.letter_en AS letter_en_2
FROM
  panel_letters p0_
WHERE
  p0_.letter_code IN (?)

SELECT p0_.letter_code AS letter_code_0, p0_.letter_ar AS letter_ar_1, p0_.letter_en AS letter_en_2 FROM panel_letters p0_ WHERE p0_.letter_code IN ('2');

SELECT
  v0_.model_id AS model_id_0,
  v0_.name_ar AS name_ar_1,
  v0_.name_en AS name_en_2,
  v0_.oracle_model_id AS oracle_model_id_3,
  v0_.maker_id AS maker_id_4
FROM
  vehicle_models v0_

SELECT v0_.model_id AS model_id_0, v0_.name_ar AS name_ar_1, v0_.name_en AS name_en_2, v0_.oracle_model_id AS oracle_model_id_3, v0_.maker_id AS maker_id_4 FROM vehicle_models v0_;

SELECT
  c0_.delegation_id AS delegation_id_0,
  c0_.relationship AS relationship_1,
  c0_.image_path AS image_path_2,
  c0_.approval_status AS approval_status_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  v1_.client_id AS client_id_6,
  v1_.is_active AS is_active_7,
  c2_.company_id AS company_id_8,
  c2_.shortname_ar AS shortname_ar_9,
  c2_.shortname_en AS shortname_en_10,
  c2_.building_no AS building_no_11,
  c2_.unit_no AS unit_no_12,
  c2_.street_name_ar AS street_name_ar_13,
  c2_.street_name_en AS street_name_en_14,
  c2_.district_name_ar AS district_name_ar_15,
  c2_.district_name_en AS district_name_en_16,
  c2_.zip_code AS zip_code_17,
  c2_.additional_no AS additional_no_18,
  c2_.universal_no AS universal_no_19,
  c2_.sms AS sms_20,
  c2_.email AS email_21,
  c2_.email2 AS email2_22,
  c2_.website AS website_23,
  c2_.trade_chamber_no AS trade_chamber_no_24,
  c2_.client_id AS client_id_25,
  c2_.vat_no AS vat_no_26,
  c2_.social_insurance_no AS social_insurance_no_27,
  c2_.labour_institution_no AS labour_institution_no_28,
  c2_.balance AS balance_29,
  c2_.locked_ot_security AS locked_ot_security_30,
  c2_.zakat_id_no AS zakat_id_no_31,
  c2_.municipality_license_no AS municipality_license_no_32,
  c2_.seal_path AS seal_path_33,
  c2_.logo_path AS logo_path_34,
  c2_.signature_path AS signature_path_35,
  c2_.is_beneficiary AS is_beneficiary_36,
  c2_.is_tjr_co AS is_tjr_co_37,
  c2_.is_bank AS is_bank_38,
  c2_.created_at AS created_at_39,
  c2_.updated_at AS updated_at_40,
  c2_.bank_code AS bank_code_41,
  c2_.balance_amount AS balance_amount_42,
  c2_.pledge_amount AS pledge_amount_43,
  c2_.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_44,
  c2_.balance_due AS balance_due_45,
  u3_.user_id AS user_id_46,
  u3_.username AS username_47,
  u3_.password AS password_48,
  u3_.telephone AS telephone_49,
  u3_.roles AS roles_50,
  u3_.mobile_number AS mobile_number_51,
  u3_.mobile_number2 AS mobile_number2_52,
  u3_.is_mobile_number2_verified AS is_mobile_number2_verified_53,
  u3_.email AS email_54,
  u3_.email_verified AS email_verified_55,
  u3_.verify_token AS verify_token_56,
  u3_.balance AS balance_57,
  u3_.locked_ot_security AS locked_ot_security_58,
  u3_.is_verified AS is_verified_59,
  u3_.is_deleted AS is_deleted_60,
  u3_.is_receive_sms AS is_receive_sms_61,
  u3_.last_login AS last_login_62,
  u3_.created_at AS created_at_63,
  u3_.updated_at AS updated_at_64,
  u3_.profile_origin AS profile_origin_65,
  u3_.signature_path AS signature_path_66,
  u3_.balance_amount AS balance_amount_67,
  u3_.pledge_amount AS pledge_amount_68,
  u3_.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_69,
  u3_.balance_due AS balance_due_70,
  u3_.client_id AS client_id_71,
  c0_.delegator_id AS delegator_id_72,
  c0_.delegated_id AS delegated_id_73,
  c0_.created_by AS created_by_74,
  c0_.updated_by AS updated_by_75,
  v1_.company_id AS company_id_76,
  v1_.user_id AS user_id_77,
  c2_.classification_id AS classification_id_78,
  c2_.city_id AS city_id_79,
  c2_.created_by AS created_by_80,
  c2_.updated_by AS updated_by_81,
  c2_.category_id AS category_id_82,
  u3_.category_id AS category_id_83,
  u3_.company_id AS company_id_84,
  u3_.created_by AS created_by_85,
  u3_.updated_by AS updated_by_86
FROM
  clients_delegation c0_
  LEFT JOIN vehicle_clients v1_ ON c0_.delegator_id = v1_.client_id
  LEFT JOIN companies c2_ ON v1_.company_id = c2_.company_id
  LEFT JOIN users u3_ ON v1_.user_id = u3_.user_id
WHERE
  c0_.delegated_id = ?
  AND c0_.approval_status = ?

SELECT c0_.delegation_id AS delegation_id_0, c0_.relationship AS relationship_1, c0_.image_path AS image_path_2, c0_.approval_status AS approval_status_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, v1_.client_id AS client_id_6, v1_.is_active AS is_active_7, c2_.company_id AS company_id_8, c2_.shortname_ar AS shortname_ar_9, c2_.shortname_en AS shortname_en_10, c2_.building_no AS building_no_11, c2_.unit_no AS unit_no_12, c2_.street_name_ar AS street_name_ar_13, c2_.street_name_en AS street_name_en_14, c2_.district_name_ar AS district_name_ar_15, c2_.district_name_en AS district_name_en_16, c2_.zip_code AS zip_code_17, c2_.additional_no AS additional_no_18, c2_.universal_no AS universal_no_19, c2_.sms AS sms_20, c2_.email AS email_21, c2_.email2 AS email2_22, c2_.website AS website_23, c2_.trade_chamber_no AS trade_chamber_no_24, c2_.client_id AS client_id_25, c2_.vat_no AS vat_no_26, c2_.social_insurance_no AS social_insurance_no_27, c2_.labour_institution_no AS labour_institution_no_28, c2_.balance AS balance_29, c2_.locked_ot_security AS locked_ot_security_30, c2_.zakat_id_no AS zakat_id_no_31, c2_.municipality_license_no AS municipality_license_no_32, c2_.seal_path AS seal_path_33, c2_.logo_path AS logo_path_34, c2_.signature_path AS signature_path_35, c2_.is_beneficiary AS is_beneficiary_36, c2_.is_tjr_co AS is_tjr_co_37, c2_.is_bank AS is_bank_38, c2_.created_at AS created_at_39, c2_.updated_at AS updated_at_40, c2_.bank_code AS bank_code_41, c2_.balance_amount AS balance_amount_42, c2_.pledge_amount AS pledge_amount_43, c2_.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_44, c2_.balance_due AS balance_due_45, u3_.user_id AS user_id_46, u3_.username AS username_47, u3_.password AS password_48, u3_.telephone AS telephone_49, u3_.roles AS roles_50, u3_.mobile_number AS mobile_number_51, u3_.mobile_number2 AS mobile_number2_52, u3_.is_mobile_number2_verified AS is_mobile_number2_verified_53, u3_.email AS email_54, u3_.email_verified AS email_verified_55, u3_.verify_token AS verify_token_56, u3_.balance AS balance_57, u3_.locked_ot_security AS locked_ot_security_58, u3_.is_verified AS is_verified_59, u3_.is_deleted AS is_deleted_60, u3_.is_receive_sms AS is_receive_sms_61, u3_.last_login AS last_login_62, u3_.created_at AS created_at_63, u3_.updated_at AS updated_at_64, u3_.profile_origin AS profile_origin_65, u3_.signature_path AS signature_path_66, u3_.balance_amount AS balance_amount_67, u3_.pledge_amount AS pledge_amount_68, u3_.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_69, u3_.balance_due AS balance_due_70, u3_.client_id AS client_id_71, c0_.delegator_id AS delegator_id_72, c0_.delegated_id AS delegated_id_73, c0_.created_by AS created_by_74, c0_.updated_by AS updated_by_75, v1_.company_id AS company_id_76, v1_.user_id AS user_id_77, c2_.classification_id AS classification_id_78, c2_.city_id AS city_id_79, c2_.created_by AS created_by_80, c2_.updated_by AS updated_by_81, c2_.category_id AS category_id_82, u3_.category_id AS category_id_83, u3_.company_id AS company_id_84, u3_.created_by AS created_by_85, u3_.updated_by AS updated_by_86 FROM clients_delegation c0_ LEFT JOIN vehicle_clients v1_ ON c0_.delegator_id = v1_.client_id LEFT JOIN companies c2_ ON v1_.company_id = c2_.company_id LEFT JOIN users u3_ ON v1_.user_id = u3_.user_id WHERE c0_.delegated_id = '88cb9365-e99f-11ec-aa65-0a343ee84526' AND c0_.approval_status = 'approved';

SELECT
  p0_.letter_code AS letter_code_0,
  p0_.letter_ar AS letter_ar_1,
  p0_.letter_en AS letter_en_2
FROM
  panel_letters p0_

SELECT p0_.letter_code AS letter_code_0, p0_.letter_ar AS letter_ar_1, p0_.letter_en AS letter_en_2 FROM panel_letters p0_;

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_

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_;

SELECT
  v0_.maker_id AS maker_id_0,
  v0_.name_ar AS name_ar_1,
  v0_.name_en AS name_en_2
FROM
  vehicle_makers v0_

SELECT v0_.maker_id AS maker_id_0, v0_.name_ar AS name_ar_1, v0_.name_en AS name_en_2 FROM vehicle_makers v0_;

SELECT
  v0_.registration_id AS registration_id_0,
  v0_.name_ar AS name_ar_1,
  v0_.name_en AS name_en_2
FROM
  vehicle_registration_types v0_

SELECT v0_.registration_id AS registration_id_0, v0_.name_ar AS name_ar_1, v0_.name_en AS name_en_2 FROM vehicle_registration_types v0_;