SHOW FULL COLUMNS FROM `sp_sys_setting` [ RunTime:0.000733s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000567s ]
SHOW FULL COLUMNS FROM `sp_website_adv` [ RunTime:0.000664s ]
SELECT * FROM `sp_website_adv` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000389s ]
SELECT * FROM `sp_website_adv` WHERE `position` = 2 ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000425s ]
SHOW FULL COLUMNS FROM `sp_hot_search` [ RunTime:0.000622s ]
SELECT `id`,`word`,`url` FROM `sp_hot_search` ORDER BY `sort` DESC LIMIT 8 [ RunTime:0.000377s ]
SHOW FULL COLUMNS FROM `sp_website_links` [ RunTime:0.000608s ]
SELECT * FROM `sp_website_links` WHERE `status` = 1 [ RunTime:0.000370s ]
SHOW FULL COLUMNS FROM `sp_customer` [ RunTime:0.000636s ]
SELECT * FROM `sp_customer` ORDER BY `ord1` DESC [ RunTime:0.000463s ]
SHOW FULL COLUMNS FROM `sp_goods_cate` [ RunTime:0.001004s ]
SELECT `id`,`pid`,`name`,`icon`,`amount` FROM `sp_goods_cate` WHERE ( `status` = 1 ) ORDER BY `amount` DESC LIMIT 500 [ RunTime:0.001395s ]
SHOW FULL COLUMNS FROM `sp_article_cate` [ RunTime:0.000928s ]
SELECT * FROM `sp_article_cate` WHERE `isc` = 2 AND `id` <> 1 AND `status` = 1 [ RunTime:0.000836s ]
SHOW FULL COLUMNS FROM `sp_article` [ RunTime:0.001003s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 3 [ RunTime:0.000777s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 4 [ RunTime:0.000727s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 5 [ RunTime:0.000694s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 6 [ RunTime:0.000762s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000628s ]
SELECT `id`,`name`,`level` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 0 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.000746s ]
SELECT `id`,`name`,`pid`,`level`,`seo_title`,`seo_desc`,`seo_keywords`,`amount` FROM `sp_goods_cate` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000558s ]
SHOW FULL COLUMNS FROM `sp_goods_cate_relation` [ RunTime:0.000810s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 7 LIMIT 1 [ RunTime:0.002818s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_tpl` [ RunTime:0.000846s ]
SELECT * FROM `sp_goods_rule_tpl` WHERE `cid` = 7 LIMIT 1 [ RunTime:0.000617s ]
SELECT `pid` FROM `sp_goods_cate` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000537s ]
SHOW FULL COLUMNS FROM `sp_goods_brands` [ RunTime:0.000859s ]
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`=7 and cate.goods_id = goods.id WHERE `brand`.`status` = '1' GROUP BY `brand`.`id` [ RunTime:0.005812s ]
SELECT `goods_id` FROM `sp_goods_cate_relation` WHERE `cate_id` = 7 [ RunTime:0.003256s ]
SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.001412s ]
SELECT `shudi` FROM `sp_goods` WHERE `id` IN (2984,2985,2986,2987,2988,2989,2993,2994,2996,2997,2998,2999,3000,3001,3002,3003,3006,3007,3008,3009,3010,3011,3012,3013,3015,3016,3017,3018,3020,3096,3097,3098,3103,3104,3105,3106,3107,3114,3115,3118,3119,3120,3121,3135,3136,3139,3140,3146,3160,3161,3162,3163,3165,3167,3265,3267,3268,3371,3381,3384,3386,3387,3414,3415,3458,3459,3462,3463,3464,3465,3466,3467,3468,3469,3472,3473,3474,3475,3476,3477,3478,3479,3480,3481,3482,3484,3485,3486,3487,3490,3491,3494,3505,3506,3522,3538,3550,3556,3568,3584,3585,3589,3590,3600,3601,3611,3618,3633,3642,3643,3644,3645,3649,3656,3658,3666,3671,3676,3691,3692,3694,3700,3711,3733,3736,3737,3738,3739,3745,3751,3752,3753,3754,3755,3756,3761,3768,3769,3770,3776,3777,3778,3780,3782,3783,3808,3809,3812,3813,3814,3815,3816,3819,3823,3824,3827,3831,3832,3835,3837,3839,3845,3859,3860,3864,3865,3867,3870,3871,3872,3873,3874,3893,3902,3904,3905,3910,3915,3916,3926,3927,3928,3929,3930,3931,3951,3952,3953,3954,3958,3969,3970,3975,3976,3977,3998,3999,4001,4002,4003,4004,4029,4043,4044,4059,4070,4075,4085,4093,4098,4101,4108,4127,4128,4132,4141,4142,4143,4144,4160,4161,4168,4169,4188,4189,4216,4274,4276,4277,4280,4292,4303,4306,4312,4326,4335,4357,4369,4372,4382,4402,4420,4430,4431,4432,4439,4441,4445,4451,4456,4457,4465,4466,4468,4478,4479,4486,4487,4488,4494,4495,4505,4508,4516,4537,4540,4541,4562,4575,4576,4577,4584,4585,4587,4588,4607,4612,4628,4629,4630,4636,4637,4646,4649,4651,4654,4675,4677,4684,4686,4689,4693,4695,4698,4699,4701,4722,4725,4746,4754,4761,4779,4797,4798,4814,4824,4825,4827,4837,4838,4850,4851,4852,4855,4856,4867,4871,4876,4881,4885,4886,4888,4889,4891,4897,4907,4908,4911,4918,4919,4921,4922,4923,4924,4928,4929,4930,4937,4938,4951,4966,4971,4975,4976,4978,4979,4985,4989,4997,5003,5004,5011,5012,5025,5026,5030,5034,5035,5044,5047,5054,5084,5096,5098,5100,5101,5103,5104,5105,5112,5113,5115,5117,5118,5127,5128,5135,5174,5181,5196,5203,5204,5302,5304,5305,5306,5307,5308,5309,5310,5311,5312,5313,5314,5315,5316,5317,5318,5321,5322,5323,5324,5325,5338,5344,5351,5352,5366,5367,5376,5377,5379,5401,5403,5420,5425,5431,5449,5474,5476,5478,5485,5498,5524,5530,5540,5551,5565,5593,5600,5603,5606,5615,5616,5626,5627,5628,5640,5648,5653,5663,5664,5672,5674,5675,5676,5677,5678,5679,5680,5689,5695,5700,5705,5709,5710,5723,5734,5750,5753,5764,5770,5771,5774,5782,5792,5801,5811,5812,5813,5841,5842,5843,5849,5852,5856,5873,5874,5875,5885,5913,5914,5939,5941,5942,5943,5948,5951,5961,5962,5963,5964,5965,5967,5968,5969,5977,5989,6008,6016,6024,6030,6046,6048,6050,6053,6072,6080,6120,6121,6123,6125,6141,6142,6158,6159,6164,6165,6170,6198,6199,6218,6283,6284,6286,6287,6288,6289,6292,6293,6297,6299,6300,6301,6302,6313,6319,6320,6324,6325,6348,6349,6350,6367,6393,6395,6397,6403,6404,6407,6423,6428,6470,6513,6519,6530,6552,6556,6557,6566,6569,6570,6582,6583,6584,6585,6592,6602,6612,6613,6617,6660,6662,6665,6671,6686,6691,6692,6698,6699,6706,6710,6711,6715,6716,6719,6727,6728,6730,6731,6737,6755,6757,6758,6760,6761,6762,6774,6784,6785,6786,6788,6792,6793,6795,6796,6798,6802,6803,6808,6811,6815,6819,6820,6821,6824,6826,6835,6842,6843,6844,6845,6855,6869,6874,6879,6880,6885,6891,6907,6908,6911,6912,6925,6950,6951,6952,6954,6964,6965,6966,6967,6968,6969,6976,6977,6984,6989,6990,6992,6993,7014,7015,7016,7017,7018,7019,7020,7026,7038,7047,7059,7060,7067,7071,7075,7092,7093,7094,7097,7100,7101,7105,7106,7109,7120,7121,7126,7131,7133,7135,7136,7144,7152,7153,7162,7163,7166,7179,7192,7208,7216,7220,7222,7228,7229,7230,7233,7239,7240,7245,7254,7255,7259,7269,7270,7271,7272,8914,8915,8916,8961,8962,8963,9000,9029,9030,9040,9041,6122,6290,6291,6294,6295,9147,9148,9227,9228,9246,9247,9391,9392,9393,9394,9395,9396,9397,9398,9399,9400) AND `shudi` > 0 GROUP BY `shudi` [ RunTime:0.012220s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 7 ORDER BY `sort` ASC LIMIT 500 [ RunTime:0.000763s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 8 LIMIT 1 [ RunTime:0.002530s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 9 LIMIT 1 [ RunTime:0.002476s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 10 LIMIT 1 [ RunTime:0.002391s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 11 LIMIT 1 [ RunTime:0.002451s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 60 LIMIT 1 [ RunTime:0.002340s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 67 LIMIT 1 [ RunTime:0.002322s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 338 LIMIT 1 [ RunTime:0.002378s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 96 LIMIT 1 [ RunTime:0.002467s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 140 LIMIT 1 [ RunTime:0.002428s ]
SELECT * FROM `sp_goods_cate_relation` WHERE `cate_id` = 7 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.003042s ]
SELECT COUNT(*) AS think_count FROM `sp_goods` WHERE `id` IN (9400,9399,9398,9397,9396,9395,9394,9393,9392,9391,9247,9246,9228,9227,9148,9147,6295,6294,6291,6290,6122,9041,9040,9030,9029,9000,8963,8962,8961,8916,8915,8914,7272,7271,7270,7269,7259,7255,7254,7245,7240,7239,7233,7230,7229,7228,7222,7220,7216,7208,7192,7179,7166,7163,7162,7153,7152,7144,7136,7135,7133,7131,7126,7121,7120,7109,7106,7105,7101,7100,7097,7094,7093,7092,7075,7071,7067,7060,7059,7047,7038,7026,7020,7019,7018,7017,7016,7015,7014,6993,6992,6990,6989,6984,6977,6976,6969,6968,6967,6966,6965,6964,6954,6952,6951,6950,6925,6912,6911,6908,6907,6891,6885,6880,6879,6874,6869,6855,6845,6844,6843,6842,6835,6826,6824,6821,6820,6819,6815,6811,6808,6803,6802,6798,6796,6795,6793,6792,6788,6786,6785,6784,6774,6762,6761,6760,6758,6757,6755,6737,6731,6730,6728,6727,6719,6716,6715,6711,6710,6706,6699,6698,6692,6691,6686,6671,6665,6662,6660,6617,6613,6612,6602,6592,6585,6584,6583,6582,6570,6569,6566,6557,6556,6552,6530,6519,6513,6470,6428,6423,6407,6404,6403,6397,6395,6393,6367,6350,6349,6348,6325,6324,6320,6319,6313,6302,6301,6300,6299,6297,6293,6292,6289,6288,6287,6286,6284,6283,6218,6199,6198,6170,6165,6164,6159,6158,6142,6141,6125,6123,6121,6120,6080,6072,6053,6050,6048,6046,6030,6024,6016,6008,5989,5977,5969,5968,5967,5965,5964,5963,5962,5961,5951,5948,5943,5942,5941,5939,5914,5913,5885,5875,5874,5873,5856,5852,5849,5843,5842,5841,5813,5812,5811,5801,5792,5782,5774,5771,5770,5764,5753,5750,5734,5723,5710,5709,5705,5700,5695,5689,5680,5679,5678,5677,5676,5675,5674,5672,5664,5663,5653,5648,5640,5628,5627,5626,5616,5615,5606,5603,5600,5593,5565,5551,5540,5530,5524,5498,5485,5478,5476,5474,5449,5431,5425,5420,5403,5401,5379,5377,5376,5367,5366,5352,5351,5344,5338,5325,5324,5323,5322,5321,5318,5317,5316,5315,5314,5313,5312,5311,5310,5309,5308,5307,5306,5305,5304,5302,5204,5203,5196,5181,5174,5135,5128,5127,5118,5117,5115,5113,5112,5105,5104,5103,5101,5100,5098,5096,5084,5054,5047,5044,5035,5034,5030,5026,5025,5012,5011,5004,5003,4997,4989,4985,4979,4978,4976,4975,4971,4966,4951,4938,4937,4930,4929,4928,4924,4923,4922,4921,4919,4918,4911,4908,4907,4897,4891,4889,4888,4886,4885,4881,4876,4871,4867,4856,4855,4852,4851,4850,4838,4837,4827,4825,4824,4814,4798,4797,4779,4761,4754,4746,4725,4722,4701,4699,4698,4695,4693,4689,4686,4684,4677,4675,4654,4651,4649,4646,4637,4636,4630,4629,4628,4612,4607,4588,4587,4585,4584,4577,4576,4575,4562,4541,4540,4537,4516,4508,4505,4495,4494,4488,4487,4486,4479,4478,4468,4466,4465,4457,4456,4451,4445,4441,4439,4432,4431,4430,4420,4402) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 LIMIT 1 [ RunTime:0.005463s ]
SELECT `id`,`name`,`slider_image`,`sales`,`collects`,`price`,`sku`,`sub_name`,`moq`,`bzs`,`bzdw` FROM `sp_goods` WHERE `id` IN (9400,9399,9398,9397,9396,9395,9394,9393,9392,9391,9247,9246,9228,9227,9148,9147,6295,6294,6291,6290,6122,9041,9040,9030,9029,9000,8963,8962,8961,8916,8915,8914,7272,7271,7270,7269,7259,7255,7254,7245,7240,7239,7233,7230,7229,7228,7222,7220,7216,7208,7192,7179,7166,7163,7162,7153,7152,7144,7136,7135,7133,7131,7126,7121,7120,7109,7106,7105,7101,7100,7097,7094,7093,7092,7075,7071,7067,7060,7059,7047,7038,7026,7020,7019,7018,7017,7016,7015,7014,6993,6992,6990,6989,6984,6977,6976,6969,6968,6967,6966,6965,6964,6954,6952,6951,6950,6925,6912,6911,6908,6907,6891,6885,6880,6879,6874,6869,6855,6845,6844,6843,6842,6835,6826,6824,6821,6820,6819,6815,6811,6808,6803,6802,6798,6796,6795,6793,6792,6788,6786,6785,6784,6774,6762,6761,6760,6758,6757,6755,6737,6731,6730,6728,6727,6719,6716,6715,6711,6710,6706,6699,6698,6692,6691,6686,6671,6665,6662,6660,6617,6613,6612,6602,6592,6585,6584,6583,6582,6570,6569,6566,6557,6556,6552,6530,6519,6513,6470,6428,6423,6407,6404,6403,6397,6395,6393,6367,6350,6349,6348,6325,6324,6320,6319,6313,6302,6301,6300,6299,6297,6293,6292,6289,6288,6287,6286,6284,6283,6218,6199,6198,6170,6165,6164,6159,6158,6142,6141,6125,6123,6121,6120,6080,6072,6053,6050,6048,6046,6030,6024,6016,6008,5989,5977,5969,5968,5967,5965,5964,5963,5962,5961,5951,5948,5943,5942,5941,5939,5914,5913,5885,5875,5874,5873,5856,5852,5849,5843,5842,5841,5813,5812,5811,5801,5792,5782,5774,5771,5770,5764,5753,5750,5734,5723,5710,5709,5705,5700,5695,5689,5680,5679,5678,5677,5676,5675,5674,5672,5664,5663,5653,5648,5640,5628,5627,5626,5616,5615,5606,5603,5600,5593,5565,5551,5540,5530,5524,5498,5485,5478,5476,5474,5449,5431,5425,5420,5403,5401,5379,5377,5376,5367,5366,5352,5351,5344,5338,5325,5324,5323,5322,5321,5318,5317,5316,5315,5314,5313,5312,5311,5310,5309,5308,5307,5306,5305,5304,5302,5204,5203,5196,5181,5174,5135,5128,5127,5118,5117,5115,5113,5112,5105,5104,5103,5101,5100,5098,5096,5084,5054,5047,5044,5035,5034,5030,5026,5025,5012,5011,5004,5003,4997,4989,4985,4979,4978,4976,4975,4971,4966,4951,4938,4937,4930,4929,4928,4924,4923,4922,4921,4919,4918,4911,4908,4907,4897,4891,4889,4888,4886,4885,4881,4876,4871,4867,4856,4855,4852,4851,4850,4838,4837,4827,4825,4824,4814,4798,4797,4779,4761,4754,4746,4725,4722,4701,4699,4698,4695,4693,4689,4686,4684,4677,4675,4654,4651,4649,4646,4637,4636,4630,4629,4628,4612,4607,4588,4587,4585,4584,4577,4576,4575,4562,4541,4540,4537,4516,4508,4505,4495,4494,4488,4487,4486,4479,4478,4468,4466,4465,4457,4456,4451,4445,4441,4439,4432,4431,4430,4420,4402) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.005106s ]
SHOW FULL COLUMNS FROM `sp_goods_attr` [ RunTime:0.000989s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000570s ]
SHOW FULL COLUMNS FROM `sp_seller` [ RunTime:0.001215s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000395s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000420s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000294s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000385s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000278s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000335s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000265s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000318s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000282s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000332s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000396s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000468s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000347s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000410s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000397s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000508s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000538s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000422s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000306s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000369s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000286s ]
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.000266s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000320s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000267s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000319s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000276s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000318s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000262s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000328s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000266s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000323s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000266s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000317s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000267s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000318s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000260s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000318s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000262s ]
SELECT * FROM `sp_goods` `goods` INNER JOIN `sp_goods_cate_relation` `cate` ON `cate`.`goods_id`=`goods`.`id` WHERE `cate`.`cate_id` = '7' AND `goods`.`is_recommend` = '1' LIMIT 10 [ RunTime:0.001061s ]
SELECT `id`,`name`,`slider_image`,`price`,`sales`,`sku`,`stock` FROM `sp_goods` WHERE `is_del` = 2 ORDER BY `sales` DESC LIMIT 10 [ RunTime:0.005666s ]
SHOW FULL COLUMNS FROM `sp_purchase` [ RunTime:0.000862s ]
SELECT `id`,`title` FROM `sp_purchase` WHERE `cate_id` LIKE '%|7|%' LIMIT 10 [ RunTime:0.000438s ]
SHOW FULL COLUMNS FROM `sp_supply` [ RunTime:0.000910s ]
SELECT `id`,`title` FROM `sp_supply` WHERE `cate_id` = '7' LIMIT 10 [ RunTime:0.000545s ]