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 (
    10074, 10573, 10577, 10651, 10642, 12529, 
    12515, 12525, 12532, 12523, 10198, 
    10557, 10202, 10556, 10101, 10558, 
    10142, 10134, 10141, 10053, 10138, 
    10130, 9934, 10563, 10569, 10572, 10602, 
    10603, 10137, 12517, 12531, 12526, 
    12509, 10226, 10551, 10550, 10193, 
    10659, 10664, 10666, 10661, 10663, 
    10190, 10657, 10658, 10194, 10692, 
    12530, 12516, 12496, 12519, 12510, 
    10087, 10100, 10698
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'ru'

Query time 0.00027

JSON explain

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