[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000759s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` WHERE ( (`post_title` LIKE '%瑜伽%' OR `post_title` LIKE '%瑜伽css模板%' OR `post_title` LIKE '%瑜伽响应式模板%' OR `post_title` LIKE '%瑜伽html源码%') OR (`post_keywords` LIKE '%瑜伽%' OR `post_keywords` LIKE '%瑜伽css模板%' OR `post_keywords` LIKE '%瑜伽响应式模板%' OR `post_keywords` LIKE '%瑜伽html源码%') OR (`post_excerpt` LIKE '%瑜伽%' OR `post_excerpt` LIKE '%瑜伽css模板%' OR `post_excerpt` LIKE '%瑜伽响应式模板%' OR `post_excerpt` LIKE '%瑜伽html源码%') ) [ RunTime:0.089576s ]
[ SQL ] SELECT * FROM `cmf_portal_post` WHERE ( (`post_title` LIKE '%瑜伽%' OR `post_title` LIKE '%瑜伽css模板%' OR `post_title` LIKE '%瑜伽响应式模板%' OR `post_title` LIKE '%瑜伽html源码%') OR (`post_keywords` LIKE '%瑜伽%' OR `post_keywords` LIKE '%瑜伽css模板%' OR `post_keywords` LIKE '%瑜伽响应式模板%' OR `post_keywords` LIKE '%瑜伽html源码%') OR (`post_excerpt` LIKE '%瑜伽%' OR `post_excerpt` LIKE '%瑜伽css模板%' OR `post_excerpt` LIKE '%瑜伽响应式模板%' OR `post_excerpt` LIKE '%瑜伽html源码%') ) LIMIT 0,30 [ RunTime:0.031149s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.001472s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000752s ]
[ 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 (830,906,993,1019,1029,1584,2473,2794,2813,2858,2946,2978,3629,3839,3906,3989,4061,4366,4418,4887,5186,5213,5311,5593,5669,5849,5910,6529,6533,6941) [ RunTime:0.015472s ]
[ 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.002410s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000670s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 ORDER BY `list_order` ASC [ RunTime:0.000492s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 31 ORDER BY `list_order` ASC [ RunTime:0.000551s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 53 ORDER BY `list_order` ASC [ RunTime:0.000543s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 16 ORDER BY `list_order` ASC [ RunTime:0.000567s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 69 ORDER BY `list_order` ASC [ RunTime:0.000588s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 7 ORDER BY `list_order` ASC [ RunTime:0.000472s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000760s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 ORDER BY `list_order` ASC [ RunTime:0.000704s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 53 ORDER BY `list_order` ASC [ RunTime:0.000509s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 16 ORDER BY `list_order` ASC [ RunTime:0.000714s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 42 ORDER BY `list_order` ASC [ RunTime:0.000472s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 39 ORDER BY `list_order` ASC [ RunTime:0.000301s ]
