Current Posts. The Query Is:
Array
(
[product_cat] => wall-decor
[fields] => all
[orderby] => rand
[order] => ASC
[tax_query] => Array
(
[relation] => AND
[0] => Array
(
[taxonomy] => product_visibility
[field] => term_taxonomy_id
[terms] => Array
(
[0] => 21
)
[operator] => NOT IN
)
)
[wc_query] => product_query
[posts_per_page] => 9
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_post_term_cache] => 1
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[comments_per_page] => 50
[taxonomy] => product_cat
[term] => wall-decor
)
SELECT SQL_CALC_FOUND_ROWS tds_posts.ID
FROM tds_posts LEFT JOIN tds_term_relationships ON (tds_posts.ID = tds_term_relationships.object_id) LEFT JOIN tds_term_relationships AS tt1 ON (tds_posts.ID = tt1.object_id)
WHERE 1=1 AND (
tds_posts.ID NOT IN (
SELECT object_id
FROM tds_term_relationships
WHERE term_taxonomy_id IN (21)
)
AND
tds_term_relationships.term_taxonomy_id IN (1540,1547,1555)
AND
tt1.term_taxonomy_id IN (1540,1547,1555)
) AND ((tds_posts.post_type = 'product' AND (tds_posts.post_status = 'publish' OR tds_posts.post_status = 'acf-disabled')))
GROUP BY tds_posts.ID
ORDER BY RAND()
LIMIT 0, 9
Array
(
[product_cat] => wall-decor
[fields] => all
[orderby] => rand
[tax_query] => Array
(
[relation] => AND
[0] => Array
(
[taxonomy] => product_visibility
[field] => term_taxonomy_id
[terms] => Array
(
[0] => 21
)
[operator] => NOT IN
)
)
[wc_query] => product_query
[posts_per_page] => 9
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_post_term_cache] => 1
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[comments_per_page] => 50
[taxonomy] => product_cat
[term] => wall-decor
)
Query modify callbacks ( posts_request ):
Query modify callbacks ( posts_pre_query ):
Query modify callbacks ( posts_where ):
Query modify callbacks ( posts_clauses ):
1. Automattic\WooCommerce\Internal\ProductFilters\QueryClauses->add_query_clauses_for_main_query()
2. Automattic\WooCommerce\Blocks\BlockTypes\ProductCollection\QueryBuilder->add_price_range_filter_posts_clauses()
3. WC_Query->product_query_post_clauses()
Query modify callbacks ( posts_join ):
Query modify callbacks ( pre_get_posts ):
1. WC_Query->pre_get_posts()
2. Automattic\Jetpack\VideoPress\Attachment_Handler->media_list_table_query()
3. ElementorPro\Modules\Search\Module->set_query()
Query modify callbacks ( posts_orderby ):
Query modify callbacks ( parse_tax_query ):
Query modify callbacks ( posts_selection ):
Query modify callbacks ( parse_term_query ):
