Symfony Profiler

SELECT
  s0_.year AS year_0
FROM
  student s0_
WHERE
  s0_.active = ?
GROUP BY
  s0_.year
ORDER BY
  s0_.year DESC

SELECT s0_.year AS year_0 FROM student s0_ WHERE s0_.active = 1 GROUP BY s0_.year ORDER BY s0_.year DESC;

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.type AS type_2,
  u0_.logo AS logo_3,
  u0_.updated_at AS updated_at_4
FROM
  university u0_
  INNER JOIN student s1_ ON u0_.id = s1_.university_id
WHERE
  s1_.year = ?
  AND u0_.type = ?
ORDER BY
  u0_.name ASC,
  s1_.name ASC

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.type AS type_2, u0_.logo AS logo_3, u0_.updated_at AS updated_at_4 FROM university u0_ INNER JOIN student s1_ ON u0_.id = s1_.university_id WHERE s1_.year = 2017 AND u0_.type = 'federal' ORDER BY u0_.name ASC, s1_.name ASC;

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.type AS type_2,
  u0_.logo AS logo_3,
  u0_.updated_at AS updated_at_4
FROM
  university u0_
  INNER JOIN student s1_ ON u0_.id = s1_.university_id
WHERE
  s1_.year = ?
  AND u0_.type = ?
ORDER BY
  u0_.name ASC,
  s1_.name ASC

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.type AS type_2, u0_.logo AS logo_3, u0_.updated_at AS updated_at_4 FROM university u0_ INNER JOIN student s1_ ON u0_.id = s1_.university_id WHERE s1_.year = 2017 AND u0_.type = 'estadual' ORDER BY u0_.name ASC, s1_.name ASC;

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.type AS type_2,
  u0_.logo AS logo_3,
  u0_.updated_at AS updated_at_4
FROM
  university u0_
  INNER JOIN student s1_ ON u0_.id = s1_.university_id
WHERE
  s1_.year = ?
  AND u0_.type = ?
ORDER BY
  u0_.name ASC,
  s1_.name ASC

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.type AS type_2, u0_.logo AS logo_3, u0_.updated_at AS updated_at_4 FROM university u0_ INNER JOIN student s1_ ON u0_.id = s1_.university_id WHERE s1_.year = 2017 AND u0_.type = 'particular' ORDER BY u0_.name ASC, s1_.name ASC;

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.type AS type_2,
  u0_.logo AS logo_3,
  u0_.updated_at AS updated_at_4
FROM
  university u0_
  INNER JOIN student s1_ ON u0_.id = s1_.university_id
WHERE
  s1_.year = ?
  AND (
    u0_.type = ?
    OR u0_.type IS NULL
    OR u0_.type = ?
  )
ORDER BY
  u0_.name ASC,
  s1_.name ASC

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.type AS type_2, u0_.logo AS logo_3, u0_.updated_at AS updated_at_4 FROM university u0_ INNER JOIN student s1_ ON u0_.id = s1_.university_id WHERE s1_.year = 2017 AND (u0_.type = 'comum' OR u0_.type IS NULL OR u0_.type = '') ORDER BY u0_.name ASC, s1_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.year AS year_4,
  t0.sector AS sector_5,
  t0.featured AS featured_6,
  t0.active AS active_7,
  t0.rank AS rank_8,
  t0.updated_at AS updated_at_9,
  t0.university_id AS university_id_10,
  t0.course_id AS course_id_11
FROM
  student t0
WHERE
  t0.featured = ?
  AND t0.year = ?
  AND t0.active = ?
ORDER BY
  t0.name ASC
LIMIT
  4

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.featured = 1 AND t0.year = 2017 AND t0.active = 1 ORDER BY t0.name ASC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  course t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM course t0 WHERE t0.id = 85;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.year AS year_4,
  t0.sector AS sector_5,
  t0.featured AS featured_6,
  t0.active AS active_7,
  t0.rank AS rank_8,
  t0.updated_at AS updated_at_9,
  t0.university_id AS university_id_10,
  t0.course_id AS course_id_11
FROM
  student t0
WHERE
  t0.university_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.university_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  course t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM course t0 WHERE t0.id = 51;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.year AS year_4,
  t0.sector AS sector_5,
  t0.featured AS featured_6,
  t0.active AS active_7,
  t0.rank AS rank_8,
  t0.updated_at AS updated_at_9,
  t0.university_id AS university_id_10,
  t0.course_id AS course_id_11
FROM
  student t0
WHERE
  t0.university_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.university_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  course t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM course t0 WHERE t0.id = 212;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.year AS year_4,
  t0.sector AS sector_5,
  t0.featured AS featured_6,
  t0.active AS active_7,
  t0.rank AS rank_8,
  t0.updated_at AS updated_at_9,
  t0.university_id AS university_id_10,
  t0.course_id AS course_id_11
FROM
  student t0
WHERE
  t0.university_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.university_id = 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  course t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM course t0 WHERE t0.id = 207;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.year AS year_4,
  t0.sector AS sector_5,
  t0.featured AS featured_6,
  t0.active AS active_7,
  t0.rank AS rank_8,
  t0.updated_at AS updated_at_9,
  t0.university_id AS university_id_10,
  t0.course_id AS course_id_11
FROM
  student t0
WHERE
  t0.university_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.university_id = 13;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  course t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM course t0 WHERE t0.id = 213;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.year AS year_4,
  t0.sector AS sector_5,
  t0.featured AS featured_6,
  t0.active AS active_7,
  t0.rank AS rank_8,
  t0.updated_at AS updated_at_9,
  t0.university_id AS university_id_10,
  t0.course_id AS course_id_11
FROM
  student t0
WHERE
  t0.university_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.university_id = 17;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.year AS year_4,
  t0.sector AS sector_5,
  t0.featured AS featured_6,
  t0.active AS active_7,
  t0.rank AS rank_8,
  t0.updated_at AS updated_at_9,
  t0.university_id AS university_id_10,
  t0.course_id AS course_id_11
FROM
  student t0
WHERE
  t0.university_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.university_id = 18;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.year AS year_4,
  t0.sector AS sector_5,
  t0.featured AS featured_6,
  t0.active AS active_7,
  t0.rank AS rank_8,
  t0.updated_at AS updated_at_9,
  t0.university_id AS university_id_10,
  t0.course_id AS course_id_11
FROM
  student t0
WHERE
  t0.university_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.university_id = 24;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  course t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM course t0 WHERE t0.id = 89;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.year AS year_4,
  t0.sector AS sector_5,
  t0.featured AS featured_6,
  t0.active AS active_7,
  t0.rank AS rank_8,
  t0.updated_at AS updated_at_9,
  t0.university_id AS university_id_10,
  t0.course_id AS course_id_11
FROM
  student t0
WHERE
  t0.university_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.university_id = 26;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  course t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM course t0 WHERE t0.id = 197;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.year AS year_4,
  t0.sector AS sector_5,
  t0.featured AS featured_6,
  t0.active AS active_7,
  t0.rank AS rank_8,
  t0.updated_at AS updated_at_9,
  t0.university_id AS university_id_10,
  t0.course_id AS course_id_11
FROM
  student t0
WHERE
  t0.university_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.university_id = 27;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.year AS year_4,
  t0.sector AS sector_5,
  t0.featured AS featured_6,
  t0.active AS active_7,
  t0.rank AS rank_8,
  t0.updated_at AS updated_at_9,
  t0.university_id AS university_id_10,
  t0.course_id AS course_id_11
FROM
  student t0
WHERE
  t0.university_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.university_id = 28;