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