考科目一有什么技巧

页面:/news/view-2049000/ | 耗时:0.6017 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2049000 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2049000 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2049000 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(390063,558589,469331,1427565,436632,427383,386702,427189,1565593,1588957,1005134,1358163,545939,595860,426422,464084,2232473,911301,536531,464950,484461,3526693,421931,480672,403819,459824,450564,410218,895739,390261) ORDER BY field (ArticleID,390063,558589,469331,1427565,436632,427383,386702,427189,1565593,1588957,1005134,1358163,545939,595860,426422,464084,2232473,911301,536531,464950,484461,3526693,421931,480672,403819,459824,450564,410218,895739,390261)