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