{
"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 (393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,263)) 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 |
---|---|---|
263 | ||
393 | ||
394 | ||
395 | ||
396 | ||
397 | ||
398 | ||
399 | ||
400 | ||
401 | ||
402 | ||
403 | ||
404 | <ul><li>Carolina Herrera Ch Good Girl Legere Edp</li><li> - 80ml+100ml Bl Set</li></ul> | |
405 | <ul><li>Carolina Herrera Ch Good Girl Legere Edp </li><li>- Ns 80ml+100ml Bl Set</li></ul> | |
406 | <p>Carolina Herrera Good Girl Edp - 80ml+100ml Bl+10ml Mini Set</p> | |
407 | <ul><li>Carolina Herrera Vip For Men Edt </li><li>- 100ml+100ml Sg Travel Set</li></ul> | |
408 | ||
409 | ||
410 | ||
411 | ||
412 | ||
413 | ||
414 | ||
415 | ||
416 | ||
417 | ||
418 | ||
419 | <ul><li>Provides effective protection against wetness & odor.Incredibly helps glides on smoothly & comfortably.</li><li>Ensures a natural long-lasting skincare treatment.</li><li>Lightweight formula offers quick-dry formula.</li><li>Suitable for all skin types</li></ul> | |
420 | ||
421 | <ul><li>Exotic floral-fruity fragrance Euphoria was launched in 2005. The fragrance is luminous and luscious like fruits notes of which are captured in it. Euphoria is mysterious and appealing like dark exotic flowers. It invites you to enjoy in joys of life. The main notes are rose hip, Japanese apple, green leaves, Lotus, black orchid, red woods, black violet and amber.</li></ul> |