SELECT id FROM users WHERE active=1 AND about_me LIKE "%#desktop-a%" ORDER BY username ASC, num_followers DESC
0.00911
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#desktop\\-a($|\,)" ORDER BY username ASC
0.01337
SELECT id FROM users WHERE active=1 AND (username LIKE "%#desktop-a%" OR fullname LIKE "%#desktop-a%" OR position LIKE "%#desktop-a%") ORDER BY username ASC
0.01241
SELECT id FROM users WHERE active=1 AND (username="#desktop-a" OR fullname="#desktop-a" OR position="#desktop-a") ORDER BY username ASC