List #: 13017
Keywords/tags: roots,root words,OCU root
Created: 12/01/2012
Modified: 12/01/2012
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SHOW FULL COLUMNS FROM `classes` | 11 | 11 | 0 | |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | 1 | 1 | 0 | |
3 | SHOW FULL COLUMNS FROM `chapters` | 3 | 3 | 0 | |
4 | SHOW FULL COLUMNS FROM `users` | 55 | 55 | 1 | |
5 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_bin'; | 1 | 1 | 0 | |
6 | SHOW FULL COLUMNS FROM `keys` | 5 | 5 | 0 | |
7 | SHOW FULL COLUMNS FROM `users_keys` | 4 | 4 | 0 | |
8 | SHOW FULL COLUMNS FROM `words` | 24 | 24 | 0 | |
9 | SHOW FULL COLUMNS FROM `limericks` | 4 | 4 | 0 | |
10 | SHOW FULL COLUMNS FROM `roots` | 4 | 4 | 0 | |
11 | SHOW FULL COLUMNS FROM `senses` | 4 | 4 | 1 | |
12 | SHOW FULL COLUMNS FROM `videos` | 14 | 14 | 0 | |
13 | SHOW FULL COLUMNS FROM `words_chapters` | 4 | 4 | 0 | |
14 | SHOW FULL COLUMNS FROM `words_alternates` | 10 | 10 | 1 | |
15 | SHOW FULL COLUMNS FROM `words_antonyms` | 5 | 5 | 0 | |
16 | SHOW FULL COLUMNS FROM `words_limericks` | 4 | 4 | 0 | |
17 | SHOW FULL COLUMNS FROM `words_related_words` | 4 | 4 | 0 | |
18 | SHOW FULL COLUMNS FROM `words_roots` | 4 | 4 | 0 | |
19 | SHOW FULL COLUMNS FROM `words_same_context_words` | 4 | 4 | 0 | |
20 | SHOW FULL COLUMNS FROM `words_senses` | 4 | 4 | 0 | |
21 | SHOW FULL COLUMNS FROM `words_synonyms` | 5 | 5 | 0 | |
22 | SHOW FULL COLUMNS FROM `words_quiz_synonyms` | 3 | 3 | 0 | |
23 | SHOW FULL COLUMNS FROM `words_videos` | 6 | 6 | 1 | |
24 | SHOW FULL COLUMNS FROM `user_practice_words` | 16 | 16 | 0 | |
25 | SHOW FULL COLUMNS FROM `word_lists` | 12 | 12 | 0 | |
26 | SHOW FULL COLUMNS FROM `schools` | 24 | 24 | 0 | |
27 | SHOW FULL COLUMNS FROM `partners` | 11 | 11 | 1 | |
28 | SHOW FULL COLUMNS FROM `partners_classes` | 4 | 4 | 1 | |
29 | SHOW FULL COLUMNS FROM `partners_users` | 4 | 4 | 0 | |
30 | SHOW FULL COLUMNS FROM `users_chapters` | 4 | 4 | 0 | |
31 | SHOW FULL COLUMNS FROM `user_preferred_words` | 9 | 9 | 1 | |
32 | SHOW FULL COLUMNS FROM `user_unwanted_words` | 3 | 3 | 0 | |
33 | SHOW FULL COLUMNS FROM `user_spelled_words` | 4 | 4 | 0 | |
34 | SHOW FULL COLUMNS FROM `word_list_bookmarks` | 4 | 4 | 0 | |
35 | SHOW FULL COLUMNS FROM `word_list_ratings` | 4 | 4 | 0 | |
36 | SHOW FULL COLUMNS FROM `teachers_students` | 5 | 5 | 0 | |
37 | SHOW FULL COLUMNS FROM `classes_students` | 3 | 3 | 0 | |
38 | SHOW FULL COLUMNS FROM `classes_teachers` | 3 | 3 | 0 | |
39 | SHOW FULL COLUMNS FROM `schools_teachers` | 4 | 4 | 0 | |
40 | SHOW FULL COLUMNS FROM `schools_admins` | 7 | 7 | 0 | |
41 | SHOW FULL COLUMNS FROM `users_sponsors` | 6 | 6 | 0 | |
42 | SHOW FULL COLUMNS FROM `users_friends` | 5 | 5 | 0 | |
43 | SHOW FULL COLUMNS FROM `users_family_sponsors` | 3 | 3 | 0 | |
44 | SHOW FULL COLUMNS FROM `classes_chapters` | 4 | 4 | 0 | |
45 | SELECT `WordList`.`id`, `WordList`.`user_id`, `WordList`.`is_public`, `WordList`.`title`, `WordList`.`keywords`, `WordList`.`comments`, `WordList`.`content_link`, `WordList`.`buy_link`, `WordList`.`created`, `WordList`.`modified`, `WordList`.`is_changed_by_admin`, `WordList`.`is_premium`, (SELECT count(*) as count FROM word_list_ratings AS Rate WHERE `Rate`.`word_list_id` = `WordList`.`id` ) AS `WordList__reviews`, (SELECT round(sum(rating)/count(*), 1) FROM word_list_ratings AS Rate WHERE `Rate`.`word_list_id` = `WordList`.`id` ) AS `WordList__rating` FROM `word_lists` AS `WordList` WHERE `WordList`.`id` = 13017 LIMIT 1 | 1 | 1 | 0 | |
46 | SELECT `Chapter`.`id`, `Chapter`.`word_list_id`, `Chapter`.`unit`, (SELECT count(*) as count FROM words AS Word JOIN words_chapters AS WordsChapter ON (`WordsChapter`.`word_id` = `Word`.`id`) WHERE `WordsChapter`.`chapter_id` = `Chapter`.`id` ) AS `Chapter__words_count`, ( SELECT GROUP_CONCAT(' ', word) FROM words_chapters AS WordsChapters JOIN words AS WORD ON `WordsChapters`.`word_id`=`WORD`.`id` WHERE `WordsChapters`.`chapter_id`=`Chapter`.`id` ) AS `Chapter__words` FROM `chapters` AS `Chapter` WHERE (SELECT count(*) as count FROM words AS Word JOIN words_chapters AS WordsChapter ON (`WordsChapter`.`word_id` = `Word`.`id`) WHERE `WordsChapter`.`chapter_id` = `Chapter`.`id` LIMIT 1)>0 AND `Chapter`.`word_list_id` = (13017) | 1 | 1 | 3 | |
47 | SELECT `Bookmark`.`id`, `Bookmark`.`word_list_id`, `Bookmark`.`user_id`, `Bookmark`.`class_id` FROM `word_list_bookmarks` AS `Bookmark` WHERE `Bookmark`.`user_id` IS NULL AND `Bookmark`.`class_id` IS NULL AND `Bookmark`.`word_list_id` = (13017) | 0 | 0 | 0 | |
48 | SELECT `Rate`.`id`, `Rate`.`word_list_id`, `Rate`.`user_id`, `Rate`.`rating` FROM `word_list_ratings` AS `Rate` WHERE `Rate`.`user_id` IS NULL AND `Rate`.`word_list_id` = (13017) | 0 | 0 | 0 | |
49 | SHOW FULL COLUMNS FROM `settings` | 6 | 6 | 0 | |
50 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`options`, `Setting`.`is_custom`, `Setting`.`is_editable` FROM `settings` AS `Setting` WHERE `key` = 'word_lists_banner' LIMIT 1 | 1 | 1 | 0 |