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