GET https://oportunidadespostgrado-test.ing.uc.cl/es/admin/user/vincular-config

Query Metrics

14 Database Queries
6 Different statements
5.32 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 0.81 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.deactivated_notifications AS deactivated_notifications_5, t0.sex AS sex_6, t0.rut AS rut_7, t0.name AS name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.picture AS picture_11, t0.reset_token AS reset_token_12, t0.reset_token_expires_at AS reset_token_expires_at_13, t0.career AS career_14, t0.curriculum AS curriculum_15, t0.other_university AS other_university_16, t17.rut AS rut_18, t17.biography AS biography_19, t17.interest_areas AS interest_areas_20, t17.english_interest_areas AS english_interest_areas_21, t17.active AS active_22, t17.english_bio AS english_bio_23, t17.user_id AS user_id_24, t25.id AS id_26, t25.career AS career_27, t25.curriculum AS curriculum_28, t25.other_university AS other_university_29, t25.user_id AS user_id_30, t25.cod_pais AS cod_pais_31, t25.cod_universidad AS cod_universidad_32, t0.cod_pais AS cod_pais_33, t0.cod_universidad AS cod_universidad_34 FROM `user` t0 LEFT JOIN faculty t17 ON t17.user_id = t0.id LEFT JOIN applicant t25 ON t25.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
2 1.04 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ WHERE u0_.roles LIKE ? OR u0_.roles LIKE ?
Parameters:
[
  "%"ROLE_ADMINISTRATIVE"%"
  "%"ROLE_OTHER"%"
]
3 0.31 ms
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = ?
Parameters:
[
  159
]
4 0.27 ms
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = ?
Parameters:
[
  159
]
5 0.27 ms
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = ?
Parameters:
[
  160
]
6 0.22 ms
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = ?
Parameters:
[
  160
]
7 0.28 ms
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = ?
Parameters:
[
  161
]
8 0.21 ms
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = ?
Parameters:
[
  161
]
9 0.24 ms
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = ?
Parameters:
[
  162
]
10 0.24 ms
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = ?
Parameters:
[
  162
]
11 0.24 ms
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = ?
Parameters:
[
  163
]
12 0.26 ms
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = ?
Parameters:
[
  163
]
13 0.36 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%"ROLE_PROFESSOR"%"
]
14 0.57 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ INNER JOIN user_assistants u2_ ON u0_.id = u2_.user_target INNER JOIN `user` u1_ ON u1_.id = u2_.user_source
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 6

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Faculty No errors.
App\Entity\Applicant No errors.
App\Entity\Country No errors.
App\Entity\University No errors.
App\Entity\Application No errors.