SELECT id FROM users WHERE active=1 AND about_me LIKE "%#дерешкан%" ORDER BY username ASC, num_followers DESC
0.00732
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#дерешкан($|\,)" ORDER BY username ASC
0.01015
SELECT id FROM users WHERE active=1 AND (username LIKE "%#дерешкан%" OR fullname LIKE "%#дерешкан%" OR position LIKE "%#дерешкан%") ORDER BY username ASC
0.00896
SELECT id FROM users WHERE active=1 AND (username="#дерешкан" OR fullname="#дерешкан" OR position="#дерешкан") ORDER BY username ASC