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 (13280, 6692, 3408) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00061

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 (13280,6692,3408)) 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
3408		<p>Transfer adapter stainless steel DIN 477-1 No. 1FzF-SS-HD1L-001-PI250-HD1R-001 Stainless steel Gas type: Combustible gases Left and right side gas cylinder connection</p><p>Standards & Design:<br><br><br><br>according to DIN 477-1 No</p>
6692		Line pressure reducer Vulkan LP216-1.6 oxygen G3/8RHi 0.01-1.6 bar<br />Standards & Design:<br /><br />single-stage design, with safety pressure gauges according to DIN ISO 5171, maximum inlet pressure: 21 bar, output pressure: 0<br /><br />Technical data:<br /><br />• maximum inlet pressure: 21 bar, output pressure: 0<br />• output pressure: 0<br /><br />Dimensions:<br /><br />width x height x depth: 108 x 162 x 108 mm
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.