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