Query time 0.34424
JSON explain
{
"query_block": {
"select_id": 1,
"table": {
"table_name": "products",
"access_type": "ref",
"possible_keys": ["PRIMARY", "status"],
"key": "status",
"key_length": "3",
"used_key_parts": ["status"],
"ref": ["const"],
"rows": 57984,
"filtered": 100,
"attached_condition": "products.`status` = 'A'",
"using_index": true
},
"table": {
"table_name": "cscart_products",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["staging2_wesave_com.products.product_id"],
"rows": 1,
"filtered": 100,
"using_index": true
},
"table": {
"table_name": "cscart_product_prices",
"access_type": "ref",
"possible_keys": ["usergroup", "product_id", "lower_limit", "usergroup_id"],
"key": "usergroup",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["staging2_wesave_com.products.product_id"],
"rows": 1,
"filtered": 25,
"attached_condition": "cscart_product_prices.lower_limit = 1 and cscart_product_prices.usergroup_id in (0,0,1)"
},
"table": {
"table_name": "prices_2",
"access_type": "ref",
"possible_keys": ["usergroup", "product_id", "lower_limit", "usergroup_id"],
"key": "usergroup",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["staging2_wesave_com.products.product_id"],
"rows": 1,
"filtered": 25,
"attached_condition": "trigcond(prices_2.price is null) and trigcond(prices_2.lower_limit = 1 and cscart_product_prices.price > prices_2.price and prices_2.usergroup_id in (0,0,1))",
"not_exists": true
}
}
}
Result
min |
max |
0.00 |
999.99 |