select REPORTDATE,sbutype,color_gamut_max,color_gamut_min,color_gamut_avg,gamut_min_spec,gamut_type_spec from EDS_DATABASE_PUSH

WHERE REPORTDATE IN ('${REPORTDATE}')

AND SBUTYPE IN ('${SBUTYPE}')

AND LC IN ('${LC}')

AND E IN ('${E}')

AND CELLGAP IN ('${CELLGAP}')

AND MASK IN ('${MASK}')

and (1=1 ${if(len(关键词1)==0,"","and APPLY like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and type like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and sbutype like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and shiptype like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and reportdate like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and fgcode like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and resolution like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and customer like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and state like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and mutant like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and ICBU like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and PPT like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and LC like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and PI like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and CELLGAP like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and OAANDRUBBING like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and APF like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and CODEVOP like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and ITO like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and PIXELSTRUCTURE like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and OPENRATIO like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and N like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and E like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and COEFFICIENT like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and FLK like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and FLKPATTERN like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and SOURCE like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and MASK like ('%"+关键词1+"%')")}

or 1=1 ${if(len(关键词1)==0,"","and MASKTYPE like ('%"+关键词1+"%')")}

)

and (1=1 ${if(len(关键词2)==0,"","and APPLY like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and type like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and sbutype like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and shiptype like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and reportdate like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and fgcode like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and resolution like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and customer like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and state like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and mutant like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and ICBU like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and PPT like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and LC like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and PI like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and CELLGAP like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and OAANDRUBBING like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and APF like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and CODEVOP like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and ITO like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and PIXELSTRUCTURE like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and OPENRATIO like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and N like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and E like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and COEFFICIENT like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and FLK like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and FLKPATTERN like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and SOURCE like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and MASK like ('%"+关键词2+"%')")}

or 1=1 ${if(len(关键词2)==0,"","and MASKTYPE like ('%"+关键词2+"%')")}

)

这段SQL在只输入关键词1或者关键词2的时候可以查询出对应的图表，同时输入关键词1和关键词2就不能出现图表数据，这是哪里有问题呀，