[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000604s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' AND `post`.`user_id` < 10 ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910482 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,3 [ RunTime:0.643727s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '23' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910483 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000597s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '23' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910483 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,3 [ RunTime:0.000841s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '3' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910483 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 2 [ RunTime:0.034619s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '7' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910483 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 2 [ RunTime:0.001181s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '7' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910483 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000660s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '7' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910483 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,5 [ RunTime:0.001125s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '7' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910483 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000255s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '7' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910483 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,5 [ RunTime:0.000360s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' AND `post`.`user_id` < 10 ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910483 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,10 [ RunTime:0.826009s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' AND `post`.`post_sort` = '1' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910483 ) GROUP BY `post`.`id` ORDER BY `post`.`post_sort` ASC,`post`.`id` DESC LIMIT 0,1 [ RunTime:0.784018s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' AND `post`.`post_sort` = '2' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910484 ) GROUP BY `post`.`id` ORDER BY `post`.`post_sort` ASC,`post`.`id` DESC LIMIT 0,1 [ RunTime:0.796471s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' AND `post`.`post_sort` = '3' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910485 ) GROUP BY `post`.`id` ORDER BY `post`.`post_sort` ASC,`post`.`id` DESC LIMIT 0,1 [ RunTime:0.783744s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' AND `post`.`post_sort` = '4' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910486 ) GROUP BY `post`.`id` ORDER BY `post`.`post_sort` ASC,`post`.`id` DESC LIMIT 0,1 [ RunTime:0.750259s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' AND `post`.`post_sort` = '5' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910487 ) GROUP BY `post`.`id` ORDER BY `post`.`post_sort` ASC,`post`.`id` DESC LIMIT 0,1 [ RunTime:0.738411s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' AND `post`.`post_sort` = '6' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910487 ) GROUP BY `post`.`id` ORDER BY `post`.`post_sort` ASC,`post`.`id` DESC LIMIT 0,1 [ RunTime:0.727046s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' AND `post`.`post_sort` = '7' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910488 ) GROUP BY `post`.`id` ORDER BY `post`.`post_sort` ASC,`post`.`id` DESC LIMIT 0,1 [ RunTime:0.748861s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' AND `post`.`post_sort` = '8' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910489 ) GROUP BY `post`.`id` ORDER BY `post`.`post_sort` ASC,`post`.`id` DESC LIMIT 0,1 [ RunTime:0.713381s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '41' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910489 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1 [ RunTime:0.000914s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '3' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910489 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 8 [ RunTime:0.048207s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`post_sort` = '10' ) AND ( `category_post`.`category_id` = '25' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910490 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,1 [ RunTime:0.001822s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`post_sort` = '11' ) AND ( `category_post`.`category_id` = '25' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910490 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,1 [ RunTime:0.001340s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '15' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910490 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 15 [ RunTime:2.644867s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`post_content_filtered` <> '' ) AND ( `category_post`.`category_id` = '26' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910492 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 10 [ RunTime:0.018748s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '8' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910492 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 10 [ RunTime:0.000962s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '20' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910492 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 10 [ RunTime:0.000711s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '12' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910492 ) GROUP BY `post`.`id` ORDER BY `post`.`id` DESC LIMIT 4 [ RunTime:0.000651s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '3' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910492 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 5 [ RunTime:0.045892s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '37' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910492 ) GROUP BY `post`.`id` ORDER BY `post`.`id` DESC LIMIT 4 [ RunTime:0.000966s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '43' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910492 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 10 [ RunTime:0.043300s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` IN ('1','39','63','64','65','68','69') ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910492 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 10 [ RunTime:0.506849s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '25' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910493 ) GROUP BY `post`.`id` ORDER BY `post`.`id` DESC LIMIT 0,1 [ RunTime:0.003359s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '25' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910493 ) GROUP BY `post`.`id` ORDER BY `post`.`id` DESC LIMIT 0,9 [ RunTime:0.002947s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '25' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910493 ) GROUP BY `post`.`id` ORDER BY `post`.`id` DESC LIMIT 0,1 [ RunTime:0.000327s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '25' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910493 ) GROUP BY `post`.`id` ORDER BY `post`.`id` DESC LIMIT 0,9 [ RunTime:0.000340s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '23' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910493 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 4 [ RunTime:0.000832s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '23' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910493 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 4 [ RunTime:0.000507s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '70' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910493 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1 [ RunTime:0.000655s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '7' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910493 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 3 [ RunTime:0.001026s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '7' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910493 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 3 [ RunTime:0.000301s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '3' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910493 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 4 [ RunTime:0.047262s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` IN ('44','66','67') ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910493 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 4 [ RunTime:0.022700s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '27' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910493 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 5 [ RunTime:0.001229s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id,user.user_nickname,user.signature,user.avatar FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`more` LIKE '%\"video\":\"default%' AND `post`.`user_id` > 9 ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1679910493 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 2 [ RunTime:0.258051s ]