减肚腩简单有效方法

页面:/news/view-460746/ | 耗时:0.5535 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=460746 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=460746 LIMIT 0,1
select * from tbl_Articles_sphinx where id=460746 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(395970,1127082,1164679,571248,808448,681687,3513060,422094,1461728,724762,994527,980474,799390,775104,1130562,1562300,3208428,1125311,485963,2026923,3456334,1499326,3237722,709148,476159,1066086,418819,528765,1205148,973917) ORDER BY field (ArticleID,395970,1127082,1164679,571248,808448,681687,3513060,422094,1461728,724762,994527,980474,799390,775104,1130562,1562300,3208428,1125311,485963,2026923,3456334,1499326,3237722,709148,476159,1066086,418819,528765,1205148,973917)