| Query |  Error |  Affected |  Num. rows |  Took (ms) |  Actions | 
|---|
| SHOW FULL COLUMNS FROM `contents` |   |  16 |  16 |  1 |  maybe slow | 
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; |   |  1 |  1 |  0 |   | 
| SHOW FULL COLUMNS FROM `users` |   |  10 |  10 |  1 |  maybe slow | 
| SHOW FULL COLUMNS FROM `groups` |   |  4 |  4 |  0 |   | 
| SHOW FULL COLUMNS FROM `permissions` |   |  5 |  5 |  1 |  maybe slow | 
| SHOW FULL COLUMNS FROM `groups_permissions` |   |  3 |  3 |  1 |  maybe slow | 
| SHOW FULL COLUMNS FROM `groups_users` |   |  3 |  3 |  1 |  maybe slow | 
| SHOW FULL COLUMNS FROM `contents_searches` |   |  6 |  6 |  1 |  maybe slow | 
| SHOW FULL COLUMNS FROM `attachments` |   |  11 |  11 |  0 |   | 
| SHOW FULL COLUMNS FROM `attachments_revs` |   |  13 |  13 |  1 |  maybe slow | 
| SHOW FULL COLUMNS FROM `contents_related_items` |   |  5 |  5 |  0 |   | 
| SHOW FULL COLUMNS FROM `related_items` |   |  6 |  6 |  1 |  maybe slow | 
| SHOW FULL COLUMNS FROM `contents_related_items_revs` |   |  8 |  8 |  0 |   | 
| SHOW FULL COLUMNS FROM `contents_tags` |   |  5 |  5 |  0 |   | 
| SHOW FULL COLUMNS FROM `tags` |   |  7 |  7 |  1 |  maybe slow | 
| SHOW FULL COLUMNS FROM `tag_groups` |   |  6 |  6 |  0 |   | 
| SHOW FULL COLUMNS FROM `contents_tags_revs` |   |  7 |  7 |  1 |  maybe slow | 
| SHOW FULL COLUMNS FROM `contents_revs` |   |  18 |  18 |  1 |  maybe slow | 
| SELECT `TagGroup`.`id`, `TagGroup`.`code`, `TagGroup`.`name`, `TagGroup`.`created`, `TagGroup`.`modified`, `TagGroup`.`flag` FROM `tag_groups` AS `TagGroup`   WHERE `flag` = 1    |   |  9 |  9 |  0 |   | 
| SELECT `Tag`.`id`, `Tag`.`tag_group_id`, `Tag`.`name`, `Tag`.`comment`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`flag` FROM `tags` AS `Tag`   WHERE `Tag`.`flag` = 1 AND `Tag`.`tag_group_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9)    |   |  129 |  129 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE id IN (1, 2, 3, 4, 5, 6)    |   |  6 |  6 |  0 |   | 
| 
            SELECT 
                MATCH (`related_items`, `tags`) AGAINST (' +"|72|"' IN BOOLEAN MODE) as score,
                content_id
            FROM
                `contents_searches` as `ContentsSearch`
            WHERE
                MATCH (`related_items`, `tags`) AGAINST (' +"|72|"' IN BOOLEAN MODE)
            ORDER BY
                score desc
            LIMIT
                10, 11 |   |  10 |  10 |  0 |   | 
| SELECT `Content`.`id`, `Content`.`user_id`, `Content`.`last_edit_user_id`, `Content`.`post_date`, `Content`.`post_date_year`, `Content`.`post_date_month`, `Content`.`post_date_day`, `Content`.`title`, `Content`.`title_en`, `Content`.`content`, `Content`.`plain_content`, `Content`.`page_view`, `Content`.`flag`, `Content`.`mod_count`, `Content`.`created`, `Content`.`modified` FROM `contents` AS `Content`   WHERE id IN (87, 90, 89, 99, 106, 117, 118, 164, 166, 167)    |   |  10 |  10 |  0 |   | 
| SELECT `Attachment`.`file_name`, `Attachment`.`dir`, `Attachment`.`model`, `Attachment`.`foreign_key` FROM `attachments` AS `Attachment`   WHERE `file_name` <> 'default.jpg' AND `Attachment`.`foreign_key` IN (87, 89, 90, 99, 106, 117, 118, 164, 166, 167)    |   |  12 |  12 |  0 |   | 
| SELECT `ContentsRelatedItem`.`content`, `ContentsRelatedItem`.`related_item_id`, `ContentsRelatedItem`.`content_id` FROM `contents_related_items` AS `ContentsRelatedItem`   WHERE `ContentsRelatedItem`.`content_id` IN (87, 89, 90, 99, 106, 117, 118, 164, 166, 167)    |   |  107 |  107 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 1    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 2    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 5    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 8    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 4    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 11    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 1    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 2    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 5    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 8    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 4    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 11    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 1    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 2    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 5    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 8    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 4    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 11    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 1    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 2    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 5    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 8    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 4    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 11    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 1    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 2    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 5    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 8    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 4    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 11    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 1    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 2    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 5    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 8    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 4    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 11    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 1    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 2    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 5    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 8    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 4    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 11    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 1    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 2    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 4    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 8    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 11    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 1    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 2    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 4    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 8    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 11    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 1    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 2    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 4    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 8    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 9    |   |  1 |  1 |  0 |   | 
| SELECT `RelatedItem`.`code`, `RelatedItem`.`name` FROM `related_items` AS `RelatedItem`   WHERE `RelatedItem`.`id` = 11    |   |  1 |  1 |  0 |   | 
| SELECT `ContentsTag`.`id`, `ContentsTag`.`tag_group_id`, `ContentsTag`.`mod_count`, `ContentsTag`.`tag_id`, `ContentsTag`.`content_id` FROM `contents_tags` AS `ContentsTag`   WHERE `ContentsTag`.`content_id` IN (87, 89, 90, 99, 106, 117, 118, 164, 166, 167)    |   |  35 |  35 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 72    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 77    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 175    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 21    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 2    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 72    |   |  1 |  1 |  1 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 175    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 72    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 175    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 51    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 4    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 72    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 175    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 72    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 77    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 99    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 5    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 1    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 65    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 67    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 68    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 70    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 72    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 82    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 175    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 35    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 3    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 72    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 77    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 175    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 38    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 3    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 62    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 65    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 72    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 100    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 72    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 6    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 100    |   |  1 |  1 |  0 |   | 
| SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup`   WHERE `TagGroup`.`id` = 7    |   |  1 |  1 |  0 |   | 
| SELECT `Tag`.`name`, `Tag`.`comment`, `Tag`.`tag_group_id` FROM `tags` AS `Tag`   WHERE `Tag`.`id` = 72    |   |  1 |  1 |  0 |   |