分批法的特点有哪些

页面:/news/view-188827/ | 耗时:0.8294 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=188827 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=188827 LIMIT 0,1
select * from tbl_Articles_sphinx where id=188827 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1084437,1074712,1091404,1080977,1048878,1106288,1129045,1088547,1070534,1009260,1063309,1074824,1370302,1073722,1066020,1069922,1041639,1091065,1113790,1071089,1055758,1081123,1041835,1085376,1084445,1042863,1089522,1086394,1086582,1066616) ORDER BY field (ArticleID,1084437,1074712,1091404,1080977,1048878,1106288,1129045,1088547,1070534,1009260,1063309,1074824,1370302,1073722,1066020,1069922,1041639,1091065,1113790,1071089,1055758,1081123,1041835,1085376,1084445,1042863,1089522,1086394,1086582,1066616)