Symfony Profiler

SELECT
  e0_.emp_index AS emp_index_0,
  e0_.emp_lastname AS emp_lastname_1,
  e0_.emp_firstname AS emp_firstname_2,
  e0_.emp_middlename AS emp_middlename_3,
  e0_.emp_gender AS emp_gender_4,
  e0_.emp_start_date AS emp_start_date_5,
  e0_.emp_suffix AS emp_suffix_6,
  e0_.emp_timestamp_initial AS emp_timestamp_initial_7,
  e0_.emp_timestamp_update AS emp_timestamp_update_8,
  e0_.emp_ftpt AS emp_ftpt_9,
  e0_.emp_show_profile AS emp_show_profile_10,
  e0_.emp_disable AS emp_disable_11,
  e0_.emp_grad_residency AS emp_grad_residency_12,
  e0_.emp_profile_update_flag AS emp_profile_update_flag_13,
  e0_.emp_chief AS emp_chief_14,
  e0_.emp_program_director AS emp_program_director_15,
  e0_.emp_network_provider AS emp_network_provider_16,
  e0_.emp_pending_forms AS emp_pending_forms_17,
  e0_.emp_emerg_name AS emp_emerg_name_18,
  e0_.emp_emerg_phone AS emp_emerg_phone_19,
  e0_.emp_emerg_relationship AS emp_emerg_relationship_20,
  e0_.emp_birthdate AS emp_birthdate_21,
  e0_.emp_birthplace AS emp_birthplace_22,
  e0_.emp_ssn AS emp_ssn_23,
  e0_.emp_race AS emp_race_24,
  e0_.emp_citizenship_index AS emp_citizenship_index_25,
  e0_.emp_ethnicity AS emp_ethnicity_26,
  e0_.emp_email_primary_index AS emp_email_primary_index_27,
  e0_.emp_spouse_name AS emp_spouse_name_28,
  e0_.faculty_auto_exempt AS faculty_auto_exempt_29,
  e0_.bamboo_id AS bamboo_id_30,
  e0_.npi AS npi_31,
  e0_.umms_ad_username AS umms_ad_username_32,
  e0_.emp_email_primary_index AS emp_email_primary_index_33,
  e0_.emp_citizenship_index AS emp_citizenship_index_34,
  e0_.emp_gender AS emp_gender_35
FROM
  employee e0_
WHERE
  e0_.emp_index = ?
  AND e0_.emp_disable = 0
  AND e0_.emp_show_profile = 1

SELECT e0_.emp_index AS emp_index_0, e0_.emp_lastname AS emp_lastname_1, e0_.emp_firstname AS emp_firstname_2, e0_.emp_middlename AS emp_middlename_3, e0_.emp_gender AS emp_gender_4, e0_.emp_start_date AS emp_start_date_5, e0_.emp_suffix AS emp_suffix_6, e0_.emp_timestamp_initial AS emp_timestamp_initial_7, e0_.emp_timestamp_update AS emp_timestamp_update_8, e0_.emp_ftpt AS emp_ftpt_9, e0_.emp_show_profile AS emp_show_profile_10, e0_.emp_disable AS emp_disable_11, e0_.emp_grad_residency AS emp_grad_residency_12, e0_.emp_profile_update_flag AS emp_profile_update_flag_13, e0_.emp_chief AS emp_chief_14, e0_.emp_program_director AS emp_program_director_15, e0_.emp_network_provider AS emp_network_provider_16, e0_.emp_pending_forms AS emp_pending_forms_17, e0_.emp_emerg_name AS emp_emerg_name_18, e0_.emp_emerg_phone AS emp_emerg_phone_19, e0_.emp_emerg_relationship AS emp_emerg_relationship_20, e0_.emp_birthdate AS emp_birthdate_21, e0_.emp_birthplace AS emp_birthplace_22, e0_.emp_ssn AS emp_ssn_23, e0_.emp_race AS emp_race_24, e0_.emp_citizenship_index AS emp_citizenship_index_25, e0_.emp_ethnicity AS emp_ethnicity_26, e0_.emp_email_primary_index AS emp_email_primary_index_27, e0_.emp_spouse_name AS emp_spouse_name_28, e0_.faculty_auto_exempt AS faculty_auto_exempt_29, e0_.bamboo_id AS bamboo_id_30, e0_.npi AS npi_31, e0_.umms_ad_username AS umms_ad_username_32, e0_.emp_email_primary_index AS emp_email_primary_index_33, e0_.emp_citizenship_index AS emp_citizenship_index_34, e0_.emp_gender AS emp_gender_35 FROM employee e0_ WHERE e0_.emp_index = '2202' AND e0_.emp_disable = 0 AND e0_.emp_show_profile = 1;

SELECT
  t0.user_index AS user_index_1,
  t0.emp_index AS emp_index_2,
  t0.username AS username_3,
  t0.ad_guid AS ad_guid_4,
  t0.password_hash AS password_hash_5,
  t0.reset_token AS reset_token_6,
  t0.reset_timestamp AS reset_timestamp_7,
  t0.reset_count AS reset_count_8,
  t0.account_update AS account_update_9,
  t0.activation_token AS activation_token_10,
  t0.activation_timestamp AS activation_timestamp_11,
  t0.activation_count AS activation_count_12,
  t0.invitation_token AS invitation_token_13,
  t0.invitation_timestamp AS invitation_timestamp_14,
  t0.invitation_count AS invitation_count_15,
  t0.timestamp AS timestamp_16,
  t0.roles AS roles_17,
  t0.emp_index AS emp_index_18
FROM
  users t0
WHERE
  t0.emp_index = ?

SELECT t0.user_index AS user_index_1, t0.emp_index AS emp_index_2, t0.username AS username_3, t0.ad_guid AS ad_guid_4, t0.password_hash AS password_hash_5, t0.reset_token AS reset_token_6, t0.reset_timestamp AS reset_timestamp_7, t0.reset_count AS reset_count_8, t0.account_update AS account_update_9, t0.activation_token AS activation_token_10, t0.activation_timestamp AS activation_timestamp_11, t0.activation_count AS activation_count_12, t0.invitation_token AS invitation_token_13, t0.invitation_timestamp AS invitation_timestamp_14, t0.invitation_count AS invitation_count_15, t0.timestamp AS timestamp_16, t0.roles AS roles_17, t0.emp_index AS emp_index_18 FROM users t0 WHERE t0.emp_index = 2202;

SELECT
  t0.emp_title_index AS emp_title_index_1,
  t0.emp_index AS emp_index_2,
  t0.title_type_index AS title_type_index_3,
  t0.title_subtype_index AS title_subtype_index_4,
  t0.emp_title_other AS emp_title_other_5,
  t0.timestamp AS timestamp_6,
  t0.emp_index AS emp_index_7,
  t0.title_type_index AS title_type_index_8,
  t0.title_subtype_index AS title_subtype_index_9
FROM
  emp_title t0
WHERE
  t0.emp_index = ?

SELECT t0.emp_title_index AS emp_title_index_1, t0.emp_index AS emp_index_2, t0.title_type_index AS title_type_index_3, t0.title_subtype_index AS title_subtype_index_4, t0.emp_title_other AS emp_title_other_5, t0.timestamp AS timestamp_6, t0.emp_index AS emp_index_7, t0.title_type_index AS title_type_index_8, t0.title_subtype_index AS title_subtype_index_9 FROM emp_title t0 WHERE t0.emp_index = 2202;

SELECT
  t0.title_subtype_index AS title_subtype_index_1,
  t0.title_type_index AS title_type_index_2,
  t0.title_subtype_name AS title_subtype_name_3,
  t0.title_subtype_sortorder AS title_subtype_sortorder_4,
  t0.title_subtype_icon AS title_subtype_icon_5,
  t0.title_subtype_acronym AS title_subtype_acronym_6,
  t0.title_type_index AS title_type_index_7
FROM
  title_subtype t0
WHERE
  t0.title_subtype_index = ?

SELECT t0.title_subtype_index AS title_subtype_index_1, t0.title_type_index AS title_type_index_2, t0.title_subtype_name AS title_subtype_name_3, t0.title_subtype_sortorder AS title_subtype_sortorder_4, t0.title_subtype_icon AS title_subtype_icon_5, t0.title_subtype_acronym AS title_subtype_acronym_6, t0.title_type_index AS title_type_index_7 FROM title_subtype t0 WHERE t0.title_subtype_index = 2;

SELECT
  t0.emp_prof_assoc_index AS emp_prof_assoc_index_1,
  t0.emp_index AS emp_index_2,
  t0.prof_fellow_assoc_index AS prof_fellow_assoc_index_3,
  t0.emp_prof_assoc_other AS emp_prof_assoc_other_4,
  t0.emp_index AS emp_index_5,
  t0.prof_fellow_assoc_index AS prof_fellow_assoc_index_6
FROM
  emp_prof_assoc t0
WHERE
  t0.emp_index = ?

SELECT t0.emp_prof_assoc_index AS emp_prof_assoc_index_1, t0.emp_index AS emp_index_2, t0.prof_fellow_assoc_index AS prof_fellow_assoc_index_3, t0.emp_prof_assoc_other AS emp_prof_assoc_other_4, t0.emp_index AS emp_index_5, t0.prof_fellow_assoc_index AS prof_fellow_assoc_index_6 FROM emp_prof_assoc t0 WHERE t0.emp_index = 2202;

SELECT
  t0.title_subtype_index AS title_subtype_index_1,
  t0.title_type_index AS title_type_index_2,
  t0.title_subtype_name AS title_subtype_name_3,
  t0.title_subtype_sortorder AS title_subtype_sortorder_4,
  t0.title_subtype_icon AS title_subtype_icon_5,
  t0.title_subtype_acronym AS title_subtype_acronym_6,
  t0.title_type_index AS title_type_index_7
FROM
  title_subtype t0
WHERE
  t0.title_subtype_index = ?

SELECT t0.title_subtype_index AS title_subtype_index_1, t0.title_type_index AS title_type_index_2, t0.title_subtype_name AS title_subtype_name_3, t0.title_subtype_sortorder AS title_subtype_sortorder_4, t0.title_subtype_icon AS title_subtype_icon_5, t0.title_subtype_acronym AS title_subtype_acronym_6, t0.title_type_index AS title_type_index_7 FROM title_subtype t0 WHERE t0.title_subtype_index = 33;

SELECT
  t0.emp_sites_index AS emp_sites_index_1,
  t0.emp_index AS emp_index_2,
  t0.site_index AS site_index_3,
  t0.timestamp AS timestamp_4,
  t0.is_primary AS is_primary_5,
  t0.emp_index AS emp_index_6,
  t0.site_index AS site_index_7
FROM
  emp_sites t0
WHERE
  t0.emp_index = ?

SELECT t0.emp_sites_index AS emp_sites_index_1, t0.emp_index AS emp_index_2, t0.site_index AS site_index_3, t0.timestamp AS timestamp_4, t0.is_primary AS is_primary_5, t0.emp_index AS emp_index_6, t0.site_index AS site_index_7 FROM emp_sites t0 WHERE t0.emp_index = 2202;

SELECT
  t0.site_index AS site_index_1,
  t0.site_name AS site_name_2,
  t0.site_name2 AS site_name2_3,
  t0.site_city AS site_city_4,
  t0.site_state AS site_state_5,
  t0.site_zip AS site_zip_6,
  t0.site_tax_id AS site_tax_id_7,
  t0.site_phone1 AS site_phone1_8,
  t0.site_phone2 AS site_phone2_9,
  t0.site_phone_fax AS site_phone_fax_10,
  t0.site_director_employee AS site_director_employee_11,
  t0.site_admin_employee AS site_admin_employee_12,
  t0.site_sortorder AS site_sortorder_13
FROM
  site t0
WHERE
  t0.site_index = ?

SELECT t0.site_index AS site_index_1, t0.site_name AS site_name_2, t0.site_name2 AS site_name2_3, t0.site_city AS site_city_4, t0.site_state AS site_state_5, t0.site_zip AS site_zip_6, t0.site_tax_id AS site_tax_id_7, t0.site_phone1 AS site_phone1_8, t0.site_phone2 AS site_phone2_9, t0.site_phone_fax AS site_phone_fax_10, t0.site_director_employee AS site_director_employee_11, t0.site_admin_employee AS site_admin_employee_12, t0.site_sortorder AS site_sortorder_13 FROM site t0 WHERE t0.site_index = 3;

SELECT
  t0.emp_board_cert_index AS emp_board_cert_index_1,
  t0.emp_index AS emp_index_2,
  t0.board_cert_index AS board_cert_index_3,
  t0.board_gen_cert_index AS board_gen_cert_index_4,
  t0.board_sec_cert_index AS board_sec_cert_index_5,
  t0.board_cert_status_index AS board_cert_status_index_6,
  t0.board_cert_expire_date AS board_cert_expire_date_7,
  t0.board_cert_last_update AS board_cert_last_update_8,
  t0.timestamp AS timestamp_9,
  t0.emp_index AS emp_index_10,
  t0.board_cert_index AS board_cert_index_11,
  t0.board_cert_status_index AS board_cert_status_index_12
FROM
  emp_board_cert t0
WHERE
  t0.emp_index = ?

SELECT t0.emp_board_cert_index AS emp_board_cert_index_1, t0.emp_index AS emp_index_2, t0.board_cert_index AS board_cert_index_3, t0.board_gen_cert_index AS board_gen_cert_index_4, t0.board_sec_cert_index AS board_sec_cert_index_5, t0.board_cert_status_index AS board_cert_status_index_6, t0.board_cert_expire_date AS board_cert_expire_date_7, t0.board_cert_last_update AS board_cert_last_update_8, t0.timestamp AS timestamp_9, t0.emp_index AS emp_index_10, t0.board_cert_index AS board_cert_index_11, t0.board_cert_status_index AS board_cert_status_index_12 FROM emp_board_cert t0 WHERE t0.emp_index = 2202;

SELECT
  t0.board_cert_index AS board_cert_index_1,
  t0.board_cert_name AS board_cert_name_2,
  t0.board_cert_sortorder AS board_cert_sortorder_3
FROM
  board_certification t0
WHERE
  t0.board_cert_index = ?

SELECT t0.board_cert_index AS board_cert_index_1, t0.board_cert_name AS board_cert_name_2, t0.board_cert_sortorder AS board_cert_sortorder_3 FROM board_certification t0 WHERE t0.board_cert_index = 1;

SELECT
  t0.emp_status_index AS emp_status_index_1,
  t0.emp_index AS emp_index_2,
  t0.status_index AS status_index_3,
  t0.emp_status_created AS emp_status_created_4,
  t0.emp_status_removed AS emp_status_removed_5,
  t0.part_time AS part_time_6,
  t0.emp_index AS emp_index_7,
  t0.status_index AS status_index_8
FROM
  emp_status t0
WHERE
  t0.emp_index = ?

SELECT t0.emp_status_index AS emp_status_index_1, t0.emp_index AS emp_index_2, t0.status_index AS status_index_3, t0.emp_status_created AS emp_status_created_4, t0.emp_status_removed AS emp_status_removed_5, t0.part_time AS part_time_6, t0.emp_index AS emp_index_7, t0.status_index AS status_index_8 FROM emp_status t0 WHERE t0.emp_index = 2202;

SELECT
  t0.status_index AS status_index_1,
  t0.status_parent AS status_parent_2,
  t0.status_codename AS status_codename_3,
  t0.status_name AS status_name_4,
  t0.status_sortorder AS status_sortorder_5,
  t0.status_name2 AS status_name2_6,
  t0.status_color AS status_color_7,
  t0.status_parent AS status_parent_8
FROM
  status t0
WHERE
  t0.status_index = ?

SELECT t0.status_index AS status_index_1, t0.status_parent AS status_parent_2, t0.status_codename AS status_codename_3, t0.status_name AS status_name_4, t0.status_sortorder AS status_sortorder_5, t0.status_name2 AS status_name2_6, t0.status_color AS status_color_7, t0.status_parent AS status_parent_8 FROM status t0 WHERE t0.status_index = 1;

SELECT
  t0.status_index AS status_index_1,
  t0.status_parent AS status_parent_2,
  t0.status_codename AS status_codename_3,
  t0.status_name AS status_name_4,
  t0.status_sortorder AS status_sortorder_5,
  t0.status_name2 AS status_name2_6,
  t0.status_color AS status_color_7,
  t0.status_parent AS status_parent_8
FROM
  status t0
WHERE
  t0.status_index = ?

SELECT t0.status_index AS status_index_1, t0.status_parent AS status_parent_2, t0.status_codename AS status_codename_3, t0.status_name AS status_name_4, t0.status_sortorder AS status_sortorder_5, t0.status_name2 AS status_name2_6, t0.status_color AS status_color_7, t0.status_parent AS status_parent_8 FROM status t0 WHERE t0.status_index = 3;

SELECT
  t0.status_index AS status_index_1,
  t0.status_parent AS status_parent_2,
  t0.status_codename AS status_codename_3,
  t0.status_name AS status_name_4,
  t0.status_sortorder AS status_sortorder_5,
  t0.status_name2 AS status_name2_6,
  t0.status_color AS status_color_7,
  t0.status_parent AS status_parent_8
FROM
  status t0
WHERE
  t0.status_index = ?

SELECT t0.status_index AS status_index_1, t0.status_parent AS status_parent_2, t0.status_codename AS status_codename_3, t0.status_name AS status_name_4, t0.status_sortorder AS status_sortorder_5, t0.status_name2 AS status_name2_6, t0.status_color AS status_color_7, t0.status_parent AS status_parent_8 FROM status t0 WHERE t0.status_index = 21;

SELECT
  t0.edu_index AS edu_index_1,
  t0.emp_index AS emp_index_2,
  t0.edu_start_date AS edu_start_date_3,
  t0.edu_stop_date AS edu_stop_date_4,
  t0.edu_type_index AS edu_type_index_5,
  t0.edu_subtype_index AS edu_subtype_index_6,
  t0.edu_major AS edu_major_7,
  t0.edu_director AS edu_director_8,
  t0.edu_supervisor AS edu_supervisor_9,
  t0.edu_degree_earned AS edu_degree_earned_10,
  t0.edu_degree_date AS edu_degree_date_11,
  t0.degree_index AS degree_index_12,
  t0.edu_chief_resident AS edu_chief_resident_13,
  t0.edu_chief_year AS edu_chief_year_14,
  t0.edu_residency_completed AS edu_residency_completed_15,
  t0.edu_residency_incomplete_reason AS edu_residency_incomplete_reason_16,
  t0.edu_inst_name AS edu_inst_name_17,
  t0.edu_inst_city AS edu_inst_city_18,
  t0.edu_inst_state AS edu_inst_state_19,
  t0.edu_inst_country AS edu_inst_country_20,
  t0.edu_timestamp AS edu_timestamp_21,
  t0.emp_index AS emp_index_22,
  t0.edu_type_index AS edu_type_index_23,
  t0.edu_subtype_index AS edu_subtype_index_24,
  t0.degree_index AS degree_index_25
FROM
  education t0
WHERE
  t0.emp_index = ?

SELECT t0.edu_index AS edu_index_1, t0.emp_index AS emp_index_2, t0.edu_start_date AS edu_start_date_3, t0.edu_stop_date AS edu_stop_date_4, t0.edu_type_index AS edu_type_index_5, t0.edu_subtype_index AS edu_subtype_index_6, t0.edu_major AS edu_major_7, t0.edu_director AS edu_director_8, t0.edu_supervisor AS edu_supervisor_9, t0.edu_degree_earned AS edu_degree_earned_10, t0.edu_degree_date AS edu_degree_date_11, t0.degree_index AS degree_index_12, t0.edu_chief_resident AS edu_chief_resident_13, t0.edu_chief_year AS edu_chief_year_14, t0.edu_residency_completed AS edu_residency_completed_15, t0.edu_residency_incomplete_reason AS edu_residency_incomplete_reason_16, t0.edu_inst_name AS edu_inst_name_17, t0.edu_inst_city AS edu_inst_city_18, t0.edu_inst_state AS edu_inst_state_19, t0.edu_inst_country AS edu_inst_country_20, t0.edu_timestamp AS edu_timestamp_21, t0.emp_index AS emp_index_22, t0.edu_type_index AS edu_type_index_23, t0.edu_subtype_index AS edu_subtype_index_24, t0.degree_index AS degree_index_25 FROM education t0 WHERE t0.emp_index = 2202;

SELECT
  t0.bio_index AS bio_index_1,
  t0.bio_employee_index AS bio_employee_index_2,
  t0.bio_personal_statement AS bio_personal_statement_3,
  t0.bio_research_interests AS bio_research_interests_4,
  t0.bio_can_host AS bio_can_host_5,
  t0.bio_alumni_city AS bio_alumni_city_6,
  t0.bio_alumni_state AS bio_alumni_state_7,
  t0.bio_alumni_location AS bio_alumni_location_8,
  t0.bio_alumni_contact_me AS bio_alumni_contact_me_9,
  t0.bio_alumni_location_type AS bio_alumni_location_type_10,
  t0.bio_alumni_region AS bio_alumni_region_11,
  t0.bio_employee_index AS bio_employee_index_12
FROM
  bio t0
WHERE
  t0.bio_employee_index = ?

SELECT t0.bio_index AS bio_index_1, t0.bio_employee_index AS bio_employee_index_2, t0.bio_personal_statement AS bio_personal_statement_3, t0.bio_research_interests AS bio_research_interests_4, t0.bio_can_host AS bio_can_host_5, t0.bio_alumni_city AS bio_alumni_city_6, t0.bio_alumni_state AS bio_alumni_state_7, t0.bio_alumni_location AS bio_alumni_location_8, t0.bio_alumni_contact_me AS bio_alumni_contact_me_9, t0.bio_alumni_location_type AS bio_alumni_location_type_10, t0.bio_alumni_region AS bio_alumni_region_11, t0.bio_employee_index AS bio_employee_index_12 FROM bio t0 WHERE t0.bio_employee_index = 2202;

SELECT
  t0.pref_index AS pref_index_1,
  t0.pref_user AS pref_user_2,
  t0.pref_txt_fac AS pref_txt_fac_3,
  t0.pref_txt_res AS pref_txt_res_4,
  t0.pref_fac_home_add AS pref_fac_home_add_5,
  t0.pref_fac_home_phone AS pref_fac_home_phone_6,
  t0.pref_fac_mobile AS pref_fac_mobile_7,
  t0.pref_fac_pager AS pref_fac_pager_8,
  t0.pref_res_home_add AS pref_res_home_add_9,
  t0.pref_res_home_phone AS pref_res_home_phone_10,
  t0.pref_res_mobile AS pref_res_mobile_11,
  t0.pref_res_pager AS pref_res_pager_12,
  t0.pref_host_applicants AS pref_host_applicants_13,
  t0.pref_default_cp_home AS pref_default_cp_home_14,
  t0.pref_txt_mobile AS pref_txt_mobile_15,
  t0.pref_txt_pager AS pref_txt_pager_16,
  t0.pref_txt_email AS pref_txt_email_17,
  t0.pref_alum_home_add AS pref_alum_home_add_18,
  t0.pref_alum_home_phone AS pref_alum_home_phone_19,
  t0.pref_alum_mobile AS pref_alum_mobile_20,
  t0.pref_alum_pager AS pref_alum_pager_21,
  t0.pref_txt_alum AS pref_txt_alum_22,
  t0.pref_txt_cc AS pref_txt_cc_23,
  t0.pref_show_lectures AS pref_show_lectures_24,
  t0.pref_show_grandrounds AS pref_show_grandrounds_25,
  t0.pref_fac_email AS pref_fac_email_26,
  t0.pref_res_email AS pref_res_email_27,
  t0.pref_alum_email AS pref_alum_email_28,
  t0.pref_allow_solicit AS pref_allow_solicit_29,
  t0.pref_txt_student AS pref_txt_student_30,
  t0.pref_txt_network AS pref_txt_network_31,
  t0.pref_txt_guest AS pref_txt_guest_32,
  t0.pref_network_home_add AS pref_network_home_add_33,
  t0.pref_network_home_phone AS pref_network_home_phone_34,
  t0.pref_network_mobile AS pref_network_mobile_35,
  t0.pref_network_pager AS pref_network_pager_36,
  t0.pref_network_email AS pref_network_email_37,
  t0.pref_guest_home_add AS pref_guest_home_add_38,
  t0.pref_guest_home_phone AS pref_guest_home_phone_39,
  t0.pref_guest_mobile AS pref_guest_mobile_40,
  t0.pref_guest_pager AS pref_guest_pager_41,
  t0.pref_guest_email AS pref_guest_email_42,
  t0.pref_conf_notification AS pref_conf_notification_43,
  t0.pref_email_reminder_decline AS pref_email_reminder_decline_44,
  t0.pref_enable_relay_message AS pref_enable_relay_message_45,
  t0.pref_user AS pref_user_46
FROM
  pref t0
WHERE
  t0.pref_user = ?

SELECT t0.pref_index AS pref_index_1, t0.pref_user AS pref_user_2, t0.pref_txt_fac AS pref_txt_fac_3, t0.pref_txt_res AS pref_txt_res_4, t0.pref_fac_home_add AS pref_fac_home_add_5, t0.pref_fac_home_phone AS pref_fac_home_phone_6, t0.pref_fac_mobile AS pref_fac_mobile_7, t0.pref_fac_pager AS pref_fac_pager_8, t0.pref_res_home_add AS pref_res_home_add_9, t0.pref_res_home_phone AS pref_res_home_phone_10, t0.pref_res_mobile AS pref_res_mobile_11, t0.pref_res_pager AS pref_res_pager_12, t0.pref_host_applicants AS pref_host_applicants_13, t0.pref_default_cp_home AS pref_default_cp_home_14, t0.pref_txt_mobile AS pref_txt_mobile_15, t0.pref_txt_pager AS pref_txt_pager_16, t0.pref_txt_email AS pref_txt_email_17, t0.pref_alum_home_add AS pref_alum_home_add_18, t0.pref_alum_home_phone AS pref_alum_home_phone_19, t0.pref_alum_mobile AS pref_alum_mobile_20, t0.pref_alum_pager AS pref_alum_pager_21, t0.pref_txt_alum AS pref_txt_alum_22, t0.pref_txt_cc AS pref_txt_cc_23, t0.pref_show_lectures AS pref_show_lectures_24, t0.pref_show_grandrounds AS pref_show_grandrounds_25, t0.pref_fac_email AS pref_fac_email_26, t0.pref_res_email AS pref_res_email_27, t0.pref_alum_email AS pref_alum_email_28, t0.pref_allow_solicit AS pref_allow_solicit_29, t0.pref_txt_student AS pref_txt_student_30, t0.pref_txt_network AS pref_txt_network_31, t0.pref_txt_guest AS pref_txt_guest_32, t0.pref_network_home_add AS pref_network_home_add_33, t0.pref_network_home_phone AS pref_network_home_phone_34, t0.pref_network_mobile AS pref_network_mobile_35, t0.pref_network_pager AS pref_network_pager_36, t0.pref_network_email AS pref_network_email_37, t0.pref_guest_home_add AS pref_guest_home_add_38, t0.pref_guest_home_phone AS pref_guest_home_phone_39, t0.pref_guest_mobile AS pref_guest_mobile_40, t0.pref_guest_pager AS pref_guest_pager_41, t0.pref_guest_email AS pref_guest_email_42, t0.pref_conf_notification AS pref_conf_notification_43, t0.pref_email_reminder_decline AS pref_email_reminder_decline_44, t0.pref_enable_relay_message AS pref_enable_relay_message_45, t0.pref_user AS pref_user_46 FROM pref t0 WHERE t0.pref_user = 2202;

SELECT
  t0.emp_photo_index AS emp_photo_index_1,
  t0.emp_photo_employee AS emp_photo_employee_2,
  t0.emp_photo_name AS emp_photo_name_3,
  t0.timestamp AS timestamp_4,
  t0.emp_photo_employee AS emp_photo_employee_5
FROM
  emp_photo t0
WHERE
  t0.emp_photo_employee = ?

SELECT t0.emp_photo_index AS emp_photo_index_1, t0.emp_photo_employee AS emp_photo_employee_2, t0.emp_photo_name AS emp_photo_name_3, t0.timestamp AS timestamp_4, t0.emp_photo_employee AS emp_photo_employee_5 FROM emp_photo t0 WHERE t0.emp_photo_employee = 2202;