Query counts for submission list page build

submission-list-queries.txt

      1 : SELECT * FROM journals WHERE journal_id = ?
      1 : SELECT	* FROM navigation_menu_items WHERE path = ? and context_id = ? and type= ?
      1 : SELECT i.* FROM issues i WHERE journal_id = ? AND current = 1
      2 : SELECT *
      3 : SELECT	DISTINCT ug.role_id
      4 : SELECT * FROM sections WHERE journal_id = ? ORDER BY seq
      6 : SELECT last_run FROM scheduled_tasks WHERE class_name = ?
      7 : SELECT count(*) FROM notifications WHERE user_id = ? AND date_read IS NULL AND level = ?
      7 : SELECT * FROM sessions WHERE session_id = ?
      7 : SELECT * FROM site
      7 : SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ? AND context_id = ?
      7 : SELECT v.*
      7 : UPDATE sessions
      8 : SELECT * FROM notifications WHERE user_id = ? AND level = ? ORDER BY date_created DESC
      8 : SELECT * FROM review_rounds WHERE submission_id = ? AND stage_id = ? AND round = ?
      8 : SELECT * FROM section_settings WHERE section_id = ?
      8 : SELECT * FROM users WHERE user_id = ?
      9 : SELECT c.* FROM journals c
     11 : SELECT * FROM submission_file_settings WHERE file_id = ?
     12 : SELECT * FROM submission_galley_settings WHERE galley_id = ?
     16 : SELECT	edit_decision_id, editor_id, decision,
     17 : SELECT * FROM journals WHERE path = ?
     18 : SELECT	i.*
     18 : SELECT i.* FROM issues i WHERE issue_id = ?
     18 : SELECT sf.*, g.*
     19 : SELECT * FROM issue_settings WHERE issue_id = ?
     19 : SELECT * FROM journal_settings WHERE journal_id = ?
     46 : SELECT	a.*, ug.show_title
     46 : SELECT	COUNT(*)
     46 : SELECT * FROM review_rounds WHERE submission_id = ? ORDER BY stage_id ASC, round ASC
     46 : SELECT	user_group_id
     55 : SELECT * FROM author_settings WHERE author_id = ?
     57 : SELECT	s.*, ps.date_published,
     64 : SELECT	ug.*
    121 : SELECT * FROM submission_settings WHERE submission_id = ?
    126 : SELECT DISTINCT
    153 : SELECT r.*, r2.review_revision, u.first_name, u.last_name FROM review_assignments r
    168 : SELECT	date_last_viewed
    168 : SELECT u.*
    176 : SELECT * FROM user_settings WHERE user_id = ?
    184 : SELECT	DISTINCT q.*
    207 : SELECT	*
    346 : SELECT ugs.stage_id AS stage_id, sa.* FROM stage_assignments sa
    498 : SELECT	ps.*,
    560 : SELECT * FROM user_group_settings WHERE user_group_id = ?