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