Query Metrics
93
Database Queries
13
Different statements
16.33 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.40 ms (26.95%) |
20 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.job_position AS job_position_5, t0.other_gender AS other_gender_6, t0.personal_orcid AS personal_orcid_7, t0.email AS email_8, t0.postal_address1 AS postal_address1_9, t0.postal_address2 AS postal_address2_10, t0.zipcode AS zipcode_11, t0.city AS city_12, t0.country AS country_13, t0.bio AS bio_14, t0.degrees AS degrees_15, t0.news_about_me AS news_about_me_16, t0.about_me AS about_me_17, t0.can_be_phd_supervisor AS can_be_phd_supervisor_18, t0.created_at AS created_at_19, t0.last_modified_at AS last_modified_at_20, t0.last_login AS last_login_21, t0.published AS published_22, t0.role AS role_23, t0.title_id AS title_id_24, t0.photo_id AS photo_id_25, t0.gender_id AS gender_id_26 FROM researcher t0 WHERE t0.id = ?
Parameters:
[
"102"
]
|
2.17 ms (13.29%) |
13 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.icon_path AS icon_path_4, t0.position AS position_5, t0.parent_id AS parent_id_6 FROM research_area t0 WHERE t0.id = ?
Parameters:
[
177
]
|
1.85 ms (11.34%) |
10 |
SELECT t0.id AS id_1, t0.source AS source_2, t0.alias AS alias_3, t0.default_alias AS default_alias_4 FROM url t0 WHERE t0.source = ? AND t0.default_alias = ? LIMIT 1
Parameters:
[ "App_Entity_Researcher:102" 1 ] |
1.53 ms (9.40%) |
9 |
SELECT t0.id AS id_1, t0.is_admin AS is_admin_2, t0.researcher_id AS researcher_id_3, t0.institution_id AS institution_id_4 FROM researcher_institution t0 WHERE t0.researcher_id = ?
Parameters:
[
102
]
|
1.42 ms (8.70%) |
9 |
SELECT t0.id AS id_1, t0.other_role AS other_role_2, t0.researcher_id AS researcher_id_3, t0.research_unit_id AS research_unit_id_4, t0.role_id AS role_id_5 FROM person_of_interest_research_unit t0 WHERE t0.researcher_id = ?
Parameters:
[
102
]
|
1.38 ms (8.48%) |
9 |
SELECT t0.id AS id_1, t0.researcher_id AS researcher_id_2, t0.research_area_id AS research_area_id_3 FROM researcher_research_area t0 WHERE t0.researcher_id = ?
Parameters:
[
102
]
|
1.05 ms (6.41%) |
7 |
SELECT t0.id AS id_1, t0.other_role AS other_role_2, t0.researcher_id AS researcher_id_3, t0.research_team_id AS research_team_id_4, t0.role_id AS role_id_5 FROM person_of_interest_research_team t0 WHERE t0.researcher_id = ?
Parameters:
[
102
]
|
0.91 ms (5.55%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.alias AS alias_4, t0.postal_address1 AS postal_address1_5, t0.postal_address2 AS postal_address2_6, t0.zipcode AS zipcode_7, t0.city AS city_8, t0.country AS country_9, t0.description AS description_10, t0.created_at AS created_at_11, t0.last_modified_at AS last_modified_at_12, t0.published AS published_13, t0.logo_id AS logo_id_14 FROM research_unit t0 WHERE t0.id = ?
Parameters:
[
5
]
|
0.71 ms (4.32%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.phone_number AS phone_number_4, t0.postal_address1 AS postal_address1_5, t0.postal_address2 AS postal_address2_6, t0.zipcode AS zipcode_7, t0.city AS city_8, t0.country AS country_9, t0.alias AS alias_10, t0.id_svg_on_image AS id_svg_on_image_11, t0.created_at AS created_at_12, t0.last_modified_at AS last_modified_at_13, t0.published AS published_14, t0.position AS position_15, t0.logo_id AS logo_id_16 FROM institution t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.45 ms (2.75%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.alias AS alias_4, t0.description AS description_5, t0.created_at AS created_at_6, t0.last_modified_at AS last_modified_at_7, t0.published AS published_8, t0.logo_id AS logo_id_9, t0.research_unit_id AS research_unit_id_10 FROM research_team t0 WHERE t0.id = ?
Parameters:
[
9
]
|
0.18 ms (1.13%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4 FROM title t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.15 ms (0.92%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.can_update_publish AS can_update_publish_3, t0.position AS position_4, t0.parent_id AS parent_id_5 FROM role_research_team t0 WHERE t0.id = ?
Parameters:
[
2
]
|
0.12 ms (0.77%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.can_update_publish AS can_update_publish_3, t0.position AS position_4, t0.parent_id AS parent_id_5 FROM role_research_unit t0 WHERE t0.id = ?
Parameters:
[
3
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.