Symfony Profiler

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.sort_order AS sort_order_2,
  r0_.created AS created_3,
  r0_.created_by AS created_by_4,
  r0_.updated AS updated_5,
  r0_.updated_by AS updated_by_6
FROM
  research_status r0_
ORDER BY
  r0_.id ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.sort_order AS sort_order_2, r0_.created AS created_3, r0_.created_by AS created_by_4, r0_.updated AS updated_5, r0_.updated_by AS updated_by_6 FROM research_status r0_ ORDER BY r0_.id ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.title AS title_1,
          r0_.sponsor AS sponsor_2,
          r0_.clinical_trials_id AS clinical_trials_id_3,
          r0_.start_date AS start_date_4,
          r0_.end_date AS end_date_5,
          r0_.help_needed AS help_needed_6,
          r0_.summary_description AS summary_description_7,
          r0_.full_description AS full_description_8,
          r0_.keywords AS keywords_9,
          r0_.created AS created_10,
          r0_.created_by AS created_by_11,
          r0_.updated AS updated_12,
          r0_.updated_by AS updated_by_13
        FROM
          research_study r0_
        ORDER BY
          r0_.end_date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.sponsor AS sponsor_2, r0_.clinical_trials_id AS clinical_trials_id_3, r0_.start_date AS start_date_4, r0_.end_date AS end_date_5, r0_.help_needed AS help_needed_6, r0_.summary_description AS summary_description_7, r0_.full_description AS full_description_8, r0_.keywords AS keywords_9, r0_.created AS created_10, r0_.created_by AS created_by_11, r0_.updated AS updated_12, r0_.updated_by AS updated_by_13 FROM research_study r0_ ORDER BY r0_.end_date DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      end_date_5
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.title AS title_1,
          r0_.sponsor AS sponsor_2,
          r0_.clinical_trials_id AS clinical_trials_id_3,
          r0_.start_date AS start_date_4,
          r0_.end_date AS end_date_5,
          r0_.help_needed AS help_needed_6,
          r0_.summary_description AS summary_description_7,
          r0_.full_description AS full_description_8,
          r0_.keywords AS keywords_9,
          r0_.created AS created_10,
          r0_.created_by AS created_by_11,
          r0_.updated AS updated_12,
          r0_.updated_by AS updated_by_13
        FROM
          research_study r0_
      ) dctrn_result_inner
    ORDER BY
      end_date_5 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, end_date_5 FROM (SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.sponsor AS sponsor_2, r0_.clinical_trials_id AS clinical_trials_id_3, r0_.start_date AS start_date_4, r0_.end_date AS end_date_5, r0_.help_needed AS help_needed_6, r0_.summary_description AS summary_description_7, r0_.full_description AS full_description_8, r0_.keywords AS keywords_9, r0_.created AS created_10, r0_.created_by AS created_by_11, r0_.updated AS updated_12, r0_.updated_by AS updated_by_13 FROM research_study r0_) dctrn_result_inner ORDER BY end_date_5 DESC) dctrn_result LIMIT 20;

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.sponsor AS sponsor_2,
  r0_.clinical_trials_id AS clinical_trials_id_3,
  r0_.start_date AS start_date_4,
  r0_.end_date AS end_date_5,
  r0_.help_needed AS help_needed_6,
  r0_.summary_description AS summary_description_7,
  r0_.full_description AS full_description_8,
  r0_.keywords AS keywords_9,
  r0_.created AS created_10,
  r0_.created_by AS created_by_11,
  r0_.updated AS updated_12,
  r0_.updated_by AS updated_by_13,
  r0_.status AS status_14
FROM
  research_study r0_
WHERE
  r0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  r0_.end_date DESC

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.sponsor AS sponsor_2, r0_.clinical_trials_id AS clinical_trials_id_3, r0_.start_date AS start_date_4, r0_.end_date AS end_date_5, r0_.help_needed AS help_needed_6, r0_.summary_description AS summary_description_7, r0_.full_description AS full_description_8, r0_.keywords AS keywords_9, r0_.created AS created_10, r0_.created_by AS created_by_11, r0_.updated AS updated_12, r0_.updated_by AS updated_by_13, r0_.status AS status_14 FROM research_study r0_ WHERE r0_.id IN (18, 15, 20, 21, 22) ORDER BY r0_.end_date DESC;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.emp_index AS emp_index_6,
  t0.research_study AS research_study_7
FROM
  principal_investigator t0
WHERE
  t0.research_study = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.emp_index AS emp_index_6, t0.research_study AS research_study_7 FROM principal_investigator t0 WHERE t0.research_study = 18;

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

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

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.emp_index AS emp_index_6,
  t0.research_study AS research_study_7
FROM
  investigator t0
WHERE
  t0.research_study = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.emp_index AS emp_index_6, t0.research_study AS research_study_7 FROM investigator t0 WHERE t0.research_study = 18;

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

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

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.emp_index AS emp_index_6,
  t0.research_study AS research_study_7
FROM
  principal_investigator t0
WHERE
  t0.research_study = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.emp_index AS emp_index_6, t0.research_study AS research_study_7 FROM principal_investigator t0 WHERE t0.research_study = 15;

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

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

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.emp_index AS emp_index_6,
  t0.research_study AS research_study_7
FROM
  investigator t0
WHERE
  t0.research_study = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.emp_index AS emp_index_6, t0.research_study AS research_study_7 FROM investigator t0 WHERE t0.research_study = 15;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.emp_index AS emp_index_6,
  t0.research_study AS research_study_7
FROM
  principal_investigator t0
WHERE
  t0.research_study = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.emp_index AS emp_index_6, t0.research_study AS research_study_7 FROM principal_investigator t0 WHERE t0.research_study = 20;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.emp_index AS emp_index_6,
  t0.research_study AS research_study_7
FROM
  investigator t0
WHERE
  t0.research_study = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.emp_index AS emp_index_6, t0.research_study AS research_study_7 FROM investigator t0 WHERE t0.research_study = 20;

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

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

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.emp_index AS emp_index_6,
  t0.research_study AS research_study_7
FROM
  principal_investigator t0
WHERE
  t0.research_study = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.emp_index AS emp_index_6, t0.research_study AS research_study_7 FROM principal_investigator t0 WHERE t0.research_study = 21;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.emp_index AS emp_index_6,
  t0.research_study AS research_study_7
FROM
  investigator t0
WHERE
  t0.research_study = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.emp_index AS emp_index_6, t0.research_study AS research_study_7 FROM investigator t0 WHERE t0.research_study = 21;

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