GET https://oportunidadespostgrado-test.ing.uc.cl/faculties?page=679

Query Metrics

11 Database Queries
7 Different statements
11.05 ms Query time
0 Invalid entities
151 Managed entities

Queries

Group similar statements

# Time Info
1 3.37 ms
SELECT DISTINCT count(DISTINCT f0_.rut) AS sclr_0 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut LEFT JOIN department d3_ ON f2_.department_id = d3_.id LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id
Parameters:
[]
2 1.61 ms
SELECT DISTINCT f0_.rut AS rut_0 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut LEFT JOIN department d3_ ON f2_.department_id = d3_.id LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id LIMIT 10 OFFSET 6780
Parameters:
[]
3 0.67 ms
SELECT d0_.id AS id_0, d0_.department AS department_1, d0_.english_name AS english_name_2 FROM department d0_ ORDER BY d0_.department ASC
Parameters:
[]
4 0.73 ms
SELECT r0_.id AS id_0, r0_.area AS area_1, r0_.english_name AS english_name_2, r0_.cod_param_77_vig AS cod_param_77_vig_3, r0_.cod_curriculum AS cod_curriculum_4 FROM research_area r0_ ORDER BY r0_.area ASC
Parameters:
[]
5 0.61 ms
SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2 FROM cod_curriculum t0 WHERE t0.codCurriculum = ?
Parameters:
[
  41401
]
6 0.87 ms
SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2 FROM cod_curriculum t0 WHERE t0.codCurriculum = ?
Parameters:
[
  40201
]
7 0.54 ms
SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2 FROM cod_curriculum t0 WHERE t0.codCurriculum = ?
Parameters:
[
  40301
]
8 0.50 ms
SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2 FROM cod_curriculum t0 WHERE t0.codCurriculum = ?
Parameters:
[
  40401
]
9 0.47 ms
SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2 FROM cod_curriculum t0 WHERE t0.codCurriculum = ?
Parameters:
[
  41301
]
10 0.80 ms
SELECT r0_.id AS id_0, r0_.line AS line_1, r0_.english_name AS english_name_2, r0_.description AS description_3, r0_.area_id AS area_id_4, r0_.department_id AS department_id_5 FROM research_line r0_ ORDER BY r0_.line ASC
Parameters:
[]
11 0.88 ms
SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1 FROM cod_curriculum c0_ ORDER BY c0_.nom_curriculum ASC
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\Department 53
App\Entity\ResearchLine 53
App\Entity\ResearchArea 40
App\Entity\CodCurriculum 5

Entities Mapping

Class Mapping errors
App\Entity\Department No errors.
App\Entity\ResearchArea No errors.
App\Entity\CodCurriculum No errors.
App\Entity\ResearchLine No errors.
App\Entity\Faculty No errors.
App\Entity\User No errors.
App\Entity\FacultyAssignment No errors.
App\Entity\Opportunity No errors.