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