手劈砖的技巧

页面:/news/view-321745/ | 耗时:0.9008 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=321745 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=321745 LIMIT 0,1
select * from tbl_Articles_sphinx where id=321745 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(986336,1086091,1104657,1055295,1066090,1062880,1095578,1085824,1121426,1054832,1103680,1079950,1087485,1062624,1061610,1101115,1099075,1117101,1078979,1107062,1093641,1090541,1117043,1056160,1095424,1078677,1117722,1063517,1104266,1063917) ORDER BY field (ArticleID,986336,1086091,1104657,1055295,1066090,1062880,1095578,1085824,1121426,1054832,1103680,1079950,1087485,1062624,1061610,1101115,1099075,1117101,1078979,1107062,1093641,1090541,1117043,1056160,1095424,1078677,1117722,1063517,1104266,1063917)