Query time 0.00126
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "21.46"
},
"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": 31,
"rows_produced_per_join": 6,
"filtered": "20.00",
"index_condition": "(`s2cart`.`cscart_product_prices`.`product_id` in (276588,276589,276590,276591,276592,276593,276594,276595,276596,276597,276598,276599,276600,276601,276602,276603,276604,276605,276606,276607,276608,276609,276610,276611,276612,276613,276614,276615,276616,276617))",
"cost_info": {
"read_cost": "20.84",
"eval_cost": "0.62",
"prefix_cost": "21.46",
"data_read_per_join": "148"
},
"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 |
276588 |
0.00000000 |
276589 |
0.00000000 |
276590 |
0.00000000 |
276591 |
0.00000000 |
276592 |
0.00000000 |
276593 |
0.00000000 |
276594 |
0.00000000 |
276595 |
0.00000000 |
276596 |
0.00000000 |
276597 |
0.00000000 |
276598 |
0.00000000 |
276599 |
0.00000000 |
276600 |
0.00000000 |
276601 |
0.00000000 |
276602 |
0.00000000 |
276603 |
0.00000000 |
276604 |
0.00000000 |
276605 |
0.00000000 |
276606 |
0.00000000 |
276607 |
0.00000000 |
276608 |
0.00000000 |
276609 |
0.00000000 |
276610 |
0.00000000 |
276611 |
0.00000000 |
276612 |
0.00000000 |
276613 |
0.00000000 |
276614 |
0.00000000 |
276615 |
0.00000000 |
276616 |
0.00000000 |
276617 |
0.00000000 |