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
0
SHOW FULL COLUMNS FROM `groups_permissions`
3
3
0
SHOW FULL COLUMNS FROM `groups_users`
3
3
0
SHOW FULL COLUMNS FROM `contents_searches`
6
6
0
SHOW FULL COLUMNS FROM `attachments`
11
11
1
maybe slow
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
0
SHOW FULL COLUMNS FROM `contents_related_items_revs`
8
8
1
maybe slow
SHOW FULL COLUMNS FROM `contents_tags`
5
5
0
SHOW FULL COLUMNS FROM `tags`
7
7
0
SHOW FULL COLUMNS FROM `tag_groups`
6
6
1
maybe slow
SHOW FULL COLUMNS FROM `contents_tags_revs`
7
7
0
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) AND content_id not in (124, 133, 163)
ORDER BY
score desc
LIMIT
0, 11
11
11
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 (16, 23, 24, 34, 49, 51, 54, 68, 83, 86)
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 (16, 23, 24, 34, 49, 51, 54, 68, 83, 86)
11
11
0
SELECT `ContentsRelatedItem`.`content`, `ContentsRelatedItem`.`related_item_id`, `ContentsRelatedItem`.`content_id` FROM `contents_related_items` AS `ContentsRelatedItem` WHERE `ContentsRelatedItem`.`content_id` IN (16, 23, 24, 34, 49, 51, 54, 68, 83, 86)
120
120
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` = 11
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` = 12
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` = 12
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` = 12
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` = 12
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` = 12
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` = 12
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` = 12
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` = 12
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` = 11
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` = 12
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` = 12
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 (16, 23, 24, 34, 49, 51, 54, 68, 83, 86)
40
40
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` = 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` = 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` = 66
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` = 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` = 12
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` = 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` = 79
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` = 81
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` = 47
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` = 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` = 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` = 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` = 87
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` = 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` = 72
1
1
0
SELECT `TagGroup`.`code`, `TagGroup`.`name` FROM `tag_groups` AS `TagGroup` WHERE `TagGroup`.`id` = 6
1
1
0
Query Explain:
Click an "Explain" link above, to see the query explanation.
