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