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 (
    6949, 13298, 13299, 13300, 13301, 13124, 
    13125, 13126, 13098, 13105, 13112, 
    13118
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00057

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 (6949,13298,13299,13300,13301,13124,13125,13126,13098,13105,13112,13118)) 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
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>
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.
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.