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 (
    34271, 34272, 34273, 955, 953, 952, 951
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00041

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "16.81"
    },
    "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": 7,
      "rows_produced_per_join": 7,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (34271,34272,34273,955,953,952,951)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "15.41",
        "eval_cost": "1.40",
        "prefix_cost": "16.81",
        "data_read_per_join": "26K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
951 <ul><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Brand:</span> <span class="offer-product-attrValue ng-binding">Dove</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Form Product:</span> <span class="offer-product-attrValue ng-binding">Stick</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Type:</span> <span class="offer-product-attrValue ng-binding">Deodorant</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Size:</span> <span class="offer-product-attrValue ng-binding">40 ml</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Targeted Group:</span> <span class="offer-product-attrValue ng-binding">Women</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Scent:</span> <span class="offer-product-attrValue ng-binding">Fresh</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Sensitive Skin:</span> <span class="offer-product-attrValue ng-binding">Yes</span></li> </ul>
952 <ul><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Brand:</span> <span class="offer-product-attrValue ng-binding">Dove</span></li><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Manufacturer Number:</span> <span class="offer-product-attrValue ng-binding">67075218</span></li><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Form Product:</span> <span class="offer-product-attrValue ng-binding">Stick</span></li><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Type:</span> <span class="offer-product-attrValue ng-binding">Antiperspirant</span></li><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Size:</span> <span class="offer-product-attrValue ng-binding">40 gm</span></li><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Targeted Group:</span> <span class="offer-product-attrValue ng-binding">Unisex</span></li><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Scent:</span> <span class="offer-product-attrValue ng-binding">Unscented</span></li><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Expirable:</span> <span class="offer-product-attrValue ng-binding">Yes</span></li></ul>
953 <ul><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Brand:</span> <span class="offer-product-attrValue ng-binding">Dove</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Form Product:</span> <span class="offer-product-attrValue ng-binding">Stick</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Type:</span> <span class="offer-product-attrValue ng-binding">Antiperspirant</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Size:</span> <span class="offer-product-attrValue ng-binding">40 g</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Targeted Group:</span> <span class="offer-product-attrValue ng-binding">Women</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Scent:</span> <span class="offer-product-attrValue ng-binding">Original</span></li> </ul>
955 <ul><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Brand:</span> <span class="offer-product-attrValue ng-binding">Dove</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Form Product:</span> <span class="offer-product-attrValue ng-binding">Stick</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Type:</span> <span class="offer-product-attrValue ng-binding">Anti-perspirant & Anti-transpirant</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Size:</span> <span class="offer-product-attrValue ng-binding">40 gm</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Targeted Group:</span> <span class="offer-product-attrValue ng-binding">Women</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Scent:</span> <span class="offer-product-attrValue ng-binding">warm powder</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Expirable:</span> <span class="offer-product-attrValue ng-binding">Yes</span></li> </ul>
34271 <p>Dr. mist all natural deodorant spray is a unique and effective anti-bacterial product that is free of toxic chemicals, aluminum, alcohol, oils, and synthetic fragrances. It sprays on easily, dried quickly, leaves no sticky or noticeable residue, and it's suitable for sensitive skin. It's a multi-purpose antibacterial that can be used to deodorize any part of the body or to help wounds and acne sores heal.</p>
34272 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Proven to leave no white marks on 100 colours</span></li> <li><span class="a-list-item">No stain deodorant & dry deodorant</span></li> <li><span class="a-list-item">Alcohol free deodorant to help reduce irritation to the skin</span></li> <li><span class="a-list-item">Provides up to 48-hour protection</span></li> <li><span class="a-list-item">Contains 1/4 moisturising cream for beautifully soft and smooth underarms</span></li> </ul>
34273 <ul class="a-unordered-list a-vertical a-spacing-none"><li>Antiperspirant deodorant that provides light yet complete coverage</li> <li>Sweat and odour control up to 48 hours</li> <li>Stay dry and fresh throughout the day</li> <li>Suitable for all skin types</li> <li>Brand: Dove</li> <li>Size: 40 ml</li> <li>Gender: Women</li> <li>Form Product: Stick</li> </ul>