{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "72.01"
},
"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": 30,
"rows_produced_per_join": 30,
"filtered": "100.00",
"index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (648,649,650,651,652,635,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
"cost_info": {
"read_cost": "66.01",
"eval_cost": "6.00",
"prefix_cost": "72.01",
"data_read_per_join": "114K"
},
"used_columns": [
"product_id",
"lang_code",
"short_description",
"full_description"
]
}
}
}| product_id | short_description | full_description |
|---|---|---|
| 587 | ||
| 588 | <p>French tennis player Rene Lacoste created his first polo shirt in 1927. Its code is L.12.12. ("L" stands for Lacoste, the number 1 symbolizes the "Petit Piqué material used, 2 represents short sleeves and 12 is the number of prototypes made before the final product). Lacoste launches three new masculine fragrances inspired by their polo shirts. Three perfumes match three colors of the polos: white, blue and green. Three new men's fragrances L.12.12. White, L.12.12. Blue and L.12.12. Green, in addition to a common sporting note, each possesses a different olfactory character. White represents simplicity, elegance and freshness, blue symbolizes intensity, aquatic life and manhood, and green stands for nature and good vibrations. L.12.12. White is a pure classic floral woody fragrance. Top notes are grapefruit, cardamom, rosemary and cedar leaf, mixed with the core of Mexican tuberose and ylang-ylang. Sensual notes of leather, suede and cedar form the base.</p> | |
| 589 | ||
| 590 | ||
| 591 | ||
| 592 | ||
| 593 | <p>Eau de Lacoste L.12.12 Pour Elle Eau Fraîche is a floral-aquatic fragrance that blends flowers of magnolia, lily of the valley and jasmine with a woody base of Indonesian patchouli. Top notes: yellow mandarin, grapefruit, pink pepper Heart: aquatic notes, magnolia, Egyptian jasmine absolute Base: Indonesian patchouli </p> | |
| 594 | ||
| 595 | ||
| 596 | ||
| 597 | ||
| 598 | ||
| 599 | ||
| 600 | ||
| 601 | ||
| 602 | ||
| 603 | ||
| 604 | ||
| 605 | ||
| 606 | ||
| 607 | ||
| 608 | ||
| 609 | ||
| 610 | ||
| 635 | ||
| 648 | ||
| 649 | ||
| 650 | ||
| 651 | ||
| 652 |