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 (
    12505, 13099, 12514, 12513, 9759, 10496, 
    10560, 10561, 10581, 10102, 9940, 10578, 
    10143, 9947, 10567, 10568, 10565, 9933, 
    12499, 12500, 10200, 10201, 10566, 
    10545, 10227, 10552, 12506, 10693, 
    12508, 9953, 12522, 12507, 12498, 13101, 
    13100, 10699, 10695, 10195, 10576, 
    10696, 9760, 10583, 10701, 10582, 10139, 
    12503, 10575, 9932, 10075, 10135, 9952, 
    10074, 10573, 10577, 10651, 10642, 
    12529, 12515, 12525, 12532, 12523, 
    10198, 10557, 10202
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'ru'

Query time 0.00034

JSON explain

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