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