Query Metrics
5
Database Queries
5
Different statements
13.78 ms
Query time
0
Invalid entities
Queries
umem connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.56 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, e0_.emp_email_primary_index AS emp_email_primary_index_33, e0_.emp_citizenship_index AS emp_citizenship_index_34, e0_.emp_gender AS emp_gender_35 FROM employee e0_ WHERE e0_.emp_index = ? AND e0_.emp_disable = 0 AND e0_.emp_show_profile = 1
Parameters:
[
"2293"
]
|
| 2 | 0.30 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:
[
2293
]
|
| 3 | 0.38 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:
[
2293
]
|
| 4 | 5.60 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:
[
1
]
|
| 5 | 6.94 ms |
SELECT t0.emp_prof_assoc_index AS emp_prof_assoc_index_1, t0.emp_index AS emp_index_2, t0.prof_fellow_assoc_index AS prof_fellow_assoc_index_3, t0.emp_prof_assoc_other AS emp_prof_assoc_other_4, t0.emp_index AS emp_index_5, t0.prof_fellow_assoc_index AS prof_fellow_assoc_index_6 FROM emp_prof_assoc t0 WHERE t0.emp_index = ?
Parameters:
[
2293
]
|
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
No loaded entities.