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