select u.product_id
,count(u.product_id) as cnt
from user_client_log u 
join product_info p on u.product_id = p.product_id
where step = "order"
group by u.product_id
order by cnt desc,u.product_id
limit 1 offset 0