| 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 `misconceptions` | | 6 | 6 | 1 | maybe slow |
| 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 `items` | | 26 | 26 | 1 | |
| SHOW FULL COLUMNS FROM `answers` | | 7 | 7 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `packets` | | 13 | 13 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `students` | | 8 | 8 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `items_packets` | | 7 | 7 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `drawing_inputs` | | 5 | 5 | 1 | maybe slow |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci'; | | 1 | 1 | 0 | |
| SHOW FULL COLUMNS FROM `drawing_input_options` | | 57 | 57 | 1 | |
| SHOW FULL COLUMNS FROM `drawing_input_stamps` | | 5 | 5 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `rubrics` | | 8 | 8 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `posts` | | 8 | 8 | 0 | |
| SHOW FULL COLUMNS FROM `ideas` | | 9 | 9 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `goals` | | 9 | 9 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `projects` | | 12 | 12 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `project_files` | | 7 | 7 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `items_projects` | | 3 | 3 | 0 | |
| SHOW FULL COLUMNS FROM `projects_topics` | | 6 | 6 | 0 | |
| SHOW FULL COLUMNS FROM `ideas_projects` | | 2 | 2 | 0 | |
| SHOW FULL COLUMNS FROM `misconceptions_projects` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `ngss_links` | | 9 | 9 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `items_ngss_links` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `ideas_ngss_links` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `ngss_links_projects` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `ngss_links_topics` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `clusters` | | 4 | 4 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `ideas_items` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `clusters_ideas` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `ideas_misconceptions` | | 6 | 6 | 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 | 0 | |
| SHOW FULL COLUMNS FROM `assessments_items` | | 7 | 7 | 0 | |
| SHOW FULL COLUMNS FROM `feedbacks` | | 10 | 10 | 0 | |
| SHOW FULL COLUMNS FROM `items_users` | | 3 | 3 | 0 | |
| SHOW FULL COLUMNS FROM `forms` | | 8 | 8 | 0 | |
| SHOW FULL COLUMNS FROM `forms_items` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `items_misconceptions` | | 4 | 4 | 0 | |
| 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 | 0 | |
| SELECT `Misconception`.*, `Topic`.*, `Topic`.`id`, `Misconception`.`id` FROM `misconceptions` AS `Misconception` LEFT JOIN `topics` AS `Topic` ON (`Misconception`.`topic_id` = `Topic`.`id`) WHERE `Misconception`.`code` = 49 AND `Misconception`.`topic_id` = 15 | | 1 | 1 | 1 | |
| SELECT `Topic`.* FROM `topics` AS `Topic` WHERE `Topic`.`id` = 15 | | 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`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `items` AS `Item` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`misconception_id` = 1356 AND `ItemsMisconception`.`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`.`code` ASC | | 1 | 1 | 18 | maybe slow |
| 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` = 15 | | 1 | 1 | 0 | |
| SELECT `Stat`.`id`, `Stat`.`project_ref`, `Stat`.`group_ref`, `Stat`.`parameters`, `Stat`.`statr`, `Stat`.`data`, `Stat`.`item_id`, `Stat`.`idea_id`, `Stat`.`topic_id`, `Stat`.`statn`, `Stat`.`statp`, `Stat`.`fkclass`, `Stat`.`fkid` FROM `stats` AS `Stat` WHERE `Stat`.`topic_id` = 0 AND `Stat`.`idea_id` = 0 AND `Stat`.`parameters` IS NULL AND `Stat`.`item_id` = (3362) | | 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` = 3362 AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 1 | 1 | 0 | |
| 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` = 3362 AND `IdeasItem`.`idea_id` = `Idea`.`id`) WHERE `Idea`.`deleted` = 0 AND `IdeasItem`.`deleted` = 0 ORDER BY `Idea`.`code` ASC | | 1 | 1 | 0 | |
| SELECT `DistractorA`.`id`, `DistractorA`.`code`, `DistractorA`.`idea`, `DistractorA`.`topic_id`, `DistractorA`.`public`, `DistractorA`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorA` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` = 3362 AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 1 | 1 | 0 | |
| SELECT `DistractorB`.`id`, `DistractorB`.`code`, `DistractorB`.`idea`, `DistractorB`.`topic_id`, `DistractorB`.`public`, `DistractorB`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorB` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` = 3362 AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 1 | 1 | 0 | |
| SELECT `DistractorC`.`id`, `DistractorC`.`code`, `DistractorC`.`idea`, `DistractorC`.`topic_id`, `DistractorC`.`public`, `DistractorC`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorC` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` = 3362 AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 1 | 1 | 0 | |
| SELECT `DistractorD`.`id`, `DistractorD`.`code`, `DistractorD`.`idea`, `DistractorD`.`topic_id`, `DistractorD`.`public`, `DistractorD`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorD` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` = 3362 AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 0 | 0 | 0 | |
| SELECT `Idea`.`id`, `Idea`.`code`, `Idea`.`idea`, `Idea`.`goal_id`, `Idea`.`topic_id`, `Idea`.`clarification`, `Idea`.`complexity`, `Idea`.`public`, `Idea`.`deleted`, `IdeasMisconception`.`id`, `IdeasMisconception`.`misconception_id`, `IdeasMisconception`.`idea_id`, `IdeasMisconception`.`item_id`, `IdeasMisconception`.`selection`, `IdeasMisconception`.`deleted` FROM `ideas` AS `Idea` JOIN `ideas_misconceptions` AS `IdeasMisconception` ON (`IdeasMisconception`.`misconception_id` = 1356 AND `IdeasMisconception`.`idea_id` = `Idea`.`id`) WHERE `IdeasMisconception`.`deleted` = 0 AND `Idea`.`deleted` = 0 | | 1 | 1 | 1 | |
| SELECT `Project`.* FROM `projects` AS `Project` WHERE 1 = 1 ORDER BY `Project`.`id` ASC | | 7 | 7 | 0 | |