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 (
    12684, 12714, 13260, 13267, 12349, 12364, 
    12259, 12504, 12524, 12379, 6843, 6840
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00103

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "12.13"
    },
    "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": 12,
      "rows_produced_per_join": 12,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_product_descriptions`.`product_id` in (12684,12714,13260,13267,12349,12364,12259,12504,12524,12379,6843,6840)) and (`test2_gaseus`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "10.93",
        "eval_cost": "1.20",
        "prefix_cost": "12.13",
        "data_read_per_join": "54K"
      },
      "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
6840 Vulkan F15/200 Effect LabLine nitrogen cylinder pressure reducer 0-1.5 bar, fully chrome-plated with a metal diaphragm for gas purity 5.0, with pre-pressure compensation for constant back pressure under all operating conditions<br />Standards & Design:<br /><br />single-stage design, with shut-off valve, with safety gauges according to DIN EN ISO 5171, maximum inlet pressure: 200 bar, adjustable outlet pressure: 0-1<br />according to DIN 477-1 No<br /><br />Functional elements:<br /><br />• shut-off valve, with safety gauges according to DIN EN ISO 5171, maximum inlet pressure: 200 bar, adjustable outlet pressure: 0-1<br /><br />Technical data:<br /><br />• maximum inlet pressure: 200 bar, adjustable outlet pressure: 0-1<br />• outlet pressure: 0-1<br />• output: 8 Nm³/h compressed air at 1<br />• Inlet: W24<br />• outlet: 6 mm stainless steel compression fitting<br /><br />Dimensions:<br /><br />Width x Height x Depth: 210 x 190 x 75 mm
6843 Vulkan F15/200 Effect LabLine nitrogen cylinder pressure reducer 0-1.5 bar, fully chrome-plated with a metal diaphragm for gas purity 5.0, with pre-pressure compensation for constant back pressure under all operating conditions<br />Standards & Design:<br /><br />single-stage design, with shut-off valve, with safety gauges according to DIN EN ISO 5171, maximum inlet pressure: 200 bar, adjustable outlet pressure: 0-1<br />according to DIN 477-1 No<br /><br />Functional elements:<br /><br />• shut-off valve, with safety gauges according to DIN EN ISO 5171, maximum inlet pressure: 200 bar, adjustable outlet pressure: 0-1<br /><br />Technical data:<br /><br />• maximum inlet pressure: 200 bar, adjustable outlet pressure: 0-1<br />• outlet pressure: 0-1<br />• output: 8 Nm³/h compressed air at 1<br />• Inlet: W24<br />• outlet: 6 mm stainless steel compression fitting<br /><br />Dimensions:<br /><br />Width x Height x Depth: 210 x 190 x 75 mm
12259 <p> Sigma series cylinder pressure regulators are designed for precise and reliable pressure control in applications involving technical, medical, corrosive, laboratory, and high-purity gases. The modular design allows flexible configuration depending on gas type, required pressure range, and connection standards. </p> <p> The regulators are available in both single-stage and dual-stage versions. Dual-stage models ensure stable downstream pressure regardless of decreasing cylinder pressure, making them suitable for applications requiring high accuracy and consistency. </p> <p> A wide range of inlet and outlet configurations is supported, including various cylinder connection standards (e.g. DIN 477 and others) as well as multiple outlet options such as threaded connections or compression fittings. This flexibility allows seamless integration into different gas supply systems. </p> <p> The Sigma series is engineered for demanding environments and supports gas purity levels up to 6.0. Depending on configuration, regulators are available with bodies made of chrome-plated brass, stainless steel or Monel, and diaphragms made of stainless steel or Hastelloy, ensuring durability and chemical resistance. </p> <p> Additional configuration options include shut-off or metering valves, pressure gauges or transmitters, as well as internal or external gas purging systems. </p> <p> All models comply with relevant industrial and safety standards, including ATEX and PED, and are designed for operation in a wide temperature range. </p> <h2>Key Benefits</h2> <ul> <li>High pressure control accuracy</li> <li>Stable outlet pressure, especially in dual-stage configurations</li> <li>Wide range of connection standards and configuration options</li> <li>Suitable for high-purity and corrosive gases</li> <li>Modular design for application-specific customization</li> <li>Reliable operation in industrial, laboratory and medical environments</li> </ul> <h2>Typical Applications</h2> <ul> <li>Gas distribution systems</li> <li>Laboratories and research facilities</li> <li>Medical gas supply systems</li> <li>Industrial gas processes</li> <li>High-purity gas applications</li> </ul>
12349 Compact single-stage cylinder pressure regulator (ISO 2503) for technical, medical, corrosive, laboratory and high-purity gases; very high regulation accuracy for setting very low pressures in the mbar range; inlet (right): cylinder connection per DIN 477-1 or DIN 477-5, alternatively 1/4" NPT-F; outlet: compression fitting, alternatively 1/4" NPT-F; inlet pressure gauge Ø50 mm (DIN 837) and outlet pressure gauge Ø63 mm (DIN 837); 50 µm inlet filter; relief valve; gas purity up to 6.0; max inlet pressure 15 bar; outlet pressure ranges 50–1000 mbar; temperature -40 to +70 °C; body materials: chrome-plated brass, stainless steel or Monel; diaphragm: stainless steel or Hastelloy; ECD compatible; leak rate < 1×10^-8 (He); ATEX and PED compliant; options: shut-off or metering valve, purge system (self or external), contact gauge or pressure transmitter.
12364 Compact two-stage cylinder pressure regulator (ISO 2503) for technical, medical, corrosive, laboratory and high-purity gases; very high regulation accuracy for setting very low pressures in the mbar range; inlet (right): cylinder connection per DIN 477-1 or DIN 477-5, alternatively 1/4" NPT-F; outlet: compression fitting, alternatively 1/4" NPT-F; inlet pressure gauge Ø50 mm (DIN 837) and outlet pressure gauge Ø63 mm (DIN 837); 50 µm inlet filter; relief valve in each stage; gas purity up to 6.0; max inlet pressure up to 300 bar depending on standard, 210 bar for the DIN 477-1 No. 6 configuration shown in the ordering example; outlet pressure ranges 50–1000 mbar; temperature -40 to +70 °C; body materials: chrome-plated brass, stainless steel or Monel; diaphragm: stainless steel or Hastelloy; ECD compatible; leak rate < 1×10^-8 (He); ATEX and PED compliant; options: shut-off or metering valve, purge system (self or external), contact gauge or pressure transmitter.
12379 Compact single-stage cylinder pressure regulator (based on ISO 2503) for technical, medical, corrosive, laboratory and high-purity gases; compact design and high regulation accuracy; inlet (right): cylinder connection per DIN 477-1 or other standards on request; outlet: compression fitting or customer-specific connection; inlet and outlet pressure gauges Ø50 mm (DIN EN 837); 50 µm inlet filter; relief valve; gas purity up to 6.0; max inlet pressure up to 200 bar in specification, with ordering code variants L/H/300 for 70/210/300 bar inlet classes; outlet pressure ranges 1.5–30 bar (special ranges up to 60 bar possible); temperature -40 to +70 °C; body materials: chrome-plated brass, stainless steel or Monel; diaphragm: stainless steel or Hastelloy; ECD compatible; leak rate < 1×10^-8 (He); PED and ATEX compliant; options: shut-off or metering valve, purge system (self or external), contact gauge or pressure transmitter.
12504 Compact single-stage cylinder 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 (right) with cylinder connection per DIN 477-1 or DIN 477-5, alternatively 1/4" NPT-F; outlet: compression fitting or threaded fitting; inlet pressure gauge and 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: shut-off or metering valve, purge system (internal or external), contact gauge or pressure transmitter.
12524 Compact two-stage cylinder 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 cylinder pressure decreases. Features: compact design, high control accuracy, inlet (right) with cylinder connection per DIN 477-1 or DIN 477-5, alternatively 1/4" NPT-F; outlet: compression fitting or threaded fitting; inlet and outlet pressure gauges Ø 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: shut-off or metering valve, purge system (internal or external), contact gauge or pressure transmitter.
12684 Compact single-stage semi-automatic pressure control station (manifold) for two cylinders, designed for technical, medical, corrosive, laboratory and high-purity gases. Features automatic switchover via pressure difference between two connected cylinders — when one cylinder is depleted, the system automatically switches to the full cylinder. Equipped with 2 main single-stage pressure regulators (one per side), inlet and outlet pressure gauges (Ø 50 mm, DIN 837), 50 µm inlet filter and relief valve. Includes 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, purge system, contact gauge or pressure transmitter.
12714 Compact two-stage semi-automatic pressure control station (manifold) for two cylinders, designed for technical, medical, corrosive, laboratory and high-purity gases. Two-stage regulation ensures highly stable outlet pressure. Features automatic switchover via pressure difference — when one cylinder is depleted, the system automatically switches to the full cylinder. Equipped with 2 main two-stage pressure regulators (one per side), inlet and outlet pressure gauges (Ø 50 mm, DIN 837), 50 µm inlet filter and relief valve per stage. Includes 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, purge system, contact gauge or pressure transmitter.
13260 Automatic switching manifold Vulkan LabLine AM 35/300 Effect, chrome-plated. Complete on stainless steel base plate: 2× manifold regulator H20 Effect acc. to ISO 7291, 2× ND-purge valves, 1× in-line regulator AD 35, 1× automatic change-over block, 1× main shut-off valve, without contact gauge. Inlet max 300 bar, outlet 0–10 bar, max flow 50 Nm³/h at 10 bar. Stainless steel diaphragm, gas purity up to 5.0. Dimensions: 450 × 420 × 210 mm.
13267 Automatic switching manifold Vulkan LabLine AM 35/300 K Effect, chrome-plated. Complete on stainless steel base plate: 2× manifold regulator H20 Effect acc. to ISO 7291, 2× ND-purge valves, 1× in-line regulator AD 35, 1× automatic change-over block, 1× main shut-off valve, 2× contact gauges with Reed switch. Inlet max 300 bar, outlet 0–10 bar, max flow 50 Nm³/h at 10 bar. Stainless steel diaphragm, gas purity up to 5.0. Dimensions: 450 × 420 × 210 mm.