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, 13275, 13276, 13277, 13278, 13279
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00060

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.21"
    },
    "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": 6,
      "rows_produced_per_join": 6,
      "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,13275,13276,13277,13278,13279)) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "3.61",
        "eval_cost": "0.60",
        "prefix_cost": "4.21",
        "data_read_per_join": "22K"
      },
      "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
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.
13275 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.
13276 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.
13277 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.
13278 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.
13279 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.