[ 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` = '241' AND `p`.`delete_time` = 0 AND `p`.`post_type` = 3 LIMIT 1 [ RunTime:0.024993s ]
[ 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` = '241' AND `p`.`delete_time` = 0 AND `p`.`post_type` = 3 ORDER BY `p`.`published_time` DESC LIMIT 0,12 [ RunTime:0.027192s ]
[ 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` < 1618278783 ) 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.023940s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.001926s ]
[ 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` = 911 [ RunTime:0.011370s ]
[ 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` = 908 [ RunTime:0.007379s ]
[ 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` = 906 [ RunTime:0.007294s ]
[ 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` = 308 [ RunTime:0.007633s ]
