[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.003172s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` WHERE ( (`post_title` LIKE '%小游戏%' OR `post_title` LIKE '%h5小游戏%' OR `post_title` LIKE '%h5游戏%') OR (`post_keywords` LIKE '%小游戏%' OR `post_keywords` LIKE '%h5小游戏%' OR `post_keywords` LIKE '%h5游戏%') OR (`post_excerpt` LIKE '%小游戏%' OR `post_excerpt` LIKE '%h5小游戏%' OR `post_excerpt` LIKE '%h5游戏%') ) [ RunTime:0.177734s ]
[ SQL ] SELECT * FROM `cmf_portal_post` WHERE ( (`post_title` LIKE '%小游戏%' OR `post_title` LIKE '%h5小游戏%' OR `post_title` LIKE '%h5游戏%') OR (`post_keywords` LIKE '%小游戏%' OR `post_keywords` LIKE '%h5小游戏%' OR `post_keywords` LIKE '%h5游戏%') OR (`post_excerpt` LIKE '%小游戏%' OR `post_excerpt` LIKE '%h5小游戏%' OR `post_excerpt` LIKE '%h5游戏%') ) LIMIT 0,30 [ RunTime:0.165220s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.000893s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000478s ]
[ SQL ] SELECT `cmf_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status`,`pivot`.`is_url` AS `pivot__is_url` FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` IN (8337,11779,11780,11784,11785,11786,11789,11790,11793,11796,11797,11799,11800,11801,11803,11804,11805,11806,11807,11808,11810,11812,15573,15660,15709,15740,15771,15775,15814,15863) [ RunTime:0.058378s ]
[ SQL ] SELECT *,(SELECT COUNT(*) AS tp_count FROM `cmf_portal_category` `count_table` WHERE `status` = 1 AND ( `count_table`.`parent_id` =cmf_portal_category.id )) AS `subcategory_count` FROM `cmf_portal_category` WHERE `parent_id` = 0 AND `status` = 1 AND `delete_time` = 0 AND `name` <> '技术博客' ORDER BY `list_order` ASC [ RunTime:0.001105s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.004165s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 ORDER BY `list_order` ASC [ RunTime:0.000945s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 31 ORDER BY `list_order` ASC [ RunTime:0.000445s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 53 ORDER BY `list_order` ASC [ RunTime:0.000466s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 16 ORDER BY `list_order` ASC [ RunTime:0.000734s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 69 ORDER BY `list_order` ASC [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 7 ORDER BY `list_order` ASC [ RunTime:0.000785s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000450s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 ORDER BY `list_order` ASC [ RunTime:0.002735s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 53 ORDER BY `list_order` ASC [ RunTime:0.001053s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 16 ORDER BY `list_order` ASC [ RunTime:0.002589s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 42 ORDER BY `list_order` ASC [ RunTime:0.000640s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 39 ORDER BY `list_order` ASC [ RunTime:0.000444s ]
