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