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