SELECT id FROM users WHERE active=1 AND about_me LIKE "%#РеалМадрид%" ORDER BY username ASC, num_followers DESC
0.00777
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#РеалМадрид($|\,)" ORDER BY username ASC
0.01926
SELECT id FROM users WHERE active=1 AND (username LIKE "%#РеалМадрид%" OR fullname LIKE "%#РеалМадрид%" OR position LIKE "%#РеалМадрид%") ORDER BY username ASC
0.01386
SELECT id FROM users WHERE active=1 AND (username="#РеалМадрид" OR fullname="#РеалМадрид" OR position="#РеалМадрид") ORDER BY username ASC