{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "280.31"
},
"grouping_operation": {
"using_filesort": false,
"table": {
"table_name": "cscart_product_prices",
"access_type": "range",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"used_key_parts": [
"product_id",
"usergroup_id",
"lower_limit"
],
"key_length": "9",
"rows_examined_per_scan": 200,
"rows_produced_per_join": 200,
"filtered": "100.00",
"cost_info": {
"read_cost": "240.31",
"eval_cost": "40.00",
"prefix_cost": "280.31",
"data_read_per_join": "12K"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`webmarco`.`cscart_product_prices`.`lower_limit` = 1) and (`webmarco`.`cscart_product_prices`.`product_id` in (430732,430942,431453,430833,430985,431076,431466,431480,339768,431219,431330,430750,431210,431353,431438,431452,431481,430719,431222,431239,431380,430724,430987,431181,431241,431285,431377,431387,431447,381709,430632,430693,430727,431229,431384,431412,431440,431208,431292,431385,431502,430733,431236,431188,431281,430682,430721,431259,431224,431361,431335,431421,430699,431249,431253,431332,430701,430955,431040,431458,430951,431081,431172,431402,430731,430757,430945,431009,431263,431431,430970,431143,431170,431215,431298,431468,431472,381715,430736,431414,431442,431455,431478,381706,431364,431401,431454,430941,431180,431369,381708,430725,430954,431233,431378,431446,431014,431212,431213,431225)) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
339768 | 58.00000000 |
381706 | 40.00000000 |
381708 | 40.00000000 |
381709 | 60.00000000 |
381715 | 0.00000000 |
430632 | 11.50000000 |
430682 | 29.90000000 |
430693 | 29.90000000 |
430699 | 29.90000000 |
430701 | 29.90000000 |
430719 | 31.50000000 |
430721 | 31.50000000 |
430724 | 31.50000000 |
430725 | 31.50000000 |
430727 | 31.50000000 |
430731 | 31.50000000 |
430732 | 31.50000000 |
430733 | 31.50000000 |
430736 | 31.50000000 |
430750 | 31.50000000 |
430757 | 31.50000000 |
430833 | 29.90000000 |
430941 | 31.50000000 |
430942 | 31.50000000 |
430945 | 31.50000000 |
430951 | 31.50000000 |
430954 | 31.50000000 |
430955 | 31.50000000 |
430970 | 31.50000000 |
430985 | 31.50000000 |
430987 | 31.50000000 |
431009 | 31.50000000 |
431014 | 31.50000000 |
431040 | 29.90000000 |
431076 | 28.50000000 |
431081 | 26.50000000 |
431143 | 29.90000000 |
431170 | 26.90000000 |
431172 | 26.90000000 |
431180 | 26.90000000 |
431181 | 26.90000000 |
431188 | 26.90000000 |
431208 | 29.90000000 |
431210 | 29.90000000 |
431212 | 29.90000000 |
431213 | 29.90000000 |
431215 | 29.90000000 |
431219 | 29.90000000 |
431222 | 29.90000000 |
431224 | 31.50000000 |
431225 | 31.50000000 |
431229 | 31.50000000 |
431233 | 31.50000000 |
431236 | 58.90000000 |
431239 | 31.50000000 |
431241 | 31.50000000 |
431249 | 36.50000000 |
431253 | 36.50000000 |
431259 | 36.50000000 |
431263 | 54.50000000 |
431281 | 63.50000000 |
431285 | 36.50000000 |
431292 | 45.50000000 |
431298 | 45.50000000 |
431330 | 67.90000000 |
431332 | 67.90000000 |
431335 | 67.90000000 |
431353 | 40.90000000 |
431361 | 49.90000000 |
431364 | 49.90000000 |
431369 | 49.90000000 |
431377 | 45.50000000 |
431378 | 45.50000000 |
431380 | 45.50000000 |
431384 | 45.50000000 |
431385 | 45.50000000 |
431387 | 49.90000000 |
431401 | 49.90000000 |
431402 | 49.90000000 |
431412 | 49.90000000 |
431414 | 49.90000000 |
431421 | 58.90000000 |
431431 | 34.50000000 |
431438 | 34.50000000 |
431440 | 34.50000000 |
431442 | 34.50000000 |
431446 | 29.90000000 |
431447 | 29.90000000 |
431452 | 29.90000000 |
431453 | 29.90000000 |
431454 | 29.90000000 |
431455 | 29.90000000 |
431458 | 29.90000000 |
431466 | 31.50000000 |
431468 | 31.50000000 |
431472 | 31.50000000 |
431478 | 34.50000000 |
431480 | 34.50000000 |
431481 | 34.50000000 |
431502 | 73.90000000 |