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 (
    7172, 
    6924, 
    6730, 
    6784, 
    6764, 
    6737, 
    6690, 
    8742, 
    6771, 
    6724, 
    6723, 
    6813, 
    6797, 
    6801, 
    6750, 
    6694, 
    10195, 
    6706, 
    6689, 
    6782, 
    6763, 
    6736, 
    7084, 
    8743, 
    6768, 
    6720, 
    6722, 
    6812, 
    6798, 
    6793, 
    6749, 
    6691, 
    9495, 
    6702, 
    6688, 
    6781, 
    6759, 
    6734, 
    6921, 
    8680, 
    6765, 
    6718, 
    11375, 
    6721, 
    6811, 
    6796, 
    6791, 
    6748, 
    6682, 
    8802, 
    6700, 
    6687, 
    6779, 
    6755, 
    6732, 
    6923, 
    6810, 
    6920, 
    6762, 
    6717, 
    11104, 
    6719, 
    6795, 
    6789, 
    6747, 
    8801, 
    6701, 
    6686, 
    6778, 
    6754, 
    6731, 
    6808, 
    6922, 
    6761, 
    6715, 
    11103, 
    6716, 
    6794, 
    6783, 
    6746, 
    8688, 
    6699, 
    6685, 
    6776, 
    6751, 
    6915, 
    6806, 
    6918, 
    6760, 
    6712, 
    11059, 
    6714, 
    6790, 
    6780, 
    6745, 
    8241, 
    6698, 
    6684, 
    6777, 
    6744, 
    6729, 
    6916, 
    6805, 
    6919, 
    6758, 
    6713, 
    11052, 
    6711, 
    6788, 
    6769, 
    6743, 
    8008, 
    6697, 
    6683, 
    6775, 
    6740, 
    6728, 
    6917, 
    6804, 
    6914, 
    6757, 
    6705, 
    10992, 
    6710, 
    6787, 
    6770, 
    6742, 
    8000, 
    6696, 
    11378, 
    6773, 
    6739, 
    6727, 
    6912, 
    6803, 
    6809, 
    6756, 
    6704, 
    10778, 
    6708, 
    6786, 
    6767, 
    6741, 
    7914, 
    6693, 
    11211, 
    6774, 
    6735, 
    6726, 
    6913, 
    6800, 
    6807, 
    6753, 
    6703, 
    10640, 
    6709, 
    6785, 
    6766, 
    6738, 
    7411, 
    6692, 
    8865, 
    6772, 
    6733, 
    6725, 
    6814, 
    6799, 
    6802, 
    6752, 
    6695, 
    10246, 
    6707
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'ru'

Query time 0.00051

JSON explain

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