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