query slows down exponentially as table grows
The compound INDEX(field2, field1) would be a "covering" index.  This would avoid a huge number of lookups, thereby making it much faster.  Note:  This will not work if you also SELECT field3.  (InnoDB and MyISAM would both benefit in this case.)

Keep your UNIQUE(field2) because of the uniqueness constraint.