When someone is so fucked up, they head in one direction with a goal in mind but [half-way] there, forget that goal and wander off in a random direction with or without another goal in mind. Term comes from [goldfish] in an [aquarium] acting the same way due to their seconds-long memory.