SELECT id FROM users WHERE active=1 AND about_me LIKE "%#ичотранстакси%" ORDER BY username ASC, num_followers DESC
0.00912
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#ичотранстакси($|\,)" ORDER BY username ASC
0.01076
SELECT id FROM users WHERE active=1 AND (username LIKE "%#ичотранстакси%" OR fullname LIKE "%#ичотранстакси%" OR position LIKE "%#ичотранстакси%") ORDER BY username ASC
0.01387
SELECT id FROM users WHERE active=1 AND (username="#ичотранстакси" OR fullname="#ичотранстакси" OR position="#ичотранстакси") ORDER BY username ASC