314067 speed up mysql php code

Hello, I have this banner view file that works correctly but is very slow in quering the database of banners when there are more than 300 banners. The file itself displays 25 banners at a time using pagination so maybe it could be changed to only sort thru 25 banners at a time, or maybe 100 banners at a time. Files attached.