SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (3430, 3474, 13314) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00047

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "2.11"
    },
    "table": {
      "table_name": "cscart_ult_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id",
        "company_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code",
        "company_id"
      ],
      "key_length": "13",
      "rows_examined_per_scan": 3,
      "rows_produced_per_join": 3,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_ult_product_descriptions`.`company_id` = 1) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`product_id` in (3430,3474,13314)) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "1.81",
        "eval_cost": "0.30",
        "prefix_cost": "2.11",
        "data_read_per_join": "11K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "company_id",
        "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
3430 einstufige Bauart, mit Sicherheitsmanometern nach ISO 5171, Eingangsdruck max: 40 bar<br />Ausgangsdruck: 0 – 20 bar regelbar<br />Leistung max: 90 Nm³/h Druckluft bei 20 bar Hinterdruck <br />Ein- und Ausgang: Klemmring Ms 12 mm<br />ohne Eingangsmanometer<br />Ausgangsmanometer: 0 – 40/20 bar senkrecht<br />Breite x Höhe x Tiefe: 220 x 200 x 75 mm <br />mit Typenschild auf Druckminderer, mit Werkszeugnis 2.2 Bedienungsanleitung, Etikett mit Lindenummer/öl- und fettfrei auf Folie und Karton
3474 <p>acc to ISO 2503, class 20, single stage, with flowmeter for exact control of the flow in Nl/min, with high pressure compensation for constant working pressure with safety gauge acc. to ISO 5171, with shut off valveinlet pressure max: 200 bar</p><p>outlet pressure: 4,5 bar pre adjusted<br><br>flow: 5,0 – 50,0 Nl/min. adjustable<br><br>inlet: W 24,32x1/14 RH nut acc. to DIN 477-1<br><br>outlet: G 1/4 RHk x 6 mm tail-piece acc. EN 560<br><br>inlet gauge: 0 – 315/200 bar<br><br>width x height x depth:: 210 x 230 x 75 mm<br><br><br><br>replaces item 223615</p>
13314 Purge valve Vareo for Vareo VS/BS with clamp ring compression fitting 10 mm. For purging one inlet on the Vareo block, integrated in Vareo distribution block. Complete with clamp ring compression fitting 10 mm at outlet for blow-off pipe connection. Note: when retrofitting into Vareo block, the spindle must be set and checked for tightness.