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 (
    5531, 5528, 5525, 5521, 5526, 5515, 5501, 
    5529, 5503, 5512, 5514, 5511, 5523, 
    5513, 5516, 5524, 5518, 5527, 5519, 
    5532, 5530, 5517, 6766, 6730
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00039

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_ult_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id", "company_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 24,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.product_id in (5531,5528,5525,5521,5526,5515,5501,5529,5503,5512,5514,5511,5523,5513,5516,5524,5518,5527,5519,5532,5530,5517,6766,6730)",
      "attached_condition": "cscart_ult_product_descriptions.company_id = 1 and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
5501 P10-20UL1-C5-001 - 403-450 MHz 20-50 In, 100 Out, 13.8V 25A Amplifier
5503 P15-R2UL1-C6-001 - 403-450 MHz .200-.500 In, 150 Out, 13.8V 38A Amplifier
5511 P5-R2UH1-C5-001 - 450-512 MHz .200-.500 In, 50 Out, 13.8V 13A Amplifier
5512 P5-R5UH1-C5-001 - 450-512 MHz .500-1 In, 50 Out, 13.8V 13A Amplifier
5513 P5-1UH1-C5-001 - 450-512 MHz 1-2 In, 50 Out, 13.8V 13A Amplifier
5514 P5-2UH1-C5-001 - 450-512 MHz 2-5 In, 50 Out, 13.8V 13A Amplifier
5515 P5-5UH1-C5-001 - 450-512 MHz 5-10 In, 50 Out, 13.8V 13A Amplifier
5516 P5-10UH1-C5-001 - 450-512 MHz 10-20 In, 50 Out, 13.8V 13A Amplifier
5517 P10-R1UH1-C5-001 - 450-512 MHz .100-.200 In, 100 Out, 13.8V 25A Amplifier
5518 P10-R2UH1-C5-001 - 450-512 MHz .200-.500 In, 100 Out, 13.8V 25A Amplifier
5519 P10-R5UH1-C5-001 - 450-512 MHz .500-1 In, 100 Out, 13.8V 25A Amplifier
5524 P10-20UH1-C5-001 - 450-512 MHz 20-50 In, 100 Out, 13.8V 25A Amplifier
5525 P15-R1UH1-C6-001 - 450-512 MHz .100-.200 In, 150 Out, 13.8V 38A Amplifier
5526 P15-R2UH1-C6-001 - 450-512 MHz .200-.500 In, 150 Out, 13.8V 38A Amplifier
5527 P15-R5UH1-C6-001 - 450-512 MHz .500-1 In, 150 Out, 13.8V 38A Amplifier
5528 P15-1UH1-C6-001 - 450-512 MHz 1-2 In, 150 Out, 13.8V 38A Amplifier
5529 P15-2UH1-C6-001 - 450-512 MHz 2-5 In, 150 Out, 13.8V 38A Amplifier
5530 P15-5UH1-C6-001 - 450-512 MHz 5-10 In, 150 Out, 13.8V 38A Amplifier
5531 P15-10UH1-C6-001 - 450-512 MHz 10-20 In, 150 Out, 13.8V 38A Amplifier
5532 P15-20UH1-C6-001 - 450-512 MHz 20-50 In, 150 Out, 13.8V 38A Amplifier
6730
6766