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 (
    3432, 22, 23, 24, 3933, 3934, 3935, 1334, 
    1335, 1336, 1337, 1338
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00037

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "9.47"
    },
    "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": "((`gaseus`.`cscart_ult_product_descriptions`.`company_id` = 1) and (`gaseus`.`cscart_ult_product_descriptions`.`product_id` in (3432,22,23,24,3933,3934,3935,1334,1335,1336,1337,1338)) and (`gaseus`.`cscart_ult_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "8.27",
        "eval_cost": "1.20",
        "prefix_cost": "9.47",
        "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
22 <p>In-line dome pressure reducer Vulkan LD1 MD on both sides. G 1 RHi, single-stage design, without pressure gauge. Maximum inlet pressure: 100 bar (oxygen max. 40 bar!). Output pressure: 0.5 - 99 bar adjustable (oxygen 0.5 - 39 bar!). Maximum output: 2,400 Nm³/h (oxygen 2,100 Nm³/h). Inlet and outlet: G1RHi. Width x height x depth: 130 x 170 x 130 mm. Optionally also available with control pressure reducer. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108535 (pe max. 40 bar pa 0.5 - 39 bar!). CO2/Argon: Item No. 106535. Helium: Item No. 10653526Nitrogen: Item no. 103535Hydrogen: Item no. 104535Compressed air: Item no. 107535</p>
23 <p>In-line dome pressure reducer Vulkan LD1 MD on both sides. G 1 RHi, single-stage design, without pressure gauge. Maximum inlet pressure: 100 bar (oxygen max. 40 bar!). Output pressure: 0.5 - 99 bar adjustable (oxygen 0.5 - 39 bar!). Maximum output: 2,400 Nm³/h (oxygen 2,100 Nm³/h). Inlet and outlet: G1RHi. Width x height x depth: 130 x 170 x 130 mm. Optionally also available with control pressure reducer. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108535 (pe max. 40 bar pa 0.5 - 39 bar!). CO2/Argon: Item No. 106535. Helium: Item No. 10653526Nitrogen: Item no. 103535Hydrogen: Item no. 104535Compressed air: Item no. 107535</p>
24 <p>In-line dome pressure reducer Vulkan LD1 MD on both sides. G 1 RHi, single-stage design, without pressure gauge. Maximum inlet pressure: 100 bar (oxygen max. 40 bar!). Output pressure: 0.5 - 99 bar adjustable (oxygen 0.5 - 39 bar!). Maximum output: 2,400 Nm³/h (oxygen 2,100 Nm³/h). Inlet and outlet: G1RHi. Width x height x depth: 130 x 170 x 130 mm. Optionally also available with control pressure reducer. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108535 (pe max. 40 bar pa 0.5 - 39 bar!). CO2/Argon: Item No. 106535. Helium: Item No. 10653526Nitrogen: Item no. 103535Hydrogen: Item no. 104535Compressed air: Item no. 107535</p>
1334 Vulkan LDS1 PN25 line dome pressure reducer with control pressure reducer, complete with control pressure reducer, material: brass/Viton, single-stage design, maximum inlet pressure: 25 bar, output pressure: 0.5 – 16 bar adjustable, maximum output: 1,100 Nm³/h air at 16 bar outlet pressure, input: internal thread G1RHi, output: internal thread G1RHi, input pressure gauge: optional (add in the selection window), output pressure gauge: optional (add in the selection window)
1335 Vulkan LDS1 PN25 line dome pressure reducer with control pressure reducer, complete with control pressure reducer, material: brass/Viton, single-stage design, maximum inlet pressure: 25 bar, output pressure: 0.5 – 16 bar adjustable, maximum output: 1,100 Nm³/h air at 16 bar outlet pressure, input: internal thread G1RHi, output: internal thread G1RHi, input pressure gauge: optional (add in the selection window), output pressure gauge: optional (add in the selection window)
1336 Vulkan LDS1 PN25 line dome pressure reducer with control pressure reducer, complete with control pressure reducer, material: brass/Viton, single-stage design, maximum inlet pressure: 25 bar, output pressure: 0.5 – 16 bar adjustable, maximum output: 1,100 Nm³/h air at 16 bar outlet pressure, input: internal thread G1RHi, output: internal thread G1RHi, input pressure gauge: optional (add in the selection window), output pressure gauge: optional (add in the selection window)
1337 Vulkan LDS1 PN25 line dome pressure reducer with control pressure reducer, complete with control pressure reducer, material: brass/Viton, single-stage design, maximum inlet pressure: 25 bar, output pressure: 0.5 – 16 bar adjustable, maximum output: 1,100 Nm³/h air at 16 bar outlet pressure, input: internal thread G1RHi, output: internal thread G1RHi, input pressure gauge: optional (add in the selection window), output pressure gauge: optional (add in the selection window)
1338 Vulkan LDS1 PN25 line dome pressure reducer with control pressure reducer, complete with control pressure reducer, material: brass/Viton, single-stage design, maximum inlet pressure: 25 bar, output pressure: 0.5 – 16 bar adjustable, maximum output: 1,100 Nm³/h air at 16 bar outlet pressure, input: internal thread G1RHi, output: internal thread G1RHi, input pressure gauge: optional (add in the selection window), output pressure gauge: optional (add in the selection window)
3432 <p>appropriate electrical equipment,marking: Ex II 1 G D [EEx ia] IIC, </p><p>to alarm and control in case of pressure drop, to connect 2 solenoid valves (230v 50Hz) and contact gauges with inductive contact, with integrated optical and acoustical signal, connection of additional external alarm possible, complete in box with potential free contact to connect contact gauges in explosive areas of group II, <br><br>box must be installed outside the explosive area, <br><br>power supply: 230V/ 50Hz</p>
3933 <p>In-line dome pressure reducer Vulkan LD1 MD on both sides. G 1 RHi, single-stage design, without pressure gauge. Maximum inlet pressure: 100 bar (oxygen max. 40 bar!). Output pressure: 0.5 - 99 bar adjustable (oxygen 0.5 - 39 bar!). Maximum output: 2,400 Nm³/h (oxygen 2,100 Nm³/h). Inlet and outlet: G1RHi. Width x height x depth: 130 x 170 x 130 mm. Optionally also available with control pressure reducer. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108535 (pe max. 40 bar pa 0.5 - 39 bar!). CO2/Argon: Item No. 106535. Helium: Item No. 10653526Nitrogen: Item no. 103535Hydrogen: Item no. 104535Compressed air: Item no. 107535</p>
3934 <p>In-line dome pressure reducer Vulkan LD1 MD on both sides. G 1 RHi, single-stage design, without pressure gauge. Maximum inlet pressure: 100 bar (oxygen max. 40 bar!). Output pressure: 0.5 - 99 bar adjustable (oxygen 0.5 - 39 bar!). Maximum output: 2,400 Nm³/h (oxygen 2,100 Nm³/h). Inlet and outlet: G1RHi. Width x height x depth: 130 x 170 x 130 mm. Optionally also available with control pressure reducer. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108535 (pe max. 40 bar pa 0.5 - 39 bar!). CO2/Argon: Item No. 106535. Helium: Item No. 10653526Nitrogen: Item no. 103535Hydrogen: Item no. 104535Compressed air: Item no. 107535</p>
3935 <p>In-line dome pressure reducer Vulkan LD1 MD on both sides. G 1 RHi, single-stage design, without pressure gauge. Maximum inlet pressure: 100 bar (oxygen max. 40 bar!). Output pressure: 0.5 - 99 bar adjustable (oxygen 0.5 - 39 bar!). Maximum output: 2,400 Nm³/h (oxygen 2,100 Nm³/h). Inlet and outlet: G1RHi. Width x height x depth: 130 x 170 x 130 mm. Optionally also available with control pressure reducer. Available for various gas types (please select in the selection window!): Oxygen: Item No. 108535 (pe max. 40 bar pa 0.5 - 39 bar!). CO2/Argon: Item No. 106535. Helium: Item No. 10653526Nitrogen: Item no. 103535Hydrogen: Item no. 104535Compressed air: Item no. 107535</p>