my $sth = $dbh->prepare_cached("SELECT foo,bar from table where id = ?");
for my $id (@ids) {
    $sth->execute( $id );
    my @results = $sth->fetchrow_array;
    $sth->finish;
}