SHOW FULL COLUMNS FROM `sp_sys_setting` [ RunTime:0.000815s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000640s ]
SHOW FULL COLUMNS FROM `sp_website_adv` [ RunTime:0.000810s ]
SELECT * FROM `sp_website_adv` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000498s ]
SELECT * FROM `sp_website_adv` WHERE `position` = 2 ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000572s ]
SHOW FULL COLUMNS FROM `sp_hot_search` [ RunTime:0.000745s ]
SELECT `id`,`word`,`url` FROM `sp_hot_search` ORDER BY `sort` DESC LIMIT 8 [ RunTime:0.000597s ]
SHOW FULL COLUMNS FROM `sp_website_links` [ RunTime:0.000841s ]
SELECT * FROM `sp_website_links` WHERE `status` = 1 [ RunTime:0.000545s ]
SHOW FULL COLUMNS FROM `sp_customer` [ RunTime:0.000675s ]
SELECT * FROM `sp_customer` ORDER BY `ord1` DESC [ RunTime:0.000455s ]
SHOW FULL COLUMNS FROM `sp_goods_cate` [ RunTime:0.000770s ]
SELECT `id`,`pid`,`name`,`icon`,`amount` FROM `sp_goods_cate` WHERE ( `status` = 1 ) ORDER BY `amount` DESC LIMIT 500 [ RunTime:0.001109s ]
SHOW FULL COLUMNS FROM `sp_article_cate` [ RunTime:0.000643s ]
SELECT * FROM `sp_article_cate` WHERE `isc` = 2 AND `id` <> 1 AND `status` = 1 [ RunTime:0.000451s ]
SHOW FULL COLUMNS FROM `sp_article` [ RunTime:0.000700s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 3 [ RunTime:0.000488s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 4 [ RunTime:0.000479s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 5 [ RunTime:0.000495s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 6 [ RunTime:0.000532s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000462s ]
SELECT `id`,`name`,`level` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 0 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.000617s ]
SELECT `id`,`name`,`pid`,`level`,`seo_title`,`seo_desc`,`seo_keywords`,`amount` FROM `sp_goods_cate` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000399s ]
SHOW FULL COLUMNS FROM `sp_goods_cate_relation` [ RunTime:0.000624s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 19 LIMIT 1 [ RunTime:0.002654s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_tpl` [ RunTime:0.000634s ]
SELECT * FROM `sp_goods_rule_tpl` WHERE `cid` = 19 LIMIT 1 [ RunTime:0.000394s ]
SELECT `pid` FROM `sp_goods_cate` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000325s ]
SHOW FULL COLUMNS FROM `sp_goods_brands` [ RunTime:0.000699s ]
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`=19 and cate.goods_id = goods.id WHERE `brand`.`status` = '1' GROUP BY `brand`.`id` [ RunTime:0.004084s ]
SELECT `goods_id` FROM `sp_goods_cate_relation` WHERE `cate_id` = 19 [ RunTime:0.002696s ]
SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.001146s ]
SELECT `shudi` FROM `sp_goods` WHERE `id` IN (3492,3532,3560,3561,3570,3571,3572,3573,3574,3582,3593,3594,3595,3596,3597,3598,3599,3765,3851,3886,4036,4040,4041,4046,4047,4048,4054,4055,4104,4105,4131,4146,4150,4154,4155,4175,4177,4182,4185,4194,4213,4214,4256,4257,4258,4261,4269,4270,4367,4388,4389,4410,4447,4448,4523,4525,4526,4528,4608,4647,4648,4670,4685,4706,4710,4747,4762,4763,4805,4808,4811,4823,4829,4830,4831,4832,4834,4835,4862,4864,4873,4878,4879,4906,4957,4974,5024,5058,5072,5085,5086,5090,5102,5129,5146,5197,5198,5202,5205,5206,5212,5370,5371,5382,5391,5407,5415,5464,5465,5473,5509,5516,5517,5542,5547,5589,5618,5634,5646,5665,5688,5718,5719,5749,5755,5756,5794,5795,5817,5818,5827,5828,5829,5830,5880,5903,5904,5915,5916,5917,5918,5919,5923,5924,5925,5930,5931,5932,5933,5971,5972,5978,6058,6065,6074,6129,6154,6163,6189,6211,6212,6256,6257,6306,6309,6322,6323,6351,6372,6373,6384,6391,6398,6453,6460,6461,6489,6490,6491,6497,6563,6616,6618,6619,6620,6621,6622,6623,6656,6657,6709,6778,6805,6806,6853,6854,6864,6991,7012,7013,7024,7041,7078,7088,7089,7137,7156,7160,7168,7169,7170,7171,7174,7176,7203,7204,7218,7231,9007,9038,9058,9143,9144,9209,9221,9233) AND `shudi` > 0 GROUP BY `shudi` [ RunTime:0.002444s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 19 ORDER BY `sort` ASC LIMIT 500 [ RunTime:0.000648s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 257 LIMIT 1 [ RunTime:0.002633s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 258 LIMIT 1 [ RunTime:0.002587s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 259 LIMIT 1 [ RunTime:0.002602s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 260 LIMIT 1 [ RunTime:0.002670s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 261 LIMIT 1 [ RunTime:0.002663s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 262 LIMIT 1 [ RunTime:0.002662s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 263 LIMIT 1 [ RunTime:0.002644s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 264 LIMIT 1 [ RunTime:0.002674s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 265 LIMIT 1 [ RunTime:0.002597s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 266 LIMIT 1 [ RunTime:0.002588s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 267 LIMIT 1 [ RunTime:0.002593s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 268 LIMIT 1 [ RunTime:0.002584s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 269 LIMIT 1 [ RunTime:0.002584s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 270 LIMIT 1 [ RunTime:0.002579s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 271 LIMIT 1 [ RunTime:0.002581s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 272 LIMIT 1 [ RunTime:0.002588s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 273 LIMIT 1 [ RunTime:0.002589s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 274 LIMIT 1 [ RunTime:0.002553s ]
SELECT * FROM `sp_goods_cate_relation` WHERE `cate_id` = 19 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.004224s ]
SELECT COUNT(*) AS think_count FROM `sp_goods` WHERE `id` IN (9233,9221,9209,9144,9143,9058,9038,9007,7231,7218,7204,7203,7176,7174,7171,7170,7169,7168,7160,7156,7137,7089,7088,7078,7041,7024,7013,7012,6991,6864,6854,6853,6806,6805,6778,6709,6657,6656,6623,6622,6621,6620,6619,6618,6616,6563,6497,6491,6490,6489,6461,6460,6453,6398,6391,6384,6373,6372,6351,6323,6322,6309,6306,6257,6256,6212,6211,6189,6163,6154,6129,6074,6065,6058,5978,5972,5971,5933,5932,5931,5930,5925,5924,5923,5919,5918,5917,5916,5915,5904,5903,5880,5830,5829,5828,5827,5818,5817,5795,5794,5756,5755,5749,5719,5718,5688,5665,5646,5634,5618,5589,5547,5542,5517,5516,5509,5473,5465,5464,5415,5407,5391,5382,5371,5370,5212,5206,5205,5202,5198,5197,5146,5129,5102,5090,5086,5085,5072,5058,5024,4974,4957,4906,4879,4878,4873,4864,4862,4835,4834,4832,4831,4830,4829,4823,4811,4808,4805,4763,4762,4747,4710,4706,4685,4670,4648,4647,4608,4528,4526,4525,4523,4448,4447,4410,4389,4388,4367,4270,4269,4261,4258,4257,4256,4214,4213,4194,4185,4182,4177,4175,4155,4154,4150,4146,4131,4105,4104,4055,4054,4048,4047,4046,4041,4040,4036,3886,3851,3765,3599,3598,3597,3596,3595,3594,3593,3582,3574,3573,3572,3571,3570,3561,3560,3532,3492) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 LIMIT 1 [ RunTime:0.003017s ]
SELECT `id`,`name`,`slider_image`,`sales`,`collects`,`price`,`sku`,`sub_name`,`moq`,`bzs`,`bzdw` FROM `sp_goods` WHERE `id` IN (9233,9221,9209,9144,9143,9058,9038,9007,7231,7218,7204,7203,7176,7174,7171,7170,7169,7168,7160,7156,7137,7089,7088,7078,7041,7024,7013,7012,6991,6864,6854,6853,6806,6805,6778,6709,6657,6656,6623,6622,6621,6620,6619,6618,6616,6563,6497,6491,6490,6489,6461,6460,6453,6398,6391,6384,6373,6372,6351,6323,6322,6309,6306,6257,6256,6212,6211,6189,6163,6154,6129,6074,6065,6058,5978,5972,5971,5933,5932,5931,5930,5925,5924,5923,5919,5918,5917,5916,5915,5904,5903,5880,5830,5829,5828,5827,5818,5817,5795,5794,5756,5755,5749,5719,5718,5688,5665,5646,5634,5618,5589,5547,5542,5517,5516,5509,5473,5465,5464,5415,5407,5391,5382,5371,5370,5212,5206,5205,5202,5198,5197,5146,5129,5102,5090,5086,5085,5072,5058,5024,4974,4957,4906,4879,4878,4873,4864,4862,4835,4834,4832,4831,4830,4829,4823,4811,4808,4805,4763,4762,4747,4710,4706,4685,4670,4648,4647,4608,4528,4526,4525,4523,4448,4447,4410,4389,4388,4367,4270,4269,4261,4258,4257,4256,4214,4213,4194,4185,4182,4177,4175,4155,4154,4150,4146,4131,4105,4104,4055,4054,4048,4047,4046,4041,4040,4036,3886,3851,3765,3599,3598,3597,3596,3595,3594,3593,3582,3574,3573,3572,3571,3570,3561,3560,3532,3492) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.002296s ]
SHOW FULL COLUMNS FROM `sp_goods_attr` [ RunTime:0.000889s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000530s ]
SHOW FULL COLUMNS FROM `sp_seller` [ RunTime:0.001149s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000387s ]
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.000484s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000406s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000334s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000580s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000510s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000510s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000382s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000394s ]
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.000320s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000264s ]
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.000258s ]
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.000259s ]
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.000261s ]
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.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.000260s ]
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.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.000314s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000273s ]
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.000267s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000313s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000268s ]
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.000260s ]
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.000265s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000314s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000261s ]
SELECT * FROM `sp_goods` `goods` INNER JOIN `sp_goods_cate_relation` `cate` ON `cate`.`goods_id`=`goods`.`id` WHERE `cate`.`cate_id` = '19' AND `goods`.`is_recommend` = '1' LIMIT 10 [ RunTime:0.001386s ]
SELECT `id`,`name`,`slider_image`,`price`,`sales`,`sku`,`stock` FROM `sp_goods` WHERE `is_del` = 2 ORDER BY `sales` DESC LIMIT 10 [ RunTime:0.005022s ]
SHOW FULL COLUMNS FROM `sp_purchase` [ RunTime:0.000770s ]
SELECT `id`,`title` FROM `sp_purchase` WHERE `cate_id` LIKE '%|19|%' LIMIT 10 [ RunTime:0.000392s ]
SHOW FULL COLUMNS FROM `sp_supply` [ RunTime:0.000893s ]
SELECT `id`,`title` FROM `sp_supply` WHERE `cate_id` = '19' LIMIT 10 [ RunTime:0.000393s ]