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