{
"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 (613,614,615,616,581,582,583,584,585,586,565,566,567,568,569,570)) 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 |
---|---|---|
565 | ||
566 | ||
567 | ||
568 | ||
569 | <ul><li>The composition is announced as a gourmand aphrodisiac and a love potion created by perfumers Christophe Raynaud and Amandine Marie.</li><li> It supposedly depicts the dark side of rose and mixes notes of black rose with Tahitian vanilla orchid absolute. </li><li>There are also accords of natural incense, papyrus, patchouli and litchi praline added to the mix. The faces of the campaign are Penélope Cruz and Ilay Kurelovi? and photo signed by Mert Alas and Marcus Piggott. Video campaign directed by Rob Marshall.</li></ul> | |
570 | ||
581 | <p>Polo Blue by Ralph Lauren is a Aromatic Fougere fragrance for men. Polo Blue was launched in 2003. Polo Blue was created by Carlos Benaim and Christophe Laudamiel. Top notes are melon, mandarin orange and cucumber; middle notes are basil, sage and geranium; base notes are musk, woodsy notes and suede.</p> | |
582 | ||
583 | ||
584 | ||
585 | ||
586 | ||
613 | ||
614 | ||
615 | ||
616 |