SQL语句优化(雷人代码)

SQL语句优化（雷⼈代码）

维护组项⽬出了点问题，打开⽹站越慢，部门⼏个⽼员⼯在找原因，发现⼀条SQL语句，我看到没把我雷死。

原代码：

代码

1 select top 16 goods_id,goods_name,goods_thumb,integral,cat_id from

2 goods where goods_id > 0 and cat_id = 40 and is_real = 1 and area in ( ' 000 ' , ' 0514 ' )

3 AND goods_name not like ' %B30（2G）纽曼MP3% ' and goods_name not like ' %IPOD⾳箱% '

4 and goods_name not like ' %SP-8210 史努⽐旋风吹风机% ' and goods_name not like ' %zippo打⽕机150ZL% '

5 and goods_name not like ' %ZIPPO打⽕机205% ' and goods_name not like ' %zippo打⽕机280AW陆军空战银章% '

6 and goods_name not like ' %爱国者⾳箱SP-F021% ' and goods_name not like ' %爱国者⾳箱SP-F027% '

7 and goods_name not like ' %铂⾦多⽤汤锅DFS-T012% ' and goods_name not like ' %不锈钢快速⽔壶OL-209% '

8 and goods_name not like ' %不锈钢快速⽔壶OL-215% ' and goods_name not like ' %不锈钢密封碗三件套% '

9 and goods_name not like ' %彩棉浴⼱% ' and goods_name not like ' %超⼈电吹风SB80% '

10 and goods_name not like ' %超⼈电须⼑SA35% ' and goods_name not like ' %超⼈电须⼑SA850% '

11 and goods_name not like ' %超⼈电熨⽃SY570% ' and goods_name not like ' %超⼈⽑球修剪器SR2855% '

12 and goods_name not like ' %超⼈剃须⼑SA2701% ' and goods_name not like ' %超⼈拓威⼲鞋机TH151% '

13 and goods_name not like ' %厨具⼗⼋件套CQG1518% ' and goods_name not like ' %春笑牌USB蓝鲸电暖⼿⿏标

垫% '

14 and goods_name not like ' %春笑牌USB维尼熊电暖⼿⿏标垫% ' and goods_name not like ' %春笑牌USB喜洋洋电暖

⼿⿏标垫% '

15 and goods_name not like ' %德世朗多功能蒸煮锅% ' and goods_name not like ' %迪⼠尼保温泡菜壶% '

16 and goods_name not like ' %迪⼠尼抽真空保温杯% ' and goods_name not like ' %迪⼠尼幸运草随⼿杯% '

17 and goods_name not like ' %冬暖复合被% ' and goods_name not like ' %都彭⽜⽪⽪带8818C289% '

18 and goods_name not like ' %都彭⽜⽪⽪带8881C055% ' and goods_name not like ' %都彭⽜⽪钥匙包8855B020-

4% '

19 and goods_name not like ' %哆啦A梦便利收纳箱% ' and goods_name not like ' %哆啦A梦⼤容量真空保温杯% '

20 and goods_name not like ' %哆啦A梦红酒瓶⾬伞(黄)% ' and goods_name not like ' %哆啦A梦时尚套装礼盒DM-

2319% '

21 and goods_name not like ' %果缤纷（⼑具套装）% ' and goods_name not like ' %韩式调料缸三件套（22*24*26）%

'

22 and goods_name not like ' %好帮⼿淘⽶器% ' and goods_name not like ' %红厨铝合⾦煎盘YN0351% '

23 and goods_name not like ' %吉旺1厘⽆磁钢柄五件套装7162% '

24 and goods_name not like ' %吉旺3厘⽊纹6件套7191% ' and goods_name not like ' %康⼽ 蒸好（微波炉专⽤⼩蒸

煲）CQG2004% '

25 and goods_name not like ' %康⼽SURE不锈钢保温杯% ' and goods_name not like ' %康⼽秤⼼如意厨房秤% '

26 and goods_name not like ' %康⼽情侣密封罐CQG5001% ' and goods_name not like ' %康⼽钛真空保温杯

CQG4000% '

27 and goods_name not like ' %康⼽蒸好（微波炉专⽤⼩蒸煲）CQG2004% '

28 and goods_name not like ' %康⼽智能卡路⾥电⼦跳绳% ' and goods_name not like ' %乐扣茶杯HPL934M% '

29 and goods_name not like ' %乐扣乐扣四⽅型保鲜盒HPL809F% ' and goods_name not like ' %乐扣乐扣圆型保鲜盒

HPL933% '

30 and goods_name not like ' %乐仕菲斯贝贝乐保温提盒RSC1000K% '

31 and goods_name not like ' %乐仕菲斯单柄奶锅RS1600K% ' and goods_name not like ' %乐仕菲斯优乐套装锅

RS201T% '

32 and goods_name not like ' %绿波仙⼦（补铁绿彩套锅）% '

33 and goods_name not like ' %欧莱斯特304不锈钢⽆缝内胆⽔壶OL-818橙⾊% '

34 and goods_name not like ' %欧莱斯特304不锈钢⽆缝内胆⽔壶QL-818% '

35 and goods_name not like ' %欧然电⽔壶CR-1130% ' and goods_name not like ' %⽇式环保包袋组合（折叠环保包

+爱⼼便当包）% '

36 and goods_name not like ' %三洋SANYO 煮蛋器 JH702A% '

37 and goods_name not like ' %三洋SANYO煮蛋器JH702A% ' and goods_name not like ' %三洋电吹风DH-JH104% '

38 and goods_name not like ' %三洋电吹风HD-JH101A% '

39 and goods_name not like ' %三洋电吹风HD-JH104% ' and goods_name not like ' %三洋电熨⽃A-JH102M% '

40 and goods_name not like ' %三洋加湿器CFK-JH6013% '

41 and goods_name not like ' %膳之厨多功能锅CJ-096% ' and goods_name not like ' %膳之厨锅具两件套CJ-960% '

42 and goods_name not like ' %膳之厨时尚三件套CJ-3683% ' and goods_name not like ' %圣德保罗⼯具套装SD-007-

C% '

43 and goods_name not like ' %⼗⼋⼦作⾼级不锈钢家⽤剪WJJ-01% ' and goods_name not like ' %⼗⼋⼦作开瓶器SC-

02% '

44 and goods_name not like ' %⼗⼋⼦作雅刃六件套⼑S2902% ' and goods_name not like ' %⼗⼋⼦作银盈快刃斩切⼑

S2504-A% '

45 and goods_name not like ' %时尚折叠凳% ' and goods_name not like ' %史努⽐故事保鲜盒组SP-A123% '

46 and goods_name not like ' %史努⽐故事⽔杯SP-A317% ' and goods_name not like ' %史努⽐酷狗健康称SP-

H201% '

47 and goods_name not like ' %史努⽐酷炫多功能杯SP-A105% ' and goods_name not like ' %史努⽐亲亲四⼊冷⽔壶

SP-A203% '

48 and goods_name not like ' %史努⽐清凉⼩冰杯SP-A112% '

49 and goods_name not like ' %史努⽐提⼿杯% ' and goods_name not like ' %史努⽐幸福双层饭盒SP-C103% '

50 and goods_name not like ' %史努⽐紫洋保温杯SP-A602% ' and goods_name not like ' %天飞伞3007% '

51 and goods_name not like ' %天堂10302E国⾊天⾹伞% ' and goods_name not like ' %天堂苏印丝伞% '

52 and goods_name not like ' %西铁城电⼦体温计CT513W% ' and goods_name not like ' %⾹⼭牌电⼦健康秤

EB9003L% '

53 and goods_name not like ' %⾹⼭牌机械健康秤BR2017B% ' and goods_name not like ' %⼩天⼦钢柄⼋件套⼑A-

019% '

54 and goods_name not like ' %伊莱特3L电饭煲CFXB30-J31A% ' and goods_name not like ' %宜剪美% '

55 and goods_name not like ' %⽻梦情缘被套(简装)% ' and goods_name not like ' %⽻梦情缘床单(简装)% '

56 and goods_name not like ' %⽻梦情缘枕套(简装)% ' and goods_name not like ' %⾬花丝绒毯% '

57 and goods_name not like ' %蒸功夫蒸汤两⽤锅% ' and goods_name not like ' %⽵纤维被% ' and goods_name

not like ' %⽵纤维浴⼱% '

58 and goods_name not like ' %红厨 32cm炫雅雪花不沾炒锅YN0304% ' and goods_name not like ' %春笑牌烘鞋器

（⼤）% '

59 and goods_name not like ' %欧然不锈钢快速电⽔壶CR-1181 1.2L% ' and goods_name not like ' %春笑牌烘鞋器

（⼩）% '

60 and goods_name not like ' %史努⽐紫洋保温杯 SP-A602% ' and goods_name not like ' %欧然不锈钢快速电⽔壶CR-

1120 0.8L% '

61 and goods_id not in

62 ( select top 16 goods_id from goods where goods_id > 0 and cat_id = 40 and is_real = 1 and area in ( '

000 ' , ' 0514 ' )

63 and goods_name not like ' %B30（2G）纽曼MP3% ' and goods_name not like ' %IPOD⾳箱% '

64 and goods_name not like ' %SP-8210 史努⽐旋风吹风机% ' and goods_name not like ' %zippo打⽕机150ZL% '

65 and goods_name not like ' %ZIPPO打⽕机205% ' and goods_name not like ' %zippo打⽕机280AW陆军空战银章% '

66 and goods_name not like ' %爱国者⾳箱SP-F021% ' and goods_name not like ' %爱国者⾳箱SP-F027% '

67 and goods_name not like ' %铂⾦多⽤汤锅DFS-T012% ' and goods_name not like ' %不锈钢快速⽔壶OL-209% '

68 and goods_name not like ' %不锈钢快速⽔壶OL-215% ' and goods_name not like ' %不锈钢密封碗三件套% '

69 and goods_name not like ' %彩棉浴⼱% ' and goods_name not like ' %超⼈电吹风SB80% '

70 and goods_name not like ' %超⼈电须⼑SA35% ' and goods_name not like ' %超⼈电须⼑SA850% '

71 and goods_name not like ' %超⼈电熨⽃SY570% ' and goods_name not like ' %超⼈⽑球修剪器SR2855% '

72 and goods_name not like ' %超⼈剃须⼑SA2701% ' and goods_name not like ' %超⼈拓威⼲鞋机TH151% '

73 and goods_name not like ' %厨具⼗⼋件套CQG1518% ' and goods_name not like ' %春笑牌USB蓝鲸电暖⼿⿏标

垫% '

74 and goods_name not like ' %春笑牌USB维尼熊电暖⼿⿏标垫% ' and goods_name not like ' %春笑牌USB喜洋洋电暖

⼿⿏标垫% '

75 and goods_name not like ' %德世朗多功能蒸煮锅% ' and goods_name not like ' %迪⼠尼保温泡菜壶% '

76 and goods_name not like ' %迪⼠尼抽真空保温杯% ' and goods_name not like ' %迪⼠尼幸运草随⼿杯% '

77 and goods_name not like ' %冬暖复合被% ' and goods_name not like ' %都彭⽜⽪⽪带8818C289% '

78 and goods_name not like ' %都彭⽜⽪⽪带8881C055% ' and goods_name not like ' %都彭⽜⽪钥匙包8855B020-

4% '

79 and goods_name not like ' %哆啦A梦便利收纳箱% ' and goods_name not like ' %哆啦A梦⼤容量真空保温杯% '

80 and goods_name not like ' %哆啦A梦红酒瓶⾬伞(黄)% ' and goods_name not like ' %哆啦A梦时尚套装礼盒DM-

2319% '

81 and goods_name not like ' %果缤纷（⼑具套装）% ' and goods_name not like ' %韩式调料缸三件套（22*24*26）%

'

82 and goods_name not like ' %好帮⼿淘⽶器% ' and goods_name not like ' %红厨铝合⾦煎盘YN0351% '

83 and goods_name not like ' %吉旺1厘⽆磁钢柄五件套装7162% ' and goods_name not like ' %吉旺3厘⽊纹6件套

7191% '

84 and goods_name not like ' %康⼽ 蒸好（微波炉专⽤⼩蒸煲）CQG2004% ' and goods_name not like ' %康⼽SURE

不锈钢保温杯% '

85 and goods_name not like ' %康⼽秤⼼如意厨房秤% ' and goods_name not like ' %康⼽情侣密封罐CQG5001% '

86 and goods_name not like ' %康⼽钛真空保温杯CQG4000% '

87 and goods_name not like ' %康⼽蒸好（微波炉专⽤⼩蒸煲）CQG2004% ' and goods_name not like ' %康⼽智能卡

路⾥电⼦跳绳% '

88 and goods_name not like ' %乐扣茶杯HPL934M% ' and goods_name not like ' %乐扣乐扣四⽅型保鲜盒HPL809F%

'

89 and goods_name not like ' %乐扣乐扣圆型保鲜盒HPL933% ' and goods_name not like ' %乐仕菲斯贝贝乐保温提盒

RSC1000K% '

90 and goods_name not like ' %乐仕菲斯单柄奶锅RS1600K% ' and goods_name not like ' %乐仕菲斯优乐套装锅

RS201T% '

91 and goods_name not like ' %绿波仙⼦（补铁绿彩套锅）% ' and goods_name not like ' %欧莱斯特304不锈钢⽆缝内

胆⽔壶OL-818橙⾊% '

92 and goods_name not like ' %欧莱斯特304不锈钢⽆缝内胆⽔壶QL-818% ' and goods_name not like ' %欧然电⽔壶

CR-1130% '

93 and goods_name not like ' %⽇式环保包袋组合（折叠环保包+爱⼼便当包）% '

94 and goods_name not like ' %三洋SANYO 煮蛋器 JH702A% ' and goods_name not like ' %三洋SANYO煮蛋器

JH702A% '

95 and goods_name not like ' %三洋电吹风DH-JH104% ' and goods_name not like ' %三洋电吹风HD-JH101A% '

96 and goods_name not like ' %三洋电吹风HD-JH104% ' and goods_name not like ' %三洋电熨⽃A-JH102M% '

97 and goods_name not like ' %三洋加湿器CFK-JH6013% ' and goods_name not like ' %膳之厨多功能锅CJ-096% '

98 and goods_name not like ' %膳之厨锅具两件套CJ-960% ' and goods_name not like ' %膳之厨时尚三件套CJ-3683%

'

99 and goods_name not like ' %圣德保罗⼯具套装SD-007-C% ' and goods_name not like ' %⼗⼋⼦作⾼级不锈钢家⽤剪

WJJ-01% '

100 and goods_name not like ' %⼗⼋⼦作开瓶器SC-02% ' and goods_name not like ' %⼗⼋⼦作雅刃六件套⼑S2902%

'

101 and goods_name not like ' %⼗⼋⼦作银盈快刃斩切⼑S2504-A% ' and goods_name not like ' %时尚折叠凳% '

102 and goods_name not like ' %史努⽐故事保鲜盒组SP-A123% ' and goods_name not like ' %史努⽐故事⽔杯SP-

A317% '

103 and goods_name not like ' %史努⽐酷狗健康称SP-H201% ' and goods_name not like ' %史努⽐酷炫多功能杯SP-

A105% '

104 and goods_name not like ' %史努⽐亲亲四⼊冷⽔壶SP-A203% ' and goods_name not like ' %史努⽐清凉⼩冰杯SP-

A112% '

105 and goods_name not like ' %史努⽐提⼿杯% ' and goods_name not like ' %史努⽐幸福双层饭盒SP-C103% '

106 and goods_name not like ' %史努⽐紫洋保温杯SP-A602% ' and goods_name not like ' %天飞伞3007% '

107 and goods_name not like ' %天堂10302E国⾊天⾹伞% ' and goods_name not like ' %天堂苏印丝伞% '

108 and goods_name not like ' %西铁城电⼦体温计CT513W% ' and goods_name not like ' %⾹⼭牌电⼦健康秤

EB9003L% '

109 and goods_name not like ' %⾹⼭牌机械健康秤BR2017B% ' and goods_name not like ' %⼩天⼦钢柄⼋件套⼑A-

019% '

110 and goods_name not like ' %伊莱特3L电饭煲CFXB30-J31A% ' and goods_name not like ' %宜剪美% '

111 and goods_name not like ' %⽻梦情缘被套(简装)% ' and goods_name not like ' %⽻梦情缘床单(简装)% '

112 and goods_name not like ' %⽻梦情缘枕套(简装)% ' and goods_name not like ' %⾬花丝绒毯% '

113 and goods_name not like ' %蒸功夫蒸汤两⽤锅% ' and goods_name not like ' %⽵纤维被% ' and goods_name

not like ' %⽵纤维浴⼱% '

114 and goods_name not like ' %红厨 32cm炫雅雪花不沾炒锅YN0304% '

115 and goods_name not like ' %春笑牌烘鞋器（⼤）% ' and goods_name not like ' %欧然不锈钢快速电⽔壶CR-

1181 1.2L% '

116 and goods_name not like ' %春笑牌烘鞋器（⼩）% ' and goods_name not like ' %史努⽐紫洋保温杯 SP-A602% '

117 and goods_name not like ' %欧然不锈钢快速电⽔壶CR-1120 0.8L% ' order by suppliertabid) order by

suppliertabid

全是not like,排序写了两次（order by suppliertabid），还有⼀个条件，重复写了两次（goods_id>0 and cat_id=40 and is_real=1

and area in('000','0514')）。

这种看到头都⼤了，然后执⾏查询6秒种，OMG，不到三千的数据，查询要6秒。这是任何⼀个程序员都不允许发⽣的事情。

然后⼜仔细看了下 OMG ，LDGAGA，这个 nd goods_id not in (条件)，重复上⾯where条件了，这个这个，当我没说，⼀个程序能⼲出

来这样的事，我就不发表意见了。

然后我就想给优化下，排序重复了去掉⼀个，现在暂时不先考虑NOT LIKE，还有 goods_id>0 and cat_id=40 and is_real=1 and area

in('000','0514')也重复了，去掉⼀个。

去掉⼦条件⾥⾯的。现在执⾏在毫秒级别。and goods_id not in ()这样写没有什么意义，去掉。这样少了⼀半的代码啊。继续改，where

条件改成where goods_id>0 and cat_id=40 and is_real=1 and area in('000','0514') and

goods_id not in(

select top 16 goods_id from goods where 后⾯是NOT LIKE数据)这样代码也好看些，运⾏，OMG 才30多毫秒,这就对了，这样才

OK。

修改后的代码：

代码

select top 16 goods_id,goods_name,goods_thumb,integral,cat_id from

goods where goods_id > 0 and cat_id = 40 and is_real = 1 and area in ( ' 000 ' , ' 0514 ' ) and

goods_id not in (

select top 16 goods_id from goods where

goods_name not like ' %SP-8210 史努⽐旋风吹风机% ' and goods_name not like ' %zippo打⽕机150ZL% '

and goods_name not like ' %ZIPPO打⽕机205% ' and goods_name not like ' %zippo打⽕机280AW陆军空战银章% '

and goods_name not like ' %爱国者⾳箱SP-F021% ' and goods_name not like ' %爱国者⾳箱SP-F027% '

and goods_name not like ' %铂⾦多⽤汤锅DFS-T012% ' and goods_name not like ' %不锈钢快速⽔壶OL-209% '

and goods_name not like ' %不锈钢快速⽔壶OL-215% ' and goods_name not like ' %不锈钢密封碗三件套% '

and goods_name not like ' %彩棉浴⼱% ' and goods_name not like ' %超⼈电吹风SB80% '

and goods_name not like ' %超⼈电须⼑SA35% ' and goods_name not like ' %超⼈电须⼑SA850% '

and goods_name not like ' %超⼈电熨⽃SY570% ' and goods_name not like ' %超⼈⽑球修剪器SR2855% '

and goods_name not like ' %超⼈剃须⼑SA2701% ' and goods_name not like ' %超⼈拓威⼲鞋机TH151% '

and goods_name not like ' %厨具⼗⼋件套CQG1518% ' and goods_name not like ' %春笑牌USB蓝鲸电暖⼿⿏标垫% '

and goods_name not like ' %春笑牌USB维尼熊电暖⼿⿏标垫% ' and goods_name not like ' %春笑牌USB喜洋洋电暖⼿⿏标

垫% '

and goods_name not like ' %德世朗多功能蒸煮锅% ' and goods_name not like ' %迪⼠尼保温泡菜壶% '

and goods_name not like ' %迪⼠尼抽真空保温杯% ' and goods_name not like ' %迪⼠尼幸运草随⼿杯% '

and goods_name not like ' %冬暖复合被% ' and goods_name not like ' %都彭⽜⽪⽪带8818C289% '

and goods_name not like ' %都彭⽜⽪⽪带8881C055% ' and goods_name not like ' %都彭⽜⽪钥匙包8855B020-4% '

and goods_name not like ' %哆啦A梦便利收纳箱% ' and goods_name not like ' %哆啦A梦⼤容量真空保温杯% '

and goods_name not like ' %哆啦A梦红酒瓶⾬伞(黄)% ' and goods_name not like ' %哆啦A梦时尚套装礼盒DM-2319% '

and goods_name not like ' %果缤纷（⼑具套装）% ' and goods_name not like ' %韩式调料缸三件套（22*24*26）% '

and goods_name not like ' %好帮⼿淘⽶器% ' and goods_name not like ' %红厨铝合⾦煎盘YN0351% '

and goods_name not like ' %吉旺1厘⽆磁钢柄五件套装7162% ' and goods_name not like ' %吉旺3厘⽊纹6件套7191% '

and goods_name not like ' %康⼽ 蒸好（微波炉专⽤⼩蒸煲）CQG2004% ' and goods_name not like ' %康⼽SURE不锈钢

保温杯% '

and goods_name not like ' %康⼽秤⼼如意厨房秤% ' and goods_name not like ' %康⼽情侣密封罐CQG5001% '

and goods_name not like ' %康⼽钛真空保温杯CQG4000% '

and goods_name not like ' %康⼽蒸好（微波炉专⽤⼩蒸煲）CQG2004% ' and goods_name not like ' %康⼽智能卡路⾥电

⼦跳绳% '

and goods_name not like ' %乐扣茶杯HPL934M% ' and goods_name not like ' %乐扣乐扣四⽅型保鲜盒HPL809F% '

and goods_name not like ' %乐扣乐扣圆型保鲜盒HPL933% ' and goods_name not like ' %乐仕菲斯贝贝乐保温提盒

RSC1000K% '

and goods_name not like ' %乐仕菲斯单柄奶锅RS1600K% ' and goods_name not like ' %乐仕菲斯优乐套装锅RS201T%

'

and goods_name not like ' %绿波仙⼦（补铁绿彩套锅）% ' and goods_name not like ' %欧莱斯特304不锈钢⽆缝内胆⽔壶

OL-818橙⾊% '

and goods_name not like ' %欧莱斯特304不锈钢⽆缝内胆⽔壶QL-818% ' and goods_name not like ' %欧然电⽔壶CR-

1130% '

and goods_name not like ' %⽇式环保包袋组合（折叠环保包+爱⼼便当包）% '

and goods_name not like ' %三洋SANYO 煮蛋器 JH702A% ' and goods_name not like ' %三洋SANYO煮蛋器JH702A%

'

and goods_name not like ' %三洋电吹风DH-JH104% ' and goods_name not like ' %三洋电吹风HD-JH101A% '

and goods_name not like ' %三洋电吹风HD-JH104% ' and goods_name not like ' %三洋电熨⽃A-JH102M% '

and goods_name not like ' %三洋加湿器CFK-JH6013% ' and goods_name not like ' %膳之厨多功能锅CJ-096% '

and goods_name not like ' %膳之厨锅具两件套CJ-960% ' and goods_name not like ' %膳之厨时尚三件套CJ-3683% '

and goods_name not like ' %圣德保罗⼯具套装SD-007-C% ' and goods_name not like ' %⼗⼋⼦作⾼级不锈钢家⽤剪

WJJ-01% '

and goods_name not like ' %⼗⼋⼦作开瓶器SC-02% ' and goods_name not like ' %⼗⼋⼦作雅刃六件套⼑S2902% '

and goods_name not like ' %⼗⼋⼦作银盈快刃斩切⼑S2504-A% ' and goods_name not like ' %时尚折叠凳% '

and goods_name not like ' %史努⽐故事保鲜盒组SP-A123% ' and goods_name not like ' %史努⽐故事⽔杯SP-A317% '

and goods_name not like ' %史努⽐酷狗健康称SP-H201% ' and goods_name not like ' %史努⽐酷炫多功能杯SP-A105%

'

and goods_name not like ' %史努⽐亲亲四⼊冷⽔壶SP-A203% ' and goods_name not like ' %史努⽐清凉⼩冰杯SP-

A112% '

and goods_name not like ' %史努⽐提⼿杯% ' and goods_name not like ' %史努⽐幸福双层饭盒SP-C103% '

and goods_name not like ' %史努⽐紫洋保温杯SP-A602% ' and goods_name not like ' %天飞伞3007% '

and goods_name not like ' %天堂10302E国⾊天⾹伞% ' and goods_name not like ' %天堂苏印丝伞% '

and goods_name not like ' %西铁城电⼦体温计CT513W% ' and goods_name not like ' %⾹⼭牌电⼦健康秤EB9003L% '

and goods_name not like ' %⾹⼭牌机械健康秤BR2017B% ' and goods_name not like ' %⼩天⼦钢柄⼋件套⼑A-019% '

and goods_name not like ' %伊莱特3L电饭煲CFXB30-J31A% ' and goods_name not like ' %宜剪美% '

and goods_name not like ' %⽻梦情缘被套(简装)% ' and goods_name not like ' %⽻梦情缘床单(简装)% '

and goods_name not like ' %⽻梦情缘枕套(简装)% ' and goods_name not like ' %⾬花丝绒毯% '

and goods_name not like ' %蒸功夫蒸汤两⽤锅% ' and goods_name not like ' %⽵纤维被% ' and goods_name not

like ' %⽵纤维浴⼱% '

and goods_name not like ' %红厨 32cm炫雅雪花不沾炒锅YN0304% '

and goods_name not like ' %春笑牌烘鞋器（⼤）% ' and goods_name not like ' %欧然不锈钢快速电⽔壶CR-1181 1.2L%

'

and goods_name not like ' %春笑牌烘鞋器（⼩）% ' and goods_name not like ' %史努⽐紫洋保温杯 SP-A602% '

and goods_name not like ' %欧然不锈钢快速电⽔壶CR-1120 0.8L% ' ) order by suppliertabid

这样就完整了吗？NO NO NO。

继续优化，这还怎么优化，当然能了，现在查的是商品名字啊，改啊商品ID，不使⽤NOT LIKE 性能太差了。创建唯⼀索引，OMG，更加

快了。这样是最终效果。任务完成。代码真雷死我了。