三大搜索引擎特性对比分析

页面:/news/view-3130875/ | 耗时:0.8644 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3130875 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3130875 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3130875 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1354448,185144,252999,359863,1364879,291427,1293495,700832,1343073,1491769,1327547,1339085,699149,1471638,1479402,304032,292873,1301160,534166,1280407,663410,1572583,316009,182731,891198,401950,116375,178788,1043884,146912) ORDER BY field (ArticleID,1354448,185144,252999,359863,1364879,291427,1293495,700832,1343073,1491769,1327547,1339085,699149,1471638,1479402,304032,292873,1301160,534166,1280407,663410,1572583,316009,182731,891198,401950,116375,178788,1043884,146912)