{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"table": {
"table_name": "cscart_ec_extra_product_data",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "40"
},
"used_columns": [
"product_id",
"maximum_adults",
"maximum_children",
"maximum_room_occupancy",
"minimum_length_of_stay",
"maximum_length_of_stay",
"company_id",
"blocked_date"
]
}
}
}
product_id | maximum_adults | maximum_children | maximum_room_occupancy | minimum_length_of_stay | maximum_length_of_stay | company_id | blocked_date |
---|---|---|---|---|---|---|---|
350 | 2 | 1 | 3 | 2 | 4 | 2 | 30/08/2024 |