{
"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 (90090,90100,83105,84745,83986,83987,83988,83989,84111,90087,90097,88930,90107,91837,92011,92012,92013,92014,92015,92016,92017,92099,92100,92101,92102,92103,92104,92105,83089,84096)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
}
}
}
| product_id | short_description | full_description |
|---|---|---|
| 83089 | nuie Arvan Wall Mounted Thermostatic Bath Shower Mixer - Chrome | |
| 83105 | nuie Arvan Deck Mounted 3 Tap Hole Basin Mixer With Pop Up Waste - Chrome | |
| 83986 | Old London White Topaz With Lever Handle 3 Tap Hole Wall Mounted Basin Mixer - Chrome | |
| 83987 | Old London White Topaz With Crosshead Handle 3 Tap Hole Wall Mounted Basin Mixer - Chrome | |
| 83988 | Old London White Topaz With Lever Handle 3 Tap Hole Wall Mounted Basin Mixer - Chrome | |
| 83989 | Old London White Topaz With Crosshead Handle 3 Tap Hole Wall Mounted Basin Mixer - Chrome | |
| 84096 | nuie Binsey Wall Mounted Thermostatic Bath Shower Mixer - Chrome | |
| 84111 | nuie Binsey Deck Mounted 3 Tap Hole Basin Mixer With Pop Up Waste - Chrome | |
| 84745 | nuie Bar Showers Thermostatic Bath Shower Mixer - Chrome | |
| 88930 | Hudson Reed Tec Single Lever Wall Mounted Basin Bath Filler - Chrome | |
| 90087 | nuie Windon Deck Mounted Bath Filler - Matt Black | |
| 90090 | nuie Windon Wall Mounted 2 Tap Hole Basin Mixer With Plate - Matt Black | |
| 90097 | nuie Windon Deck Mounted Bath Filler - Gunmetal | |
| 90100 | nuie Windon Wall Mounted 2 Tap Hole Basin Mixer With Plate - Gunmetal | |
| 90107 | nuie Windon Mono Basin Mixer With Push Button Waste - Brushed Brass | |
| 91837 | BC Designs Plinth Only For 1580mm Acrylic Boat Bath - White | |
| 92011 | BC Designs Victrion Deck Mounted Crosshead Bath Pillar Taps - Brushed Chrome | |
| 92012 | BC Designs Victrion Deck Mounted Crosshead Bath Pillar Taps - Brushed Copper | |
| 92013 | BC Designs Victrion Deck Mounted Crosshead Bath Pillar Taps - Brushed Gold | |
| 92014 | BC Designs Victrion Deck Mounted Crosshead Bath Pillar Taps - Brushed Nickel | |
| 92015 | BC Designs Victrion Deck Mounted Crosshead Bath Pillar Taps - Copper | |
| 92016 | BC Designs Victrion Deck Mounted Crosshead Bath Pillar Taps - Gold | |
| 92017 | BC Designs Victrion Deck Mounted Crosshead Bath Pillar Taps - Nickel | |
| 92099 | BC Designs Victrion Deck Mounted Lever Bath Pillar Taps - Brushed Chrome | |
| 92100 | BC Designs Victrion Deck Mounted Lever Bath Pillar Taps - Brushed Copper | |
| 92101 | BC Designs Victrion Deck Mounted Lever Bath Pillar Taps - Brushed Gold | |
| 92102 | BC Designs Victrion Deck Mounted Lever Bath Pillar Taps - Brushed Nickel | |
| 92103 | BC Designs Victrion Deck Mounted Lever Bath Pillar Taps - Copper | |
| 92104 | BC Designs Victrion Deck Mounted Lever Bath Pillar Taps - Gold | |
| 92105 | BC Designs Victrion Deck Mounted Lever Bath Pillar Taps - Nickel |