Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.research_line AS research_line_1,
          r0_.sort AS sort_2,
          a1_.id AS id_3,
          a1_.researcher_id AS researcher_id_4,
          a1_.daisng_id AS daisng_id_5,
          a1_.bio AS bio_6,
          a1_.vigent AS vigent_7
        FROM
          research_line r0_
          INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id
          INNER JOIN author a1_ ON a1_.id = a2_.author_id
        WHERE
          a1_.vigent = 1
        ORDER BY
          r0_.sort ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.research_line AS research_line_1, r0_.sort AS sort_2, a1_.id AS id_3, a1_.researcher_id AS researcher_id_4, a1_.daisng_id AS daisng_id_5, a1_.bio AS bio_6, a1_.vigent AS vigent_7 FROM research_line r0_ INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id INNER JOIN author a1_ ON a1_.id = a2_.author_id WHERE a1_.vigent = 1 ORDER BY r0_.sort ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sort_2
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.research_line AS research_line_1,
          r0_.sort AS sort_2,
          a1_.id AS id_3,
          a1_.researcher_id AS researcher_id_4,
          a1_.daisng_id AS daisng_id_5,
          a1_.bio AS bio_6,
          a1_.vigent AS vigent_7
        FROM
          research_line r0_
          INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id
          INNER JOIN author a1_ ON a1_.id = a2_.author_id
        WHERE
          a1_.vigent = 1
      ) dctrn_result_inner
    ORDER BY
      sort_2 ASC
  ) dctrn_result
LIMIT
  4
OFFSET
  116

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sort_2 FROM (SELECT r0_.id AS id_0, r0_.research_line AS research_line_1, r0_.sort AS sort_2, a1_.id AS id_3, a1_.researcher_id AS researcher_id_4, a1_.daisng_id AS daisng_id_5, a1_.bio AS bio_6, a1_.vigent AS vigent_7 FROM research_line r0_ INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id INNER JOIN author a1_ ON a1_.id = a2_.author_id WHERE a1_.vigent = 1) dctrn_result_inner ORDER BY sort_2 ASC) dctrn_result LIMIT 4 OFFSET 116;

SELECT
  r0_.id AS id_0,
  r0_.research_line AS research_line_1,
  r0_.sort AS sort_2,
  a1_.id AS id_3,
  a1_.researcher_id AS researcher_id_4,
  a1_.daisng_id AS daisng_id_5,
  a1_.bio AS bio_6,
  a1_.vigent AS vigent_7,
  a1_.user_id AS user_id_8
FROM
  research_line r0_
  INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id
  INNER JOIN author a1_ ON a1_.id = a2_.author_id
WHERE
  a1_.vigent = 1
  AND r0_.id IN (?, ?, ?, ?)
ORDER BY
  r0_.sort ASC

SELECT r0_.id AS id_0, r0_.research_line AS research_line_1, r0_.sort AS sort_2, a1_.id AS id_3, a1_.researcher_id AS researcher_id_4, a1_.daisng_id AS daisng_id_5, a1_.bio AS bio_6, a1_.vigent AS vigent_7, a1_.user_id AS user_id_8 FROM research_line r0_ INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id INNER JOIN author a1_ ON a1_.id = a2_.author_id WHERE a1_.vigent = 1 AND r0_.id IN (34, 92, 159, 36) ORDER BY r0_.sort ASC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.last_name AS last_name_6,
  t0.rut AS rut_7,
  t0.sex AS sex_8,
  t0.photo AS photo_9,
  t10.id AS id_11,
  t10.researcher_id AS researcher_id_12,
  t10.daisng_id AS daisng_id_13,
  t10.bio AS bio_14,
  t10.vigent AS vigent_15,
  t10.user_id AS user_id_16
FROM
  `user` t0
  LEFT JOIN author t10 ON t10.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.rut AS rut_7, t0.sex AS sex_8, t0.photo AS photo_9, t10.id AS id_11, t10.researcher_id AS researcher_id_12, t10.daisng_id AS daisng_id_13, t10.bio AS bio_14, t10.vigent AS vigent_15, t10.user_id AS user_id_16 FROM `user` t0 LEFT JOIN author t10 ON t10.user_id = t0.id WHERE t0.id = 27;

SELECT
  t0.id AS id_1,
  t0.research_line AS research_line_2,
  t0.sort AS sort_3
FROM
  research_line t0
  INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id
WHERE
  author_research_line.author_id = ?

SELECT t0.id AS id_1, t0.research_line AS research_line_2, t0.sort AS sort_3 FROM research_line t0 INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id WHERE author_research_line.author_id = 26;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.last_name AS last_name_6,
  t0.rut AS rut_7,
  t0.sex AS sex_8,
  t0.photo AS photo_9,
  t10.id AS id_11,
  t10.researcher_id AS researcher_id_12,
  t10.daisng_id AS daisng_id_13,
  t10.bio AS bio_14,
  t10.vigent AS vigent_15,
  t10.user_id AS user_id_16
FROM
  `user` t0
  LEFT JOIN author t10 ON t10.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.rut AS rut_7, t0.sex AS sex_8, t0.photo AS photo_9, t10.id AS id_11, t10.researcher_id AS researcher_id_12, t10.daisng_id AS daisng_id_13, t10.bio AS bio_14, t10.vigent AS vigent_15, t10.user_id AS user_id_16 FROM `user` t0 LEFT JOIN author t10 ON t10.user_id = t0.id WHERE t0.id = 55;

SELECT
  t0.id AS id_1,
  t0.research_line AS research_line_2,
  t0.sort AS sort_3
FROM
  research_line t0
  INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id
WHERE
  author_research_line.author_id = ?

SELECT t0.id AS id_1, t0.research_line AS research_line_2, t0.sort AS sort_3 FROM research_line t0 INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id WHERE author_research_line.author_id = 54;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.last_name AS last_name_6,
  t0.rut AS rut_7,
  t0.sex AS sex_8,
  t0.photo AS photo_9,
  t10.id AS id_11,
  t10.researcher_id AS researcher_id_12,
  t10.daisng_id AS daisng_id_13,
  t10.bio AS bio_14,
  t10.vigent AS vigent_15,
  t10.user_id AS user_id_16
FROM
  `user` t0
  LEFT JOIN author t10 ON t10.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.rut AS rut_7, t0.sex AS sex_8, t0.photo AS photo_9, t10.id AS id_11, t10.researcher_id AS researcher_id_12, t10.daisng_id AS daisng_id_13, t10.bio AS bio_14, t10.vigent AS vigent_15, t10.user_id AS user_id_16 FROM `user` t0 LEFT JOIN author t10 ON t10.user_id = t0.id WHERE t0.id = 96;

SELECT
  t0.id AS id_1,
  t0.research_line AS research_line_2,
  t0.sort AS sort_3
FROM
  research_line t0
  INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id
WHERE
  author_research_line.author_id = ?

SELECT t0.id AS id_1, t0.research_line AS research_line_2, t0.sort AS sort_3 FROM research_line t0 INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id WHERE author_research_line.author_id = 97;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.last_name AS last_name_6,
  t0.rut AS rut_7,
  t0.sex AS sex_8,
  t0.photo AS photo_9,
  t10.id AS id_11,
  t10.researcher_id AS researcher_id_12,
  t10.daisng_id AS daisng_id_13,
  t10.bio AS bio_14,
  t10.vigent AS vigent_15,
  t10.user_id AS user_id_16
FROM
  `user` t0
  LEFT JOIN author t10 ON t10.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.rut AS rut_7, t0.sex AS sex_8, t0.photo AS photo_9, t10.id AS id_11, t10.researcher_id AS researcher_id_12, t10.daisng_id AS daisng_id_13, t10.bio AS bio_14, t10.vigent AS vigent_15, t10.user_id AS user_id_16 FROM `user` t0 LEFT JOIN author t10 ON t10.user_id = t0.id WHERE t0.id = 30;

SELECT
  t0.id AS id_1,
  t0.research_line AS research_line_2,
  t0.sort AS sort_3
FROM
  research_line t0
  INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id
WHERE
  author_research_line.author_id = ?

SELECT t0.id AS id_1, t0.research_line AS research_line_2, t0.sort AS sort_3 FROM research_line t0 INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id WHERE author_research_line.author_id = 29;