Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          k0_.id AS id_0,
          k0_.keyword AS keyword_1,
          k0_.in_stop_list AS in_stop_list_2,
          k0_.sort AS sort_3,
          p1_.id AS id_4,
          p1_.title AS title_5,
          p1_.ut AS ut_6,
          p1_.doctype AS doctype_7,
          p1_.pages AS pages_8,
          p1_.issue AS issue_9,
          p1_.volume AS volume_10,
          p1_.published_month AS published_month_11,
          p1_.published_year AS published_year_12,
          p1_.doi AS doi_13,
          p1_.issn AS issn_14,
          p1_.isbn AS isbn_15,
          p1_.updated_date AS updated_date_16,
          p1_.abstract AS abstract_17,
          p1_.times_cited AS times_cited_18,
          p1_.funding_text AS funding_text_19,
          p1_.interdisciplinary AS interdisciplinary_20,
          p1_.validated AS validated_21,
          p1_.siding_id AS siding_id_22,
          p1_.public_comments AS public_comments_23,
          p1_.private_comments AS private_comments_24,
          p1_.publication_type AS publication_type_25,
          p2_.id AS id_26,
          p2_.firstname AS firstname_27,
          p2_.lastname AS lastname_28,
          p2_.participation AS participation_29,
          p2_.master_student AS master_student_30,
          p2_.phd_student AS phd_student_31,
          p2_.uc_not_ing AS uc_not_ing_32,
          p2_.postdoc AS postdoc_33,
          a3_.id AS id_34,
          a3_.researcher_id AS researcher_id_35,
          a3_.daisng_id AS daisng_id_36,
          a3_.bio AS bio_37,
          a3_.vigent AS vigent_38
        FROM
          keyword k0_
          INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id
          INNER JOIN publication p1_ ON p1_.id = k4_.publication_id
          INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id
          INNER JOIN author a3_ ON p2_.author_id = a3_.id
        WHERE
          p1_.validated = 1
          AND a3_.vigent = 1
          AND k0_.keyword LIKE ?
        ORDER BY
          k0_.sort ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT k0_.id AS id_0, k0_.keyword AS keyword_1, k0_.in_stop_list AS in_stop_list_2, k0_.sort AS sort_3, p1_.id AS id_4, p1_.title AS title_5, p1_.ut AS ut_6, p1_.doctype AS doctype_7, p1_.pages AS pages_8, p1_.issue AS issue_9, p1_.volume AS volume_10, p1_.published_month AS published_month_11, p1_.published_year AS published_year_12, p1_.doi AS doi_13, p1_.issn AS issn_14, p1_.isbn AS isbn_15, p1_.updated_date AS updated_date_16, p1_.abstract AS abstract_17, p1_.times_cited AS times_cited_18, p1_.funding_text AS funding_text_19, p1_.interdisciplinary AS interdisciplinary_20, p1_.validated AS validated_21, p1_.siding_id AS siding_id_22, p1_.public_comments AS public_comments_23, p1_.private_comments AS private_comments_24, p1_.publication_type AS publication_type_25, p2_.id AS id_26, p2_.firstname AS firstname_27, p2_.lastname AS lastname_28, p2_.participation AS participation_29, p2_.master_student AS master_student_30, p2_.phd_student AS phd_student_31, p2_.uc_not_ing AS uc_not_ing_32, p2_.postdoc AS postdoc_33, a3_.id AS id_34, a3_.researcher_id AS researcher_id_35, a3_.daisng_id AS daisng_id_36, a3_.bio AS bio_37, a3_.vigent AS vigent_38 FROM keyword k0_ INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id INNER JOIN publication p1_ ON p1_.id = k4_.publication_id INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id INNER JOIN author a3_ ON p2_.author_id = a3_.id WHERE p1_.validated = 1 AND a3_.vigent = 1 AND k0_.keyword LIKE '%Historical Urban Center%' ORDER BY k0_.sort ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sort_3
    FROM
      (
        SELECT
          k0_.id AS id_0,
          k0_.keyword AS keyword_1,
          k0_.in_stop_list AS in_stop_list_2,
          k0_.sort AS sort_3,
          p1_.id AS id_4,
          p1_.title AS title_5,
          p1_.ut AS ut_6,
          p1_.doctype AS doctype_7,
          p1_.pages AS pages_8,
          p1_.issue AS issue_9,
          p1_.volume AS volume_10,
          p1_.published_month AS published_month_11,
          p1_.published_year AS published_year_12,
          p1_.doi AS doi_13,
          p1_.issn AS issn_14,
          p1_.isbn AS isbn_15,
          p1_.updated_date AS updated_date_16,
          p1_.abstract AS abstract_17,
          p1_.times_cited AS times_cited_18,
          p1_.funding_text AS funding_text_19,
          p1_.interdisciplinary AS interdisciplinary_20,
          p1_.validated AS validated_21,
          p1_.siding_id AS siding_id_22,
          p1_.public_comments AS public_comments_23,
          p1_.private_comments AS private_comments_24,
          p1_.publication_type AS publication_type_25,
          p2_.id AS id_26,
          p2_.firstname AS firstname_27,
          p2_.lastname AS lastname_28,
          p2_.participation AS participation_29,
          p2_.master_student AS master_student_30,
          p2_.phd_student AS phd_student_31,
          p2_.uc_not_ing AS uc_not_ing_32,
          p2_.postdoc AS postdoc_33,
          a3_.id AS id_34,
          a3_.researcher_id AS researcher_id_35,
          a3_.daisng_id AS daisng_id_36,
          a3_.bio AS bio_37,
          a3_.vigent AS vigent_38
        FROM
          keyword k0_
          INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id
          INNER JOIN publication p1_ ON p1_.id = k4_.publication_id
          INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id
          INNER JOIN author a3_ ON p2_.author_id = a3_.id
        WHERE
          p1_.validated = 1
          AND a3_.vigent = 1
          AND k0_.keyword LIKE ?
      ) dctrn_result_inner
    ORDER BY
      sort_3 ASC
  ) dctrn_result
LIMIT
  4

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sort_3 FROM (SELECT k0_.id AS id_0, k0_.keyword AS keyword_1, k0_.in_stop_list AS in_stop_list_2, k0_.sort AS sort_3, p1_.id AS id_4, p1_.title AS title_5, p1_.ut AS ut_6, p1_.doctype AS doctype_7, p1_.pages AS pages_8, p1_.issue AS issue_9, p1_.volume AS volume_10, p1_.published_month AS published_month_11, p1_.published_year AS published_year_12, p1_.doi AS doi_13, p1_.issn AS issn_14, p1_.isbn AS isbn_15, p1_.updated_date AS updated_date_16, p1_.abstract AS abstract_17, p1_.times_cited AS times_cited_18, p1_.funding_text AS funding_text_19, p1_.interdisciplinary AS interdisciplinary_20, p1_.validated AS validated_21, p1_.siding_id AS siding_id_22, p1_.public_comments AS public_comments_23, p1_.private_comments AS private_comments_24, p1_.publication_type AS publication_type_25, p2_.id AS id_26, p2_.firstname AS firstname_27, p2_.lastname AS lastname_28, p2_.participation AS participation_29, p2_.master_student AS master_student_30, p2_.phd_student AS phd_student_31, p2_.uc_not_ing AS uc_not_ing_32, p2_.postdoc AS postdoc_33, a3_.id AS id_34, a3_.researcher_id AS researcher_id_35, a3_.daisng_id AS daisng_id_36, a3_.bio AS bio_37, a3_.vigent AS vigent_38 FROM keyword k0_ INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id INNER JOIN publication p1_ ON p1_.id = k4_.publication_id INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id INNER JOIN author a3_ ON p2_.author_id = a3_.id WHERE p1_.validated = 1 AND a3_.vigent = 1 AND k0_.keyword LIKE '%Historical Urban Center%') dctrn_result_inner ORDER BY sort_3 ASC) dctrn_result LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.ut AS ut_3,
  t0.doctype AS doctype_4,
  t0.pages AS pages_5,
  t0.issue AS issue_6,
  t0.volume AS volume_7,
  t0.published_month AS published_month_8,
  t0.published_year AS published_year_9,
  t0.doi AS doi_10,
  t0.issn AS issn_11,
  t0.isbn AS isbn_12,
  t0.updated_date AS updated_date_13,
  t0.abstract AS abstract_14,
  t0.times_cited AS times_cited_15,
  t0.funding_text AS funding_text_16,
  t0.interdisciplinary AS interdisciplinary_17,
  t0.validated AS validated_18,
  t0.siding_id AS siding_id_19,
  t0.public_comments AS public_comments_20,
  t0.private_comments AS private_comments_21,
  t0.publication_type AS publication_type_22,
  t0.journal_id AS journal_id_23,
  t0.publisher_id AS publisher_id_24
FROM
  publication t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = 778;

SELECT
  t0.id AS id_1,
  t0.keyword AS keyword_2,
  t0.in_stop_list AS in_stop_list_3,
  t0.sort AS sort_4
FROM
  keyword t0
  INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id
WHERE
  keyword_publication.publication_id = ?

SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = 1940;

SELECT
  k0_.id AS id_0,
  k0_.keyword AS keyword_1,
  k0_.in_stop_list AS in_stop_list_2,
  k0_.sort AS sort_3,
  p1_.id AS id_4,
  p1_.title AS title_5,
  p1_.ut AS ut_6,
  p1_.doctype AS doctype_7,
  p1_.pages AS pages_8,
  p1_.issue AS issue_9,
  p1_.volume AS volume_10,
  p1_.published_month AS published_month_11,
  p1_.published_year AS published_year_12,
  p1_.doi AS doi_13,
  p1_.issn AS issn_14,
  p1_.isbn AS isbn_15,
  p1_.updated_date AS updated_date_16,
  p1_.abstract AS abstract_17,
  p1_.times_cited AS times_cited_18,
  p1_.funding_text AS funding_text_19,
  p1_.interdisciplinary AS interdisciplinary_20,
  p1_.validated AS validated_21,
  p1_.siding_id AS siding_id_22,
  p1_.public_comments AS public_comments_23,
  p1_.private_comments AS private_comments_24,
  p1_.publication_type AS publication_type_25,
  p2_.id AS id_26,
  p2_.firstname AS firstname_27,
  p2_.lastname AS lastname_28,
  p2_.participation AS participation_29,
  p2_.master_student AS master_student_30,
  p2_.phd_student AS phd_student_31,
  p2_.uc_not_ing AS uc_not_ing_32,
  p2_.postdoc AS postdoc_33,
  a3_.id AS id_34,
  a3_.researcher_id AS researcher_id_35,
  a3_.daisng_id AS daisng_id_36,
  a3_.bio AS bio_37,
  a3_.vigent AS vigent_38,
  p1_.journal_id AS journal_id_39,
  p1_.publisher_id AS publisher_id_40,
  p2_.author_id AS author_id_41,
  p2_.publication_id AS publication_id_42,
  p2_.external_author_id AS external_author_id_43,
  a3_.user_id AS user_id_44
FROM
  keyword k0_
  INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id
  INNER JOIN publication p1_ ON p1_.id = k4_.publication_id
  INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id
  INNER JOIN author a3_ ON p2_.author_id = a3_.id
WHERE
  p1_.validated = 1
  AND a3_.vigent = 1
  AND k0_.keyword LIKE ?
  AND k0_.id IN (?)
ORDER BY
  k0_.sort ASC

SELECT k0_.id AS id_0, k0_.keyword AS keyword_1, k0_.in_stop_list AS in_stop_list_2, k0_.sort AS sort_3, p1_.id AS id_4, p1_.title AS title_5, p1_.ut AS ut_6, p1_.doctype AS doctype_7, p1_.pages AS pages_8, p1_.issue AS issue_9, p1_.volume AS volume_10, p1_.published_month AS published_month_11, p1_.published_year AS published_year_12, p1_.doi AS doi_13, p1_.issn AS issn_14, p1_.isbn AS isbn_15, p1_.updated_date AS updated_date_16, p1_.abstract AS abstract_17, p1_.times_cited AS times_cited_18, p1_.funding_text AS funding_text_19, p1_.interdisciplinary AS interdisciplinary_20, p1_.validated AS validated_21, p1_.siding_id AS siding_id_22, p1_.public_comments AS public_comments_23, p1_.private_comments AS private_comments_24, p1_.publication_type AS publication_type_25, p2_.id AS id_26, p2_.firstname AS firstname_27, p2_.lastname AS lastname_28, p2_.participation AS participation_29, p2_.master_student AS master_student_30, p2_.phd_student AS phd_student_31, p2_.uc_not_ing AS uc_not_ing_32, p2_.postdoc AS postdoc_33, a3_.id AS id_34, a3_.researcher_id AS researcher_id_35, a3_.daisng_id AS daisng_id_36, a3_.bio AS bio_37, a3_.vigent AS vigent_38, p1_.journal_id AS journal_id_39, p1_.publisher_id AS publisher_id_40, p2_.author_id AS author_id_41, p2_.publication_id AS publication_id_42, p2_.external_author_id AS external_author_id_43, a3_.user_id AS user_id_44 FROM keyword k0_ INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id INNER JOIN publication p1_ ON p1_.id = k4_.publication_id INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id INNER JOIN author a3_ ON p2_.author_id = a3_.id WHERE p1_.validated = 1 AND a3_.vigent = 1 AND k0_.keyword LIKE '%Historical Urban Center%' AND k0_.id IN (6251) ORDER BY k0_.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 = 100;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.participation AS participation_4,
  t0.master_student AS master_student_5,
  t0.phd_student AS phd_student_6,
  t0.uc_not_ing AS uc_not_ing_7,
  t0.postdoc AS postdoc_8,
  t0.author_id AS author_id_9,
  t0.publication_id AS publication_id_10,
  t0.external_author_id AS external_author_id_11
FROM
  publication_author t0
WHERE
  t0.author_id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.author_id = 101;