SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    431687, 414514, 414393, 431514, 414329, 
    396078, 396044, 431552, 414335, 414429, 
    414468, 414459, 431698, 414360, 414401, 
    414415, 396052, 431754, 431743, 396074, 
    431776, 414488, 414323, 431570, 414326, 
    396065, 396013, 414322, 414375
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00141

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "40.66"
    },
    "table": {
      "table_name": "cscart_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": 29,
      "rows_produced_per_join": 29,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "34.86",
        "eval_cost": "5.80",
        "prefix_cost": "40.66",
        "data_read_per_join": "198K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (431687,414514,414393,431514,414329,396078,396044,431552,414335,414429,414468,414459,431698,414360,414401,414415,396052,431754,431743,396074,431776,414488,414323,431570,414326,396065,396013,414322,414375)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
396013 <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
396044 <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
396052 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
396065 <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
396074 <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
396078 <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414322 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414323 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414326 <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414329 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414335 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414360 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414375 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414393 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414401 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 16 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414415 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414429 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414459 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414468 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414488 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
414514 <p></p> <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
431514 <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style. </p>
431552 <p>Quality children's clothing, for every age group starting from newborn to 16 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style. </p>
431570 <p>Quality children's clothing, for every age group starting from newborn to 16 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style. </p>
431687 <p>Quality children's clothing, for every age group starting from newborn to 16 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style. </p>
431698 <p>Quality children's clothing, for every age group starting from newborn to 16 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style. </p>
431743 <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
431754 <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>
431776 <p>Quality children's clothing, for every age group starting from newborn to 13 years offered by Fashion Kids. Made with quality material, our products are the perfect choice to keep your children cool and comfortable without missing out on style.</p>