I need to use whereIntegerInRaw query because when I have too large database, use whereIn is very slow.
I try to extend query builder and add that method to it,but it still no working.
In OptimizeBuilder
public function whereIntegerInRaw($column, $values, $boolean = 'and', $not = false)
$type = $not ? 'NotInRaw' : 'InRaw';
if ($values instanceof Arrayable) {
$values = $values->toArray();
}
foreach ($values as &$value) {
$value = (int) $value;
}
$this->wheres[] = compact('type', 'column', 'values', 'boolean');
return $this;
In model
public static function query(): OptimizeBuilder
{
return parent::query();
}
public function newEloquentBuilder($query)
{
return new OptimizeBuilder($query);
}
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire