A judge has detailed how Liam Payne was so high on a cocktail of drink and drugs he was “unable to stand” in his final hours.