SHOW FULL COLUMNS FROM `city` [ RunTime:0.000906s ]
SELECT * FROM `city` WHERE `cityid` = 83 LIMIT 1 [ RunTime:0.000227s ]
SHOW FULL COLUMNS FROM `points_browse` [ RunTime:0.000728s ]
SHOW FULL COLUMNS FROM `points_browselog` [ RunTime:0.000627s ]
SELECT `a`.*,EXISTS(SELECT * FROM `points_browselog` WHERE `userid` = 0 AND `browseid` = a.browseid AND `createtime` BETWEEN '2025-11-14 00:00:00' AND '2025-11-14 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.000592s ]
SELECT COUNT(*) AS think_count FROM `points_browse` WHERE `browsestatus` = 1 AND ( `cityid` = 83 OR `cityid` = 1 ) AND ( remainder > 0 ) LIMIT 1 [ RunTime:0.000210s ]