{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "38.41"
},
"table": {
"table_name": "q_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": 16,
"rows_produced_per_join": 16,
"filtered": "100.00",
"index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (38156,38157,38158,38159,38160,38161,38162,38163,38164,38165,38166,38167,38168,38169,38171,38172)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
"cost_info": {
"read_cost": "35.21",
"eval_cost": "3.20",
"prefix_cost": "38.41",
"data_read_per_join": "61K"
},
"used_columns": [
"product_id",
"lang_code",
"short_description",
"full_description"
]
}
}
}| product_id | short_description | full_description |
|---|---|---|
| 38156 | <ul><li>L'Artisan Perfumeur Explosions D'Emotions Rappelle (W) Edp 1.5Ml Vails</li> <li> <p>This is an Eau de Parfum with an expansive and extroverted personality, where a generous floral peony note meets with the unexpected fruitiness of pomegranate.</p> </li> <li> <p>Top:Fruity and metallic note of pomegranate and black pepper;</p> </li> <li> <p>Sample</p> </li> <li> <p>Travel Size</p> </li> </ul> | |
| 38157 | ||
| 38158 | <ul><li>L'Artisan Perfumeur Onde Sensuelle (W) Edp 1.5Ml Vails</li> <li class="showHiddenFeatureBullets"><span class="a-list-item">The addition of a dash of sweet and spicy cinnamon will put a smile on your face and a spring in your step</span></li> <li class="showHiddenFeatureBullets"><span class="a-list-item">Sample</span></li> <li class="showHiddenFeatureBullets"><span class="a-list-item">Travel Size</span></li> </ul> | |
| 38159 | <ul><li>L'Artisan Perfumeur Skin On Skin (W) Edp 1.5Ml Vails</li> </ul> | |
| 38160 | ||
| 38161 | ||
| 38162 | ||
| 38163 | ||
| 38164 | ||
| 38165 | ||
| 38166 | ||
| 38167 | ||
| 38168 | ||
| 38169 | ||
| 38171 | ||
| 38172 |