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 (
    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, 
    213, 
    215, 
    217, 
    218, 
    220, 
    222, 
    224, 
    225, 
    226, 
    227, 
    228, 
    229, 
    230, 
    231, 
    232, 
    233, 
    234, 
    235, 
    236, 
    237, 
    238, 
    239, 
    242, 
    243, 
    78, 
    79, 
    80, 
    81, 
    82, 
    83, 
    84, 
    85, 
    86, 
    87, 
    88, 
    89, 
    90, 
    91, 
    92, 
    93, 
    94, 
    95, 
    96, 
    97, 
    100, 
    101, 
    102, 
    103, 
    104, 
    105, 
    106, 
    107, 
    108, 
    109, 
    110, 
    111, 
    112, 
    113, 
    114, 
    115, 
    116, 
    117, 
    118, 
    119, 
    120, 
    121, 
    122, 
    123, 
    124, 
    125, 
    126, 
    127, 
    128, 
    129, 
    130, 
    131, 
    132, 
    133, 
    134, 
    135, 
    136, 
    137, 
    138, 
    139, 
    140, 
    141, 
    142, 
    143, 
    144, 
    145, 
    146
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00187

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "82.26"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "rows_examined_per_scan": 379,
      "rows_produced_per_join": 134,
      "filtered": "35.62",
      "cost_info": {
        "read_cost": "55.26",
        "eval_cost": "27.00",
        "prefix_cost": "82.26",
        "data_read_per_join": "228K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`pankajecarter_systemsix`.`cscart_seo_names`.`object_id` in (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,213,215,217,218,220,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,242,243,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146)) and (`pankajecarter_systemsix`.`cscart_seo_names`.`type` = 'p') and (`pankajecarter_systemsix`.`cscart_seo_names`.`dispatch` = '') and (`pankajecarter_systemsix`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
242 apple-ipod-classic-black 166/177/178
243 apple-ipod-classic-white 166/177/178
213 intel-boxed-intel-core-i7-2600 167/201
215 intel-core-i7-processor-extreme-edition-980x-i7-980x 167/201
226 intel-core-i7-processor-i7-950 167/201
94 batman-arkham-city-x360 245/248
96 batman-arkham-city-x360-ce 245/248
136 blazblue-continuum-shift-extend 245/249
90 f-e-a-r-3-ps3-mx 245/247
95 game-party-in-motion-x360 245/248
89 green-lantern-rise-of-the-manhunters-ps3 245/247
82 legend-of-the-guardians-the-owls-of-gahoole-vg 245/246
84 lego-batman-wii 245/246
85 looney-tunes-acme-arsenal-wii 245/246
88 lord-of-the-rings-war-in-the-north-ps3 245/247
138 ridge-racer 245/249
93 scene-it-bright-lights-big-screen-x360 245/248
87 sesame-street-cookies-counting-carnival-wii 245/246
139 shinobido-2-revenge-of-zen 245/249
83 speed-racer-the-videogame-wii 245/246
137 ultimate-marvel-vs-capcom-3 245/249
248 x-box-one 245/248
280 t-shirt-color-black 223/224
282 t-shirt-color-blue 223/224
278 t-shirt-color-white 223/224
78 adizero-rush-shoes 223/226
232 2011-ice-queen 203/215/216
230 2011-pit-boss 203/215/216
238 apple-iphone-4s-black 166/234/235
241 apple-ipad-with-retina-display-wi-fi-32gb-white 167/165
240 apple-ipad-with-retina-display-wi-fi-64gb-black 167/165
247 nokia-n1-pad-7-9-quad-core-64bit-2-3ghz-2gb-32gb-android-5-0 167/165
223 samsung-galaxy-tab-8-9-wi-fi-only-32gb-metallic-gray 167/165
225 samsung-galaxy-tab-7-0-verizon 167/165
224 samsung-galaxy-tab-8-9-at-and-t 167/165
231 2011-tycoon 203/215/216
227 acer-3d-series-hn274h-bmiiid 167/170
79 adizero-tempaia-shoes 223/226
245 apple-iphone-5c-32gb-cell-phone-green 166/234/235
239 apple-iphone-4s-white 166/234/235
214 asus-cp6130 167/168
217 asus-cp6230 167/168
200 john-rutter-the-colours-of-christmas 228/230
97 harry-potter-and-the-deathly-hallows-part-2-blu-raydvdultraviolet-digital-copy-combo-pack 241/242
124 truth-sst-2-x9-complete-bike-10spd-12 203/204/208
222 series-3-15-6-laptop 167/169
244 packard-bell-onetwo 167/168
211 hp-officejet-pro-8600-premium-e-all-in-one-printer 167/172
237 elite-evanston-8-tent 203/215/218
197 guitar-man-album-artwork 228/229
92 montblanc-timewalker-automatic 223/227
205 dir-657-hd-media-router-1000 167/171
128 casio-fx-115es 250/251
115 evolve-sst-2-x9-complete-bike-10spd-12 203/204/208
134 creative-zen-style-m300-mp3-player-16gb-black 166/177/182
219 series-3-15-6-laptop-en 167/169
220 series-7-chronos-14-notebook 167/169
221 series-9-13-3-laptop 167/169
194 u218-singles-u2tcd020 228/232
236 weathermaster-screened-6-tent-with-hinged-door 203/215/218
208 h-264-megapixel-surveillance-camera-tl-sc3430 167/171
117 sch-i515 166/234/237
203 new-years-concert-2012-diverse-wr-philharmoniker-jansons-m-wr-san 228/230
206 rt-n66u-dual-band-wireless-n900-gigabit-router 167/171
127 fore-cr5-sram-red 203/204/209
198 b-b-king-one-kind-favor-cd-grammy-award-winning-cd-manufacturer-geffen-records-sku-bbk-11onekindfavorcd-reviewed-2-times 228/229
125 samsung-galaxy-s-ii 166/234/237
120 samsung-galaxy-s-ii-epic-4g-touch-black 166/234/237
113 sgh-i677 166/234/237
129 fore-cr1 203/204/209
114 birds-of-prey-the-complete-series-dvd 241/243
246 gopro-hero3-black-edition-camera 166/196/199
199 b-b-king-original-greatest-hits-cd 228/229
196 feeding-the-monkies-at-ma-maison-zappa 228/232
218 asus-essentio-cp1130 167/168
207 asus-usb-n53 167/171
201 beethoven-piano-concertos-nos-1-and-2 228/230
192 black-and-white-america-cd-pack 228/232
130 casio-dr-210tm 250/251
126 casio-prizm-fx-cg10 250/251
131 catania 203/204/209
135 creative-zen-touch-2-mp3-player-8gb-black 166/177/182
195 crossroads-guitar-festival-2010-2dvd 228/232
233 crystal-lake-warm-weather-sleeping-bag 203/215/217
116 i-am-legend-dvd-ws 241/243
210 hp-photosmart-plus-e-all-in-one-printer-b210a 167/172
103 fringe-the-complete-third-season-blu-ray 241/242
80 nike-tenkay-slip-txtl-womens-shoe 223/226
104 final-destination-5-blu-ray 241/242
91 montblanc-nicolas-rieussec-chronograph-automatic 223/227
166 nikon-1-j1-two-lens-wide-angle-kit-red 166/196/198
209 hp-scanjet-g3110-scanner 167/172
228 lg-d2342p-pn 167/170
141 yamaha-pdx-11-gr 166/177/180
66 xrs-9970g 166/175/189
111 last-samurai-the-dvd-ws 241/243
100 the-hangover-part-ii-blu-ray 241/242
109 montblanc-contemporary-collection-key-ring-with-montblanc-emblem 223/227
102 pr-100-womens-white-quartz-watch 223/227
234 white-water-cool-weather-sleeping-bag 203/215/217
229 hp-2711x-27-led-monitor 167/170
6 toshiba-32c120u-32-class-720p-hd-lcd-tv 166/174/191
133 samsung-galaxy-player-4-0 166/177/179
108 due-date-blu-ray 241/242
132 samsung-galaxy-player-5-0 166/177/182
118 smallville-the-complete-tenth-season 241/244
140 yamaha-pdx-11-db 166/177/180
144 yamaha-pdx-30bu 166/177/180
143 yamaha-pdx-30pi 166/177/180
142 yamaha-tsx-130wh 166/177/180
235 everglades-cold-weather-sleeping-bag 203/215/217
122 evolution-sst-2-xo-complete-bike-10spd12 203/204/208
121 fringe-the-complete-third-season 241/244
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
107 montblanc-classic-collection-money-clip 223/227
204 the-police-the-stewart-copeland-anthology 228/232
212 panasonic-kx-mb2000-24ppm-3-in-1-monochrome-laser-mfp 167/172
146 sansa-clip-mp3-player-blue-4gb 166/177/179
202 new-years-concert-2011-diverse-klassik-welser-moest-wiener-philharmoniker 228/230
123 supernatural-the-complete-sixth-season 241/244
119 the-big-bang-theory-the-complete-fourth-season 241/244
81 minnetonka-original-cowhide-driving-moc 223/226
112 gone-with-the-wind-2-disc-special-edition 241/243
110 roots-30th-anniversary-special-edition-dvd 241/243
145 sansa-fuze-mp3-player-red-4gb 166/177/179