select id,name,operation,DATE_FORMAT(addTime,"%Y-%m-%d %H:%i:%s") addTime from log
where 1=1
and name LIKE concat('%',#{name},'%' )
and DATE_FORMAT(addTime,"%Y-%m-%d")>=beg
and DATE_FORMAT(addTime,"%Y-%m-%d")<=end
select id,name,operation,DATE_FORMAT(addTime,"%Y-%m-%d %H:%i:%s") addTime from log
where 1=1
and name LIKE concat('%',#{name},'%' )
and DATE_FORMAT(addTime,"%Y-%m-%d")>=beg
and DATE_FORMAT(addTime,"%Y-%m-%d")<=end