Query time 0.00210
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "67.91"
},
"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": 97,
"rows_produced_per_join": 19,
"filtered": "20.00",
"index_condition": "(`s2cart`.`cscart_product_prices`.`product_id` in (276426,276427,276428,276429,276430,276431,276432,276433,276434,276435,276436,276437,276438,276439,276440,276441,276442,276443,276444,276445,276446,276447,276448,276449,276450,276451,276452,276453,276454,276455,276456,276457,276458,276459,276460,276461,276462,276463,276464,276465,276466,276467,276468,276469,276470,276471,276472,276473,276474,276475,276476,276477,276478,276497,276498,276499,276500,276501,276502,276503,276504,276505,276506,276507,276508,276509,276510,276511,276512,276513,276514,276515,276516,276517,276518,276519,276520,276521,276522,276523,276524,276525,276526,276527,276528,276529,276530,276531,276532,276533,276534,276535,276536,276537,276538,276539,276540))",
"cost_info": {
"read_cost": "65.97",
"eval_cost": "1.94",
"prefix_cost": "67.91",
"data_read_per_join": "465"
},
"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 |
276426 |
0.00000000 |
276427 |
0.00000000 |
276428 |
0.00000000 |
276429 |
0.00000000 |
276430 |
0.00000000 |
276431 |
0.00000000 |
276432 |
0.00000000 |
276433 |
0.00000000 |
276434 |
0.00000000 |
276435 |
0.00000000 |
276436 |
0.00000000 |
276437 |
0.00000000 |
276438 |
0.00000000 |
276439 |
0.00000000 |
276440 |
0.00000000 |
276441 |
0.00000000 |
276442 |
0.00000000 |
276443 |
0.00000000 |
276444 |
0.00000000 |
276445 |
0.00000000 |
276446 |
0.00000000 |
276447 |
0.00000000 |
276448 |
0.00000000 |
276449 |
0.00000000 |
276450 |
0.00000000 |
276451 |
0.00000000 |
276452 |
0.00000000 |
276453 |
0.00000000 |
276454 |
0.00000000 |
276455 |
0.00000000 |
276456 |
0.00000000 |
276457 |
0.00000000 |
276458 |
0.00000000 |
276459 |
0.00000000 |
276460 |
0.00000000 |
276461 |
0.00000000 |
276462 |
0.00000000 |
276463 |
0.00000000 |
276464 |
0.00000000 |
276465 |
0.00000000 |
276466 |
0.00000000 |
276467 |
0.00000000 |
276468 |
0.00000000 |
276469 |
0.00000000 |
276470 |
0.00000000 |
276471 |
0.00000000 |
276472 |
0.00000000 |
276473 |
0.00000000 |
276474 |
0.00000000 |
276475 |
0.00000000 |
276476 |
0.00000000 |
276477 |
0.00000000 |
276478 |
0.00000000 |
276497 |
0.00000000 |
276498 |
0.00000000 |
276499 |
0.00000000 |
276500 |
0.00000000 |
276501 |
0.00000000 |
276502 |
0.00000000 |
276503 |
0.00000000 |
276504 |
0.00000000 |
276505 |
0.00000000 |
276506 |
0.00000000 |
276507 |
0.00000000 |
276508 |
0.00000000 |
276509 |
0.00000000 |
276510 |
0.00000000 |
276511 |
0.00000000 |
276512 |
0.00000000 |
276513 |
0.00000000 |
276514 |
0.00000000 |
276515 |
0.00000000 |
276516 |
0.00000000 |
276517 |
0.00000000 |
276518 |
0.00000000 |
276519 |
0.00000000 |
276520 |
0.00000000 |
276521 |
0.00000000 |
276522 |
0.00000000 |
276523 |
0.00000000 |
276524 |
0.00000000 |
276525 |
0.00000000 |
276526 |
0.00000000 |
276527 |
0.00000000 |
276528 |
0.00000000 |
276529 |
0.00000000 |
276530 |
0.00000000 |
276531 |
0.00000000 |
276532 |
0.00000000 |
276533 |
0.00000000 |
276534 |
0.00000000 |
276535 |
0.00000000 |
276536 |
0.00000000 |
276537 |
0.00000000 |
276538 |
0.00000000 |
276539 |
0.00000000 |
276540 |
0.00000000 |