SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (
    3452, 3478, 3479, 3453, 3491, 3488, 3497, 
    3495, 3489, 3492, 3496, 3490, 3494, 
    6951, 3502, 3503, 3493, 3498, 3428, 
    22, 23, 24, 3933, 3934
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00061

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "18.94"
    },
    "table": {
      "table_name": "cscart_ult_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id",
        "company_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code",
        "company_id"
      ],
      "key_length": "13",
      "rows_examined_per_scan": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "index_condition": "((`gaseus`.`cscart_ult_product_descriptions`.`company_id` = 1) and (`gaseus`.`cscart_ult_product_descriptions`.`product_id` in (3452,3478,3479,3453,3491,3488,3497,3495,3489,3492,3496,3490,3494,6951,3502,3503,3493,3498,3428,22,23,24,3933,3934)) and (`gaseus`.`cscart_ult_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "16.54",
        "eval_cost": "2.40",
        "prefix_cost": "18.94",
        "data_read_per_join": "91K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "company_id",
        "short_description",
        "full_description",
        "meta_keywords",
        "meta_description",
        "search_words",
        "promo_text"
      ]
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
22 <p>In-line dome pressure reducer Vulkan LD1 MD on both sides. G 1 RHi, single-stage design, without pressure gauge. Maximum inlet pressure: 100 bar (oxygen max. 40 bar!). Output pressure: 0.5 - 99 bar adjustable (oxygen 0.5 - 39 bar!). Maximum output: 2,400 Nm³/h (oxygen 2,100 Nm³/h). Inlet and outlet: G1RHi. Width x height x depth: 130 x 170 x 130 mm. Optionally also available with control pressure reducer. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108535 (pe max. 40 bar pa 0.5 - 39 bar!). CO2/Argon: Item No. 106535. Helium: Item No. 10653526Nitrogen: Item no. 103535Hydrogen: Item no. 104535Compressed air: Item no. 107535</p>
23 <p>In-line dome pressure reducer Vulkan LD1 MD on both sides. G 1 RHi, single-stage design, without pressure gauge. Maximum inlet pressure: 100 bar (oxygen max. 40 bar!). Output pressure: 0.5 - 99 bar adjustable (oxygen 0.5 - 39 bar!). Maximum output: 2,400 Nm³/h (oxygen 2,100 Nm³/h). Inlet and outlet: G1RHi. Width x height x depth: 130 x 170 x 130 mm. Optionally also available with control pressure reducer. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108535 (pe max. 40 bar pa 0.5 - 39 bar!). CO2/Argon: Item No. 106535. Helium: Item No. 10653526Nitrogen: Item no. 103535Hydrogen: Item no. 104535Compressed air: Item no. 107535</p>
24 <p>In-line dome pressure reducer Vulkan LD1 MD on both sides. G 1 RHi, single-stage design, without pressure gauge. Maximum inlet pressure: 100 bar (oxygen max. 40 bar!). Output pressure: 0.5 - 99 bar adjustable (oxygen 0.5 - 39 bar!). Maximum output: 2,400 Nm³/h (oxygen 2,100 Nm³/h). Inlet and outlet: G1RHi. Width x height x depth: 130 x 170 x 130 mm. Optionally also available with control pressure reducer. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108535 (pe max. 40 bar pa 0.5 - 39 bar!). CO2/Argon: Item No. 106535. Helium: Item No. 10653526Nitrogen: Item no. 103535Hydrogen: Item no. 104535Compressed air: Item no. 107535</p>
3428 according to drawing no. 95 100 130, with inlet pressure gauge and shut-off valve,Inlet pressure max: 12 bar<br />Outlet pressure: fixed at approx. 0.5 - 0.7 bar<br />Inlet: 7/16" x 28 NS2<br />Output: compression fitting 4 mm Ms nickel-plated<br />Inlet pressure gauge: 0 - 16 bar<br />Output pressure gauge: without (no connection available)<br />With flyer provided by Linde - Linde #43586000<br />Accessory pack: bag with 3 O-rings #11207000<br /><br />Minimum order quantity 300 pieces
3452 <p>acc to DIN EN ISO 2503, class 3, single stage, with safety gauges acc. to DIN ISO 5171,</p><p>with shut off valve<br><br>inlet pressure max: 200 bar<br><br>outlet pressure: 0 - 30 Nl/min. (0 – 10 bar) adjustable<br><br>flow max: 30 Nl/min. at 10 bar outlet pressure <br><br>inlet connection: W 21,8x1/14 LH nut acc. to DIN 477-1, no. 1<br><br>outlet connection: G 3/8 LHk x 9 mm tail-piece acc. EN560<br><br>inlet gauge: 0 – 315 /200 bar<br><br>working gauge: 0 – 30 Nl/min.<br><br>width x height x depth: 210 x 190 x 75 mm<br><br>with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape</p>
3453 <p>acc to DIN EN ISO 2503, class 3, single stage, with safety gauges acc. to DIN ISO 5171,</p><p>with shut off valve<br><br>inlet pressure max: 200 bar<br><br>outlet pressure: 0 - 50 Nl/min. (0 – 10 bar) adjustable<br><br>flow max: 50 Nl/min. at 10 bar outlet pressure <br><br>inlet connection: W 21,8x1/14 LH nut acc. to DIN 477-1, no. 1<br><br>outlet connection: G 3/8 LHk x 9 mm tail-piece acc. EN560<br><br>inlet gauge: 0 – 315 /200 bar<br><br>working gauge: 0 – 50 Nl/min.<br><br>width x height x depth: 210 x 190 x 75 mm<br><br>with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape</p>
3478 acc to DIN EN ISO 2503, class 3, single stage, with safety gauges acc. to DIN ISO 5171, with shut off valve,inlet pressure max: 200 bar<br />outlet pressure: 0 – 10 bar <br />flow: 0 – 30 Nl/min. adjustable<br />inlet connection: W 21,8x1/14 RH nut acc. to DIN 477-1, no. 6<br />outlet connection: G 1/4RH x 6mm tail-piece<br />inlet gauge: 0 – 315/200 bar<br />working gauge: 0 – 30 Nl/min. (0 - 10 bar)<br />width x height x depth: 210 x 190 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde tape
3479 acc to DIN EN ISO 2503, class 3, single stage, with safety gauges acc. to DIN ISO 5171inlet pressure max: 200 bar<br />outlet pressure: 0-10 bar<br />flow: 0 – 20 Nl/min. adjustable<br />Inlet connection: W 21,8x1/14 RH nut acc. to DIN 477-1, no. 6<br />outlet connection: G 1/4 RHk x 6 mm tailpiece acc. to EN 560<br />inlet gauge: 0 – 315/200 bar<br />outlet gauge: 0 – 30 Nl/min. double scale Ar/CO2 (0 - 10 bar)<br />width x height x depth: 210 x 230 x 75 mm <br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3488 according to ISO 2503, class 3,single stage with high-pressure compensation, with safety gauges according to ISO 5171, including shut off valveinlet pressure max.: 300 bar<br />working pressure: 0 - 10 bar adjustable <br />flow max. 48 Nm³/h compressed air at 10 bar working pressure<br />inlet connection: W 30x2 RH acc. to DIN 477-5, no. 54<br />outlet connection: G 1/4 RH x 6 mm acc. to EN 560<br />cylinder gauge 0 - 400/300 bar<br />working gauge: 0 - 16/10 bar<br />width x height x depth: 210 x 190 x 75 mm <br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3489 acc. to ISO 2503, single stage with safety gauges acc. to EN562inlet pressure max:300 bar<br />outlet pressure: 10 - 100 bar adjustable<br />flow max:380 Nm³/h at 50 bar outlet pressure <br />inlet connection: W 30x2 RH nut acc. to DIN 477-5, no. 54<br />outlet connection: W 24,32x1/14 RH male DIN 477-1, no. 10<br />inlet gauge: 0 – 400/300 bar<br />working gauge: 0 – 160/100 bar<br />width x height x depth: 170 x 140 x 180 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3490 acc. to ISO 2503, single stage with safety gauges acc. to ISO5171inlet pressure max: 300 bar<br />outlet pressure: 10 - 300 bar adjustable<br />flow max: 380 Nm³/h at 50 bar outlet pressure <br />inlet connection: W 30x2 RH nut acc. to DIN 477-5, no. 54<br />outlet connection: W 24,32x1/14 RH male DIN 477-1, no. 10<br />inlet gauge: 0 – 400/300 bar<br />working gauge: 0 – 315/200 bar<br />width x height x depth: 170 x 140 x 180 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3491 acc. to ISO 2503, class3, with high pressure compensation, single stage with safety gauges acc. to DIN ISO 5171inlet pressure max:300 bar<br />outlet pressure: 0 – 10 bar adjustable<br />flow max: 48 Nm³/h at 10 bar outlet pressure<br />inlet connection: W 30x2LHk nut acc. to DIN 477-5, Nr. 57<br />outlet connection: G 3/8 LHk x 9mm tail-piece acc. to DIN EN 560<br />inlet gauge: 0 – 400 / 300 bar<br />working gauge: 0 – 16/10 bar<br />width x height x depth: 210 x 190 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3492 acc. to ISO 2503, class 5, single stage, with high pressure compensation for constant working pressure, with safety gauges acc. to ISO 5171, with shut off valve,inlet pressure max.: 300 bar<br />outlet pressure: 0 – 20 bar adjustable<br />flow max.: 75 Nm³/h air at 10 bar working pressure<br />Inlet connection: W30x2LH nut acc. to DIN 477-5 no. 57<br />outlet connection: G 3/8 LHk x 9 mm tailpiece acc. to EN 560<br />inlet gauge: 0 - 400/300 bar<br />working gauge: 0 - 40/20 bar<br />width x height x depth: 210 x 210 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3493 <p>acc to DIN EN ISO 2503, class 3, single stage, with safety gauges acc. to DIN ISO 5171,</p><p>with shut off valve<br><br>inlet pressure max: 200 bar<br><br>outlet pressure: 0 - 50 Nl/min. (0 – 10 bar) adjustable<br><br>flow max: 50 Nl/min. at 10 bar outlet pressure <br><br>inlet connection: W 30x2 LH nut acc. to DIN 477-5 no. 57<br><br>outlet connection: G 3/8 LHk x 9 mm tail-piece acc. EN560<br><br>inlet gauge: 0 – 400/300 bar<br><br>working gauge: 0 – 50 Nl/min.<br><br>width x height x depth: 210 x 190 x 75 mm<br><br>with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape</p>
3494 <p>acc to DIN EN ISO 2503, single stage, with high pressure compensation for a constant working pressure on falling inlet pressure with safety gauges acc. to DIN ISO 5171inlet pressure max: 200 bar</p><p>outlet pressure: 0 – 60 bar adjustable<br><br>flow max: 140 Nm³/h at 60 bar working pressure<br><br>inlet connection: W30x2 RHf nut acc. to DIN 477-5, no. 54<br><br>outlet connection: G 1/4RHak acc. to EN560<br><br>inlet gauge: 0 – 400/300 bar<br><br>working gauge: 0 – 100/60 bar<br><br>width x height x depth: 210 x 210 x 75 mm<br><br>with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape</p>
3495 acc. to ISO 2503, single stage with safety gauges acc. to ISO 5171inlet pressure max:300 bar<br />outlet pressure: 10 - 100 bar adjustable<br />flow max: 380 Nm³/h at 50 bar outlet pressure <br />inlet connection: W 30x2 RH nut acc. to DIN 477-5, no. 54<br />outlet connection: W 21,8x1/14 RH male DIN 477-1, no. 6<br />inlet gauge: 0 – 400/300 bar<br />working gauge: 0 – 160/100 bar<br />width x height x depth: 170 x 140 x 180 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3496 acc. to ISO 2503, single stage with safety gauges acc. to EN562inlet pressure max: 300 bar<br />outlet pressure: 10 - 300 bar adjustable<br />flow max:380 Nm³/h at 50 bar outlet pressure <br />inlet connection: W 30x2 RH nut acc. to DIN 477-5, no. 54<br />outlet connection: W 21,8x1/14 RH male DIN 477-1, no. 6<br />inlet gauge: 0 – 400/300 bar<br />working gauge: 0 – 315/200 bar<br />width x height x depth: 170 x 140 x 180 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3497 according to ISO 2503, class 3, adiabatic compression tested, single stage with high-pressure compensation, with safety gauges according to ISO 5171, including shut off valveinlet pressure max.: 300 bar<br />working pressure: 0 - 10 bar adjustable <br />flow max. 48 Nm³/h compressed air at 10 bar working pressure<br />inlet connection: W 30x2 RH acc. to DIN 477-5, no. 59<br />outlet connection: G 1/4 RH x 6 mm acc. to EN 560<br />cylinder gauge 0 - 400/300 bar<br />working gauge: 0 - 16/10 bar<br />width x height x depth: 210 x 190 x 75 mm <br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3498 acc. to ISO 2503, single stage with safety gauges acc. to EN562inlet pressure max:300 bar<br />outlet pressure: 10 - 100 bar adjustable<br />flow max:380 Nm³/h at 50 bar outlet pressure <br />inlet connection: W 30x2 RH nut acc. to DIN 477-5, no. 59<br />outlet connection: G3/4RHf male DIN 477-1, no. 9<br />inlet gauge: 0 – 400/300 bar<br />working gauge: 0 – 160/100 bar<br />width x height x depth: 170 x 140 x 180 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3502 <p>acc to ISO2503, single stage, with flowmeter for exact control of the flow in Nl/min, TÜV – approved following Pressure equipment Directive 97/23/EG with high pressure compensation for constant working pressure with safety gauge acc. to ISO 5171, with shut off valveinlet pressure max: 300 bar</p><p>outlet pressure: 1,5 bar pre adjusted<br><br>flow: 2 – 23 Nl/min. adjustable<br><br>inlet: W 30x2 LH nut acc. to DIN 477-5<br><br>outlet: G 3/8 LHk x 9 mm tail-piece acc. EN 560<br><br>inlet gauge: 0 – 400/300 bar<br><br>width x height x depth:: 210 x 230 x 75 mm</p>
3503 acc to DIN EN ISO 2503, class 3, single stage, with safety gauges acc. to DIN ISO 5171, with shut off valve,inlet pressure max: 300 bar<br />outlet pressure: 0 – 10 bar <br />flow: 0 – 30 Nl/min. adjustable<br />inlet connection: W 30x2 RH nut acc. to DIN 477-5, no. 54<br />outlet connection: G 1/4RH x 6mm tail-piece<br />inlet gauge: 0 – 400/300 bar<br />working gauge: 0 – 30 Nl/min. (0 - 10 bar)<br />width x height x depth: 210 x 190 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde tape
3933 <p>In-line dome pressure reducer Vulkan LD1 MD on both sides. G 1 RHi, single-stage design, without pressure gauge. Maximum inlet pressure: 100 bar (oxygen max. 40 bar!). Output pressure: 0.5 - 99 bar adjustable (oxygen 0.5 - 39 bar!). Maximum output: 2,400 Nm³/h (oxygen 2,100 Nm³/h). Inlet and outlet: G1RHi. Width x height x depth: 130 x 170 x 130 mm. Optionally also available with control pressure reducer. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108535 (pe max. 40 bar pa 0.5 - 39 bar!). CO2/Argon: Item No. 106535. Helium: Item No. 10653526Nitrogen: Item no. 103535Hydrogen: Item no. 104535Compressed air: Item no. 107535</p>
3934 <p>In-line dome pressure reducer Vulkan LD1 MD on both sides. G 1 RHi, single-stage design, without pressure gauge. Maximum inlet pressure: 100 bar (oxygen max. 40 bar!). Output pressure: 0.5 - 99 bar adjustable (oxygen 0.5 - 39 bar!). Maximum output: 2,400 Nm³/h (oxygen 2,100 Nm³/h). Inlet and outlet: G1RHi. Width x height x depth: 130 x 170 x 130 mm. Optionally also available with control pressure reducer. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108535 (pe max. 40 bar pa 0.5 - 39 bar!). CO2/Argon: Item No. 106535. Helium: Item No. 10653526Nitrogen: Item no. 103535Hydrogen: Item no. 104535Compressed air: Item no. 107535</p>
6951 acc to EN 13918, class 10, single stage, with flowmeter for exact control of the flow in Nl/min, TÜV – approved following Pressure equipment Directive 97/23/EG with high pressure compensation for constant working pressure with safety gauge acc. to ISO 5171, with shut off valveinlet pressure max: 300 bar<br />outlet pressure: 1,5 bar pre adjusted<br />flow: 4 – 32 Nl/min. adjustable<br />inlet: W 30x2 RH nut acc. to DIN 477-5<br />outlet: G 1/4 RHk x 6 mm tail-piece acc. EN 560<br />inlet gauge: 0 – 400/300 bar<br />width x height x depth:: 210 x 230 x 75 mm