snkrs突袭抽签技巧

页面:/news/view-3108522/ | 耗时:0.3252 s | 内存:1.89 MB | 查询:6 | 缓存读取:4 写入:2 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3108522 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3108522 LIMIT 0,1
SELECT * FROM tbl_categories where CategoryID=90024 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3108522 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(3457784,640915,488013,806738,2556923,2261600,3354239,896937,692429,2357299,944679,1165586,2535326,3521292,1927053,3485927,920882,2356306,1074956,1208638,893999,2186075,529891,1001279,2129469,2968352,3248484,3018377,425437,3371944) ORDER BY field (ArticleID,3457784,640915,488013,806738,2556923,2261600,3354239,896937,692429,2357299,944679,1165586,2535326,3521292,1927053,3485927,920882,2356306,1074956,1208638,893999,2186075,529891,1001279,2129469,2968352,3248484,3018377,425437,3371944)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90024 ORDER BY ArticleID DESC LIMIT 20