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