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