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,
  e1_.emp_photo_index AS emp_photo_index_33,
  e1_.emp_photo_employee AS emp_photo_employee_34,
  e1_.emp_photo_name AS emp_photo_name_35,
  e1_.timestamp AS timestamp_36,
  e2_.emp_title_index AS emp_title_index_37,
  e2_.emp_index AS emp_index_38,
  e2_.title_type_index AS title_type_index_39,
  e2_.title_subtype_index AS title_subtype_index_40,
  e2_.emp_title_other AS emp_title_other_41,
  e2_.timestamp AS timestamp_42,
  e3_.edu_index AS edu_index_43,
  e3_.emp_index AS emp_index_44,
  e3_.edu_start_date AS edu_start_date_45,
  e3_.edu_stop_date AS edu_stop_date_46,
  e3_.edu_type_index AS edu_type_index_47,
  e3_.edu_subtype_index AS edu_subtype_index_48,
  e3_.edu_major AS edu_major_49,
  e3_.edu_director AS edu_director_50,
  e3_.edu_supervisor AS edu_supervisor_51,
  e3_.edu_degree_earned AS edu_degree_earned_52,
  e3_.edu_degree_date AS edu_degree_date_53,
  e3_.degree_index AS degree_index_54,
  e3_.edu_chief_resident AS edu_chief_resident_55,
  e3_.edu_chief_year AS edu_chief_year_56,
  e3_.edu_residency_completed AS edu_residency_completed_57,
  e3_.edu_residency_incomplete_reason AS edu_residency_incomplete_reason_58,
  e3_.edu_inst_name AS edu_inst_name_59,
  e3_.edu_inst_city AS edu_inst_city_60,
  e3_.edu_inst_state AS edu_inst_state_61,
  e3_.edu_inst_country AS edu_inst_country_62,
  e3_.edu_timestamp AS edu_timestamp_63,
  e4_.edu_subtype_index AS edu_subtype_index_64,
  e4_.edu_type_index AS edu_type_index_65,
  e4_.edu_subtype_name AS edu_subtype_name_66,
  e4_.edu_subtype_sortorder AS edu_subtype_sortorder_67,
  e0_.emp_email_primary_index AS emp_email_primary_index_68,
  e0_.emp_citizenship_index AS emp_citizenship_index_69,
  e0_.emp_gender AS emp_gender_70,
  e1_.emp_photo_employee AS emp_photo_employee_71,
  e2_.emp_index AS emp_index_72,
  e2_.title_type_index AS title_type_index_73,
  e2_.title_subtype_index AS title_subtype_index_74,
  e3_.emp_index AS emp_index_75,
  e3_.edu_type_index AS edu_type_index_76,
  e3_.edu_subtype_index AS edu_subtype_index_77,
  e3_.degree_index AS degree_index_78,
  e4_.edu_type_index AS edu_type_index_79
FROM
  employee e0_
  INNER JOIN emp_status e5_ ON e0_.emp_index = e5_.emp_index
  LEFT JOIN emp_photo e1_ ON e0_.emp_index = e1_.emp_photo_employee
  LEFT JOIN emp_title e2_ ON e0_.emp_index = e2_.emp_index
  LEFT JOIN education e3_ ON e0_.emp_index = e3_.emp_index
  LEFT JOIN edu_subtype e4_ ON e3_.edu_subtype_index = e4_.edu_subtype_index
WHERE
  e5_.status_index IN (?)
  AND e0_.emp_show_profile = 1
  AND e0_.emp_disable = 0
  AND (
    CURRENT_TIMESTAMP < e5_.emp_status_removed
    OR e5_.emp_status_removed IS NULL
  )
  AND (
    CURRENT_TIMESTAMP > e5_.emp_status_created
  )
ORDER BY
  e0_.emp_lastname ASC,
  e0_.emp_firstname ASC

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, e1_.emp_photo_index AS emp_photo_index_33, e1_.emp_photo_employee AS emp_photo_employee_34, e1_.emp_photo_name AS emp_photo_name_35, e1_.timestamp AS timestamp_36, e2_.emp_title_index AS emp_title_index_37, e2_.emp_index AS emp_index_38, e2_.title_type_index AS title_type_index_39, e2_.title_subtype_index AS title_subtype_index_40, e2_.emp_title_other AS emp_title_other_41, e2_.timestamp AS timestamp_42, e3_.edu_index AS edu_index_43, e3_.emp_index AS emp_index_44, e3_.edu_start_date AS edu_start_date_45, e3_.edu_stop_date AS edu_stop_date_46, e3_.edu_type_index AS edu_type_index_47, e3_.edu_subtype_index AS edu_subtype_index_48, e3_.edu_major AS edu_major_49, e3_.edu_director AS edu_director_50, e3_.edu_supervisor AS edu_supervisor_51, e3_.edu_degree_earned AS edu_degree_earned_52, e3_.edu_degree_date AS edu_degree_date_53, e3_.degree_index AS degree_index_54, e3_.edu_chief_resident AS edu_chief_resident_55, e3_.edu_chief_year AS edu_chief_year_56, e3_.edu_residency_completed AS edu_residency_completed_57, e3_.edu_residency_incomplete_reason AS edu_residency_incomplete_reason_58, e3_.edu_inst_name AS edu_inst_name_59, e3_.edu_inst_city AS edu_inst_city_60, e3_.edu_inst_state AS edu_inst_state_61, e3_.edu_inst_country AS edu_inst_country_62, e3_.edu_timestamp AS edu_timestamp_63, e4_.edu_subtype_index AS edu_subtype_index_64, e4_.edu_type_index AS edu_type_index_65, e4_.edu_subtype_name AS edu_subtype_name_66, e4_.edu_subtype_sortorder AS edu_subtype_sortorder_67, e0_.emp_email_primary_index AS emp_email_primary_index_68, e0_.emp_citizenship_index AS emp_citizenship_index_69, e0_.emp_gender AS emp_gender_70, e1_.emp_photo_employee AS emp_photo_employee_71, e2_.emp_index AS emp_index_72, e2_.title_type_index AS title_type_index_73, e2_.title_subtype_index AS title_subtype_index_74, e3_.emp_index AS emp_index_75, e3_.edu_type_index AS edu_type_index_76, e3_.edu_subtype_index AS edu_subtype_index_77, e3_.degree_index AS degree_index_78, e4_.edu_type_index AS edu_type_index_79 FROM employee e0_ INNER JOIN emp_status e5_ ON e0_.emp_index = e5_.emp_index LEFT JOIN emp_photo e1_ ON e0_.emp_index = e1_.emp_photo_employee LEFT JOIN emp_title e2_ ON e0_.emp_index = e2_.emp_index LEFT JOIN education e3_ ON e0_.emp_index = e3_.emp_index LEFT JOIN edu_subtype e4_ ON e3_.edu_subtype_index = e4_.edu_subtype_index WHERE e5_.status_index IN (2) AND e0_.emp_show_profile = 1 AND e0_.emp_disable = 0 AND (CURRENT_TIMESTAMP < e5_.emp_status_removed OR e5_.emp_status_removed IS NULL) AND (CURRENT_TIMESTAMP > e5_.emp_status_created) ORDER BY e0_.emp_lastname ASC, e0_.emp_firstname ASC;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 = ?