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