As no-one else has replied, I'll give you one cheap idea if you fancy a project rather than a finished solution.
You can get a decent core from a fire camera (eBay etc) and then build your own camera with the interesting bits.
Here is my latest work in progress, with a 160x120 Raytheon ASi out of a Marconi/e2v Argus 3
The box lid contains a 4" video in LCD also from the camera, and there's batteries to go in too. I have loosened off the lens grub screw so it can now be focussed.
Imaging 1mm objects is asking a bit much of a 160, but a 320 or 384 should be adequate. Otherwise to focus short you would need to add another lens on front of a camera set at normal viewing as described elsewhere on this forum.
Bill