GET http://146.155.173.135/faculties/27

Query Metrics

10 Database Queries
8 Different statements
2.51 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 0.38 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:
[
  27
]
2 0.37 ms
SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.title AS title_3, t0.english_title AS english_title_4, t0.description AS description_5, t0.english_description AS english_description_6, t0.total_slots AS total_slots_7, t0.picture AS picture_8, t0.published_deadline AS published_deadline_9, t0.faculty_rut AS faculty_rut_10, t0.second_faculty_rut AS second_faculty_rut_11, t0.status_id AS status_id_12, t0.cod_curriculum_id AS cod_curriculum_id_13, t0.created_by_admin_id AS created_by_admin_id_14 FROM opportunity t0 WHERE t0.faculty_rut = ?
Parameters:
[
  8828344
]
3 0.38 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.other_university AS other_university_26, t22.user_id AS user_id_27, t22.cod_pais AS cod_pais_28, t22.cod_universidad AS cod_universidad_29 FROM `user` t0 LEFT JOIN faculty t14 ON t14.user_id = t0.id LEFT JOIN applicant t22 ON t22.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  27
]
4 0.27 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:
[
  8828344
]
5 0.18 ms
SELECT t0.id AS id_1, t0.position AS position_2 FROM position t0 WHERE t0.id = ?
Parameters:
[
  "dir"
]
6 0.19 ms
SELECT t0.id AS id_1, t0.department AS department_2, t0.english_name AS english_name_3 FROM department t0 WHERE t0.id = ?
Parameters:
[
  "DIRRESSOC"
]
7 0.14 ms
SELECT t0.id AS id_1, t0.position AS position_2 FROM position t0 WHERE t0.id = ?
Parameters:
[
  "profe"
]
8 0.13 ms
SELECT t0.id AS id_1, t0.department AS department_2, t0.english_name AS english_name_3 FROM department t0 WHERE t0.id = ?
Parameters:
[
  "ICT"
]
9 0.27 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:
[
  8828344
]
10 0.20 ms
SELECT t0.id AS id_1, t0.area AS area_2, t0.english_name AS english_name_3, t0.cod_param_77_vig AS cod_param_77_vig_4, t0.cod_curriculum AS cod_curriculum_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:
[
  8828344
]

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\FacultyAssignment 2
App\Entity\Position 2
App\Entity\Department 2
App\Entity\Faculty 1
App\Entity\User 1
App\Entity\ResearchArea 1
App\Entity\CodCurriculum 1

Entities Mapping