Query time 0.00067
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "21.01"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_master_products_storefront_min_price",
"access_type": "system",
"possible_keys": [
"PRIMARY"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"storefront_id",
"product_id",
"price"
]
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "range",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"rows_examined_per_scan": 30,
"rows_produced_per_join": 5,
"filtered": "20.00",
"index_condition": "(`s2cart`.`cscart_product_prices`.`product_id` in (276633,276634,276635,276636,276637,276638,276639,276640,276641,276642,276643,276644,276645,276646,276647,276648,276649,276650,276651,276652,276653,276654,276655,276656,276657,276658,276659,276660,276661,276662))",
"cost_info": {
"read_cost": "20.41",
"eval_cost": "0.60",
"prefix_cost": "21.01",
"data_read_per_join": "143"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`s2cart`.`cscart_product_prices`.`lower_limit` = 1) and (`s2cart`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
]
}
}
}
Result
product_id |
price |
276633 |
0.00000000 |
276634 |
0.00000000 |
276635 |
0.00000000 |
276636 |
0.00000000 |
276637 |
0.00000000 |
276638 |
0.00000000 |
276639 |
0.00000000 |
276640 |
0.00000000 |
276641 |
0.00000000 |
276642 |
0.00000000 |
276643 |
0.00000000 |
276644 |
0.00000000 |
276645 |
0.00000000 |
276646 |
0.00000000 |
276647 |
0.00000000 |
276648 |
0.00000000 |
276649 |
0.00000000 |
276650 |
0.00000000 |
276651 |
0.00000000 |
276652 |
0.00000000 |
276653 |
0.00000000 |
276654 |
0.00000000 |
276655 |
0.00000000 |
276656 |
0.00000000 |
276657 |
0.00000000 |
276658 |
0.00000000 |
276659 |
0.00000000 |
276660 |
0.00000000 |
276661 |
0.00000000 |
276662 |
0.00000000 |