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