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 (
    9984, 
    9985, 
    9986, 
    9987, 
    9988, 
    9989, 
    9990, 
    9991, 
    9992, 
    9993, 
    9994, 
    9995, 
    9996, 
    9997, 
    9998, 
    9999, 
    12995, 
    12996, 
    12997, 
    12998, 
    10734, 
    10735, 
    10736, 
    10737, 
    10738, 
    10747, 
    10748, 
    10749, 
    10750, 
    10751, 
    10752, 
    15744, 
    15745, 
    15746, 
    15743, 
    15738, 
    15739, 
    15740, 
    15741, 
    15742, 
    15736, 
    15737, 
    10668, 
    10669, 
    10670, 
    10671, 
    10672, 
    10673, 
    10674, 
    10675, 
    10676, 
    10677, 
    10678, 
    10679, 
    10680, 
    10681, 
    10682, 
    10683, 
    10684, 
    10685, 
    10686, 
    10607, 
    10608, 
    10609, 
    10610, 
    10611, 
    10612, 
    10613, 
    10614, 
    10615, 
    10616, 
    10617, 
    10618, 
    10619, 
    10620, 
    10621, 
    10622, 
    10623, 
    10624, 
    9685, 
    10653, 
    10646, 
    10645, 
    10647, 
    10648, 
    10649, 
    10726, 
    10650, 
    10547, 
    9789, 
    10655, 
    10654, 
    10605, 
    10604, 
    9873, 
    9972, 
    9973, 
    9975, 
    9976, 
    9977, 
    9978, 
    9979, 
    10179, 
    10180, 
    10523, 
    10073, 
    10077, 
    10076, 
    10086, 
    10085, 
    10084, 
    10083, 
    10082, 
    10081, 
    10080, 
    10079, 
    10584, 
    10594, 
    9814, 
    9815, 
    9816, 
    9817, 
    9818, 
    15732, 
    9820, 
    9821, 
    9822, 
    9823
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'ru'

Query time 0.00057

JSON explain

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