| 1234567891011121314151617181920212223242526 |
- <?php
- namespace App\Console\Commands;
- use App\Models\Order;
- use Illuminate\Console\Command;
- use Log;
- class UpdateUserSpeedLimit extends Command
- {
- protected $signature = 'updateUserSpeedLimit';
- protected $description = '根据商品更新用户限速';
- public function handle()
- {
- $jobTime = microtime(true);
- foreach (Order::whereStatus(2)->whereIsExpire(0)->where('goods_id', '<>', null)->oldest()->with(['user', 'goods'])->has('goods')->has('user')->get() as $order) {
- $order->user->update(['speed_limit' => $order->goods->speed_limit]);
- }
- $jobTime = round(microtime(true) - $jobTime, 4);
- Log::info('---【'.$this->description.'】完成---,耗时'.$jobTime.'秒');
- }
- }
|