I can reproduce this on BBS
something is not right about that query that is tripping the planner. Try looking at the plan and fiddling with it a bit.
My guess is that some very very small changes will get this down to 1 millisecond for almost 4 seconds.
Note to all the readers out there, having mini profiler enabled is key here, it can help you find the problem query.
