{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "10.82"
},
"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": 24,
"rows_produced_per_join": 24,
"filtered": "100.00",
"cost_info": {
"read_cost": "8.42",
"eval_cost": "2.40",
"prefix_cost": "10.82",
"data_read_per_join": "91K"
},
"used_columns": [
"product_id",
"lang_code",
"short_description",
"full_description"
],
"attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (90007,89766,89767,82864,82865,82937,82938,83010,83011,83446,83447,83451,83452,84802,84803,91082,82718,82719,83456,83457,89764,86470,86746,82862)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
}
}
}
| product_id | short_description | full_description |
|---|---|---|
| 82718 | nuie Arno 800mm Floor Standing 2-Drawer Vanity & Thin-Edge Basin - Gloss White | |
| 82719 | nuie Arno 800mm Floor Standing 2-Drawer Vanity & Curved Basin - Gloss White | |
| 82862 | nuie Arno 800mm Floor Standing 2-Drawer Vanity & Mid-Edge Basin - Solace Oak | |
| 82864 | nuie Arno 800mm Floor Standing 2-Drawer Vanity & Thin-Edge Basin - Solace Oak | |
| 82865 | nuie Arno 800mm Floor Standing 2-Drawer Vanity & Curved Basin - Solace Oak | |
| 82937 | nuie Arno 800mm Floor Standing 2-Drawer Vanity & Thin-Edge Basin - Anthracite | |
| 82938 | nuie Arno 800mm Floor Standing 2-Drawer Vanity & Curved Basin - Anthracite | |
| 83010 | nuie Arno 800mm Floor Standing 2-Drawer Vanity & Thin-Edge Basin - Charcoal Black | |
| 83011 | nuie Arno 800mm Floor Standing 2-Drawer Vanity & Curved Basin - Charcoal Black | |
| 83446 | nuie Athena Floor Standing 2 Drawer Vanity With Thin-Edge 1 Tap Hole Ceramic Basin 800mm - Anthracite Woodgrain | |
| 83447 | nuie Athena Floor Standing 2 Drawer Vanity With Curved 1 Tap Hole Ceramic Basin 800mm - Anthracite Woodgrain | |
| 83451 | nuie Athena Floor Standing 2 Drawer Vanity With Thin-Edge 1 Tap Hole Ceramic Basin 800mm - Hacienda Black | |
| 83452 | nuie Athena Floor Standing 2 Drawer Vanity With Curved 1 Tap Hole Ceramic Basin 800mm - Hacienda Black | |
| 83456 | nuie Athena Floor Standing 2 Drawer Vanity With Thin-Edge 1 Tap Hole Ceramic Basin 800mm - Gloss White | |
| 83457 | nuie Athena Floor Standing 2 Drawer Vanity With Curved 1 Tap Hole Ceramic Basin 800mm - Gloss White | |
| 84802 | nuie Classique Floor Standing 2 Door Vanity Basin Unit & 1 Tap Hole Fireclay Basin, 800mm - Satin White | |
| 84803 | nuie Classique Floor Standing 2 Door Vanity Basin Unit & 3 Tap Hole Fireclay Basin, 800mm - Satin White | |
| 86470 | Hudson Reed Juno 800mm Floor Standing 2-Door Vanity & Minimalist 1 Tap Hole Basin - Autumn Oak | |
| 86746 | Hudson Reed Juno Floor Standing 2 Door Vanity Basin Unit & Minimalist Ceramic Basin, 800mm - Metallic Slate | |
| 89764 | Hudson Reed Urban Floor Standing 2 Door 1 Drawer Vanity Unit with Mid-Edge Basin 800mm - Satin White | |
| 89766 | Hudson Reed Urban Floor Standing 2 Door Vanity Unit with Thin-Edge Basin 800mm - Satin White | |
| 89767 | Hudson Reed Urban Floor Standing 2 Door Vanity Unit with Curved Basin 800mm - Satin White | |
| 90007 | nuie Mayford Floor Standing 2 Door 3 Drawer Vanity Unit with Round Ceramic Basin 1050mm - Gloss White | |
| 91082 | nuie Classique Floor Standing 2 Door Unit & 0 Tap Hole Fireclay Basin, 800mm - Satin White |