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

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "8.41"
    },
    "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": 12,
      "rows_produced_per_join": 12,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_ult_product_descriptions`.`company_id` = 1) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`product_id` in (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": "7.21",
        "eval_cost": "1.20",
        "prefix_cost": "8.41",
        "data_read_per_join": "45K"
      },
      "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.
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.
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.