We did retrieve the whole list 20 lines ago, didn't we?
Well, who cares... Let's retrieve it again IN A LOOP, im EACH ITERATION.
and then for good measure lets make another query for each item, each time we retrieve the list. Why not?

I have to make an effort not to swear right now. I have been asked to optimize a particular oiece of code...

Ffs