Query Metrics
21
Database Queries
2
Different statements
4.65 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.33 ms |
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 | 0.23 ms |
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:
[
"347"
]
|
3 | 0.23 ms |
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:
[
"103"
]
|
4 | 0.23 ms |
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:
[
"399"
]
|
5 | 0.23 ms |
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:
[
"985"
]
|
6 | 0.23 ms |
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:
[
"704"
]
|
7 | 0.24 ms |
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:
[
"583"
]
|
8 | 0.23 ms |
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:
[
"578"
]
|
9 | 0.23 ms |
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:
[
"765"
]
|
10 | 0.22 ms |
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:
[
"646"
]
|
11 | 0.21 ms |
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:
[
"546"
]
|
12 | 0.18 ms |
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:
[
"673"
]
|
13 | 0.16 ms |
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:
[
"734"
]
|
14 | 0.17 ms |
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:
[
"400"
]
|
15 | 0.19 ms |
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:
[
"177"
]
|
16 | 0.17 ms |
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:
[
"865"
]
|
17 | 0.33 ms |
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:
[
"1088"
]
|
18 | 0.23 ms |
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:
[
"1314"
]
|
19 | 0.19 ms |
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:
[
"1130"
]
|
20 | 0.18 ms |
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:
[
"1076"
]
|
21 | 0.25 ms |
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 ] |
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. |