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 (
    232, 298, 309, 337, 339, 405, 427, 428, 
    429, 430, 431, 520, 521, 522, 523, 550, 
    551, 552, 553, 554, 555, 556, 1562, 1563, 
    1564, 1565, 1566, 1567, 1568, 1569, 
    1570, 1755, 1756, 1757, 1758, 1759, 
    1760, 1761, 1762, 1763, 1764, 1765, 
    1766, 1767, 1768, 1769, 1770, 1771, 
    3314, 3315, 3478, 3479, 3480, 5556, 
    5473, 5475, 533, 1843, 531, 1841, 536, 
    1840, 486, 534, 532, 1842, 292, 535
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00044

JSON explain

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