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