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