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 (13274, 13280, 3105) 
  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": "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 (13274,13280,3105)) 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
3105		Vulkan LP216 line pressure reducer for compressed air G1/4RHi, 1 - 250 mbar<br />Standards & Design:<br /><br />single-stage design, with safety gauges according to DIN EN ISO 5171, maximum inlet pressure: 21 bar, output pressure: 1 - 250 mbar, adjustable<br /><br />Technical data:<br /><br />• maximum inlet pressure: 21 bar, output pressure: 1 - 250 mbar, adjustable<br />• output pressure: 1 - 250 mbar, adjustable<br />• Inlet: internal thread G1/4RHi, output: internal thread G1/4RHi, output gauge: 0 - 250 mbar<br /><br />Dimensions:<br /><br />Width x Height x Depth: 108 x 162 x 108 mm
13274		In-line regulator Vulkan LabLine L10, single stage, chrome-plated body with stainless steel diaphragm for gas purity up to 5.0. With safety gauges acc. to DIN EN ISO 5171. Inlet pressure max 20 bar, outlet pressure 0–10 bar adjustable. Max. flow 45 Nm³/h at 10 bar. Inlet: clamp ring 8 mm. Outlet: clamp ring 8 mm. Dimensions: 200 × 190 × 75 mm, 1.5 kg.
13280		In-line regulator Vulkan LabLine L15, single stage, chrome-plated body with stainless steel diaphragm for gas purity up to 5.0. With safety gauges acc. to DIN EN ISO 5171. Inlet pressure max 20 bar, outlet pressure 0–1.5 bar adjustable. Max. flow 8 Nm³/h at 1.5 bar. Inlet: clamp ring 8 mm. Outlet: clamp ring 8 mm. Dimensions: 200 × 190 × 75 mm, 1.5 kg.