SELECT id FROM users WHERE active=1 AND about_me LIKE "%supreme cat commander%" ORDER BY username ASC, num_followers DESC
0.03308
SELECT id FROM users WHERE tags REGEXP "(^|\,| )supreme cat commander($|\,)" ORDER BY username ASC
0.01360
SELECT id FROM users WHERE active=1 AND (username LIKE "%supreme cat commander%" OR fullname LIKE "%supreme cat commander%" OR position LIKE "%supreme cat commander%") ORDER BY username ASC
0.01109
SELECT id FROM users WHERE active=1 AND (username="supreme cat commander" OR fullname="supreme cat commander" OR position="supreme cat commander") ORDER BY username ASC