{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "13.52"
},
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"rows_examined_per_scan": 30,
"rows_produced_per_join": 30,
"filtered": "100.00",
"cost_info": {
"read_cost": "10.52",
"eval_cost": "3.00",
"prefix_cost": "13.52",
"data_read_per_join": "114K"
},
"used_columns": [
"product_id",
"lang_code",
"short_description",
"full_description"
],
"attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (88015,87972,87944,88154,94484,94486,94487,94488,94489,94490,94491,94493,94494,94505,94506,94507,94509,94511,94512,94513,94516,94517,94518,94519,94520,94521,94522,94523,94524,94525)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
}
}
}
| product_id | short_description | full_description |
|---|---|---|
| 87944 | nuie Asselby Small Cloakroom Basin 1 Tap Hole | |
| 87972 | Nuie 545mm Basin 1 Tap Hole | |
| 88015 | nuie Melbourne Large Basin 2 Tap Hole | |
| 88154 | nuie Lawton 560mm Basin 1 Tap Hole | |
| 94484 | ||
| 94486 | ||
| 94487 | ||
| 94488 | ||
| 94489 | ||
| 94490 | ||
| 94491 | ||
| 94493 | ||
| 94494 | ||
| 94505 | ||
| 94506 | ||
| 94507 | ||
| 94509 | ||
| 94511 | ||
| 94512 | ||
| 94513 | ||
| 94516 | ||
| 94517 | ||
| 94518 | ||
| 94519 | ||
| 94520 | ||
| 94521 | ||
| 94522 | ||
| 94523 | ||
| 94524 | ||
| 94525 |