SELECT 
  cscart_seo_names.object_id AS product_id, 
  cscart_seo_names.name AS seo_name, 
  cscart_seo_names.path AS seo_path 
FROM 
  cscart_seo_names 
WHERE 
  cscart_seo_names.object_id IN (
    153378, 
    146250, 
    151676, 
    170573, 
    132911, 
    151528, 
    168300, 
    146008, 
    149505, 
    137270, 
    118463, 
    175108, 
    120360, 
    125752, 
    145670, 
    165520, 
    164728, 
    168291, 
    3459, 
    135232, 
    134222, 
    163348, 
    147116, 
    141352, 
    173196, 
    133367, 
    136278, 
    164224, 
    169761, 
    120371, 
    126781, 
    174454, 
    159721, 
    122698, 
    146691, 
    132361, 
    145504, 
    151584, 
    163029, 
    142300, 
    148407, 
    159680, 
    166851, 
    135515, 
    158366, 
    167558, 
    118856, 
    150294, 
    120895, 
    164939, 
    148060, 
    170707, 
    154297, 
    169846, 
    159381, 
    165473, 
    152983, 
    168016, 
    159560, 
    157441, 
    160602, 
    125438, 
    174205, 
    125076, 
    141675, 
    141823, 
    120656, 
    126863, 
    158696, 
    145139, 
    137529, 
    141871, 
    139050, 
    175166, 
    171127, 
    120496, 
    169901, 
    138735, 
    146824, 
    158471, 
    162470, 
    154893, 
    146279, 
    121442, 
    125787, 
    120264, 
    138776, 
    164451, 
    138985, 
    121657, 
    139237, 
    172341, 
    169627, 
    121067, 
    122178, 
    131028, 
    133688, 
    135620, 
    129139, 
    156331, 
    177744, 
    160951, 
    160534, 
    171706, 
    128069, 
    163441, 
    131982, 
    170708, 
    136526, 
    152889, 
    146907, 
    169481, 
    172066, 
    165323, 
    120928, 
    143092, 
    160218, 
    146004, 
    169267, 
    151452, 
    165666, 
    149523, 
    131594, 
    129845, 
    133281, 
    148051, 
    163097, 
    144228
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.01469

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.25201984,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_seo_names",
          "access_type": "range",
          "possible_keys": ["PRIMARY", "dispatch"],
          "key": "PRIMARY",
          "key_length": "206",
          "used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
          "loops": 1,
          "rows": 128,
          "cost": 0.25201984,
          "filtered": 100,
          "attached_condition": "cscart_seo_names.object_id in (153378,146250,151676,170573,132911,151528,168300,146008,149505,137270,118463,175108,120360,125752,145670,165520,164728,168291,3459,135232,134222,163348,147116,141352,173196,133367,136278,164224,169761,120371,126781,174454,159721,122698,146691,132361,145504,151584,163029,142300,148407,159680,166851,135515,158366,167558,118856,150294,120895,164939,148060,170707,154297,169846,159381,165473,152983,168016,159560,157441,160602,125438,174205,125076,141675,141823,120656,126863,158696,145139,137529,141871,139050,175166,171127,120496,169901,138735,146824,158471,162470,154893,146279,121442,125787,120264,138776,164451,138985,121657,139237,172341,169627,121067,122178,131028,133688,135620,129139,156331,177744,160951,160534,171706,128069,163441,131982,170708,136526,152889,146907,169481,172066,165323,120928,143092,160218,146004,169267,151452,165666,149523,131594,129845,133281,148051,163097,144228) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id seo_name seo_path
3459 air-book-325 300/305/306
118463 air-backpack-685 300/301/302
118856 air-camera-936 300/301/302
120264 air-grinder-860 300/305/306
120360 air-backpack-729 300/305/306
120371 air-bottle-207 300/305/306
120496 air-grinder-170 300/305/306
120656 air-drone-440 300/301/302
120895 air-camera-993 300/305/306
120928 air-laptop-869 300/305/306
121067 air-headphones-503 300/301/302
121442 air-grinder-661 300/301/302
121657 air-headphones-241 300/305/306
122178 air-headphones-551 300/305/306
122698 air-bottle-617 300/305/306
125076 air-drone-368 300/301/302
125438 air-drone-322 300/305/306
125752 air-backpack-847 300/305/306
125787 air-grinder-723 300/305/306
126781 air-bottle-441 300/301/302
126863 air-drone-454 300/301/302
128069 air-laptop-224 300/305/306
129139 air-headphones-683 300/305/306
129845 air-phone-132 300/305/306
131028 air-headphones-570 300/301/302
131594 air-mixer-888 300/305/306
131982 air-laptop-335 300/305/306
132361 air-bottle-808 300/301/302
132911 air-backpack-473 300/301/302
133281 air-phone-161 300/301/302
133367 air-book-927 300/301/302
133688 air-headphones-651 300/305/306
134222 air-book-476 300/301/302
135232 air-book-335 300/301/302
135515 air-camera-646 300/301/302
135620 air-headphones-653 300/301/302
136278 air-book-968 300/301/302
136526 air-laptop-388 300/301/302
137270 air-backpack-677 300/305/306
137529 air-drone-809 300/305/306
138735 air-grinder-346 300/305/306
138776 air-grinder-918 300/305/306
138985 air-headphones-155 300/301/302
139050 air-drone-921 300/305/306
139237 air-headphones-308 300/305/306
141352 air-book-611 300/305/306
141675 air-drone-407 300/305/306
141823 air-drone-437 300/305/306
141871 air-drone-887 300/301/302
142300 air-camera-549 300/305/306
143092 air-laptop-898 300/301/302
144228 air-phone-379 300/305/306
145139 air-drone-635 300/301/302
145504 air-bottle-818 300/301/302
145670 air-book-161 300/305/306
146004 air-mixer-558 300/301/302
146008 air-backpack-595 300/301/302
146250 air-backpack-242 300/301/302
146279 air-grinder-484 300/301/302
146691 air-bottle-701 300/301/302
146824 air-grinder-377 300/305/306
146907 air-laptop-521 300/301/302
147116 air-book-570 300/301/302
148051 air-phone-308 300/305/306
148060 air-chair-222 300/301/302
148407 air-camera-577 300/305/306
149505 air-backpack-647 300/305/306
149523 air-mixer-793-en 300/301/302
150294 air-camera-981 300/305/306
151452 air-mixer-671 300/305/306
151528 air-backpack-504 300/301/302
151584 air-camera-242 300/305/306
151676 air-backpack-369 300/305/306
152889 air-laptop-465 300/305/306
152983 air-chair-903 300/301/302
153378 air-backpack-230 300/305/306
154297 air-chair-257 300/301/302
154893 air-grinder-476 300/301/302
156331 air-headphones-684 300/301/302
157441 air-drone-193 300/301/302
158366 air-camera-770 300/305/306
158471 air-grinder-424 300/305/306
158696 air-drone-464 300/301/302
159381 air-chair-567 300/305/306
159560 air-chair-975 300/305/306
159680 air-camera-614 300/305/306
159721 air-bottle-573 300/305/306
160218 air-laptop-910 300/305/306
160534 air-laptop-170 300/301/302
160602 air-drone-269 300/305/306
160951 air-headphones-920 300/305/306
162470 air-grinder-453 300/301/302
163029 air-camera-272 300/305/306
163097 air-phone-309 300/305/306
163348 air-book-492 300/301/302
163441 air-laptop-283 300/305/306
164224 air-bottle-117 300/305/306
164451 air-grinder-987 300/305/306
164728 air-book-251 300/301/302
164939 air-chair-159 300/305/306
165323 air-laptop-742 300/301/302
165473 air-chair-893 300/305/306
165520 air-book-178 300/301/302
165666 air-mixer-674 300/301/302
166851 air-camera-631 300/305/306
167558 air-camera-879 300/301/302
168016 air-chair-904 300/305/306
168291 air-book-256 300/305/306
168300 air-backpack-513 300/301/302
169267 air-mixer-625 300/305/306
169481 air-laptop-553 300/301/302
169627 air-headphones-439 300/301/302
169761 air-bottle-189 300/305/306
169846 air-chair-500 300/305/306
169901 air-grinder-323-en 300/301/302
170573 air-backpack-439 300/305/306
170707 air-chair-251 300/305/306
170708 air-laptop-354 300/305/306
171127 air-drone-979 300/301/302
171706 air-laptop-204 300/301/302
172066 air-laptop-645 300/305/306
172341 air-headphones-350 300/305/306
173196 air-book-714 300/301/302
174205 air-drone-352 300/301/302
174454 air-bottle-473 300/301/302
175108 air-backpack-706 300/301/302
175166 air-drone-924 300/305/306
177744 air-headphones-756 300/305/306