I have a lens which is dedicated to macro photography. I utilize it for product photography when listing items for sale on eBay and also for capturing images of small insects, bugs and creepy crawlers.
I also utilize focus stacking software for macro images. Since the objects being photographed are so small, the portion of the image that is considered to be in focus is very small. With focus stacking software, multiple images are taken at slightly different focal lengths and then combined to form a single image that is completely in focus.
Images can be viewed at here