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 (
    3498, 3428, 12916, 12921, 12876, 12896, 
    12900, 12909
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00048

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "8.09"
    },
    "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": 8,
      "rows_produced_per_join": 8,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_product_descriptions`.`product_id` in (3498,3428,12916,12921,12876,12896,12900,12909)) and (`test2_gaseus`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "7.29",
        "eval_cost": "0.80",
        "prefix_cost": "8.09",
        "data_read_per_join": "36K"
      },
      "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
3428 according to drawing no. 95 100 130, with inlet pressure gauge and shut-off valve,Inlet pressure max: 12 bar<br />Outlet pressure: fixed at approx. 0.5 - 0.7 bar<br />Inlet: 7/16" x 28 NS2<br />Output: compression fitting 4 mm Ms nickel-plated<br />Inlet pressure gauge: 0 - 16 bar<br />Output pressure gauge: without (no connection available)<br />With flyer provided by Linde - Linde #43586000<br />Accessory pack: bag with 3 O-rings #11207000<br /><br />Minimum order quantity 300 pieces
3498 acc. to ISO 2503, single stage with safety gauges acc. to EN562inlet pressure max:300 bar<br />outlet pressure: 10 - 100 bar adjustable<br />flow max:380 Nm³/h at 50 bar outlet pressure <br />inlet connection: W 30x2 RH nut acc. to DIN 477-5, no. 59<br />outlet connection: G3/4RHf male DIN 477-1, no. 9<br />inlet gauge: 0 – 400/300 bar<br />working gauge: 0 – 160/100 bar<br />width x height x depth: 170 x 140 x 180 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
12876 Tapping point regulator Vulkan TecLine E10, single stage. Brass body, Perbunan diaphragm and seals. Gas purity up to 4.5. Safety gauges acc. to DIN EN ISO 5171. Inlet pressure max 20 bar. Outlet pressure 0–10 bar (adjustable). Max. flow 46 Nm³/h at 10 bar back pressure. Inlet: G 3/8 RH (right-hand) nut acc. to EN 560. Outlet: G 1/4 RH x 6 mm hose nozzle. LP gauge: 0–16 bar. Dimensions: 120 × 160 × 65 mm, weight 1.0 kg.
12896 Tapping point regulator Vulkan TecLine E10F, single stage with integrated flowmeter for precise flow control. Brass body, Perbunan diaphragm and seals, acc. to ISO 2503 Class 10. Inlet pressure max 20 bar. Outlet pressure 4.5 bar (fixed). Flowmeter range 0.5–5.0 Nl/min (adjustable). Inlet: G 3/8 RH (right-hand) nut acc. to EN 560. Outlet: G 1/4 RH x 6 mm hose nozzle. Dimensions: 120 × 210 × 65 mm, weight 1.0 kg.
12900 Tapping point regulator Vulkan TecLine E20, single stage. Brass body, EPDM/PTFE diaphragm, EPDM seals. Gas purity up to 4.5. Safety gauges acc. to DIN EN ISO 5171. Inlet pressure max 40 bar. Outlet pressure 0–20 bar (adjustable). Max. flow 75 Nm³/h at 20 bar back pressure. Inlet: G 1/2 RH (right-hand) nut acc. to EN 560. Outlet: G 1/2 RH x 9 mm hose nozzle. LP gauge: 0–25 bar. Dimensions: 180 × 225 × 75 mm, weight 1.7 kg.
12909 Tapping point regulator Vulkan TecLine E40, single stage. Brass body, PTFE diaphragm (stainless steel for oxygen), PTFE seals. Gas purity up to 4.5. Safety gauges acc. to DIN EN ISO 5171. Inlet pressure max 60 bar. Outlet pressure 0–40 bar (adjustable). Max. flow 120 Nm³/h at 40 bar back pressure. Inlet: G 1/2 RH (right-hand) nut acc. to EN 560. Outlet: G 1/2 RH x 9 mm hose nozzle. Dimensions: 180 × 225 × 75 mm, weight 1.7 kg.
12916 Ribbed tapping point regulator Vulkan TecLine ER20, single stage. Brass body, stainless steel diaphragm, PTFE seals. Gas purity up to 4.5. Safety gauges acc. to DIN EN ISO 5171. Inlet pressure max 100 bar. Outlet pressure 0–20 bar (adjustable). Inlet: G 1/2 RH (right-hand) nut acc. to EN 560. Outlet: G 1/2 RH x 9 mm hose nozzle. Dimensions: 180 × 225 × 75 mm, weight 1.7 kg.
12921 Ribbed tapping point regulator Vulkan TecLine ER40, single stage. Brass body, stainless steel diaphragm, PTFE seals. Gas purity up to 4.5. Safety gauges acc. to DIN EN ISO 5171. Inlet pressure max 100 bar. Outlet pressure 15–40 bar (adjustable). Inlet: G 1/2 RH (right-hand) nut acc. to EN 560. Outlet: G 1/2 RH x 9 mm hose nozzle. Dimensions: 180 × 225 × 75 mm, weight 1.7 kg.