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 (
    9744, 
    9658, 
    9943, 
    9589, 
    9730, 
    8461, 
    9647, 
    9928, 
    9756, 
    9573, 
    9672, 
    9955, 
    9616, 
    9743, 
    8945, 
    9657, 
    9942, 
    9587, 
    9686, 
    8459, 
    9927, 
    9754, 
    9671, 
    9954, 
    9633, 
    9612, 
    8941, 
    9656, 
    9585, 
    9685, 
    8458, 
    10202, 
    9645, 
    9926, 
    9753, 
    9569, 
    9953, 
    9629, 
    9611, 
    9655, 
    9925, 
    9584, 
    9683, 
    8457, 
    10030, 
    9643, 
    9568, 
    9668, 
    9952, 
    9630, 
    9610, 
    9738, 
    8939, 
    9654, 
    9937, 
    9923, 
    9582, 
    9682, 
    8308, 
    9961, 
    9750, 
    9666, 
    9632, 
    9737, 
    8936, 
    9924, 
    9581, 
    9681, 
    8307, 
    9641, 
    9565, 
    9665, 
    9950, 
    9627, 
    9606, 
    8933, 
    9652, 
    9934, 
    9922, 
    9578, 
    9960, 
    9640, 
    9748, 
    9564, 
    9664, 
    9949, 
    9626, 
    9604, 
    9735, 
    8687, 
    9651, 
    9933, 
    9921, 
    9577, 
    9959, 
    9562, 
    9662, 
    9947, 
    9625, 
    9600, 
    9734, 
    9650, 
    9932, 
    9576, 
    9677, 
    7493, 
    9958, 
    9638, 
    9746, 
    8999, 
    9945, 
    9623, 
    9599, 
    8463, 
    9931, 
    9758, 
    9575, 
    9676, 
    6883, 
    9956, 
    9745, 
    8983, 
    9660, 
    9944, 
    9621, 
    9732, 
    8462, 
    9648, 
    9930, 
    9757, 
    9574, 
    9673, 
    9957, 
    9635, 
    8982, 
    9619, 
    9634, 
    9646, 
    9572, 
    9741, 
    9940, 
    9670, 
    9740, 
    8940, 
    9939, 
    9752, 
    9642, 
    9566, 
    9951, 
    9607, 
    9653, 
    9935, 
    9962, 
    9749, 
    9736, 
    9680, 
    8235, 
    9678, 
    8213, 
    9639, 
    9747, 
    8686, 
    9920, 
    9661, 
    9733, 
    9649, 
    9636, 
    9591
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'ru'

Query time 0.00038

JSON explain

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