Symfony Profiler

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.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.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.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.id = '26419';

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

SELECT
  e0_.id AS id_0,
  e0_.firstname AS firstname_1,
  e0_.lastname AS lastname_2,
  e0_.researcher_id AS researcher_id_3,
  e0_.daisng_id AS daisng_id_4,
  e0_.gender AS gender_5,
  e0_.gender_probability AS gender_probability_6
FROM
  external_author e0_
WHERE
  e0_.id IN (?)

SELECT e0_.id AS id_0, e0_.firstname AS firstname_1, e0_.lastname AS lastname_2, e0_.researcher_id AS researcher_id_3, e0_.daisng_id AS daisng_id_4, e0_.gender AS gender_5, e0_.gender_probability AS gender_probability_6 FROM external_author e0_ WHERE e0_.id IN ('7633');

SELECT
  a0_.id AS id_0,
  a0_.researcher_id AS researcher_id_1,
  a0_.daisng_id AS daisng_id_2,
  a0_.user_id AS user_id_3
FROM
  author a0_
WHERE
  a0_.id IN (?)

SELECT a0_.id AS id_0, a0_.researcher_id AS researcher_id_1, a0_.daisng_id AS daisng_id_2, a0_.user_id AS user_id_3 FROM author a0_ WHERE a0_.id IN ('211');

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  publication_author
SET
  externalAuthor_id = ?,
  author_id = ?
WHERE
  id = ?

UPDATE publication_author SET externalAuthor_id = NULL, author_id = 211 WHERE id = 26419;

"COMMIT"

"COMMIT";

DELETE FROM
  publication_author
WHERE
  publication_id IS NULL
  AND author_id IS NOT NULL

DELETE FROM publication_author WHERE publication_id IS NULL AND author_id IS NOT NULL;