{
"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 (430695,430988,430644,431073,431083,431313,430628,430730,431043,431135,430842,430844,431063,431089,431167,431183,431459,339831,430829,430651,430662,430880,430884,431066,430869,430898,430899,430928,339762,430769,430962,431142,339781,430684,431035,430653,430712,430847,430891,431140,430631,430893,430626,431185,381713,431031,431093,430881,430896,430909,431123,339733,339691,430806,430883,431197,430633,430797,430900,430980,431250,339600,430873,431088,431226,430837,430787,430876,430930,431023,430645,430685,430758,430913,431064,339804,430676,430768,430772,431119,431121,339488,430760,430841,430981,431008,431078,431131,431198,339594,430796,430802,430846,431032,431113,431159,431178,431356,430698,430703)) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
339488 | 75.00000000 |
339594 | 9.00000000 |
339600 | 11.00000000 |
339691 | 5.00000000 |
339733 | 10.00000000 |
339762 | 70.00000000 |
339781 | 16.00000000 |
339804 | 40.00000000 |
339831 | 79.00000000 |
381713 | 80.00000000 |
430626 | 25.50000000 |
430628 | 25.50000000 |
430631 | 11.50000000 |
430633 | 11.50000000 |
430644 | 13.50000000 |
430645 | 13.50000000 |
430651 | 13.50000000 |
430653 | 31.50000000 |
430662 | 31.50000000 |
430676 | 29.90000000 |
430684 | 29.90000000 |
430685 | 29.90000000 |
430695 | 29.90000000 |
430698 | 29.90000000 |
430703 | 29.90000000 |
430712 | 29.90000000 |
430730 | 31.50000000 |
430758 | 31.50000000 |
430760 | 34.50000000 |
430768 | 34.50000000 |
430769 | 34.50000000 |
430772 | 34.50000000 |
430787 | 34.50000000 |
430796 | 34.50000000 |
430797 | 34.50000000 |
430802 | 34.50000000 |
430806 | 34.50000000 |
430829 | 29.90000000 |
430837 | 29.90000000 |
430841 | 29.90000000 |
430842 | 29.90000000 |
430844 | 29.90000000 |
430846 | 29.90000000 |
430847 | 29.90000000 |
430869 | 29.90000000 |
430873 | 29.90000000 |
430876 | 29.90000000 |
430880 | 29.90000000 |
430881 | 29.90000000 |
430883 | 31.50000000 |
430884 | 31.50000000 |
430891 | 31.50000000 |
430893 | 31.50000000 |
430896 | 45.50000000 |
430898 | 45.50000000 |
430899 | 45.50000000 |
430900 | 45.50000000 |
430909 | 45.50000000 |
430913 | 45.50000000 |
430928 | 31.50000000 |
430930 | 31.50000000 |
430962 | 31.50000000 |
430980 | 31.50000000 |
430981 | 31.50000000 |
430988 | 31.50000000 |
431008 | 31.50000000 |
431023 | 31.50000000 |
431031 | 31.50000000 |
431032 | 31.50000000 |
431035 | 31.50000000 |
431043 | 29.90000000 |
431063 | 29.90000000 |
431064 | 29.90000000 |
431066 | 29.90000000 |
431073 | 28.50000000 |
431078 | 26.50000000 |
431083 | 26.90000000 |
431088 | 28.50000000 |
431089 | 31.50000000 |
431093 | 31.50000000 |
431113 | 31.50000000 |
431119 | 17.90000000 |
431121 | 17.90000000 |
431123 | 17.90000000 |
431131 | 17.90000000 |
431135 | 29.90000000 |
431140 | 29.90000000 |
431142 | 29.90000000 |
431159 | 31.50000000 |
431167 | 26.90000000 |
431178 | 26.90000000 |
431183 | 26.90000000 |
431185 | 26.90000000 |
431197 | 29.90000000 |
431198 | 29.90000000 |
431226 | 31.50000000 |
431250 | 36.50000000 |
431313 | 45.50000000 |
431356 | 40.90000000 |
431459 | 29.90000000 |