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 (
    13124, 13125, 13126, 13098, 13105, 13112, 
    13118, 13064, 13071, 13078, 13085, 
    13091, 12956, 12958, 13014, 13028, 
    13040, 13052, 12960, 12974, 12988, 
    13000, 12926, 12942
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00100

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 (13124,13125,13126,13098,13105,13112,13118,13064,13071,13078,13085,13091,12956,12958,13014,13028,13040,13052,12960,12974,12988,13000,12926,12942)) 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
12926 Single-cylinder manifold station Vulkan TecLine SE10/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator H10 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 0–10 bar adjustable. Max. flow 50 Nm³/h at 10 bar. With standard pressure gauges. Dimensions: 420 × 260 × 110 mm, 4.5 kg.
12942 Single-cylinder manifold station Vulkan TecLine SE20/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator H20 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 0–20 bar adjustable. Max. flow 75 Nm³/h at 20 bar. With standard pressure gauges. Dimensions: 420 × 320 × 110 mm, 5.0 kg.
12956 Single-bundle acetylene manifold station Vulkan TecLine EB10 (with standard gauges). Complete on stainless steel base plate, acc. to ISO 14114, with HA10 regulator acc. to ISO 7291, automatic quick cut-off valve acc. to ISO 15615, flashback arrestor acc. to ISO 5175, and main shut-off valve. Manual switching. Inlet pressure max 26 bar, outlet pressure 0–1.5 bar. Max. flow 10 Nm³/h at 1.5 bar. Dimensions: 700 × 190 × 160 mm, 14 kg.
12958 Single-bundle acetylene manifold station Vulkan TecLine EB20 (with standard gauges). Complete on stainless steel base plate, acc. to ISO 14114, with HA10/H20 regulator acc. to ISO 7291, automatic quick cut-off valve acc. to ISO 15615, flashback arrestor acc. to ISO 5175, and main shut-off valve. Manual switching. Inlet pressure max 26 bar, outlet pressure 0–1.5 bar. Max. flow 18 Nm³/h at 1.5 bar. Dimensions: 970 × 190 × 160 mm, 16 kg.
12960 Single-bundle manifold station Vulkan TecLine EB60/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator H20 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 0–20 bar. Max. flow 75 Nm³/h at 20 bar. With standard pressure gauges. Dimensions: 420 × 320 × 110 mm, 5.0 kg.
12974 Single-bundle manifold station Vulkan TecLine EB70/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR40 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 0–40 bar. Max. flow 120 Nm³/h at 40 bar. With standard pressure gauges. Dimensions: N/A mm, N/A kg.
12988 Single-bundle manifold station Vulkan TecLine EB75/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR60 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 0–60 bar. Max. flow 140 Nm³/h at 60 bar. With standard pressure gauges. Dimensions: 370 × 280 × 110 mm, N/A kg.
13000 Single-bundle manifold station Vulkan TecLine EB80/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR20 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 0–20 bar. Max. flow 170 Nm³/h at 20 bar. With standard pressure gauges. Dimensions: 440 × 350 × 130 mm, N/A kg.
13014 Single-bundle manifold station Vulkan TecLine EB100/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR40 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 15–40 bar. Max. flow 290 Nm³/h at 40 bar. With standard pressure gauges. Dimensions: 440 × 370 × 130 mm, N/A kg.
13028 Single-bundle manifold station Vulkan TecLine EB120/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR60 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 15–60 bar. Max. flow 450 Nm³/h at 60 bar. With standard pressure gauges. Dimensions: N/A mm, N/A kg.
13040 Single-bundle manifold station Vulkan TecLine EB200/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR200 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 15–200 bar. Max. flow 480 Nm³/h at 200 bar. With standard pressure gauges. Dimensions: 390 × 240 × 240 mm, N/A kg.
13052 Single-bundle manifold station Vulkan TecLine EB270/300. Complete on stainless steel base plate, with HP shut-off valve, manifold fin regulator HR270 acc. to ISO 7291 (adiabatic compression tested), and main shut-off valve. Manual switching. Inlet pressure max 300 bar, outlet pressure 15–270 bar. Max. flow 480 Nm³/h at 270 bar. With standard pressure gauges. Dimensions: 390 × 240 × 240 mm, N/A kg.
13064 Manual manifold base station Vulkan TecLine BS 50/300. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator H10 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 0–10 bar. Max. flow 50 Nm³/h at 10 bar. Dimensions: 570 × 250 × 210 mm, 10 kg.
13071 Manual manifold base station Vulkan TecLine BS 60/300 Effect. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator H20 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Also available with incorporated gas pre-heater GPH 200 or GPH 400. Inlet max 300 bar, outlet 0–20 bar. Max. flow 75 Nm³/h at 20 bar. Dimensions: 570 × 250 × 210 mm, 10 kg.
13078 Manual manifold base station Vulkan TecLine BS 70/300 Effect. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator HR40 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 0–40 bar. Max. flow 120 Nm³/h at 40 bar. Dimensions: 570 × 250 × 210 mm, 10 kg.
13085 Manual manifold base station Vulkan TecLine BS 75/300 Effect. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator HR60 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 0–60 bar. Max. flow 140 Nm³/h at 60 bar. Dimensions: 570 × 250 × 210 mm, 10 kg.
13091 Manual manifold base station Vulkan TecLine BS 80/300 Effect. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator HR20 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 0–20 bar. Max. flow 170 Nm³/h at 20 bar. Dimensions: 590 × 250 × 210 mm, 11 kg.
13098 Manual manifold base station Vulkan TecLine BS 100/300 Effect. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator HR40 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 15–40 bar. Max. flow 290 Nm³/h at 40 bar. Dimensions: 590 × 270 × 210 mm, 14 kg.
13105 Manual manifold base station Vulkan TecLine BS 120/300 Effect. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold fin regulator HR60 Effect acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 15–60 bar. Max. flow 450 Nm³/h at 60 bar. Dimensions: 590 × 270 × 210 mm, 14 kg.
13112 Manual manifold base station Vulkan TecLine BS 200/300. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold manifold regulator LHR 300/200 acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 15–200 bar. Max. flow 480 Nm³/h at 200 bar. Dimensions: 590 × 330 × 285 mm, 12 kg.
13118 Manual manifold base station Vulkan TecLine BS 270/300. Modular add-on system (Modula Vareo). Complete on stainless steel base plate: 1× distributing block Modula Vareo (2 inlets, shut-off valves, non-return valves, sinter-metal filters), 1× manifold manifold regulator acc. to ISO 7291 (adiabatic compression tested), 1× main shut-off valve. Manual switching. Inlet max 300 bar, outlet 15–270 bar. Max. flow 480 Nm³/h at 270 bar. Dimensions: 590 × 330 × 285 mm, 12 kg.
13124 Manual manifold base station for acetylene bundles Vulkan TecLine BSA 10 B. Complete on stainless steel base plate acc. to ISO 14114: 1× distributing block Modula Vareo with automatic quick cut-off valve acc. to ISO 15615, 1× flashback arrestor acc. to ISO 5175, 1× manifold fin regulator HA10 acc. to ISO 7291, 1× main shut-off valve. Manual switching. Inlet max 26 bar, outlet 0–1.5 bar. Max. flow 10 Nm³/h. Dimensions: 850 × 250 × 210 mm, 15 kg.
13125 Manual manifold base station for acetylene bundles Vulkan TecLine BSA 20 B. Complete on stainless steel base plate acc. to ISO 14114: 1× distributing block Modula Vareo with automatic quick cut-off valve acc. to ISO 15615, 1× flashback arrestor acc. to ISO 5175, 1× manifold regulator H20 acetylene acc. to ISO 7291, 1× main shut-off valve. Manual switching. Inlet max 26 bar, outlet 0–1.5 bar. Max. flow 18 Nm³/h. Dimensions: 980 × 250 × 230 mm, 19 kg.
13126 Manual manifold base station for acetylene bundles Vulkan TecLine BSA 40 B. Complete on stainless steel base plate acc. to ISO 14114: 1× distributing block Modula Vareo with automatic quick cut-off valve acc. to ISO 15615, 1× flashback arrestor acc. to ISO 5175, 1× manifold fin regulator HA40 acc. to ISO 7291, 1× main shut-off valve. Manual switching. Inlet max 26 bar, outlet 0–1.5 bar. Max. flow 38 Nm³/h. Dimensions: 980 × 275 × 210 mm, 26 kg.