Load an url with minimal/no DB queries

It is excruciatingly painful to deeply customize WordPress load process.

It’s not quite clear if your requirements here are performance related or tied to soemthing else.

For your question as stated there would be about following approaches (madness ascending):

  • get rid of actual code causing unwanted queries, altogether or via techniques like caching
  • customize the load process in runtime, such as using mu-plugin to control which plugins are loaded
  • build a custom SHORTINIT endpoint and load the required minimum of WP core in “manual” way with your own code

Related Posts:

  1. How to create custom URL routes?
  2. URL rewriting with custom user meta “/%shop_name%/gallery/%gallery%”
  3. How can I create custom URL routes?
  4. How do you create a “virtual” page in WordPress
  5. Rewrite rules not working in WordPress
  6. How to add custom rewrite rule to .htaccess?
  7. Preserving $_GET parameter while using custom Rewrite Rule
  8. Taxonomy rewrite question
  9. Why does wordpress still strip my query var?
  10. When to call `add_rewrite_rule` for safety
  11. Getting add_rewrite_rule and add_rewrite_tag to work
  12. Rewrite rules goes away
  13. Rewrite Rule for Custom Page with Query Vars in URL
  14. Dynamic URL, not a physical page within the database
  15. Rewrite Rule for Post “Subpage”, with pagination
  16. WP Rewrite the last two parts of the URL
  17. Nginx rewrite rule conflict with WordPress permalinks rule
  18. Access $_POST data after redirect
  19. Change Query String to pretty permalink
  20. add_rewrite_rule not working for language specific characters
  21. How to add a custom redirect rule for subdomains?
  22. Custom rewrite rule
  23. How to do Basic URL Rewrite Without Redirecting
  24. Is it possible to remove feeds from rewrites?
  25. URL Rewrite doesn’t work for nested pages
  26. Rewrite URL – insert custom variables as a directory path
  27. WordPress not respecting template hierarchy (fetches index.php instead of single.php or page.php)
  28. How to properly rewrite url by custom var
  29. Can’t add external rewrites
  30. url rewrite parsing a custom url parameter not working
  31. How to add custom variable in url without redirect?
  32. Using category slug in add_rewrite rule
  33. add_rewrite_rule ignoring other params than the “p” param
  34. Url Rewriting a dynamic wordpress page
  35. How to catch Rewrite rules then display a specific post?
  36. Adding two rewrite rules
  37. How to building pretty URLs to reflect category hierarchy?
  38. WordPress Rewrites – How can I pass a variable to Custom Post Type?
  39. Monkey Man Rewrite Analyzer says my rule will trigger but it doesn’t [closed]
  40. .htaccess rewrite
  41. Need to add rewrite rule that adds in additional information about the post to url
  42. Auto generate rewrite rules for multiple taxonomies
  43. add_rewrite_rule is redirecting instead of rewriting url
  44. Help with Rewrite Rule for Custom Post Type with Query String
  45. Rewrite URLs – Custom Post Type – Post Slug, Taxonamy Slug
  46. URL Rewriting for PHP script on an image URL
  47. Create Dynamic SEO Friendly URL for Virtual Page
  48. add_rewrite_rule with query variables
  49. Rewrite rules automatically for pages using specific template
  50. Custom Rewrite rule to captured post (rewrite rule to rewrite rule)
  51. Rewrite query string to path
  52. Rewrite API -Adding a parameter before the slug
  53. Help with rewrite rules for two post types
  54. How to pass url as a parameter in a add_rewrite_rule
  55. Per Page Permalink Structure for Page Post Type
  56. Customise particular RSS permalink
  57. RSS feed rewrite matching wrong rule
  58. Rewrites rules disappear after a while
  59. Adding a rewrite rule to page that has no fixed variables and pagination
  60. Flush rewrite rules on option update with Settings API
  61. Localize URL bases
  62. Rewrite specific action url
  63. Using URL rewrite to add custom URL for custom post type
  64. WordPress simple Url Rewrite
  65. Custom rewrite rule not working
  66. Rewriting in wordpress url
  67. Add pagination to a template loaded by query variable
  68. Rewrite rule shows 404 page
  69. Why is a rewrite rule in wordpress prevent pagination?
  70. Rewrite custom taxonomy slug – but only parent items
  71. How can I allow trailing slashes on some URLs without a redirect, but not on others?
  72. Adding the amp url prefix to the beginning
  73. wordpress path generation from rewrite rule
  74. Rewrite WordPress Url from root to subfolder without moving files
  75. How to redirect to a login virtual page?
  76. Ugly URLs when there’s pagination
  77. How do I rewrite URL that has custom parameter
  78. Help adding custom url, rewrite_rules_array
  79. Why is there a 404 on page 2+ for my search page?
  80. Rewrite rule for post as a child of a CPT
  81. Broken page redirect
  82. URL Rewrite and Archive Template Files – Post Type vs. Taxonomy
  83. URL rewrite before template_redirect called
  84. add_rewrite Rule
  85. rewrite rule of post when accessed from archives pages
  86. .htaccess RewriteBase equivalent for WordPress – Passing a URL as a variable without getting a 404
  87. URL Rewrite for CPT single posts
  88. Migration from old CMS to WordPress 301 redirection rules?
  89. How to make a custom route with any-string-part/number-part pointing to an existing page?
  90. Using add_rewrite_tag to create urls for page sections
  91. Rewriting WordPress URLs
  92. Can’t get pretty permalinks to work without index.php
  93. Programmatically add a custom url route “/category/index.json” to return a collection of posts in json
  94. Rewrite rule to simulate page hierarchy results in 404
  95. Rewrite URLs in a Custom Post Type with Multiple Taxonomies
  96. Rewrite rule giving 404 error
  97. add_rewrite_rule not working with custom variables
  98. WordPress picks a wrong template if ?cat= is used as URL parameter
  99. WP-Include rewrite directory
  100. How to combine nearly identical custom rewrite rules for WordPress