{
"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 (92075,92076,92077,92078,92079,92080,92081,92131,92132,92133,92134,92135,92136,92137,84026,84027,84028,84029,85580,89486,89014,84018,84019,84020,84021,92019,92020,92021,92022,92023)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
}
}
}
| product_id | short_description | full_description |
|---|---|---|
| 84018 | Old London Black Topaz With Lever Handle Bidet Tap - Chrome | |
| 84019 | Old London Black Topaz With Crosshead Handle Bidet Tap - Chrome | |
| 84020 | Old London Black Topaz With Lever Handle Bidet Tap - Chrome | |
| 84021 | Old London Black Topaz With Crosshead Handle Bidet Tap - Chrome | |
| 84026 | Old London Black Topaz With Lever Handle Wall-Mounted Bath Spout - Chrome / Black | |
| 84027 | Old London Black Topaz With Crosshead Handle Bath Spout - Chrome / Black | |
| 84028 | Old London Black Topaz With Lever Handle Bath Spout - Chrome / Black | |
| 84029 | Old London Black Topaz With Crosshead Handle Bath Spout - Chrome / Black | |
| 85580 | Roll Top Bath Pack | |
| 89014 | Hudson Reed Tec Single Lever High Rise Mixer - Brushed Brass | |
| 89486 | Hudson Reed Soar Bath Shower Mixer - Chrome | |
| 92019 | BC Designs Victrion Deck Mounted Crosshead Mono Basin Mixer Tap - Brushed Chrome | |
| 92020 | BC Designs Victrion Deck Mounted Crosshead Mono Basin Mixer Tap - Brushed Copper | |
| 92021 | BC Designs Victrion Deck Mounted Crosshead Mono Basin Mixer Tap - Brushed Gold | |
| 92022 | BC Designs Victrion Deck Mounted Crosshead Mono Basin Mixer Tap - Brushed Nickel | |
| 92023 | BC Designs Victrion Deck Mounted Crosshead Mono Basin Mixer Tap - Copper | |
| 92075 | BC Designs Victrion Wall Mount Lever 3 Tap Hole Basin Filler Tap - Brushed Chrome | |
| 92076 | BC Designs Victrion Wall Mount Lever 3 Tap Hole Basin Filler Tap - Brushed Copper | |
| 92077 | BC Designs Victrion Wall Mount Lever 3 Tap Hole Basin Filler Tap - Brushed Gold | |
| 92078 | BC Designs Victrion Wall Mount Lever 3 Tap Hole Basin Filler Tap - Brushed Nickel | |
| 92079 | BC Designs Victrion Wall Mount Lever 3 Tap Hole Basin Filler Tap - Copper | |
| 92080 | BC Designs Victrion Wall Mount Lever 3 Tap Hole Basin Filler Tap - Gold | |
| 92081 | BC Designs Victrion Wall Mount Lever 3 Tap Hole Basin Filler Tap - Nickel | |
| 92131 | BC Designs Victrion Deck Mounted Lever 3 Tap Hole Basin Mixer Tap - Brushed Chrome | |
| 92132 | BC Designs Victrion Deck Mounted Lever 3 Tap Hole Basin Mixer Tap - Brushed Copper | |
| 92133 | BC Designs Victrion Deck Mounted Lever 3 Tap Hole Basin Mixer Tap - Brushed Gold | |
| 92134 | BC Designs Victrion Deck Mounted Lever 3 Tap Hole Basin Mixer Tap - Brushed Nickel | |
| 92135 | BC Designs Victrion Deck Mounted Lever 3 Tap Hole Basin Mixer Tap - Copper | |
| 92136 | BC Designs Victrion Deck Mounted Lever 3 Tap Hole Basin Mixer Tap - Gold | |
| 92137 | BC Designs Victrion Deck Mounted Lever 3 Tap Hole Basin Mixer Tap - Nickel |