select 
    product_id,
    count(*) as cnt
from user_client_log
where step='order'
group by product_id
order by cnt desc
limit 1

注意审题！是下单量最多！