To do anything takes a finite amount of time.
To do the same thing 45K times, takes [at least] 45K times as long.
This is a classic 1+n query.
Retrieve a list of ids, then process each in turn with another query.
- It runs like a slug.
- It's completely unscaleable.
- It's complete untunable. Indeed, your database will be thoroughly enjoying itself, being asked to retrieve a single record based on single value that it can find in a unique index!
Rewrite your code to retrieve the whole Set of data, then loop through the rows within it to process it or, in this case, simply select the data you want, for all the rows you want, in a single query. I assume you used another query to retrieve the values in your "list": use the "WHERE" clause from that query to retrieve [all] the data you need:
SELECT column_1, ... column_n
ORDER BY column_1
No; it's not very Object Oriented.
It's Set Based and, for Relational Databases, there's nothing better.