SQL query executed 3 times (not wanted)

[eluser]oldmatt[/eluser]
I don't know if this is your problem, but I have had problems in the past with routes because I was not careful about how I defined the routes.

URI Routing

That page in the documentation shows in the pink note box, that the order in which you define routes affects the results.

Again, I didn't really extensively look into your code, but I thought it might be a good place to start.