SHOW FULL COLUMNS FROM `sp_sys_setting` [ RunTime:0.001605s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000963s ]
SHOW FULL COLUMNS FROM `sp_website_adv` [ RunTime:0.001310s ]
SELECT * FROM `sp_website_adv` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000653s ]
SELECT * FROM `sp_website_adv` WHERE `position` = 2 ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000744s ]
SHOW FULL COLUMNS FROM `sp_hot_search` [ RunTime:0.001045s ]
SELECT `id`,`word`,`url` FROM `sp_hot_search` ORDER BY `sort` DESC LIMIT 8 [ RunTime:0.000769s ]
SHOW FULL COLUMNS FROM `sp_website_links` [ RunTime:0.000991s ]
SELECT * FROM `sp_website_links` WHERE `status` = 1 [ RunTime:0.000541s ]
SHOW FULL COLUMNS FROM `sp_customer` [ RunTime:0.001077s ]
SELECT * FROM `sp_customer` ORDER BY `ord1` DESC [ RunTime:0.000518s ]
SHOW FULL COLUMNS FROM `sp_goods_cate` [ RunTime:0.000970s ]
SELECT `id`,`pid`,`name`,`icon`,`amount` FROM `sp_goods_cate` WHERE ( `status` = 1 ) ORDER BY `amount` DESC LIMIT 500 [ RunTime:0.001351s ]
SHOW FULL COLUMNS FROM `sp_article_cate` [ RunTime:0.000888s ]
SELECT * FROM `sp_article_cate` WHERE `isc` = 2 AND `id` <> 1 AND `status` = 1 [ RunTime:0.000616s ]
SHOW FULL COLUMNS FROM `sp_article` [ RunTime:0.000886s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 3 [ RunTime:0.000682s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 4 [ RunTime:0.000570s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 5 [ RunTime:0.000566s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 6 [ RunTime:0.000672s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000491s ]
SELECT `id`,`name`,`level` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 0 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.000694s ]
SELECT `id`,`name`,`pid`,`level`,`seo_title`,`seo_desc`,`seo_keywords`,`amount` FROM `sp_goods_cate` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000532s ]
SHOW FULL COLUMNS FROM `sp_goods_cate_relation` [ RunTime:0.000877s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 7 LIMIT 1 [ RunTime:0.002970s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_tpl` [ RunTime:0.000777s ]
SELECT * FROM `sp_goods_rule_tpl` WHERE `cid` = 8 LIMIT 1 [ RunTime:0.000554s ]
SELECT `pid` FROM `sp_goods_cate` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000443s ]
SELECT * FROM `sp_goods_rule_tpl` WHERE `cid` = 7 LIMIT 1 [ RunTime:0.000504s ]
SHOW FULL COLUMNS FROM `sp_goods_brands` [ RunTime:0.000849s ]
SELECT `brand`.`id`,`brand`.`name`,`brand`.`enname` FROM `sp_goods_brands` `brand` INNER JOIN `sp_goods` `goods` ON `brand`.`id`=`goods`.`brand_id` INNER JOIN `sp_goods_cate_relation` `cate` ON `cate`.`cate_id`=8 and cate.goods_id = goods.id WHERE `brand`.`status` = '1' GROUP BY `brand`.`id` [ RunTime:0.004425s ]
SELECT `goods_id` FROM `sp_goods_cate_relation` WHERE `cate_id` = 8 [ RunTime:0.002865s ]
SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.001111s ]
SELECT `shudi` FROM `sp_goods` WHERE `id` IN (2984,2985,2986,2987,2988,2989,2993,2994,2996,2997,2998,2999,3000,3001,3002,3003,3114,3115,3118,3119,3120,3121,3265,3381,3458,3459,3462,3463,3464,3465,3466,3467,3468,3469,3490,3505,3506,3538,3550,3556,3568,3584,3585,3589,3590,3601,3611,3633,3643,3644,3649,3666,3676,3700,3711,3739,3752,3753,3754,3755,3756,3768,3769,3776,3777,3778,3780,3812,3813,3814,3815,3816,3837,3864,3865,3867,3916,3951,3952,3953,3954,3958,3975,3976,3977,3998,3999,4001,4002,4003,4004,4029,4070,4093,4098,4101,4127,4128,4160,4188,4274,4277,4402,4420,4441,4445,4468,4478,4479,4505,4508,4516,4584,4585,4587,4675,4689,4695,4761,4827,4881,4897,4911,4918,4924,4937,4938,4951,4975,4976,5047,5054,5084,5105,5115,5196,5203,5204,5302,5324,5338,5366,5401,5498,5530,5593,5600,5648,5653,5672,5680,5710,5723,5734,5753,5782,5811,5812,5813,5841,5842,5843,5873,5874,5914,5942,5962,5963,5964,5965,5977,5989,6016,6024,6030,6072,6141,6142,6158,6164,6165,6348,6367,6395,6397,6470,6513,6566,6569,6570,6582,6583,6584,6613,6715,6716,6719,6727,6728,6737,6757,6761,6762,6774,6792,6793,6798,6815,6819,6824,6835,6855,6874,6879,6880,6885,6891,6907,6912,6984,6989,6990,7017,7018,7019,7020,7026,7047,7059,7060,7067,7075,7094,7097,7100,7121,7126,7133,7144,7152,7166,7192,7208,7216,7229,7230,7233,7259,8915,8962,9000,9029,9030,9041,9246,9247,9173,9399,9400) AND `shudi` > 0 GROUP BY `shudi` [ RunTime:0.002560s ]
SELECT `id` FROM `sp_goods_cate` WHERE `pid` = 8 AND `status` = 1 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 8 ORDER BY `sort` ASC LIMIT 500 [ RunTime:0.000606s ]
SELECT * FROM `sp_goods_cate_relation` WHERE `cate_id` IS NULL ORDER BY `id` DESC LIMIT 500 [ RunTime:0.003796s ]
SELECT COUNT(*) AS think_count FROM `sp_goods` WHERE 0 = 1 AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 LIMIT 1 [ RunTime:0.000348s ]
SELECT * FROM `sp_goods` `goods` INNER JOIN `sp_goods_cate_relation` `cate` ON `cate`.`goods_id`=`goods`.`id` WHERE `cate`.`cate_id` = '8' AND `goods`.`is_recommend` = '1' LIMIT 10 [ RunTime:0.001017s ]
SELECT `id`,`name`,`slider_image`,`price`,`sales`,`sku`,`stock` FROM `sp_goods` WHERE `is_del` = 2 ORDER BY `sales` DESC LIMIT 10 [ RunTime:0.004814s ]
SHOW FULL COLUMNS FROM `sp_purchase` [ RunTime:0.000842s ]
SELECT `id`,`title` FROM `sp_purchase` WHERE `cate_id` LIKE '%|8|%' LIMIT 10 [ RunTime:0.000392s ]
SHOW FULL COLUMNS FROM `sp_supply` [ RunTime:0.000835s ]
SELECT `id`,`title` FROM `sp_supply` WHERE `cate_id` = '8' LIMIT 10 [ RunTime:0.000368s ]