Indexable database call detected when indexable is disabled via filter

[shabnam611]

• [x] I've read and understood the contribution guidelines.
• [x] I've searched for any related issues and avoided creating a duplicate issue.

Please give us a description of what happened

To Reproduce

Step-by-step reproduction instructions

1. Install and activate Query monitor plugin
2. Set your site to production
3. Add the filer _add_filter( 'Yoast\WP\SEO\should_index_indexables', '__returnfalse' ); to set the indexable to false. I used the Code Snippets plugin to add the filter and activate it.
4. Visit the frontend of the site and check Query monitor's Database query and look for the following outputs

• Yoast\W\S\R\Indexable_Repository->find_by_id_and_type()
• Yoast\W\S\R\Indexable_Repository->find_for_home_page()
• Yoast\W\S\R\Indexable_Hierarchy_Repository->find_ancestors()

Expected results

1. There should not be Indexable calls being made on the front-end

Actual results

1. Indexable calls are appearing on the front-end where it should not be

Screenshots, screen recording, code snippet

If possible, please provide a screenshot, a screen recording or a code snippet which demonstrates the bug.

Twenty Twenty theme

Twenty Twenty Four

Technical info

• If relevant, which editor is affected (or editors):
• [x] Block Editor
• [ ] Gutenberg Editor
• [ ] Elementor Editor
• [ ] Classic Editor
• [ ] Other:

• Which browser is affected (or browsers):
• [x] Chrome
• [ ] Firefox
• [ ] Safari
• [ ] Other:

Used versions

• Device you are using: Macbook pro
• Operating system: Sonoma 14.5
• PHP version: 8.0
• WordPress version: 6.5.5
• WordPress Theme: Twenty Twenty and Twenty Twenty Four
• Yoast SEO version: 23.0
• Gutenberg plugin version:
• Elementor plugin version:
• Classic Editor plugin version:
• Relevant plugins in case of a bug: Yoast Test Helper 1.18, Query Monitor 3.16.3, Code Snippets by Code Snippets Pro 3.6.5.1

[shabnam611]

+1 https://wordpress.org/support/topic/yoast-database-calls-expected-results/

[Pcosta88]

Thank you!

[josevarghese]

Closing this issue, as we have an internal FR with comments from the development team having the technical proposal on how to remove indexables related queries when the indexable filter Yoast\WP\SEO\should_index_indexables is set as false here: https://github.com/Yoast/featurerequests/issues/829.