Laravel大数据批量操作慢如蜗牛？yadakhov/insert-on-duplicate-key助你轻松解决，效率飙升！

<code class="bash">composer require yadakhov/insert-on-duplicate-key</code>

<pre class="brush:php;toolbar:false;">use Illuminate\Database\Eloquent\Model;
use Yadakhov\InsertOnDuplicateKey;

class User extends Model
{
    // 引入这个 trait，即可拥有批量操作的能力
    use InsertOnDuplicateKey;

    protected $fillable = ['id', 'email', 'name', 'heritage']; // 确保你的模型有 fillable 字段
}

<pre class="brush:php;toolbar:false;">use Carbon\Carbon; // 如果你需要处理时间戳

$users = [
    ['id' => 1, 'email' => 'user1@example.com', 'name' => 'User One', 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()],
    ['id' => 2, 'email' => 'user2@example.com', 'name' => 'User Two', 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()],
    ['id' => 3, 'email' => 'user3@example.com', 'name' => 'User Three', 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()],
];

// 默认情况下，如果发生冲突，所有字段都会被更新（除了主键）
User::insertOnDuplicateKey($users);

/*
会生成类似这样的 SQL 语句：
INSERT INTO `users`(`id`,`email`,`name`,`created_at`,`updated_at`) VALUES
(1,'user1@example.com','User One',...), (2,'user2@example.com','User Two',...), (3,'user3@example.com','User Three',...)
ON DUPLICATE KEY UPDATE `id` = VALUES(`id`), `email` = VALUES(`email`), `name` = VALUES(`name`), `created_at` = VALUES(`created_at`), `updated_at` = VALUES(`updated_at`)
*/

<pre class="brush:php;toolbar:false;">// 如果发生冲突，只更新 email 字段
User::insertOnDuplicateKey($users, ['email']);

/*
SQL 语句将变为：
... ON DUPLICATE KEY UPDATE `email` = VALUES(`email`)
*/

<pre class="brush:php;toolbar:false;">use Illuminate\Support\Facades\DB;

$usersWithHeritage = [
    ['id' => 1, 'name' => 'User One', 'heritage' => 1000, 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()],
    ['id' => 2, 'name' => 'User Two', 'heritage' => 2000, 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()],
];

// 如果 id 冲突，则将 heritage 字段累加
User::insertOnDuplicateKey($usersWithHeritage, ['heritage' => DB::raw('`heritage` + VALUES(`heritage`)')]);

/*
SQL 语句将变为：
... ON DUPLICATE KEY UPDATE `heritage` = `heritage` + VALUES(`heritage`)
*/

<pre class="brush:php;toolbar:false;">User::insertIgnore($users);

/*
会生成类似这样的 SQL 语句：
INSERT IGNORE INTO `users`(`id`,`email`,`name`) VALUES (...)
*/

<pre class="brush:php;toolbar:false;">User::replace($users);

/*
会生成类似这样的 SQL 语句：
REPLACE INTO `users`(`id`,`email`,`name`) VALUES (...)
*/