时间过滤详细考虑:
AND (( startTime <![CDATA[ >= ]]> #{startTime} AND startTime <![CDATA[ <= ]]> #{endTime} )
or ( endTime <![CDATA[ >= ]]> #{startTime} AND endTime <![CDATA[ <= ]]> #{endTime})
or ( endTime <![CDATA[ <= ]]> #{startTime} AND endTime <![CDATA[ >= ]]> #{endTime}) )