二档减一档技巧

页面:/news/view-791052/ | 耗时:0.8142 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=791052 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=791052 LIMIT 0,1
select * from tbl_Articles_sphinx where id=791052 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1199487,378348,3205931,668493,779281,414340,3456999,474562,3292900,467963,3138845,490189,558867,1165364,753988,3471292,1983297,1137129,942699,1071120,1066057,376830,1704688,2683826,882540,1546856,2276267,677518,605140,765337) ORDER BY field (ArticleID,1199487,378348,3205931,668493,779281,414340,3456999,474562,3292900,467963,3138845,490189,558867,1165364,753988,3471292,1983297,1137129,942699,1071120,1066057,376830,1704688,2683826,882540,1546856,2276267,677518,605140,765337)