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