Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.researcher_id AS researcher_id_2,
  t0.daisng_id AS daisng_id_3,
  t0.bio AS bio_4,
  t0.vigent AS vigent_5,
  t0.user_id AS user_id_6
FROM
  author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.researcher_id AS researcher_id_2, t0.daisng_id AS daisng_id_3, t0.bio AS bio_4, t0.vigent AS vigent_5, t0.user_id AS user_id_6 FROM author t0 WHERE t0.id = '49';

SELECT
  CONCAT(e0_.firstname, ' ', e0_.lastname) AS sclr_0,
  COUNT(p1_.id) AS sclr_1,
  CONCAT(
    e0_.gender, ' p(', e0_.gender_probability,
    ')'
  ) AS sclr_2,
  e0_.id AS id_3
FROM
  external_author e0_
  INNER JOIN publication_author p2_ ON e0_.id = p2_.external_author_id
  INNER JOIN publication p1_ ON p2_.publication_id = p1_.id
  INNER JOIN publication_author p3_ ON p1_.id = p3_.publication_id
  INNER JOIN author a4_ ON p3_.author_id = a4_.id
WHERE
  a4_.id = ?
  AND p1_.validated = 1
GROUP BY
  e0_.id
ORDER BY
  COUNT(p1_.id) DESC

SELECT CONCAT(e0_.firstname, ' ', e0_.lastname) AS sclr_0, COUNT(p1_.id) AS sclr_1, CONCAT(e0_.gender, ' p(', e0_.gender_probability, ')') AS sclr_2, e0_.id AS id_3 FROM external_author e0_ INNER JOIN publication_author p2_ ON e0_.id = p2_.external_author_id INNER JOIN publication p1_ ON p2_.publication_id = p1_.id INNER JOIN publication_author p3_ ON p1_.id = p3_.publication_id INNER JOIN author a4_ ON p3_.author_id = a4_.id WHERE a4_.id = 49 AND p1_.validated = 1 GROUP BY e0_.id ORDER BY COUNT(p1_.id) DESC;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.researcher_id AS researcher_id_4,
  t0.daisng_id AS daisng_id_5,
  t0.gender AS gender_6,
  t0.gender_probability AS gender_probability_7
FROM
  external_author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8098;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.researcher_id AS researcher_id_4,
  t0.daisng_id AS daisng_id_5,
  t0.gender AS gender_6,
  t0.gender_probability AS gender_probability_7
FROM
  external_author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 1761;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.researcher_id AS researcher_id_4,
  t0.daisng_id AS daisng_id_5,
  t0.gender AS gender_6,
  t0.gender_probability AS gender_probability_7
FROM
  external_author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 11872;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.researcher_id AS researcher_id_4,
  t0.daisng_id AS daisng_id_5,
  t0.gender AS gender_6,
  t0.gender_probability AS gender_probability_7
FROM
  external_author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 814;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.researcher_id AS researcher_id_4,
  t0.daisng_id AS daisng_id_5,
  t0.gender AS gender_6,
  t0.gender_probability AS gender_probability_7
FROM
  external_author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8676;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.researcher_id AS researcher_id_4,
  t0.daisng_id AS daisng_id_5,
  t0.gender AS gender_6,
  t0.gender_probability AS gender_probability_7
FROM
  external_author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13031;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.researcher_id AS researcher_id_4,
  t0.daisng_id AS daisng_id_5,
  t0.gender AS gender_6,
  t0.gender_probability AS gender_probability_7
FROM
  external_author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 8677;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.researcher_id AS researcher_id_4,
  t0.daisng_id AS daisng_id_5,
  t0.gender AS gender_6,
  t0.gender_probability AS gender_probability_7
FROM
  external_author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 11873;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.researcher_id AS researcher_id_4,
  t0.daisng_id AS daisng_id_5,
  t0.gender AS gender_6,
  t0.gender_probability AS gender_probability_7
FROM
  external_author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13032;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.researcher_id AS researcher_id_4,
  t0.daisng_id AS daisng_id_5,
  t0.gender AS gender_6,
  t0.gender_probability AS gender_probability_7
FROM
  external_author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 11871;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.researcher_id AS researcher_id_4,
  t0.daisng_id AS daisng_id_5,
  t0.gender AS gender_6,
  t0.gender_probability AS gender_probability_7
FROM
  external_author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 4368;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.researcher_id AS researcher_id_4,
  t0.daisng_id AS daisng_id_5,
  t0.gender AS gender_6,
  t0.gender_probability AS gender_probability_7
FROM
  external_author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 13033;

SELECT
  CONCAT(u0_.name, ' ', u0_.last_name) AS sclr_0,
  COUNT(a1_.id) AS sclr_1,
  a1_.id AS id_2,
  a1_.vigent AS vigent_3
FROM
  author a1_
  INNER JOIN publication_author p2_ ON a1_.id = p2_.author_id
  INNER JOIN publication p3_ ON p2_.publication_id = p3_.id
  INNER JOIN publication_author p4_ ON p3_.id = p4_.publication_id
  INNER JOIN author a5_ ON p4_.author_id = a5_.id
  INNER JOIN `user` u0_ ON a1_.user_id = u0_.id
WHERE
  a5_.id = ?
  AND a1_.id <> a5_.id
  AND p3_.validated = 1
GROUP BY
  a1_.id,
  u0_.name,
  u0_.last_name
ORDER BY
  COUNT(a1_.id) DESC

SELECT CONCAT(u0_.name, ' ', u0_.last_name) AS sclr_0, COUNT(a1_.id) AS sclr_1, a1_.id AS id_2, a1_.vigent AS vigent_3 FROM author a1_ INNER JOIN publication_author p2_ ON a1_.id = p2_.author_id INNER JOIN publication p3_ ON p2_.publication_id = p3_.id INNER JOIN publication_author p4_ ON p3_.id = p4_.publication_id INNER JOIN author a5_ ON p4_.author_id = a5_.id INNER JOIN `user` u0_ ON a1_.user_id = u0_.id WHERE a5_.id = 49 AND a1_.id <> a5_.id AND p3_.validated = 1 GROUP BY a1_.id, u0_.name, u0_.last_name ORDER BY COUNT(a1_.id) DESC;

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 = 49;

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 = 230;

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 = 230;

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 = 232;

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 = 232;

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 = 239;

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 = 239;

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 = 321;