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 (
    18977, 20565, 19418, 18992, 21626, 18908, 
    18926, 19004, 22046, 18981, 22045, 
    22059, 18994, 21634, 18911, 18958, 
    19005, 22053, 18982, 20601, 22058, 
    18995, 21640, 18912, 18959, 19006, 
    22055, 18984, 20602, 22047, 18913, 
    18996, 21639, 18960, 19007, 22054, 
    18985, 20603, 21629, 18914, 18997, 
    21637, 18961, 19011, 22056, 18986, 
    21627, 21630, 18915, 18998, 21635, 
    18970, 19013, 22057, 18987, 21638, 
    21631, 18917, 18999, 22061, 22051, 
    18971, 19014, 22064, 18988, 21636, 
    21632, 18918, 19000, 22050, 22461, 
    18973, 19016, 22063, 18989, 21642, 
    22052, 18920, 19001, 22049, 22479, 
    18975, 19017, 9348, 18990, 21641, 22062, 
    18924, 19002, 22048, 18976, 19066, 
    9347, 18991, 21628, 22060, 18925, 19003, 
    22044
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'uk'

Query time 0.00043

JSON explain

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