常见的插花技巧

页面:/news/view-1444450/ | 耗时:0.3551 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1444450 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1444450 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1444450 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1126664,1050377,1071277,1062396,1123939,1082984,1118068,1055133,1116403,1115301,1075799,1110041,1109122,1106571,1043043,1121910,1123685,1105217,1050529,1109507,1125082,1105791,1049997,1122030,1078847,1124275,1109102,1125640,1114204,1115525) ORDER BY field (ArticleID,1126664,1050377,1071277,1062396,1123939,1082984,1118068,1055133,1116403,1115301,1075799,1110041,1109122,1106571,1043043,1121910,1123685,1105217,1050529,1109507,1125082,1105791,1049997,1122030,1078847,1124275,1109102,1125640,1114204,1115525)