Laravel - Query +100k placeholders in Laravel using `whereIn()`

laravel-query-too-many-placeholder.php

<?php 

$transactionIds = Transaction::pluck('id'); // +100k transaction ids

$maxAtOneTime = 5000;
$total = count($transactionIds);

$pages = ceil($total / $maxAtOneTime);
$transactions = collect();

for ($i = 1; $i < ($pages + 1); $i++) {
    $offset = (($i - 1) * $maxAtOneTime);
    $start = ($offset == 0 ? 0 : ($offset + 1));

    $data = Transaction::query()
      ->whereIn('id', $transactionIds)
      ->skip($start)
      ->take($maxAtOneTime)
      ->get();
  
    $transactions = $transactions->merge($data);
}
 
// Now $transactions has all you need!