Symfony Profiler

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

Query Metrics

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM opportunity o0_ LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id LEFT JOIN status s8_ ON o0_.status_id = s8_.id WHERE f1_.active = 1 AND o0_.status_id IN (?, ?)

[
  1
  2
]

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  opportunity o0_
  LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut
  LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id
  LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id
  LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id
  LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum
  LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id
  LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id
  LEFT JOIN status s8_ ON o0_.status_id = s8_.id
WHERE
  f1_.active = 1
  AND o0_.status_id IN (?, ?)

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM opportunity o0_ LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id LEFT JOIN status s8_ ON o0_.status_id = s8_.id WHERE f1_.active = 1 AND o0_.status_id IN (1, 2);

SELECT DISTINCT o0_.id AS id_0, o0_.status_id AS sclr_1, o0_.creation_date AS creation_date_2 FROM opportunity o0_ LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id LEFT JOIN status s8_ ON o0_.status_id = s8_.id WHERE f1_.active = 1 AND o0_.status_id IN (?, ?) ORDER BY o0_.status_id ASC, o0_.creation_date DESC LIMIT 9

[
  1
  2
]

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.status_id AS sclr_1,
  o0_.creation_date AS creation_date_2
FROM
  opportunity o0_
  LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut
  LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id
  LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id
  LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id
  LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum
  LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id
  LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id
  LEFT JOIN status s8_ ON o0_.status_id = s8_.id
WHERE
  f1_.active = 1
  AND o0_.status_id IN (?, ?)
ORDER BY
  o0_.status_id ASC,
  o0_.creation_date DESC
LIMIT
  9

SELECT DISTINCT o0_.id AS id_0, o0_.status_id AS sclr_1, o0_.creation_date AS creation_date_2 FROM opportunity o0_ LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id LEFT JOIN status s8_ ON o0_.status_id = s8_.id WHERE f1_.active = 1 AND o0_.status_id IN (1, 2) ORDER BY o0_.status_id ASC, o0_.creation_date DESC LIMIT 9;

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 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_english 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_english 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_english 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 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 s0_.id AS id_0, s0_.status AS status_1, s0_.english AS english_2 FROM status s0_ WHERE s0_.status IN (?, ?) ORDER BY s0_.status ASC

[
  "Abierta"
  "Cerrada"
]

SELECT
  s0_.id AS id_0,
  s0_.status AS status_1,
  s0_.english AS english_2
FROM
  status s0_
WHERE
  s0_.status IN (?, ?)
ORDER BY
  s0_.status ASC

SELECT s0_.id AS id_0, s0_.status AS status_1, s0_.english AS english_2 FROM status s0_ WHERE s0_.status IN ('Abierta', 'Cerrada') ORDER BY s0_.status ASC;