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 (
    13387, 
    11741, 
    13189, 
    13410, 
    12079, 
    11672, 
    12953, 
    12215, 
    11869, 
    13224, 
    12421, 
    13350, 
    12225, 
    11710, 
    13092, 
    13686, 
    11965, 
    8377, 
    12889, 
    11853, 
    11854, 
    11851, 
    13394, 
    12209, 
    11682, 
    12964, 
    12957, 
    11921, 
    7161, 
    12489, 
    8893, 
    11816, 
    13395, 
    11740, 
    13171, 
    13411, 
    12078, 
    11671, 
    12952, 
    11947, 
    11868, 
    13225, 
    12382, 
    13351, 
    12224, 
    11703, 
    13091, 
    18018, 
    11964, 
    8159, 
    12888, 
    11826, 
    11852, 
    13209, 
    13396, 
    12208, 
    11681, 
    12963, 
    12951, 
    11919, 
    6943, 
    12486, 
    8890, 
    11814, 
    13399, 
    11739, 
    13170, 
    13412, 
    12077, 
    19519, 
    12950, 
    11923, 
    11866, 
    13226, 
    12381, 
    13382, 
    12223, 
    11694, 
    13090, 
    18099, 
    11946, 
    8068, 
    12887, 
    11824, 
    11850, 
    11815, 
    13207, 
    13397, 
    12166, 
    11680, 
    12962, 
    12947, 
    11879, 
    6940, 
    12485, 
    8062, 
    13400, 
    11738, 
    13169, 
    13413, 
    12076, 
    18071, 
    12949, 
    11922, 
    11862, 
    13227, 
    12379, 
    13383, 
    12222, 
    11692, 
    13089, 
    18100, 
    11945, 
    8031, 
    12525, 
    11822, 
    11827, 
    11807, 
    13205, 
    13398, 
    12165, 
    11679, 
    12961, 
    12890, 
    11878, 
    6887, 
    12484, 
    8009, 
    13403, 
    11737, 
    13168, 
    13452, 
    12075, 
    9980, 
    12948, 
    11920, 
    11861, 
    13230, 
    13386, 
    12221, 
    11690, 
    13087, 
    18101, 
    11944, 
    7995, 
    12523, 
    11805, 
    11825, 
    11806, 
    13204, 
    13401, 
    12164, 
    11678, 
    12960, 
    12524, 
    11877, 
    6864, 
    12482, 
    13222, 
    12231, 
    13404, 
    11736, 
    13155, 
    13487, 
    12073, 
    9271, 
    12946, 
    11875, 
    11860, 
    13240, 
    13388, 
    12220, 
    11689, 
    13077, 
    18136, 
    11943, 
    7896, 
    12521, 
    11747, 
    11823, 
    11751, 
    13203, 
    13402, 
    12085, 
    11677, 
    12959, 
    12522, 
    11876, 
    6858, 
    12483, 
    13228, 
    12230, 
    13405, 
    11735, 
    13099, 
    13488, 
    12074, 
    9252, 
    12944, 
    11874, 
    11859, 
    13241, 
    13389, 
    12219, 
    11688, 
    13076, 
    13134, 
    11942, 
    7778, 
    12520, 
    11742, 
    11821, 
    11746, 
    13202, 
    13406, 
    12084, 
    11676, 
    12958, 
    12518, 
    11873, 
    13219, 
    12481, 
    13229, 
    12229, 
    13498, 
    11734, 
    13097, 
    13495, 
    12052, 
    8903, 
    12894, 
    11867, 
    11858, 
    13262, 
    13390, 
    12218, 
    11687, 
    13075, 
    13098, 
    11941, 
    7658, 
    12519, 
    11693, 
    13349, 
    11745, 
    13195, 
    13407, 
    12083, 
    11675, 
    12956, 
    12487, 
    11872, 
    13220, 
    12480, 
    12228, 
    11733, 
    13096, 
    13496, 
    12051, 
    8892, 
    12893, 
    11865, 
    11857, 
    13263, 
    13391, 
    12217, 
    11686, 
    13074, 
    13095, 
    11926, 
    7541, 
    12517, 
    11691, 
    11819, 
    13384, 
    11744, 
    13194, 
    13408, 
    12081, 
    11674, 
    12955, 
    12422, 
    11871, 
    13221, 
    12479, 
    12227, 
    11732, 
    13094, 
    13497, 
    12032, 
    8889, 
    12892, 
    11864, 
    11856, 
    13264, 
    13392, 
    12216, 
    11685, 
    13012, 
    11925, 
    18703, 
    12516, 
    11684, 
    11818, 
    13385, 
    11743, 
    13192, 
    13409, 
    12080, 
    11673, 
    12954, 
    12380, 
    11870, 
    13223, 
    12423, 
    12226, 
    11731, 
    13093, 
    13685, 
    12031, 
    8516, 
    12891, 
    11863, 
    11855, 
    13347, 
    18422, 
    13393, 
    12214, 
    11683, 
    12965, 
    13073, 
    11924, 
    7278, 
    12490, 
    9699, 
    11817, 
    12364, 
    11820, 
    13088
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'ru'

Query time 0.00054

JSON explain

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