Query Metrics

21 Database Queries
2 Different statements
4.65 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.