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 (
    13319, 13298, 13299, 13300, 13301, 13314, 
    13316, 13315, 13317, 13318
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00033

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.11"
    },
    "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": 10,
      "rows_produced_per_join": 10,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_product_descriptions`.`product_id` in (13319,13298,13299,13300,13301,13314,13316,13315,13317,13318)) and (`test2_gaseus`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "9.11",
        "eval_cost": "1.00",
        "prefix_cost": "10.11",
        "data_read_per_join": "45K"
      },
      "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
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.
13319		Cylinder rack Vulkan Modula for securing gas cylinders against tipping. Fully stainless steel construction with wall fixture, chain with snap hook, and edge protection. For 1 cylinder. Width: 280 mm.