Sandbox

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 (
    32228, 31940, 32110, 31943, 31941, 31945
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00176

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_descriptions",
          "access_type": "range",
          "possible_keys": ["PRIMARY", "product_id"],
          "key": "PRIMARY",
          "key_length": "11",
          "used_key_parts": ["product_id", "lang_code"],
          "rows": 6,
          "filtered": 100,
          "index_condition": "cscart_product_descriptions.product_id in (32228,31940,32110,31943,31941,31945) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id	short_description	full_description
31940		<p>Vitobee keeps bees at robusta coffee farms in the Central Highland area. The farms are ensured to be cared for in a clean environment using natural farming methods. Therefore, honey is safe for health because of its high purity. In addition, it is only harvested when fully caped to achieve a more condensed texture and stronger sweetness. Add this to drinks or use it as an ingredient for savory dishes or baking goods.</p>
31941		<p>The multifloral honey at Vitobe is harvested when the honey is fully ripe. The source of this honey is from a variety of flowers in the North and Central Highlands regions of Vietnam. Natural multifloral honey has a sweet taste and smooth texture. It is processed to be free from impurities. In addition, no preservatives or additional flavorings are added. Every morning, drinking a glass of water mixed with honey is both good for your health and helps you have more energy for the new day.</p>
31943		<p>With the combination of honey, nanocurcumin and royal jelly worker bees, Vitobe has brought a wonderful Vietnamese folk remedy to help prevent and cure diseases related to the stomach and intestines. In addition, curcumin, a compound often seen in turmeric, also has the effect of preventing cancer. The product has a yellow color and sweet taste, and is easy to consume. You can consume it directly or spread some on bread or sprinkle on ice-cream, waffles, etc.</p>
31945		<p>Notoginseng honey is combined between robusta honey and notoginseng root powder. The product can help prevent cancer risk and stroke risks, as well as promote blood circulation. However, despite its great content of nutrients that is good for your health, there are a few notes that you need to read carefully before using this honey.</p>
32110		<p>Melaleuca honey is obtained from the flowers of melaleuca trees in the Central Highlands and Northern regions of Vietnam. Only when the honey is fully ripe, it is harvested and processed into a quality and free-of-impurity jar. It is clean and sweet in taste, has a dark yellow color, and can be used as a cooking ingredient.</p>
32228		<p>Six-year-old slices of ginseng are soaked in robusta honey, then undergone rigorous production and testing. Ginseng has anti-aging effects, prevents cancer, and can nourish the body with its packed content of nutrients. You can directly use a slice of ginseng with honey every morning, bringing good health to the body.</p>