[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `banmo_ask` `post` LEFT JOIN `banmo_user` `w` ON `post`.`uid`=`w`.`id` LEFT JOIN `banmo_ask_support` `s` ON `post`.`id`=s.ask_id and s.uid=0 WHERE `post`.`sid` = 18118 AND ( post.status = 0 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000701s ]
[ SQL ] SELECT w.id as wuid,`w`.`user_nickname`,w.name as wname,`w`.`avatar`,`w`.`headimgurl`,`post`.*,s.id as sid FROM `banmo_ask` `post` LEFT JOIN `banmo_user` `w` ON `post`.`uid`=`w`.`id` LEFT JOIN `banmo_ask_support` `s` ON `post`.`id`=s.ask_id and s.uid=0 WHERE `post`.`sid` = 18118 AND ( post.status = 0 ) GROUP BY `post`.`id` ORDER BY `cai` DESC,`support` DESC,`id` DESC LIMIT 0,300 [ RunTime:0.000726s ]
