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