{
"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 (294,295,296,297,298,299,300,301,302,303,304,305,306,307,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261)) 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 |
---|---|---|
246 | <p>Girl of Now by Elie Saab is a Oriental Floral fragrance for women. This is a new fragrance. Girl of Now was launched in 2017. Top notes are mandarin orange, pear and pistachio; middle notes are orange blossom, magnolia and almond; base notes are patchouli, cashmeran, tonka bean and almond milk. Girl of Now was created by Dominique Ropion and Sophie Labbe.</p> | |
247 | ||
248 | ||
249 | ||
250 | ||
251 | ||
252 | ||
253 | ||
254 | ||
255 | ||
256 | ||
257 | <p>The first fragrance from the Lebanese haute couture designer is simply called Le Parfum. After 279 trial versions, an ultra-feminine, flowery-woody composition has been selected, signed by perfumer Francis Kurkdjian. The perfume opens with notes of orange blossom. Jasmine is in the heart, including both Grandiflorum and Sambac, whereas the base consists of cedar, patchouli and rose honey accord. </p> | |
258 | <p>The first fragrance from the Lebanese haute couture designer is simply called Le Parfum. After 279 trial versions, an ultra-feminine, flowery-woody composition has been selected, signed by perfumer Francis Kurkdjian. The perfume opens with notes of orange blossom. Jasmine is in the heart, including both Grandiflorum and Sambac, whereas the base consists of cedar, patchouli and rose honey accord. </p> | |
259 | ||
260 | ||
261 | ||
294 | ||
295 | ||
296 | ||
297 | <p>Expression. individuality. warmth. close your eyes, open your mind, and live life with freedom. a unique tonic musk that is clean and fresh, without being over-powering. top notes: bergamot, juniper berry, mandarin, mint and lavender, mid notes: light spices, magnolia, white peach, end notes: opoponax, tonka bean.</p> | |
298 | ||
299 | ||
300 | ||
301 | ||
302 | ||
303 | ||
304 | ||
305 | ||
306 | ||
307 |