SELECT id FROM users WHERE active=1 AND about_me LIKE "%bike japan%" ORDER BY username ASC, num_followers DESC
0.02389
SELECT id FROM users WHERE tags REGEXP "(^|\,| )bike japan($|\,)" ORDER BY username ASC
0.01114
SELECT id FROM users WHERE active=1 AND (username LIKE "%bike japan%" OR fullname LIKE "%bike japan%" OR position LIKE "%bike japan%") ORDER BY username ASC
0.00911
SELECT id FROM users WHERE active=1 AND (username="bike japan" OR fullname="bike japan" OR position="bike japan") ORDER BY username ASC