发票明细整理技巧

页面:/news/view-1729236/ | 耗时:0.3807 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1729236 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1729236 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1729236 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(578051,380507,1293071,701045,636774,2152446,1712554,998343,2010920,478750,443771,434350,1179684,994099,1166195,1465016,1577663,1029959,922889,1999367,828545,2149943,711712,1133392,2000353,2041656,1830376,2051607,956263,600424) ORDER BY field (ArticleID,578051,380507,1293071,701045,636774,2152446,1712554,998343,2010920,478750,443771,434350,1179684,994099,1166195,1465016,1577663,1029959,922889,1999367,828545,2149943,711712,1133392,2000353,2041656,1830376,2051607,956263,600424)