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 (
    64941, 62258, 60732, 60733, 60737, 64621, 
    61385, 64942, 60751, 60735, 64943, 
    64339, 63128, 60738, 62671, 64340, 
    61386, 64620, 64815, 65519, 65568, 
    65851, 65870, 65875, 65853, 65864, 
    65877, 65874, 65863, 65869, 65868, 
    65862, 65850, 65880, 65852, 65855, 
    65854, 65866, 65857, 65876, 65858, 
    65856, 65860, 65859, 65861
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00031

JSON explain

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