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