Query Metrics
3
Database Queries
3
Different statements
1.34 ms
Query time
1
Invalid entities
Queries
umem connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.51 ms |
SELECT t0.emp_index AS emp_index_1, t0.emp_lastname AS emp_lastname_2, t0.emp_firstname AS emp_firstname_3, t0.emp_middlename AS emp_middlename_4, t0.emp_gender AS emp_gender_5, t0.emp_start_date AS emp_start_date_6, t0.emp_suffix AS emp_suffix_7, t0.emp_timestamp_initial AS emp_timestamp_initial_8, t0.emp_timestamp_update AS emp_timestamp_update_9, t0.emp_ftpt AS emp_ftpt_10, t0.emp_show_profile AS emp_show_profile_11, t0.emp_disable AS emp_disable_12, t0.emp_grad_residency AS emp_grad_residency_13, t0.emp_profile_update_flag AS emp_profile_update_flag_14, t0.emp_chief AS emp_chief_15, t0.emp_program_director AS emp_program_director_16, t0.emp_network_provider AS emp_network_provider_17, t0.emp_pending_forms AS emp_pending_forms_18, t0.emp_emerg_name AS emp_emerg_name_19, t0.emp_emerg_phone AS emp_emerg_phone_20, t0.emp_emerg_relationship AS emp_emerg_relationship_21, t0.emp_birthdate AS emp_birthdate_22, t0.emp_birthplace AS emp_birthplace_23, t0.emp_ssn AS emp_ssn_24, t0.emp_race AS emp_race_25, t0.emp_citizenship_index AS emp_citizenship_index_26, t0.emp_ethnicity AS emp_ethnicity_27, t0.emp_email_primary_index AS emp_email_primary_index_28, t0.emp_spouse_name AS emp_spouse_name_29, t0.faculty_auto_exempt AS faculty_auto_exempt_30, t0.bamboo_id AS bamboo_id_31, t0.npi AS npi_32, t0.umms_ad_username AS umms_ad_username_33, t34.user_index AS user_index_35, t34.emp_index AS emp_index_36, t34.username AS username_37, t34.ad_guid AS ad_guid_38, t34.password_hash AS password_hash_39, t34.reset_token AS reset_token_40, t34.reset_timestamp AS reset_timestamp_41, t34.reset_count AS reset_count_42, t34.account_update AS account_update_43, t34.activation_token AS activation_token_44, t34.activation_timestamp AS activation_timestamp_45, t34.activation_count AS activation_count_46, t34.invitation_token AS invitation_token_47, t34.invitation_timestamp AS invitation_timestamp_48, t34.invitation_count AS invitation_count_49, t34.timestamp AS timestamp_50, t34.roles AS roles_51, t34.emp_index AS emp_index_52, t0.emp_email_primary_index AS emp_email_primary_index_53, t0.emp_citizenship_index AS emp_citizenship_index_54, t0.emp_gender AS emp_gender_55 FROM employee t0 LEFT JOIN users t34 ON t34.emp_index = t0.emp_index WHERE t0.emp_index = ? LIMIT 1
Parameters:
[
"352"
]
|
| 2 | 0.54 ms |
SELECT t0.pref_index AS pref_index_1, t0.pref_user AS pref_user_2, t0.pref_txt_fac AS pref_txt_fac_3, t0.pref_txt_res AS pref_txt_res_4, t0.pref_fac_home_add AS pref_fac_home_add_5, t0.pref_fac_home_phone AS pref_fac_home_phone_6, t0.pref_fac_mobile AS pref_fac_mobile_7, t0.pref_fac_pager AS pref_fac_pager_8, t0.pref_res_home_add AS pref_res_home_add_9, t0.pref_res_home_phone AS pref_res_home_phone_10, t0.pref_res_mobile AS pref_res_mobile_11, t0.pref_res_pager AS pref_res_pager_12, t0.pref_host_applicants AS pref_host_applicants_13, t0.pref_default_cp_home AS pref_default_cp_home_14, t0.pref_txt_mobile AS pref_txt_mobile_15, t0.pref_txt_pager AS pref_txt_pager_16, t0.pref_txt_email AS pref_txt_email_17, t0.pref_alum_home_add AS pref_alum_home_add_18, t0.pref_alum_home_phone AS pref_alum_home_phone_19, t0.pref_alum_mobile AS pref_alum_mobile_20, t0.pref_alum_pager AS pref_alum_pager_21, t0.pref_txt_alum AS pref_txt_alum_22, t0.pref_txt_cc AS pref_txt_cc_23, t0.pref_show_lectures AS pref_show_lectures_24, t0.pref_show_grandrounds AS pref_show_grandrounds_25, t0.pref_fac_email AS pref_fac_email_26, t0.pref_res_email AS pref_res_email_27, t0.pref_alum_email AS pref_alum_email_28, t0.pref_allow_solicit AS pref_allow_solicit_29, t0.pref_txt_student AS pref_txt_student_30, t0.pref_txt_network AS pref_txt_network_31, t0.pref_txt_guest AS pref_txt_guest_32, t0.pref_network_home_add AS pref_network_home_add_33, t0.pref_network_home_phone AS pref_network_home_phone_34, t0.pref_network_mobile AS pref_network_mobile_35, t0.pref_network_pager AS pref_network_pager_36, t0.pref_network_email AS pref_network_email_37, t0.pref_guest_home_add AS pref_guest_home_add_38, t0.pref_guest_home_phone AS pref_guest_home_phone_39, t0.pref_guest_mobile AS pref_guest_mobile_40, t0.pref_guest_pager AS pref_guest_pager_41, t0.pref_guest_email AS pref_guest_email_42, t0.pref_conf_notification AS pref_conf_notification_43, t0.pref_email_reminder_decline AS pref_email_reminder_decline_44, t0.pref_enable_relay_message AS pref_enable_relay_message_45, t0.pref_user AS pref_user_46 FROM pref t0 WHERE t0.pref_user = ?
Parameters:
[
352
]
|
| 3 | 0.29 ms |
SELECT t0.emp_photo_index AS emp_photo_index_1, t0.emp_photo_employee AS emp_photo_employee_2, t0.emp_photo_name AS emp_photo_name_3, t0.timestamp AS timestamp_4, t0.emp_photo_employee AS emp_photo_employee_5 FROM emp_photo t0 WHERE t0.emp_photo_employee = ?
Parameters:
[
352
]
|
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. |