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