woocommerce-performance

Original：🇺🇸 English

Translated

Identify performance issues in WooCommerce PHP code. Use when writing or reviewing code that loads collections of post-based objects (products, orders), renders product lists with images, reads multiple options in a loop or method, or writes SQL queries involving joins, aggregates, meta lookups, or range queries.

9installs

Sourcewoocommerce/woocommerce

Added on2026-09-01

NPX Install

npx skill4agent add woocommerce/woocommerce woocommerce-performance

SKILL.md Content

View Translation Comparison →

WooCommerce Performance

Post Cache Priming — cache-priming.md

Use when writing or reviewing code that loads collections of post-based objects (products, orders) or renders product lists with images. Covers

_prime_post_caches()

usage patterns — both as a generation guide (apply these patterns when writing new code) and a review guide (flag missing priming in existing code).

Options Cache Priming — options-cache-priming.md

Use when writing or reviewing code that reads multiple non-autoloaded options in a loop or method. Covers

wp_prime_option_caches()

usage patterns for static key lists, derivable key patterns, and dynamically extracted key sets (excluding autoloaded options, which are already in cache).

SQL Query Patterns — sql-query-patterns.md

Use when writing or reviewing any SQL query in WooCommerce PHP code. Covers: redundant posts joins, fan-out JOIN on

wp_term_relationships

, N-query loops, OR index-merge, cross-product meta conditions, multi-fan join decoupling, WooCommerce lookup table preference (

wc_product_meta_lookup

,

wc_product_attributes_lookup

), and MIN/MAX full-scan elimination.