Here's a snapshot for you, to illustrate how little we know about what many of our compounds can do. I was browsing the latest issue of the British Journal of Pharmacology, which is one of many perfectly respectable journals in that field, and was struck by the table of contents.
Here, for example, is a paper on Celebrex (celecoxib), but not about its role in pain or inflammation. No, this one, from a group in Turin, is studying the drug's effects on a colon cancer cell line, and finding that it affects the ability of the cells to stick to surfaces. This appears to be driven by downregulation of adhesion proteins such as ICAM-1 and VCAM-1, and that seems to have nothing particular to do with COX-2 inhibition, which is, of course, the whole reason that Celebrex exists.
This is a story that's been going on for a few years now. There's been quite a bit of study on the use of COX-2 drugs in cancer (particularly colon cancer), but that was driven by their actual COX-2 effects. Now it's to the point that people are looking at close analogs of the drugs that don't have any COX-2 effects at all, but still seem to have promise in oncology. You never know.
Moving down the list of papers, there's this one, which studies a well-known model of diabetes in rats. Cardiovascular complications are among the worst features of chronic diabetes, so these folks are looking at the effect of vascular relaxing compounds to see if they might provide some therapeutic effect. And they found that giving these diabetic rats sildenafil, better known as Viagra, seems to have helped quite a bit. They suggest that smaller chronic doses might well be beneficial in human patients, which is definitely not something that the drug was targeted for, but could actually work.
And further down, here's another paper looking at a known drug. In this case, it's another piece of the puzzle about the effects of Acomplia (rimonabant), Sanofi-Aventis's one-time wonder drug candidate for obesity. It's become clear that it (and perhaps all CB-1 compounds) may also have effects on inflammation and the immune system, and these researchers confirm that with one subtype of blood cells. It appears that rimonabant is also a novel immune modulator, which is most definitely not one of the things it was envisioned as. Do the other CB-1 compounds (such as Merck's taranabant) have such effects? No one knows, but it wouldn't come as a complete surprise, would it?
These are not unusual examples. They just serve to show how little we understand about human physiology, and how important it is to study drugs in whole living systems. You might never learn about such things by studying the biochemical pathways in isolation, as valuable as that is in other contexts. But our context in the drug industry is the real world, with real human patients, and they're going to be surprising us for a long time to come. Good surprises, and bad ones, too.