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 (
    6949, 13298, 13299, 13300, 13301, 13124, 
    13125, 13126, 13098, 13105, 13112, 
    13118, 13064, 13071, 13078, 13085, 
    13091, 13314, 13316, 13315, 13317, 
    13318, 12956, 12958, 13014, 13028, 
    13040, 13052, 12960, 12974, 12988, 
    13000, 12926, 12942
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00093

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "34.35"
    },
    "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": 34,
      "rows_produced_per_join": 34,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_product_descriptions`.`product_id` in (6949,13298,13299,13300,13301,13124,13125,13126,13098,13105,13112,13118,13064,13071,13078,13085,13091,13314,13316,13315,13317,13318,12956,12958,13014,13028,13040,13052,12960,12974,12988,13000,12926,12942)) and (`test2_gaseus`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "30.95",
        "eval_cost": "3.40",
        "prefix_cost": "34.35",
        "data_read_per_join": "155K"
      },
      "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
6949 <p>acc to DIN EN ISO 2503, class 10, single stage, with double flowmeter for exact control of the flow in Nl/min, with high pressure compensation for constant working pressure with safety gauge acc. to ISO 5171, with shut off valveinlet pressure max: 200 bar</p><p>outlet pressure: 1,5 bar pre adjusted<br><br>flow: 2 x 2-23 Nl/min. adjustable<br><br>inlet: W 24,32x1/14 RH nut acc. to DIN 477-1, no. 1<br><br>outlet: 2x G 1/4 RHk x 6 mm tail-piece acc. EN 560<br><br>inlet gauge: 0 – 315/200 bar<br><br>width x height x depth: 250 x 230 x 130 mm<br><br>with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape</p>
12926 Single-cylinder manifold station Vulkan TecLine SE10/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator H10 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 0–10 bar adjustable. Max. flow 50 Nm³/h at 10 bar. With standard pressure gauges. Dimensions: 420 × 260 × 110 mm, 4.5 kg.
12942 Single-cylinder manifold station Vulkan TecLine SE20/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator H20 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 0–20 bar adjustable. Max. flow 75 Nm³/h at 20 bar. With standard pressure gauges. Dimensions: 420 × 320 × 110 mm, 5.0 kg.
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.
12960 Single-bundle manifold station Vulkan TecLine EB60/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator H20 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 0–20 bar. Max. flow 75 Nm³/h at 20 bar. With standard pressure gauges. Dimensions: 420 × 320 × 110 mm, 5.0 kg.
12974 Single-bundle manifold station Vulkan TecLine EB70/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR40 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 0–40 bar. Max. flow 120 Nm³/h at 40 bar. With standard pressure gauges. Dimensions: N/A mm, N/A 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.
13000 Single-bundle manifold station Vulkan TecLine EB80/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR20 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 0–20 bar. Max. flow 170 Nm³/h at 20 bar. With standard pressure gauges. Dimensions: 440 × 350 × 130 mm, N/A kg.
13014 Single-bundle manifold station Vulkan TecLine EB100/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR40 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 15–40 bar. Max. flow 290 Nm³/h at 40 bar. With standard pressure gauges. Dimensions: 440 × 370 × 130 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.
13064 Manual manifold base station Vulkan TecLine BS 50/300. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator H10 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 0–10 bar. Max. flow 50 Nm³/h at 10 bar. Dimensions: 570 × 250 × 210 mm, 10 kg.
13071 Manual manifold base station Vulkan TecLine BS 60/300 Effect. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator H20 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Also available with incorporated gas pre-heater GPH 200 or GPH 400. Inlet max 300 bar, outlet 0–20 bar. Max. flow 75 Nm³/h at 20 bar. Dimensions: 570 × 250 × 210 mm, 10 kg.
13078 Manual manifold base station Vulkan TecLine BS 70/300 Effect. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator HR40 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 0–40 bar. Max. flow 120 Nm³/h at 40 bar. Dimensions: 570 × 250 × 210 mm, 10 kg.
13085 Manual manifold base station Vulkan TecLine BS 75/300 Effect. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator HR60 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 0–60 bar. Max. flow 140 Nm³/h at 60 bar. Dimensions: 570 × 250 × 210 mm, 10 kg.
13091 Manual manifold base station Vulkan TecLine BS 80/300 Effect. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator HR20 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 0–20 bar. Max. flow 170 Nm³/h at 20 bar. Dimensions: 590 × 250 × 210 mm, 11 kg.
13098 Manual manifold base station Vulkan TecLine BS 100/300 Effect. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator HR40 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 15–40 bar. Max. flow 290 Nm³/h at 40 bar. Dimensions: 590 × 270 × 210 mm, 14 kg.
13105 Manual manifold base station Vulkan TecLine BS 120/300 Effect. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator HR60 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 15–60 bar. Max. flow 450 Nm³/h at 60 bar. Dimensions: 590 × 270 × 210 mm, 14 kg.
13112 Manual manifold base station Vulkan TecLine BS 200/300. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold manifold regulator LHR 300/200 acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 15–200 bar. Max. flow 480 Nm³/h at 200 bar. Dimensions: 590 × 330 × 285 mm, 12 kg.
13118 Manual manifold base station Vulkan TecLine BS 270/300. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold manifold regulator acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 15–270 bar. Max. flow 480 Nm³/h at 270 bar. Dimensions: 590 × 330 × 285 mm, 12 kg.
13124 Manual manifold base station for acetylene bundles Vulkan TecLine BSA 10 B. Complete on stainless steel base plate acc. to ISO 14114: 1× distributing block Modula Vareo with automatic quick cut-off valve acc. to ISO 15615, 1× flashback arrestor acc. to ISO 5175, 1× manifold fin regulator HA10 acc. to ISO 7291, 1× main shut-off valve. Manual switching. Inlet max 26 bar, outlet 0–1.5 bar. Max. flow 10 Nm³/h. Dimensions: 850 × 250 × 210 mm, 15 kg.
13125 Manual manifold base station for acetylene bundles Vulkan TecLine BSA 20 B. Complete on stainless steel base plate acc. to ISO 14114: 1× distributing block Modula Vareo with automatic quick cut-off valve acc. to ISO 15615, 1× flashback arrestor acc. to ISO 5175, 1× manifold regulator H20 acetylene acc. to ISO 7291, 1× main shut-off valve. Manual switching. Inlet max 26 bar, outlet 0–1.5 bar. Max. flow 18 Nm³/h. Dimensions: 980 × 250 × 230 mm, 19 kg.
13126 Manual manifold base station for acetylene bundles Vulkan TecLine BSA 40 B. Complete on stainless steel base plate acc. to ISO 14114: 1× distributing block Modula Vareo with automatic quick cut-off valve acc. to ISO 15615, 1× flashback arrestor acc. to ISO 5175, 1× manifold fin regulator HA40 acc. to ISO 7291, 1× main shut-off valve. Manual switching. Inlet max 26 bar, outlet 0–1.5 bar. Max. flow 38 Nm³/h. Dimensions: 980 × 275 × 210 mm, 26 kg.
13298 Manifold station Modula Vareo VS for oxygen, inert and fuel gases (except acetylene). Vareo distribution block with 2 inlets M 24×1.5 RH for connecting 2 cylinders or bundles up to 300 bar. Equipped with 2 sinter filters, 2 non-return valves (NRV), 2 shut-off valves, and 2 connections for additional manifold stations or base station Vareo. Fully assembled on base plate. Material: brass. Dimensions: 195 × 205 × 240 mm.
13299 Manifold station Modula Vareo VS for acetylene. Vareo distribution block with 2 inlets W 21.8×1/14 LH for connecting 2 cylinders or bundles up to 300 bar. Equipped with 2 sinter filters, 2 non-return valves (NRV), 2 shut-off valves, and 2 connections for additional manifold stations or base station Vareo. Fully assembled on base plate. Material: brass. Dimensions: 195 × 205 × 240 mm.
13300 Manifold station Modula Vareo VSD for oxygen, inert and fuel gases (except acetylene). Without non-return valve and sinter filter. Vareo distribution block with 2 inlets M 24×1.5 RH for connecting 2 cylinders or bundles up to 300 bar. 2 shut-off valves and 2 connections for additional manifold stations or base station Vareo. Fully assembled on base plate. Material: brass. Dimensions: 195 × 205 × 240 mm.
13301 Manifold station Modula Vareo VSL for oxygen, inert and fuel gases (except acetylene). Without shut-off valve. Vareo distribution block with 2 inlets M 24×1.5 RH for connecting 2 cylinders or bundles up to 300 bar. 2 sinter filters, 2 non-return valves and 2 connections for additional manifold stations or base station Vareo. Fully assembled on base plate. Material: brass. Dimensions: 195 × 205 × 240 mm.
13314 Purge valve Vareo for Vareo VS/BS with clamp ring compression fitting 10 mm. For purging one inlet on the Vareo block, integrated in Vareo distribution block. Complete with clamp ring compression fitting 10 mm at outlet for blow-off pipe connection. Note: when retrofitting into Vareo block, the spindle must be set and checked for tightness.
13315 Purge valve Vareo for Vareo VS/BS with angle valve EV UM M24×1.5RH-16S, for all technical gases except acetylene. Inlet: U-nut M 24×1.5 RH.
13316 Purge valve Vareo for Vareo VS/BS with angle valve EV UM M24×1.5RH-16S, for acetylene. Inlet: U-nut M 24×1.5 RH.
13317 Rail system Vulkan Modula FN 1-cylinder with non-return valve, left mounting. 1 inlet M 24×1.5 RH with non-return valve and sinter filter. Brass body, max 300 bar. Width: 125 mm.
13318 Rail system Vulkan Modula FN 1-cylinder with non-return valve, right mounting. 1 inlet M 24×1.5 RH with non-return valve and sinter filter. Brass body, max 300 bar. Width: 125 mm.