select c.contentid,c.url,c.inputtime,c.title,c.thumb,c.introduction,c.userid,c.companyname,c.areaid,c.groupid,c.linkqq,c.price from cont_product_temp c where 1=1 AND c.catid in (1249,1082,1084,1083,1250,1087,1088,1089,1090,1091,1996,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1997,1998,2017,2018,2019,2020,2021,2306,2307,2308,2309,2310,2311,2312,2313,2314,2315,2316,2317,2318,2319,2320,2321,2322,2323,2324,2325,2326,2327,2328,2329,2330,2331,2332,2333,2334,2335,2336,2337,2338) order by c.groupid desc,c.inputtime desc 求助各位大侠 这样的mysql 语句如何优化
解决方案 »
- php时间问题
- moxiu.com这样的在线制作手机主题生成那怎么实现的
- echo 双引号变量解析问题
- 基本问题 PHP页面代码 到底是运行在客户端(浏览器来解释他)还是服务端(网站服务器解释他)?
- phpmyadmin出错问题
- PHPWind出售贴如何统一换成交易币
- 如何将-rw-r--r--格式的FTP权限转为0777格式的!
- 有一个文件,共有四行内容如下,行与行之间是用\r来换行的,现在我想得到第三行的数据内容,应该如何做呢
- ***我这贴子挂了几天,还是没人能解,这其实对高手来说是很简单的问题!!!再次加分挂贴!!!
- 询问: extract() 出错
- 如何使用ASP或者PHP脚本语言实现如下功能
- 宾馆客房管理程序
2.加上limit;
3.groupid desc,inputtime加索引;
4.找你的联系的id,用between
别的没办法了
比如:
select contentid,url,inputtime,title,thumb,introduction,userid,companyname,areaid,groupid,linkqq,price from cont_product_temp where catid in (1249,1082,1084,1083,1250) or (catid between 1087 and 2338) order by groupid desc,inputtime desc