SELECT id FROM users WHERE active=1 AND about_me LIKE "%#bulgaria%" ORDER BY username ASC, num_followers DESC
0.00796
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#bulgaria($|\,)" ORDER BY username ASC
0.01113
SELECT id FROM users WHERE active=1 AND (username LIKE "%#bulgaria%" OR fullname LIKE "%#bulgaria%" OR position LIKE "%#bulgaria%") ORDER BY username ASC
0.01019
SELECT id FROM users WHERE active=1 AND (username="#bulgaria" OR fullname="#bulgaria" OR position="#bulgaria") ORDER BY username ASC