| 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 `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 | 1 | maybe slow |
| 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 `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 | 0 | |
| SHOW FULL COLUMNS FROM `misconceptions_projects` | | 4 | 4 | 0 | |
| 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 `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 `answers` | | 7 | 7 | 0 | |
| 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 | 1 | maybe slow |
| 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 `forms` | | 8 | 8 | 0 | |
| SHOW FULL COLUMNS FROM `forms_items` | | 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 `Project`.* FROM `projects` AS `Project` WHERE 1 = 1 ORDER BY `Project`.`id` ASC | | 7 | 7 | 0 | |
| SELECT `Topic`.*, `Topic`.`id` FROM `topics` AS `Topic` WHERE `Topic`.`public_items` = 1 ORDER BY `Topic`.`topic_pub` ASC | | 23 | 23 | 0 | |
| SELECT `Post`.`id`, `Post`.`content`, `Post`.`modified`, `Post`.`user_id`, `Post`.`created`, `Post`.`fkclass`, `Post`.`fkid`, `Post`.`post_type` FROM `posts` AS `Post` WHERE `Post`.`post_type`='overview' AND `Post`.`fkclass`='T' AND `Post`.`fkid` IN (44, 47, 5, 31, 20, 50, 41, 28, 29, 35, 43, 15, 9, 16, 11, 14, 25, 27, 12, 6, 3, 32, 26) | | 14 | 14 | 0 | |
| SELECT `Item`.*, `Topic`.`id`, `Topic`.`topic_pub`, `Topic`.`short_pub`, `Item`.`id` FROM `items` AS `Item` LEFT JOIN `topics` AS `Topic` ON (`Item`.`topic_id` = `Topic`.`id`) WHERE NOT (SUBSTRING(`Item`.`item_status`, 1, 1) = '0') AND `Item`.`deleted` = 0 AND SUBSTRING(`Item`.`item_status`, 4, 1) = '1' AND SUBSTRING(`Item`.`code`, 3) = '23-9' AND `Item`.`code` = 'RH23-9' LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Topic`.`id`, `Topic`.`topic_pub`, `Topic`.`short_pub` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 12 | | 1 | 1 | 0 | |
| SELECT `DrawingInput`.`id`, `DrawingInput`.`item_id`, `DrawingInput`.`sort`, `DrawingInput`.`name`, `DrawingInput`.`watermark` FROM `drawing_inputs` AS `DrawingInput` WHERE `DrawingInput`.`item_id` = (5329) ORDER BY `DrawingInput`.`sort` ASC | | 0 | 0 | 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` = (5329) | | 3 | 3 | 0 | |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` = (5329) | | 0 | 0 | 0 | |
| SELECT `Post`.`id`, `Post`.`content`, `Post`.`modified`, `Post`.`user_id`, `Post`.`created`, `Post`.`fkclass`, `Post`.`fkid`, `Post`.`post_type` FROM `posts` AS `Post` WHERE `Post`.`post_type` = 'statsum' AND `Post`.`fkid` = (5329) | | 0 | 0 | 0 | |
| SELECT `Assessment`.`id`, `Assessment`.`label`, `Assessment`.`created`, `Assessment`.`modified`, `Assessment`.`research_allow`, `Assessment`.`research_included`, `Assessment`.`user_id`, `Assessment`.`status`, `Assessment`.`item_params`, `Assessment`.`public`, `Assessment`.`deleted`, `Assessment`.`instrument_id`, `Assessment`.`params`, `AssessmentsItem`.`id`, `AssessmentsItem`.`assessment_id`, `AssessmentsItem`.`item_id`, `AssessmentsItem`.`sort`, `AssessmentsItem`.`type`, `AssessmentsItem`.`template`, `AssessmentsItem`.`custom` FROM `assessments` AS `Assessment` JOIN `assessments_items` AS `AssessmentsItem` ON (`AssessmentsItem`.`item_id` = 5329 AND `AssessmentsItem`.`assessment_id` = `Assessment`.`id`) WHERE `Assessment`.`public` = 1 | | 0 | 0 | 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` = 5329 AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 1 | 1 | 0 | |
| SELECT `Idea`.`id`, `Idea`.`idea`, `Idea`.`clarification`, `Idea`.`goal_id`, `IdeasItem`.`id`, `IdeasItem`.`item_id`, `IdeasItem`.`idea_id`, `IdeasItem`.`deleted` FROM `ideas` AS `Idea` JOIN `ideas_items` AS `IdeasItem` ON (`IdeasItem`.`item_id` = 5329 AND `IdeasItem`.`idea_id` = `Idea`.`id`) WHERE `Idea`.`deleted` = 0 AND `IdeasItem`.`deleted` = 0 ORDER BY `Idea`.`code` ASC | | 2 | 2 | 0 | |
| SELECT `Goal`.`code`, `Goal`.`goal_text` FROM `goals` AS `Goal` WHERE `Goal`.`id` = 897 | | 1 | 1 | 0 | |
| SELECT `Goal`.`code`, `Goal`.`goal_text` FROM `goals` AS `Goal` WHERE `Goal`.`id` = 832 | | 1 | 1 | 0 | |
| SELECT `Misconception`.`id`, `Misconception`.`code`, `Misconception`.`idea`, `Misconception`.`topic_id`, `Misconception`.`public`, `Misconception`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `Misconception` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` = 5329 AND `ItemsMisconception`.`misconception_id` = `Misconception`.`id`) ORDER BY `ItemsMisconception`.`selection` ASC, `Misconception`.`code` ASC | | 4 | 4 | 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` = 12 | | 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` = 12 | | 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` = 12 | | 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` = 12 | | 1 | 1 | 0 | |
| SELECT `NgssLink`.`id`, `NgssLink`.`sort`, `NgssLink`.`code`, `NgssLink`.`section`, `NgssLink`.`text`, `NgssLink`.`primary`, `NgssLink`.`secondary`, `NgssLink`.`address`, `NgssLink`.`deleted`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `ngss_links` AS `NgssLink` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`item_id` = 5329 AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` 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` = 5329 AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 0 | 0 | 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` = 5329 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` = 5329 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` = 5329 AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 2 | 2 | 0 | |
| SELECT `DistractorE`.`id`, `DistractorE`.`code`, `DistractorE`.`idea`, `DistractorE`.`topic_id`, `DistractorE`.`public`, `DistractorE`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorE` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` = 5329 AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 0 | |
| SELECT `DistractorF`.`id`, `DistractorF`.`code`, `DistractorF`.`idea`, `DistractorF`.`topic_id`, `DistractorF`.`public`, `DistractorF`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorF` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` = 5329 AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' 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` FROM `ideas` AS `Idea` WHERE `Idea`.`deleted` = 0 AND `Idea`.`topic_id` = 12 ORDER BY `Idea`.`code` ASC | | 16 | 16 | 0 | |
| SELECT `Post`.`id`, `Post`.`content`, `Post`.`modified`, `Post`.`user_id`, `Post`.`created`, `Post`.`fkclass`, `Post`.`fkid`, `Post`.`post_type` FROM `posts` AS `Post` WHERE `Post`.`post_type`='statsum' AND `Post`.`fkclass`='K' AND `Post`.`fkid` IN (230, 231, 232, 233, 234, 235, 237, 238, 239, 170, 300, 301, 302, 303, 304, 228) | | 3 | 3 | 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`, `IdeasItem`.`id`, `IdeasItem`.`item_id`, `IdeasItem`.`idea_id`, `IdeasItem`.`deleted` FROM `items` AS `Item` JOIN `ideas_items` AS `IdeasItem` ON (`IdeasItem`.`idea_id` IN (230, 231, 232, 233, 234, 235, 237, 238, 239, 170, 300, 301, 302, 303, 304, 228) AND `IdeasItem`.`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`.`title` ASC | | 86 | 86 | 1 | |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 107 | 107 | 3 | |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 0 | 0 | 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 (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 89 | 89 | 0 | |
| SELECT `NgssLink`.`id`, `NgssLink`.`sort`, `NgssLink`.`code`, `NgssLink`.`section`, `NgssLink`.`text`, `NgssLink`.`primary`, `NgssLink`.`secondary`, `NgssLink`.`address`, `NgssLink`.`deleted`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `ngss_links` AS `NgssLink` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 60 | 60 | 1 | |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 23 | 23 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 62 | 62 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 42 | 42 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 76 | 76 | 0 | |
| SELECT `DistractorE`.`id`, `DistractorE`.`code`, `DistractorE`.`idea`, `DistractorE`.`topic_id`, `DistractorE`.`public`, `DistractorE`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorE` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 0 | |
| SELECT `DistractorF`.`id`, `DistractorF`.`code`, `DistractorF`.`idea`, `DistractorF`.`topic_id`, `DistractorF`.`public`, `DistractorF`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorF` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 107 | 107 | 2 | |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 0 | 0 | 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 (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 89 | 89 | 0 | |
| SELECT `NgssLink`.`id`, `NgssLink`.`sort`, `NgssLink`.`code`, `NgssLink`.`section`, `NgssLink`.`text`, `NgssLink`.`primary`, `NgssLink`.`secondary`, `NgssLink`.`address`, `NgssLink`.`deleted`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `ngss_links` AS `NgssLink` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 60 | 60 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 23 | 23 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 62 | 62 | 13 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 42 | 42 | 7 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 76 | 76 | 8 | maybe slow |
| SELECT `DistractorE`.`id`, `DistractorE`.`code`, `DistractorE`.`idea`, `DistractorE`.`topic_id`, `DistractorE`.`public`, `DistractorE`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorE` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 0 | |
| SELECT `DistractorF`.`id`, `DistractorF`.`code`, `DistractorF`.`idea`, `DistractorF`.`topic_id`, `DistractorF`.`public`, `DistractorF`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorF` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 8 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 107 | 107 | 2 | |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 0 | 0 | 9 | maybe slow |
| 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 (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 89 | 89 | 2 | |
| SELECT `NgssLink`.`id`, `NgssLink`.`sort`, `NgssLink`.`code`, `NgssLink`.`section`, `NgssLink`.`text`, `NgssLink`.`primary`, `NgssLink`.`secondary`, `NgssLink`.`address`, `NgssLink`.`deleted`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `ngss_links` AS `NgssLink` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 60 | 60 | 13 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 23 | 23 | 7 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 62 | 62 | 2 | |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 42 | 42 | 10 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 76 | 76 | 0 | |
| SELECT `DistractorE`.`id`, `DistractorE`.`code`, `DistractorE`.`idea`, `DistractorE`.`topic_id`, `DistractorE`.`public`, `DistractorE`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorE` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 10 | maybe slow |
| SELECT `DistractorF`.`id`, `DistractorF`.`code`, `DistractorF`.`idea`, `DistractorF`.`topic_id`, `DistractorF`.`public`, `DistractorF`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorF` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 107 | 107 | 10 | maybe slow |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 0 | 0 | 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 (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 89 | 89 | 0 | |
| SELECT `NgssLink`.`id`, `NgssLink`.`sort`, `NgssLink`.`code`, `NgssLink`.`section`, `NgssLink`.`text`, `NgssLink`.`primary`, `NgssLink`.`secondary`, `NgssLink`.`address`, `NgssLink`.`deleted`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `ngss_links` AS `NgssLink` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 60 | 60 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 23 | 23 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 62 | 62 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 42 | 42 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 76 | 76 | 0 | |
| SELECT `DistractorE`.`id`, `DistractorE`.`code`, `DistractorE`.`idea`, `DistractorE`.`topic_id`, `DistractorE`.`public`, `DistractorE`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorE` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 0 | |
| SELECT `DistractorF`.`id`, `DistractorF`.`code`, `DistractorF`.`idea`, `DistractorF`.`topic_id`, `DistractorF`.`public`, `DistractorF`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorF` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 107 | 107 | 2 | |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 0 | 0 | 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 (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 89 | 89 | 9 | maybe slow |
| SELECT `NgssLink`.`id`, `NgssLink`.`sort`, `NgssLink`.`code`, `NgssLink`.`section`, `NgssLink`.`text`, `NgssLink`.`primary`, `NgssLink`.`secondary`, `NgssLink`.`address`, `NgssLink`.`deleted`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `ngss_links` AS `NgssLink` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 60 | 60 | 9 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 23 | 23 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 62 | 62 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 42 | 42 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 76 | 76 | 0 | |
| SELECT `DistractorE`.`id`, `DistractorE`.`code`, `DistractorE`.`idea`, `DistractorE`.`topic_id`, `DistractorE`.`public`, `DistractorE`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorE` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 0 | |
| SELECT `DistractorF`.`id`, `DistractorF`.`code`, `DistractorF`.`idea`, `DistractorF`.`topic_id`, `DistractorF`.`public`, `DistractorF`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorF` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 107 | 107 | 2 | |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 0 | 0 | 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 (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 89 | 89 | 0 | |
| SELECT `NgssLink`.`id`, `NgssLink`.`sort`, `NgssLink`.`code`, `NgssLink`.`section`, `NgssLink`.`text`, `NgssLink`.`primary`, `NgssLink`.`secondary`, `NgssLink`.`address`, `NgssLink`.`deleted`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `ngss_links` AS `NgssLink` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 60 | 60 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 23 | 23 | 9 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 62 | 62 | 7 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 42 | 42 | 3 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 76 | 76 | 0 | |
| SELECT `DistractorE`.`id`, `DistractorE`.`code`, `DistractorE`.`idea`, `DistractorE`.`topic_id`, `DistractorE`.`public`, `DistractorE`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorE` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 0 | |
| SELECT `DistractorF`.`id`, `DistractorF`.`code`, `DistractorF`.`idea`, `DistractorF`.`topic_id`, `DistractorF`.`public`, `DistractorF`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorF` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 107 | 107 | 2 | |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 0 | 0 | 5 | maybe slow |
| 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 (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 89 | 89 | 10 | maybe slow |
| SELECT `NgssLink`.`id`, `NgssLink`.`sort`, `NgssLink`.`code`, `NgssLink`.`section`, `NgssLink`.`text`, `NgssLink`.`primary`, `NgssLink`.`secondary`, `NgssLink`.`address`, `NgssLink`.`deleted`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `ngss_links` AS `NgssLink` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 60 | 60 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 23 | 23 | 7 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 62 | 62 | 9 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 42 | 42 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 76 | 76 | 6 | maybe slow |
| SELECT `DistractorE`.`id`, `DistractorE`.`code`, `DistractorE`.`idea`, `DistractorE`.`topic_id`, `DistractorE`.`public`, `DistractorE`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorE` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 10 | maybe slow |
| SELECT `DistractorF`.`id`, `DistractorF`.`code`, `DistractorF`.`idea`, `DistractorF`.`topic_id`, `DistractorF`.`public`, `DistractorF`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorF` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 107 | 107 | 9 | maybe slow |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 0 | 0 | 12 | maybe slow |
| 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 (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 89 | 89 | 10 | maybe slow |
| SELECT `NgssLink`.`id`, `NgssLink`.`sort`, `NgssLink`.`code`, `NgssLink`.`section`, `NgssLink`.`text`, `NgssLink`.`primary`, `NgssLink`.`secondary`, `NgssLink`.`address`, `NgssLink`.`deleted`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `ngss_links` AS `NgssLink` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 60 | 60 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 23 | 23 | 7 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 62 | 62 | 9 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 42 | 42 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 76 | 76 | 6 | maybe slow |
| SELECT `DistractorE`.`id`, `DistractorE`.`code`, `DistractorE`.`idea`, `DistractorE`.`topic_id`, `DistractorE`.`public`, `DistractorE`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorE` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 6 | maybe slow |
| SELECT `DistractorF`.`id`, `DistractorF`.`code`, `DistractorF`.`idea`, `DistractorF`.`topic_id`, `DistractorF`.`public`, `DistractorF`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorF` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 2 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 107 | 107 | 7 | maybe slow |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 0 | 0 | 12 | maybe slow |
| 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 (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 89 | 89 | 10 | maybe slow |
| SELECT `NgssLink`.`id`, `NgssLink`.`sort`, `NgssLink`.`code`, `NgssLink`.`section`, `NgssLink`.`text`, `NgssLink`.`primary`, `NgssLink`.`secondary`, `NgssLink`.`address`, `NgssLink`.`deleted`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `ngss_links` AS `NgssLink` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 60 | 60 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 23 | 23 | 7 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 62 | 62 | 6 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 42 | 42 | 2 | |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 76 | 76 | 8 | maybe slow |
| SELECT `DistractorE`.`id`, `DistractorE`.`code`, `DistractorE`.`idea`, `DistractorE`.`topic_id`, `DistractorE`.`public`, `DistractorE`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorE` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 0 | |
| SELECT `DistractorF`.`id`, `DistractorF`.`code`, `DistractorF`.`idea`, `DistractorF`.`topic_id`, `DistractorF`.`public`, `DistractorF`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorF` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 107 | 107 | 2 | |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 0 | 0 | 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 (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 89 | 89 | 11 | maybe slow |
| SELECT `NgssLink`.`id`, `NgssLink`.`sort`, `NgssLink`.`code`, `NgssLink`.`section`, `NgssLink`.`text`, `NgssLink`.`primary`, `NgssLink`.`secondary`, `NgssLink`.`address`, `NgssLink`.`deleted`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `ngss_links` AS `NgssLink` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 60 | 60 | 1 | |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 23 | 23 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 62 | 62 | 11 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 42 | 42 | 11 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 76 | 76 | 8 | maybe slow |
| SELECT `DistractorE`.`id`, `DistractorE`.`code`, `DistractorE`.`idea`, `DistractorE`.`topic_id`, `DistractorE`.`public`, `DistractorE`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorE` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 7 | maybe slow |
| SELECT `DistractorF`.`id`, `DistractorF`.`code`, `DistractorF`.`idea`, `DistractorF`.`topic_id`, `DistractorF`.`public`, `DistractorF`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorF` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 4 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 107 | 107 | 7 | maybe slow |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 0 | 0 | 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 (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 89 | 89 | 9 | maybe slow |
| SELECT `NgssLink`.`id`, `NgssLink`.`sort`, `NgssLink`.`code`, `NgssLink`.`section`, `NgssLink`.`text`, `NgssLink`.`primary`, `NgssLink`.`secondary`, `NgssLink`.`address`, `NgssLink`.`deleted`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `ngss_links` AS `NgssLink` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 60 | 60 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 23 | 23 | 7 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 62 | 62 | 9 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 42 | 42 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 76 | 76 | 6 | maybe slow |
| SELECT `DistractorE`.`id`, `DistractorE`.`code`, `DistractorE`.`idea`, `DistractorE`.`topic_id`, `DistractorE`.`public`, `DistractorE`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorE` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 10 | maybe slow |
| SELECT `DistractorF`.`id`, `DistractorF`.`code`, `DistractorF`.`idea`, `DistractorF`.`topic_id`, `DistractorF`.`public`, `DistractorF`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorF` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 107 | 107 | 9 | maybe slow |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 0 | 0 | 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 (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 89 | 89 | 0 | |
| SELECT `NgssLink`.`id`, `NgssLink`.`sort`, `NgssLink`.`code`, `NgssLink`.`section`, `NgssLink`.`text`, `NgssLink`.`primary`, `NgssLink`.`secondary`, `NgssLink`.`address`, `NgssLink`.`deleted`, `ItemsNgssLink`.`id`, `ItemsNgssLink`.`item_id`, `ItemsNgssLink`.`ngss_link_id`, `ItemsNgssLink`.`deleted` FROM `ngss_links` AS `NgssLink` JOIN `items_ngss_links` AS `ItemsNgssLink` ON (`ItemsNgssLink`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 60 | 60 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 23 | 23 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 62 | 62 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 42 | 42 | 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 76 | 76 | 10 | maybe slow |
| SELECT `DistractorE`.`id`, `DistractorE`.`code`, `DistractorE`.`idea`, `DistractorE`.`topic_id`, `DistractorE`.`public`, `DistractorE`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorE` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 10 | maybe slow |
| SELECT `DistractorF`.`id`, `DistractorF`.`code`, `DistractorF`.`idea`, `DistractorF`.`topic_id`, `DistractorF`.`public`, `DistractorF`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorF` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 3 | maybe slow |
| 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` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 107 | 107 | 13 | maybe slow |
| SELECT `Rubric`.`rubric_id`, `Rubric`.`item_id`, `Rubric`.`name`, `Rubric`.`rubric`, `Rubric`.`points_earned`, `Rubric`.`points_possible`, `Rubric`.`mc_answer`, `Rubric`.`mc_input` FROM `rubrics` AS `Rubric` WHERE `Rubric`.`item_id` IN (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) | | 0 | 0 | 12 | maybe slow |
| 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 (2544, 2960, 2566, 2565, 2572, 2563, 2549, 2964, 2968, 2962, 2967, 2963, 2970, 2965, 2969, 2269, 2267, 2270, 5027, 2268, 5329, 2307, 2274, 2273, 2272, 2252, 2253, 2554, 2241, 2233, 2259, 2542, 2298, 2239, 2560, 2559, 2959, 5354, 2294, 2564, 2234, 2236, 2235, 2275, 2555, 2291, 2576, 2573, 2550, 2571, 2547, 2568, 2569, 2546, 2543, 2562, 2561, 2551, 2574, 2575, 2570, 2293, 2266, 5320, 2966, 5318, 2265, 2260, 2264, 2545, 2557, 2242, 2240, 2556, 2256, 2254, 2258, 2957, 2558, 2958, 5028, 2276, 2548, 2297, 2961, 2567) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 89 | 89 | 10 | maybe slow |