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 (3435, 3447, 3439) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00033

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "2.37"
    },
    "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": "((`gaseus`.`cscart_ult_product_descriptions`.`company_id` = 1) and (`gaseus`.`cscart_ult_product_descriptions`.`product_id` in (3435,3447,3439)) and (`gaseus`.`cscart_ult_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "2.08",
        "eval_cost": "0.30",
        "prefix_cost": "2.38",
        "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
3435		single stage with safety gauge acc. to ISO 5171, inlet pressure max: 20 bar<br />outlet pressure: 0 – 4 bar adjustable<br />flow max: 10 kg/h at 4 bar working pressure<br />inlet: W 21,8x1/14 LH nut acc. to DIN 477<br />outlet: G 3/8 LHk x 9 mm tail-piece EN 560<br />outlet gauge: 0 – 6/4 bar<br />width x height x depth: 198 x 134 x 75 mm<br />with Linde-Logo on body, with Linde-tape and Linde operating manual<br />
3439		acc to DIN EN ISO 2503, class 3, single stage, with safety gauges acc. to DIN ISO 5171,<br />with shut off valve<br />inlet pressure max:200 bar<br />outlet pressure: 0 – 10 bar adjustable<br />flow max:48 Nm³/h air at 10 bar outlet pressure <br />inlet connection: W 24,32x1/14 RH nut acc. to DIN 477-1, no. 10<br />outlet connection: G 1/4RH x 6mm tail-piece acc. EN560<br />inlet gauge: 0 – 315 /200 bar<br />working gauge: 0 – 16/10 bar<br />width x height x depth: 210 x 190 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3447		acc. to ISO 2503, class 3, single stage, with safety gauges acc. to ISO 5171, with shut off valve,inlet pressure max.: 200 bar<br />outlet pressure: 0 – 10 bar adjustable<br />flow max.: 48 Nm³/h air at 10 bar working pressure<br />Inlet connection: W21,8x1/14LH nut acc. to DIN 477-1, no. 1<br />outlet connection:G 3/8 RHk x 9 mm tailpiece acc. to EN 560<br />inlet gauge: 0 - 315/200 bar<br />working gauge: 0 - 16/10 bar<br />width x height x depth: 210 x 190 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape