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