Sandbox

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 (
    13310, 13311, 13312, 13313, 13304, 13305, 
    12349, 12364, 12259, 12504, 12524, 
    12379
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00082

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 (13310,13311,13312,13313,13304,13305,12349,12364,12259,12504,12524,12379)) 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.
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.
13304		Connecting pipe Vareo VU 2×bent (offset), 300 mm. Copper tube, DN10, PN300. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Manifold station → automatic manifold, for cylinders.
13305		Connecting pipe Vareo VU 2×bent (offset) Acetylene, 400 mm. Steel tube, DN10, PN26. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Manifold station → automatic manifold, for cylinders.
13310		Connecting pipe Vareo VP straight, 900 mm. Copper tube, DN10, PN300. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Between two manifold stations, for bundles.
13311		Connecting pipe Vareo VP straight Acetylene, 900 mm. Steel tube, DN10, PN26. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Between two manifold stations, for bundles.
13312		Connecting pipe Vareo VPU 2×bent (offset), 900 mm. Copper tube, DN10, PN300. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Manifold station → automatic manifold, for bundles.
13313		Connecting pipe Vareo VPU 2×bent (offset) Acetylene, 900 mm. Steel tube, DN10, PN26. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Manifold station → automatic manifold, for bundles.