[ 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` = '1629' AND `p`.`delete_time` = 0 AND `p`.`post_type` = 3 LIMIT 1 [ RunTime:0.017433s ]
[ 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` = '1629' AND `p`.`delete_time` = 0 AND `p`.`post_type` = 3 ORDER BY `p`.`published_time` DESC LIMIT 0,18 [ RunTime:0.025850s ]
[ 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` < 1620967701 ) 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.021284s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.002049s ]
[ 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` = 1771 [ RunTime:0.007790s ]
