四种市场结构的对比

页面:/news/view-211732/ | 耗时:0.8271 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=211732 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=211732 LIMIT 0,1
select * from tbl_Articles_sphinx where id=211732 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1086680,1113383,1116293,1071121,1042020,1070092,1096254,1068262,1115501,1095784,1070796,1065795,1101707,1043756,1079890,1115027,1103386,1099703,1089070,980889,1101783,1082203,1083113,1080428,1093280,1104629,1041729,1119205,1062488,1105065) ORDER BY field (ArticleID,1086680,1113383,1116293,1071121,1042020,1070092,1096254,1068262,1115501,1095784,1070796,1065795,1101707,1043756,1079890,1115027,1103386,1099703,1089070,980889,1101783,1082203,1083113,1080428,1093280,1104629,1041729,1119205,1062488,1105065)