Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.facebook AS facebook_2,
  t0.instagram AS instagram_3,
  t0.linked_in AS linked_in_4,
  t0.twitter AS twitter_5,
  t0.you_tube AS you_tube_6,
  t0.tik_tok AS tik_tok_7,
  t0.vimeo AS vimeo_8,
  t0.company_id AS company_id_9,
  t0.personal_info_id AS personal_info_id_10
FROM
  social_media t0
WHERE
  t0.personal_info_id = ?

SELECT t0.id AS id_1, t0.facebook AS facebook_2, t0.instagram AS instagram_3, t0.linked_in AS linked_in_4, t0.twitter AS twitter_5, t0.you_tube AS you_tube_6, t0.tik_tok AS tik_tok_7, t0.vimeo AS vimeo_8, t0.company_id AS company_id_9, t0.personal_info_id AS personal_info_id_10 FROM social_media t0 WHERE t0.personal_info_id = 128;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.canonical_email AS canonical_email_3,
  t0.email_validated AS email_validated_4,
  t0.password AS password_5,
  t0.is_active AS is_active_6,
  t0.roles AS roles_7,
  t0.confirmation_token AS confirmation_token_8,
  t0.forget_token AS forget_token_9,
  t0.created_at AS created_at_10,
  t0.last_activity_at AS last_activity_at_11,
  t0.last_login_at AS last_login_at_12,
  t0.google_id AS google_id_13,
  t0.temporary_picture AS temporary_picture_14,
  t0.status AS status_15,
  t0.fwa_status AS fwa_status_16,
  t0.reminder AS reminder_17,
  t0.feature_document_management AS feature_document_management_18,
  t0.permission AS permission_19,
  t0.appraisal_status AS appraisal_status_20,
  t0.objective_status AS objective_status_21,
  t0.is_manager AS is_manager_22,
  t23.id AS id_24,
  t23.first_name AS first_name_25,
  t23.middle_name AS middle_name_26,
  t23.last_name AS last_name_27,
  t23.chinese_name AS chinese_name_28,
  t23.address_street AS address_street_29,
  t23.address_city AS address_city_30,
  t23.job_title AS job_title_31,
  t23.job_join_date AS job_join_date_32,
  t23.job_description AS job_description_33,
  t23.job_responsibility AS job_responsibility_34,
  t23.tax_number AS tax_number_35,
  t23.tax_status AS tax_status_36,
  t23.social_security_number AS social_security_number_37,
  t23.gender AS gender_38,
  t23.religion AS religion_39,
  t23.blood_type AS blood_type_40,
  t23.birth_place AS birth_place_41,
  t23.birth_date AS birth_date_42,
  t23.nationality AS nationality_43,
  t23.id_number AS id_number_44,
  t23.passport_number AS passport_number_45,
  t23.passport_issue_date AS passport_issue_date_46,
  t23.passport_expiry_date AS passport_expiry_date_47,
  t23.employment_pass_number AS employment_pass_number_48,
  t23.work_permit_issue_date AS work_permit_issue_date_49,
  t23.work_permit_expiry_date AS work_permit_expiry_date_50,
  t23.contact_phone AS contact_phone_51,
  t23.contact_mobile AS contact_mobile_52,
  t23.contact_email AS contact_email_53,
  t23.contact_skype AS contact_skype_54,
  t23.emergency_contact_name AS emergency_contact_name_55,
  t23.emergency_contact_phone AS emergency_contact_phone_56,
  t23.marital_status AS marital_status_57,
  t23.spouse_name AS spouse_name_58,
  t23.spouse_passport_number AS spouse_passport_number_59,
  t23.spouse_nationality AS spouse_nationality_60,
  t23.spouse_occupation AS spouse_occupation_61,
  t23.spouse_employer AS spouse_employer_62,
  t23.profile_picture AS profile_picture_63,
  t23.job_status AS job_status_64,
  t23.modified_at AS modified_at_65,
  t23.job_expiry_date AS job_expiry_date_66,
  t23.work_permit_type AS work_permit_type_67,
  t23.curriculum_vitae AS curriculum_vitae_68,
  t23.about_me AS about_me_69,
  t23.address_postcode AS address_postcode_70,
  t23.address_country AS address_country_71,
  t23.language AS language_72,
  t23.job_terminate_date AS job_terminate_date_73,
  t23.job_terminate_reason AS job_terminate_reason_74,
  t23.job_permanent_date AS job_permanent_date_75,
  t23.attributes AS attributes_76,
  t23.contact_wechat AS contact_wechat_77,
  t23.contact_whatsapp AS contact_whatsapp_78,
  t23.appointment_scheduling AS appointment_scheduling_79,
  t23.id_issue_date AS id_issue_date_80,
  t23.id_expiry_date AS id_expiry_date_81,
  t23.id_file AS id_file_82,
  t23.passport_file AS passport_file_83,
  t23.employment_pass_file AS employment_pass_file_84,
  t23.pip_date AS pip_date_85,
  t23.pip_extension_date AS pip_extension_date_86,
  t23.pip_file AS pip_file_87,
  t23.pip_end_date AS pip_end_date_88,
  t23.tax_file AS tax_file_89,
  t23.user_id AS user_id_90,
  t23.preferred_bank_id AS preferred_bank_id_91,
  t23.user_role_id AS user_role_id_92,
  t23.recruit_applicant_id AS recruit_applicant_id_93,
  t0.office_id AS office_id_94,
  t0.manager_id AS manager_id_95,
  t96.id AS id_97,
  t96.fwh AS fwh_98,
  t96.fp AS fp_99,
  t96.pt AS pt_100,
  t96.updated_at AS updated_at_101,
  t96.user_id AS user_id_102,
  t0.department_id AS department_id_103,
  t104.id AS id_105,
  t104.status AS status_106,
  t104.title AS title_107,
  t104.join_date AS join_date_108,
  t104.description AS description_109,
  t104.responsibility AS responsibility_110,
  t104.expiry_date AS expiry_date_111,
  t104.terminate_date AS terminate_date_112,
  t104.terminate_reason AS terminate_reason_113,
  t104.permanent_date AS permanent_date_114,
  t104.salary AS salary_115,
  t104.hourly_rate AS hourly_rate_116,
  t104.user_id AS user_id_117
FROM
  user t0
  LEFT JOIN personal_info t23 ON t23.user_id = t0.id
  LEFT JOIN flexi_work_arrangement_option t96 ON t96.user_id = t0.id
  LEFT JOIN job_info t104 ON t104.user_id = t0.id
  INNER JOIN user_user ON t0.id = user_user.user_id
WHERE
  user_user.sub_manager_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.canonical_email AS canonical_email_3, t0.email_validated AS email_validated_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.roles AS roles_7, t0.confirmation_token AS confirmation_token_8, t0.forget_token AS forget_token_9, t0.created_at AS created_at_10, t0.last_activity_at AS last_activity_at_11, t0.last_login_at AS last_login_at_12, t0.google_id AS google_id_13, t0.temporary_picture AS temporary_picture_14, t0.status AS status_15, t0.fwa_status AS fwa_status_16, t0.reminder AS reminder_17, t0.feature_document_management AS feature_document_management_18, t0.permission AS permission_19, t0.appraisal_status AS appraisal_status_20, t0.objective_status AS objective_status_21, t0.is_manager AS is_manager_22, t23.id AS id_24, t23.first_name AS first_name_25, t23.middle_name AS middle_name_26, t23.last_name AS last_name_27, t23.chinese_name AS chinese_name_28, t23.address_street AS address_street_29, t23.address_city AS address_city_30, t23.job_title AS job_title_31, t23.job_join_date AS job_join_date_32, t23.job_description AS job_description_33, t23.job_responsibility AS job_responsibility_34, t23.tax_number AS tax_number_35, t23.tax_status AS tax_status_36, t23.social_security_number AS social_security_number_37, t23.gender AS gender_38, t23.religion AS religion_39, t23.blood_type AS blood_type_40, t23.birth_place AS birth_place_41, t23.birth_date AS birth_date_42, t23.nationality AS nationality_43, t23.id_number AS id_number_44, t23.passport_number AS passport_number_45, t23.passport_issue_date AS passport_issue_date_46, t23.passport_expiry_date AS passport_expiry_date_47, t23.employment_pass_number AS employment_pass_number_48, t23.work_permit_issue_date AS work_permit_issue_date_49, t23.work_permit_expiry_date AS work_permit_expiry_date_50, t23.contact_phone AS contact_phone_51, t23.contact_mobile AS contact_mobile_52, t23.contact_email AS contact_email_53, t23.contact_skype AS contact_skype_54, t23.emergency_contact_name AS emergency_contact_name_55, t23.emergency_contact_phone AS emergency_contact_phone_56, t23.marital_status AS marital_status_57, t23.spouse_name AS spouse_name_58, t23.spouse_passport_number AS spouse_passport_number_59, t23.spouse_nationality AS spouse_nationality_60, t23.spouse_occupation AS spouse_occupation_61, t23.spouse_employer AS spouse_employer_62, t23.profile_picture AS profile_picture_63, t23.job_status AS job_status_64, t23.modified_at AS modified_at_65, t23.job_expiry_date AS job_expiry_date_66, t23.work_permit_type AS work_permit_type_67, t23.curriculum_vitae AS curriculum_vitae_68, t23.about_me AS about_me_69, t23.address_postcode AS address_postcode_70, t23.address_country AS address_country_71, t23.language AS language_72, t23.job_terminate_date AS job_terminate_date_73, t23.job_terminate_reason AS job_terminate_reason_74, t23.job_permanent_date AS job_permanent_date_75, t23.attributes AS attributes_76, t23.contact_wechat AS contact_wechat_77, t23.contact_whatsapp AS contact_whatsapp_78, t23.appointment_scheduling AS appointment_scheduling_79, t23.id_issue_date AS id_issue_date_80, t23.id_expiry_date AS id_expiry_date_81, t23.id_file AS id_file_82, t23.passport_file AS passport_file_83, t23.employment_pass_file AS employment_pass_file_84, t23.pip_date AS pip_date_85, t23.pip_extension_date AS pip_extension_date_86, t23.pip_file AS pip_file_87, t23.pip_end_date AS pip_end_date_88, t23.tax_file AS tax_file_89, t23.user_id AS user_id_90, t23.preferred_bank_id AS preferred_bank_id_91, t23.user_role_id AS user_role_id_92, t23.recruit_applicant_id AS recruit_applicant_id_93, t0.office_id AS office_id_94, t0.manager_id AS manager_id_95, t96.id AS id_97, t96.fwh AS fwh_98, t96.fp AS fp_99, t96.pt AS pt_100, t96.updated_at AS updated_at_101, t96.user_id AS user_id_102, t0.department_id AS department_id_103, t104.id AS id_105, t104.status AS status_106, t104.title AS title_107, t104.join_date AS join_date_108, t104.description AS description_109, t104.responsibility AS responsibility_110, t104.expiry_date AS expiry_date_111, t104.terminate_date AS terminate_date_112, t104.terminate_reason AS terminate_reason_113, t104.permanent_date AS permanent_date_114, t104.salary AS salary_115, t104.hourly_rate AS hourly_rate_116, t104.user_id AS user_id_117 FROM user t0 LEFT JOIN personal_info t23 ON t23.user_id = t0.id LEFT JOIN flexi_work_arrangement_option t96 ON t96.user_id = t0.id LEFT JOIN job_info t104 ON t104.user_id = t0.id INNER JOIN user_user ON t0.id = user_user.user_id WHERE user_user.sub_manager_id = 5;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.last_vaccination_date AS last_vaccination_date_3,
  t0.effective_date AS effective_date_4,
  t0.personal_info_id AS personal_info_id_5
FROM
  vaccination t0
WHERE
  t0.personal_info_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.last_vaccination_date AS last_vaccination_date_3, t0.effective_date AS effective_date_4, t0.personal_info_id AS personal_info_id_5 FROM vaccination t0 WHERE t0.personal_info_id = 128;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.canonical_email AS canonical_email_3,
  t0.email_validated AS email_validated_4,
  t0.password AS password_5,
  t0.is_active AS is_active_6,
  t0.roles AS roles_7,
  t0.confirmation_token AS confirmation_token_8,
  t0.forget_token AS forget_token_9,
  t0.created_at AS created_at_10,
  t0.last_activity_at AS last_activity_at_11,
  t0.last_login_at AS last_login_at_12,
  t0.google_id AS google_id_13,
  t0.temporary_picture AS temporary_picture_14,
  t0.status AS status_15,
  t0.fwa_status AS fwa_status_16,
  t0.reminder AS reminder_17,
  t0.feature_document_management AS feature_document_management_18,
  t0.permission AS permission_19,
  t0.appraisal_status AS appraisal_status_20,
  t0.objective_status AS objective_status_21,
  t0.is_manager AS is_manager_22,
  t23.id AS id_24,
  t23.first_name AS first_name_25,
  t23.middle_name AS middle_name_26,
  t23.last_name AS last_name_27,
  t23.chinese_name AS chinese_name_28,
  t23.address_street AS address_street_29,
  t23.address_city AS address_city_30,
  t23.job_title AS job_title_31,
  t23.job_join_date AS job_join_date_32,
  t23.job_description AS job_description_33,
  t23.job_responsibility AS job_responsibility_34,
  t23.tax_number AS tax_number_35,
  t23.tax_status AS tax_status_36,
  t23.social_security_number AS social_security_number_37,
  t23.gender AS gender_38,
  t23.religion AS religion_39,
  t23.blood_type AS blood_type_40,
  t23.birth_place AS birth_place_41,
  t23.birth_date AS birth_date_42,
  t23.nationality AS nationality_43,
  t23.id_number AS id_number_44,
  t23.passport_number AS passport_number_45,
  t23.passport_issue_date AS passport_issue_date_46,
  t23.passport_expiry_date AS passport_expiry_date_47,
  t23.employment_pass_number AS employment_pass_number_48,
  t23.work_permit_issue_date AS work_permit_issue_date_49,
  t23.work_permit_expiry_date AS work_permit_expiry_date_50,
  t23.contact_phone AS contact_phone_51,
  t23.contact_mobile AS contact_mobile_52,
  t23.contact_email AS contact_email_53,
  t23.contact_skype AS contact_skype_54,
  t23.emergency_contact_name AS emergency_contact_name_55,
  t23.emergency_contact_phone AS emergency_contact_phone_56,
  t23.marital_status AS marital_status_57,
  t23.spouse_name AS spouse_name_58,
  t23.spouse_passport_number AS spouse_passport_number_59,
  t23.spouse_nationality AS spouse_nationality_60,
  t23.spouse_occupation AS spouse_occupation_61,
  t23.spouse_employer AS spouse_employer_62,
  t23.profile_picture AS profile_picture_63,
  t23.job_status AS job_status_64,
  t23.modified_at AS modified_at_65,
  t23.job_expiry_date AS job_expiry_date_66,
  t23.work_permit_type AS work_permit_type_67,
  t23.curriculum_vitae AS curriculum_vitae_68,
  t23.about_me AS about_me_69,
  t23.address_postcode AS address_postcode_70,
  t23.address_country AS address_country_71,
  t23.language AS language_72,
  t23.job_terminate_date AS job_terminate_date_73,
  t23.job_terminate_reason AS job_terminate_reason_74,
  t23.job_permanent_date AS job_permanent_date_75,
  t23.attributes AS attributes_76,
  t23.contact_wechat AS contact_wechat_77,
  t23.contact_whatsapp AS contact_whatsapp_78,
  t23.appointment_scheduling AS appointment_scheduling_79,
  t23.id_issue_date AS id_issue_date_80,
  t23.id_expiry_date AS id_expiry_date_81,
  t23.id_file AS id_file_82,
  t23.passport_file AS passport_file_83,
  t23.employment_pass_file AS employment_pass_file_84,
  t23.pip_date AS pip_date_85,
  t23.pip_extension_date AS pip_extension_date_86,
  t23.pip_file AS pip_file_87,
  t23.pip_end_date AS pip_end_date_88,
  t23.tax_file AS tax_file_89,
  t23.user_id AS user_id_90,
  t23.preferred_bank_id AS preferred_bank_id_91,
  t23.user_role_id AS user_role_id_92,
  t23.recruit_applicant_id AS recruit_applicant_id_93,
  t0.office_id AS office_id_94,
  t0.manager_id AS manager_id_95,
  t96.id AS id_97,
  t96.fwh AS fwh_98,
  t96.fp AS fp_99,
  t96.pt AS pt_100,
  t96.updated_at AS updated_at_101,
  t96.user_id AS user_id_102,
  t0.department_id AS department_id_103,
  t104.id AS id_105,
  t104.status AS status_106,
  t104.title AS title_107,
  t104.join_date AS join_date_108,
  t104.description AS description_109,
  t104.responsibility AS responsibility_110,
  t104.expiry_date AS expiry_date_111,
  t104.terminate_date AS terminate_date_112,
  t104.terminate_reason AS terminate_reason_113,
  t104.permanent_date AS permanent_date_114,
  t104.salary AS salary_115,
  t104.hourly_rate AS hourly_rate_116,
  t104.user_id AS user_id_117
FROM
  user t0
  LEFT JOIN personal_info t23 ON t23.user_id = t0.id
  LEFT JOIN flexi_work_arrangement_option t96 ON t96.user_id = t0.id
  LEFT JOIN job_info t104 ON t104.user_id = t0.id
WHERE
  t0.office_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.canonical_email AS canonical_email_3, t0.email_validated AS email_validated_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.roles AS roles_7, t0.confirmation_token AS confirmation_token_8, t0.forget_token AS forget_token_9, t0.created_at AS created_at_10, t0.last_activity_at AS last_activity_at_11, t0.last_login_at AS last_login_at_12, t0.google_id AS google_id_13, t0.temporary_picture AS temporary_picture_14, t0.status AS status_15, t0.fwa_status AS fwa_status_16, t0.reminder AS reminder_17, t0.feature_document_management AS feature_document_management_18, t0.permission AS permission_19, t0.appraisal_status AS appraisal_status_20, t0.objective_status AS objective_status_21, t0.is_manager AS is_manager_22, t23.id AS id_24, t23.first_name AS first_name_25, t23.middle_name AS middle_name_26, t23.last_name AS last_name_27, t23.chinese_name AS chinese_name_28, t23.address_street AS address_street_29, t23.address_city AS address_city_30, t23.job_title AS job_title_31, t23.job_join_date AS job_join_date_32, t23.job_description AS job_description_33, t23.job_responsibility AS job_responsibility_34, t23.tax_number AS tax_number_35, t23.tax_status AS tax_status_36, t23.social_security_number AS social_security_number_37, t23.gender AS gender_38, t23.religion AS religion_39, t23.blood_type AS blood_type_40, t23.birth_place AS birth_place_41, t23.birth_date AS birth_date_42, t23.nationality AS nationality_43, t23.id_number AS id_number_44, t23.passport_number AS passport_number_45, t23.passport_issue_date AS passport_issue_date_46, t23.passport_expiry_date AS passport_expiry_date_47, t23.employment_pass_number AS employment_pass_number_48, t23.work_permit_issue_date AS work_permit_issue_date_49, t23.work_permit_expiry_date AS work_permit_expiry_date_50, t23.contact_phone AS contact_phone_51, t23.contact_mobile AS contact_mobile_52, t23.contact_email AS contact_email_53, t23.contact_skype AS contact_skype_54, t23.emergency_contact_name AS emergency_contact_name_55, t23.emergency_contact_phone AS emergency_contact_phone_56, t23.marital_status AS marital_status_57, t23.spouse_name AS spouse_name_58, t23.spouse_passport_number AS spouse_passport_number_59, t23.spouse_nationality AS spouse_nationality_60, t23.spouse_occupation AS spouse_occupation_61, t23.spouse_employer AS spouse_employer_62, t23.profile_picture AS profile_picture_63, t23.job_status AS job_status_64, t23.modified_at AS modified_at_65, t23.job_expiry_date AS job_expiry_date_66, t23.work_permit_type AS work_permit_type_67, t23.curriculum_vitae AS curriculum_vitae_68, t23.about_me AS about_me_69, t23.address_postcode AS address_postcode_70, t23.address_country AS address_country_71, t23.language AS language_72, t23.job_terminate_date AS job_terminate_date_73, t23.job_terminate_reason AS job_terminate_reason_74, t23.job_permanent_date AS job_permanent_date_75, t23.attributes AS attributes_76, t23.contact_wechat AS contact_wechat_77, t23.contact_whatsapp AS contact_whatsapp_78, t23.appointment_scheduling AS appointment_scheduling_79, t23.id_issue_date AS id_issue_date_80, t23.id_expiry_date AS id_expiry_date_81, t23.id_file AS id_file_82, t23.passport_file AS passport_file_83, t23.employment_pass_file AS employment_pass_file_84, t23.pip_date AS pip_date_85, t23.pip_extension_date AS pip_extension_date_86, t23.pip_file AS pip_file_87, t23.pip_end_date AS pip_end_date_88, t23.tax_file AS tax_file_89, t23.user_id AS user_id_90, t23.preferred_bank_id AS preferred_bank_id_91, t23.user_role_id AS user_role_id_92, t23.recruit_applicant_id AS recruit_applicant_id_93, t0.office_id AS office_id_94, t0.manager_id AS manager_id_95, t96.id AS id_97, t96.fwh AS fwh_98, t96.fp AS fp_99, t96.pt AS pt_100, t96.updated_at AS updated_at_101, t96.user_id AS user_id_102, t0.department_id AS department_id_103, t104.id AS id_105, t104.status AS status_106, t104.title AS title_107, t104.join_date AS join_date_108, t104.description AS description_109, t104.responsibility AS responsibility_110, t104.expiry_date AS expiry_date_111, t104.terminate_date AS terminate_date_112, t104.terminate_reason AS terminate_reason_113, t104.permanent_date AS permanent_date_114, t104.salary AS salary_115, t104.hourly_rate AS hourly_rate_116, t104.user_id AS user_id_117 FROM user t0 LEFT JOIN personal_info t23 ON t23.user_id = t0.id LEFT JOIN flexi_work_arrangement_option t96 ON t96.user_id = t0.id LEFT JOIN job_info t104 ON t104.user_id = t0.id WHERE t0.office_id = 4;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.logo AS logo_3,
  t0.introduction AS introduction_4,
  t0.starter_guide AS starter_guide_5,
  t0.reminder AS reminder_6,
  t0.attributes AS attributes_7,
  t0.user_id AS user_id_8,
  t9.id AS id_10,
  t9.facebook AS facebook_11,
  t9.instagram AS instagram_12,
  t9.linked_in AS linked_in_13,
  t9.twitter AS twitter_14,
  t9.you_tube AS you_tube_15,
  t9.tik_tok AS tik_tok_16,
  t9.vimeo AS vimeo_17,
  t9.company_id AS company_id_18,
  t9.personal_info_id AS personal_info_id_19
FROM
  company t0
  LEFT JOIN social_media t9 ON t9.company_id = t0.id
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.logo AS logo_3, t0.introduction AS introduction_4, t0.starter_guide AS starter_guide_5, t0.reminder AS reminder_6, t0.attributes AS attributes_7, t0.user_id AS user_id_8, t9.id AS id_10, t9.facebook AS facebook_11, t9.instagram AS instagram_12, t9.linked_in AS linked_in_13, t9.twitter AS twitter_14, t9.you_tube AS you_tube_15, t9.tik_tok AS tik_tok_16, t9.vimeo AS vimeo_17, t9.company_id AS company_id_18, t9.personal_info_id AS personal_info_id_19 FROM company t0 LEFT JOIN social_media t9 ON t9.company_id = t0.id WHERE t0.user_id = 128;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.address AS address_3,
  t0.country AS country_4,
  t0.contact_phone AS contact_phone_5,
  t0.registration_number AS registration_number_6,
  t0.tax_number AS tax_number_7,
  t0.work_permit_type AS work_permit_type_8,
  t0.starter_guide AS starter_guide_9,
  t0.currency AS currency_10,
  t0.custom_order AS custom_order_11,
  t0.custom_personal_info AS custom_personal_info_12,
  t0.company_id AS company_id_13,
  t0.widget_id AS widget_id_14,
  t15.id AS id_16,
  t15.flexi_work_hours_file AS flexi_work_hours_file_17,
  t15.flexi_place_file AS flexi_place_file_18,
  t15.part_time_file AS part_time_file_19,
  t15.info_url AS info_url_20,
  t15.info_file AS info_file_21,
  t15.tracking_url AS tracking_url_22,
  t15.tracking_file AS tracking_file_23,
  t15.tips_url AS tips_url_24,
  t15.tips_file AS tips_file_25,
  t15.office_id AS office_id_26,
  t27.id AS id_28,
  t27.about_info AS about_info_29,
  t27.social_media_info AS social_media_info_30,
  t27.personal_info AS personal_info_31,
  t27.contact_info AS contact_info_32,
  t27.marital_info AS marital_info_33,
  t27.children_info AS children_info_34,
  t27.employment_info AS employment_info_35,
  t27.tax_info AS tax_info_36,
  t27.payment_info AS payment_info_37,
  t27.office_id AS office_id_38,
  t39.id AS id_40,
  t39.annual_days AS annual_days_41,
  t39.is_incremental AS is_incremental_42,
  t39.incremental_start AS incremental_start_43,
  t39.incremental_value AS incremental_value_44,
  t39.sick_days AS sick_days_45,
  t39.office_id AS office_id_46
FROM
  office t0
  LEFT JOIN flexi_work_arrangement t15 ON t15.office_id = t0.id
  LEFT JOIN office_user_info t27 ON t27.office_id = t0.id
  LEFT JOIN office_leave t39 ON t39.office_id = t0.id
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.address AS address_3, t0.country AS country_4, t0.contact_phone AS contact_phone_5, t0.registration_number AS registration_number_6, t0.tax_number AS tax_number_7, t0.work_permit_type AS work_permit_type_8, t0.starter_guide AS starter_guide_9, t0.currency AS currency_10, t0.custom_order AS custom_order_11, t0.custom_personal_info AS custom_personal_info_12, t0.company_id AS company_id_13, t0.widget_id AS widget_id_14, t15.id AS id_16, t15.flexi_work_hours_file AS flexi_work_hours_file_17, t15.flexi_place_file AS flexi_place_file_18, t15.part_time_file AS part_time_file_19, t15.info_url AS info_url_20, t15.info_file AS info_file_21, t15.tracking_url AS tracking_url_22, t15.tracking_file AS tracking_file_23, t15.tips_url AS tips_url_24, t15.tips_file AS tips_file_25, t15.office_id AS office_id_26, t27.id AS id_28, t27.about_info AS about_info_29, t27.social_media_info AS social_media_info_30, t27.personal_info AS personal_info_31, t27.contact_info AS contact_info_32, t27.marital_info AS marital_info_33, t27.children_info AS children_info_34, t27.employment_info AS employment_info_35, t27.tax_info AS tax_info_36, t27.payment_info AS payment_info_37, t27.office_id AS office_id_38, t39.id AS id_40, t39.annual_days AS annual_days_41, t39.is_incremental AS is_incremental_42, t39.incremental_start AS incremental_start_43, t39.incremental_value AS incremental_value_44, t39.sick_days AS sick_days_45, t39.office_id AS office_id_46 FROM office t0 LEFT JOIN flexi_work_arrangement t15 ON t15.office_id = t0.id LEFT JOIN office_user_info t27 ON t27.office_id = t0.id LEFT JOIN office_leave t39 ON t39.office_id = t0.id WHERE t0.company_id = 4;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.canonical_email AS canonical_email_3,
  t0.email_validated AS email_validated_4,
  t0.password AS password_5,
  t0.is_active AS is_active_6,
  t0.roles AS roles_7,
  t0.confirmation_token AS confirmation_token_8,
  t0.forget_token AS forget_token_9,
  t0.created_at AS created_at_10,
  t0.last_activity_at AS last_activity_at_11,
  t0.last_login_at AS last_login_at_12,
  t0.google_id AS google_id_13,
  t0.temporary_picture AS temporary_picture_14,
  t0.status AS status_15,
  t0.fwa_status AS fwa_status_16,
  t0.reminder AS reminder_17,
  t0.feature_document_management AS feature_document_management_18,
  t0.permission AS permission_19,
  t0.appraisal_status AS appraisal_status_20,
  t0.objective_status AS objective_status_21,
  t0.is_manager AS is_manager_22,
  t23.id AS id_24,
  t23.first_name AS first_name_25,
  t23.middle_name AS middle_name_26,
  t23.last_name AS last_name_27,
  t23.chinese_name AS chinese_name_28,
  t23.address_street AS address_street_29,
  t23.address_city AS address_city_30,
  t23.job_title AS job_title_31,
  t23.job_join_date AS job_join_date_32,
  t23.job_description AS job_description_33,
  t23.job_responsibility AS job_responsibility_34,
  t23.tax_number AS tax_number_35,
  t23.tax_status AS tax_status_36,
  t23.social_security_number AS social_security_number_37,
  t23.gender AS gender_38,
  t23.religion AS religion_39,
  t23.blood_type AS blood_type_40,
  t23.birth_place AS birth_place_41,
  t23.birth_date AS birth_date_42,
  t23.nationality AS nationality_43,
  t23.id_number AS id_number_44,
  t23.passport_number AS passport_number_45,
  t23.passport_issue_date AS passport_issue_date_46,
  t23.passport_expiry_date AS passport_expiry_date_47,
  t23.employment_pass_number AS employment_pass_number_48,
  t23.work_permit_issue_date AS work_permit_issue_date_49,
  t23.work_permit_expiry_date AS work_permit_expiry_date_50,
  t23.contact_phone AS contact_phone_51,
  t23.contact_mobile AS contact_mobile_52,
  t23.contact_email AS contact_email_53,
  t23.contact_skype AS contact_skype_54,
  t23.emergency_contact_name AS emergency_contact_name_55,
  t23.emergency_contact_phone AS emergency_contact_phone_56,
  t23.marital_status AS marital_status_57,
  t23.spouse_name AS spouse_name_58,
  t23.spouse_passport_number AS spouse_passport_number_59,
  t23.spouse_nationality AS spouse_nationality_60,
  t23.spouse_occupation AS spouse_occupation_61,
  t23.spouse_employer AS spouse_employer_62,
  t23.profile_picture AS profile_picture_63,
  t23.job_status AS job_status_64,
  t23.modified_at AS modified_at_65,
  t23.job_expiry_date AS job_expiry_date_66,
  t23.work_permit_type AS work_permit_type_67,
  t23.curriculum_vitae AS curriculum_vitae_68,
  t23.about_me AS about_me_69,
  t23.address_postcode AS address_postcode_70,
  t23.address_country AS address_country_71,
  t23.language AS language_72,
  t23.job_terminate_date AS job_terminate_date_73,
  t23.job_terminate_reason AS job_terminate_reason_74,
  t23.job_permanent_date AS job_permanent_date_75,
  t23.attributes AS attributes_76,
  t23.contact_wechat AS contact_wechat_77,
  t23.contact_whatsapp AS contact_whatsapp_78,
  t23.appointment_scheduling AS appointment_scheduling_79,
  t23.id_issue_date AS id_issue_date_80,
  t23.id_expiry_date AS id_expiry_date_81,
  t23.id_file AS id_file_82,
  t23.passport_file AS passport_file_83,
  t23.employment_pass_file AS employment_pass_file_84,
  t23.pip_date AS pip_date_85,
  t23.pip_extension_date AS pip_extension_date_86,
  t23.pip_file AS pip_file_87,
  t23.pip_end_date AS pip_end_date_88,
  t23.tax_file AS tax_file_89,
  t23.user_id AS user_id_90,
  t23.preferred_bank_id AS preferred_bank_id_91,
  t23.user_role_id AS user_role_id_92,
  t23.recruit_applicant_id AS recruit_applicant_id_93,
  t0.office_id AS office_id_94,
  t0.manager_id AS manager_id_95,
  t96.id AS id_97,
  t96.fwh AS fwh_98,
  t96.fp AS fp_99,
  t96.pt AS pt_100,
  t96.updated_at AS updated_at_101,
  t96.user_id AS user_id_102,
  t0.department_id AS department_id_103,
  t104.id AS id_105,
  t104.status AS status_106,
  t104.title AS title_107,
  t104.join_date AS join_date_108,
  t104.description AS description_109,
  t104.responsibility AS responsibility_110,
  t104.expiry_date AS expiry_date_111,
  t104.terminate_date AS terminate_date_112,
  t104.terminate_reason AS terminate_reason_113,
  t104.permanent_date AS permanent_date_114,
  t104.salary AS salary_115,
  t104.hourly_rate AS hourly_rate_116,
  t104.user_id AS user_id_117
FROM
  user t0
  LEFT JOIN personal_info t23 ON t23.user_id = t0.id
  LEFT JOIN flexi_work_arrangement_option t96 ON t96.user_id = t0.id
  LEFT JOIN job_info t104 ON t104.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.canonical_email AS canonical_email_3, t0.email_validated AS email_validated_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.roles AS roles_7, t0.confirmation_token AS confirmation_token_8, t0.forget_token AS forget_token_9, t0.created_at AS created_at_10, t0.last_activity_at AS last_activity_at_11, t0.last_login_at AS last_login_at_12, t0.google_id AS google_id_13, t0.temporary_picture AS temporary_picture_14, t0.status AS status_15, t0.fwa_status AS fwa_status_16, t0.reminder AS reminder_17, t0.feature_document_management AS feature_document_management_18, t0.permission AS permission_19, t0.appraisal_status AS appraisal_status_20, t0.objective_status AS objective_status_21, t0.is_manager AS is_manager_22, t23.id AS id_24, t23.first_name AS first_name_25, t23.middle_name AS middle_name_26, t23.last_name AS last_name_27, t23.chinese_name AS chinese_name_28, t23.address_street AS address_street_29, t23.address_city AS address_city_30, t23.job_title AS job_title_31, t23.job_join_date AS job_join_date_32, t23.job_description AS job_description_33, t23.job_responsibility AS job_responsibility_34, t23.tax_number AS tax_number_35, t23.tax_status AS tax_status_36, t23.social_security_number AS social_security_number_37, t23.gender AS gender_38, t23.religion AS religion_39, t23.blood_type AS blood_type_40, t23.birth_place AS birth_place_41, t23.birth_date AS birth_date_42, t23.nationality AS nationality_43, t23.id_number AS id_number_44, t23.passport_number AS passport_number_45, t23.passport_issue_date AS passport_issue_date_46, t23.passport_expiry_date AS passport_expiry_date_47, t23.employment_pass_number AS employment_pass_number_48, t23.work_permit_issue_date AS work_permit_issue_date_49, t23.work_permit_expiry_date AS work_permit_expiry_date_50, t23.contact_phone AS contact_phone_51, t23.contact_mobile AS contact_mobile_52, t23.contact_email AS contact_email_53, t23.contact_skype AS contact_skype_54, t23.emergency_contact_name AS emergency_contact_name_55, t23.emergency_contact_phone AS emergency_contact_phone_56, t23.marital_status AS marital_status_57, t23.spouse_name AS spouse_name_58, t23.spouse_passport_number AS spouse_passport_number_59, t23.spouse_nationality AS spouse_nationality_60, t23.spouse_occupation AS spouse_occupation_61, t23.spouse_employer AS spouse_employer_62, t23.profile_picture AS profile_picture_63, t23.job_status AS job_status_64, t23.modified_at AS modified_at_65, t23.job_expiry_date AS job_expiry_date_66, t23.work_permit_type AS work_permit_type_67, t23.curriculum_vitae AS curriculum_vitae_68, t23.about_me AS about_me_69, t23.address_postcode AS address_postcode_70, t23.address_country AS address_country_71, t23.language AS language_72, t23.job_terminate_date AS job_terminate_date_73, t23.job_terminate_reason AS job_terminate_reason_74, t23.job_permanent_date AS job_permanent_date_75, t23.attributes AS attributes_76, t23.contact_wechat AS contact_wechat_77, t23.contact_whatsapp AS contact_whatsapp_78, t23.appointment_scheduling AS appointment_scheduling_79, t23.id_issue_date AS id_issue_date_80, t23.id_expiry_date AS id_expiry_date_81, t23.id_file AS id_file_82, t23.passport_file AS passport_file_83, t23.employment_pass_file AS employment_pass_file_84, t23.pip_date AS pip_date_85, t23.pip_extension_date AS pip_extension_date_86, t23.pip_file AS pip_file_87, t23.pip_end_date AS pip_end_date_88, t23.tax_file AS tax_file_89, t23.user_id AS user_id_90, t23.preferred_bank_id AS preferred_bank_id_91, t23.user_role_id AS user_role_id_92, t23.recruit_applicant_id AS recruit_applicant_id_93, t0.office_id AS office_id_94, t0.manager_id AS manager_id_95, t96.id AS id_97, t96.fwh AS fwh_98, t96.fp AS fp_99, t96.pt AS pt_100, t96.updated_at AS updated_at_101, t96.user_id AS user_id_102, t0.department_id AS department_id_103, t104.id AS id_105, t104.status AS status_106, t104.title AS title_107, t104.join_date AS join_date_108, t104.description AS description_109, t104.responsibility AS responsibility_110, t104.expiry_date AS expiry_date_111, t104.terminate_date AS terminate_date_112, t104.terminate_reason AS terminate_reason_113, t104.permanent_date AS permanent_date_114, t104.salary AS salary_115, t104.hourly_rate AS hourly_rate_116, t104.user_id AS user_id_117 FROM user t0 LEFT JOIN personal_info t23 ON t23.user_id = t0.id LEFT JOIN flexi_work_arrangement_option t96 ON t96.user_id = t0.id LEFT JOIN job_info t104 ON t104.user_id = t0.id WHERE t0.id = 128;