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