I have two pages, one working correctly and one broken.
The first is called Calendar and it has an ID of 34. I created a page template called page-34.php and wrote some custom code, and when I load the page the template is pulled correctly and the custom code displays correctly. I have a bunch of other pages on my site like this, and they work just like this.
And then I have the second, feisty page. It's name is FAQ and it has an ID of 35. I created a template called page-35.php and wrote some custom code, but when I load the page it just defaults to index.php.
To provide some background, I recently imported all of this content from a Drupal 7 site using a plugin. I'm wondering if something broke during that process. I'm a fairly experienced WordPress developer and I've done all my usual checks for this problem, so I'm at the point where I want to do a deeper debug.
Question: Does anyone know how to do a deep programmatic debug of the template hierarchy check? I'm not afraid to get my hands dirty in the database.