Sandbox

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 (
    6949, 13298, 13299, 13300, 13301, 13124, 
    13125, 13126, 13098, 13105, 13112, 
    13118, 13064, 13071, 13078, 13085, 
    13091, 13314, 13316, 13315, 13317, 
    13318, 12956, 12958
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00075

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "16.81"
    },
    "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": "((`test2_gaseus`.`cscart_ult_product_descriptions`.`company_id` = 1) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`product_id` in (6949,13298,13299,13300,13301,13124,13125,13126,13098,13105,13112,13118,13064,13071,13078,13085,13091,13314,13316,13315,13317,13318,12956,12958)) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "14.41",
        "eval_cost": "2.40",
        "prefix_cost": "16.81",
        "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
6949		<p>acc to DIN EN ISO 2503, class 10, single stage, with double flowmeter for exact control of the flow in Nl/min, with high pressure compensation for constant working pressure with safety gauge acc. to ISO 5171, with shut off valveinlet pressure max: 200 bar</p><p>outlet pressure: 1,5 bar pre adjusted<br><br>flow: 2 x 2-23 Nl/min. adjustable<br><br>inlet: W 24,32x1/14 RH nut acc. to DIN 477-1, no. 1<br><br>outlet: 2x G 1/4 RHk x 6 mm tail-piece acc. EN 560<br><br>inlet gauge: 0 – 315/200 bar<br><br>width x height x depth: 250 x 230 x 130 mm<br><br>with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape</p>
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.
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.
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.
13298		Manifold station Modula Vareo VS for oxygen, inert and fuel gases (except acetylene). Vareo distribution block with 2 inlets M 24×1.5 RH for connecting 2 cylinders or bundles up to 300 bar. Equipped with 2 sinter filters, 2 non-return valves (NRV), 2 shut-off valves, and 2 connections for additional manifold stations or base station Vareo. Fully assembled on base plate. Material: brass. Dimensions: 195 × 205 × 240 mm.
13299		Manifold station Modula Vareo VS for acetylene. Vareo distribution block with 2 inlets W 21.8×1/14 LH for connecting 2 cylinders or bundles up to 300 bar. Equipped with 2 sinter filters, 2 non-return valves (NRV), 2 shut-off valves, and 2 connections for additional manifold stations or base station Vareo. Fully assembled on base plate. Material: brass. Dimensions: 195 × 205 × 240 mm.
13300		Manifold station Modula Vareo VSD for oxygen, inert and fuel gases (except acetylene). Without non-return valve and sinter filter. Vareo distribution block with 2 inlets M 24×1.5 RH for connecting 2 cylinders or bundles up to 300 bar. 2 shut-off valves and 2 connections for additional manifold stations or base station Vareo. Fully assembled on base plate. Material: brass. Dimensions: 195 × 205 × 240 mm.
13301		Manifold station Modula Vareo VSL for oxygen, inert and fuel gases (except acetylene). Without shut-off valve. Vareo distribution block with 2 inlets M 24×1.5 RH for connecting 2 cylinders or bundles up to 300 bar. 2 sinter filters, 2 non-return valves and 2 connections for additional manifold stations or base station Vareo. Fully assembled on base plate. Material: brass. Dimensions: 195 × 205 × 240 mm.
13314		Purge valve Vareo for Vareo VS/BS with clamp ring compression fitting 10 mm. For purging one inlet on the Vareo block, integrated in Vareo distribution block. Complete with clamp ring compression fitting 10 mm at outlet for blow-off pipe connection. Note: when retrofitting into Vareo block, the spindle must be set and checked for tightness.
13315		Purge valve Vareo for Vareo VS/BS with angle valve EV UM M24×1.5RH-16S, for all technical gases except acetylene. Inlet: U-nut M 24×1.5 RH.
13316		Purge valve Vareo for Vareo VS/BS with angle valve EV UM M24×1.5RH-16S, for acetylene. Inlet: U-nut M 24×1.5 RH.
13317		Rail system Vulkan Modula FN 1-cylinder with non-return valve, left mounting. 1 inlet M 24×1.5 RH with non-return valve and sinter filter. Brass body, max 300 bar. Width: 125 mm.
13318		Rail system Vulkan Modula FN 1-cylinder with non-return valve, right mounting. 1 inlet M 24×1.5 RH with non-return valve and sinter filter. Brass body, max 300 bar. Width: 125 mm.