Widget Newest Members might use inefficient query

Kirby

Well-known member
Affected version
2.2.13
PHP:
$userFinder = $this->finder('XF:User')
    ->isValidUser()
    ->order('register_date', 'DESC')
    ->limit($this->options['limit']);

This sometimes picks index user_state / is_banned_user_state which is inefficient - ddding an index hint for register_date seems to fix this.
 
Top Bottom