select * from my_product where product_type = 1 and status = 36 and TIMESTAMPDIFF(DAY, NOW(), date_add(eff_time, interval 30 day)) = #{days,jdbcType=INTEGER}
select * from my_product where product_type = 1 and status = 36 and TIMESTAMPDIFF(DAY, NOW(), date_add(eff_time, interval 30 day)) = #{days,jdbcType=INTEGER}