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 = '71';

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 = 71 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 = 7407;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 = ?