Adding a page to the Sitemap2 users found helpful
URLs look like: /index.php/profile/showmyprofile/
Which is a physical path but no file is found.
The templates are stored in files (for concrete5, they're in the "themes" directory), but the content is stored in the database.
Are you trying to solve a specific problem with your site or are you just curious about how it works? If you're having a specific problem, please post more details and people might be able to provide a solution for you.
I'm just wondering how it works and understand why some pages are physical files while others are not.