{
"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 (89284,89437,91289,84262,84266,90120,89157,89548,90092,90102,90111,89335,82329,86813,86847,89100,89293,91944,89199,82397,86850,89291,89370,83114,83124,83133,89262,89372,89728,89733)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
}
}
}
| product_id | short_description | full_description |
|---|---|---|
| 82329 | Hudson Reed Tec Pura Triple Thermostatic Shower Valve - Chrome | |
| 82397 | Hudson Reed Tec Pura Twin Thermostatic Shower Valve - Matt Black | |
| 83114 | nuie Arvan Triple Thermostatic Valve - Matt Black | |
| 83124 | nuie Arvan Triple Thermostatic Valve - Gunmetal | |
| 83133 | nuie Arvan Triple Thermostatic Valve - Brushed Brass | |
| 84262 | Old London Black Topaz Twin Concealed Shower Valve - Chrome / Black | |
| 84266 | Old London Black Topaz Twin Exposed Shower Valve - Chrome / Black | |
| 86813 | nuie Square Showers Triple Thermostatic Shower Valve - Chrome | |
| 86847 | Hudson Reed Tec Crosshead Triple Thermostatic Shower Valve - Chrome | |
| 86850 | Hudson Reed Tec Crosshead Twin Thermostatic Shower Valve - Matt Black | |
| 89100 | nuie Round Showers Triple Thermostatic Shower Valve - Chrome | |
| 89157 | Hudson Reed Indus Twin Thermostatic Shower Valve With Diverter - Chrome | |
| 89199 | nuie Sanford Triple Thermostatic Valve With Diverter - Chrome | |
| 89262 | nuie Thermostatic Concealed Twin Round Valve & Slide Rail Kit with Multi Function Handset & Outlet Elbow Shower Kit - Chrome | |
| 89284 | nuie 1 Outlet Bundle Arvan - Chrome | |
| 89291 | nuie Binsey Thermostatic Concealed Twin Round Valve, Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome | |
| 89293 | nuie Arvan Thermostatic Concealed Twin Round Valve, Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome | |
| 89335 | nuie Sanford Thermostatic Square Bath Shower Mixer & Single Function Slide Rail Shower Kit - Chrome | |
| 89370 | nuie Thermostatic Square Bar Valve & Single Function Slide Rail Shower Kit - Chrome | |
| 89372 | nuie Thermostatic Square Bar Valve & Single Function Slide Rail Shower Kit - Chrome | |
| 89437 | Hudson Reed Industrial Valves Twin Valve with Diverter - Chrome | |
| 89548 | Hudson Reed Lennox Twin Thermostatic Shower Valve With Diverter - Chrome | |
| 89728 | Old London White Topaz Twin Thermostatic Shower Valve - Chrome / White | |
| 89733 | Old London White Topaz Twin Thermostatic Shower Valve - Chrome / White | |
| 90092 | nuie Windon Triple Thermostatic Valve - Matt Black | |
| 90102 | nuie Windon Triple Thermostatic Valve - Gunmetal | |
| 90111 | nuie Windon Triple Thermostatic Valve - Brushed Brass | |
| 90120 | nuie Windon Triple Thermostatic Valve With Diverter - Chrome | |
| 91289 | nuie Aztec Triple Thermostatic Concealed Shower Valve - 2 Outlet - Matt Black | |
| 91944 | BC Designs Victrion Superbe Fixed Rigid Riser Kit with 8" Shower Head and Handset - Chrome |