请帮忙优化此SQL语句？

Question

select 
    distinct dfitting_id,dfitting_pid,PARAM_NAME,dfitting_EMP,peoname,dfitting_DATE 
from
    vinm_dfitting,VINM_PARAM,VINM_REPORTUSERLIST 
where 
    (dfitting_pid between 148 and 157)
    and
    PARAM_ID=dfitting_WORK 
    and 
    PARAM_FIELD='总装工序' 
    and 
    dfitting_EMP=peono

Answer 1

select distinct dfitting_id,dfitting_pid,PARAM_NAME,dfitting_EMP,peoname,
dfitting_DATE 
from vinm_dfitting,VINM_PARAM,VINM_REPORTUSERLIST 
where PARAM_ID=dfitting_WORK and dfitting_EMP=peono and 
PARAM_FIELD='总装工序' and dfitting_pid between 148 and 157 

Answer 2

dfitting_pid=157 or dfitting_pid=156 or dfitting_pid=155 or
dfitting_pid=154 or dfitting_pid=153 or dfitting_pid=152 or dfitting_pid=151 or dfitting_pid=150 or dfitting_pid=149 or dfitting_pid=148 
这些编号可能是不连续的，偶尔有连续！

Answer 3

select distinct dfitting_id,dfitting_pid,PARAM_NAME,dfitting_EMP,peoname,
dfitting_DATE 
from vinm_dfitting,VINM_PARAM,VINM_REPORTUSERLIST 
where PARAM_ID=dfitting_WORK and dfitting_EMP=peono and 
PARAM_FIELD='总装工序' and dfitting_pid in(157,156...)
好像只能简化语句长短
我觉得用between  and  是最合适的，数据不连续不受影响