How to find the non-SEF URL whilst SEF is enabled (Joomla 1.5)?-Collection of common programming errors
For menu items, it’s stored in the ‘jos_menu’ table, in the ‘link’ column (but the itemid is not in this string – it’s the ‘id’ column).
For anything else, it’s probably not stored in the database, but can normally be worked out pretty easily, especially with core components. It can be a little bit of a pain with third party components, but you can look through the MVC architecture of most components to figure it out.
Otherwise, you could always turn off SEF on your dev site/create a dev site for this.
Is there a specific component that you’re curious about?