select
substring_index(order_id,'_',-1) as product_id,
count(*) as cnt
from order_log
group by product_id
order by product_id,cnt desc
limit 1;

select
substring_index(order_id,'_',-1) as product_id,
count(*) as cnt
from order_log
group by product_id
order by product_id,cnt desc
limit 1;