SELECT id FROM users WHERE active=1 AND about_me LIKE "%#дийппрованс%" ORDER BY username ASC, num_followers DESC
0.01007
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#дийппрованс($|\,)" ORDER BY username ASC
0.01691
SELECT id FROM users WHERE active=1 AND (username LIKE "%#дийппрованс%" OR fullname LIKE "%#дийппрованс%" OR position LIKE "%#дийппрованс%") ORDER BY username ASC
0.01270
SELECT id FROM users WHERE active=1 AND (username="#дийппрованс" OR fullname="#дийппрованс" OR position="#дийппрованс") ORDER BY username ASC