{
"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 (92024,92025,92107,92108,92109,92110,92111,92112,92113,89626,89639,83097,92151,92152,92153,92353,92354,92355,92356,89651,89652,84103,83974,83975,83976,83977,84014,84015,84016,84017)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
}
}
}
| product_id | short_description | full_description |
|---|---|---|
| 83097 | nuie Arvan Deck Mounted 5 Tap Hole Bath Shower Mixer - Chrome | |
| 83974 | Old London White Topaz With Lever Handle Bidet Tap - Chrome | |
| 83975 | Old London White Topaz With Crosshead Handle Bidet Tap - Chrome | |
| 83976 | Old London White Topaz With Lever Handle Bidet Tap - Chrome | |
| 83977 | Old London White Topaz With Crosshead Handle Bidet Tap - Chrome | |
| 84014 | Old London Black Topaz With Lever Handle Mono Basin Mixer - Chrome / Black | |
| 84015 | Old London Black Topaz With Crosshead Handle Mono Basin Mixer - Chrome / Black | |
| 84016 | Old London Black Topaz With Lever Handle Mono Basin Mixer - Chrome / Black | |
| 84017 | Old London Black Topaz With Crosshead Handle Mono Basin Mixer - Chrome / Black | |
| 84103 | nuie Binsey Deck Mounted 5 Tap Hole Bath Shower Mixer - Chrome | |
| 89626 | Hudson Reed Tec Lever Bath Filler - Brushed Brass | |
| 89639 | Hudson Reed Tec Crosshead Bath Filler - Brushed Brass | |
| 89651 | Hudson Reed Revolution Wall Mounted Basin Mixer - Brushed Brass | |
| 89652 | Hudson Reed Revolution Bath Filler - Brushed Brass | |
| 92024 | BC Designs Victrion Deck Mounted Crosshead Mono Basin Mixer Tap - Gold | |
| 92025 | BC Designs Victrion Deck Mounted Crosshead Mono Basin Mixer Tap - Nickel | |
| 92107 | BC Designs Victrion Deck Mounted Lever Mono Basin Mixer Tap - Brushed Chrome | |
| 92108 | BC Designs Victrion Deck Mounted Lever Mono Basin Mixer Tap - Brushed Copper | |
| 92109 | BC Designs Victrion Deck Mounted Lever Mono Basin Mixer Tap - Brushed Gold | |
| 92110 | BC Designs Victrion Deck Mounted Lever Mono Basin Mixer Tap - Brushed Nickel | |
| 92111 | BC Designs Victrion Deck Mounted Lever Mono Basin Mixer Tap - Copper | |
| 92112 | BC Designs Victrion Deck Mounted Lever Mono Basin Mixer Tap - Gold | |
| 92113 | BC Designs Victrion Deck Mounted Lever Mono Basin Mixer Tap - Nickel | |
| 92151 | BC Designs Standpipes Traditional Bath Legs with Adjustable Shrouds - Copper | |
| 92152 | BC Designs Standpipes Traditional Bath Legs with Adjustable Shrouds - Gold | |
| 92153 | BC Designs Standpipes Traditional Bath Legs with Adjustable Shrouds - Nickel | |
| 92353 | BC Designs Bath Legs with Adjustable Shrouds - Brushed Chrome | |
| 92354 | BC Designs Bath Legs with Adjustable Shrouds - Brushed Copper | |
| 92355 | BC Designs Bath Legs with Adjustable Shrouds - Brushed Gold | |
| 92356 | BC Designs Bath Legs with Adjustable Shrouds - Brushed Nickel |