SHOW FULL COLUMNS FROM `sp_sys_setting` [ RunTime:0.000809s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000562s ]
SHOW FULL COLUMNS FROM `sp_website_adv` [ RunTime:0.000932s ]
SELECT * FROM `sp_website_adv` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000465s ]
SELECT * FROM `sp_website_adv` WHERE `position` = 2 ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `sp_hot_search` [ RunTime:0.000746s ]
SELECT `id`,`word`,`url` FROM `sp_hot_search` ORDER BY `sort` DESC LIMIT 8 [ RunTime:0.000456s ]
SHOW FULL COLUMNS FROM `sp_website_links` [ RunTime:0.000756s ]
SELECT * FROM `sp_website_links` WHERE `status` = 1 [ RunTime:0.000455s ]
SHOW FULL COLUMNS FROM `sp_customer` [ RunTime:0.000674s ]
SELECT * FROM `sp_customer` ORDER BY `ord1` DESC [ RunTime:0.000452s ]
SHOW FULL COLUMNS FROM `sp_goods_cate` [ RunTime:0.000837s ]
SELECT `id`,`pid`,`name`,`icon`,`amount` FROM `sp_goods_cate` WHERE ( `status` = 1 ) ORDER BY `amount` DESC LIMIT 500 [ RunTime:0.001100s ]
SHOW FULL COLUMNS FROM `sp_article_cate` [ RunTime:0.000885s ]
SELECT * FROM `sp_article_cate` WHERE `isc` = 2 AND `id` <> 1 AND `status` = 1 [ RunTime:0.000528s ]
SHOW FULL COLUMNS FROM `sp_article` [ RunTime:0.000766s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 3 [ RunTime:0.000630s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 4 [ RunTime:0.000623s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 5 [ RunTime:0.000621s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 6 [ RunTime:0.000650s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000546s ]
SELECT `id`,`name`,`level` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 0 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.000677s ]
SELECT `id`,`name`,`pid`,`level`,`seo_title`,`seo_desc`,`seo_keywords`,`amount` FROM `sp_goods_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000501s ]
SHOW FULL COLUMNS FROM `sp_goods_cate_relation` [ RunTime:0.000762s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 1 LIMIT 1 [ RunTime:0.002536s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_tpl` [ RunTime:0.000699s ]
SELECT * FROM `sp_goods_rule_tpl` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.000399s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_items` [ RunTime:0.000633s ]
SELECT * FROM `sp_goods_rule_items` WHERE `rule_tpl_id` = 4 ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000578s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_values` [ RunTime:0.000708s ]
SELECT * FROM `sp_goods_rule_values` WHERE `rule_item_id` IN (117,118,119,120,121,122) ORDER BY `sort_order` ASC,`id` ASC,`sort_order` ASC,`id` ASC [ RunTime:0.000678s ]
SHOW FULL COLUMNS FROM `sp_goods_brands` [ RunTime:0.000840s ]
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`=1 and cate.goods_id = goods.id WHERE `brand`.`status` = '1' GROUP BY `brand`.`id` [ RunTime:0.005142s ]
SELECT `goods_id` FROM `sp_goods_cate_relation` WHERE `cate_id` = 1 [ RunTime:0.002906s ]
SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.001084s ]
SELECT `shudi` FROM `sp_goods` WHERE `id` IN (2818,2821,2860,2864,2865,2866,2867,2868,2869,2870,2871,2877,2878,2879,2881,2882,2883,2884,2885,2886,2905,2906,3030,3031,3032,3035,3036,3037,3038,3039,3040,3063,3067,3070,3071,3072,3073,3074,3075,3077,3078,3079,3081,3083,3084,3085,3087,3089,3094,3108,3109,3110,3111,3138,3148,3149,3150,3186,3192,3194,3195,3196,3197,3198,3199,3227,3231,3232,3240,3242,3250,3251,3263,3264,3276,3277,3278,3279,3280,3281,3289,3337,3339,3340,3341,3342,3343,3345,3346,3347,3348,3350,3353,3354,3355,3356,3359,3360,3361,3365,3366,3368,3370,3372,3373,3374,3378,3393,3394,3395,3438,3439,3488,3496,3497,3501,3502,3520,3521,3536,3537,3544,3546,3554,3555,3576,3578,3579,3580,3588,3605,3608,3614,3617,3637,3655,3661,3663,3672,3674,3675,3680,3681,3682,3683,3684,3690,3693,3695,3696,3699,3701,3702,3707,3709,3718,3719,3740,3741,3742,3749,3763,3764,3773,3774,3775,3784,3786,3787,3789,3790,3794,3795,3796,3797,3798,3801,3802,3803,3805,3806,3807,3811,3828,3843,3856,3857,3858,3861,3863,3868,3884,3885,3888,3889,3890,3891,3892,3894,3908,3909,3921,3922,3925,3932,3933,3938,3940,3941,3943,3944,3945,3946,3947,3948,3949,3950,3957,3959,3960,3962,3963,3974,3982,3983,3985,3993,3996,4006,4039,4051,4056,4061,4063,4064,4065,4066,4069,4071,4072,4073,4074,4082,4094,4096,4099,4113,4121,4122,4123,4125,4133,4136,4156,4157,4158,4159,4171,4180,4183,4184,4190,4202,4204,4209,4210,4217,4218,4219,4221,4291,4295,4302,4305,4308,4309,4310,4317,4325,4327,4328,4374,4381,4424,4428,4440,4464,4474,4476,4477,4480,4482,4492,4512,4513,4514,4530,4553,4554,4582,4597,4601,4603,4615,4621,4623,4639,4660,4661,4663,4669,4688,4691,4692,4705,4728,4729,4730,4731,4732,4735,4739,4778,4784,4785,4791,4793,4794,4795,4796,4799,4800,4801,4802,4806,4828,4842,4843,4860,4877,4884,4900,4902,4926,4932,4934,4998,5001,5041,5042,5043,5048,5049,5055,5082,5139,5140,5156,5157,5176,5177,5178,5179,5180,5185,5186,5192,5201,5207,5215,5216,5300,5345,5346,5347,5348,5349,5350,5385,5386,5387,5398,5428,5429,5430,5438,5439,5440,5452,5491,5493,5494,5527,5528,5529,5531,5534,5536,5549,5554,5569,5590,5597,5602,5623,5625,5629,5630,5631,5633,5651,5669,5670,5681,5682,5687,5691,5692,5714,5715,5716,5720,5722,5725,5726,5727,5733,5743,5767,5768,5779,5793,5802,5803,5823,5831,5832,5833,5851,5853,5859,5862,5863,5864,5865,5870,5871,5872,5878,5905,5927,5935,5945,5990,6013,6014,6019,6023,6027,6036,6037,6039,6064,6066,6073,6089,6090,6091,6092,6093,6094,6095,6096,6097,6098,6099,6115,6118,6119,6126,6130,6131,6132,6140,6146,6149,6153,6156,6157,6182,6188,6190,6195,6196,6200,6223,6224,6249,6258,6259,6260,6264,6271,6275,6296,6331,6334,6335,6337,6341,6344,6357,6360,6361,6362,6369,6371,6376,6377,6378,6381,6410,6411,6429,6440,6443,6454,6457,6459,6463,6465,6467,6468,6469,6487,6488,6555,6560,6561,6562,6565,6567,6580,6593,6596,6597,6598,6601,6605,6606,6627,6640,6641,6659,6674,6683,6702,6703,6720,6721,6722,6734,6736,6745,6746,6752,6768,6769,6807,6812,6863,6877,6883,6884,6917,6918,6919,6926,6945,6946,6958,6959,7034,7035,7036,7037,7042,7053,7058,7061,7062,7063,7083,7087,7095,7110,7111,7119,7123,7125,7130,7132,7134,7151,7172,7185,7186,7187,7196,7200,7205,7213,7214,7215,7237,7238,7243,7248,7249,7257,7264,7265,7266,7267,7275,7276,7277,7278,4496,8890,8891,8900,8904,8905,8906,8907,8908,8909,8910,8911,8912,8913,7184,5861,3883,8937,8938,8947,8951,8952,8953,8954,8955,8956,8957,8958,8959,8960,8992,8993,8997,8998,8999,9012,9031,9032,9033,9034,9035,9036,9039,9149,9172,9181,9182,9186,9204,9205,9208,9230,9236,9237,9243,9244,9245,9254,9256,9261,9262,9264,9018,9413,9414,9415,9416,9417,9418,9419,9420,9421,9422,9423,9401,9402,9403,9404,7279,7124,3076,4067) AND `shudi` > 0 GROUP BY `shudi` [ RunTime:0.008092s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 1 ORDER BY `sort` ASC LIMIT 500 [ RunTime:0.000714s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 2 LIMIT 1 [ RunTime:0.002563s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 107 LIMIT 1 [ RunTime:0.002540s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 106 LIMIT 1 [ RunTime:0.002533s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 132 LIMIT 1 [ RunTime:0.002549s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 46 LIMIT 1 [ RunTime:0.002529s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 3 LIMIT 1 [ RunTime:0.002644s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 4 LIMIT 1 [ RunTime:0.002744s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 5 LIMIT 1 [ RunTime:0.002799s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 56 LIMIT 1 [ RunTime:0.002719s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 6 LIMIT 1 [ RunTime:0.002531s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 69 LIMIT 1 [ RunTime:0.002528s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 131 LIMIT 1 [ RunTime:0.002484s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 47 LIMIT 1 [ RunTime:0.002451s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 344 LIMIT 1 [ RunTime:0.002587s ]
SELECT * FROM `sp_goods_cate_relation` WHERE `cate_id` = 1 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.003760s ]
SELECT COUNT(*) AS think_count FROM `sp_goods` WHERE `id` IN (4067,3076,7124,7279,9404,9403,9402,9401,9423,9422,9421,9420,9419,9418,9417,9416,9415,9414,9413,9018,9264,9262,9261,9256,9254,9245,9244,9243,9237,9236,9230,9208,9205,9204,9186,9182,9181,9172,9149,9039,9036,9035,9034,9033,9032,9031,9012,8999,8998,8997,8993,8992,8960,8959,8958,8957,8956,8955,8954,8953,8952,8951,8947,8938,8937,3883,5861,7184,8913,8912,8911,8910,8909,8908,8907,8906,8905,8904,8900,8891,8890,4496,7278,7277,7276,7275,7267,7266,7265,7264,7257,7249,7248,7243,7238,7237,7215,7214,7213,7205,7200,7196,7187,7186,7185,7172,7151,7134,7132,7130,7125,7123,7119,7111,7110,7095,7087,7083,7063,7062,7061,7058,7053,7042,7037,7036,7035,7034,6959,6958,6946,6945,6926,6919,6918,6917,6884,6883,6877,6863,6812,6807,6769,6768,6752,6746,6745,6736,6734,6722,6721,6720,6703,6702,6683,6674,6659,6641,6640,6627,6606,6605,6601,6598,6597,6596,6593,6580,6567,6565,6562,6561,6560,6555,6488,6487,6469,6468,6467,6465,6463,6459,6457,6454,6443,6440,6429,6411,6410,6381,6378,6377,6376,6371,6369,6362,6361,6360,6357,6344,6341,6337,6335,6334,6331,6296,6275,6271,6264,6260,6259,6258,6249,6224,6223,6200,6196,6195,6190,6188,6182,6157,6156,6153,6149,6146,6140,6132,6131,6130,6126,6119,6118,6115,6099,6098,6097,6096,6095,6094,6093,6092,6091,6090,6089,6073,6066,6064,6039,6037,6036,6027,6023,6019,6014,6013,5990,5945,5935,5927,5905,5878,5872,5871,5870,5865,5864,5863,5862,5859,5853,5851,5833,5832,5831,5823,5803,5802,5793,5779,5768,5767,5743,5733,5727,5726,5725,5722,5720,5716,5715,5714,5692,5691,5687,5682,5681,5670,5669,5651,5633,5631,5630,5629,5625,5623,5602,5597,5590,5569,5554,5549,5536,5534,5531,5529,5528,5527,5494,5493,5491,5452,5440,5439,5438,5430,5429,5428,5398,5387,5386,5385,5350,5349,5348,5347,5346,5345,5300,5216,5215,5207,5201,5192,5186,5185,5180,5179,5178,5177,5176,5157,5156,5140,5139,5082,5055,5049,5048,5043,5042,5041,5001,4998,4934,4932,4926,4902,4900,4884,4877,4860,4843,4842,4828,4806,4802,4801,4800,4799,4796,4795,4794,4793,4791,4785,4784,4778,4739,4735,4732,4731,4730,4729,4728,4705,4692,4691,4688,4669,4663,4661,4660,4639,4623,4621,4615,4603,4601,4597,4582,4554,4553,4530,4514,4513,4512,4492,4482,4480,4477,4476,4474,4464,4440,4428,4424,4381,4374,4328,4327,4325,4317,4310,4309,4308,4305,4302,4295,4291,4221,4219,4218,4217,4210,4209,4204,4202,4190,4184,4183,4180,4171,4159,4158,4157,4156,4136,4133,4125,4123,4122,4121,4113,4099,4096,4094,4082,4074,4073,4072,4071,4069,4066,4065,4064,4063,4061,4056,4051,4039,4006,3996,3993,3985,3983,3982,3974,3963,3962,3960,3959,3957,3950,3949,3948,3947,3946,3945,3944) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 LIMIT 1 [ RunTime:0.005989s ]
SELECT `id`,`name`,`slider_image`,`sales`,`collects`,`price`,`sku`,`sub_name`,`moq`,`bzs`,`bzdw` FROM `sp_goods` WHERE `id` IN (4067,3076,7124,7279,9404,9403,9402,9401,9423,9422,9421,9420,9419,9418,9417,9416,9415,9414,9413,9018,9264,9262,9261,9256,9254,9245,9244,9243,9237,9236,9230,9208,9205,9204,9186,9182,9181,9172,9149,9039,9036,9035,9034,9033,9032,9031,9012,8999,8998,8997,8993,8992,8960,8959,8958,8957,8956,8955,8954,8953,8952,8951,8947,8938,8937,3883,5861,7184,8913,8912,8911,8910,8909,8908,8907,8906,8905,8904,8900,8891,8890,4496,7278,7277,7276,7275,7267,7266,7265,7264,7257,7249,7248,7243,7238,7237,7215,7214,7213,7205,7200,7196,7187,7186,7185,7172,7151,7134,7132,7130,7125,7123,7119,7111,7110,7095,7087,7083,7063,7062,7061,7058,7053,7042,7037,7036,7035,7034,6959,6958,6946,6945,6926,6919,6918,6917,6884,6883,6877,6863,6812,6807,6769,6768,6752,6746,6745,6736,6734,6722,6721,6720,6703,6702,6683,6674,6659,6641,6640,6627,6606,6605,6601,6598,6597,6596,6593,6580,6567,6565,6562,6561,6560,6555,6488,6487,6469,6468,6467,6465,6463,6459,6457,6454,6443,6440,6429,6411,6410,6381,6378,6377,6376,6371,6369,6362,6361,6360,6357,6344,6341,6337,6335,6334,6331,6296,6275,6271,6264,6260,6259,6258,6249,6224,6223,6200,6196,6195,6190,6188,6182,6157,6156,6153,6149,6146,6140,6132,6131,6130,6126,6119,6118,6115,6099,6098,6097,6096,6095,6094,6093,6092,6091,6090,6089,6073,6066,6064,6039,6037,6036,6027,6023,6019,6014,6013,5990,5945,5935,5927,5905,5878,5872,5871,5870,5865,5864,5863,5862,5859,5853,5851,5833,5832,5831,5823,5803,5802,5793,5779,5768,5767,5743,5733,5727,5726,5725,5722,5720,5716,5715,5714,5692,5691,5687,5682,5681,5670,5669,5651,5633,5631,5630,5629,5625,5623,5602,5597,5590,5569,5554,5549,5536,5534,5531,5529,5528,5527,5494,5493,5491,5452,5440,5439,5438,5430,5429,5428,5398,5387,5386,5385,5350,5349,5348,5347,5346,5345,5300,5216,5215,5207,5201,5192,5186,5185,5180,5179,5178,5177,5176,5157,5156,5140,5139,5082,5055,5049,5048,5043,5042,5041,5001,4998,4934,4932,4926,4902,4900,4884,4877,4860,4843,4842,4828,4806,4802,4801,4800,4799,4796,4795,4794,4793,4791,4785,4784,4778,4739,4735,4732,4731,4730,4729,4728,4705,4692,4691,4688,4669,4663,4661,4660,4639,4623,4621,4615,4603,4601,4597,4582,4554,4553,4530,4514,4513,4512,4492,4482,4480,4477,4476,4474,4464,4440,4428,4424,4381,4374,4328,4327,4325,4317,4310,4309,4308,4305,4302,4295,4291,4221,4219,4218,4217,4210,4209,4204,4202,4190,4184,4183,4180,4171,4159,4158,4157,4156,4136,4133,4125,4123,4122,4121,4113,4099,4096,4094,4082,4074,4073,4072,4071,4069,4066,4065,4064,4063,4061,4056,4051,4039,4006,3996,3993,3985,3983,3982,3974,3963,3962,3960,3959,3957,3950,3949,3948,3947,3946,3945,3944) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.005256s ]
SHOW FULL COLUMNS FROM `sp_goods_attr` [ RunTime:0.000846s ]
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.001263s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000323s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000494s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000358s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000402s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000270s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000315s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000249s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000321s ]
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.000306s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000274s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000305s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000232s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000322s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000252s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000327s ]
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.000325s ]
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.000288s ]
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.000288s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000243s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000301s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000238s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000330s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000259s ]
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.000262s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000311s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000272s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000324s ]
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.000312s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000269s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000315s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000258s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000311s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000272s ]
SELECT * FROM `sp_goods` `goods` INNER JOIN `sp_goods_cate_relation` `cate` ON `cate`.`goods_id`=`goods`.`id` WHERE `cate`.`cate_id` = '1' AND `goods`.`is_recommend` = '1' LIMIT 10 [ RunTime:0.000922s ]
SELECT `id`,`name`,`slider_image`,`price`,`sales`,`sku`,`stock` FROM `sp_goods` WHERE `is_del` = 2 ORDER BY `sales` DESC LIMIT 10 [ RunTime:0.005115s ]
SHOW FULL COLUMNS FROM `sp_purchase` [ RunTime:0.000831s ]
SELECT `id`,`title` FROM `sp_purchase` WHERE `cate_id` LIKE '%|1|%' LIMIT 10 [ RunTime:0.000419s ]
SHOW FULL COLUMNS FROM `sp_supply` [ RunTime:0.000845s ]
SELECT `id`,`title` FROM `sp_supply` WHERE `cate_id` = '1' LIMIT 10 [ RunTime:0.000409s ]