<?php
//overwrite product query
add_action( 'woocommerce_product_query', 'a4mc_wc_product_query_init');
function a4mc_wc_product_query_init( $q ){
  $product_array_to_return = array();

//content of a json file with following structure:
$full_index_cache = json_decode("here the json content",true);
/*
{
"all-product-ids" :{
"110" : "110",
"111" : "111",
"112" : "112"
},
  "products":{
    "product_cat":{
      "category a":{
        "110" : "110",
        "111" : "111",
        "112" : "112"
      },
      "category b":{
        "110" : "110",
        "111" : "111",
        "112" : "112"
      },
      "category c":{
        "110" : "110",
        "111" : "111",
        "112" : "112"
      }
    },
    "pa_taxonomy_z":{
      "taxonomy value a":{
        "110" : "110",
        "111" : "111",
        "112" : "112"
      },
      "taxonomy value b":{
        "110" : "110",
        "111" : "111",
        "112" : "112"
      },
      "taxonomy value c":{
        "110" : "110",
        "111" : "111",
        "112" : "112"
      }
    }
  }
}
*/

//just as example, but better loop the get value and check for (category,taxonomy etc)
//No database request need to filter huge amount of product ids

  if(isset($_GET["swoof"]) && isset($_GET["product_cat"])){
    $product_array_to_return = $full_index_cache["products"]["product_cat"][$_GET["product_cat"]];
  }

  if(isset($_GET["swoof"]) && isset($_GET["pa_taxonomy_z"])){
    //No database request need to filter huge amount of product ids
    $product_array_to_return = intersect2($product_array_to_return,$full_index_cache["products"]["pa_taxonomy_z"][$_GET["pa_taxonomy_z"]]);
  }

  //... etc

  //do with this array eg database request like...
  $query = new WP_Query( array(
    'posts_per_page' => -1,
    'return' => 'ids',
    'status' => 'publish',
    'post_type' => 'product',
    'post__in' => $product_array_to_return,
    'meta_query'     => array(
        array( // Simple products type
            'key'           => '_sale_price',
            'value'         => 0,
            'compare'       => '>',
            'type'          => 'numeric'
        ),
      ),
    )
  );
  $product_array_to_return = wp_list_pluck($query->posts, 'ID');

  //then return the query to wp
  $q->set( 'post__in', (array) $product_array_to_return);
}

function intersect2($arrayOne, $arrayTwo)
{
    if($arrayOne != null && $arrayTwo != null){
      if(!empty($arrayOne) && !empty($arrayTwo)){
        $index = array_flip(array_filter($arrayOne));
        $second = array_flip(array_filter($arrayTwo));

        $x = array_intersect_key($index, $second);

        return array_flip($x);
      } else {
        return null;
      }
    } else {
      return null;
    }
}