ALTER TABLE `yf_discount_goods` ADD INDEX `common_id` (`common_id`);
ALTER TABLE `yf_discount_goods` ADD INDEX `goods_id` (`goods_id`);
ALTER TABLE `yf_groupbuy_base` ADD INDEX `common_id` (`common_id`);
ALTER TABLE `yf_groupbuy_base` ADD INDEX `groupbuy_state` (`groupbuy_state`);
ALTER TABLE `yf_increase_goods` ADD INDEX `goods_id` (`goods_id`);
ALTER TABLE `yf_mansong_rule` ADD INDEX `goods_id` (`goods_id`);
####
ALTER TABLE `yf_goods_images` ADD INDEX `images_color_id` (`images_color_id`);
ALTER TABLE `yf_goods_images` ADD INDEX `common_id` (`common_id`);
ALTER TABLE `yf_order_goods` ADD INDEX `goods_id` (`goods_id`);
ALTER TABLE `yf_base_district` ADD INDEX `district_name` (`district_name`);
ALTER TABLE `yf_web_config` ADD INDEX `config_key` (`config_key`);
ALTER TABLE `yf_goods_cat_nav` ADD INDEX `goods_cat_id` (`goods_cat_id`);
ALTER TABLE `bbc`.`yf_order_goods` ADD INDEX `common_id` (`common_id`);
ALTER TABLE `bbc`.`yf_order_goods` ADD INDEX `buyer_user_id` (`buyer_user_id`);
### 活動SQL
#限時折扣
select *
from yf_discount_goods as a,yf_discount_base as b
where
a.discount_id = b.discount_id and
# 狀態， 1-正常/2-結束/3-管理員關閉
b.discount_state = 1 and
a.goods_id = 111
#團購
select * from
yf_groupbuy_base as a
where
# 1.審核中 2.正常 3.結束 4 .審核失敗 5.管理員關閉
groupbuy_state = 2 and
a.common_id = 1
#加價購
select *
from yf_increase_goods as a,yf_increase_base as b
where
a.increase_id = b.increase_id and
# 狀態， 1-正常/2-結束/3-管理員關閉
b.increase_state = 1 and
a.goods_id = 111
#滿即送
select *
from yf_mansong_rule as a,yf_mansong_base as b
where
a.mansong_id = b.mansong_id and
# 1-正常/2-已結束/3-管理員關閉，取消
b.mansong_state = 1 and
a.goods_id = 111
#拼團
select *
from yf_pintuan_detail as a,yf_pintuan as b
where
a.pintuan_id = b.id and
# 是否可用，1為可用。
b.status = 1 and
a.goods_id = 111
