[ SQL ] SELECT COUNT(*) AS tp_count FROM cmf_portal_post p INNER JOIN `cmf_portal_category_post` `pc` ON `p`.`id`=`pc`.`post_id` INNER JOIN `cmf_portal_post_extend` `pe` ON `p`.`id`=`pe`.`aid` WHERE `p`.`relation_aids` = '1764' AND `p`.`delete_time` = 0 AND `p`.`post_type` = 3 LIMIT 1 [ RunTime:0.180686s ]
[ SQL ] SELECT `p`.`id`,`p`.`post_title`,`p`.`post_hits`,`p`.`more`,`p`.`goods_gaodu`,pc.category_id as cid,`pe`.`value` FROM cmf_portal_post p INNER JOIN `cmf_portal_category_post` `pc` ON `p`.`id`=`pc`.`post_id` INNER JOIN `cmf_portal_post_extend` `pe` ON `p`.`id`=`pe`.`aid` WHERE `p`.`relation_aids` = '1764' AND `p`.`delete_time` = 0 AND `p`.`post_type` = 3 ORDER BY `p`.`published_time` DESC LIMIT 0,12 [ RunTime:0.117993s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,extend.value as extend FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_post_extend` `extend` ON `post`.`id`=`extend`.`aid` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1623702012 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` IN ('1','2','3','7','8','9','10','11','12','15','16','22','49') AND `post`.`create_time` >= 0 AND `post`.`post_title` LIKE '%杨鹏飞%' GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 8 [ RunTime:0.074500s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.002284s ]
[ 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 FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 3457 [ RunTime:0.051086s ]
[ 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 FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 3096 [ RunTime:0.015517s ]
[ 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 FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 1776 [ RunTime:0.014796s ]
[ 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 FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 1775 [ RunTime:0.026141s ]
[ 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 FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 1774 [ RunTime:0.031532s ]
[ 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 FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 1773 [ RunTime:0.047141s ]
[ 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 FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 1772 [ RunTime:0.045583s ]
