| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| SHOW FULL COLUMNS FROM `aros` | | 7 | 7 | 1 | maybe slow |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 0 | |
| SHOW FULL COLUMNS FROM `acos` | | 7 | 7 | 0 | |
| SHOW FULL COLUMNS FROM `aros_acos` | | 7 | 7 | 0 | |
| SHOW FULL COLUMNS FROM `ngss_links` | | 9 | 9 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `items` | | 26 | 26 | 1 | |
| SHOW FULL COLUMNS FROM `topics` | | 13 | 13 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `categories` | | 3 | 3 | 0 | |
| SHOW FULL COLUMNS FROM `stats` | | 13 | 13 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `ideas` | | 9 | 9 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `goals` | | 9 | 9 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `posts` | | 8 | 8 | 0 | |
| SHOW FULL COLUMNS FROM `users` | | 15 | 15 | 0 | |
| SHOW FULL COLUMNS FROM `groups` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `assessments` | | 13 | 13 | 0 | |
| SHOW FULL COLUMNS FROM `participants` | | 15 | 15 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `responses` | | 9 | 9 | 3 | maybe slow |
| SHOW FULL COLUMNS FROM `assessments_items` | | 7 | 7 | 7 | |
| SHOW FULL COLUMNS FROM `feedbacks` | | 10 | 10 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `items_users` | | 3 | 3 | 9 | maybe slow |
| SHOW FULL COLUMNS FROM `projects` | | 12 | 12 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `project_files` | | 7 | 7 | 1 | maybe slow |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci'; | | 1 | 1 | 0 | |
| SHOW FULL COLUMNS FROM `misconceptions` | | 6 | 6 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `items_misconceptions` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `ideas_misconceptions` | | 6 | 6 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `misconceptions_projects` | | 4 | 4 | 3 | maybe slow |
| SHOW FULL COLUMNS FROM `items_projects` | | 3 | 3 | 0 | |
| SHOW FULL COLUMNS FROM `projects_topics` | | 6 | 6 | 6 | |
| SHOW FULL COLUMNS FROM `ideas_projects` | | 2 | 2 | 0 | |
| SHOW FULL COLUMNS FROM `clusters` | | 4 | 4 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `ideas_items` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `ideas_ngss_links` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `clusters_ideas` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `answers` | | 7 | 7 | 9 | maybe slow |
| SHOW FULL COLUMNS FROM `packets` | | 13 | 13 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `students` | | 8 | 8 | 0 | |
| SHOW FULL COLUMNS FROM `items_packets` | | 7 | 7 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `drawing_inputs` | | 5 | 5 | 6 | maybe slow |
| SHOW FULL COLUMNS FROM `drawing_input_options` | | 57 | 57 | 1 | |
| SHOW FULL COLUMNS FROM `drawing_input_stamps` | | 5 | 5 | 8 | maybe slow |
| SHOW FULL COLUMNS FROM `rubrics` | | 8 | 8 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `forms` | | 8 | 8 | 0 | |
| SHOW FULL COLUMNS FROM `forms_items` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `items_ngss_links` | | 4 | 4 | 7 | maybe slow |
| SHOW FULL COLUMNS FROM `ngss_links_projects` | | 4 | 4 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `ngss_links_topics` | | 4 | 4 | 7 | maybe slow |
| SELECT `Topic`.`id`, `Topic`.`topic_pub`, `Topic`.`short`, `Topic`.`short_pub`, `Category`.*, `Category`.`id` FROM `topics` AS `Topic` LEFT JOIN `categories` AS `Category` ON (`Topic`.`category_id` = `Category`.`id`) WHERE `Topic`.`public_items` = 1 ORDER BY `Topic`.`topic_pub` ASC | | 23 | 23 | 8 | maybe slow |
| SELECT `Topic`.* FROM `topics` AS `Topic` WHERE `Topic`.`public_items` = 1 ORDER BY `Topic`.`topic_pub` ASC | | 23 | 23 | 0 | |
| SELECT `NgssLink`.*, `NgssLink`.`id` FROM `ngss_links` AS `NgssLink` WHERE `NgssLink`.`code` = "LS1.C-M.2" | | 1 | 1 | 0 | |
| SELECT `Item`.`id`, `Item`.`code`, `Item`.`owner`, `Item`.`text`, `Item`.`version`, `Item`.`title`, `Item`.`date`, `Item`.`topic_id`, `Item`.`notes`, `Item`.`source`, `Item`.`attribution`, `Item`.`answer`, `Item`.`answer_type`, `Item`.`response_count`, `Item`.`locked`, `Item`.`public`, `Item`.`context`, `Item`.`deleted`, `Item`.`img_support`, `Item`.`item_status`, `Item`.`html_check`, `Item`.`ngss_notes`, `Item`.`grade_bands`, `Item`.`scale_score`, `Item`.`stats_file`, `Item`.`n_value`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `items` AS `Item` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`ngss_link_id` = 388 AND `ItemsNgssLink`.`item_id` = `Item`.`id`) WHERE SUBSTRING(`Item`.`item_status`, 1, 1) <> '0' AND SUBSTRING(`Item`.`item_status`, 3, 1) = '1' AND SUBSTRING(`Item`.`item_status`, 4, 1) = '1' AND `Item`.`deleted` = 0 ORDER BY `Item`.`id` ASC | | 24 | 24 | 1 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 14 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 16 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 16 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 16 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 16 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 16 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 16 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 16 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 16 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 16 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 16 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 14 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 14 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 14 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 14 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 14 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 14 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 14 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 14 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 41 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 41 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 41 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 41 | | 1 | 1 | 0 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 41 | | 1 | 1 | 0 | |
| SELECT `Project`.`id`, `Project`.`title`, `Project`.`internal_notes`, `Project`.`description`, `Project`.`funder`, `Project`.`complexity`, `Project`.`cluster`, `Project`.`multistat`, `Project`.`baseline`, `Project`.`control`, `Project`.`treatment`, `Project`.`deleted`, `ItemsProject`.`id`, `ItemsProject`.`project_id`, `ItemsProject`.`item_id` FROM `projects` AS `Project` JOIN `items_projects` AS `ItemsProject` ON (`ItemsProject`.`item_id` IN (2067, 3104, 3106, 3108, 3112, 3114, 3118, 3120, 3122, 3138, 3155, 3998, 4168, 4169, 4170, 4171, 4178, 4179, 4181, 5240, 5241, 5242, 5369, 5370) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 24 | 24 | 1 | |
| SELECT `Idea`.`id`, `Idea`.`idea`, `IdeasItem`.`id`, `IdeasItem`.`item_id`, `IdeasItem`.`idea_id`, `IdeasItem`.`deleted` FROM `ideas` AS `Idea` JOIN `ideas_items` AS `IdeasItem` ON (`IdeasItem`.`item_id` IN (2067, 3104, 3106, 3108, 3112, 3114, 3118, 3120, 3122, 3138, 3155, 3998, 4168, 4169, 4170, 4171, 4178, 4179, 4181, 5240, 5241, 5242, 5369, 5370) AND `IdeasItem`.`idea_id` = `Idea`.`id`) WHERE `Idea`.`deleted` = 0 AND `IdeasItem`.`deleted` = 0 ORDER BY `Idea`.`code` ASC | | 28 | 28 | 0 | |
| SELECT `Idea`.`id`, `Idea`.`code`, `Idea`.`idea`, `Idea`.`goal_id`, `Idea`.`topic_id`, `Idea`.`clarification`, `Idea`.`complexity`, `Idea`.`public`, `Idea`.`deleted`, `IdeasNgssLink`.`id`, `IdeasNgssLink`.`item_id`, `IdeasNgssLink`.`ngss_link_id`, `IdeasNgssLink`.`idea_id` FROM `ideas` AS `Idea` JOIN `ideas_ngss_links` AS `IdeasNgssLink` ON (`IdeasNgssLink`.`ngss_link_id` = 388 AND `IdeasNgssLink`.`idea_id` = `Idea`.`id`) | | 30 | 30 | 1 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id`, `NgssLinksTopic`.`id`, `NgssLinksTopic`.`item_id`, `NgssLinksTopic`.`topic_id`, `NgssLinksTopic`.`ngss_link_id` FROM `topics` AS `Topic` JOIN `ngss_links_topics` AS `NgssLinksTopic` ON (`NgssLinksTopic`.`ngss_link_id` = 388 AND `NgssLinksTopic`.`topic_id` = `Topic`.`id`) | | 28 | 28 | 0 | |
| SELECT `Idea`.* FROM `ideas` AS `Idea` WHERE `Idea`.`id` IN (83) ORDER BY `Idea`.`code` ASC | | 1 | 1 | 0 | |
| SELECT `Project`.* FROM `projects` AS `Project` WHERE 1 = 1 ORDER BY `Project`.`id` ASC | | 7 | 7 | 0 | |
| SELECT `IdeasProject`.`idea_id`, `IdeasProject`.`project_id` FROM `ideas_projects` AS `IdeasProject` WHERE 1 = 1 | | 174 | 174 | 0 | |