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