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 (3433, 6686, 12474) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00058

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "2.11"
    },
    "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": 3,
      "rows_produced_per_join": 3,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_ult_product_descriptions`.`company_id` = 1) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`product_id` in (3433,6686,12474)) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "1.81",
        "eval_cost": "0.30",
        "prefix_cost": "2.11",
        "data_read_per_join": "11K"
      },
      "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
3433 <p>for connecting, monitoring and switching two contact pressure gauges with inductive contacts and two solenoid valves, with internal signal display "Gas type operation OK empty" for each channel, extraction side selectable, with "Empty message hold function" (alarm must be acknowledged),Inputs: 2 x inductive contact</p><p>Output: 2 x solenoid valve 230V 50Hz<br><br>with potential-free contacts,<br><br>completely in plastic housing<br><br>Width x height x depth: 300 x 230 x 190 mm<br><br>With operating instructions, CE declaration of conformity for the electrical part, electr. Execution according to current VDE and European regulations, affixed type plate with Linde logo, glass front pane with Linde logo, Linde type designation, affixed Linde lettering, individually packed in a carton, with Linde adhesive tape</p>
6686 Vulkan L15 line pressure reducer for fuel gases G1/2RH, 0 - 1.5 bar<br />Standards & Design:<br /><br />single-stage design, with safety pressure gauges according to DIN ISO 5171, maximum inlet pressure: 20 bar, output pressure: 0 to 1<br />according to EN 560, output: external thread G1/2RH according to EN 560, input pressure gauge: 0 to 40/20 bar, output pressure gauge: 0 to 2<br /><br />Technical data:<br /><br />• maximum inlet pressure: 20 bar, output pressure: 0 to 1<br />• outlet pressure, input: external thread G1/2RH according to EN 560, output: external thread G1/2RH according to EN 560, input pressure gauge: 0 to 40/20 bar, output pressure gauge: 0 to 2<br />• output pressure: 0 to 1<br /><br />Dimensions:<br /><br />width x height x depth: 200 x 200 x 75 mm