SHOW FULL COLUMNS FROM `city` [ RunTime:0.001149s ]
SELECT * FROM `city` WHERE `cityid` = 83 LIMIT 1 [ RunTime:0.000384s ]
SHOW FULL COLUMNS FROM `points_task` [ RunTime:0.000908s ]
SELECT * FROM `points_task` WHERE `taskstatus` = 2 AND ( remainder ) AND ( `cityid` = 83 OR `cityid` = 1 ) AND ( num != completed ) ORDER BY `cityid` DESC,`updatetime` DESC LIMIT 20,20 [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `points_task_apply` [ RunTime:0.001000s ]
SELECT * FROM `points_task_apply` WHERE `userid` = 0 AND `taskid` IN (5,1) [ RunTime:0.000371s ]
SELECT COUNT(*) AS think_count FROM `points_task` WHERE `taskstatus` = 2 AND ( remainder ) AND ( `cityid` = 83 OR `cityid` = 1 ) AND ( num != completed ) LIMIT 1 [ RunTime:0.000572s ]