Reccomend some good insoles

I wait tables for a living, and am on my feet a good 7 or 8 hours a day. Naturally after awhile my feet get tired and sore. Before work on Friday, I bought a pair of insoles for my shoes. They worked great Friday night, but Saturday night my feet started hurting again, and tonight they hurt even worse.

Does anyone know of a good brand and type of shoe insole that lasts for awhile?