Duh, anybody who's done opiates and gone to the gym could tell you that. Not so good for weight-lifting, but you'll be able to do cardio for hours
For those of us who are not inclined to pick up a drug habit, beta alanine comes close to the same effect... you'll pump a weight, waiting for the burn to come, and then your muscles just fail seemingly out of nowhere