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 (
    10102, 
    10643, 
    10178, 
    10177, 
    10606, 
    10644, 
    10101, 
    10175, 
    10100, 
    15962, 
    15961, 
    15960, 
    15959, 
    10094, 
    10093, 
    9813, 
    10097, 
    9760, 
    9759, 
    9934, 
    9933, 
    9932, 
    9931, 
    9936, 
    9947, 
    9953, 
    9952, 
    10074, 
    10096, 
    10075, 
    10602, 
    10087, 
    10130, 
    10603, 
    10135, 
    10134, 
    10139, 
    10138, 
    10137, 
    10141, 
    10143, 
    10142, 
    12628, 
    12627, 
    12629, 
    10095, 
    10195, 
    10194, 
    10193, 
    10190, 
    10496, 
    10198, 
    10202, 
    10201, 
    10200, 
    10227, 
    10226, 
    10651, 
    9945, 
    10642, 
    10601, 
    9727, 
    9728, 
    9729, 
    9730, 
    9731, 
    9732, 
    9733, 
    10181, 
    9734, 
    9735, 
    9724, 
    10655, 
    10654, 
    10605, 
    10604, 
    9873, 
    10653, 
    10646, 
    10645, 
    10647, 
    10648, 
    10649, 
    10726, 
    10650, 
    9789, 
    10547, 
    9796, 
    9874, 
    9875, 
    9879, 
    9887, 
    9941, 
    9942, 
    9943, 
    9944, 
    10744, 
    10745, 
    10746, 
    10739, 
    10740, 
    10741, 
    10742, 
    10734, 
    10735, 
    10736, 
    10737, 
    10738, 
    10688, 
    10727, 
    10728, 
    10729, 
    10730, 
    10731, 
    10732, 
    10733, 
    10713, 
    10714, 
    10715, 
    10716, 
    10717, 
    10718, 
    10719, 
    10720, 
    10721, 
    10722, 
    10723, 
    10704
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'ru'

Query time 0.00030

JSON explain

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