| 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 | 10 | maybe slow |
| SHOW FULL COLUMNS FROM `topics` | | 13 | 13 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `categories` | | 3 | 3 | 0 | |
| SHOW FULL COLUMNS FROM `stats` | | 13 | 13 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `ideas` | | 9 | 9 | 6 | maybe slow |
| SHOW FULL COLUMNS FROM `goals` | | 9 | 9 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `posts` | | 8 | 8 | 5 | maybe slow |
| 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 | 8 | maybe slow |
| 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 | 7 | |
| 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 | 2 | 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 | 8 | maybe slow |
| 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 | 9 | maybe slow |
| 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 | 5 | maybe slow |
| SHOW FULL COLUMNS FROM `answers` | | 7 | 7 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `packets` | | 13 | 13 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `students` | | 8 | 8 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `items_packets` | | 7 | 7 | 6 | 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 | 3 | maybe slow |
| SHOW FULL COLUMNS FROM `forms` | | 8 | 8 | 3 | maybe slow |
| 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 | 1 | |
| SELECT `Project`.* FROM `projects` AS `Project` WHERE 1 = 1 ORDER BY `Project`.`id` ASC | | 7 | 7 | 1 | maybe slow |
| SELECT `Topic`.*, `Topic`.`id` FROM `topics` AS `Topic` WHERE `Topic`.`public_items` = 1 ORDER BY `Topic`.`topic_pub` ASC | | 23 | 23 | 1 | |
| 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 | 1 | maybe slow |
| 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) = '55-1' AND `Item`.`code` = 'EN55-1' LIMIT 1 | | 1 | 1 | 12 | maybe slow |
| SELECT `Topic`.`id`, `Topic`.`topic_pub`, `Topic`.`short_pub` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 15 | | 1 | 1 | 0 | |
| SELECT `DrawingInput`.`id`, `DrawingInput`.`item_id`, `DrawingInput`.`sort`, `DrawingInput`.`name`, `DrawingInput`.`watermark` FROM `drawing_inputs` AS `DrawingInput` WHERE `DrawingInput`.`item_id` = (3434) 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` = (3434) | | 1 | 1 | 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` = (3434) | | 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` = (3434) | | 0 | 0 | 4 | maybe slow |
| 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` = 3434 AND `AssessmentsItem`.`assessment_id` = `Assessment`.`id`) WHERE `Assessment`.`public` = 1 | | 0 | 0 | 86 | 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` = 3434 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` = 3434 AND `IdeasItem`.`idea_id` = `Idea`.`id`) WHERE `Idea`.`deleted` = 0 AND `IdeasItem`.`deleted` = 0 ORDER BY `Idea`.`code` ASC | | 1 | 1 | 1 | |
| SELECT `Goal`.`code`, `Goal`.`goal_text` FROM `goals` AS `Goal` WHERE `Goal`.`id` = 771 | | 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` = 3434 AND `ItemsMisconception`.`misconception_id` = `Misconception`.`id`) ORDER BY `ItemsMisconception`.`selection` ASC, `Misconception`.`code` ASC | | 1 | 1 | 1 | |
| SELECT `Topic`.`short`, `Topic`.`short_pub`, `Topic`.`topic`, `Topic`.`id`, `Topic`.`topic_info`, `Topic`.`public_pr`, `Topic`.`topic_pub`, `Topic`.`public_items`, `Topic`.`idea_notes`, `Topic`.`item_notes`, `Topic`.`miscon_notes`, `Topic`.`ngss_notes`, `Topic`.`category_id` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 15 | | 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` = 3434 AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 0 | 0 | 1 | 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` = 3434 AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 1 | 1 | 0 | |
| SELECT `DistractorB`.`id`, `DistractorB`.`code`, `DistractorB`.`idea`, `DistractorB`.`topic_id`, `DistractorB`.`public`, `DistractorB`.`deleted`, `ItemsMisconception`.`id`, `ItemsMisconception`.`item_id`, `ItemsMisconception`.`misconception_id`, `ItemsMisconception`.`selection` FROM `misconceptions` AS `DistractorB` JOIN `items_misconceptions` AS `ItemsMisconception` ON (`ItemsMisconception`.`item_id` = 3434 AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 0 | 0 | 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` = 3434 AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 0 | 0 | 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` = 3434 AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 0 | 0 | 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` = 3434 AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 1 | 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` = 3434 AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 1 | maybe slow |
| 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` = 15 ORDER BY `Idea`.`code` ASC | | 7 | 7 | 7 | |
| 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 (262, 418, 419, 263, 264, 422, 265) | | 0 | 0 | 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 (262, 418, 419, 263, 264, 422, 265) 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 | | 121 | 121 | 2 | |
| 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 292 | 292 | 13 | |
| 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 3 | 3 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 128 | 128 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 90 | 90 | 7 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 42 | 42 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 34 | 34 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 41 | 41 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 54 | 54 | 4 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 292 | 292 | 25 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 3 | 3 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 128 | 128 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 90 | 90 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 42 | 42 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 34 | 34 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 41 | 41 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 54 | 54 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 292 | 292 | 4 | |
| 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 3 | 3 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 128 | 128 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 90 | 90 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 42 | 42 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 34 | 34 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 41 | 41 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 54 | 54 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 292 | 292 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 3 | 3 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 128 | 128 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 90 | 90 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 42 | 42 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 34 | 34 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 41 | 41 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 54 | 54 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorE`.`id`) WHERE `ItemsMisconception`.`selection` = 'E' ORDER BY `code` ASC | | 0 | 0 | 9 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 292 | 292 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 3 | 3 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 128 | 128 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 90 | 90 | 10 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 42 | 42 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 34 | 34 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 41 | 41 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 54 | 54 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 292 | 292 | 15 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 3 | 3 | 1 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 128 | 128 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 90 | 90 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 42 | 42 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 34 | 34 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 41 | 41 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 54 | 54 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 292 | 292 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) | | 3 | 3 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsProject`.`project_id` = `Project`.`id`) ORDER BY `Project`.`id` ASC | | 128 | 128 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsNgssLink`.`ngss_link_id` = `NgssLink`.`id`) ORDER BY `NgssLink`.`id` ASC | | 90 | 90 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorA`.`id`) WHERE `ItemsMisconception`.`selection` = 'A' ORDER BY `code` ASC | | 42 | 42 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorB`.`id`) WHERE `ItemsMisconception`.`selection` = 'B' ORDER BY `code` ASC | | 34 | 34 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorC`.`id`) WHERE `ItemsMisconception`.`selection` = 'C' ORDER BY `code` ASC | | 41 | 41 | 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorD`.`id`) WHERE `ItemsMisconception`.`selection` = 'D' ORDER BY `code` ASC | | 54 | 54 | 1 | |
| 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) 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 (3391, 3380, 3381, 3429, 5043, 3419, 3424, 5319, 3426, 5029, 3423, 3384, 5317, 5347, 5027, 5329, 5332, 3413, 5217, 3366, 3417, 5337, 3414, 5341, 4993, 3364, 5323, 2298, 5354, 4390, 5351, 5316, 5342, 5345, 5340, 3428, 5290, 5305, 5307, 5308, 5327, 4869, 2576, 5348, 5346, 4857, 5349, 5352, 3382, 5039, 4392, 5324, 5321, 5023, 5048, 3376, 5344, 5309, 3383, 4283, 3399, 3411, 3402, 4397, 3421, 3367, 5322, 5004, 5330, 5312, 3362, 3434, 4958, 4952, 4947, 5325, 5314, 5014, 5338, 5015, 5339, 5336, 5313, 3400, 5320, 5318, 5301, 5303, 3363, 5353, 5300, 5299, 4950, 3392, 5047, 3393, 3389, 5036, 5343, 5310, 4979, 5311, 3365, 5304, 2258, 3361, 5028, 3433, 3431, 3430, 3432, 3397, 3398, 5315, 5356, 5350, 3371, 2624, 5035, 5355, 5357) AND `ItemsMisconception`.`misconception_id` = `DistractorF`.`id`) WHERE `ItemsMisconception`.`selection` = 'F' ORDER BY `code` ASC | | 0 | 0 | 0 | |
| SHOW FULL COLUMNS FROM `stats_constructed_responses` | | 24 | 24 | 4 | maybe slow |
| SELECT `StatsConstructedResponse`.`id`, `StatsConstructedResponse`.`code`, `StatsConstructedResponse`.`serial`, `StatsConstructedResponse`.`answer`, `StatsConstructedResponse`.`project_ref`, `StatsConstructedResponse`.`group_ref`, `StatsConstructedResponse`.`part`, `StatsConstructedResponse`.`part_name`, `StatsConstructedResponse`.`correct`, `StatsConstructedResponse`.`total`, `StatsConstructedResponse`.`bygrade_h_correct`, `StatsConstructedResponse`.`bygrade_h_total`, `StatsConstructedResponse`.`bygrade_m_correct`, `StatsConstructedResponse`.`bygrade_m_total`, `StatsConstructedResponse`.`bygrade_e_correct`, `StatsConstructedResponse`.`bygrade_e_total`, `StatsConstructedResponse`.`bygender_m_correct`, `StatsConstructedResponse`.`bygender_m_total`, `StatsConstructedResponse`.`bygender_f_correct`, `StatsConstructedResponse`.`bygender_f_total`, `StatsConstructedResponse`.`bylang_en_correct`, `StatsConstructedResponse`.`bylang_en_total`, `StatsConstructedResponse`.`bylang_ot_correct`, `StatsConstructedResponse`.`bylang_ot_total` FROM `stats_constructed_responses` AS `StatsConstructedResponse` WHERE 1 = 1 | | 85 | 85 | 5 | maybe slow |
| SHOW FULL COLUMNS FROM `framework_statements` | | 6 | 6 | 1 | maybe slow |
| SELECT `FrameworkStatements`.`id`, `FrameworkStatements`.`item_ref`, `FrameworkStatements`.`framework_chapter`, `FrameworkStatements`.`framework_page`, `FrameworkStatements`.`framework_text`, `FrameworkStatements`.`deleted` FROM `framework_statements` AS `FrameworkStatements` WHERE `FrameworkStatements`.`item_ref` = 3434 | | 1 | 1 | 3 | maybe slow |