SELECT 
  q_product_descriptions.product_id, 
  q_product_descriptions.short_description, 
  IF(
    q_product_descriptions.short_description = '', 
    q_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  q_product_descriptions 
WHERE 
  q_product_descriptions.product_id IN (
    314, 315, 316, 317, 318, 319, 320, 321, 
    322, 323, 324, 325, 326, 327, 328, 329
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00135

JSON explain

{
  "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 (314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329)) 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"
      ]
    }
  }
}

Result

product_id short_description full_description
314 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">This CK Free Calvin Klein perfume has an ideal start with the notes of jackfruit, juniper berries, star anise, and wormwood</span></li><li><span class="a-list-item">The middle notes of this CK Free perfume comprise agathosma, tobacco, coffee, and suede</span></li><li><span class="a-list-item">The ending notes of this CK Free Calvin Klein perfume include the woody notes, patchouli, Virginia cedar, and oak</span></li><li><span class="a-list-item">Eau de Toilette</span></li></ul>
315 <p>CK IN2U for Him by Calvin Klein is a Aromatic Fougere fragrance for men. CK IN2U for Him was launched in 2007. CK IN2U for Him was created by Carlos Benaim, Bruno Jovanovic, Loc Dong and Jean-Marc Chaillan. Top notes are lemon and tomato leaf; middle notes are and cacao pod; base notes are vetiver, cedar and white musk.</p>
316 <p>Calvin Klein launched a new duo CK IN2U, his first duo instead of unisex fragrances. This trendy pair is intended for young generation, that Calvin Klein cristened as "techno-sexual generation". CK IN2U expresses freedom and possibilities of young people to explore the wolrd. The young and sexy juice is in the urban bottle, simple and attractive in its minimalist design. With CK IN2U Calvin Klein demonstrates that he still knows what young people need.</p>
317 <p>Calvin Klein launched a new duo CK IN2U, his first duo instead of unisex fragrances. This trendy pair is intended for young generation, that Calvin Klein cristened as "techno-sexual generation". CK IN2U expresses freedom and possibilities of young people to explore the wolrd. The young and sexy juice is in the urban bottle, simple and attractive in its minimalist design. With CK IN2U Calvin Klein demonstrates that he still knows what young people need.</p>
318 <p>At the heart of OBSESSED is the memory of a past love, triggered by the scent of another on the skin. Here, the genders are subverted and layered, with the traditional scents of the masculine Fougèreparticularly White lavenderharnessed for the womens fragrance, while the mens scent is in thrall to a dark Vanilla.</p>
319 <p>A fresh citrus explosion at the top notes (tangerine, grapefruit, lime and bergamot) is harmonized with a floral sharpness of lavender, nut, spiced notes of coriander and warm cinnamon. Carnation (along with jasmine, rose tree and pine) is restrained with warm patchouli, sandalwood, vetiver, benzoin, vanilla and amber. Subtle aroma of red berries enforces the structure, adding sensuousness and characteristic to the perfume. The creator of this fragrance is Bob Slattery, and the bottle designer is Pierre Dinand. Obsession for Men was launched in 1986, a year after the female version. This fragrance pair belongs to one of the most popular ones in the 80s</p>
320 <p>Obsession Night for Men by Calvin Klein is a Oriental Woody fragrance for men. Obsession Night for Men was launched in 2005. Top notes are artemisia, grapefruit, pear and cardamom; middle notes are nutmeg and musk; base notes are patchouli, vanilla and vetiver.</p>
321 <p>Obsession Night is a new creation evoking the delicious thrills of the hot, summer night; juicy citruses dewed by the gentle rain shine under the moonlight and the darkness of the garden is scented by night-flowering. Main notes are: bergamot, orange, mandarine, white flowers, gardenia, rose, lily-of-the-valley, jasmine, vanilla, tonka bean, labdanum, amber, and sandalwood. It was created in 2005.</p>
322 <p>CK One by Calvin Klein is a Citrus Aromatic fragrance for women and men. CK One was launched in 1994. CK One was created by Alberto Morillas and Harry Fremont. Top notes are pineapple, green notes, mandarin orange, papaya, bergamot, cardamom and lemon; middle notes are nutmeg, violet, orris root, jasmine, lily-of-the-valley, rose and freesia; base notes are sandalwood, amber, musk, cedar, oakmoss, green tea and green accord.</p>
323 <p>One of the most successful fragrances from Calvin Klein is CK One, the citrus unisex fragrance from 1994. CK One Shock is a surprise for all the fans of CK One line. It is not an unisex edition, but two separate oriental compositions: CK One Shock For Her and CK One Shock For Him. CK One Shock For Him is built around aromatic, spicy and deep oriental nuances. It opens with citrusy clementine, fresh cucumber and energy drink accord. The heart of black pepper, black basil and cardamom is placed on the base of masculine tobacco, musk, patchouli and ambrene wood.</p>
324 <p>ne of the most successful fragrances from Calvin Klein is CK One, the citrus unisex fragrance from 1994. CK One Shock is a surprise for all the fans of CK One line. It is not an unisex edition, but two separate oriental compositions: CK One Shock For Her and CK One Shock For Him.</p>
325 <ul><li>CK One Shock For Her is an opulent oriental - floral fragrance with top notes of passion flower, pink peony and poppy. </li><li>Its heart is made of feminine jasmine, narcissus, blackberry and dark cocoa.</li><li> The base consists of amber, vanilla, musk and patchouli.</li></ul>
326
327
328
329