Optimize SQL queries when updating a bunch of records at once. (From: https://laracasts.com/forum/1442-best-way-to-update-400-database-rows)

gistfile1.txt

<?php

$checked = [];
$unchecked = [];

foreach($input as $id => $enabled)
{
    if ($enabled) $checked[] = $id;
    else $unchecked[] = $id;
}

Component::whereIn('id', $checked)->update(['checked' => true]);
Component::whereIn('id', $unchecked)->update(['checked' => false]);