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 (
    453, 
    454, 
    455, 
    450, 
    451, 
    452, 
    435, 
    439, 
    443, 
    430, 
    429, 
    428, 
    415, 
    416, 
    417, 
    418, 
    419, 
    420, 
    421, 
    422, 
    423, 
    424, 
    425, 
    426, 
    403, 
    404, 
    405, 
    406, 
    407, 
    408, 
    409, 
    410, 
    411, 
    412, 
    413, 
    414, 
    391, 
    392, 
    393, 
    394, 
    395, 
    396, 
    397, 
    398, 
    399, 
    400, 
    401, 
    402, 
    379, 
    380, 
    381, 
    382, 
    383, 
    384, 
    385, 
    386, 
    387, 
    388, 
    389, 
    390, 
    363, 
    364, 
    365, 
    366, 
    367, 
    368, 
    369, 
    370, 
    355, 
    356, 
    357, 
    358, 
    359, 
    360, 
    361, 
    362, 
    352, 
    353, 
    354, 
    350, 
    349, 
    346, 
    345, 
    331, 
    335, 
    339, 
    341, 
    315, 
    289, 
    287, 
    286, 
    278, 
    280, 
    282, 
    247, 
    248, 
    241, 
    244, 
    245, 
    246, 
    240, 
    6, 
    66, 
    166, 
    214, 
    219, 
    221, 
    223, 
    192, 
    194, 
    195, 
    196, 
    197, 
    198, 
    199, 
    200, 
    201, 
    202, 
    203, 
    204, 
    205, 
    206, 
    207, 
    208, 
    209, 
    210, 
    211, 
    212
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00201

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "119.08"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "rows_examined_per_scan": 554,
      "rows_produced_per_join": 148,
      "filtered": "26.90",
      "cost_info": {
        "read_cost": "89.28",
        "eval_cost": "29.80",
        "prefix_cost": "119.08",
        "data_read_per_join": "252K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`pankajecarter_systemfour`.`cscart_seo_names`.`object_id` in (453,454,455,450,451,452,435,439,443,430,429,428,415,416,417,418,419,420,421,422,423,424,425,426,403,404,405,406,407,408,409,410,411,412,413,414,391,392,393,394,395,396,397,398,399,400,401,402,379,380,381,382,383,384,385,386,387,388,389,390,363,364,365,366,367,368,369,370,355,356,357,358,359,360,361,362,352,353,354,350,349,346,345,331,335,339,341,315,289,287,286,278,280,282,247,248,241,244,245,246,240,6,66,166,214,219,221,223,192,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212)) and (`pankajecarter_systemfour`.`cscart_seo_names`.`type` = 'p') and (`pankajecarter_systemfour`.`cscart_seo_names`.`dispatch` = '') and (`pankajecarter_systemfour`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
241 apple-ipad-with-retina-display-wi-fi-32gb-white 167/165
223 samsung-galaxy-tab-8-9-wi-fi-only-32gb-metallic-gray 167/165
219 series-3-15-6-laptop-en 167/169
208 h-264-megapixel-surveillance-camera-tl-sc3430 167/171
206 rt-n66u-dual-band-wireless-n900-gigabit-router 167/171
212 panasonic-kx-mb2000-24ppm-3-in-1-monochrome-laser-mfp 167/172
195 crossroads-guitar-festival-2010-2dvd 228/232
207 asus-usb-n53 167/171
199 b-b-king-original-greatest-hits-cd 228/229
198 b-b-king-one-kind-favor-cd-grammy-award-winning-cd-manufacturer-geffen-records-sku-bbk-11onekindfavorcd-reviewed-2-times 228/229
201 beethoven-piano-concertos-nos-1-and-2 228/230
192 black-and-white-america-cd-pack 228/232
196 feeding-the-monkies-at-ma-maison-zappa 228/232
197 guitar-man-album-artwork 228/229
200 john-rutter-the-colours-of-christmas 228/230
202 new-years-concert-2011-diverse-klassik-welser-moest-wiener-philharmoniker 228/230
203 new-years-concert-2012-diverse-wr-philharmoniker-jansons-m-wr-san 228/230
204 the-police-the-stewart-copeland-anthology 228/232
194 u218-singles-u2tcd020 228/232
214 asus-cp6130 167/168
240 apple-ipad-with-retina-display-wi-fi-64gb-black 167/165
205 dir-657-hd-media-router-1000 167/171
280 t-shirt-color-black 223/224
282 t-shirt-color-blue 223/224
248 x-box-one 245/248
278 t-shirt-color-white 223/224
211 hp-officejet-pro-8600-premium-e-all-in-one-printer 167/172
210 hp-photosmart-plus-e-all-in-one-printer-b210a 167/172
209 hp-scanjet-g3110-scanner 167/172
66 xrs-9970g 166/175/189
245 apple-iphone-5c-32gb-cell-phone-green 166/234/235
247 nokia-n1-pad-7-9-quad-core-64bit-2-3ghz-2gb-32gb-android-5-0 167/165
244 packard-bell-onetwo 167/168
221 series-9-13-3-laptop 167/169
166 nikon-1-j1-two-lens-wide-angle-kit-red 166/196/198
6 toshiba-32c120u-32-class-720p-hd-lcd-tv 166/174/191
246 gopro-hero3-black-edition-camera 166/196/199
286 super-luxury-rooms 241/242
287 luxury-rooms 241/242
289 vip-rooms 241/242
360 test123-en-17 166/234/235
358 test123-en-15 166/234/235
315 luxury-rooms-en 241/242
366 test123-en-22 166/234/235
364 test123-en-20 166/234/235
365 test123-en-21 166/234/235
355 test123-en-9 166/234/235
356 test123-en-12 166/234/235
361 test123-en-18 166/234/235
363 test123-en-19 166/234/235
341 test123-en-4 166/234/235
357 test123-en-14 166/234/235
331 test123 166/234/235
335 test123-en-2 166/234/235
359 test123-en-16 166/234/235
339 test123-en-3 166/234/235
435 2011-ice-queen-en-2 203/215/216
345 2011-ice-queen-en-4 203/215/216
368 test123-en-24 166/234/235
367 test123-en-23 166/234/235
352 18-55mm-portrait-lens-en 166/196/200
353 18-55mm-portrait-lens-en-2 166/196/200
354 18-55mm-portrait-lens-en-3 166/196/200
346 2011-ice-queen-en-5 203/215/216
439 2011-ice-queen-en-6 203/215/216
443 2011-ice-queen-en-7 203/215/216
349 46-class-45-9-diag-lcd-610-series-tv-en-2 166/174/191
350 46-class-45-9-diag-lcd-610-series-tv-en-3 166/174/191
428 46-class-45-9-diag-lcd-610-series-tv-en-4 166/174/191
450 65-class-64-5-diag-led-8000-series-smart-tv-en 166/174/190
451 65-class-64-5-diag-led-8000-series-smart-tv-en-2 166/174/190
452 65-class-64-5-diag-led-8000-series-smart-tv-en-3 166/174/190
453 65-class-64-5-diag-led-8000-series-smart-tv-en-4 166/174/190
454 65-class-64-5-diag-led-8000-series-smart-tv-en-5 166/174/190
455 65-class-64-5-diag-led-8000-series-smart-tv-en-6 166/174/190
429 2011-tycoon-en-3 203/215/216
430 2011-tycoon-en-4 203/215/216
369 test123-en-25 166/234/235
370 test123-en-26 166/234/235
379 test123-en-27 166/234/235
380 test123-en-28 166/234/235
381 test123-en-29 166/234/235
382 test123-en-30 166/234/235
383 test123-en-31 166/234/235
384 test123-en-32 166/234/235
385 test123-en-33 166/234/235
386 test123-en-34 166/234/235
387 test123-en-35 166/234/235
388 test123-en-36 166/234/235
389 test123-en-37 166/234/235
390 test123-en-38 166/234/235
391 test123-en-39 166/234/235
392 test123-en-40 166/234/235
393 test123-en-41 166/234/235
394 test123-en-42 166/234/235
395 test123-en-43 166/234/235
396 test123-en-44 166/234/235
397 test123-en-45 166/234/235
398 test123-en-46 166/234/235
399 test123-en-47 166/234/235
400 test123-en-48 166/234/235
401 test123-en-49 166/234/235
402 test123-en-50 166/234/235
403 test123-en-51 166/234/235
404 test123-en-52 166/234/235
405 test123-en-53 166/234/235
406 test123-en-54 166/234/235
407 test123-en-55 166/234/235
408 test123-en-56 166/234/235
409 test123-en-57 166/234/235
410 test123-en-58 166/234/235
411 test123-en-59 166/234/235
412 test123-en-60 166/234/235
413 test123-en-61 166/234/235
414 test123-en-62 166/234/235
415 test123-en-63 166/234/235
416 test123-en-64 166/234/235
417 test123-en-65 166/234/235
418 test123-en-66 166/234/235
419 test123-en-67 166/234/235
420 test123-en-68 166/234/235
421 test123-en-69 166/234/235
422 test123-en-70 166/234/235
423 test123-en-71 166/234/235
424 test123-en-72 166/234/235
425 test123-en-73 166/234/235
426 test123-en-74 166/234/235
362 test123-en-75 166/234/235