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 (
    187, 
    321, 
    323, 
    326, 
    329, 
    332, 
    16, 
    5, 
    24, 
    170, 
    1, 
    22, 
    149, 
    227, 
    78, 
    79, 
    190, 
    189, 
    162, 
    159, 
    158, 
    245, 
    238, 
    239, 
    242, 
    243, 
    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, 
    287, 
    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, 
    211, 
    210, 
    209, 
    67, 
    25, 
    116, 
    213, 
    215, 
    226, 
    200, 
    154, 
    53, 
    52, 
    111, 
    82, 
    84, 
    228, 
    85, 
    88, 
    26, 
    35, 
    47, 
    81, 
    107
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00315

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "135.53"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "rows_examined_per_scan": 631,
      "rows_produced_per_join": 139,
      "filtered": "22.03",
      "cost_info": {
        "read_cost": "107.73",
        "eval_cost": "27.80",
        "prefix_cost": "135.53",
        "data_read_per_join": "235K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`atulecarter_atul_demo2`.`cscart_seo_names`.`object_id` in (187,321,323,326,329,332,16,5,24,170,1,22,149,227,78,79,190,189,162,159,158,245,238,239,242,243,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,287,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,211,210,209,67,25,116,213,215,226,200,154,53,52,111,82,84,228,85,88,26,35,47,81,107)) and (`atulecarter_atul_demo2`.`cscart_seo_names`.`type` = 'p') and (`atulecarter_atul_demo2`.`cscart_seo_names`.`dispatch` = '') and (`atulecarter_atul_demo2`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
1 65-class-64-5-diag-led-8000-series-smart-tv 166/174/190
78 adizero-rush-shoes 223/226
170 588-chrome-wedge 203/211/212
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
172 compact-full-hd-camcorder 166/196/199
238 apple-iphone-4s-black 166/234/235
167 d3100-18-55-vr-lens-kit 166/196/197
237 elite-evanston-8-tent 203/215/218
173 h300-long-zoom-compact-full-hd-camcorder-black 166/196/199
41 gift-set-onesie-plus-socks 223/225
214 asus-cp6130 167/168
217 asus-cp6230 167/168
218 asus-essentio-cp1130 167/168
242 apple-ipod-classic-black 166/177/178
243 apple-ipod-classic-white 166/177/178
134 creative-zen-style-m300-mp3-player-16gb-black 166/177/182
135 creative-zen-touch-2-mp3-player-8gb-black 166/177/182
156 extra-bass-headphones-70mm 166/177/181
154 jr900-wireless-headphones 166/177/181
287 deluxe-room-with-two-queen-beds 166/177/182
190 af-s-dx-nikkor-10-24mm-f-3-5-4-5g-ed 166/196/200
71 droid-incredible-2 166/234/236
70 evo-design-4g 166/234/236
67 htc-wildfire-s-white-t-mobile 166/234/236
233 crystal-lake-warm-weather-sleeping-bag 203/215/217
235 everglades-cold-weather-sleeping-bag 203/215/217
122 evolution-sst-2-xo-complete-bike-10spd12 203/204/208
115 evolve-sst-2-x9-complete-bike-10spd-12 203/204/208
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
60 avic-z130bt 166/175/176
30 go-2535-tm-wte 166/175/176
59 avh-p4400bh 166/175/188
58 avh-p8400bh 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
43 fh-p8000bt 166/175/185
56 gm-6500f 166/175/187
57 gm-d8500m 166/175/187
187 2010-tour-staff-bag-10 203/211/214
16 3d-blu-ray-disc-player-bd-d7500 166/174/194
97 harry-potter-and-the-deathly-hallows-part-2-blu-raydvdultraviolet-digital-copy-combo-pack 241/242
191 esperanza-spalding-radio-music-society 228/231
111 last-samurai-the-dvd-ws 241/243
114 birds-of-prey-the-complete-series-dvd 241/243
108 due-date-blu-ray 241/242
104 final-destination-5-blu-ray 241/242
121 fringe-the-complete-third-season 241/244
103 fringe-the-complete-third-season-blu-ray 241/242
112 gone-with-the-wind-2-disc-special-edition 241/243
116 i-am-legend-dvd-ws 241/243
152 drifter-2 203/204/210
160 drifter-3 203/204/210
136 blazblue-continuum-shift-extend 245/249
130 casio-dr-210tm 250/251
128 casio-fx-115es 250/251
126 casio-prizm-fx-cg10 250/251
82 legend-of-the-guardians-the-owls-of-gahoole-vg 245/246
207 asus-usb-n53 167/171
94 batman-arkham-city-x360 245/248
177 cg-black-driver 203/211/212
179 cg16-black-pearl-wedge 203/211/212
73 droid-bionic 166/234/240
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
195 crossroads-guitar-festival-2010-2dvd 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
239 apple-iphone-4s-white 166/234/235
74 droid-3 166/234/240
75 droid-pro 166/234/240
72 droid-razr 166/234/240
76 flipside-with-motoblur 166/234/240
208 h-264-megapixel-surveillance-camera-tl-sc3430 167/171
11 collegiate-72-tee 223/224
240 apple-ipad-with-retina-display-wi-fi-64gb-black 167/165
182 gbc-smart-view-3-ring-report-cover 250/252
175 f50-flash-memory-52x-zoom-camcorder-silver 166/196/199
81 minnetonka-original-cowhide-driving-moc 223/226
168 d300s-body-only 166/196/197
169 d5100-af-s-dx-nikkor-18-55mm-f-3-5-5-6g-vr-lens-kit 166/196/197
79 adizero-tempaia-shoes 223/226
24 5-1-channel-blu-ray-3d-home-theater-system-en 166/174/195
22 7-1-channel-blu-ray-3d-home-theater-system 166/174/195
227 acer-3d-series-hn274h-bmiiid 167/170
189 af-s-nikkor-14-24mm-f-2-8g-ed 166/196/200
162 aiko-safe-model-as-180-office-safe-with-one-shelve-and-one-drawer 250/253
96 batman-arkham-city-x360-ce 245/248
159 aiko-safe-model-as-53-home-safe-horizontal-model-with-one-tray 250/253
245 apple-iphone-5c-32gb-cell-phone-green 166/234/235
107 montblanc-classic-collection-money-clip 223/227
127 fore-cr5-sram-red 203/204/209
131 catania 203/204/209
186 cg-black-staff-bag 203/211/214
185 cg-lightweight-cart-bag 203/211/214
321 2010-tour-staff-bag-10-en-3 203/211/214
323 2010-tour-staff-bag-10-en-6 203/211/214
326 2010-tour-staff-bag-10-en-9 203/211/214
329 2010-tour-staff-bag-10-en-12 203/211/214
332 2010-tour-staff-bag-10-en-15 203/211/214
246 gopro-hero3-black-edition-camera 166/196/199
228 lg-d2342p-pn 167/170
205 dir-657-hd-media-router-1000 167/171
88 lord-of-the-rings-war-in-the-north-ps3 245/247
95 game-party-in-motion-x360 245/248
226 intel-core-i7-processor-i7-950 167/201
90 f-e-a-r-3-ps3-mx 245/247
89 green-lantern-rise-of-the-manhunters-ps3 245/247
47 marvel-vs-capcom-3-fate-of-two-worlds-special-edition-ps3 245/247
213 intel-boxed-intel-core-i7-2600 167/201
215 intel-core-i7-processor-extreme-edition-980x-i7-980x 167/201
129 fore-cr1 203/204/209
229 hp-2711x-27-led-monitor 167/170
85 looney-tunes-acme-arsenal-wii 245/246
84 lego-batman-wii 245/246
25 hw-d7000-av-receiver-with-built-in-blu-ray-disc-player 166/174/195
26 mac-os-x-lion-the-missing-manual 219/220
35 managing-enterprise-content-a-unified-content-strategy-2nd-edition 219/220