{
"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 (89649,83970,83971,83972,83973,89620,89633,91304,83982,83983,83984,83985,91300,89650,89187,90067,90081,91839,89485,90083,86220,83128,84030,84031,84032,84033,84038,90082,88935,89188)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
}
}
}
| product_id | short_description | full_description |
|---|---|---|
| 83128 | nuie Arvan Deck Mounted Bath Filler - Brushed Brass | |
| 83970 | Old London White Topaz With Lever Handle Mono Basin Mixer - Chrome / White | |
| 83971 | Old London White Topaz With Crosshead Handle Mono Basin Mixer - Chrome / White | |
| 83972 | Old London White Topaz With Lever Handle Mono Basin Mixer - Chrome / White | |
| 83973 | Old London White Topaz With Crosshead Handle Mono Basin Mixer - Chrome / White | |
| 83982 | Old London White Topaz With Lever Handle Wall Mounted Bath Spout & Stop Taps - Chrome / White | |
| 83983 | Old London White Topaz With Crosshead Handle Wall Mounted Bath Spout & Stop Taps - Chrome / White | |
| 83984 | Old London White Topaz With Lever Handle Wall Mounted Bath Spout & Stop Taps - Chrome / White | |
| 83985 | Old London White Topaz With Crosshead Handle Wall Mounted Bath Spout & Stop Taps - Chrome / White | |
| 84030 | Old London Black Topaz With Lever Handle 3 Tap Hole Wall Mounted Basin Mixer - Chrome | |
| 84031 | Old London Black Topaz With Crosshead Handle 3 Tap Hole Wall Mounted Basin Mixer - Chrome | |
| 84032 | Old London Black Topaz With Lever Handle 3 Tap Hole Wall Mounted Basin Mixer - Chrome | |
| 84033 | Old London Black Topaz With Crosshead Handle 3 Tap Hole Wall Mounted Basin Mixer - Chrome | |
| 84038 | Old London Brass Topaz With Crosshead Handle 3 Tap Hole Wall Mounted Basin Mixer - Brushed Brass | |
| 86220 | nuie Hardy Bath Shower Mixer - Chrome | |
| 88935 | Hudson Reed Tec Single Lever Wall Mounted Basin Bath Filler - Matt Black | |
| 89187 | nuie Sanford Deck Mounted 3 Tap Hole Bath Filler - Chrome | |
| 89188 | nuie Sanford Deck Mounted 4 Tap Hole Bath Shower Mixer No Spout - Chrome | |
| 89485 | Hudson Reed Soar Bath Filler - Chrome | |
| 89620 | Hudson Reed Tec Lever Bath Shower Mixer - Chrome | |
| 89633 | Hudson Reed Tec Crosshead Bath Shower Mixer - Chrome | |
| 89649 | Hudson Reed Revolution Bath Filler - Matt Black | |
| 89650 | Hudson Reed Revolution Mono Basin Mixer - Brushed Brass | |
| 90067 | nuie Windon Wall Mounted Thermostatic Bath Shower Mixer - Chrome | |
| 90081 | nuie Windon Deck Mounted 3 Tap Hole Bath Filler - Chrome | |
| 90082 | nuie Windon Deck Mounted 4 Tap Hole Bath Shower Mixer No Spout - Chrome | |
| 90083 | nuie Windon Deck Mounted 3 Tap Hole Basin Mixer With Pop Up Waste - Chrome | |
| 91300 | nuie Aztec Deck Mount Bath Shower Mixer with Kit - Chrome | |
| 91304 | nuie Aztec Deck Mount Bath Filler - Matt Black | |
| 91839 | BC Designs Plinth Only For 1800mm Acrylic Boat Bath - White |