Sandbox

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, 4027, 13314) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00055

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,4027,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
4027		<p>Working pressure reducer Vulkan AD 35 nitrogen 0 - 10 bar for AM 35, single-stage design, with safety pressure gauge according to DIN EN ISO 5171. Maximum inlet pressure: 20 bar. Output pressure: 0 - 10 bar, adjustable. Maximum output: 50 Nm³/h air at 10 bar outlet pressure. Inlet: G1/2" male thread, threaded connection according to DIN EN 560. Outlet: G3/8" male thread, threaded connection according to DIN EN 560. Outlet pressure gauge: 0 - 16/10 bar. Width x Height x Depth: 89 x 166 x 134 mm. This line pressure reducer is available in the following versions: Gas purity/diaphragm: Standard: - for technical gases up to a gas purity of 4.5 with a standard diaphragm. Optional (surcharge): - for pure gases up to a gas purity of 5.0 with a stainless steel diaphragm. SS321 (1.4541)</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.