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