SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    1831, 1839, 1830, 1838, 1833, 1837, 1846, 
    1217, 951, 471, 469, 483, 473, 474, 481, 
    479, 1190, 1193, 943, 1156, 944, 803, 
    1904, 1165
  ) 
  AND cscart_product_descriptions.lang_code = 'de'

Query time 0.00097

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "57.61"
    },
    "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": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "index_condition": "((`eshopuga_upgr_4122`.`cscart_product_descriptions`.`product_id` in (1831,1839,1830,1838,1833,1837,1846,1217,951,471,469,483,473,474,481,479,1190,1193,943,1156,944,803,1904,1165)) and (`eshopuga_upgr_4122`.`cscart_product_descriptions`.`lang_code` = 'de'))",
      "cost_info": {
        "read_cost": "52.81",
        "eval_cost": "4.80",
        "prefix_cost": "57.61",
        "data_read_per_join": "91K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "meta_keywords",
        "meta_description",
        "search_words",
        "promo_text"
      ]
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
469 <p><strong style="background-color: initial;">ABSOLUT VODKA Absolut 75cl</strong></p><p><strong></strong></p><p><strong>Absolut Vodka - </strong>Absolut Vodka was first launched in New York in 1979. It soon became the talk of the town, in the US and eventually of the world. But the recipe behind the pure and natural taste of Absolut is actually older than 30 years. So is the 18th century medicine flask found in an antique store in Stockholm that gave inspiration to the iconic Absolut Vodka bottle.</p><p><strong>Key Features</strong></p><ul> <li>Alcohol Content: 40%</li><li>Country Produced: Sweden</li><li>Main Ingredients: Water and Winter Wheat</li></ul>
471 <p><strong style="background-color: initial;">Absolut Raspberri - </strong>Since wild raspberries are often found in the Swedish hillsides, nothing could be more natural than introducing Absolut Raspberri. And so it was, in 2004, 25 years after the introduction of Absolut Vodka.</p><p><strong>Key Features</strong></p><ul> <li>Alcohol Content: 40%</li><li>Country Produced: Sweden</li><li>Main Ingredients: Absolut Vodka and raspberry flavor</li></ul>
473 <p><strong>ABSOLUT VODKA Kurant - 100cl</strong></p><p><strong>Absolut Kurant - </strong>The story behind the name Absolut Kurant is black currant, a typical Swedish berry from which the flavor is taken. When launched in 1992 it was a tribute to the Swedish origin of Absolut Vodka. Originally it was even supposed to be called Absolut Vinbär since the Swedish word for black currant is vinbär. Only thing was that the English pronunciation would have been wine bar.</p><p><strong></strong><strong>Key Features</strong></p><ul> <li>Alcohol Content: 40%</li><li>Country Produced: Sweden</li><li>Main Ingredients: Absolut Vodka and black currant flavor</li></ul>
474 <p><strong></strong><strong>ABSOLUT VODKA Mango - 700ml</strong></p><p><strong style="background-color: initial;">Absolut Mango - </strong>Just as fellow flavor Absolut Pears, Absolut Mango was introduced in 2007. The flavor, quite obviously, is based on mango – a word that’s more or less the same world wide. That in combination with the juicy taste, might very well be the reason behind the instant world wide&nbsp;</p><p><strong style="background-color: initial;">Key Features</strong></p><ul> <li>Alcohol Content: 40%</li><li>Country Produced: Sweden</li><li>Main Ingredients: Absolut Vodka and mango flavor</li></ul>
479 <p><strong style="background-color: initial;">ABSOLUT VODKA Vanilla - 100 cl</strong></p><p><strong></strong></p><p><strong>Absolut Vanilia - </strong>Absolut Vanilia was introduced in 2003. Basically because vanilla is one of the most beloved flavors in the world. And it wasn’t long until that fact was reinforced through the instant success of Absolut Vanilia – it is almost equally popular as vanilla itself.</p><p><strong>Key Features</strong></p><ul> <li>Alcohol Content: 40%</li><li>Country Produced: Sweden</li><li>Main Ingredients: Absolut Vodka and vanilla flavor</li></ul>
481 <p><strong></strong><strong>ABSOLUT VODKA Ruby Red - 100cl</strong></p><p><strong>Absolut Ruby Red - </strong>Absolut Ruby Red was introduced in 2006, following the success of the other citrus flavors, Absolut Citron and Absolut Mandrin. The name Absolut Ruby Red is taken from a special kind of red grapefruit. And grapefruit is of course what it tastes like!</p><p><strong></strong><strong>Key Features</strong></p><ul> <li>Alcohol Content: 40%</li><li>Country Produced: Sweden</li><li>Main Ingredients: Absolut Vodka and grapefruit flavor</li></ul>
483 <p><strong style="background-color: initial;">ABSOLUT VODKA Citron - 75cl</strong></p><p><strong></strong></p><p><strong>Absolut Citron - </strong>Absolut Citron was good news for “vodka on the rocks with a twist of lemon” fans back in the 80’s (and there were lots of them). More specifically Absolut Citron was launched in 1988, nine years after Absolut Original and two years after the first flavored family member Absolut Peppar. The success was major among the twist-of-lemon-people, but it also became the main ingredient in the blockbuster drink “Cosmopolitan”.</p><p><strong>Key Features</strong></p><ul> <li>Alcohol Content: 40%</li><li>Country Produced: Sweden</li><li>Main Ingredients: Absolut Vodka and citrus (lemon) flavor</li></ul>
803 <p>Baileys The Original Irish Cream is an iconic blend of fresh Irish cream, selected spirits and Irish Whiskey. While there are a myriad of uses for the time honoured liqueur, Baileys is best served simply over ice where you can fully enjoy the subtlety and gentle flavours that have made it one of the world's favourite drinks</p>
943 <p>Amarula is a cream liqueur from South Africa. It is made with sugar, cream and the fruit of the African marula tree (Sclerocarya birrea).</p>
944 <p>Baileys is a delicious blend of quality whiskey and smooth Irish cream.</p>
951 <p><strong style="background-color: initial;">1 Litre Hennessy V.S. Cognac<br></strong>J &amp; B Scotch Whiskey is naturally lighter and differs from other Scotch whiskies with flavors of rich fruitiness, vanilla, and reserved smokiness that make it great on the rocks, with soda, or mixed in your favorite cocktail.</p>
1156 <p>It is classic Bacardi rum, the soul of the Bacardi brand - youthful, high-quality, sociable, sensual and passionate.</p>
1165 <p>Founded by Alexandre Bisquit in 1819, the house of Bisquit, with its home at the Château de Lignères by the banks of the Charente River, had a long-standing family tradition until the house was sold to Pernod Ricard in 1966.</p>
1190 <p>AC Black Whiskey that is a superior combination of selected Indian spirits and imported scotch malts.</p>
1193 <p>AC Black Whiskey that is a superior combination of selected Indian spirits and imported scotch malts.</p>
1217 <p>Bushmills Original Irish Whiskey is the cornerstone of the Bushmills family. It is triple distilled and has a rich warming taste of fresh fruit and vanilla. Some times called Bushmills red or white,it is a blend of 6-7 year old malt from Bushmills with 4-5 year old grain from Midleton.</p>
1830 <p>(750ml x 12 bottles) Captain Morgan spiced gold Rum carton</p>
1831 <p> (200ml x 48 bottles) Gilbey's Gin carton</p>
1833 <p> (750ml x 12 bottles) Gilbey's Gin carton</p>
1837 <p>(750ml x 12 bottles) J&amp;B Rare scotch whiskey carton</p>
1838 <p>(750ml x 12 bottles) Johnnie walker red label carton</p>
1839 <p>(375ml x 24 bottles) Johnnie walker red label carton</p>
1846 <p>(750ml x 12 bottles) VAT 69 Scotch whiskey </p>
1904 <p>Ballantines Finest Blended Scotch Whisky 750ml</p>