SHOW FULL COLUMNS FROM `sp_sys_setting` [ RunTime:0.001064s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000822s ]
SHOW FULL COLUMNS FROM `sp_website_adv` [ RunTime:0.000901s ]
SELECT * FROM `sp_website_adv` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000469s ]
SELECT * FROM `sp_website_adv` WHERE `position` = 2 ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000489s ]
SHOW FULL COLUMNS FROM `sp_hot_search` [ RunTime:0.000867s ]
SELECT `id`,`word`,`url` FROM `sp_hot_search` ORDER BY `sort` DESC LIMIT 8 [ RunTime:0.000588s ]
SHOW FULL COLUMNS FROM `sp_website_links` [ RunTime:0.000731s ]
SELECT * FROM `sp_website_links` WHERE `status` = 1 [ RunTime:0.000420s ]
SHOW FULL COLUMNS FROM `sp_customer` [ RunTime:0.000726s ]
SELECT * FROM `sp_customer` ORDER BY `ord1` DESC [ RunTime:0.000553s ]
SHOW FULL COLUMNS FROM `sp_goods_cate` [ RunTime:0.001003s ]
SELECT `id`,`pid`,`name`,`icon`,`amount` FROM `sp_goods_cate` WHERE ( `status` = 1 ) ORDER BY `amount` DESC LIMIT 500 [ RunTime:0.001118s ]
SHOW FULL COLUMNS FROM `sp_article_cate` [ RunTime:0.000834s ]
SELECT * FROM `sp_article_cate` WHERE `isc` = 2 AND `id` <> 1 AND `status` = 1 [ RunTime:0.000599s ]
SHOW FULL COLUMNS FROM `sp_article` [ RunTime:0.000859s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 3 [ RunTime:0.000583s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 4 [ RunTime:0.000572s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 5 [ RunTime:0.000575s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 6 [ RunTime:0.000579s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000544s ]
SELECT `id`,`name`,`level` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 0 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.000716s ]
SELECT `id`,`name`,`pid`,`level`,`seo_title`,`seo_desc`,`seo_keywords`,`amount` FROM `sp_goods_cate` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000606s ]
SHOW FULL COLUMNS FROM `sp_goods_cate_relation` [ RunTime:0.000774s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 12 LIMIT 1 [ RunTime:0.002856s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_tpl` [ RunTime:0.000728s ]
SELECT * FROM `sp_goods_rule_tpl` WHERE `cid` = 12 LIMIT 1 [ RunTime:0.000642s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_items` [ RunTime:0.000741s ]
SELECT * FROM `sp_goods_rule_items` WHERE `rule_tpl_id` = 7 ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000643s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_values` [ RunTime:0.000932s ]
SELECT * FROM `sp_goods_rule_values` WHERE `rule_item_id` IN (32,33,34,35,36,37) ORDER BY `sort_order` ASC,`id` ASC,`sort_order` ASC,`id` ASC [ RunTime:0.000840s ]
SHOW FULL COLUMNS FROM `sp_goods_brands` [ RunTime:0.000886s ]
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`=12 and cate.goods_id = goods.id WHERE `brand`.`status` = '1' GROUP BY `brand`.`id` [ RunTime:0.004487s ]
SELECT `goods_id` FROM `sp_goods_cate_relation` WHERE `cate_id` = 12 [ RunTime:0.002891s ]
SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.001317s ]
SELECT `shudi` FROM `sp_goods` WHERE `id` IN (2887,2888,2889,2890,2892,2893,2894,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2920,2921,2922,2983,3041,3042,3043,3044,3045,3046,3047,3048,3050,3052,3054,3055,3058,3059,3060,3061,3090,3091,3092,3128,3129,3131,3132,3133,3134,3183,3184,3185,3225,3235,3238,3239,3243,3272,3273,3282,3283,3336,3344,3380,3388,3389,3390,3391,3392,3503,3535,3540,3583,3606,3609,3610,3622,3623,3624,3625,3626,3627,3628,3629,3630,3646,3654,3659,3668,3688,3708,3717,3723,3725,3726,3727,3728,3730,3743,3744,3746,3747,3766,3820,3841,3855,3869,3887,3918,3979,3980,3981,4042,4086,4087,4088,4089,4090,4091,4092,4111,4112,4259,4260,4307,4321,4341,4378,4379,4380,4392,4415,4416,4436,4437,4438,4455,4463,4473,4509,4510,4571,4572,4589,4625,4626,4627,4635,4645,4676,4678,4702,4721,4726,4759,4767,4774,4809,4844,4849,4858,4916,4917,4950,4958,4959,4995,4996,5010,5013,5029,5037,5038,5053,5066,5067,5075,5122,5123,5163,5175,5390,5402,5411,5413,5414,5467,5475,5550,5566,5567,5735,5737,5738,5739,5759,5814,5816,5824,5882,5883,5884,5936,5975,5976,6026,6077,6105,6193,6217,6228,6310,6326,6329,6399,6405,6408,6456,6472,6479,6480,6483,6493,6509,6518,6532,6599,6697,6717,6718,6767,6794,6799,6800,6801,6837,6887,6937,6938,6949,6961,6981,6994,7002,7003,7004,7005,7007,7008,7045,7046,7076,7103,7104,7138,7140,7141,7142,7143,7219,7242,8985,9146,9177,9178,9203,9225,9234,9042) AND `shudi` > 0 GROUP BY `shudi` [ RunTime:0.002986s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 12 ORDER BY `sort` ASC LIMIT 500 [ RunTime:0.000790s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 13 LIMIT 1 [ RunTime:0.002808s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 43 LIMIT 1 [ RunTime:0.002686s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 14 LIMIT 1 [ RunTime:0.002626s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 51 LIMIT 1 [ RunTime:0.002645s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 44 LIMIT 1 [ RunTime:0.002624s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 98 LIMIT 1 [ RunTime:0.002634s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 108 LIMIT 1 [ RunTime:0.002631s ]
SELECT * FROM `sp_goods_cate_relation` WHERE `cate_id` = 12 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.004260s ]
SELECT COUNT(*) AS think_count FROM `sp_goods` WHERE `id` IN (9042,9234,9225,9203,9178,9177,9146,8985,7242,7219,7143,7142,7141,7140,7138,7104,7103,7076,7046,7045,7008,7007,7005,7004,7003,7002,6994,6981,6961,6949,6938,6937,6887,6837,6801,6800,6799,6794,6767,6718,6717,6697,6599,6532,6518,6509,6493,6483,6480,6479,6472,6456,6408,6405,6399,6329,6326,6310,6228,6217,6193,6105,6077,6026,5976,5975,5936,5884,5883,5882,5824,5816,5814,5759,5739,5738,5737,5735,5567,5566,5550,5475,5467,5414,5413,5411,5402,5390,5175,5163,5123,5122,5075,5067,5066,5053,5038,5037,5029,5013,5010,4996,4995,4959,4958,4950,4917,4916,4858,4849,4844,4809,4774,4767,4759,4726,4721,4702,4678,4676,4645,4635,4627,4626,4625,4589,4572,4571,4510,4509,4473,4463,4455,4438,4437,4436,4416,4415,4392,4380,4379,4378,4341,4321,4307,4260,4259,4112,4111,4092,4091,4090,4089,4088,4087,4086,4042,3981,3980,3979,3918,3887,3869,3855,3841,3820,3766,3747,3746,3744,3743,3730,3728,3727,3726,3725,3723,3717,3708,3688,3668,3659,3654,3646,3630,3629,3628,3627,3626,3625,3624,3623,3622,3610,3609,3606,3583,3540,3535,3503,3392,3391,3390,3389,3388,3380,3344,3336,3283,3282,3273,3272,3243,3239,3238,3235,3225,3185,3184,3183,3134,3133,3132,3131,3129,3128,3092,3091,3090,3061,3060,3059,3058,3055,3054,3052,3050,3048,3047,3046,3045,3044,3043,3042,3041,2983,2922,2921,2920,2904,2903,2902,2901,2900,2899,2898,2897,2896,2895,2894,2893,2892,2890,2889,2888,2887) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 LIMIT 1 [ RunTime:0.002930s ]
SELECT `id`,`name`,`slider_image`,`sales`,`collects`,`price`,`sku`,`sub_name`,`moq`,`bzs`,`bzdw` FROM `sp_goods` WHERE `id` IN (9042,9234,9225,9203,9178,9177,9146,8985,7242,7219,7143,7142,7141,7140,7138,7104,7103,7076,7046,7045,7008,7007,7005,7004,7003,7002,6994,6981,6961,6949,6938,6937,6887,6837,6801,6800,6799,6794,6767,6718,6717,6697,6599,6532,6518,6509,6493,6483,6480,6479,6472,6456,6408,6405,6399,6329,6326,6310,6228,6217,6193,6105,6077,6026,5976,5975,5936,5884,5883,5882,5824,5816,5814,5759,5739,5738,5737,5735,5567,5566,5550,5475,5467,5414,5413,5411,5402,5390,5175,5163,5123,5122,5075,5067,5066,5053,5038,5037,5029,5013,5010,4996,4995,4959,4958,4950,4917,4916,4858,4849,4844,4809,4774,4767,4759,4726,4721,4702,4678,4676,4645,4635,4627,4626,4625,4589,4572,4571,4510,4509,4473,4463,4455,4438,4437,4436,4416,4415,4392,4380,4379,4378,4341,4321,4307,4260,4259,4112,4111,4092,4091,4090,4089,4088,4087,4086,4042,3981,3980,3979,3918,3887,3869,3855,3841,3820,3766,3747,3746,3744,3743,3730,3728,3727,3726,3725,3723,3717,3708,3688,3668,3659,3654,3646,3630,3629,3628,3627,3626,3625,3624,3623,3622,3610,3609,3606,3583,3540,3535,3503,3392,3391,3390,3389,3388,3380,3344,3336,3283,3282,3273,3272,3243,3239,3238,3235,3225,3185,3184,3183,3134,3133,3132,3131,3129,3128,3092,3091,3090,3061,3060,3059,3058,3055,3054,3052,3050,3048,3047,3046,3045,3044,3043,3042,3041,2983,2922,2921,2920,2904,2903,2902,2901,2900,2899,2898,2897,2896,2895,2894,2893,2892,2890,2889,2888,2887) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.002384s ]
SHOW FULL COLUMNS FROM `sp_goods_attr` [ RunTime:0.000849s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000556s ]
SHOW FULL COLUMNS FROM `sp_seller` [ RunTime:0.001076s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000315s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000375s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000311s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000414s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000298s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000421s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000435s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000482s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000431s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000377s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000429s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000411s ]
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.000307s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000288s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000302s ]
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.000302s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000328s ]
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.000243s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000297s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000236s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000576s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000589s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000566s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000483s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000592s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000474s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000548s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000455s ]
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.000345s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000397s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000289s ]
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.000325s ]
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.000290s ]
SELECT * FROM `sp_goods` `goods` INNER JOIN `sp_goods_cate_relation` `cate` ON `cate`.`goods_id`=`goods`.`id` WHERE `cate`.`cate_id` = '12' AND `goods`.`is_recommend` = '1' LIMIT 10 [ RunTime:0.000984s ]
SELECT `id`,`name`,`slider_image`,`price`,`sales`,`sku`,`stock` FROM `sp_goods` WHERE `is_del` = 2 ORDER BY `sales` DESC LIMIT 10 [ RunTime:0.005138s ]
SHOW FULL COLUMNS FROM `sp_purchase` [ RunTime:0.000796s ]
SELECT `id`,`title` FROM `sp_purchase` WHERE `cate_id` LIKE '%|12|%' LIMIT 10 [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `sp_supply` [ RunTime:0.000822s ]
SELECT `id`,`title` FROM `sp_supply` WHERE `cate_id` = '12' LIMIT 10 [ RunTime:0.000449s ]