Query Metrics
100
Database Queries
6
Different statements
29.16 ms
Query time
1
Invalid entities
Queries
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
fabric entity manager
| Class | Mapping errors |
|---|---|
| Umem\FabricBundle\FabricEntity\StaffingModelLevel | No errors. |
| Umem\FabricBundle\FabricEntity\StaffingModel |
|
| Umem\FabricBundle\FabricEntity\StaffingModelWeight | No errors. |