What are the long term effects of opiods, apart from constipation? A potential dip in sex drive? What's the part that's not safe? Other than respiratory depress

What are the long term effects of opiods, apart from constipation? A potential dip in sex drive? What's the part that's not safe? Other than respiratory depression which is fairly easily avoided with properly labelled medicine.