科目二垂直入库技巧

页面:/news/view-3492869/ | 耗时:0.9011 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3492869 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3492869 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3492869 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(677814,822674,403819,646157,537227,603374,744852,3129597,1749444,666435,691617,2467997,381038,695117,359876,840066,593056,732037,1837196,1550347,732711,3247754,791138,781681,498374,452453,1058724,1197541,712509,3461037) ORDER BY field (ArticleID,677814,822674,403819,646157,537227,603374,744852,3129597,1749444,666435,691617,2467997,381038,695117,359876,840066,593056,732037,1837196,1550347,732711,3247754,791138,781681,498374,452453,1058724,1197541,712509,3461037)