Widget Newest Members might use inefficient query

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.

Читать далее...