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

Query Metrics

6 Database Queries
6 Different statements
8.02 ms Query time
0 Invalid entities
153 Managed entities

Queries

Group similar statements

# Time Info
1 4.00 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 2.07 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 6480
Parameters:
[]
3 0.59 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.45 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 0.57 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.35 ms
SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1, c0_.opportunity_type_id AS opportunity_type_id_2 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
App\Entity\OpportunityType 2

Entities Mapping