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