I have a confusion in product and category url rewrite concept. Is magento stores the url in database? If yes which table? If no how we get the category and product url from collections? like this.
$product_collection = Mage::getModel('catalog/product')->getCollection()
->addAttributeToFilter('entity_id', 16)
->addUrlRewrite();
$product_collection_url = $product_collection->getFirstItem()->getProductUrl();
and what is addUrlRewrite()
?
Please explain.