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 (
    12916, 12921, 12956, 12958, 13014, 13028, 
    13040, 13052, 12960, 12974, 12988, 
    13000, 13148, 13153, 12928, 12926, 
    12942, 3135, 12850, 12869, 12876, 12896, 
    12900, 12909
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00069

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "16.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": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_ult_product_descriptions`.`company_id` = 1) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`product_id` in (12916,12921,12956,12958,13014,13028,13040,13052,12960,12974,12988,13000,13148,13153,12928,12926,12942,3135,12850,12869,12876,12896,12900,12909)) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "14.41",
        "eval_cost": "2.40",
        "prefix_cost": "16.81",
        "data_read_per_join": "91K"
      },
      "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
3135 HD bundle hose Vulkan Vareo 200 bar, DN 6, PN 200 Flexible metal corrugated hose with two anti-kink springs, vent valve (attached to the hose on the bundle side) and safety cable (with loop on the bundle side) for connecting a nitrogen cylinder bundle to a gas supply Vareo, length 2,000 mm, DN6, PN 200, inlet according to DIN 477-1, No. 10, outlet M 24x1.5 RHk U-nut -16S Vareo
12956 Single-bundle acetylene manifold station Vulkan TecLine EB10 (with standard gauges). Complete on stainless steel base plate, acc. to ISO 14114, with HA10 regulator acc. to ISO 7291, automatic quick cut-off valve acc. to ISO 15615, flashback arrestor acc. to ISO 5175, and main shut-off valve. Manual switching. Inlet pressure max 26 bar, outlet pressure 0–1.5 bar. Max. flow 10 Nm³/h at 1.5 bar. Dimensions: 700 × 190 × 160 mm, 14 kg.
12958 Single-bundle acetylene manifold station Vulkan TecLine EB20 (with standard gauges). Complete on stainless steel base plate, acc. to ISO 14114, with HA10/H20 regulator acc. to ISO 7291, automatic quick cut-off valve acc. to ISO 15615, flashback arrestor acc. to ISO 5175, and main shut-off valve. Manual switching. Inlet pressure max 26 bar, outlet pressure 0–1.5 bar. Max. flow 18 Nm³/h at 1.5 bar. Dimensions: 970 × 190 × 160 mm, 16 kg.
12988 Single-bundle manifold station Vulkan TecLine EB75/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR60 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 0–60 bar. Max. flow 140 Nm³/h at 60 bar. With standard pressure gauges. Dimensions: 370 × 280 × 110 mm, N/A kg.
13028 Single-bundle manifold station Vulkan TecLine EB120/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR60 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 15–60 bar. Max. flow 450 Nm³/h at 60 bar. With standard pressure gauges. Dimensions: N/A mm, N/A kg.
13040 Single-bundle manifold station Vulkan TecLine EB200/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR200 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 15–200 bar. Max. flow 480 Nm³/h at 200 bar. With standard pressure gauges. Dimensions: 390 × 240 × 240 mm, N/A kg.
13052 Single-bundle manifold station Vulkan TecLine EB270/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR270 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 15–270 bar. Max. flow 480 Nm³/h at 270 bar. With standard pressure gauges. Dimensions: 390 × 240 × 240 mm, N/A kg.
13148 Single-cylinder manifold station Vulkan LabLine SE 10/2 300 (with standard gauges), chrome-plated. Modular add-on system. Manual switching. Complete on stainless steel base plate: 1× HP shut-off valve, 1× manifold regulator H10/2 double stage acc. to ISO 7291, 1× main shut-off valve, 1× purge valve, 1× cylinder rack. Inlet max 300 bar, outlet 0–10 bar. Max. flow 30 Nm³/h at 10 bar. Stainless steel diaphragm, gas purity up to 5.0. Dimensions: 480 × 280 × 110 mm.