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