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