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 (
    13302, 13303, 13308, 13309, 13306, 13307, 
    13310, 13311, 13312, 13313, 13304, 
    13305, 13319, 13298, 13299, 13300, 
    13301, 13314, 13316, 13315, 13317, 
    13318
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00056

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "15.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": 22,
      "rows_produced_per_join": 22,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_ult_product_descriptions`.`company_id` = 1) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`product_id` in (13302,13303,13308,13309,13306,13307,13310,13311,13312,13313,13304,13305,13319,13298,13299,13300,13301,13314,13316,13315,13317,13318)) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "13.21",
        "eval_cost": "2.20",
        "prefix_cost": "15.41",
        "data_read_per_join": "83K"
      },
      "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
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.
13302 Connecting pipe Vareo VB 90° bent, 2 × 150 mm. Copper tube, DN10, PN300. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Manifold station → base station, for cylinders.
13303 Connecting pipe Vareo VB 90° bent Acetylene, 2 × 150 mm. Steel tube, DN10, PN300. Inlet: M 24×1.5 RH U-nut. Outlet: W 21.8×1/14 LH U-nut. Manifold station → base station, for cylinders.
13304 Connecting pipe Vareo VU 2×bent (offset), 300 mm. Copper tube, DN10, PN300. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Manifold station → automatic manifold, for cylinders.
13305 Connecting pipe Vareo VU 2×bent (offset) Acetylene, 400 mm. Steel tube, DN10, PN26. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Manifold station → automatic manifold, for cylinders.
13306 Connecting pipe Vareo VF straight, 400 mm. Copper tube, DN10, PN300. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Between two manifold stations, for cylinders.
13307 Connecting pipe Vareo VF straight Acetylene, 400 mm. Steel tube, DN10, PN26. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Between two manifold stations, for cylinders.
13308 Connecting pipe Vareo VBP 90° bent, 900 × 150 mm. Copper tube, DN10, PN300. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Manifold station → base station, for bundles.
13309 Connecting pipe Vareo VBP 90° bent Acetylene, 900 × 150 mm. Steel tube, DN10, PN300. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Manifold station → base station, for bundles.
13310 Connecting pipe Vareo VP straight, 900 mm. Copper tube, DN10, PN300. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Between two manifold stations, for bundles.
13311 Connecting pipe Vareo VP straight Acetylene, 900 mm. Steel tube, DN10, PN26. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Between two manifold stations, for bundles.
13312 Connecting pipe Vareo VPU 2×bent (offset), 900 mm. Copper tube, DN10, PN300. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Manifold station → automatic manifold, for bundles.
13313 Connecting pipe Vareo VPU 2×bent (offset) Acetylene, 900 mm. Steel tube, DN10, PN26. Inlet: M 24×1.5 RH U-nut. Outlet: M 24×1.5 RH U-nut. Manifold station → automatic manifold, for bundles.
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.