MySQL支持全文检索 只需加一个KEY 数据量不大的情况下对搜索效果是一个很牛的提升

ALTER TABLE `20241125-sign-language`.`articles` ADD FULLTEXT `ft_index` (`title`, `content`) WITH PARSER ngram;

$builder->whereRaw(MATCH(title,content) AGAINST ('{$params['keyword']}'));
$builder->orderByDesc('SCORE');
$builder->addSelect('*', DB::raw(MATCH(title,content) AGAINST ('{$params['keyword']}') AS SCORE));