SELECT id FROM users WHERE active=1 AND about_me LIKE "%#ЧеренХумор%" ORDER BY username ASC, num_followers DESC
0.00947
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#ЧеренХумор($|\,)" ORDER BY username ASC
0.01283
SELECT id FROM users WHERE active=1 AND (username LIKE "%#ЧеренХумор%" OR fullname LIKE "%#ЧеренХумор%" OR position LIKE "%#ЧеренХумор%") ORDER BY username ASC
0.01118
SELECT id FROM users WHERE active=1 AND (username="#ЧеренХумор" OR fullname="#ЧеренХумор" OR position="#ЧеренХумор") ORDER BY username ASC