Instead of calling

SELECT count(*) FROM users WHERE type='member'

If you frequently need that count, try storing the count in a separate table

SELECT value FROM summaries WHERE name='member_value'

Keep this value current with either a trigger, a co-executed statement, or via an external job (if some delay is acceptable)