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