正循环与反循环的区别

页面:/news/view-103570/ | 耗时:0.5490 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=103570 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=103570 LIMIT 0,1
select * from tbl_Articles_sphinx where id=103570 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1118943,1057908,1112570,1050331,1078116,1110041,1123663,1111586,1096298,1096877,1129631,1043637,1110626,1124181,1117209,1067917,1084213,1116105,1121280,1106455,1117083,1100037,1111439,1104567,1076864,1114934,1123356,1123799,1118825,1121586) ORDER BY field (ArticleID,1118943,1057908,1112570,1050331,1078116,1110041,1123663,1111586,1096298,1096877,1129631,1043637,1110626,1124181,1117209,1067917,1084213,1116105,1121280,1106455,1117083,1100037,1111439,1104567,1076864,1114934,1123356,1123799,1118825,1121586)