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, 12349, 12364, 12259, 12504, 
    12524, 12379, 12594, 12609, 12424, 
    12554
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00061

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,12349,12364,12259,12504,12524,12379,12594,12609,12424,12554)) 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
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.
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>
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.
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.
12594 Compact single-stage line fine pressure regulator type Omega I in accordance with ISO 2503 for technical, medical, corrosive, laboratory and high-purity gases. Designed for precise millibar-range outlet pressure control. Features: compact design with high control accuracy; inlet and outlet: 1/4" NPT-F, alternatively compression fitting; outlet pressure gauge Ø 63 mm; 50 µm inlet filter; relief valve; 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, shut-off or metering valve, gas purging system (internal or external), contact gauge or pressure transmitter.
12609 Compact two-stage line fine pressure regulator type Omega II in accordance with ISO 2503 for technical, medical, corrosive, laboratory and high-purity gases. Two-stage design provides exceptionally stable millibar-range outlet pressure. Features: compact design with high control accuracy; inlet and outlet: 1/4" NPT-F, alternatively compression fitting; outlet pressure gauge Ø 63 mm; 50 µm inlet filter; 2 relief valves (one 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, shut-off or metering valve, gas purging 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.