{
"query_block": {
"select_id": 1,
"cost": 0.0216566,
"nested_loop": [
{
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "range",
"possible_keys": ["PRIMARY", "product_id"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["product_id", "lang_code"],
"loops": 1,
"rows": 12,
"cost": 0.0216566,
"filtered": 100,
"attached_condition": "cscart_product_descriptions.product_id in (1335,1338,1233,1324,1323,1081,1326,1325,1333,1082,1321,1330) and cscart_product_descriptions.lang_code = 'en'"
}
}
]
}
}
| product_id | short_description | full_description | unit_name |
|---|---|---|---|
| 1081 | Commercial Max/Oval Steel Accessory 100mm Conduit PVC Pipe only 4.2M Long | ||
| 1082 | Commercial Max/Oval Steel Accessory 150mm Conduit PVC Pipe Only 4.2M Long | ||
| 1233 | <p>Commercial Max/Oval Steel Accessory</p> | ||
| 1321 | <p>Commercial Max/Oval Steel Accessory Beacon Plate</p> | ||
| 1323 | <p>Commercial Max/Oval Steel Accessory 100mm conduit carrier with caps and 3 brackets</p> | ||
| 1324 | <p>Commercial Max/Oval Steel Accessory 100mm conduit carrier caps and 3 brackets, NO PIPE</p> | ||
| 1325 | Commercial Max/Oval Steel Accessory 150mm conduit carrier with caps and 3 brackets | ||
| 1326 | Commercial Max/Oval Steel Accessory 150mm conduit carrier caps and 3 brackets, NO PIPE | ||
| 1330 | <p>Commercial Max/Oval Steel Accessory Jack and shovel holder</p> | ||
| 1333 | Commercial Max/Oval Steel Accessory 150mm Conduit end cap | ||
| 1335 | <p>Commercial Max Double roller bracket and rollers</p> | ||
| 1338 | Commercial Max Single roller bracket and roller |