Symfony Profiler

SELECT
  t0.emp_index AS emp_index_1,
  t0.emp_lastname AS emp_lastname_2,
  t0.emp_firstname AS emp_firstname_3,
  t0.emp_middlename AS emp_middlename_4,
  t0.emp_gender AS emp_gender_5,
  t0.emp_start_date AS emp_start_date_6,
  t0.emp_suffix AS emp_suffix_7,
  t0.emp_timestamp_initial AS emp_timestamp_initial_8,
  t0.emp_timestamp_update AS emp_timestamp_update_9,
  t0.emp_ftpt AS emp_ftpt_10,
  t0.emp_show_profile AS emp_show_profile_11,
  t0.emp_disable AS emp_disable_12,
  t0.emp_grad_residency AS emp_grad_residency_13,
  t0.emp_profile_update_flag AS emp_profile_update_flag_14,
  t0.emp_chief AS emp_chief_15,
  t0.emp_program_director AS emp_program_director_16,
  t0.emp_network_provider AS emp_network_provider_17,
  t0.emp_pending_forms AS emp_pending_forms_18,
  t0.emp_emerg_name AS emp_emerg_name_19,
  t0.emp_emerg_phone AS emp_emerg_phone_20,
  t0.emp_emerg_relationship AS emp_emerg_relationship_21,
  t0.emp_birthdate AS emp_birthdate_22,
  t0.emp_birthplace AS emp_birthplace_23,
  t0.emp_ssn AS emp_ssn_24,
  t0.emp_race AS emp_race_25,
  t0.emp_citizenship_index AS emp_citizenship_index_26,
  t0.emp_ethnicity AS emp_ethnicity_27,
  t0.emp_email_primary_index AS emp_email_primary_index_28,
  t0.emp_spouse_name AS emp_spouse_name_29,
  t0.faculty_auto_exempt AS faculty_auto_exempt_30,
  t0.bamboo_id AS bamboo_id_31,
  t0.npi AS npi_32,
  t0.umms_ad_username AS umms_ad_username_33,
  t34.user_index AS user_index_35,
  t34.emp_index AS emp_index_36,
  t34.username AS username_37,
  t34.ad_guid AS ad_guid_38,
  t34.password_hash AS password_hash_39,
  t34.reset_token AS reset_token_40,
  t34.reset_timestamp AS reset_timestamp_41,
  t34.reset_count AS reset_count_42,
  t34.account_update AS account_update_43,
  t34.activation_token AS activation_token_44,
  t34.activation_timestamp AS activation_timestamp_45,
  t34.activation_count AS activation_count_46,
  t34.invitation_token AS invitation_token_47,
  t34.invitation_timestamp AS invitation_timestamp_48,
  t34.invitation_count AS invitation_count_49,
  t34.timestamp AS timestamp_50,
  t34.roles AS roles_51,
  t34.emp_index AS emp_index_52,
  t0.emp_email_primary_index AS emp_email_primary_index_53,
  t0.emp_citizenship_index AS emp_citizenship_index_54,
  t0.emp_gender AS emp_gender_55
FROM
  employee t0
  LEFT JOIN users t34 ON t34.emp_index = t0.emp_index
WHERE
  t0.emp_index = ?
LIMIT
  1

SELECT t0.emp_index AS emp_index_1, t0.emp_lastname AS emp_lastname_2, t0.emp_firstname AS emp_firstname_3, t0.emp_middlename AS emp_middlename_4, t0.emp_gender AS emp_gender_5, t0.emp_start_date AS emp_start_date_6, t0.emp_suffix AS emp_suffix_7, t0.emp_timestamp_initial AS emp_timestamp_initial_8, t0.emp_timestamp_update AS emp_timestamp_update_9, t0.emp_ftpt AS emp_ftpt_10, t0.emp_show_profile AS emp_show_profile_11, t0.emp_disable AS emp_disable_12, t0.emp_grad_residency AS emp_grad_residency_13, t0.emp_profile_update_flag AS emp_profile_update_flag_14, t0.emp_chief AS emp_chief_15, t0.emp_program_director AS emp_program_director_16, t0.emp_network_provider AS emp_network_provider_17, t0.emp_pending_forms AS emp_pending_forms_18, t0.emp_emerg_name AS emp_emerg_name_19, t0.emp_emerg_phone AS emp_emerg_phone_20, t0.emp_emerg_relationship AS emp_emerg_relationship_21, t0.emp_birthdate AS emp_birthdate_22, t0.emp_birthplace AS emp_birthplace_23, t0.emp_ssn AS emp_ssn_24, t0.emp_race AS emp_race_25, t0.emp_citizenship_index AS emp_citizenship_index_26, t0.emp_ethnicity AS emp_ethnicity_27, t0.emp_email_primary_index AS emp_email_primary_index_28, t0.emp_spouse_name AS emp_spouse_name_29, t0.faculty_auto_exempt AS faculty_auto_exempt_30, t0.bamboo_id AS bamboo_id_31, t0.npi AS npi_32, t0.umms_ad_username AS umms_ad_username_33, t34.user_index AS user_index_35, t34.emp_index AS emp_index_36, t34.username AS username_37, t34.ad_guid AS ad_guid_38, t34.password_hash AS password_hash_39, t34.reset_token AS reset_token_40, t34.reset_timestamp AS reset_timestamp_41, t34.reset_count AS reset_count_42, t34.account_update AS account_update_43, t34.activation_token AS activation_token_44, t34.activation_timestamp AS activation_timestamp_45, t34.activation_count AS activation_count_46, t34.invitation_token AS invitation_token_47, t34.invitation_timestamp AS invitation_timestamp_48, t34.invitation_count AS invitation_count_49, t34.timestamp AS timestamp_50, t34.roles AS roles_51, t34.emp_index AS emp_index_52, t0.emp_email_primary_index AS emp_email_primary_index_53, t0.emp_citizenship_index AS emp_citizenship_index_54, t0.emp_gender AS emp_gender_55 FROM employee t0 LEFT JOIN users t34 ON t34.emp_index = t0.emp_index WHERE t0.emp_index = '314' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT pearl_index_0
    FROM
      (
        SELECT
          p0_.pearl_index AS pearl_index_0,
          p0_.pearl_title AS pearl_title_1,
          p0_.pearl_author AS pearl_author_2,
          p0_.pearl_category AS pearl_category_3,
          p0_.pearl_audience AS pearl_audience_4,
          p0_.pearl_message AS pearl_message_5,
          p0_.pearl_timestamp AS pearl_timestamp_6,
          p0_.pearl_emailed AS pearl_emailed_7,
          p0_.pearl_keywords AS pearl_keywords_8,
          p0_.pearl_reference AS pearl_reference_9,
          p0_.pearl_active AS pearl_active_10,
          p0_.pearl_updated AS pearl_updated_11,
          p0_.pearl_preview AS pearl_preview_12,
          p0_.pearl_visualdiagnosis_flag AS pearl_visualdiagnosis_flag_13,
          p0_.pearl_visualdiagnosis_text AS pearl_visualdiagnosis_text_14,
          p0_.format AS format_15,
          p1_.pearl_file_index AS pearl_file_index_16,
          p1_.pearl_message_index AS pearl_message_index_17,
          p1_.pearl_file_title AS pearl_file_title_18,
          p1_.pearl_file_type AS pearl_file_type_19,
          p1_.pearl_file_size AS pearl_file_size_20,
          p1_.pearl_file_timestamp AS pearl_file_timestamp_21,
          p1_.pearl_file_location AS pearl_file_location_22,
          p1_.pearl_file_audience AS pearl_file_audience_23
        FROM
          pearl p0_
          LEFT JOIN pearl_file p1_ ON p0_.pearl_index = p1_.pearl_message_index
        WHERE
          p0_.pearl_active = 1
          AND p0_.pearl_author = ?
        ORDER BY
          p0_.pearl_emailed DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT pearl_index_0 FROM (SELECT p0_.pearl_index AS pearl_index_0, p0_.pearl_title AS pearl_title_1, p0_.pearl_author AS pearl_author_2, p0_.pearl_category AS pearl_category_3, p0_.pearl_audience AS pearl_audience_4, p0_.pearl_message AS pearl_message_5, p0_.pearl_timestamp AS pearl_timestamp_6, p0_.pearl_emailed AS pearl_emailed_7, p0_.pearl_keywords AS pearl_keywords_8, p0_.pearl_reference AS pearl_reference_9, p0_.pearl_active AS pearl_active_10, p0_.pearl_updated AS pearl_updated_11, p0_.pearl_preview AS pearl_preview_12, p0_.pearl_visualdiagnosis_flag AS pearl_visualdiagnosis_flag_13, p0_.pearl_visualdiagnosis_text AS pearl_visualdiagnosis_text_14, p0_.format AS format_15, p1_.pearl_file_index AS pearl_file_index_16, p1_.pearl_message_index AS pearl_message_index_17, p1_.pearl_file_title AS pearl_file_title_18, p1_.pearl_file_type AS pearl_file_type_19, p1_.pearl_file_size AS pearl_file_size_20, p1_.pearl_file_timestamp AS pearl_file_timestamp_21, p1_.pearl_file_location AS pearl_file_location_22, p1_.pearl_file_audience AS pearl_file_audience_23 FROM pearl p0_ LEFT JOIN pearl_file p1_ ON p0_.pearl_index = p1_.pearl_message_index WHERE p0_.pearl_active = 1 AND p0_.pearl_author = '314' ORDER BY p0_.pearl_emailed DESC) dctrn_result) dctrn_table;

SELECT
  p0_.pearl_category_index AS pearl_category_index_0,
  p0_.pearl_category_name AS pearl_category_name_1
FROM
  pearl_category p0_
ORDER BY
  p0_.pearl_category_name ASC

SELECT p0_.pearl_category_index AS pearl_category_index_0, p0_.pearl_category_name AS pearl_category_name_1 FROM pearl_category p0_ ORDER BY p0_.pearl_category_name 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,
  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_
  INNER JOIN pearl p1_ ON e0_.emp_index = p1_.pearl_author
WHERE
  p1_.pearl_index IS NOT NULL
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, 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_ INNER JOIN pearl p1_ ON e0_.emp_index = p1_.pearl_author WHERE p1_.pearl_index IS NOT NULL 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 = 366;

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

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

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

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

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

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

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

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

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

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

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

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

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