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 (
    211, 
    210, 
    209, 
    67, 
    25, 
    116, 
    213, 
    215, 
    226, 
    200, 
    154, 
    53, 
    52, 
    111, 
    82, 
    84, 
    228, 
    85, 
    88, 
    287, 
    315, 
    26, 
    35, 
    47, 
    81, 
    107, 
    109, 
    91, 
    92, 
    161, 
    188, 
    202, 
    203, 
    34, 
    31, 
    38, 
    80, 
    165, 
    166, 
    86, 
    106, 
    105, 
    247, 
    101, 
    33, 
    32, 
    163, 
    244, 
    212, 
    155, 
    102, 
    55, 
    176, 
    69, 
    138, 
    110, 
    36, 
    206, 
    28, 
    184, 
    183, 
    133, 
    132, 
    125, 
    120, 
    223, 
    225, 
    224, 
    146, 
    147, 
    93, 
    117, 
    219, 
    222, 
    220, 
    221, 
    87, 
    113, 
    139, 
    118, 
    83, 
    157, 
    286, 
    123, 
    174, 
    171, 
    280, 
    282, 
    278, 
    331, 
    335, 
    339, 
    341, 
    355, 
    356, 
    357, 
    358, 
    359, 
    360, 
    361, 
    362, 
    363, 
    364, 
    365, 
    366, 
    367, 
    368, 
    369, 
    370, 
    379, 
    380, 
    381, 
    382, 
    383, 
    384, 
    385, 
    386, 
    387, 
    388, 
    389, 
    390, 
    391, 
    392, 
    393, 
    394, 
    395, 
    396, 
    397
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00247

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": 141,
      "filtered": "25.45",
      "cost_info": {
        "read_cost": "90.88",
        "eval_cost": "28.20",
        "prefix_cost": "119.08",
        "data_read_per_join": "239K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`pankajecarter_systemfour`.`cscart_seo_names`.`object_id` in (211,210,209,67,25,116,213,215,226,200,154,53,52,111,82,84,228,85,88,287,315,26,35,47,81,107,109,91,92,161,188,202,203,34,31,38,80,165,166,86,106,105,247,101,33,32,163,244,212,155,102,55,176,69,138,110,36,206,28,184,183,133,132,125,120,223,225,224,146,147,93,117,219,222,220,221,87,113,139,118,83,157,286,123,174,171,280,282,278,331,335,339,341,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397)) 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
222 series-3-15-6-laptop 167/169
34 nike-untouchable-womens-tank-top 223/225
88 lord-of-the-rings-war-in-the-north-ps3 245/247
223 samsung-galaxy-tab-8-9-wi-fi-only-32gb-metallic-gray 167/165
219 series-3-15-6-laptop-en 167/169
206 rt-n66u-dual-band-wireless-n900-gigabit-router 167/171
212 panasonic-kx-mb2000-24ppm-3-in-1-monochrome-laser-mfp 167/172
213 intel-boxed-intel-core-i7-2600 167/201
107 montblanc-classic-collection-money-clip 223/227
109 montblanc-contemporary-collection-key-ring-with-montblanc-emblem 223/227
55 prs-d800 166/175/187
224 samsung-galaxy-tab-8-9-at-and-t 167/165
82 legend-of-the-guardians-the-owls-of-gahoole-vg 245/246
188 new-wilson-staff-fifty-elite-yellow-golf-ball 203/211/213
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
220 series-7-chronos-14-notebook 167/169
86 nokia-700 166/234/238
106 nokia-e5-00 166/234/238
105 nokia-lumia-800 166/234/238
101 nokia-x3-02 166/234/238
163 nx200-20-3-megapixel-compact-system-camera 166/196/198
132 samsung-galaxy-player-5-0 166/177/182
228 lg-d2342p-pn 167/170
280 t-shirt-color-black 223/224
282 t-shirt-color-blue 223/224
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
53 kfc-w3012 166/175/202
52 kfc-w3013ps 166/175/202
33 nuvi-2455lt 166/175/176
32 nuvi-3450 166/175/176
116 i-am-legend-dvd-ws 241/243
111 last-samurai-the-dvd-ws 241/243
110 roots-30th-anniversary-special-edition-dvd 241/243
176 quartet-euro-magnetic-porcelain-total-erase-mobile-easel 250/252
174 swingline-optima-20-electric-stapler 250/252
171 swingline-stack-and-shred-100x-hands-free-shredder 250/252
26 mac-os-x-lion-the-missing-manual 219/220
35 managing-enterprise-content-a-unified-content-strategy-2nd-edition 219/220
36 routing-protocols-and-concepts-ccna-exploration-companion-guide 219/220
81 minnetonka-original-cowhide-driving-moc 223/226
80 nike-tenkay-slip-txtl-womens-shoe 223/226
91 montblanc-nicolas-rieussec-chronograph-automatic 223/227
92 montblanc-timewalker-automatic 223/227
102 pr-100-womens-white-quartz-watch 223/227
118 smallville-the-complete-tenth-season 241/244
123 supernatural-the-complete-sixth-season 241/244
247 nokia-n1-pad-7-9-quad-core-64bit-2-3ghz-2gb-32gb-android-5-0 167/165
225 samsung-galaxy-tab-7-0-verizon 167/165
244 packard-bell-onetwo 167/168
28 run-perf-7-8-ti 223/225
31 nike-classic-solid-womens-jersey-shorts 223/225
38 nike-futura-unravel-womens-t-shirt 223/225
215 intel-core-i7-processor-extreme-edition-980x-i7-980x 167/201
226 intel-core-i7-processor-i7-950 167/201
221 series-9-13-3-laptop 167/169
125 samsung-galaxy-s-ii 166/234/237
120 samsung-galaxy-s-ii-epic-4g-touch-black 166/234/237
117 sch-i515 166/234/237
113 sgh-i677 166/234/237
161 mv800-16-1-megapixel-multiview-compact-digital-camera 166/196/198
165 nikon-1-j1-one-lens-kit-white 166/196/198
166 nikon-1-j1-two-lens-wide-angle-kit-red 166/196/198
25 hw-d7000-av-receiver-with-built-in-blu-ray-disc-player 166/174/195
133 samsung-galaxy-player-4-0 166/177/179
146 sansa-clip-mp3-player-blue-4gb 166/177/179
147 sansa-clip-mp3-player-red-4gb 166/177/179
138 ridge-racer 245/249
139 shinobido-2-revenge-of-zen 245/249
67 htc-wildfire-s-white-t-mobile 166/234/236
69 rhyme 166/234/236
154 jr900-wireless-headphones 166/177/181
155 porta-pro-ktc-on-ear-headphone 166/177/181
157 studio-monitor-headphones 166/177/181
184 samsung-30mm-nx-pancake-lens 166/196/200
183 samsung-50-200mm-nx-telephoto-ois-lens 166/196/200
93 scene-it-bright-lights-big-screen-x360 245/248
84 lego-batman-wii 245/246
85 looney-tunes-acme-arsenal-wii 245/246
47 marvel-vs-capcom-3-fate-of-two-worlds-special-edition-ps3 245/247
87 sesame-street-cookies-counting-carnival-wii 245/246
83 speed-racer-the-videogame-wii 245/246
286 super-luxury-rooms 241/242
287 luxury-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
368 test123-en-24 166/234/235
367 test123-en-23 166/234/235
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
362 test123-en-75 166/234/235