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 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `topics` | | 13 | 13 | 10 | maybe slow |
SHOW FULL COLUMNS FROM `categories` | | 3 | 3 | 1 | maybe slow |
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 | 8 | 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 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `rubrics` | | 8 | 8 | 4 | maybe slow |
SHOW FULL COLUMNS FROM `posts` | | 8 | 8 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `ideas` | | 9 | 9 | 2 | 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 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `misconceptions` | | 6 | 6 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `items_misconceptions` | | 4 | 4 | 5 | maybe slow |
SHOW FULL COLUMNS FROM `ideas_misconceptions` | | 6 | 6 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `misconceptions_projects` | | 4 | 4 | 5 | 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 | 3 | maybe slow |
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 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `clusters` | | 4 | 4 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `ideas_items` | | 4 | 4 | 0 | |
SHOW FULL COLUMNS FROM `clusters_ideas` | | 4 | 4 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `users` | | 15 | 15 | 4 | maybe slow |
SHOW FULL COLUMNS FROM `groups` | | 4 | 4 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `assessments` | | 13 | 13 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `participants` | | 15 | 15 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `responses` | | 9 | 9 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `assessments_items` | | 7 | 7 | 5 | maybe slow |
SHOW FULL COLUMNS FROM `feedbacks` | | 10 | 10 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `items_users` | | 3 | 3 | 0 | |
SHOW FULL COLUMNS FROM `forms` | | 8 | 8 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `forms_items` | | 4 | 4 | 3 | 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 | | 22 | 22 | 3 | maybe slow |