Redirect 301 redirect from GET @profiles_staff (91aa45)

GET https://stg.umem.org/profiles/staff/

Query Metrics

100 Database Queries
6 Different statements
29.16 ms Query time
1 Invalid entities

Queries

Group similar statements

umem connection

# Time Info
1 6.54 ms
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_status_index AS emp_status_index_33, e1_.emp_index AS emp_index_34, e1_.status_index AS status_index_35, e1_.emp_status_created AS emp_status_created_36, e1_.emp_status_removed AS emp_status_removed_37, e1_.part_time AS part_time_38, e2_.emp_photo_index AS emp_photo_index_39, e2_.emp_photo_employee AS emp_photo_employee_40, e2_.emp_photo_name AS emp_photo_name_41, e2_.timestamp AS timestamp_42, e0_.emp_email_primary_index AS emp_email_primary_index_43, e0_.emp_citizenship_index AS emp_citizenship_index_44, e0_.emp_gender AS emp_gender_45, e1_.emp_index AS emp_index_46, e1_.status_index AS status_index_47, e2_.emp_photo_employee AS emp_photo_employee_48 FROM employee e0_ INNER JOIN emp_status e1_ ON e0_.emp_index = e1_.emp_index INNER JOIN emp_photo e2_ ON e0_.emp_index = e2_.emp_photo_employee LEFT JOIN emp_sites e3_ ON e0_.emp_index = e3_.emp_index WHERE e1_.status_index IN (?) AND e0_.emp_show_profile = 1 AND e0_.emp_disable = 0 AND (CURRENT_TIMESTAMP < e1_.emp_status_removed OR e1_.emp_status_removed IS NULL) AND (CURRENT_TIMESTAMP > e1_.emp_status_created) AND e3_.site_index IN (?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.emp_lastname ASC, e0_.emp_firstname ASC
Parameters:
[
  4
  1
  2
  3
  4
  5
  10
  23
]
2 0.38 ms
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 = ?
Parameters:
[
  1051
]
3 0.33 ms
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 = ?
Parameters:
[
  2870
]
4 0.26 ms
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 = ?
Parameters:
[
  2972
]
5 0.24 ms
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 = ?
Parameters:
[
  146
]
6 0.22 ms
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 = ?
Parameters:
[
  1671
]
7 0.23 ms
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 = ?
Parameters:
[
  3289
]
8 0.21 ms
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 = ?
Parameters:
[
  2186
]
9 0.20 ms
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 = ?
Parameters:
[
  2569
]
10 0.20 ms
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 = ?
Parameters:
[
  3102
]
11 0.19 ms
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 = ?
Parameters:
[
  3252
]
12 0.22 ms
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 = ?
Parameters:
[
  2432
]
13 0.20 ms
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 = ?
Parameters:
[
  724
]
14 0.19 ms
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 = ?
Parameters:
[
  2622
]
15 0.21 ms
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 = ?
Parameters:
[
  2866
]
16 0.20 ms
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 = ?
Parameters:
[
  871
]
17 0.19 ms
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 = ?
Parameters:
[
  3253
]
18 0.18 ms
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 = ?
Parameters:
[
  1873
]
19 0.21 ms
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 = ?
Parameters:
[
  2642
]
20 0.22 ms
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 = ?
Parameters:
[
  2262
]
21 0.19 ms
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 = ?
Parameters:
[
  3254
]
22 0.20 ms
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 = ?
Parameters:
[
  3233
]
23 0.21 ms
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 = ?
Parameters:
[
  2641
]
24 0.20 ms
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 = ?
Parameters:
[
  2105
]
25 0.21 ms
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 = ?
Parameters:
[
  1660
]
26 0.34 ms
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 = ?
Parameters:
[
  1051
]
27 0.35 ms
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 = ?
Parameters:
[
  1051
]
28 0.31 ms
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 = ?
Parameters:
[
  1051
]
29 0.23 ms
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 = ?
Parameters:
[
  2870
]
30 0.24 ms
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 = ?
Parameters:
[
  2870
]
31 0.25 ms
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 = ?
Parameters:
[
  2870
]
32 0.22 ms
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 = ?
Parameters:
[
  2972
]
33 0.23 ms
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 = ?
Parameters:
[
  2972
]
34 0.22 ms
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 = ?
Parameters:
[
  2972
]
35 0.26 ms
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 = ?
Parameters:
[
  146
]
36 0.25 ms
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 = ?
Parameters:
[
  146
]
37 0.23 ms
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 = ?
Parameters:
[
  146
]
38 0.21 ms
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 = ?
Parameters:
[
  1671
]
39 0.22 ms
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 = ?
Parameters:
[
  1671
]
40 0.21 ms
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 = ?
Parameters:
[
  1671
]
41 0.22 ms
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 = ?
Parameters:
[
  3289
]
42 0.21 ms
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 = ?
Parameters:
[
  3289
]
43 0.22 ms
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 = ?
Parameters:
[
  3289
]
44 0.19 ms
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 = ?
Parameters:
[
  2186
]
45 0.20 ms
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 = ?
Parameters:
[
  2186
]
46 0.24 ms
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 = ?
Parameters:
[
  2186
]
47 0.25 ms
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 = ?
Parameters:
[
  2569
]
48 0.23 ms
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 = ?
Parameters:
[
  2569
]
49 0.23 ms
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 = ?
Parameters:
[
  2569
]
50 0.19 ms
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 = ?
Parameters:
[
  3102
]
51 0.29 ms
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 = ?
Parameters:
[
  12
]
52 0.26 ms
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 = ?
Parameters:
[
  3102
]
53 0.26 ms
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 = ?
Parameters:
[
  3102
]
54 0.30 ms
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 = ?
Parameters:
[
  3252
]
55 0.25 ms
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 = ?
Parameters:
[
  3252
]
56 0.26 ms
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 = ?
Parameters:
[
  3252
]
57 0.26 ms
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 = ?
Parameters:
[
  2432
]
58 0.22 ms
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 = ?
Parameters:
[
  2432
]
59 0.22 ms
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 = ?
Parameters:
[
  2432
]
60 0.25 ms
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 = ?
Parameters:
[
  724
]
61 0.25 ms
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 = ?
Parameters:
[
  724
]
62 0.25 ms
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 = ?
Parameters:
[
  724
]
63 0.21 ms
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 = ?
Parameters:
[
  2622
]
64 0.22 ms
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 = ?
Parameters:
[
  2622
]
65 0.24 ms
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 = ?
Parameters:
[
  2622
]
66 0.19 ms
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 = ?
Parameters:
[
  2866
]
67 0.21 ms
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 = ?
Parameters:
[
  2866
]
68 0.24 ms
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 = ?
Parameters:
[
  2866
]
69 0.22 ms
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 = ?
Parameters:
[
  871
]
70 0.21 ms
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 = ?
Parameters:
[
  871
]
71 0.28 ms
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 = ?
Parameters:
[
  871
]
72 0.23 ms
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 = ?
Parameters:
[
  3253
]
73 0.18 ms
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 = ?
Parameters:
[
  8
]
74 0.23 ms
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 = ?
Parameters:
[
  3253
]
75 0.23 ms
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 = ?
Parameters:
[
  3253
]
76 0.22 ms
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 = ?
Parameters:
[
  1873
]
77 0.22 ms
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 = ?
Parameters:
[
  1873
]
78 0.23 ms
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 = ?
Parameters:
[
  1873
]
79 0.21 ms
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 = ?
Parameters:
[
  2642
]
80 0.21 ms
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 = ?
Parameters:
[
  2642
]
81 0.25 ms
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 = ?
Parameters:
[
  2642
]
82 0.22 ms
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 = ?
Parameters:
[
  2262
]
83 0.20 ms
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 = ?
Parameters:
[
  2262
]
84 0.23 ms
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 = ?
Parameters:
[
  2262
]
85 0.19 ms
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 = ?
Parameters:
[
  3254
]
86 0.21 ms
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 = ?
Parameters:
[
  3254
]
87 0.24 ms
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 = ?
Parameters:
[
  3254
]
88 0.22 ms
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 = ?
Parameters:
[
  3233
]
89 0.17 ms
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 = ?
Parameters:
[
  3
]
90 0.20 ms
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 = ?
Parameters:
[
  3233
]
91 0.23 ms
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 = ?
Parameters:
[
  3233
]
92 0.23 ms
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 = ?
Parameters:
[
  2641
]
93 0.22 ms
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 = ?
Parameters:
[
  2641
]
94 0.21 ms
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 = ?
Parameters:
[
  2641
]
95 0.20 ms
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 = ?
Parameters:
[
  2105
]
96 0.21 ms
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 = ?
Parameters:
[
  2105
]
97 0.22 ms
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 = ?
Parameters:
[
  2105
]
98 0.22 ms
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 = ?
Parameters:
[
  1660
]
99 0.21 ms
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 = ?
Parameters:
[
  1660
]
100 0.25 ms
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 = ?
Parameters:
[
  1660
]

Database Connections

Name Service
umem doctrine.dbal.umem_connection
mailman doctrine.dbal.mailman_connection
moodle doctrine.dbal.moodle_connection
fabric doctrine.dbal.fabric_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
fabric doctrine.orm.fabric_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
Umem\EmployeeBundle\Entity\Employee No errors.
Umem\EmployeeBundle\Entity\EmpStatus No errors.
Umem\EmployeeBundle\Entity\EmpPhoto No errors.
Umem\EmployeeBundle\Entity\EmpSites No errors.
Umem\EmployeeBundle\Entity\Email No errors.
Umem\EmployeeBundle\Entity\Citizenship No errors.
Umem\EmployeeBundle\Entity\Gender No errors.
Umem\EmployeeBundle\Entity\Status No errors.
Umem\UserBundle\Entity\Users No errors.
Umem\EmployeeBundle\Entity\Address No errors.
Umem\EmployeeBundle\Entity\Phone No errors.
Umem\EmployeeBundle\Entity\EmpTitle No errors.
Umem\EmployeeBundle\Entity\EmpProfAssoc No errors.
Umem\EmployeeBundle\Entity\EmpBoardCert No errors.
Umem\EmployeeBundle\Entity\Education No errors.
Umem\EmployeeBundle\Entity\Pref No errors.
Umem\AppBundle\Entity\Perm No errors.
Umem\EmployeeBundle\Entity\Bio No errors.
Umem\UserBundle\Entity\Track No errors.
Umem\PearlBundle\Entity\Pearl No errors.
Umem\EducationBundle\Entity\Podcast No errors.
Umem\MedStudentBundle\Entity\Evaluation No errors.
Umem\EmployeeBundle\Entity\FundingProfile No errors.
Umem\EmployeeBundle\Entity\Site No errors.
Umem\EmployeeBundle\Entity\AddressType No errors.
Umem\UtilitiesBundle\Entity\State No errors.
Umem\UtilitiesBundle\Entity\Country No errors.
Umem\EmployeeBundle\Entity\PhoneType No errors.
Umem\EmployeeBundle\Entity\PhoneVendor No errors.
Umem\EmployeeBundle\Entity\TitleType No errors.
Umem\EmployeeBundle\Entity\TitleSubtype No errors.
Umem\EmployeeBundle\Entity\ProfFellowAssoc No errors.
Umem\EmployeeBundle\Entity\BoardCertification No errors.
Umem\EmployeeBundle\Entity\BoardCertStatus No errors.
Umem\EmployeeBundle\Entity\EduType No errors.
Umem\EmployeeBundle\Entity\EduSubtype No errors.
Umem\EmployeeBundle\Entity\Degree No errors.
Umem\PearlBundle\Entity\PearlCategory No errors.
Umem\PearlBundle\Entity\PearlFile No errors.
Umem\EducationBundle\Entity\Tag No errors.
Umem\MedStudentBundle\Entity\Shift No errors.
Umem\MedStudentBundle\Entity\EvaluationType No errors.
Umem\AppBundle\Entity\ContactsAppAuth No errors.
Umem\AppBundle\Entity\MeetingDate No errors.
Umem\AppBundle\Entity\MeetingAttendance No errors.
Umem\AppBundle\Entity\PermSet No errors.
Umem\EmployeeBundle\Entity\SiteNetworkMap No errors.
Umem\EmployeeBundle\Entity\MailingListCriteria No errors.
Umem\EmployeeBundle\Entity\ContactMe No errors.
Umem\ContentBundle\Entity\RotationFile No errors.
Umem\ContentBundle\Entity\PhoneList No errors.
Umem\ContentBundle\Entity\RotationInfo No errors.
Umem\ContentBundle\Entity\PhoneCategory No errors.
Umem\ContentBundle\Entity\DynamicContent No errors.
Umem\ContentBundle\Entity\Faq No errors.
Umem\ContentBundle\Entity\BlogPost No errors.
Umem\ContentBundle\Entity\RotationContact No errors.
Umem\EventBundle\Entity\EvaluationQuestion No errors.
Umem\EventBundle\Entity\Event No errors.
Umem\EventBundle\Entity\OffsiteLecture No errors.
Umem\EventBundle\Entity\EventLocation No errors.
Umem\EventBundle\Entity\EvaluationTemplate No errors.
Umem\EventBundle\Entity\Speaker No errors.
Umem\EventBundle\Entity\EmployeeIdCard No errors.
Umem\EventBundle\Entity\EvaluationArchive No errors.
Umem\EventBundle\Entity\LectureCategory No errors.
Umem\EventBundle\Entity\LectureAttendance No errors.
Umem\EventBundle\Entity\EvaluationResponse No errors.
Umem\EventBundle\Entity\Conference No errors.
Umem\EventBundle\Entity\Evaluation No errors.
Umem\EventBundle\Entity\Lecture No errors.
Umem\EventBundle\Entity\ExtraCredit No errors.
Vich\UploaderBundle\Entity\File No errors.
Umem\EventBundle\Entity\EventFile No errors.
Umem\FileCollectionBundle\Entity\Category No errors.
Umem\FileCollectionBundle\Entity\File No errors.
Umem\FileCollectionBundle\Entity\FileCollection No errors.
Umem\PearlBundle\Entity\PushToken No errors.
Umem\PearlBundle\Entity\Ads No errors.
Umem\ResearchBundle\Entity\Investigator No errors.
Umem\ResearchBundle\Entity\ResearchStudy No errors.
Umem\ResearchBundle\Entity\PrincipalInvestigator No errors.
Umem\ResearchBundle\Entity\ResearchStatus No errors.
Umem\TimesheetBundle\Entity\ClinicalSchedule No errors.
Umem\TimesheetBundle\Entity\TrackerEvent No errors.
Umem\SurveyBundle\Entity\Response No errors.
Umem\SurveyBundle\Entity\Question No errors.

fabric entity manager

Class Mapping errors
Umem\FabricBundle\FabricEntity\StaffingModelLevel No errors.
Umem\FabricBundle\FabricEntity\StaffingModel
  • The field Umem\FabricBundle\FabricEntity\StaffingModel#levels is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Umem\FabricBundle\FabricEntity\StaffingModelLevel#model does not contain the required 'inversedBy="levels"' attribute.
Umem\FabricBundle\FabricEntity\StaffingModelWeight No errors.