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