SHOW FULL COLUMNS FROM `sp_sys_setting` [ RunTime:0.001947s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000723s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000850s ]
SHOW FULL COLUMNS FROM `sp_goods_cate` [ RunTime:0.002304s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 0 ORDER BY `id` DESC [ RunTime:0.000760s ]
SELECT `id`,`name`,`pid` FROM `sp_goods_cate` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000601s ]
SELECT `id` FROM `sp_goods_cate` WHERE `pid` = 37 AND `status` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000639s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 37 ORDER BY `id` DESC [ RunTime:0.000618s ]
SHOW FULL COLUMNS FROM `sp_goods_cate_relation` [ RunTime:0.001650s ]
SELECT * FROM `sp_goods_cate_relation` WHERE `cate_id` = 39 ORDER BY `id` DESC [ RunTime:0.001294s ]
SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.002441s ]
SELECT COUNT(*) AS think_count FROM `sp_goods` WHERE ( `id` IN (1406,1405,1404,1403,1402,1401,1400,1399,1392,1391,1390,1389,1388,1387,1386,1385,1384,1383,1382,1381,1380,1379,1378,1377,1376,1375,1374,1373,1372,1371,1370,1369,1368,1367,1366,1365,1364,1363,1362,1361,1360,1359,1358,1357,1355,1354,1353,1352,1351,1350,1349,1348,1347,1346,1345,1344,1343,1342,1341,1340,1339,1338,1337,1336,1335,1334,1333,1332,1331,1330,1329,1328,1327,1326,1325,1324,1323,1322,1321,1320,1319,1318,1317,1316,1314,1313,1312,1311,1310,1309,1308,1307,1306,1305,1304,1303,1302,1301,1300,1299,1298,1297,1296,1295,1294,1293,1292,1291,1290,1289,1288,1287,1286,1285,1284,1283,1282,1281,1280,1279,1278,1277,1276,1275,1274,1273,1272,1271,1270,1269,1268,1267,1266,1265,1264,1263,1262,1261,1260,1259,1257,1256,1255,1254,1253,1252,1251,1250,1249,1248,1247,1246,1245,1244,1243,1242,1241,1240,1239,1238,1237,1236,1235,1234,1233,1230,1229,1228,1227,1225,1224,1223,1222,1218,1217,1216,1215,1214,1213,1212,1211,1210,1209,1208,1207,1206,1205,1204,1203,1202,1201,1200,1199,1198,1197,1196,1195,1194,1193,1192,1191,1190,1189,1188,1187,1186,1185,1184,1183,1182,1181,1173,1174,1171,1170,1169,1168,1167,1166,1165,1164,1163,1162,1159,1158,1157,1156,1155,1154,1153,1152,1151,1150,1149,1148,1147,1146,1145,1144,1143,1142,1141,1140,1139,1138,1137,1136,1135,1134,1133,1132,1131,1130,1129,1128,1127,1126,1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,608,607,606,605,604,603,602,601,600,599,598,595,594,593,592,591,590,589,588,587,586,585,584,583,582,581,580,579,578,577,576,575,574,573,572,571,570,569,568,567,566,565,564,563,562,561,560,559,558,557,556,555,554,553,552,551,550,549,548,326,325,324) AND `is_del` = 2 AND `is_show` = 1 ) [ RunTime:0.002887s ]
SELECT `id`,`name`,`slider_image`,`sales`,`collects`,`price` FROM `sp_goods` WHERE ( `id` IN (1406,1405,1404,1403,1402,1401,1400,1399,1392,1391,1390,1389,1388,1387,1386,1385,1384,1383,1382,1381,1380,1379,1378,1377,1376,1375,1374,1373,1372,1371,1370,1369,1368,1367,1366,1365,1364,1363,1362,1361,1360,1359,1358,1357,1355,1354,1353,1352,1351,1350,1349,1348,1347,1346,1345,1344,1343,1342,1341,1340,1339,1338,1337,1336,1335,1334,1333,1332,1331,1330,1329,1328,1327,1326,1325,1324,1323,1322,1321,1320,1319,1318,1317,1316,1314,1313,1312,1311,1310,1309,1308,1307,1306,1305,1304,1303,1302,1301,1300,1299,1298,1297,1296,1295,1294,1293,1292,1291,1290,1289,1288,1287,1286,1285,1284,1283,1282,1281,1280,1279,1278,1277,1276,1275,1274,1273,1272,1271,1270,1269,1268,1267,1266,1265,1264,1263,1262,1261,1260,1259,1257,1256,1255,1254,1253,1252,1251,1250,1249,1248,1247,1246,1245,1244,1243,1242,1241,1240,1239,1238,1237,1236,1235,1234,1233,1230,1229,1228,1227,1225,1224,1223,1222,1218,1217,1216,1215,1214,1213,1212,1211,1210,1209,1208,1207,1206,1205,1204,1203,1202,1201,1200,1199,1198,1197,1196,1195,1194,1193,1192,1191,1190,1189,1188,1187,1186,1185,1184,1183,1182,1181,1173,1174,1171,1170,1169,1168,1167,1166,1165,1164,1163,1162,1159,1158,1157,1156,1155,1154,1153,1152,1151,1150,1149,1148,1147,1146,1145,1144,1143,1142,1141,1140,1139,1138,1137,1136,1135,1134,1133,1132,1131,1130,1129,1128,1127,1126,1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,608,607,606,605,604,603,602,601,600,599,598,595,594,593,592,591,590,589,588,587,586,585,584,583,582,581,580,579,578,577,576,575,574,573,572,571,570,569,568,567,566,565,564,563,562,561,560,559,558,557,556,555,554,553,552,551,550,549,548,326,325,324) AND `is_del` = 2 AND `is_show` = 1 ) ORDER BY `price` ASC LIMIT 0,20 [ RunTime:0.003129s ]
