| 1 | SHOW FULL COLUMNS FROM `classes` | | 11 | 11 | 1 |
| 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 | 1 |
| 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 | 1 |
| 7 | SHOW FULL COLUMNS FROM `users_keys` | | 4 | 4 | 1 |
| 8 | SHOW FULL COLUMNS FROM `words` | | 24 | 24 | 1 |
| 9 | SHOW FULL COLUMNS FROM `limericks` | | 4 | 4 | 1 |
| 10 | SHOW FULL COLUMNS FROM `roots` | | 4 | 4 | 1 |
| 11 | SHOW FULL COLUMNS FROM `senses` | | 4 | 4 | 1 |
| 12 | SHOW FULL COLUMNS FROM `videos` | | 14 | 14 | 1 |
| 13 | SHOW FULL COLUMNS FROM `words_chapters` | | 4 | 4 | 1 |
| 14 | SHOW FULL COLUMNS FROM `words_alternates` | | 10 | 10 | 1 |
| 15 | SHOW FULL COLUMNS FROM `words_antonyms` | | 5 | 5 | 1 |
| 16 | SHOW FULL COLUMNS FROM `words_limericks` | | 4 | 4 | 1 |
| 17 | SHOW FULL COLUMNS FROM `words_related_words` | | 4 | 4 | 1 |
| 18 | SHOW FULL COLUMNS FROM `words_roots` | | 4 | 4 | 1 |
| 19 | SHOW FULL COLUMNS FROM `words_same_context_words` | | 4 | 4 | 1 |
| 20 | SHOW FULL COLUMNS FROM `words_senses` | | 4 | 4 | 1 |
| 21 | SHOW FULL COLUMNS FROM `words_synonyms` | | 5 | 5 | 1 |
| 22 | SHOW FULL COLUMNS FROM `words_quiz_synonyms` | | 3 | 3 | 1 |
| 23 | SHOW FULL COLUMNS FROM `words_videos` | | 6 | 6 | 1 |
| 24 | SHOW FULL COLUMNS FROM `user_practice_words` | | 16 | 16 | 1 |
| 25 | SHOW FULL COLUMNS FROM `word_lists` | | 12 | 12 | 1 |
| 26 | SHOW FULL COLUMNS FROM `schools` | | 24 | 24 | 1 |
| 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 | 1 |
| 30 | SHOW FULL COLUMNS FROM `users_chapters` | | 4 | 4 | 1 |
| 31 | SHOW FULL COLUMNS FROM `user_preferred_words` | | 9 | 9 | 2 |
| 32 | SHOW FULL COLUMNS FROM `user_unwanted_words` | | 3 | 3 | 4 |
| 33 | SHOW FULL COLUMNS FROM `user_spelled_words` | | 4 | 4 | 1 |
| 34 | SHOW FULL COLUMNS FROM `word_list_bookmarks` | | 4 | 4 | 4 |
| 35 | SHOW FULL COLUMNS FROM `word_list_ratings` | | 4 | 4 | 1 |
| 36 | SHOW FULL COLUMNS FROM `teachers_students` | | 5 | 5 | 1 |
| 37 | SHOW FULL COLUMNS FROM `classes_students` | | 3 | 3 | 2 |
| 38 | SHOW FULL COLUMNS FROM `classes_teachers` | | 3 | 3 | 3 |
| 39 | SHOW FULL COLUMNS FROM `schools_teachers` | | 4 | 4 | 1 |
| 40 | SHOW FULL COLUMNS FROM `schools_admins` | | 7 | 7 | 1 |
| 41 | SHOW FULL COLUMNS FROM `users_sponsors` | | 6 | 6 | 5 |
| 42 | SHOW FULL COLUMNS FROM `users_friends` | | 5 | 5 | 1 |
| 43 | SHOW FULL COLUMNS FROM `users_family_sponsors` | | 3 | 3 | 1 |
| 44 | SHOW FULL COLUMNS FROM `classes_chapters` | | 4 | 4 | 3 |
| 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` = 13627 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` = (13627) | | 1 | 1 | 1 |
| 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` = (13627) | | 0 | 0 | 1 |
| 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` = (13627) | | 0 | 0 | 0 |
| 49 | SHOW FULL COLUMNS FROM `settings` | | 6 | 6 | 3 |
| 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 | 3 |
| 51 | SHOW FULL COLUMNS FROM `wp_postmeta` | | 4 | 4 | 1 |
| 52 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb4_unicode_ci'; | | 1 | 1 | 0 |
| 53 | SHOW FULL COLUMNS FROM `wp_term_taxonomy` | | 6 | 6 | 2 |
| 54 | SHOW FULL COLUMNS FROM `wp_posts` | | 23 | 23 | 6 |
| 55 | SHOW FULL COLUMNS FROM `wp_term_relationships` | | 3 | 3 | 1 |
| 56 | SHOW FULL COLUMNS FROM `wp_terms` | | 4 | 4 | 1 |
| 57 | SELECT `WpTermTaxonomy`.`term_taxonomy_id`, `WpTermTaxonomy`.`term_id`, `WpTermTaxonomy`.`taxonomy`, `WpTermTaxonomy`.`description`, `WpTermTaxonomy`.`parent`, `WpTermTaxonomy`.`count`, (`WpTermTaxonomy`.`term_taxonomy_id`) AS `WpTermTaxonomy__id`, `WpTerm`.`term_id`, `WpTerm`.`name`, `WpTerm`.`slug`, `WpTerm`.`term_group`, (`WpTerm`.`term_id`) AS `WpTerm__id` FROM `wp_term_taxonomy` AS `WpTermTaxonomy` LEFT JOIN `wp_terms` AS `WpTerm` ON (`WpTermTaxonomy`.`term_id` = `WpTerm`.`term_id`) WHERE `slug` = 'top_menu_1' AND `taxonomy` = 'nav_menu' LIMIT 1 | | 1 | 1 | 1 |
| 58 | SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 7 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC | | 11 | 11 | 1 |
| 59 | SELECT `WpPostMeta`.`meta_id`, `WpPostMeta`.`post_id`, `WpPostMeta`.`meta_key`, `WpPostMeta`.`meta_value`, (`WpPostMeta`.`meta_id`) AS `WpPostMeta__id` FROM `wp_postmeta` AS `WpPostMeta` WHERE post_id IN (39, 714, 653, 858, 859, 860, 650, 244, 789, 788, 252) | | 88 | 88 | 3 |
| 60 | SELECT `WpTermTaxonomy`.`term_taxonomy_id`, `WpTermTaxonomy`.`term_id`, `WpTermTaxonomy`.`taxonomy`, `WpTermTaxonomy`.`description`, `WpTermTaxonomy`.`parent`, `WpTermTaxonomy`.`count`, (`WpTermTaxonomy`.`term_taxonomy_id`) AS `WpTermTaxonomy__id`, `WpTerm`.`term_id`, `WpTerm`.`name`, `WpTerm`.`slug`, `WpTerm`.`term_group`, (`WpTerm`.`term_id`) AS `WpTerm__id` FROM `wp_term_taxonomy` AS `WpTermTaxonomy` LEFT JOIN `wp_terms` AS `WpTerm` ON (`WpTermTaxonomy`.`term_id` = `WpTerm`.`term_id`) WHERE `slug` = 'top_menu_2' AND `taxonomy` = 'nav_menu' LIMIT 1 | | 1 | 1 | 4 |
| 61 | SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 6 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC | | 19 | 19 | 1 |
| 62 | SELECT `WpPostMeta`.`meta_id`, `WpPostMeta`.`post_id`, `WpPostMeta`.`meta_key`, `WpPostMeta`.`meta_value`, (`WpPostMeta`.`meta_id`) AS `WpPostMeta__id` FROM `wp_postmeta` AS `WpPostMeta` WHERE post_id IN (36, 40, 787, 4830, 257, 4829, 1364, 4827, 4828, 1365, 1366, 1367, 1518, 861, 2110, 862, 863, 54, 559) | | 152 | 152 | 1 |
| 63 | SELECT `WpTermTaxonomy`.`term_taxonomy_id`, `WpTermTaxonomy`.`term_id`, `WpTermTaxonomy`.`taxonomy`, `WpTermTaxonomy`.`description`, `WpTermTaxonomy`.`parent`, `WpTermTaxonomy`.`count`, (`WpTermTaxonomy`.`term_taxonomy_id`) AS `WpTermTaxonomy__id`, `WpTerm`.`term_id`, `WpTerm`.`name`, `WpTerm`.`slug`, `WpTerm`.`term_group`, (`WpTerm`.`term_id`) AS `WpTerm__id` FROM `wp_term_taxonomy` AS `WpTermTaxonomy` LEFT JOIN `wp_terms` AS `WpTerm` ON (`WpTermTaxonomy`.`term_id` = `WpTerm`.`term_id`) WHERE `slug` = 'footer_1' AND `taxonomy` = 'nav_menu' LIMIT 1 | | 1 | 1 | 0 |
| 64 | SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 9 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC | | 5 | 5 | 1 |
| 65 | SELECT `WpPostMeta`.`meta_id`, `WpPostMeta`.`post_id`, `WpPostMeta`.`meta_key`, `WpPostMeta`.`meta_value`, (`WpPostMeta`.`meta_id`) AS `WpPostMeta__id` FROM `wp_postmeta` AS `WpPostMeta` WHERE post_id IN (62, 265, 3055, 3672, 3673) | | 40 | 40 | 4 |
| 66 | SELECT `WpTermTaxonomy`.`term_taxonomy_id`, `WpTermTaxonomy`.`term_id`, `WpTermTaxonomy`.`taxonomy`, `WpTermTaxonomy`.`description`, `WpTermTaxonomy`.`parent`, `WpTermTaxonomy`.`count`, (`WpTermTaxonomy`.`term_taxonomy_id`) AS `WpTermTaxonomy__id`, `WpTerm`.`term_id`, `WpTerm`.`name`, `WpTerm`.`slug`, `WpTerm`.`term_group`, (`WpTerm`.`term_id`) AS `WpTerm__id` FROM `wp_term_taxonomy` AS `WpTermTaxonomy` LEFT JOIN `wp_terms` AS `WpTerm` ON (`WpTermTaxonomy`.`term_id` = `WpTerm`.`term_id`) WHERE `slug` = 'footer_2' AND `taxonomy` = 'nav_menu' LIMIT 1 | | 1 | 1 | 0 |
| 67 | SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 10 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC | | 6 | 6 | 1 |
| 68 | SELECT `WpPostMeta`.`meta_id`, `WpPostMeta`.`post_id`, `WpPostMeta`.`meta_key`, `WpPostMeta`.`meta_value`, (`WpPostMeta`.`meta_id`) AS `WpPostMeta__id` FROM `wp_postmeta` AS `WpPostMeta` WHERE post_id IN (63, 64, 266, 267, 268, 269) | | 48 | 48 | 0 |
| 69 | SELECT `WpTermTaxonomy`.`term_taxonomy_id`, `WpTermTaxonomy`.`term_id`, `WpTermTaxonomy`.`taxonomy`, `WpTermTaxonomy`.`description`, `WpTermTaxonomy`.`parent`, `WpTermTaxonomy`.`count`, (`WpTermTaxonomy`.`term_taxonomy_id`) AS `WpTermTaxonomy__id`, `WpTerm`.`term_id`, `WpTerm`.`name`, `WpTerm`.`slug`, `WpTerm`.`term_group`, (`WpTerm`.`term_id`) AS `WpTerm__id` FROM `wp_term_taxonomy` AS `WpTermTaxonomy` LEFT JOIN `wp_terms` AS `WpTerm` ON (`WpTermTaxonomy`.`term_id` = `WpTerm`.`term_id`) WHERE `slug` = 'footer_3' AND `taxonomy` = 'nav_menu' LIMIT 1 | | 1 | 1 | 0 |
| 70 | SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 11 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC | | 6 | 6 | 1 |
| 71 | SELECT `WpPostMeta`.`meta_id`, `WpPostMeta`.`post_id`, `WpPostMeta`.`meta_key`, `WpPostMeta`.`meta_value`, (`WpPostMeta`.`meta_id`) AS `WpPostMeta__id` FROM `wp_postmeta` AS `WpPostMeta` WHERE post_id IN (65, 3713, 66, 270, 271, 4521) | | 48 | 48 | 1 |
| 72 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`options`, `Setting`.`is_custom`, `Setting`.`is_editable` FROM `settings` AS `Setting` WHERE `key` = 'support_email' LIMIT 1 | | 1 | 1 | 0 |
