SELECT id FROM users WHERE active=1 AND about_me LIKE "%#flux-pavilion%" ORDER BY username ASC, num_followers DESC
0.00947
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#flux\\-pavilion($|\,)" ORDER BY username ASC
0.01309
SELECT id FROM users WHERE active=1 AND (username LIKE "%#flux-pavilion%" OR fullname LIKE "%#flux-pavilion%" OR position LIKE "%#flux-pavilion%") ORDER BY username ASC
0.01155
SELECT id FROM users WHERE active=1 AND (username="#flux-pavilion" OR fullname="#flux-pavilion" OR position="#flux-pavilion") ORDER BY username ASC