Is there any way to get the estimate cost of executing a query in MySQL?
In short


Run your SELECT ... query 
SHOW STATUS LIKE 'last_query_cost' 
if the answer was 0 rerun the query with 
select  SQL_NO_CACHE ... and do step 2 above again