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