排序方法有哪几种

页面:/news/view-567692/ | 耗时:0.1640 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=567692 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=567692 LIMIT 0,1
select * from tbl_Articles_sphinx where id=567692 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(510279,1304993,425703,1063916,550623,539179,1189082,81198,2758007,2527978,1128686,2739881,397732,2215250,1093212,672992,3041824,405832,962900,2678800,389015,924510,371725,856313,3334595,86272,1446522,406635,1116480,100652) ORDER BY field (ArticleID,510279,1304993,425703,1063916,550623,539179,1189082,81198,2758007,2527978,1128686,2739881,397732,2215250,1093212,672992,3041824,405832,962900,2678800,389015,924510,371725,856313,3334595,86272,1446522,406635,1116480,100652)