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