List #: 12919
Keywords/tags: roots,root words,FLECT 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 | 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 | 0 | |
7 | SHOW FULL COLUMNS FROM `users_keys` | 4 | 4 | 0 | |
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 | 0 | |
11 | SHOW FULL COLUMNS FROM `senses` | 4 | 4 | 0 | |
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 | 0 | |
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 | 1 | |
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 | 0 | |
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 | 1 | |
32 | SHOW FULL COLUMNS FROM `user_unwanted_words` | 3 | 3 | 1 | |
33 | SHOW FULL COLUMNS FROM `user_spelled_words` | 4 | 4 | 1 | |
34 | SHOW FULL COLUMNS FROM `word_list_bookmarks` | 4 | 4 | 1 | |
35 | SHOW FULL COLUMNS FROM `word_list_ratings` | 4 | 4 | 1 | |
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 | 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` = 12919 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` = (12919) | 1 | 1 | 0 | |
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` = (12919) | 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` = (12919) | 0 | 0 | 0 | |
49 | SHOW FULL COLUMNS FROM `settings` | 6 | 6 | 1 | |
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 | |
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 | 1 | |
54 | SHOW FULL COLUMNS FROM `wp_posts` | 23 | 23 | 1 | |
55 | SHOW FULL COLUMNS FROM `wp_term_relationships` | 3 | 3 | 0 | |
56 | SHOW FULL COLUMNS FROM `wp_terms` | 4 | 4 | 2 | |
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 | 0 | |
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 | 1 | |
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 | 0 | |
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 | 0 | |
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 | 0 | |
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 |