{
"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 (8695,8694,8693,8692,8251,8250,8249,8248,8247,8246,8245,8244,8243,8242,8241,8240)) 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 |
---|---|---|
8240 | <ul><li><span class="a-list-item">Fragrance Type: Eau de Parfum</span></li><li><span class="a-list-item">Fragrance Family: Floral</span></li><li>Blue Shadow Pour Homme By Khalis EDP For Men 100ML</li></ul> | |
8241 | English Blazer Original EDT 100ML+ Free Body Spray 150ML 2Pcs Gift Set For Men | |
8242 | English Blazer Copper EDT 100ML+ Body Spray 150ML 2Pcs Gift Set For Men | |
8243 | English Blazer Empire EDT 100ML+ Body Spray 150ML 2Pcs Gift Set For Men | |
8244 | English Blazer London EDT 100ML+ Free Deodorant Spray 150ML 2Pcs Gift Set For Men | |
8245 | English Blazer Victory EDT 100ML+ Deodorant Spray 150ML 2Pcs Gift Set For Men | |
8246 | English Blazer Timeless EDT 100ML+ Body Spray 150ML 2Pcs Gift Set For Men | |
8247 | English Blazer Commando Edt 100 Ml+ Body Spray 150 Ml 2 Pcs Gift Set for Men | |
8248 | English Blazer Sailor Edt 100 Ml+ Deodorant Spray 150 Ml 2 Pcs Gift Set for Men | |
8249 | English Blazer Black Edt 100 Ml+ Free Deodorant Spray 150 Ml 2 Pcs Gift Set for Men | |
8250 | English Blazer Gold Edt 100 Ml+ Deodorant Spray 150 Ml 2 Pcs Gift Set for Men | |
8251 | Tonino Lamborghini Intenso Edt Spray 100 Ml + Deodorant Spray 150 Ml 2 Pcs Gift Set for Men | |
8692 | <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Air Travel Approved Size.</span></li> <li><span class="a-list-item">A travel essential for both men and women.</span></li> <li><span class="a-list-item">Compact and portable, convenient to carry and storage.</span></li> <li><span class="a-list-item">It is very easy to use and can be refilled in seconds.</span></li> <li><span class="a-list-item">Perfect for storing some of your favourite.</span></li> </ul> | |
8693 | Victoria's Secret Love Spell Fragrance Mist For Women 250ML | |
8694 | Victoria's Secret Pure Seduction Fragrance Mist For Women 250ML | |
8695 | <ul><li>Victoria Secret</li> <li> Amber Romance Body Fragrance Mist 250ML</li> <li><span class="a-list-item">Victorias Secret Garden Amber Romance Body Mist</span></li> </ul> |