Index page was loading too slow

i did some change in query because the index page was loading too slow