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 (
    58884, 62123, 29986, 60914, 29983, 60749, 
    29992, 29989, 60748, 63034, 62012, 
    60739, 60745, 61430, 62240, 63755, 
    60753, 64625, 62259, 64624, 61340, 
    61337, 64616, 60746, 64617, 60736, 
    64615, 62252, 61336, 62253, 64614, 
    60731, 60726, 60750, 60734, 61388, 
    64622, 60741, 64623, 64626, 60747, 
    62254, 60730, 62260, 60740, 61387, 
    60742, 61171
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00022

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}