怎么查找学生成绩排名

页面:/news/view-190350/ | 耗时:0.3538 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=190350 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=190350 LIMIT 0,1
select * from tbl_Articles_sphinx where id=190350 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1055640,1087253,1081151,1102028,1121640,1117990,1132063,1367412,1101675,1106471,1068102,1090797,1098489,3192108,1112919,1072561,1073891,1086510,1087133,1113528,1118503,1084893,1116787,1108982,1065765,1076267,1297814,1126896,1129059,1087884) ORDER BY field (ArticleID,1055640,1087253,1081151,1102028,1121640,1117990,1132063,1367412,1101675,1106471,1068102,1090797,1098489,3192108,1112919,1072561,1073891,1086510,1087133,1113528,1118503,1084893,1116787,1108982,1065765,1076267,1297814,1126896,1129059,1087884)