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