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 (
    9967, 9968, 9972, 9973, 9974, 9975, 9976, 
    9977, 9978
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00043

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.61"
    },
    "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": 9,
      "rows_produced_per_join": 9,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (9967,9968,9972,9973,9974,9975,9976,9977,9978)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "19.81",
        "eval_cost": "1.80",
        "prefix_cost": "21.61",
        "data_read_per_join": "34K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
9967 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Genuine leather case for Apple Pencil</span></li> <li><span class="a-list-item">Magnetically attaches to most iPad cases</span></li> <li><span class="a-list-item">Helps transport and protect Apple Pencil with your iPad</span></li> <li><span class="a-list-item">Compatible with Apple Smart Cover, Apple Smart Keyboard and Twelve South Surface Pad for iPad Pro</span></li> </ul>
9968 <ul><li><span>A built-in typing/sketching angle protects your wrists for long sessions on iPad</span></li> <li><span>An incorporated display stand allows you to show your work anywhere</span></li> <li><span>Hardback covers, crush resistant spine and a soft interior lining keep iPad safe wherever you go</span></li> <li><span>iPad Pro and 2018 versions include Apple Pencil storage in the spine</span></li> </ul><p><span>BookBook for iPad is a gorgeous leather case designed to fit the family of iPads like a glove. Each BookBook is a handmade, one-of-a-kind, hardback leather case designed to protect and enhance your iPad experience.</span></p>
9972 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9973 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9974 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> <li>Easy to attach and hang to your car seat</li> <li>Have fun characters</li> <li>Can watch videos or play games comfortably</li> </ul>
9975 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9976 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9977 <ul><li>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9978 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>