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 (13274, 13286, 13292, 3430) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00051

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "2.81"
    },
    "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": 4,
      "rows_produced_per_join": 4,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_ult_product_descriptions`.`company_id` = 1) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`product_id` in (13274,13286,13292,3430)) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "2.41",
        "eval_cost": "0.40",
        "prefix_cost": "2.81",
        "data_read_per_join": "15K"
      },
      "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
13274		In-line regulator Vulkan LabLine L10, single stage, chrome-plated body with stainless steel diaphragm for gas purity up to 5.0. With safety gauges acc. to DIN EN ISO 5171. Inlet pressure max 20 bar, outlet pressure 0–10 bar adjustable. Max. flow 45 Nm³/h at 10 bar. Inlet: clamp ring 8 mm. Outlet: clamp ring 8 mm. Dimensions: 200 × 190 × 75 mm, 1.5 kg.
13286		In-line regulator Vulkan LabLine L10/2, double stage, chrome-plated body with stainless steel diaphragm for gas purity up to 5.0. With safety gauges acc. to DIN EN ISO 5171. Inlet pressure max 20 bar, outlet pressure 0–10 bar adjustable. Max. flow 30 Nm³/h at 10 bar. Inlet: clamp ring 8 mm. Outlet: clamp ring 8 mm. Dimensions: 240 × 190 × 75 mm, 2.0 kg.
13292		In-line regulator Vulkan LabLine L15/2, double stage, chrome-plated body with stainless steel diaphragm for gas purity up to 5.0. With safety gauges acc. to DIN EN ISO 5171. Inlet pressure max 20 bar, outlet pressure 0–1.5 bar adjustable. Max. flow 8 Nm³/h at 1.5 bar. Inlet: clamp ring 8 mm. Outlet: clamp ring 8 mm. Dimensions: 240 × 190 × 75 mm, 2.0 kg.