GET https://oportunidadespostgrado-test.ing.uc.cl/faculties/299

Query Metrics

5 Database Queries
5 Different statements
3.11 ms Query time
0 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 0.69 ms
SELECT t0.rut AS rut_1, t0.status AS status_2, t0.post AS post_3, t0.biography AS biography_4, t0.interest_areas AS interest_areas_5, t0.english_interest_areas AS english_interest_areas_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  299
]
2 1.12 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, t14.rut AS rut_15, t14.status AS status_16, t14.post AS post_17, t14.biography AS biography_18, t14.interest_areas AS interest_areas_19, t14.english_interest_areas AS english_interest_areas_20, t14.user_id AS user_id_21, t22.id AS id_23, t22.career AS career_24, t22.curriculum AS curriculum_25, t22.user_id AS user_id_26, t22.cod_pais AS cod_pais_27, t22.cod_universidad AS cod_universidad_28, t29.id AS id_30, t29.application_date AS application_date_31, t29.comment AS comment_32, t29.name AS name_33, t29.last_name AS last_name_34, t29.email AS email_35, t29.career AS career_36, t29.curriculum AS curriculum_37, t29.applicant_id AS applicant_id_38, t29.opportunity_id AS opportunity_id_39, t29.cod_universidad AS cod_universidad_40, t29.cod_pais AS cod_pais_41, t0.administrativo_asignado_id AS administrativo_asignado_id_42 FROM `user` t0 LEFT JOIN faculty t14 ON t14.user_id = t0.id LEFT JOIN applicant t22 ON t22.user_id = t0.id LEFT JOIN application t29 ON t29.applicant_id = t0.id WHERE t0.id = ?
Parameters:
[
  299
]
3 0.53 ms
SELECT t0.faculty_rut AS faculty_rut_1, t0.position_id AS position_id_2, t0.department_id AS department_id_3 FROM faculty_assignment t0 WHERE t0.faculty_rut = ?
Parameters:
[
  21458509
]
4 0.44 ms
SELECT t0.id AS id_1, t0.line AS line_2, t0.english_name AS english_name_3, t0.description AS description_4, t0.area_id AS area_id_5, t0.department_id AS department_id_6 FROM research_line t0 INNER JOIN faculty_research_line ON t0.id = faculty_research_line.research_line_id WHERE faculty_research_line.faculty_rut = ?
Parameters:
[
  21458509
]
5 0.33 ms
SELECT t0.id AS id_1, t0.area AS area_2, t0.english_name AS english_name_3, t0.cod_curriculum AS cod_curriculum_4, t0.cod_param_77_vig AS cod_param_77_vig_5 FROM research_area t0 INNER JOIN faculty_research_area ON t0.id = faculty_research_area.research_area_id WHERE faculty_research_area.faculty_rut = ?
Parameters:
[
  21458509
]

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\Faculty 1
App\Entity\User 1
App\Entity\ResearchArea 1

Entities Mapping