| 1 | SHOW FULL COLUMNS FROM `words` | | 24 | 24 | 1 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | | 1 | 1 | 0 |
| 3 | SHOW FULL COLUMNS FROM `limericks` | | 4 | 4 | 1 |
| 4 | SHOW FULL COLUMNS FROM `roots` | | 4 | 4 | 0 |
| 5 | SHOW FULL COLUMNS FROM `senses` | | 4 | 4 | 1 |
| 6 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_bin'; | | 1 | 1 | 0 |
| 7 | SHOW FULL COLUMNS FROM `videos` | | 14 | 14 | 1 |
| 8 | SHOW FULL COLUMNS FROM `words_chapters` | | 4 | 4 | 1 |
| 9 | SHOW FULL COLUMNS FROM `words_alternates` | | 10 | 10 | 1 |
| 10 | SHOW FULL COLUMNS FROM `words_antonyms` | | 5 | 5 | 1 |
| 11 | SHOW FULL COLUMNS FROM `words_limericks` | | 4 | 4 | 1 |
| 12 | SHOW FULL COLUMNS FROM `words_related_words` | | 4 | 4 | 1 |
| 13 | SHOW FULL COLUMNS FROM `words_roots` | | 4 | 4 | 1 |
| 14 | SHOW FULL COLUMNS FROM `words_same_context_words` | | 4 | 4 | 1 |
| 15 | SHOW FULL COLUMNS FROM `words_senses` | | 4 | 4 | 1 |
| 16 | SHOW FULL COLUMNS FROM `words_synonyms` | | 5 | 5 | 1 |
| 17 | SHOW FULL COLUMNS FROM `words_quiz_synonyms` | | 3 | 3 | 1 |
| 18 | SHOW FULL COLUMNS FROM `words_videos` | | 6 | 6 | 1 |
| 19 | SHOW FULL COLUMNS FROM `user_practice_words` | | 16 | 16 | 1 |
| 20 | SHOW FULL COLUMNS FROM `word_lists` | | 12 | 12 | 1 |
| 21 | SHOW FULL COLUMNS FROM `schools` | | 24 | 24 | 1 |
| 22 | SHOW FULL COLUMNS FROM `partners` | | 11 | 11 | 1 |
| 23 | SHOW FULL COLUMNS FROM `partners_classes` | | 4 | 4 | 1 |
| 24 | SHOW FULL COLUMNS FROM `partners_users` | | 4 | 4 | 1 |
| 25 | SHOW FULL COLUMNS FROM `users_chapters` | | 4 | 4 | 1 |
| 26 | SHOW FULL COLUMNS FROM `user_preferred_words` | | 9 | 9 | 1 |
| 27 | SHOW FULL COLUMNS FROM `user_unwanted_words` | | 3 | 3 | 1 |
| 28 | SHOW FULL COLUMNS FROM `user_spelled_words` | | 4 | 4 | 1 |
| 29 | SHOW FULL COLUMNS FROM `word_list_bookmarks` | | 4 | 4 | 1 |
| 30 | SHOW FULL COLUMNS FROM `word_list_ratings` | | 4 | 4 | 1 |
| 31 | SHOW FULL COLUMNS FROM `teachers_students` | | 5 | 5 | 1 |
| 32 | SHOW FULL COLUMNS FROM `classes_students` | | 3 | 3 | 1 |
| 33 | SHOW FULL COLUMNS FROM `classes_teachers` | | 3 | 3 | 1 |
| 34 | SHOW FULL COLUMNS FROM `schools_teachers` | | 4 | 4 | 2 |
| 35 | SHOW FULL COLUMNS FROM `schools_admins` | | 7 | 7 | 1 |
| 36 | SHOW FULL COLUMNS FROM `users_sponsors` | | 6 | 6 | 2 |
| 37 | SHOW FULL COLUMNS FROM `users_friends` | | 5 | 5 | 2 |
| 38 | SHOW FULL COLUMNS FROM `users_family_sponsors` | | 3 | 3 | 0 |
| 39 | SHOW FULL COLUMNS FROM `classes_chapters` | | 4 | 4 | 3 |
| 40 | 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` = 13570 LIMIT 1 | | 1 | 1 | 1 |
| 41 | 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` = (13570) | | 1 | 1 | 1 |
| 42 | 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` = (13570) | | 0 | 0 | 0 |
| 43 | 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` = (13570) | | 0 | 0 | 0 |
| 44 | SHOW FULL COLUMNS FROM `settings` | | 6 | 6 | 1 |
| 45 | 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 |
