SELECT id FROM users WHERE active=1 AND about_me LIKE "%#лудогорец%" ORDER BY username ASC, num_followers DESC
0.00823
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#лудогорец($|\,)" ORDER BY username ASC
0.01240
SELECT id FROM users WHERE active=1 AND (username LIKE "%#лудогорец%" OR fullname LIKE "%#лудогорец%" OR position LIKE "%#лудогорец%") ORDER BY username ASC
0.01097
SELECT id FROM users WHERE active=1 AND (username="#лудогорец" OR fullname="#лудогорец" OR position="#лудогорец") ORDER BY username ASC