SELECT id FROM users WHERE active=1 AND about_me LIKE "%#кифландия%" ORDER BY username ASC, num_followers DESC
0.00943
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#кифландия($|\,)" ORDER BY username ASC
0.01314
SELECT id FROM users WHERE active=1 AND (username LIKE "%#кифландия%" OR fullname LIKE "%#кифландия%" OR position LIKE "%#кифландия%") ORDER BY username ASC
0.01135
SELECT id FROM users WHERE active=1 AND (username="#кифландия" OR fullname="#кифландия" OR position="#кифландия") ORDER BY username ASC