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 u.step = 'order'
group by u.product_id
order by cnt desc 
limit 1

就是求有order下单的商品的次数