保存栗子的3个小技巧

页面:/news/view-3506844/ | 耗时:0.4167 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3506844 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3506844 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3506844 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1118302,1087803,1107178,986059,1120719,1109316,1070576,1050529,1093633,1109487,1122411,1120211,1122867,1118120,1048298,1076766,1117868,1066264,1114010,1055133,1123533,1045683,1117704,1112606,1098301,1099201,1107739,1096959,1080531,1106467) ORDER BY field (ArticleID,1118302,1087803,1107178,986059,1120719,1109316,1070576,1050529,1093633,1109487,1122411,1120211,1122867,1118120,1048298,1076766,1117868,1066264,1114010,1055133,1123533,1045683,1117704,1112606,1098301,1099201,1107739,1096959,1080531,1106467)