Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Translation 10
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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 WHERE f0_.active = 1

[]

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
WHERE
  f0_.active = 1

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 WHERE f0_.active = 1;

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 WHERE f0_.active = 1 LIMIT 10 OFFSET 130

[]

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
WHERE
  f0_.active = 1
LIMIT
  10
OFFSET
  130

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 WHERE f0_.active = 1 LIMIT 10 OFFSET 130;

SELECT f0_.rut AS rut_0, f0_.biography AS biography_1, f0_.interest_areas AS interest_areas_2, f0_.english_interest_areas AS english_interest_areas_3, f0_.active AS active_4, f0_.english_bio AS english_bio_5, f0_.user_id AS user_id_6 FROM faculty f0_ INNER JOIN `user` u1_ ON f0_.user_id = u1_.id WHERE f0_.active = 1 ORDER BY u1_.name ASC

[]

SELECT
  f0_.rut AS rut_0,
  f0_.biography AS biography_1,
  f0_.interest_areas AS interest_areas_2,
  f0_.english_interest_areas AS english_interest_areas_3,
  f0_.active AS active_4,
  f0_.english_bio AS english_bio_5,
  f0_.user_id AS user_id_6
FROM
  faculty f0_
  INNER JOIN `user` u1_ ON f0_.user_id = u1_.id
WHERE
  f0_.active = 1
ORDER BY
  u1_.name ASC

SELECT f0_.rut AS rut_0, f0_.biography AS biography_1, f0_.interest_areas AS interest_areas_2, f0_.english_interest_areas AS english_interest_areas_3, f0_.active AS active_4, f0_.english_bio AS english_bio_5, f0_.user_id AS user_id_6 FROM faculty f0_ INNER JOIN `user` u1_ ON f0_.user_id = u1_.id WHERE f0_.active = 1 ORDER BY u1_.name ASC;

SELECT d0_.id AS id_0, d0_.department AS department_1, d0_.english_name AS english_name_2, d0_.active AS active_3 FROM department d0_ WHERE d0_.active = 1 ORDER BY d0_.department ASC

[]

SELECT
  d0_.id AS id_0,
  d0_.department AS department_1,
  d0_.english_name AS english_name_2,
  d0_.active AS active_3
FROM
  department d0_
WHERE
  d0_.active = 1
ORDER BY
  d0_.department ASC

SELECT d0_.id AS id_0, d0_.department AS department_1, d0_.english_name AS english_name_2, d0_.active AS active_3 FROM department d0_ WHERE d0_.active = 1 ORDER BY d0_.department ASC;

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_.active AS active_4, r0_.cod_curriculum AS cod_curriculum_5 FROM research_area r0_ WHERE r0_.active = 1 ORDER BY r0_.area ASC

[]

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_.active AS active_4,
  r0_.cod_curriculum AS cod_curriculum_5
FROM
  research_area r0_
WHERE
  r0_.active = 1
ORDER BY
  r0_.area ASC

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_.active AS active_4, r0_.cod_curriculum AS cod_curriculum_5 FROM research_area r0_ WHERE r0_.active = 1 ORDER BY r0_.area ASC;

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2, t0.active AS active_3, t0.nom_curriculum_english AS nom_curriculum_english_4 FROM cod_curriculum t0 WHERE t0.codCurriculum = ?

[
  40201
]

SELECT
  t0.codCurriculum AS codCurriculum_1,
  t0.nom_curriculum AS nom_curriculum_2,
  t0.active AS active_3,
  t0.nom_curriculum_english AS nom_curriculum_english_4
FROM
  cod_curriculum t0
WHERE
  t0.codCurriculum = ?

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2, t0.active AS active_3, t0.nom_curriculum_english AS nom_curriculum_english_4 FROM cod_curriculum t0 WHERE t0.codCurriculum = 40201;

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2, t0.active AS active_3, t0.nom_curriculum_english AS nom_curriculum_english_4 FROM cod_curriculum t0 WHERE t0.codCurriculum = ?

[
  40301
]

SELECT
  t0.codCurriculum AS codCurriculum_1,
  t0.nom_curriculum AS nom_curriculum_2,
  t0.active AS active_3,
  t0.nom_curriculum_english AS nom_curriculum_english_4
FROM
  cod_curriculum t0
WHERE
  t0.codCurriculum = ?

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2, t0.active AS active_3, t0.nom_curriculum_english AS nom_curriculum_english_4 FROM cod_curriculum t0 WHERE t0.codCurriculum = 40301;

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2, t0.active AS active_3, t0.nom_curriculum_english AS nom_curriculum_english_4 FROM cod_curriculum t0 WHERE t0.codCurriculum = ?

[
  40401
]

SELECT
  t0.codCurriculum AS codCurriculum_1,
  t0.nom_curriculum AS nom_curriculum_2,
  t0.active AS active_3,
  t0.nom_curriculum_english AS nom_curriculum_english_4
FROM
  cod_curriculum t0
WHERE
  t0.codCurriculum = ?

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2, t0.active AS active_3, t0.nom_curriculum_english AS nom_curriculum_english_4 FROM cod_curriculum t0 WHERE t0.codCurriculum = 40401;

SELECT r0_.id AS id_0, r0_.line AS line_1, r0_.english_name AS english_name_2, r0_.description AS description_3, r0_.active AS active_4, r0_.area_id AS area_id_5, r0_.department_id AS department_id_6 FROM research_line r0_ WHERE r0_.active = 1 ORDER BY r0_.line ASC

[]

SELECT
  r0_.id AS id_0,
  r0_.line AS line_1,
  r0_.english_name AS english_name_2,
  r0_.description AS description_3,
  r0_.active AS active_4,
  r0_.area_id AS area_id_5,
  r0_.department_id AS department_id_6
FROM
  research_line r0_
WHERE
  r0_.active = 1
ORDER BY
  r0_.line ASC

SELECT r0_.id AS id_0, r0_.line AS line_1, r0_.english_name AS english_name_2, r0_.description AS description_3, r0_.active AS active_4, r0_.area_id AS area_id_5, r0_.department_id AS department_id_6 FROM research_line r0_ WHERE r0_.active = 1 ORDER BY r0_.line ASC;

SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1, c0_.active AS active_2, c0_.nom_curriculum_english AS nom_curriculum_english_3 FROM cod_curriculum c0_ WHERE c0_.active = 1 ORDER BY c0_.nom_curriculum ASC

[]

SELECT
  c0_.codCurriculum AS codCurriculum_0,
  c0_.nom_curriculum AS nom_curriculum_1,
  c0_.active AS active_2,
  c0_.nom_curriculum_english AS nom_curriculum_english_3
FROM
  cod_curriculum c0_
WHERE
  c0_.active = 1
ORDER BY
  c0_.nom_curriculum ASC

SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1, c0_.active AS active_2, c0_.nom_curriculum_english AS nom_curriculum_english_3 FROM cod_curriculum c0_ WHERE c0_.active = 1 ORDER BY c0_.nom_curriculum ASC;