$user = User::where ('activation_token', $token)->firstOrFail ();需要提前给'activation_token'字段加索引吗?
public function confirmEmail($token)
{
$user = User::where('activation_token', $token)->firstOrFail();
$user->activated = true;
$user->activation_token = null;
$user->save();
Auth::login($user);
session()->flash('success', '恭喜你,激活成功!');
return redirect()->route('users.show', [$user]);
}
$user = User::where('activation_token', $token)->firstOrFail();
针对上面的查询语句, 为了提高效率, 需要提前给'activation_token'字段加索引吗?
推荐文章: