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