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