Query Metrics

128 Database Queries
13 Different statements
22.09 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.40 ms
(19.92%)
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.92 ms
(13.20%)
16
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
]
2.54 ms
(11.50%)
15
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
]
2.38 ms
(10.75%)
15
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
]
2.34 ms
(10.61%)
15
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
]
2.17 ms
(9.82%)
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
]
2.07 ms
(9.35%)
13
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
]
1.51 ms
(6.83%)
10
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
(3.19%)
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.61 ms
(2.75%)
4
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
(0.84%)
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.68%)
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.57%)
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.

Entities Mapping

Class Mapping errors
App\Entity\Researcher No errors.
App\Entity\Title No errors.
App\Entity\Document No errors.
App\Entity\Gender No errors.
App\Entity\PersonOfInterestEquipment No errors.
App\Entity\PersonOfInterestFacility No errors.
App\Entity\ResearcherInstitution No errors.
App\Entity\ResearcherKeyword No errors.
App\Entity\ResearchProject No errors.
App\Entity\ResearcherResearchArea No errors.
App\Entity\ResearcherResearchPlatform No errors.
App\Entity\ResearcherResearchProject No errors.
App\Entity\PersonOfInterestResearchTeam No errors.
App\Entity\PersonOfInterestResearchUnit No errors.
App\Entity\PersonOfInterestService No errors.
App\Entity\ResearcherSocialNetwork No errors.
App\Entity\Website No errors.
App\Entity\Url No errors.
App\Entity\Equipment No errors.
App\Entity\Facility No errors.
App\Entity\Service No errors.
App\Entity\Institution No errors.
App\Entity\ResearchTeam No errors.
App\Entity\ResearchUnit No errors.
App\Entity\RoleEquipment No errors.
App\Entity\RoleFacility No errors.
App\Entity\Keyword No errors.
App\Entity\ResearchArea No errors.
App\Entity\ResearchPlatform No errors.
App\Entity\RoleResearchTeam No errors.
App\Entity\RoleResearchUnit No errors.
App\Entity\RoleService No errors.
App\Entity\SocialNetwork No errors.
App\Entity\WebsiteType No errors.
App\Entity\EquipmentInstitution No errors.
App\Entity\FacilityInstitution No errors.
App\Entity\ResearchUnitInstitution No errors.
App\Entity\ServiceInstitution No errors.
App\Entity\LoginHistory No errors.
App\Entity\ResearchTeamResearchArea No errors.
App\Entity\ResearchUnitResearchArea No errors.
App\Entity\ResearchUnitEquipment No errors.
App\Entity\ResearchUnitFacility No errors.
App\Entity\ResearchUnitJri No errors.
App\Entity\ResearchUnitKeyword No errors.
App\Entity\ResearchUnitService No errors.
App\Entity\ResearchTeamKeyword No errors.
App\Entity\EquipmentAccessMode No errors.
App\Entity\EquipmentCategory No errors.
App\Entity\FacilityEquipment No errors.
App\Entity\EquipmentKeyword No errors.
App\Entity\ServiceEquipment No errors.
App\Entity\EquipmentTargetAudience No errors.
App\Entity\FacilityAccessMode No errors.
App\Entity\FacilityCategory No errors.
App\Entity\FacilityKeyword No errors.
App\Entity\FacilityService No errors.
App\Entity\FacilityTargetAudience No errors.
App\Entity\ServiceCategory No errors.
App\Entity\ServiceAccessType No errors.
App\Entity\ServiceAccessMode No errors.
App\Entity\ServiceKeyword No errors.
App\Entity\ServiceTargetAudience No errors.
App\Entity\Jri No errors.
App\Entity\AccessMode No errors.
App\Entity\TargetAudience No errors.
App\Entity\AccessType No errors.