考科目一全程技巧

页面:/news/view-411533/ | 耗时:0.3659 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=411533 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=411533 LIMIT 0,1
select * from tbl_Articles_sphinx where id=411533 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(839595,484112,719739,401073,2741823,3399594,819258,398769,802857,3258545,436544,857144,1358163,1152612,606534,468356,441419,623017,676685,381992,1134777,590666,840066,548158,593276,358859,3249515,570544,410538,789329) ORDER BY field (ArticleID,839595,484112,719739,401073,2741823,3399594,819258,398769,802857,3258545,436544,857144,1358163,1152612,606534,468356,441419,623017,676685,381992,1134777,590666,840066,548158,593276,358859,3249515,570544,410538,789329)