快速筛选的技巧

页面:/news/view-1048369/ | 耗时:0.1111 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1048369 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1048369 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1048369 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1102646,98818,1127683,152721,99128,1082007,602317,80004,1117435,591002,2250632,467036,84533,1081973,421107,1102862,1097009,494503,1085786,534305,1110846,634283,672025,1098679,1095442,1084409,1092912,443933,455595,523506) ORDER BY field (ArticleID,1102646,98818,1127683,152721,99128,1082007,602317,80004,1117435,591002,2250632,467036,84533,1081973,421107,1102862,1097009,494503,1085786,534305,1110846,634283,672025,1098679,1095442,1084409,1092912,443933,455595,523506)