{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "4.81"
},
"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": 2,
"rows_produced_per_join": 2,
"filtered": "100.00",
"index_condition": "((`atulecarter_atul_demo5`.`cscart_product_descriptions`.`product_id` in (133,132)) and (`atulecarter_atul_demo5`.`cscart_product_descriptions`.`lang_code` = 'en'))",
"cost_info": {
"read_cost": "4.41",
"eval_cost": "0.40",
"prefix_cost": "4.81",
"data_read_per_join": "9K"
},
"used_columns": [
"product_id",
"lang_code",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"promo_text",
"unit_name"
]
}
}
}
| product_id | short_description | full_description | meta_keywords | meta_description | search_words | promo_text | unit_name |
|---|---|---|---|---|---|---|---|
| 132 | <p>Easily connect via Wi-Fi without any monthly service fees. The Samsung Galaxy Player can access the internet and apps anywhere there is an available hotspot. The sleek, lightweight 6.42 oz. design fits in any pocket and the brilliant 5” LCD delivers incredible viewing quality.</p> | <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p> | |||||
| 133 | <p>Easily connect via Wi-Fi without any monthly service fees. The Samsung Galaxy Player can access the internet and apps anywhere there is an available hotspot. The sleek, lightweight 4.27 oz. design fits in any pocket and the brilliant 4” Super Clear LCD delivers incredible viewing quality.</p> | <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p> |