List #: 12971
Keywords/tags: roots,root words,LIBER root
Created: 12/01/2012
Modified: 12/01/2012
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SHOW FULL COLUMNS FROM `words_antonyms` | 5 | 5 | 1 | |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | 1 | 1 | 0 | |
3 | SHOW FULL COLUMNS FROM `words_limericks` | 4 | 4 | 1 | |
4 | SHOW FULL COLUMNS FROM `words_related_words` | 4 | 4 | 1 | |
5 | SHOW FULL COLUMNS FROM `words_roots` | 4 | 4 | 0 | |
6 | SHOW FULL COLUMNS FROM `words_same_context_words` | 4 | 4 | 0 | |
7 | SHOW FULL COLUMNS FROM `words_senses` | 4 | 4 | 1 | |
8 | SHOW FULL COLUMNS FROM `words_synonyms` | 5 | 5 | 1 | |
9 | SHOW FULL COLUMNS FROM `words_quiz_synonyms` | 3 | 3 | 1 | |
10 | SHOW FULL COLUMNS FROM `words_videos` | 6 | 6 | 1 | |
11 | SHOW FULL COLUMNS FROM `user_practice_words` | 16 | 16 | 1 | |
12 | SHOW FULL COLUMNS FROM `word_lists` | 12 | 12 | 1 | |
13 | SHOW FULL COLUMNS FROM `schools` | 24 | 24 | 1 | |
14 | SHOW FULL COLUMNS FROM `partners` | 11 | 11 | 13 | |
15 | SHOW FULL COLUMNS FROM `partners_classes` | 4 | 4 | 1 | |
16 | SHOW FULL COLUMNS FROM `partners_users` | 4 | 4 | 1 | |
17 | SHOW FULL COLUMNS FROM `users_chapters` | 4 | 4 | 1 | |
18 | SHOW FULL COLUMNS FROM `user_preferred_words` | 9 | 9 | 1 | |
19 | SHOW FULL COLUMNS FROM `user_unwanted_words` | 3 | 3 | 0 | |
20 | SHOW FULL COLUMNS FROM `user_spelled_words` | 4 | 4 | 1 | |
21 | SHOW FULL COLUMNS FROM `word_list_bookmarks` | 4 | 4 | 0 | |
22 | SHOW FULL COLUMNS FROM `word_list_ratings` | 4 | 4 | 1 | |
23 | SHOW FULL COLUMNS FROM `teachers_students` | 5 | 5 | 1 | |
24 | SHOW FULL COLUMNS FROM `classes_students` | 3 | 3 | 1 | |
25 | SHOW FULL COLUMNS FROM `classes_teachers` | 3 | 3 | 1 | |
26 | SHOW FULL COLUMNS FROM `schools_teachers` | 4 | 4 | 1 | |
27 | SHOW FULL COLUMNS FROM `schools_admins` | 7 | 7 | 0 | |
28 | SHOW FULL COLUMNS FROM `users_sponsors` | 6 | 6 | 0 | |
29 | SHOW FULL COLUMNS FROM `users_friends` | 5 | 5 | 1 | |
30 | SHOW FULL COLUMNS FROM `users_family_sponsors` | 3 | 3 | 0 | |
31 | SHOW FULL COLUMNS FROM `classes_chapters` | 4 | 4 | 1 | |
32 | 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` = 12971 LIMIT 1 | 1 | 1 | 0 | |
33 | 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` = (12971) | 1 | 1 | 37 | |
34 | 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` = (12971) | 0 | 0 | 0 | |
35 | 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` = (12971) | 0 | 0 | 0 | |
36 | SHOW FULL COLUMNS FROM `settings` | 6 | 6 | 1 | |
37 | 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 |