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