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 (
    12, 
    17, 
    148, 
    180, 
    352, 
    353, 
    354, 
    187, 
    232, 
    345, 
    346, 
    435, 
    439, 
    443, 
    230, 
    231, 
    429, 
    430, 
    18, 
    16, 
    4, 
    5, 
    349, 
    350, 
    428, 
    23, 
    24, 
    170, 
    1, 
    450, 
    451, 
    452, 
    453, 
    454, 
    455, 
    22, 
    149, 
    227, 
    78, 
    79, 
    190, 
    189, 
    162, 
    159, 
    158, 
    245, 
    238, 
    239, 
    242, 
    243, 
    241, 
    240, 
    214, 
    217, 
    218, 
    207, 
    59, 
    58, 
    60, 
    199, 
    198, 
    94, 
    96, 
    201, 
    114, 
    192, 
    136, 
    130, 
    128, 
    126, 
    131, 
    177, 
    186, 
    185, 
    179, 
    11, 
    172, 
    134, 
    135, 
    195, 
    233, 
    168, 
    167, 
    169, 
    42, 
    39, 
    40, 
    205, 
    37, 
    152, 
    160, 
    74, 
    73, 
    71, 
    75, 
    72, 
    108, 
    237, 
    191, 
    235, 
    70, 
    122, 
    115, 
    156, 
    90, 
    175, 
    196, 
    43, 
    104, 
    76, 
    129, 
    127, 
    121, 
    103, 
    95, 
    182, 
    41, 
    56, 
    57, 
    30, 
    112, 
    246, 
    89, 
    197, 
    208, 
    173, 
    97, 
    229
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00203

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": 134,
      "filtered": "24.37",
      "cost_info": {
        "read_cost": "92.08",
        "eval_cost": "27.00",
        "prefix_cost": "119.08",
        "data_read_per_join": "228K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`pankajecarter_systemfour`.`cscart_seo_names`.`object_id` in (12,17,148,180,352,353,354,187,232,345,346,435,439,443,230,231,429,430,18,16,4,5,349,350,428,23,24,170,1,450,451,452,453,454,455,22,149,227,78,79,190,189,162,159,158,245,238,239,242,243,241,240,214,217,218,207,59,58,60,199,198,94,96,201,114,192,136,130,128,126,131,177,186,185,179,11,172,134,135,195,233,168,167,169,42,39,40,205,37,152,160,74,73,71,75,72,108,237,191,235,70,122,115,156,90,175,196,43,104,76,129,127,121,103,95,182,41,56,57,30,112,246,89,197,208,173,97,229)) 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
148 16gb-a-series-walkman-video-mp3 166/177/179
180 18-55mm-portrait-lens 166/196/200
241 apple-ipad-with-retina-display-wi-fi-32gb-white 167/165
108 due-date-blu-ray 241/242
160 drifter-3 203/204/210
243 apple-ipod-classic-white 166/177/178
187 2010-tour-staff-bag-10 203/211/214
78 adizero-rush-shoes 223/226
94 batman-arkham-city-x360 245/248
169 d5100-af-s-dx-nikkor-18-55mm-f-3-5-5-6g-vr-lens-kit 166/196/197
237 elite-evanston-8-tent 203/215/218
208 h-264-megapixel-surveillance-camera-tl-sc3430 167/171
60 avic-z130bt 166/175/176
12 100g-pants 223/224
11 collegiate-72-tee 223/224
233 crystal-lake-warm-weather-sleeping-bag 203/215/217
195 crossroads-guitar-festival-2010-2dvd 228/232
122 evolution-sst-2-xo-complete-bike-10spd12 203/204/208
58 avh-p8400bh 166/175/188
43 fh-p8000bt 166/175/185
126 casio-prizm-fx-cg10 250/251
230 2011-pit-boss 203/215/216
235 everglades-cold-weather-sleeping-bag 203/215/217
90 f-e-a-r-3-ps3-mx 245/247
177 cg-black-driver 203/211/212
186 cg-black-staff-bag 203/211/214
207 asus-usb-n53 167/171
239 apple-iphone-4s-white 166/234/235
16 3d-blu-ray-disc-player-bd-d7500 166/174/194
22 7-1-channel-blu-ray-3d-home-theater-system 166/174/195
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
191 esperanza-spalding-radio-music-society 228/231
196 feeding-the-monkies-at-ma-maison-zappa 228/232
197 guitar-man-album-artwork 228/229
190 af-s-dx-nikkor-10-24mm-f-3-5-4-5g-ed 166/196/200
214 asus-cp6130 167/168
240 apple-ipad-with-retina-display-wi-fi-64gb-black 167/165
167 d3100-18-55-vr-lens-kit 166/196/197
74 droid-3 166/234/240
30 go-2535-tm-wte 166/175/176
229 hp-2711x-27-led-monitor 167/170
205 dir-657-hd-media-router-1000 167/171
227 acer-3d-series-hn274h-bmiiid 167/170
1 65-class-64-5-diag-led-8000-series-smart-tv 166/174/190
170 588-chrome-wedge 203/211/212
232 2011-ice-queen 203/215/216
158 aiko-safe-model-economy-as-30-home-safe-with-single-key 250/253
149 8gb-e-series-walkman-video-mp3 166/177/179
5 46-class-45-9-diag-lcd-610-series-tv 166/174/191
23 5-1-channel-blu-ray-3d-home-theater-system 166/174/195
172 compact-full-hd-camcorder 166/196/199
238 apple-iphone-4s-black 166/234/235
59 avh-p4400bh 166/175/188
42 deh-1300mp 166/175/185
39 deh-80prs 166/175/185
40 deh-p8400bh 166/175/185
37 dpx308u 166/175/185
56 gm-6500f 166/175/187
57 gm-d8500m 166/175/187
136 blazblue-continuum-shift-extend 245/249
114 birds-of-prey-the-complete-series-dvd 241/243
112 gone-with-the-wind-2-disc-special-edition 241/243
152 drifter-2 203/204/210
185 cg-lightweight-cart-bag 203/211/214
131 catania 203/204/209
129 fore-cr1 203/204/209
127 fore-cr5-sram-red 203/204/209
115 evolve-sst-2-x9-complete-bike-10spd-12 203/204/208
245 apple-iphone-5c-32gb-cell-phone-green 166/234/235
231 2011-tycoon 203/215/216
179 cg16-black-pearl-wedge 203/211/212
162 aiko-safe-model-as-180-office-safe-with-one-shelve-and-one-drawer 250/253
159 aiko-safe-model-as-53-home-safe-horizontal-model-with-one-tray 250/253
182 gbc-smart-view-3-ring-report-cover 250/252
104 final-destination-5-blu-ray 241/242
103 fringe-the-complete-third-season-blu-ray 241/242
97 harry-potter-and-the-deathly-hallows-part-2-blu-raydvdultraviolet-digital-copy-combo-pack 241/242
79 adizero-tempaia-shoes 223/226
130 casio-dr-210tm 250/251
128 casio-fx-115es 250/251
121 fringe-the-complete-third-season 241/244
242 apple-ipod-classic-black 166/177/178
17 101-things-everyone-should-know-about-economics-a-down-and-dirty-guide-to-everything-from-securities-and-derivatives-to-interest-rates-and-hedge-fundsand-what-they-mean-for-you 219/222
217 asus-cp6230 167/168
218 asus-essentio-cp1130 167/168
41 gift-set-onesie-plus-socks 223/225
134 creative-zen-style-m300-mp3-player-16gb-black 166/177/182
135 creative-zen-touch-2-mp3-player-8gb-black 166/177/182
73 droid-bionic 166/234/240
75 droid-pro 166/234/240
72 droid-razr 166/234/240
76 flipside-with-motoblur 166/234/240
18 3d-blu-ray-disc-player-bd-d7000 166/174/194
4 40-class-40-0-diag-led-5003-series-tv 166/174/190
24 5-1-channel-blu-ray-3d-home-theater-system-en 166/174/195
189 af-s-nikkor-14-24mm-f-2-8g-ed 166/196/200
168 d300s-body-only 166/196/197
71 droid-incredible-2 166/234/236
70 evo-design-4g 166/234/236
156 extra-bass-headphones-70mm 166/177/181
175 f50-flash-memory-52x-zoom-camcorder-silver 166/196/199
246 gopro-hero3-black-edition-camera 166/196/199
173 h300-long-zoom-compact-full-hd-camcorder-black 166/196/199
96 batman-arkham-city-x360-ce 245/248
95 game-party-in-motion-x360 245/248
89 green-lantern-rise-of-the-manhunters-ps3 245/247
435 2011-ice-queen-en-2 203/215/216
345 2011-ice-queen-en-4 203/215/216
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