First of all I would like to welcome you to this Wonderful community of programmers.
What version of MySQL you are using. If you are using 4.x version of MySQL it does not support stored procedures but its just 5.0 that supports.
I dont think it can help much the problem area is something different.
On the home page you are almost showing 50 Recods but if you can reduce that it will load faster as 50 records nees 50 + images to be loaded. Show only 10-15 and it should be fine.