select t.service_id,
t.prod_id,
t.prod_name,
t.prod_type,
t.buss_type,
t.pricing_fee,
t.detail
from TB_BUS_PROD_ACTIVITY_INFO t
where 1=1
<if test="prod_id!=null and prod_id!=''">
and t.prod_id in
<foreach item="item" index="index" collection="prod_id"
open="(" separator="," close=")">
#{item}
</foreach>
</if>
</select>