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 (
    19, 20, 21, 3929, 3930, 3931, 12424, 12554, 
    12536, 12546, 6724, 3100, 3106, 3114, 
    3120, 3125, 3153, 3154, 6672, 6688, 
    6689, 6694, 6702, 6706
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00097

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "24.25"
    },
    "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": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_product_descriptions`.`product_id` in (19,20,21,3929,3930,3931,12424,12554,12536,12546,6724,3100,3106,3114,3120,3125,3153,3154,6672,6688,6689,6694,6702,6706)) and (`test2_gaseus`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "21.85",
        "eval_cost": "2.40",
        "prefix_cost": "24.25",
        "data_read_per_join": "109K"
      },
      "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
19 <p>In-line dome pressure reducer Vulkan LD1 MD both sides G1RHi 0.5 - 99 bar single-stage design, without pressure gauge. Maximum inlet pressure: 25 bar. Output pressure: 0.1 - 24 bar adjustable. Maximum output: 700 Nm³/h at 12 bar outlet pressure. Inlet and outlet: G 1 RHi. Width x height x depth: 130 x 170 x 130 mm. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108536. CO2 / Argon: Item No. 106536. Helium: Item No. 10653626. Nitrogen: Item No. 103536. Hydrogen: Item No. 104536. Compressed air: Item No. 107536</p>
20 <p>In-line dome pressure reducer Vulkan LD1 MD both sides G1RHi 0.5 - 99 bar single-stage design, without pressure gauge. Maximum inlet pressure: 25 bar. Output pressure: 0.1 - 24 bar adjustable. Maximum output: 700 Nm³/h at 12 bar outlet pressure. Inlet and outlet: G 1 RHi. Width x height x depth: 130 x 170 x 130 mm. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108536. CO2 / Argon: Item No. 106536. Helium: Item No. 10653626. Nitrogen: Item No. 103536. Hydrogen: Item No. 104536. Compressed air: Item No. 107536</p>
21 <p>In-line dome pressure reducer Vulkan LD1 MD both sides G1RHi 0.5 - 99 bar single-stage design, without pressure gauge. Maximum inlet pressure: 25 bar. Output pressure: 0.1 - 24 bar adjustable. Maximum output: 700 Nm³/h at 12 bar outlet pressure. Inlet and outlet: G 1 RHi. Width x height x depth: 130 x 170 x 130 mm. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108536. CO2 / Argon: Item No. 106536. Helium: Item No. 10653626. Nitrogen: Item No. 103536. Hydrogen: Item No. 104536. Compressed air: Item No. 107536</p>
3100 Line pressure reducer Vulkan LH25/10 oxygen 0.5 - 10 bar with safety pressure gauge ISO 5171, Max. inlet pressure: 40 bar<br />Technical data:<br /><br />• Outlet pressure: 0<br />• output: 180 Nm?/h compressed air at 10 bar outlet pressure, Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br /><br />Dimensions:<br /><br />Width x Height x Depth: 200 x 210 x 120 mm
3106 Line pressure reducer Vulkan LH25/10 oxygen 0.5 - 10 bar with safety pressure gauge ISO 5171, Max. inlet pressure: 40 bar<br />Technical data:<br /><br />• Outlet pressure: 0<br />• output: 180 Nm?/h compressed air at 10 bar outlet pressure, Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br /><br />Dimensions:<br /><br />Width x Height x Depth: 200 x 210 x 120 mm
3114 Line pressure reducer Vulkan LH25/10 oxygen 0.5 - 10 bar with safety pressure gauge ISO 5171, Max. inlet pressure: 40 bar<br />Technical data:<br /><br />• Outlet pressure: 0<br />• output: 180 Nm?/h compressed air at 10 bar outlet pressure, Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br /><br />Dimensions:<br /><br />Width x Height x Depth: 200 x 210 x 120 mm
3120 Line pressure reducer Vulkan LH25/10 oxygen 0.5 - 10 bar with safety pressure gauge ISO 5171, Max. inlet pressure: 40 bar<br />Technical data:<br /><br />• Outlet pressure: 0<br />• output: 180 Nm?/h compressed air at 10 bar outlet pressure, Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br /><br />Dimensions:<br /><br />Width x Height x Depth: 200 x 210 x 120 mm
3125 Line pressure reducer Vulkan LH25/10 oxygen 0.5 - 10 bar with safety pressure gauge ISO 5171, Max. inlet pressure: 40 bar<br />Technical data:<br /><br />• Outlet pressure: 0<br />• output: 180 Nm?/h compressed air at 10 bar outlet pressure, Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br /><br />Dimensions:<br /><br />Width x Height x Depth: 200 x 210 x 120 mm
3153 Line pressure reducer Vulkan LH25/10 oxygen 0.5 - 10 bar with safety pressure gauge ISO 5171, Max. inlet pressure: 40 bar<br />Technical data:<br /><br />• Outlet pressure: 0<br />• output: 180 Nm?/h compressed air at 10 bar outlet pressure, Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br /><br />Dimensions:<br /><br />Width x Height x Depth: 200 x 210 x 120 mm
3154 Line pressure reducer Vulkan LH25/10 oxygen 0.5 - 10 bar with safety pressure gauge ISO 5171, Max. inlet pressure: 40 bar<br />Technical data:<br /><br />• Outlet pressure: 0<br />• output: 180 Nm?/h compressed air at 10 bar outlet pressure, Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br /><br />Dimensions:<br /><br />Width x Height x Depth: 200 x 210 x 120 mm
3929 <p>In-line dome pressure reducer Vulkan LD1 MD both sides G1RHi 0.5 - 99 bar single-stage design, without pressure gauge. Maximum inlet pressure: 25 bar. Output pressure: 0.1 - 24 bar adjustable. Maximum output: 700 Nm³/h at 12 bar outlet pressure. Inlet and outlet: G 1 RHi. Width x height x depth: 130 x 170 x 130 mm. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108536. CO2 / Argon: Item No. 106536. Helium: Item No. 10653626. Nitrogen: Item No. 103536. Hydrogen: Item No. 104536. Compressed air: Item No. 107536</p>
3930 <p>In-line dome pressure reducer Vulkan LD1 MD both sides G1RHi 0.5 - 99 bar single-stage design, without pressure gauge. Maximum inlet pressure: 25 bar. Output pressure: 0.1 - 24 bar adjustable. Maximum output: 700 Nm³/h at 12 bar outlet pressure. Inlet and outlet: G 1 RHi. Width x height x depth: 130 x 170 x 130 mm. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108536. CO2 / Argon: Item No. 106536. Helium: Item No. 10653626. Nitrogen: Item No. 103536. Hydrogen: Item No. 104536. Compressed air: Item No. 107536</p>
3931 <p>In-line dome pressure reducer Vulkan LD1 MD both sides G1RHi 0.5 - 99 bar single-stage design, without pressure gauge. Maximum inlet pressure: 25 bar. Output pressure: 0.1 - 24 bar adjustable. Maximum output: 700 Nm³/h at 12 bar outlet pressure. Inlet and outlet: G 1 RHi. Width x height x depth: 130 x 170 x 130 mm. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108536. CO2 / Argon: Item No. 106536. Helium: Item No. 10653626. Nitrogen: Item No. 103536. Hydrogen: Item No. 104536. Compressed air: Item No. 107536</p>
6672 Line pressure reducer Vulkan LH25/10 oxygen 0.5 - 10 bar with safety pressure gauge ISO 5171, Max. inlet pressure: 40 bar<br />Technical data:<br /><br />• Outlet pressure: 0<br />• output: 180 Nm?/h compressed air at 10 bar outlet pressure, Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br /><br />Dimensions:<br /><br />Width x Height x Depth: 200 x 210 x 120 mm
6688 Line pressure reducer Vulkan LH25/10 oxygen 0.5 - 10 bar with safety pressure gauge ISO 5171, Max. inlet pressure: 40 bar<br />Technical data:<br /><br />• Outlet pressure: 0<br />• output: 180 Nm?/h compressed air at 10 bar outlet pressure, Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br /><br />Dimensions:<br /><br />Width x Height x Depth: 200 x 210 x 120 mm
6689 Line pressure reducer Vulkan LH25/10 oxygen 0.5 - 10 bar with safety pressure gauge ISO 5171, Max. inlet pressure: 40 bar<br />Technical data:<br /><br />• Outlet pressure: 0<br />• output: 180 Nm?/h compressed air at 10 bar outlet pressure, Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br /><br />Dimensions:<br /><br />Width x Height x Depth: 200 x 210 x 120 mm
6694 Line pressure reducer Vulkan LH25/10 oxygen 0.5 - 10 bar with safety pressure gauge ISO 5171, Max. inlet pressure: 40 bar<br />Technical data:<br /><br />• Outlet pressure: 0<br />• output: 180 Nm?/h compressed air at 10 bar outlet pressure, Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br /><br />Dimensions:<br /><br />Width x Height x Depth: 200 x 210 x 120 mm
6702 Line pressure reducer Vulkan LH25/10 oxygen 0.5 - 10 bar with safety pressure gauge ISO 5171, Max. inlet pressure: 40 bar<br />Technical data:<br /><br />• Outlet pressure: 0<br />• output: 180 Nm?/h compressed air at 10 bar outlet pressure, Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br /><br />Dimensions:<br /><br />Width x Height x Depth: 200 x 210 x 120 mm
6706 Line pressure reducer Vulkan LH25/10 oxygen 0.5 - 10 bar with safety pressure gauge ISO 5171, Max. inlet pressure: 40 bar<br />Technical data:<br /><br />• Outlet pressure: 0<br />• output: 180 Nm?/h compressed air at 10 bar outlet pressure, Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Inlet: Internal thread G1RH, Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br />• Outlet: Internal thread G1RH, Output pressure gauge: 0-16/10 axial, Width x Height x Depth: 200 x 210 x 120 mm<br /><br />Dimensions:<br /><br />Width x Height x Depth: 200 x 210 x 120 mm
6724 Tapping Points: Pressure Reducer Vulkan E10F Flowmeter LabLine Forming Gas 34 Nl/min. Completely chrome-plated with metal diaphragms for gas purity 5.0, based on ISO 2503<br />Standards & Design:<br /><br />Class 20<br />single-stage design, with flowmeter for monitoring the exact flow rate in Nl/min<br />according to DIN EN 560<br /><br />Technical data:<br /><br />• Maximum inlet pressure: 20 bar<br />• Output pressure: 4<br />• Inlet: G 3/8 LHk U-nut according to DIN EN 560<br />• Outlet: 6mm double clamp ring, stainless steel<br /><br />Dimensions:<br /><br />Width x Height x Depth: 120 x 210 x 65 mm
12424 <p>Compact single-stage line pressure regulator according to ISO 2503 for technical, medical, corrosive, laboratory and high-purity gases. Inlet and outlet: 1/4" NPT-F thread or compression fitting. Outlet pressure gauge Ø50 mm according to DIN 837. 50 µm inlet filter and relief valve. Gas purity up to 6.0. Maximum inlet pressure up to 300 bar depending on standard; coding legend additionally defines inlet pressure classes L=70 bar, H=210 bar, 300=300 bar (brass only), 400=400 bar (stainless steel only). Outlet pressure ranges from 1.5 to 30 bar, special ranges up to 60 bar possible. Temperature range -40 to +70 °C. Body materials: chrome-plated brass, stainless steel or Monel. Membrane materials: stainless steel or Hastelloy. ECD suitable. Leak rate &lt; 1×10^-8 (helium). ATEX and PED compliant. Options include inlet gauge, shut-off or metering valve, self or external purge system, contact gauge or pressure transmitter.</p>
12536 Compact single-stage line pressure regulator type Thanos in accordance with ISO 2503 for technical, medical, corrosive, laboratory and high-purity gases. Features: compact design, high control accuracy, inlet and outlet: 1/4" NPT-F or according to customer requirements; outlet pressure gauge Ø 50 mm (DIN EN 837); 74 µm inlet filter; relief valve; gas purity up to 6.0; temperature range -20 to +60 °C; body materials: nickel-plated brass or stainless steel 316L; diaphragm: stainless steel 316L; seat: PCTFE; leak rate < 2×10⁻⁸ mbar·l/s (He); compliant with 2014/68/EU (PED) and 2014/34/EU (ATEX). Options: inlet pressure gauge, shut-off or metering valve, purge system (internal or external), contact gauge or pressure transmitter.
12546 Compact two-stage line pressure regulator type Thanos II in accordance with ISO 2503 for technical, medical, corrosive, laboratory and high-purity gases. Two-stage design provides absolutely constant outlet pressure even as inlet pressure fluctuates. Features: compact design, high control accuracy, inlet and outlet: 1/4" NPT-F or according to customer requirements; outlet pressure gauge Ø 50 mm (DIN EN 837); 74 µm inlet filter; relief valve; gas purity up to 6.0; temperature range -20 to +60 °C; body materials: nickel-plated brass or stainless steel 316L; diaphragm: stainless steel 316L; seat: PCTFE; leak rate < 2×10⁻⁸ mbar·l/s (He); compliant with 2014/68/EU (PED) and 2014/34/EU (ATEX). Options: inlet pressure gauge, shut-off or metering valve, purge system (internal or external), contact gauge or pressure transmitter.
12554 Compact two-stage line pressure regulator type Sigma II in accordance with ISO 2503 for technical, medical, corrosive, laboratory and high-purity gases. Two-stage design provides absolutely constant outlet pressure even as inlet pressure fluctuates. Features: compact design with high control accuracy; inlet and outlet: 1/4" NPT-F, alternatively compression fitting; outlet pressure gauge Ø 50 mm (DIN EN 837); 50 µm inlet filter; relief valve per stage; gas purity up to 6.0; temperature range -40 to +70 °C; body materials: chrome-plated brass, stainless steel or Monel; diaphragm: stainless steel or Hastelloy; seat: PCTFE; ECD compatible; ATEX compliant (94/9/EG); PED compliant (97/23/EG). Options: inlet pressure gauge Ø 50 mm, shut-off or metering valve, gas purging system (internal or external), contact gauge or pressure transmitter.