SHOW FULL COLUMNS FROM `sp_sys_setting` [ RunTime:0.000685s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000446s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000421s ]
SHOW FULL COLUMNS FROM `sp_goods_cate` [ RunTime:0.000649s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 0 ORDER BY `id` DESC [ RunTime:0.000367s ]
SELECT `id`,`name`,`pid` FROM `sp_goods_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000288s ]
SELECT `id`,`name`,`pid` FROM `sp_goods_cate` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000280s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 13 ORDER BY `id` DESC [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `sp_goods_cate_relation` [ RunTime:0.000542s ]
SELECT * FROM `sp_goods_cate_relation` WHERE `cate_id` = 14 ORDER BY `id` DESC [ RunTime:0.000448s ]
SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.000704s ]
SELECT COUNT(*) AS think_count FROM `sp_goods` WHERE `id` IN (216,215,214,213,212,210,31,173,174,175,176,177,138,137,181,180,136,134,133,131,129,125,130,111,110,109,108,104,100,99,80,79,47,45,44,43,40,39,38,172,171,170,37,168,169,167,166,165,164,36,163,162,161,160,159,34,158,157,156,33,155,154,29,32,153,152,151,150,149,148,30,24,26,147,146,145,144,22,25,143,142,141,140,135,27,28,46,42,41,35,23,10,11,12,13,9,7,8,6) AND `is_del` = 2 AND `is_show` = 1 LIMIT 1 [ RunTime:0.001572s ]
SELECT `id`,`name`,`slider_image`,`sales`,`collects`,`price` FROM `sp_goods` WHERE `id` IN (216,215,214,213,212,210,31,173,174,175,176,177,138,137,181,180,136,134,133,131,129,125,130,111,110,109,108,104,100,99,80,79,47,45,44,43,40,39,38,172,171,170,37,168,169,167,166,165,164,36,163,162,161,160,159,34,158,157,156,33,155,154,29,32,153,152,151,150,149,148,30,24,26,147,146,145,144,22,25,143,142,141,140,135,27,28,46,42,41,35,23,10,11,12,13,9,7,8,6) AND `is_del` = 2 AND `is_show` = 1 ORDER BY `price` ASC LIMIT 0,20 [ RunTime:0.001563s ]