query optimization - mysql select min performance issues -

i have query select minimum id. seems work fine in first few clicks, gets sluggish when keep on clicking button calls query.

any workarounds query?

"select min(t1.blog_id) min_id           (select blog_id myblogs_view          blog_id<'$id' order blog_id desc limit 10) t1"; 

try with

select min(blog_id) min_id myblogs_view blog_id < '$id' group blog_id 

do have index on blog_id column?

in general when dealing slow query, can use explain command see how mysql executes query.