SELECT id FROM users WHERE active=1 AND about_me LIKE "%#static-x%" ORDER BY username ASC, num_followers DESC
0.00909
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#static\\-x($|\,)" ORDER BY username ASC
0.01722
SELECT id FROM users WHERE active=1 AND (username LIKE "%#static-x%" OR fullname LIKE "%#static-x%" OR position LIKE "%#static-x%") ORDER BY username ASC
0.01866
SELECT id FROM users WHERE active=1 AND (username="#static-x" OR fullname="#static-x" OR position="#static-x") ORDER BY username ASC