Symfony Profiler

SELECT
  *
FROM
  external_contacts
WHERE
  `external_contacts`.`email` = ?
LIMIT
  1

SELECT * FROM external_contacts WHERE `external_contacts`.`email`='weichao.yu@mdpi.com' LIMIT 1;

SELECT
  *
FROM
  english_editor_profile
WHERE
  `english_editor_profile`.`user_id` = ?
LIMIT
  1

SELECT * FROM english_editor_profile WHERE `english_editor_profile`.`user_id`=113953 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.firstname AS firstname_4,
  t0.middlename AS middlename_5,
  t0.lastname AS lastname_6,
  t0.status AS status_7,
  t0.active AS active_8,
  t0.date_registered AS date_registered_9,
  t0.application AS application_10
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.firstname AS firstname_4, t0.middlename AS middlename_5, t0.lastname AS lastname_6, t0.status AS status_7, t0.active AS active_8, t0.date_registered AS date_registered_9, t0.application AS application_10 FROM users t0 WHERE t0.id = 113953;

SELECT
  submission_reviewers.*,
  submission_reviewer_additional_info.*
FROM
  submission_reviewers
  LEFT JOIN submission_reviewer_additional_info ON (
    submission_reviewers.id = submission_reviewer_additional_info.submission_reviewer_id
  )
WHERE
  submission_reviewers.email = ?
LIMIT
  1

SELECT submission_reviewers.*, submission_reviewer_additional_info.* FROM submission_reviewers LEFT JOIN submission_reviewer_additional_info ON (submission_reviewers.id = submission_reviewer_additional_info.submission_reviewer_id) WHERE submission_reviewers.email = 'weichao.yu@mdpi.com' LIMIT 1;

SELECT
  users.*,
  employees.*,
  editors.*,
  user_title.*
FROM
  users
  LEFT JOIN employees ON (employees.user_id = users.id)
  LEFT JOIN editors ON (editors.id = users.editor_id)
  LEFT JOIN user_title ON (user_title.id = users.title_id)
WHERE
  users.email = ?
LIMIT
  1

SELECT users.*, employees.*, editors.*, user_title.* FROM users LEFT JOIN employees ON (employees.user_id = users.id) LEFT JOIN editors ON (editors.id = users.editor_id) LEFT JOIN user_title ON (user_title.id = users.title_id) WHERE users.email = 'weichao.yu@mdpi.com' LIMIT 1;

SELECT
  *
FROM
  editors
WHERE
  `editors`.`email` = ?
LIMIT
  1

SELECT * FROM editors WHERE `editors`.`email`='weichao.yu@mdpi.com' LIMIT 1;

SELECT
  *
FROM
  editors
WHERE
  `editors`.`email` = ?
LIMIT
  1

SELECT * FROM editors WHERE `editors`.`email`='' LIMIT 1;

SELECT
  *
FROM
  submission_manuscript
WHERE
  `submission_manuscript`.`hash_key` = ?
LIMIT
  1

SELECT * FROM submission_manuscript WHERE `submission_manuscript`.`hash_key`='8f80ac65da412e90cfbff88b42e28cf9' LIMIT 1;

SELECT
  *
FROM
  submission_manuscript
WHERE
  `submission_manuscript`.`hash_key` = ?
LIMIT
  1

SELECT * FROM submission_manuscript WHERE `submission_manuscript`.`hash_key`='fe444d01a7933387335fa1d65d83c6a3' LIMIT 1;

SELECT
  *
FROM
  submission_manuscript
WHERE
  `submission_manuscript`.`hash_key` = ?
LIMIT
  1

SELECT * FROM submission_manuscript WHERE `submission_manuscript`.`hash_key`='67bb9de250b71c44c432d4ebeb16df3d' LIMIT 1;

SELECT
  *
FROM
  submission_manuscript
WHERE
  `submission_manuscript`.`hash_key` = ?
LIMIT
  1

SELECT * FROM submission_manuscript WHERE `submission_manuscript`.`hash_key`='17c81362abac16192f857acdb7dc0ff4' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.editor_id AS editor_id_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.title_id AS title_id_5,
  t0.firstname AS firstname_6,
  t0.middlename AS middlename_7,
  t0.lastname AS lastname_8,
  t0.department AS department_9,
  t0.organization AS organization_10,
  t0.address1 AS address1_11,
  t0.address2 AS address2_12,
  t0.city AS city_13,
  t0.state AS state_14,
  t0.zipcode AS zipcode_15,
  t0.country_id AS country_id_16,
  t0.telephone AS telephone_17,
  t0.fax AS fax_18,
  t0.workplace_id AS workplace_id_19,
  t0.jobtype_id AS jobtype_id_20,
  t0.research_keywords AS research_keywords_21,
  t0.ip AS ip_22,
  t0.status AS status_23,
  t0.active AS active_24,
  t0.date_registered AS date_registered_25,
  t0.alert_frequency AS alert_frequency_26,
  t0.alert_last_success AS alert_last_success_27,
  t0.signature AS signature_28,
  t0.orcid AS orcid_29,
  t0.application AS application_30,
  t0.facebook AS facebook_31,
  t0.twitter AS twitter_32,
  t0.skype AS skype_33,
  t0.is_subscribed AS is_subscribed_34,
  t0.has_hypothesis_account AS has_hypothesis_account_35,
  t0.image AS image_36,
  t0.hinted AS hinted_37,
  t0.pronouns AS pronouns_38,
  t0.editor_id AS editor_id_39,
  t0.title_id AS title_id_40,
  t41.id AS id_42,
  t41.user_id AS user_id_43,
  t41.title AS title_44,
  t41.degree AS degree_45,
  t41.sex AS sex_46,
  t41.firstname AS firstname_47,
  t41.middlename AS middlename_48,
  t41.lastname AS lastname_49,
  t41.biography AS biography_50,
  t41.birthdate AS birthdate_51,
  t41.position AS position_52,
  t41.section_id AS section_id_53,
  t41.position_id AS position_id_54,
  t41.order_id AS order_id_55,
  t41.max_number AS max_number_56,
  t41.image AS image_57,
  t41.date_updated AS date_updated_58,
  t41.user_id AS user_id_59,
  t41.position_id AS position_id_60
FROM
  users t0
  LEFT JOIN employees t41 ON t41.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.editor_id AS editor_id_2, t0.email AS email_3, t0.password AS password_4, t0.title_id AS title_id_5, t0.firstname AS firstname_6, t0.middlename AS middlename_7, t0.lastname AS lastname_8, t0.department AS department_9, t0.organization AS organization_10, t0.address1 AS address1_11, t0.address2 AS address2_12, t0.city AS city_13, t0.state AS state_14, t0.zipcode AS zipcode_15, t0.country_id AS country_id_16, t0.telephone AS telephone_17, t0.fax AS fax_18, t0.workplace_id AS workplace_id_19, t0.jobtype_id AS jobtype_id_20, t0.research_keywords AS research_keywords_21, t0.ip AS ip_22, t0.status AS status_23, t0.active AS active_24, t0.date_registered AS date_registered_25, t0.alert_frequency AS alert_frequency_26, t0.alert_last_success AS alert_last_success_27, t0.signature AS signature_28, t0.orcid AS orcid_29, t0.application AS application_30, t0.facebook AS facebook_31, t0.twitter AS twitter_32, t0.skype AS skype_33, t0.is_subscribed AS is_subscribed_34, t0.has_hypothesis_account AS has_hypothesis_account_35, t0.image AS image_36, t0.hinted AS hinted_37, t0.pronouns AS pronouns_38, t0.editor_id AS editor_id_39, t0.title_id AS title_id_40, t41.id AS id_42, t41.user_id AS user_id_43, t41.title AS title_44, t41.degree AS degree_45, t41.sex AS sex_46, t41.firstname AS firstname_47, t41.middlename AS middlename_48, t41.lastname AS lastname_49, t41.biography AS biography_50, t41.birthdate AS birthdate_51, t41.position AS position_52, t41.section_id AS section_id_53, t41.position_id AS position_id_54, t41.order_id AS order_id_55, t41.max_number AS max_number_56, t41.image AS image_57, t41.date_updated AS date_updated_58, t41.user_id AS user_id_59, t41.position_id AS position_id_60 FROM users t0 LEFT JOIN employees t41 ON t41.user_id = t0.id WHERE t0.id = 113953;

SELECT
  users_roles_rels.*,
  users_roles_types.*,
  submission_users_roles.*
FROM
  users_roles_rels
  LEFT JOIN users_roles_types ON (
    users_roles_rels.role_id = users_roles_types.role_id
  )
  LEFT JOIN submission_users_roles ON (
    users_roles_rels.role_id = submission_users_roles.id
  )
WHERE
  users_roles_rels.user_id = ?
ORDER BY
  submission_users_roles.desc ASC

SELECT users_roles_rels.*, users_roles_types.*, submission_users_roles.* FROM users_roles_rels LEFT JOIN users_roles_types ON (users_roles_rels.role_id = users_roles_types.role_id) LEFT JOIN submission_users_roles ON (users_roles_rels.role_id = submission_users_roles.id) WHERE users_roles_rels.user_id = 113953 ORDER BY submission_users_roles.desc ASC;

SELECT
  *
FROM
  user_menus
WHERE
  `user_menus`.`user_id` = ?
LIMIT
  1

SELECT * FROM user_menus WHERE `user_menus`.`user_id`=113953 LIMIT 1;

SELECT
  journal_id
FROM
  user_grant_journal_rels
WHERE
  grant_type = ?
  AND user_id = ?

SELECT journal_id FROM user_grant_journal_rels WHERE grant_type = 12 AND user_id = 113953;

SELECT
  *
FROM
  user_grant_journal_rels
WHERE
  `user_grant_journal_rels`.`user_id` = ?
  AND `user_grant_journal_rels`.`grant_type` = ?

SELECT * FROM user_grant_journal_rels WHERE `user_grant_journal_rels`.`user_id`=113953 AND `user_grant_journal_rels`.`grant_type`=8;

SELECT
  *
FROM
  user_multiple_email
WHERE
  `user_multiple_email`.`user_id` = ?

SELECT * FROM user_multiple_email WHERE `user_multiple_email`.`user_id`=113953;

SELECT
  *
FROM
  membership_institutes
WHERE
  email IN ('weichao.yu@mdpi.com')
  AND is_susy_enabled = 1
  AND status_id = ?

SELECT * FROM membership_institutes WHERE email IN ('weichao.yu@mdpi.com') AND is_susy_enabled = 1 AND status_id = 3;

SELECT
  c.*
FROM
  membership_institutes a
  INNER JOIN membership_institute_admin b ON (b.membership_id = a.id)
  LEFT JOIN membership_institutes c ON (c.email = a.email)
WHERE
  b.user_id = ?
  AND c.is_susy_enabled = 1
  AND c.status_id = ?

SELECT c.* FROM membership_institutes a INNER JOIN membership_institute_admin b ON (b.membership_id = a.id) LEFT JOIN membership_institutes c ON (c.email = a.email) WHERE b.user_id = 113953 AND c.is_susy_enabled = 1 AND c.status_id = 3;

SELECT
  *
FROM
  membership_institute_consortiums
WHERE
  email IN ('weichao.yu@mdpi.com')

SELECT * FROM membership_institute_consortiums WHERE email IN ('weichao.yu@mdpi.com');

SELECT
  *
FROM
  membership_institutes
WHERE
  email IN ('weichao.yu@mdpi.com')
  AND is_susy_enabled = 1
  AND status_id = ?

SELECT * FROM membership_institutes WHERE email IN ('weichao.yu@mdpi.com') AND is_susy_enabled = 1 AND status_id = 3;

SELECT
  COUNT(submission_authors.hash_key)
FROM
  submission_authors
  LEFT JOIN submission_manuscript ON (
    submission_manuscript.hash_key = submission_authors.hash_key
  )
WHERE
  submission_authors.email = ?
  AND submission_manuscript.article_author_id != ?

SELECT COUNT(submission_authors.hash_key) FROM submission_authors LEFT JOIN submission_manuscript ON (submission_manuscript.hash_key = submission_authors.hash_key) WHERE submission_authors.email = 'weichao.yu@mdpi.com' AND submission_manuscript.article_author_id != 113953;

SELECT
  submission_reviewers.*
FROM
  submission_reviewers
WHERE
  submission_reviewers.email IN ('weichao.yu@mdpi.com')

SELECT submission_reviewers.* FROM submission_reviewers WHERE submission_reviewers.email IN ('weichao.yu@mdpi.com') ;

SELECT
  submission_reviewers_journal_boards.*,
  journals.*
FROM
  submission_reviewers_journal_boards
  LEFT JOIN journals ON (
    journals.id = submission_reviewers_journal_boards.journal_id
  )
WHERE
  submission_reviewers_journal_boards.submission_reviewer_id = ?

SELECT submission_reviewers_journal_boards.*, journals.* FROM submission_reviewers_journal_boards LEFT JOIN journals ON (journals.id = submission_reviewers_journal_boards.journal_id) WHERE submission_reviewers_journal_boards.submission_reviewer_id = 1207348;

SELECT
  *
FROM
  volunteer_reviewers
WHERE
  email IN (?)

SELECT * FROM volunteer_reviewers WHERE email IN ('weichao.yu@mdpi.com');

SELECT
  *
FROM
  blacklist
WHERE
  `blacklist`.`email` = ?
LIMIT
  1

SELECT * FROM blacklist WHERE `blacklist`.`email`='weichao.yu@mdpi.com' LIMIT 1;

SELECT
  blacklisted_relations.*
FROM
  blacklisted_relations
WHERE
  id_blacklist = ?
ORDER BY
  id ASC

SELECT blacklisted_relations.* FROM blacklisted_relations WHERE id_blacklist = 1651888 ORDER BY id ASC;

SELECT
  *
FROM
  blacklisted_relations
WHERE
  id_blacklist = ?
  AND (
    all_sections = 1
    OR id_blacklisted_section IN (4)
  )

SELECT * FROM blacklisted_relations WHERE id_blacklist = 1651888 AND (all_sections = 1 OR id_blacklisted_section IN (4));

SELECT
  SUM(
    scholar_role_relations.role_num
  )
FROM
  submission_scholars
  LEFT JOIN scholar_role_relations ON (
    scholar_role_relations.scholar_id = submission_scholars.id
  )
WHERE
  1
  AND scholar_role_relations.role_id IN (7)
  AND submission_scholars.email IN ('weichao.yu@mdpi.com')
  AND scholar_role_relations.status = ?

SELECT SUM(scholar_role_relations.role_num) FROM submission_scholars LEFT JOIN scholar_role_relations ON (scholar_role_relations.scholar_id = submission_scholars.id) WHERE 1 AND scholar_role_relations.role_id IN (7) AND submission_scholars.email IN ('weichao.yu@mdpi.com') AND scholar_role_relations.status = 1;

SELECT
  SUM(
    scholar_role_relations.role_num
  )
FROM
  submission_scholars
  LEFT JOIN scholar_role_relations ON (
    scholar_role_relations.scholar_id = submission_scholars.id
  )
WHERE
  1
  AND scholar_role_relations.role_id IN (6)
  AND submission_scholars.email IN ('weichao.yu@mdpi.com')
  AND scholar_role_relations.status = ?

SELECT SUM(scholar_role_relations.role_num) FROM submission_scholars LEFT JOIN scholar_role_relations ON (scholar_role_relations.scholar_id = submission_scholars.id) WHERE 1 AND scholar_role_relations.role_id IN (6) AND submission_scholars.email IN ('weichao.yu@mdpi.com') AND scholar_role_relations.status = 1;

SELECT
  COUNT(
    DISTINCT submission_manuscript_review.hash_key
  )
FROM
  submission_manuscript_review
  LEFT JOIN submission_reviewers_rel ON (
    submission_reviewers_rel.id = submission_manuscript_review.reviewer_rel_id
  )
WHERE
  submission_reviewers_rel.reviewer_id IN (1207348)
  AND submission_manuscript_review.signatures_date_review IS NOT NULL
  AND submission_manuscript_review.is_rejected = 0
  AND submission_reviewers_rel.reviewer_status_id != 101

SELECT COUNT(DISTINCT submission_manuscript_review.hash_key) FROM submission_manuscript_review LEFT JOIN submission_reviewers_rel ON (submission_reviewers_rel.id = submission_manuscript_review.reviewer_rel_id) WHERE submission_reviewers_rel.reviewer_id IN (1207348)  AND submission_manuscript_review.signatures_date_review IS NOT NULL AND submission_manuscript_review.is_rejected = 0 AND submission_reviewers_rel.reviewer_status_id != 101;

SELECT
  *
FROM
  editors
WHERE
  email IN ('weichao.yu@mdpi.com')

SELECT * FROM editors WHERE email IN ('weichao.yu@mdpi.com');

SELECT
  *
FROM
  user_multiple_email
WHERE
  `user_multiple_email`.`email` = ?
LIMIT
  1

SELECT * FROM user_multiple_email WHERE `user_multiple_email`.`email`='weichao.yu@mdpi.com' LIMIT 1;

SELECT
  *
FROM
  user_grant_journal_rels
WHERE
  `user_grant_journal_rels`.`user_id` = ?
  AND `user_grant_journal_rels`.`grant_type` = ?

SELECT * FROM user_grant_journal_rels WHERE `user_grant_journal_rels`.`user_id`=113953 AND `user_grant_journal_rels`.`grant_type`=11;

SELECT
  *
FROM
  submission_users_roles
WHERE
  enabled = ?

SELECT * FROM submission_users_roles WHERE enabled = 1;

SELECT
  submission_users_roles.id
FROM
  users_roles_rels
  LEFT JOIN submission_users_roles ON (
    users_roles_rels.role_id = submission_users_roles.id
  )
WHERE
  users_roles_rels.user_id = ?
  AND submission_users_roles.enabled = 1

SELECT submission_users_roles.id FROM users_roles_rels LEFT JOIN submission_users_roles ON (users_roles_rels.role_id = submission_users_roles.id) WHERE users_roles_rels.user_id = 113953 AND submission_users_roles.enabled = 1;

SELECT
  *
FROM
  journals
WHERE
  `journals`.`id` = ?
LIMIT
  1

SELECT * FROM journals WHERE `journals`.`id`=32 LIMIT 1;

SELECT
  *
FROM
  journals
WHERE
  `journals`.`id` = ?
LIMIT
  1

SELECT * FROM journals WHERE `journals`.`id`=111 LIMIT 1;

SELECT
  *
FROM
  journals
WHERE
  `journals`.`id` = ?
LIMIT
  1

SELECT * FROM journals WHERE `journals`.`id`=252 LIMIT 1;

SELECT
  *
FROM
  journals
WHERE
  `journals`.`id` = ?
LIMIT
  1

SELECT * FROM journals WHERE `journals`.`id`=36 LIMIT 1;