SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (4145, 633, 635) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00019

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 3,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4145,633,635)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
633 <p>Motorola Solutions OEM high capacity battery compatible with CP185 and CP100d (analog and digital models). </p> cp185 battery, cp-185 battery, cp 185 battery, CP100, CP100d, CP100 high capacity battery, CP100d high capacity battery, CP100 battery, CP100d battery
635 <p>Motorola Solutions OEM Ni-MH rechargeable battery for CP185 and CP100d (analog and digital models). </p> cp185 battery, cp-185 battery, cp 185 battery, CP100, CP100d, CP100 battery, CP100d battery, CP100d NiMH, CP100 NiMH, CP100d Ni-MH
4145 <p>Motorola Original batteries are designed for reliable power you can count on. The Lithium Ion (Li-ion) battery offers 15000 mAh minimum output, with 1750 mAh for typical use. Compatible with the CP185 and CP100d (analog and digital models). The higher capacity PMNN4080A is recommended for use in digital mode. </p><p>The PMNN4476A replaced the PMNN4081AR. </p> cp185 battery, cp-185 battery, cp 185 battery, CP100 battery, CP-100 battery, CP100d battery, CP-100d battery, CP100, CP100d, CP100D, CP100d standard battery, PMNN-4476, PMNN-4081, PMNN4081, PMNN4081AR