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 (13286, 13292, 6670) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00063

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 (13286,13292,6670)) 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
6670		Vulkan LR40 nitrogen ribbed line pressure reducer G3/4RHak, 15-40 bar<br />Standards & Design:<br /><br />single-stage design, with safety pressure gauges according to DIN EN ISO 5171, maximum inlet pressure: 100 bar, output pressure: 15-40 bar, adjustable, maximum output: 280 Nm³/h compressed air at 40 bar outlet pressure and 81 bar inlet pressure, input: external thread G3/4RHak, output: external thread G3/4RHak, input pressure gauge: 0-160/100 bar, output pressure gauge: 0-60/40 bar, width x height x depth: 215 x 330 x 85 mm<br /><br />Technical data:<br /><br />• maximum inlet pressure: 100 bar, output pressure: 15-40 bar, adjustable, maximum output: 280 Nm³/h compressed air at 40 bar outlet pressure and 81 bar inlet pressure, input: external thread G3/4RHak, output: external thread G3/4RHak, input pressure gauge: 0-160/100 bar, output pressure gauge: 0-60/40 bar, width x height x depth: 215 x 330 x 85 mm<br />• outlet pressure and 81 bar inlet pressure, input: external thread G3/4RHak, output: external thread G3/4RHak, input pressure gauge: 0-160/100 bar, output pressure gauge: 0-60/40 bar, width x height x depth: 215 x 330 x 85 mm<br />• output pressure: 15-40 bar, adjustable, maximum output: 280 Nm³/h compressed air at 40 bar outlet pressure and 81 bar inlet pressure, input: external thread G3/4RHak, output: external thread G3/4RHak, input pressure gauge: 0-160/100 bar, output pressure gauge: 0-60/40 bar, width x height x depth: 215 x 330 x 85 mm<br /><br />Dimensions:<br /><br />width x height x depth: 215 x 330 x 85 mm
13286		In-line regulator Vulkan LabLine L10/2, double 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 30 Nm³/h at 10 bar. Inlet: clamp ring 8 mm. Outlet: clamp ring 8 mm. Dimensions: 240 × 190 × 75 mm, 2.0 kg.
13292		In-line regulator Vulkan LabLine L15/2, double 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: 240 × 190 × 75 mm, 2.0 kg.