I could've sworn that as a kid I'd heard of flights to Australia that lasted around 27 hours, but I was probably too young at the time to understand that adults like to exaggerate about these things as much as children.
The longest I've been in the air was about 9 hours I think, Manchester to Chicago. That was absolute hell, but I put it down mostly to the terrible seats on the Airbus. I was uncomfortable from the minute I sat down. Mentally, 9 hours was pushing the limit for how much inactivity I could stand.