按成绩排位子的利与弊

页面:/news/view-189257/ | 耗时:0.2255 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=189257 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=189257 LIMIT 0,1
select * from tbl_Articles_sphinx where id=189257 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1098747,1074306,1091952,1077208,1077074,1082203,1085154,1118152,1104335,1108237,1084471,1061030,1109040,1063551,1109499,1119389,1109671,1107687,1067089,1087713,1090541,1085904,1115265,1077976,1096611,1107386,1091183,1115001,1062973,1109308) ORDER BY field (ArticleID,1098747,1074306,1091952,1077208,1077074,1082203,1085154,1118152,1104335,1108237,1084471,1061030,1109040,1063551,1109499,1119389,1109671,1107687,1067089,1087713,1090541,1085904,1115265,1077976,1096611,1107386,1091183,1115001,1062973,1109308)