SELECT id FROM users WHERE active=1 AND about_me LIKE "%#фотография%" ORDER BY username ASC, num_followers DESC
0.00910
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#фотография($|\,)" ORDER BY username ASC
0.01261
SELECT id FROM users WHERE active=1 AND (username LIKE "%#фотография%" OR fullname LIKE "%#фотография%" OR position LIKE "%#фотография%") ORDER BY username ASC
0.01087
SELECT id FROM users WHERE active=1 AND (username="#фотография" OR fullname="#фотография" OR position="#фотография") ORDER BY username ASC