select substr(order_id,6,4) as product_id, 
count(substr(order_id,6,4)) cnt
from order_log
group by substr(order_id,6,4)
order by cnt desc
limit 1

简单