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 (
    262226, 262225, 262224, 262227, 269827, 
    262223, 309437, 270028, 269816, 269815, 
    269817, 269818, 269814, 269830, 435278, 
    435279, 269820, 269833, 269822, 269832, 
    269819, 269821
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00098

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "30.85"
    },
    "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": 22,
      "rows_produced_per_join": 22,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "26.45",
        "eval_cost": "4.40",
        "prefix_cost": "30.85",
        "data_read_per_join": "150K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (262226,262225,262224,262227,269827,262223,309437,270028,269816,269815,269817,269818,269814,269830,435278,435279,269820,269833,269822,269832,269819,269821)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
262223 <p></p> <p>The most charismatic red variety of the Greek vineyard, highlights a perfectly balanced wine. It can be aged and accompanies excellent red meats, rich sauces and salads. Enjoy it at 16 degrees Celsius. </p>
262224 <p></p> <p>Protected geographical indication Peloponnese. Rich in aromas of flowers and fresh fruit. A demanding and at the same time large in the character and taste of wine. Served at 10-12 degrees Celsius and accompanies excellent white meats, pasta, cheeses and fruits. </p>
262225 <p></p> <p>Mild and rose flavor, with a mild aromatic bouquet of red fruits. Served at 12 degrees Celsius, coexists harmoniously with fish, spaghetti with seafood, white meats and light cheeses. </p>
262226 <p></p> <p>Moschofilero meets Chardonnay and they offer us an abundant wine with aromas of citrus and fresh flowers. Ideal to accompany seafood, pasta, white meat, salads and fruits. Served at 10 - 12 degrees Celsius </p>
262227 <p></p> <p>The deep red color, the intense aroma of the forest and the soft  taste are dominant elements of the MERLOT variety in the Peloponnese. An explosive bouquet of red fruits, wild flowers and spices that will flavour your taste! Ideal to accompany red meats, spicy cheese, asiatic kitchen and rich sauces. Served at 16 degrees Celsius. </p>
269814 <h2 class="text-center"><span style="color:rgb(149,55,52);">Because a great story never started with someone eating a salad. </span></h2>
269815 <h2 class="text-center"><span style="color:rgb(149,55,52);">Life is relativ, vodka is absolut.</span></h2>
269816 <h2 class="text-center"><span style="color:rgb(149,55,52);">When life gives you LEMONS, it’s time to open the GIN.</span></h2> <p></p>
269817 <h2 class="text-center"><span style="color:rgb(149,55,52);">People who wonder whether thw glass is half empty or half full are missing the point. The glass is REFILLABLE</span></h2>
269818 <h2 class="text-center"><span style="color:rgb(149,55,52);">First you take a drink, then the drink takes a drink, then the drink takes you.</span> </h2> <p></p>
269819 <h2 class="text-center"><span style="color:rgb(149,55,52);">Save water drink beer! </span></h2>
269820 <h2 class="text-center"><span style="color:rgb(149,55,52);"><strong>Start the day with a smile and finish it with a glass of wine!!!</strong></span><span></span> </h2>
269821 <h2 class="text-center"><span style="color:rgb(149,55,52);">May all your days be filled with umbrella drinks.</span></h2>
269822 <h2 class="text-center"><span style="color:rgb(149,55,52);">Life begins after coffee.</span></h2>
269827 <p></p> <p>Anima means soul. Anima Cabernet Sauvignon is fleshy, deep purple, with soft tannins, rich in aromas of spices, ripe red fruits, vanilla and a velvety taste that leaves a distinct long aftertaste in the mouth. Thick, complete, complete, addressed to selected palates.</p> <p>Let it breathe and enjoy it at room temperature, at 16 - 18o C. It goes well with red meat, game, and strong red sauces.</p> <p>Anima means soul. Anima Cabernet Sauvignon is the flagship of Greek red wines. Fleshy, deep purple, with soft tannins, rich in aromas of spices, ripe red fruits, vanilla and a velvety taste that leaves a distinct long aftertaste in the mouth. Thick, complete, complete, addressed to selected palates.</p> <p>Cabernet Sauvignon is the finest variety in the world. What you may not have known is that the microclimate on the slopes of western Messinia overlooking the Ionian Sea, at an altitude of between 500 and 600 meters, gives the top Cabernet Sauvignon in the world! That is why the Anima Cabernet Sauvignon of Oinomessinia has conquered the top wineries and restaurants in Paris, New York, Moscow, Berlin and the cosmopolitan Shanghai. .</p> <p>Anima Cabernet Sauvignon is aged in oak barrels for years (and not in barrels for a few months, like many so-called "aged" wines). Try it and you will understand the difference!</p> <p>Award-winning wine, which has won, among others, the Gold Medal of the Bucharest International Competition "Concours International de Vinuri", the Gold Medal of the Thessaloniki International Competition, the Silver Medal of the German "Mundus Vini" International Competition and the Silver W Medal of the Greek W - OINOTHIKI.</p>
269830 <h2 class="text-center"><span style="color:rgb(149,55,52);">Tequila is cheaper than therapy.</span></h2>
269832 <h2 class="text-center"><span style="color:rgb(149,55,52);">Unleash the beast.</span></h2>
269833 <h2 class="text-center"><span style="color:rgb(149,55,52);">I'm not special I'm limited edition</span></h2>
270028 <h2 class="text-center"><span style="color:rgb(149,55,52);">Whisky doesn’t ask silly questions. Whisky understand.</span></h2>
309437 <p>Malagouzia - a native Greek variety - is found in the vineyards of Peloponnese,</p><p>produces a vivid wine with extraordinary aromas of citrus fruits and mature peach. </p><p>It's pleasant acidity and intense aftertaste will deceive your flavour!</p><p>Served chilled and pairs well with sea food, white meat, pasta, cheese and fruits.</p><p>Protected Geographical Indication Peloponnese </p> <p>Contains 11.5% alcohol</p> <p><br /></p>
435278 <p>Agiorgitiko meets Cabernet Sauvignon  and they offer us a well balanced wine, with soft and velvet taste and a pallet of dried forest fruit aromas. </p> <p>Pairs great with red meat and cooked dishes.   </p> <p>alc.13,5% vol<br /></p> <p>Served at 10-12 degrees Celsius<br /></p>
435279 <p>The Pink version of Agiorgitiko and Merlot vines, produce a fruity, well balanced wine.</p> <p>Served chilled,is perfect with seafood, pasta, light salads, cheese and fruits.                                                                                       </p> <p>Peloponnese </p> <p>alc.12.5% vol<br /></p>