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