[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000829s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` WHERE ( (`post_title` LIKE '%交友html%' OR `post_title` LIKE '%交友%' OR `post_title` LIKE '%交友css模板%' OR `post_title` LIKE '%交友html模板%' OR `post_title` LIKE '%交友网站模板%') OR (`post_keywords` LIKE '%交友html%' OR `post_keywords` LIKE '%交友%' OR `post_keywords` LIKE '%交友css模板%' OR `post_keywords` LIKE '%交友html模板%' OR `post_keywords` LIKE '%交友网站模板%') OR (`post_excerpt` LIKE '%交友html%' OR `post_excerpt` LIKE '%交友%' OR `post_excerpt` LIKE '%交友css模板%' OR `post_excerpt` LIKE '%交友html模板%' OR `post_excerpt` LIKE '%交友网站模板%') ) [ RunTime:0.113482s ]
[ SQL ] SELECT * FROM `cmf_portal_post` WHERE ( (`post_title` LIKE '%交友html%' OR `post_title` LIKE '%交友%' OR `post_title` LIKE '%交友css模板%' OR `post_title` LIKE '%交友html模板%' OR `post_title` LIKE '%交友网站模板%') OR (`post_keywords` LIKE '%交友html%' OR `post_keywords` LIKE '%交友%' OR `post_keywords` LIKE '%交友css模板%' OR `post_keywords` LIKE '%交友html模板%' OR `post_keywords` LIKE '%交友网站模板%') OR (`post_excerpt` LIKE '%交友html%' OR `post_excerpt` LIKE '%交友%' OR `post_excerpt` LIKE '%交友css模板%' OR `post_excerpt` LIKE '%交友html模板%' OR `post_excerpt` LIKE '%交友网站模板%') ) LIMIT 30,30 [ RunTime:0.478770s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.000956s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.011774s ]
[ 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 (5672,5875,8225,10017,10051,10137,10139,10167,10170,10171,10199,10210,10353,10354,10385,15587,15699,15706,15725,15730,15731,15733,15743,15744,15808,15918,15919,15956,18860,19182) [ RunTime:0.008390s ]
[ 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.000904s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.012902s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 ORDER BY `list_order` ASC [ RunTime:0.000956s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 31 ORDER BY `list_order` ASC [ RunTime:0.000809s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 53 ORDER BY `list_order` ASC [ RunTime:0.000422s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 16 ORDER BY `list_order` ASC [ RunTime:0.000799s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 69 ORDER BY `list_order` ASC [ RunTime:0.001542s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 7 ORDER BY `list_order` ASC [ RunTime:0.001237s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.003741s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 ORDER BY `list_order` ASC [ RunTime:0.002796s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 53 ORDER BY `list_order` ASC [ RunTime:0.004696s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 16 ORDER BY `list_order` ASC [ RunTime:0.008801s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 42 ORDER BY `list_order` ASC [ RunTime:0.001805s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 39 ORDER BY `list_order` ASC [ RunTime:0.001420s ]
