| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| 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 `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`, `Category`.`id`, `Category`.`created`, `Category`.`updated`, `Category`.`status`, `Category`.`name`, `Category`.`type` 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 `Topic`.`id` = 630 LIMIT 1 | 1 | 1 | 0 | |
| 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` = (630) | 0 | 0 | 5 | maybe slow |
| SELECT `Category`.`id`, `Category`.`name` FROM `test_tochigi`.`categories` AS `Category` WHERE `id` IN (5, 62) | 2 | 2 | 0 | |
| SELECT `Category`.`id`, `Category`.`name` FROM `test_tochigi`.`categories` AS `Category` WHERE id = (NULL) | 0 | 0 | 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 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 | 7 | 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('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 | 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('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 | 5 | 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('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 | 3 | 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('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 | 7 | 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('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 | 6 | 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('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 | 3 | maybe slow |
| 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 | |
