{
"query_block": {
"select_id": 1,
"cost": 0.01817902,
"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": 10,
"cost": 0.01817902,
"filtered": 100,
"attached_condition": "cscart_product_descriptions.product_id in (18508,18520,18481,19942,19936,19937,19938,19939,19940,19941) and cscart_product_descriptions.lang_code = 'en'"
}
}
]
}
}
| product_id | short_description | full_description | unit_name |
|---|---|---|---|
| 18481 | <p>test</p> | ||
| 18508 | <p>Ideal for cold-weather training or work outdoors, the Chaz Hoodie promises superior warmth with every wear. Thick material blocks out the wind as ribbed cuffs and bottom band seal in body heat.</p> <p>• Two-tone gray heather hoodie.<br />• Drawstring-adjustable hood. <br />• Machine wash/dry.</p> | ||
| 18520 | <p>Ideal for cold-weather training or work outdoors, the Chaz Hoodie promises superior warmth with every wear. Thick material blocks out the wind as ribbed cuffs and bottom band seal in body heat.</p> <p>• Two-tone gray heather hoodie.<br />• Drawstring-adjustable hood. <br />• Machine wash/dry.</p> | ||
| 19936 | <p>test</p> | ||
| 19937 | <p>test</p> | ||
| 19938 | <p>test</p> | ||
| 19939 | <p>test</p> | ||
| 19940 | <p>test</p> | ||
| 19941 | <p>test</p> | ||
| 19942 | <p>this is test</p> |