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

Query Metrics

6 Database Queries
6 Different statements
16.00 ms Query time
0 Invalid entities
151 Managed entities

Queries

Group similar statements

# Time Info
1 8.32 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 3.96 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 6180
Parameters:
[]
3 0.99 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.94 ms
SELECT r0_.id AS id_0, r0_.area AS area_1, r0_.english_name AS english_name_2, r0_.cod_curriculum AS cod_curriculum_3, r0_.cod_param_77_vig AS cod_param_77_vig_4 FROM research_area r0_ ORDER BY r0_.area ASC
Parameters:
[]
5 1.13 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:
[]
6 0.65 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\ResearchLine No errors.
App\Entity\CodCurriculum No errors.
App\Entity\Faculty No errors.
App\Entity\User No errors.
App\Entity\FacultyAssignment No errors.
App\Entity\Opportunity No errors.