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