实践的三个基本形式

页面:/news/view-2412650/ | 耗时:0.9402 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2412650 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2412650 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2412650 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1116948,1103342,1117652,1089040,1047309,1113417,1071661,1092225,1099121,1063181,1106054,1068564,1068118,1126760,1057595,1097815,1089464,1091061,1087439,1074880,1107965,1086582,1081687,1108141,1095784,1101527,1088549,1100515,1097351,1097283) ORDER BY field (ArticleID,1116948,1103342,1117652,1089040,1047309,1113417,1071661,1092225,1099121,1063181,1106054,1068564,1068118,1126760,1057595,1097815,1089464,1091061,1087439,1074880,1107965,1086582,1081687,1108141,1095784,1101527,1088549,1100515,1097351,1097283)