SELECT id FROM users WHERE active=1 AND about_me LIKE "%#preg\_replace%" ORDER BY username ASC, num_followers DESC
0.01322
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#preg_replace($|\,)" ORDER BY username ASC
0.01744
SELECT id FROM users WHERE active=1 AND (username LIKE "%#preg\_replace%" OR fullname LIKE "%#preg\_replace%" OR position LIKE "%#preg\_replace%") ORDER BY username ASC
0.01245
SELECT id FROM users WHERE active=1 AND (username="#preg_replace" OR fullname="#preg_replace" OR position="#preg_replace") ORDER BY username ASC