{
"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 (670,671,672,673,636,637,638,639,640,641,642,643,644,645,646,647)) 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 |
---|---|---|
636 | ||
637 | ||
638 | <p>Cool Water is fresh and sharp, simple and very masculine. Top notes include mint and green nuances, lavender, coriander and rosemary. The heart notes include geranium, neroli, jasmine and sandalwood. The base is composed of cedarwood, musk, amber and tobacco.</p> | |
639 | ||
640 | ||
641 | ||
642 | ||
643 | ||
644 | ||
645 | ||
646 | ||
647 | ||
670 | <ul><li>Trussardi Uomo</li><li> For Men</li><li> EDT 100ml+100ml Sg+Pouch (Soft Box) Set</li></ul> | |
671 | <ul><li>Trussardi Uomo</li><li> For Men </li><li>EDT 100ml+200ml Sg+100ml Deodorant Set</li></ul> | |
672 | <ul><li>Trussardi Uomo</li><li> For Men</li><li> Eau De Parfum</li><li>50ml+100ml Sg Travel Set</li></ul> | |
673 | <ul><li>Trussardi Uomo </li><li>The Red For Men</li><li> EDT 100ml+100ml Sg+50ml Beard Soap Set</li></ul> |