SHOW FULL COLUMNS FROM `sp_sys_setting` [ RunTime:0.000760s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000641s ]
SHOW FULL COLUMNS FROM `sp_website_adv` [ RunTime:0.000759s ]
SELECT * FROM `sp_website_adv` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000490s ]
SELECT * FROM `sp_website_adv` WHERE `position` = 2 ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000549s ]
SHOW FULL COLUMNS FROM `sp_hot_search` [ RunTime:0.000768s ]
SELECT `id`,`word`,`url` FROM `sp_hot_search` ORDER BY `sort` DESC LIMIT 8 [ RunTime:0.000443s ]
SHOW FULL COLUMNS FROM `sp_website_links` [ RunTime:0.000754s ]
SELECT * FROM `sp_website_links` WHERE `status` = 1 [ RunTime:0.000443s ]
SHOW FULL COLUMNS FROM `sp_customer` [ RunTime:0.000690s ]
SELECT * FROM `sp_customer` ORDER BY `ord1` DESC [ RunTime:0.000408s ]
SHOW FULL COLUMNS FROM `sp_goods_cate` [ RunTime:0.000793s ]
SELECT `id`,`pid`,`name`,`icon`,`amount` FROM `sp_goods_cate` WHERE ( `status` = 1 ) ORDER BY `amount` DESC LIMIT 500 [ RunTime:0.001081s ]
SHOW FULL COLUMNS FROM `sp_article_cate` [ RunTime:0.000713s ]
SELECT * FROM `sp_article_cate` WHERE `isc` = 2 AND `id` <> 1 AND `status` = 1 [ RunTime:0.000518s ]
SHOW FULL COLUMNS FROM `sp_article` [ RunTime:0.000930s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 3 [ RunTime:0.000573s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 4 [ RunTime:0.000542s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 5 [ RunTime:0.000537s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 6 [ RunTime:0.000572s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000730s ]
SELECT `id`,`name`,`level` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 0 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.000707s ]
SELECT `id`,`name`,`pid`,`level`,`seo_title`,`seo_desc`,`seo_keywords`,`amount` FROM `sp_goods_cate` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000444s ]
SHOW FULL COLUMNS FROM `sp_goods_cate_relation` [ RunTime:0.000844s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 7 LIMIT 1 [ RunTime:0.002925s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_tpl` [ RunTime:0.000724s ]
SELECT * FROM `sp_goods_rule_tpl` WHERE `cid` = 8 LIMIT 1 [ RunTime:0.000455s ]
SELECT `pid` FROM `sp_goods_cate` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000378s ]
SELECT * FROM `sp_goods_rule_tpl` WHERE `cid` = 7 LIMIT 1 [ RunTime:0.000442s ]
SHOW FULL COLUMNS FROM `sp_goods_brands` [ RunTime:0.000868s ]
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.004424s ]
SELECT `goods_id` FROM `sp_goods_cate_relation` WHERE `cate_id` = 8 [ RunTime:0.003013s ]
SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.001190s ]
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.002782s ]
SELECT `id`,`name`,`pid`,`seo_title`,`seo_desc`,`seo_keywords` FROM `sp_goods_cate` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`name`,`pid`,`seo_title`,`seo_desc`,`seo_keywords` FROM `sp_goods_cate` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 7 ORDER BY `sort` ASC LIMIT 500 [ RunTime:0.000720s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 8 LIMIT 1 [ RunTime:0.002803s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 9 LIMIT 1 [ RunTime:0.002770s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 10 LIMIT 1 [ RunTime:0.002846s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 11 LIMIT 1 [ RunTime:0.002843s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 60 LIMIT 1 [ RunTime:0.004322s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 67 LIMIT 1 [ RunTime:0.003578s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 338 LIMIT 1 [ RunTime:0.002840s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 96 LIMIT 1 [ RunTime:0.002830s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 140 LIMIT 1 [ RunTime:0.002935s ]
SELECT * FROM `sp_goods_cate_relation` WHERE `cate_id` = 8 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.007605s ]
SELECT COUNT(*) AS think_count FROM `sp_goods` WHERE `id` IN (9400,9399,9173,9247,9246,9041,9030,9029,9000,8962,8915,7259,7233,7230,7229,7216,7208,7192,7166,7152,7144,7133,7126,7121,7100,7097,7094,7075,7067,7060,7059,7047,7026,7020,7019,7018,7017,6990,6989,6984,6912,6907,6891,6885,6880,6879,6874,6855,6835,6824,6819,6815,6798,6793,6792,6774,6762,6761,6757,6737,6728,6727,6719,6716,6715,6613,6584,6583,6582,6570,6569,6566,6513,6470,6397,6395,6367,6348,6165,6164,6158,6142,6141,6072,6030,6024,6016,5989,5977,5965,5964,5963,5962,5942,5914,5874,5873,5843,5842,5841,5813,5812,5811,5782,5753,5734,5723,5710,5680,5672,5653,5648,5600,5593,5530,5498,5401,5366,5338,5324,5302,5204,5203,5196,5115,5105,5084,5054,5047,4976,4975,4951,4938,4937,4924,4918,4911,4897,4881,4827,4761,4695,4689,4675,4587,4585,4584,4516,4508,4505,4479,4478,4468,4445,4441,4420,4402,4277,4274,4188,4160,4128,4127,4101,4098,4093,4070,4029,4004,4003,4002,4001,3999,3998,3977,3976,3975,3958,3954,3953,3952,3951,3916,3867,3865,3864,3837,3816,3815,3814,3813,3812,3780,3778,3777,3776,3769,3768,3756,3755,3754,3753,3752,3739,3711,3700,3676,3666,3649,3644,3643,3633,3611,3601,3590,3589,3585,3584,3568,3556,3550,3538,3506,3505,3490,3469,3468,3467,3466,3465,3464,3463,3462,3459,3458,3381,3265,3121,3120,3119,3118,3115,3114,3003,3002,3001,3000,2999,2998,2997,2996,2994,2993,2989,2988,2987,2986,2985,2984) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 LIMIT 1 [ RunTime:0.004084s ]
SELECT `id`,`name`,`slider_image`,`sales`,`collects`,`price`,`sku`,`sub_name`,`moq`,`bzs`,`bzdw` FROM `sp_goods` WHERE `id` IN (9400,9399,9173,9247,9246,9041,9030,9029,9000,8962,8915,7259,7233,7230,7229,7216,7208,7192,7166,7152,7144,7133,7126,7121,7100,7097,7094,7075,7067,7060,7059,7047,7026,7020,7019,7018,7017,6990,6989,6984,6912,6907,6891,6885,6880,6879,6874,6855,6835,6824,6819,6815,6798,6793,6792,6774,6762,6761,6757,6737,6728,6727,6719,6716,6715,6613,6584,6583,6582,6570,6569,6566,6513,6470,6397,6395,6367,6348,6165,6164,6158,6142,6141,6072,6030,6024,6016,5989,5977,5965,5964,5963,5962,5942,5914,5874,5873,5843,5842,5841,5813,5812,5811,5782,5753,5734,5723,5710,5680,5672,5653,5648,5600,5593,5530,5498,5401,5366,5338,5324,5302,5204,5203,5196,5115,5105,5084,5054,5047,4976,4975,4951,4938,4937,4924,4918,4911,4897,4881,4827,4761,4695,4689,4675,4587,4585,4584,4516,4508,4505,4479,4478,4468,4445,4441,4420,4402,4277,4274,4188,4160,4128,4127,4101,4098,4093,4070,4029,4004,4003,4002,4001,3999,3998,3977,3976,3975,3958,3954,3953,3952,3951,3916,3867,3865,3864,3837,3816,3815,3814,3813,3812,3780,3778,3777,3776,3769,3768,3756,3755,3754,3753,3752,3739,3711,3700,3676,3666,3649,3644,3643,3633,3611,3601,3590,3589,3585,3584,3568,3556,3550,3538,3506,3505,3490,3469,3468,3467,3466,3465,3464,3463,3462,3459,3458,3381,3265,3121,3120,3119,3118,3115,3114,3003,3002,3001,3000,2999,2998,2997,2996,2994,2993,2989,2988,2987,2986,2985,2984) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.002980s ]
SHOW FULL COLUMNS FROM `sp_goods_attr` [ RunTime:0.001194s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000627s ]
SHOW FULL COLUMNS FROM `sp_seller` [ RunTime:0.001548s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000577s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000687s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000467s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000526s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000462s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000480s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000321s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000392s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000245s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000378s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000242s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000294s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000244s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000340s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000247s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000290s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000280s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000292s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000244s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000289s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000239s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000291s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000241s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000343s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000240s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000292s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000257s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000292s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000235s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000292s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000241s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000291s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000248s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000342s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000253s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000279s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000250s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000281s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000243s ]
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.001057s ]
SELECT `id`,`name`,`slider_image`,`price`,`sales`,`sku`,`stock` FROM `sp_goods` WHERE `is_del` = 2 ORDER BY `sales` DESC LIMIT 10 [ RunTime:0.005069s ]
SHOW FULL COLUMNS FROM `sp_purchase` [ RunTime:0.000756s ]
SELECT `id`,`title` FROM `sp_purchase` WHERE `cate_id` LIKE '%|8|%' LIMIT 10 [ RunTime:0.000395s ]
SHOW FULL COLUMNS FROM `sp_supply` [ RunTime:0.000869s ]
SELECT `id`,`title` FROM `sp_supply` WHERE `cate_id` = '8' LIMIT 10 [ RunTime:0.000377s ]