给3月1日至3月31日做60万条数据，VideoDate 要求1到31日StartTime要求00:00到24点，仅供笔记参考

 public function actionIndex()
    {


        $times = 1646064000;// 起始日期2022年3月1号
        for ($i = 1; $i <= 31; $i++) {
            // 3月1号时间戳 1646064000  每一条数据,相隔4.32秒
            $n=1;
            for ($j = 1; $j <= 20000; $j++) {

                if($n==201){
                    $n=1;
                }
                $no = 30000 + $n;
                $time = date('Y-m-d H:i:s',$times+4.32*$j);
                $date = date('Y-m-d',$times);
                $saveAdd[$j]['FileName'] = 'HXD30189_上海巨石_01_一端路况_20220410_193017.mp4';
                $saveAdd[$j]['FilePath'] = '/6A-VIDEO-HXD30189-上海巨石/2022-04-10/HXD30189_上海巨石_01_一端路况_20220410_193017.mp4';
                $saveAdd[$j]['NodeID'] = 3;
                $saveAdd[$j]['TrainNo'] = 'HXD' . $no;
                $saveAdd[$j]['Brand'] = '上海巨石';
                $saveAdd[$j]['Chanel'] = '01';
                $saveAdd[$j]['ChannelName'] = '一端路况';
                $saveAdd[$j]['VideoDate'] = $date;// 3月1号到31号
                $saveAdd[$j]['StartTime'] = $time;// 0:00 到23:59
                $saveAdd[$j]['EndTime'] = $time; //
                $saveAdd[$j]['M3u8Path'] = '_20220410_193017.m3u8';
                $saveAdd[$j]['DriverID'] = '22';
                $saveAdd[$j]['Driver'] = '司机名';
                $saveAdd[$j]['CoDriverID'] = '22';
                $saveAdd[$j]['CoDriver'] = '副司机名';
                $saveAdd[$j]['VideoUploadTime'] = date('Y-m-d H:i:s');
                $saveAdd[$j]['IsVideoProcessed'] = '00';
                $n++;
            }


            Yii::$app->db->createCommand()->batchInsert('testinsert', ['FileName','FilePath','NodeID','TrainNo','Brand','Chanel','ChannelName','VideoDate'
                ,'StartTime','EndTime','M3u8Path','DriverID','Driver','CoDriverID','CoDriver','VideoUploadTime','IsVideoProcessed'
            ], $saveAdd)->execute();
            
            $times += 86400; //处理完一次加一天
        }

        return $this->render('index');
    }