SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    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, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (12464, 12624, 12654) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00068

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "3.04"
    },
    "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": 3,
      "rows_produced_per_join": 3,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_product_descriptions`.`product_id` in (12464,12624,12654)) and (`test2_gaseus`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "2.74",
        "eval_cost": "0.30",
        "prefix_cost": "3.04",
        "data_read_per_join": "13K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "meta_keywords",
        "meta_description",
        "search_words",
        "promo_text",
        "unit_name"
      ]
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text unit_name
12464 <p>Compact single-stage pressure control station (manifold) for one cylinder, designed for technical, medical, corrosive, laboratory and high-purity gases. Equipped with one main pressure regulator, inlet and outlet pressure gauges (Ø 50 mm, DIN 837), 50 µm inlet filter and relief valve. Includes one stainless steel corrugated metal hose, 1,000 mm long, for cylinder connection. Completely mounted on a stainless steel base plate with fixing holes. Inlet: cylinder connection according to DIN 477 Part 1 or Part 5. Outlet: compression fitting or alternatively 1/4" NPT-F thread. Maximum inlet pressure up to 300 bar depending on standard. Outlet pressure ranges from 1.5 to 30 bar; special ranges up to 60 bar are possible. Temperature range: -40 to +70 °C. Body materials: chrome-plated brass, stainless steel or Monel. Membranes: stainless steel or Hastelloy. ECD suitable. Leak rate &lt; 1×10^-8 (helium). ATEX and PED compliant. Options include shut-off or metering valve, purge system and contact gauge or pressure transmitter.</p>
12624 Compact single-stage pressure control station (manifold) for two cylinders with manual changeover, designed for technical, medical, corrosive, laboratory and high-purity gases. Equipped with one main pressure regulator, inlet and outlet pressure gauges (Ø 50 mm, DIN 837), 50 µm inlet filter and relief valve. Includes 2 distribution blocks with shut-off valves for left and right cylinder changeover, and 2 stainless steel corrugated metal hoses (1,000 mm) for cylinder connection. Completely mounted on a stainless steel base plate with fixing holes. Inlet: cylinder connection according to DIN 477 Part 1 or Part 5. Outlet: compression fitting or alternatively 1/4" NPT-F thread. Maximum inlet pressure up to 300 bar depending on standard. Outlet pressure ranges from 1.5 to 30 bar; special ranges up to 60 bar. Temperature range: -40 to +70 °C. Body materials: chrome-plated brass, stainless steel or Monel. Diaphragm: stainless steel or Hastelloy. Seat: PCTFE. ECD suitable. Leak rate < 1×10⁻⁸ mbar·l/s (He). ATEX and PED compliant. Options: shut-off or metering valve, extension for more cylinders, purge system, contact gauge or pressure transmitter.
12654 Compact two-stage pressure control station (manifold) for two cylinders with manual changeover, designed for technical, medical, corrosive, laboratory and high-purity gases. Two-stage regulation ensures highly stable outlet pressure regardless of declining inlet pressure. Equipped with one main two-stage pressure regulator, inlet and outlet pressure gauges (Ø 50 mm, DIN 837), 50 µm inlet filter and relief valve per stage. Includes 2 distribution blocks with shut-off valves for left and right cylinder changeover, and 2 stainless steel corrugated metal hoses (1,000 mm) for cylinder connection. Completely mounted on a stainless steel base plate with fixing holes. Inlet: cylinder connection according to DIN 477 Part 1 or Part 5. Outlet: compression fitting or alternatively 1/4" NPT-F thread. Maximum inlet pressure up to 300 bar depending on standard. Outlet pressure ranges from 1.5 to 30 bar; special ranges up to 60 bar. Temperature range: -40 to +70 °C. Body materials: chrome-plated brass, stainless steel or Monel. Diaphragm: stainless steel or Hastelloy. Seat: PCTFE. ECD suitable. Leak rate < 1×10⁻⁸ mbar·l/s (He). ATEX and PED compliant. Options: shut-off or metering valve, extension for more cylinders, purge system, contact gauge or pressure transmitter.