SELECT id FROM users WHERE active=1 AND about_me LIKE "%#volleyball%" ORDER BY username ASC, num_followers DESC
0.00903
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#volleyball($|\,)" ORDER BY username ASC
0.01273
SELECT id FROM users WHERE active=1 AND (username LIKE "%#volleyball%" OR fullname LIKE "%#volleyball%" OR position LIKE "%#volleyball%") ORDER BY username ASC
0.01099
SELECT id FROM users WHERE active=1 AND (username="#volleyball" OR fullname="#volleyball" OR position="#volleyball") ORDER BY username ASC