Optimize `array_has()` for scalar needle

[neilconway]

Is your feature request related to a problem or challenge?

For the scalar needle case, array_has is reasonably fast but it could be optimized by avoiding the per-row work that is currently done to construct the result set (construct a slice into a BooleanArray and count the set bits).

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[neilconway]

take

[neilconway]

See also #18181, although in that case the observed performance issue is actually with array_has_any.