$on_sell_log['device_type'] = Db::name('charge_commodity')->where($where2)->where('del',0)->where('status','in','1,3')
->group("FROM_UNIXTIME(create_time,'$date2'),`platform` ")
->field("create_time,FROM_UNIXTIME(create_time,'$date2') as $date,count(game_id) as total_amount,platform as device_type")->select();
数据查询group和FROM_UNIXTIME的使用
最新推荐文章于 2023-07-17 17:29:29 发布