Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.iso_abbrev AS iso_abbrev_2,
  p0_.issn AS issn_3,
  p0_.eissn AS eissn_4,
  p0_.impact_factor AS impact_factor_5,
  p0_.percentile AS percentile_6,
  p0_.q AS q_7,
  p0_.year AS year_8
FROM
  publisher p0_

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.iso_abbrev AS iso_abbrev_2, p0_.issn AS issn_3, p0_.eissn AS eissn_4, p0_.impact_factor AS impact_factor_5, p0_.percentile AS percentile_6, p0_.q AS q_7, p0_.year AS year_8 FROM publisher p0_;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.name AS name_4,
  t0.last_name AS last_name_5,
  t0.rut AS rut_6,
  t0.sex AS sex_7,
  t8.id AS id_9,
  t8.researcher_id AS researcher_id_10,
  t8.daisng_id AS daisng_id_11,
  t8.user_id AS user_id_12
FROM
  user t0
  LEFT JOIN author t8 ON t8.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.rut AS rut_6, t0.sex AS sex_7, t8.id AS id_9, t8.researcher_id AS researcher_id_10, t8.daisng_id AS daisng_id_11, t8.user_id AS user_id_12 FROM user t0 LEFT JOIN author t8 ON t8.user_id = t0.id WHERE t0.id = 190;

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.externalAuthor_id AS externalAuthor_id_9,
  t0.author_id AS author_id_10,
  t0.publication_id AS publication_id_11
FROM
  publication_author t0
WHERE
  t0.publication_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.externalAuthor_id AS externalAuthor_id_9, t0.author_id AS author_id_10, t0.publication_id AS publication_id_11 FROM publication_author t0 WHERE t0.publication_id = 2889;

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.city AS city_3,
  t0.country AS country_4
FROM
  organization t0
  INNER JOIN publicationAuthors_organizations ON t0.id = publicationAuthors_organizations.organization_id
WHERE
  publicationAuthors_organizations.publication_author_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publicationAuthors_organizations ON t0.id = publicationAuthors_organizations.organization_id WHERE publicationAuthors_organizations.publication_author_id = 26350;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.issn AS issn_3,
  t0.isbn AS isbn_4,
  t0.e_issn AS e_issn_5
FROM
  journal t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.issn AS issn_3, t0.isbn AS isbn_4, t0.e_issn AS e_issn_5 FROM journal t0 WHERE t0.id = 632;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.text AS text_3
FROM
  role t0
  INNER JOIN users_userRoles ON t0.id = users_userRoles.role_id
WHERE
  users_userRoles.user_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.text AS text_3 FROM role t0 INNER JOIN users_userRoles ON t0.id = users_userRoles.role_id WHERE users_userRoles.user_id = 190;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.iso_abbrev AS iso_abbrev_3,
  t0.issn AS issn_4,
  t0.eissn AS eissn_5,
  t0.impact_factor AS impact_factor_6,
  t0.percentile AS percentile_7,
  t0.q AS q_8,
  t0.year AS year_9
FROM
  publisher t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.iso_abbrev AS iso_abbrev_3, t0.issn AS issn_4, t0.eissn AS eissn_5, t0.impact_factor AS impact_factor_6, t0.percentile AS percentile_7, t0.q AS q_8, t0.year AS year_9 FROM publisher t0 WHERE t0.id = 1;