五项倒车入库技巧

页面:/news/view-874690/ | 耗时:0.5720 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=874690 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=874690 LIMIT 0,1
select * from tbl_Articles_sphinx where id=874690 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(667865,918466,685754,935426,1686847,511345,621943,594746,723845,895272,1599447,815368,661564,953120,596384,376019,1099996,1093862,1100224,763553,2641154,2393965,3272557,1351022,3140637,449721,1031848,360646,1039140,462709) ORDER BY field (ArticleID,667865,918466,685754,935426,1686847,511345,621943,594746,723845,895272,1599447,815368,661564,953120,596384,376019,1099996,1093862,1100224,763553,2641154,2393965,3272557,1351022,3140637,449721,1031848,360646,1039140,462709)