orderByRaw not working (anymore)

[francoism90]

I don't know what I'm doing wrong:

class Model
{
      public function scopeSearch($query, string $value = '*', int $limit = 10)
          {
              $models = $this->getModel()->search($value)->take($limit);
      
              return $query
                  ->reorder()
                  ->whereIn('id', $models->keys())
                  ->orderByRaw("FIELD ('id', {$models->keys()->implode(',')})");
          }
}

Results:

> Book::query()->search('a')->pluck('id')
= Illuminate\Support\Collection {#8722
    all: [
      8180,
      24627,
      27389,
      27390,
      27391,
      27392,
      27393,
      30432,
      38188,
      38416,
    ],
  }

This is direct search:

> Book::search('a')->take(10)->get()->pluck('id')
= Illuminate\Support\Collection {#8761
    all: [
      24627,
      27389,
      27390,
      27391,
      27392,
      27393,
      30432,
      8180,
      38188,
      38416,
    ],
  }

As you can see the keys (order) is being reset/sorted, but I don't have any idea why?

If I use orderBy('id', 'DESC'), it works fine, but it doesn't seem to parse orderByRaw (anymore)?
Do I miss something? Like preserveKeys? It doesn't matter if I use get() directly without pluck, the order is always (unwanted) sorted.

Thanks

[francoism90]

By not limiting the search, it works as expected, and I get the same result every time:

$models = $this->getModel()->search($value);

This does not work, as it seems to change the result:

$models = $this->getModel()->search($value, 10);

It's really weird, but I think this happens because the collection length isn't the same.