Products may be accessed using SEO friendly URLs like /my-product instead of /catalog/product/view/id/{ID}
A. An event observer adds RewriteRules to .htaccess on product save
B. MagentoCatalogControllerProductView::loadByUrlKey loads product pages using the url_key attribute value
C. Using a URL Rewrite stored in the database connecting the request path with the target path
D. A plugin on MagentoUrlRewriteControllerRouter::match loads products by the url_key attribute