Optimize MySQL InnoDB query for SUM and Order By
You have indexes on item_link and sale_date but you are not using item_link.  When The first column of index are not in use in the where clause, the index are tends to be skipped while query execution.

Plan you index as per you where clause which in this case sale_date would be a good 

Thanks,