SET NAMES 'utf8'

SELECT `id`, `parent_id`, `name`, `slug`, `public`, `show_in_post` 
FROM `category` 
ORDER BY `name`

SELECT `id`, `name` 
FROM `category` 
WHERE (`public` = 1) AND (`show_in_post` = 1) AND (`category`.`id` = '287')

SELECT `post`.*, IFNULL(get_post_title(`post`.`id`, `post`.`rotate_title`), `post`.`name`) AS
`nameTitle`, IF(`post`.`photo_id` IS NOT NULL, (
SELECT `photo`.`url` 
FROM `photo` 
WHERE `photo`.`id`=`post`.`photo_id`), IF(`post`.`file_id` IS NOT NULL, (
SELECT CONCAT('/static/files/', `file`.`path`, `file`.`filename`, ".", `file`.`extension`) AS `url` 
FROM `file` 
WHERE `file`.`id`=`post`.`file_id`), NULL)) AS `photoUrl` 
FROM `post` FORCE INDEX (`post_article_base_index`) 
LEFT JOIN `post_2_category` ON `post`.`id` = `post_2_category`.`post_id` AND
(`post_2_category`.`category_id` = '287') 
WHERE (`post`.`post_type_id` = 2) AND (`post`.`post_state_id` = 3) AND (`post`.`publish_date` <=
NOW()) AND (`post`.`unpublish_date` IS NULL OR (`post`.`unpublish_date` IS NOT NULL AND
`post`.`unpublish_date` >= NOW())) AND (`post_2_category`.`category_id` = '287') 
ORDER BY `publish_date` DESC 
LIMIT 9 
OFFSET 144