| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Topic`.`id`, `Topic`.`created`, `Topic`.`updated`, `Topic`.`date`, `Topic`.`status`, `Topic`.`title`, `Topic`.`content`, `Topic`.`summary`, `Topic`.`thumbnail`, `Topic`.`category_post_id`, `Topic`.`category_line_id`, `Topic`.`category_brand_id`, `Topic`.`position` FROM `test_tochigi`.`topics` AS `Topic` WHERE `Topic`.`status` = 'publish' ORDER BY `position` asc LIMIT 13 | 13 | 13 | 3 | maybe slow |
| SELECT `Tax`.`id`, `Tax`.`created`, `Tax`.`updated`, `Tax`.`key`, `Tax`.`value` FROM `test_tochigi`.`options` AS `Tax` WHERE `key` = 'taxes' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Item`.`id`, `Item`.`created`, `Item`.`updated`, `Item`.`status`, `Item`.`name`, `Item`.`price`, `Item`.`spec`, `Item`.`content`, `Item`.`summary`, `Item`.`category_id`, `Item`.`brand_id` FROM `test_tochigi`.`items` AS `Item` LEFT JOIN `test_tochigi`.`item_stickies` AS `ItemSticky` ON (`Item`.`id` = `ItemSticky`.`item_id`) WHERE `Item`.`status` = 'publish' AND `ItemSticky`.`type` = 'new' AND `ItemSticky`.`status` = 'publish' ORDER BY `position` ASC | 26 | 26 | 1 | |
| SELECT `ItemImage`.`id`, `ItemImage`.`created`, `ItemImage`.`updated`, `ItemImage`.`item_id`, `ItemImage`.`image`, `ItemImage`.`position` FROM `test_tochigi`.`item_images` AS `ItemImage` WHERE `ItemImage`.`item_id` IN (127, 126, 18, 125, 37, 108, 1, 119, 120, 105, 114, 122, 112, 110, 117, 116, 111, 109, 113, 97, 98, 102, 101, 99, 123, 124) | 115 | 115 | 1 | |
| SELECT `Item`.`id`, `Item`.`created`, `Item`.`updated`, `Item`.`status`, `Item`.`name`, `Item`.`price`, `Item`.`spec`, `Item`.`content`, `Item`.`summary`, `Item`.`category_id`, `Item`.`brand_id` FROM `test_tochigi`.`items` AS `Item` LEFT JOIN `test_tochigi`.`item_stickies` AS `ItemSticky` ON (`Item`.`id` = `ItemSticky`.`item_id`) WHERE `Item`.`status` = 'publish' AND `ItemSticky`.`type` = 'recommend' AND `ItemSticky`.`status` = 'publish' ORDER BY `position` ASC | 8 | 8 | 0 | |
| SELECT `ItemImage`.`id`, `ItemImage`.`created`, `ItemImage`.`updated`, `ItemImage`.`item_id`, `ItemImage`.`image`, `ItemImage`.`position` FROM `test_tochigi`.`item_images` AS `ItemImage` WHERE `ItemImage`.`item_id` IN (94, 93, 31, 30, 32, 27, 29, 28) | 69 | 69 | 1 | |
| SELECT `HomeImage`.`id`, `HomeImage`.`created`, `HomeImage`.`updated`, `HomeImage`.`status`, `HomeImage`.`title`, `HomeImage`.`image`, `HomeImage`.`url`, `HomeImage`.`position` FROM `test_tochigi`.`home_images` AS `HomeImage` WHERE `status` = 'publish' ORDER BY `position` asc | 3 | 3 | 0 | |
| SELECT `Link`.`id`, `Link`.`created`, `Link`.`updated`, `Link`.`status`, `Link`.`name`, `Link`.`content`, `Link`.`url`, `Link`.`thumbnail`, `Link`.`position` FROM `test_tochigi`.`links` AS `Link` WHERE `Link`.`status` = 'publish' ORDER BY `position` asc LIMIT 8 | 2 | 2 | 0 | |
| SELECT `PlusGallery`.`id`, `PlusGallery`.`created`, `PlusGallery`.`updated`, `PlusGallery`.`date`, `PlusGallery`.`status`, `PlusGallery`.`title`, `PlusGallery`.`content`, `PlusGallery`.`image`, `PlusGallery`.`position` FROM `test_tochigi`.`plus_galleries` AS `PlusGallery` WHERE `PlusGallery`.`status` = 'publish' ORDER BY `position` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`name` FROM `test_tochigi`.`categories` AS `Category` WHERE `Category`.`status` = 'publish' AND `type` = 'post' ORDER BY `name` ASC | 3 | 3 | 0 | |
| SELECT `Category`.`id`, `Category`.`name` FROM `test_tochigi`.`categories` AS `Category` WHERE `Category`.`status` = 'publish' AND `type` = 'category' ORDER BY `name` ASC | 23 | 23 | 0 | |
| SELECT `Category`.`id`, `Category`.`name` FROM `test_tochigi`.`categories` AS `Category` WHERE `Category`.`status` = 'publish' AND `type` = 'brand' ORDER BY `name` ASC | 53 | 53 | 0 | |
| SELECT `Item`.`category_id`, count(category_id) count FROM `test_tochigi`.`items` AS `Item` WHERE `Item`.`status` = 'publish' AND `Item`.`category_id` >= 1 GROUP BY category_id | 16 | 16 | 1 | maybe slow |
| SELECT `Item`.`brand_id`, count(brand_id) count FROM `test_tochigi`.`items` AS `Item` WHERE `Item`.`status` = 'publish' AND `Item`.`brand_id` >= 1 GROUP BY brand_id | 24 | 24 | 0 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND `category_post_id` = 3 | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND `category_post_id` = 6 | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND `category_post_id` = 22 | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('10',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('66',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('5',`Topic`.`category_line_id`) | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('8',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('65',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('34',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('18',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('12',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('64',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('17',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('38',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('63',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('62',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('81',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('13',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('20',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('82',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('87',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('86',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('79',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('67',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('80',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('15',`Topic`.`category_line_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('49',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('24',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('39',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('26',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('59',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('58',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('23',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('84',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('83',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('48',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('42',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('75',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('52',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('37',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('14',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('50',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('44',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('73',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('55',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('35',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('76',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('71',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('11',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('54',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('43',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('41',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('25',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('47',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('27',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('74',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('16',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('77',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('56',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('36',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('85',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('9',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('32',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('51',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('60',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('30',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('31',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('40',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('4',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('28',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('29',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('45',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('46',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('72',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('33',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('57',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('53',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('78',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' AND FIND_IN_SET('19',`Topic`.`category_brand_id`) | 1 | 1 | 1 | |
| SELECT LEFT( date, 7) name, count( LEFT( date, 7)) count, `Topic`.`id` FROM `test_tochigi`.`topics` AS `Topic` LEFT JOIN `test_tochigi`.`categories` AS `Category` ON (`Topic`.`category_post_id` = `Category`.`id` AND `Topic`.`category_post_id` = `Category`.`id`) WHERE `Topic`.`status` = 'publish' GROUP BY LEFT( date, 7) ORDER BY `name` desc | 51 | 51 | 2 | |
| SELECT `Recommend`.`id`, `Recommend`.`created`, `Recommend`.`updated`, `Recommend`.`parent`, `Recommend`.`parent_id`, `Recommend`.`item_id` FROM `test_tochigi`.`recommends` AS `Recommend` WHERE `parent` = 'Topic' AND `Recommend`.`parent_id` IN (826, 825, 824, 759, 736, 715, 692, 670, 645, 624, 601, 579, 546, 536, 514, 495, 474, 444, 429, 404, 384, 357, 333, 313, 297, 285, 268, 240, 217, 191, 159, 132, 129, 112, 88, 87, 71, 67, 47, 45, 41, 40, 38, 35, 32, 26, 25, 20, 17, 14, 7) | 9 | 9 | 0 | |