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 (
    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_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00084

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 (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_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
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.
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.
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.
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.