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