SHOW FULL COLUMNS FROM `sp_sys_setting` [ RunTime:0.002980s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.001393s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000799s ]
SHOW FULL COLUMNS FROM `sp_goods_cate` [ RunTime:0.001367s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 0 ORDER BY `id` DESC [ RunTime:0.000857s ]
SELECT `id`,`name`,`pid` FROM `sp_goods_cate` WHERE `id` = 65 LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`name`,`pid` FROM `sp_goods_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 1 ORDER BY `id` DESC [ RunTime:0.000577s ]
SHOW FULL COLUMNS FROM `sp_goods_cate_relation` [ RunTime:0.001019s ]
SELECT * FROM `sp_goods_cate_relation` WHERE `cate_id` = 65 ORDER BY `id` DESC [ RunTime:0.001533s ]
SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.001573s ]
SELECT COUNT(*) AS think_count FROM `sp_goods` WHERE `id` IN (261,262,253,344,342,343,265,323,322,321,320,319,317,316,45,219,220,221,222,223,314,313,312,311,310,309,308,307,306,305,304,303,302,301,225,226,268,269,274,273,272,271,270,267,266,264,263,260,259,258,257,256,255,254,234,224,227,228,229,44,43,42,41,40,39,36,35,33,31,30,29,28,27,26,25,24,23,22,21,20,19,18,11,10,9,8,7,6,5,4,3,2,1) AND `is_del` = 2 AND `is_show` = 1 LIMIT 1 [ RunTime:0.004158s ]
SELECT `id`,`name`,`slider_image`,`sales`,`collects`,`price` FROM `sp_goods` WHERE `id` IN (261,262,253,344,342,343,265,323,322,321,320,319,317,316,45,219,220,221,222,223,314,313,312,311,310,309,308,307,306,305,304,303,302,301,225,226,268,269,274,273,272,271,270,267,266,264,263,260,259,258,257,256,255,254,234,224,227,228,229,44,43,42,41,40,39,36,35,33,31,30,29,28,27,26,25,24,23,22,21,20,19,18,11,10,9,8,7,6,5,4,3,2,1) AND `is_del` = 2 AND `is_show` = 1 ORDER BY `price` ASC LIMIT 0,20 [ RunTime:0.003164s ]