如何快速得将数据同步到数据库 $datas 大概500条数据 就执行8秒
foreach ($datas as $data) {
if(!$data[‘category_names’]){
continue;
} //验证商品分类是否存在
/** $category = $this->getCategoryByNameOrCreate( $storeGuid, $data[‘category_names’] ); */
$isTakeaway = $data[‘isTakeaway’];
$isTakeaway = in_array($isTakeaway, [1, 0]) ? $isTakeaway : 1; // 默认是网上售卖
$commodity=Commodity::query()
->where(‘No’,$data[‘no’])
->where(‘StoreGuid’,$storeGuid)
->first();
$commodity_data=[
‘StoreGuid’=>$storeGuid,
‘No’=>$data[‘no’],
‘Name’ => $data[‘name’],
‘SecondName’ => $data[‘secondName’],
‘Description’ => $data[‘description’]??’’,
‘Price’ => $data[‘price’],
‘SecondPrice’ => $data[‘secondPrice’],
‘ThirdPrice’ => $data[‘thirdPrice’],
‘Tax’ => $data[‘tax’],
‘IsTakeaway’ => $isTakeaway,
‘UnitGuid’ => ‘’,
‘Type’ => Commodity::TYPE_GENERAL,
‘Stock’ =>$data[‘stock’]??0,
‘Barcode’ => $data[‘barcode’]??’’,
‘Enabled’ => $data[‘enabled’]??true,
‘Deleted’ => false,
‘add_cart_quantity’ => $data[‘add_cart_quantity’]??0,
‘synchronous_platform’ => $synchronous_platform,
//‘CategoryGuid’ => $category[‘guid’]??’’
];
if(!$commodity){
$commodity=new Commodity();
$commodity_data[‘Guid’]=$this->uuid();
}
$commodity->fill($commodity_data);
$commodity->save();
/**
if(!empty($commodity->No) && !empty($data[‘path’])){ $CommodityImage=CommodityImage::query() ->where([ [‘CommodityNO’,’=’,$commodity->No], [‘StoreGuid’,’=’,$storeGuid] ])->select(‘Id’)->first(); $data=[ ‘Path’=>$data[‘path’] ]; if(empty($CommodityImage)){ $CommodityImage=new CommodityImage(); $data[‘Guid’]=$this->uuid(); $data[‘CommodityNO’]=$commodity->No; $data[‘CommodityGuid’]=$commodity->Guid; $data[‘StoreGuid’]=$storeGuid; } $CommodityImage->fill($data); $CommodityImage->save(); } */}
推荐文章: