larravel框架使用force index提高查询性能

     $_record = null;

    $_record = self::from(DB::raw(‘pay_records FORCE INDEX (created_at)’))

    ->leftJoin(‘mobile_gsds’, DB::raw(‘substring(pay_records.mobile,1,7)’), ‘=’, ‘mobile_gsds.phone’)