Dota蓝猫的一些小技巧

页面:/news/view-208595/ | 耗时:0.8259 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=208595 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=208595 LIMIT 0,1
select * from tbl_Articles_sphinx where id=208595 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1065303,1117207,1081197,1065469,1106116,1072138,1065713,1080058,1112058,1100537,1069003,1115819,1102308,1070284,1063309,1084139,1115295,1086592,1062973,1087523,1083461,1095520,1092387,1122739,1128237,1092129,1105029,1103680,1111722,1086230) ORDER BY field (ArticleID,1065303,1117207,1081197,1065469,1106116,1072138,1065713,1080058,1112058,1100537,1069003,1115819,1102308,1070284,1063309,1084139,1115295,1086592,1062973,1087523,1083461,1095520,1092387,1122739,1128237,1092129,1105029,1103680,1111722,1086230)