SHOW FULL COLUMNS FROM `city` [ RunTime:0.000931s ]
SELECT * FROM `city` WHERE `cityid` = 83 LIMIT 1 [ RunTime:0.000225s ]
SHOW FULL COLUMNS FROM `points_browse` [ RunTime:0.000724s ]
SHOW FULL COLUMNS FROM `points_browselog` [ RunTime:0.000550s ]
SELECT `a`.*,EXISTS(SELECT * FROM `points_browselog` WHERE `userid` = 0 AND `browseid` = a.browseid AND `createtime` BETWEEN '2026-01-02 00:00:00' AND '2026-01-02 23:59:59' LIMIT 1) AS isbrowsed FROM `points_browse` `a` WHERE `a`.`browsestatus` = '1' AND ( `a`.`cityid` = '83' OR `a`.`cityid` = '1' ) AND `a`.`remainder` > '0' ORDER BY `a`.`cityid` DESC,`a`.`browseid` DESC LIMIT 0,20 [ RunTime:0.000301s ]
SELECT COUNT(*) AS think_count FROM `points_browse` WHERE `browsestatus` = 1 AND ( `cityid` = 83 OR `cityid` = 1 ) AND ( remainder > 0 ) LIMIT 1 [ RunTime:0.000226s ]