{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "25.66"
},
"grouping_operation": {
"using_filesort": false,
"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": 37,
"rows_produced_per_join": 7,
"filtered": "20.00",
"index_condition": "(`cscartdb`.`cscart_product_prices`.`product_id` in (62676,57923,57919,63369,57930,57936,57912,63445,63383,62954,57913,57917,57924,63431,63395,57934,57915,57914,57940,57946,63419,63407,57947,57916,57927,57920,57922,57918,57928,57929,63684,63457,57911,57935,63443,63682))",
"cost_info": {
"read_cost": "24.92",
"eval_cost": "0.74",
"prefix_cost": "25.66",
"data_read_per_join": "177"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`cscartdb`.`cscart_product_prices`.`lower_limit` = 1) and (`cscartdb`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
57911 | 250.00000000 |
57912 | 50.00000000 |
57913 | 100.00000000 |
57914 | 140.00000000 |
57915 | 160.00000000 |
57916 | 160.00000000 |
57917 | 150.00000000 |
57918 | 220.00000000 |
57919 | 90.00000000 |
57920 | 55.00000000 |
57922 | 60.00000000 |
57923 | 50.00000000 |
57924 | 100.00000000 |
57927 | 150.00000000 |
57928 | 60.00000000 |
57929 | 220.00000000 |
57930 | 330.00000000 |
57934 | 250.00000000 |
57935 | 310.00000000 |
57936 | 140.00000000 |
57940 | 110.00000000 |
57946 | 260.00000000 |
57947 | 250.00000000 |
62676 | 220.00000000 |
62954 | 260.00000000 |
63369 | 70.00000000 |
63383 | 155.00000000 |
63395 | 210.00000000 |
63407 | 80.00000000 |
63419 | 160.00000000 |
63431 | 110.00000000 |
63443 | 60.00000000 |
63445 | 310.00000000 |
63457 | 180.00000000 |
63682 | 250.00000000 |
63684 | 220.00000000 |