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 (
    3488, 3497, 3495, 3489, 3492, 3496, 3490, 
    3494, 6951, 3502, 3503, 3493, 3498, 
    3428, 12916, 12921, 12876, 12896, 12900, 
    12909
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00054

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "20.21"
    },
    "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": 20,
      "rows_produced_per_join": 20,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_product_descriptions`.`product_id` in (3488,3497,3495,3489,3492,3496,3490,3494,6951,3502,3503,3493,3498,3428,12916,12921,12876,12896,12900,12909)) and (`test2_gaseus`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "18.21",
        "eval_cost": "2.00",
        "prefix_cost": "20.21",
        "data_read_per_join": "91K"
      },
      "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
3488 according to ISO 2503, class 3,single stage with high-pressure compensation, with safety gauges according to ISO 5171, including shut off valveinlet pressure max.: 300 bar<br />working pressure: 0 - 10 bar adjustable <br />flow max. 48 Nm³/h compressed air at 10 bar working pressure<br />inlet connection: W 30x2 RH acc. to DIN 477-5, no. 54<br />outlet connection: G 1/4 RH x 6 mm acc. to EN 560<br />cylinder gauge 0 - 400/300 bar<br />working gauge: 0 - 16/10 bar<br />width x height x depth: 210 x 190 x 75 mm <br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3489 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. 54<br />outlet connection: W 24,32x1/14 RH male DIN 477-1, no. 10<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
3490 acc. to ISO 2503, single stage with safety gauges acc. to ISO5171inlet pressure max: 300 bar<br />outlet pressure: 10 - 300 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. 54<br />outlet connection: W 24,32x1/14 RH male DIN 477-1, no. 10<br />inlet gauge: 0 – 400/300 bar<br />working gauge: 0 – 315/200 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
3492 acc. to ISO 2503, class 5, single stage, with high pressure compensation for constant working pressure, with safety gauges acc. to ISO 5171, with shut off valve,inlet pressure max.: 300 bar<br />outlet pressure: 0 – 20 bar adjustable<br />flow max.: 75 Nm³/h air at 10 bar working pressure<br />Inlet connection: W30x2LH nut acc. to DIN 477-5 no. 57<br />outlet connection: G 3/8 LHk x 9 mm tailpiece acc. to EN 560<br />inlet gauge: 0 - 400/300 bar<br />working gauge: 0 - 40/20 bar<br />width x height x depth: 210 x 210 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3493 <p>acc to DIN EN ISO 2503, class 3, single stage, with safety gauges acc. to DIN ISO 5171,</p><p>with shut off valve<br><br>inlet pressure max: 200 bar<br><br>outlet pressure: 0 - 50 Nl/min. (0 – 10 bar) adjustable<br><br>flow max: 50 Nl/min. at 10 bar outlet pressure <br><br>inlet connection: W 30x2 LH nut acc. to DIN 477-5 no. 57<br><br>outlet connection: G 3/8 LHk x 9 mm tail-piece acc. EN560<br><br>inlet gauge: 0 – 400/300 bar<br><br>working gauge: 0 – 50 Nl/min.<br><br>width x height x depth: 210 x 190 x 75 mm<br><br>with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape</p>
3494 <p>acc to DIN EN ISO 2503, single stage, with high pressure compensation for a constant working pressure on falling inlet pressure with safety gauges acc. to DIN ISO 5171inlet pressure max: 200 bar</p><p>outlet pressure: 0 – 60 bar adjustable<br><br>flow max: 140 Nm³/h at 60 bar working pressure<br><br>inlet connection: W30x2 RHf nut acc. to DIN 477-5, no. 54<br><br>outlet connection: G 1/4RHak acc. to EN560<br><br>inlet gauge: 0 – 400/300 bar<br><br>working gauge: 0 – 100/60 bar<br><br>width x height x depth: 210 x 210 x 75 mm<br><br>with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape</p>
3495 acc. to ISO 2503, single stage with safety gauges acc. to ISO 5171inlet 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. 54<br />outlet connection: W 21,8x1/14 RH male DIN 477-1, no. 6<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
3496 acc. to ISO 2503, single stage with safety gauges acc. to EN562inlet pressure max: 300 bar<br />outlet pressure: 10 - 300 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. 54<br />outlet connection: W 21,8x1/14 RH male DIN 477-1, no. 6<br />inlet gauge: 0 – 400/300 bar<br />working gauge: 0 – 315/200 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
3497 according to ISO 2503, class 3, adiabatic compression tested, single stage with high-pressure compensation, with safety gauges according to ISO 5171, including shut off valveinlet pressure max.: 300 bar<br />working pressure: 0 - 10 bar adjustable <br />flow max. 48 Nm³/h compressed air at 10 bar working pressure<br />inlet connection: W 30x2 RH acc. to DIN 477-5, no. 59<br />outlet connection: G 1/4 RH x 6 mm acc. to EN 560<br />cylinder gauge 0 - 400/300 bar<br />working gauge: 0 - 16/10 bar<br />width x height x depth: 210 x 190 x 75 mm <br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
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
3502 <p>acc to ISO2503, single stage, with flowmeter for exact control of the flow in Nl/min, TÜV – approved following Pressure equipment Directive 97/23/EG with high pressure compensation for constant working pressure with safety gauge acc. to ISO 5171, with shut off valveinlet pressure max: 300 bar</p><p>outlet pressure: 1,5 bar pre adjusted<br><br>flow: 2 – 23 Nl/min. adjustable<br><br>inlet: W 30x2 LH nut acc. to DIN 477-5<br><br>outlet: G 3/8 LHk x 9 mm tail-piece acc. EN 560<br><br>inlet gauge: 0 – 400/300 bar<br><br>width x height x depth:: 210 x 230 x 75 mm</p>
3503 acc to DIN EN ISO 2503, class 3, single stage, with safety gauges acc. to DIN ISO 5171, with shut off valve,inlet pressure max: 300 bar<br />outlet pressure: 0 – 10 bar <br />flow: 0 – 30 Nl/min. adjustable<br />inlet connection: W 30x2 RH nut acc. to DIN 477-5, no. 54<br />outlet connection: G 1/4RH x 6mm tail-piece<br />inlet gauge: 0 – 400/300 bar<br />working gauge: 0 – 30 Nl/min. (0 - 10 bar)<br />width x height x depth: 210 x 190 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde tape
6951 acc to EN 13918, class 10, single stage, with flowmeter for exact control of the flow in Nl/min, TÜV – approved following Pressure equipment Directive 97/23/EG with high pressure compensation for constant working pressure with safety gauge acc. to ISO 5171, with shut off valveinlet pressure max: 300 bar<br />outlet pressure: 1,5 bar pre adjusted<br />flow: 4 – 32 Nl/min. adjustable<br />inlet: W 30x2 RH nut acc. to DIN 477-5<br />outlet: G 1/4 RHk x 6 mm tail-piece acc. EN 560<br />inlet gauge: 0 – 400/300 bar<br />width x height x depth:: 210 x 230 x 75 mm
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.