<if test="startTime != null and '' != startTime ">
<![CDATA[ and create_time >= STR_TO_DATE(#{startTime}, '%Y-%m-%d')]]>
</if>
<if test="endTime != null and '' != endTime ">
<![CDATA[ and create_time <= STR_TO_DATE(#{endTime}, '%Y-%m-%d')+1 ]]>
</if>-->