select *,count(*) as order_count, from_unixtime(create_time, '%Y-%m-%d %H:%i:%S') as create_time_str from ims_zhyshop_sun_xx  where  create_time >= 1671206400 GROUP BY order_id order by order_count desc