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 (
    17, 
    148, 
    180, 
    187, 
    232, 
    230, 
    231, 
    18, 
    16, 
    4, 
    5, 
    23, 
    24, 
    170, 
    1, 
    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, 
    211, 
    210, 
    209, 
    67, 
    25, 
    116, 
    213, 
    215, 
    226, 
    200, 
    154, 
    53, 
    52, 
    111, 
    82, 
    84, 
    228, 
    85, 
    88, 
    26
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00476

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "40.60"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "ref",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "dispatch",
      "used_key_parts": [
        "dispatch"
      ],
      "key_length": "194",
      "ref": [
        "const"
      ],
      "rows_examined_per_scan": 128,
      "rows_produced_per_join": 0,
      "filtered": "0.50",
      "index_condition": "((`twebezli_Commercemodalpopup`.`cscart_seo_names`.`object_id` in (17,148,180,187,232,230,231,18,16,4,5,23,24,170,1,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,211,210,209,67,25,116,213,215,226,200,154,53,52,111,82,84,228,85,88,26)) and (`twebezli_Commercemodalpopup`.`cscart_seo_names`.`type` = 'p') and (`twebezli_Commercemodalpopup`.`cscart_seo_names`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "15.00",
        "eval_cost": "0.13",
        "prefix_cost": "40.60",
        "data_read_per_join": "1K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
1 65-class-64-5-diag-led-8000-series-smart-tv 166/174/190
4 40-class-40-0-diag-led-5003-series-tv 166/174/190
5 46-class-45-9-diag-lcd-610-series-tv 166/174/191
11 collegiate-72-tee 223/224
16 3d-blu-ray-disc-player-bd-d7500 166/174/194
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
18 3d-blu-ray-disc-player-bd-d7000 166/174/194
22 7-1-channel-blu-ray-3d-home-theater-system 166/174/195
23 5-1-channel-blu-ray-3d-home-theater-system 166/174/195
24 5-1-channel-blu-ray-3d-home-theater-system-en 166/174/195
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
30 go-2535-tm-wte 166/175/176
37 dpx308u 166/175/185
39 deh-80prs 166/175/185
40 deh-p8400bh 166/175/185
41 gift-set-onesie-plus-socks 223/225
42 deh-1300mp 166/175/185
43 fh-p8000bt 166/175/185
52 kfc-w3013ps 166/175/202
53 kfc-w3012 166/175/202
56 gm-6500f 166/175/187
57 gm-d8500m 166/175/187
58 avh-p8400bh 166/175/188
59 avh-p4400bh 166/175/188
60 avic-z130bt 166/175/176
67 htc-wildfire-s-white-t-mobile 166/234/236
70 evo-design-4g 166/234/236
71 droid-incredible-2 166/234/236
72 droid-razr 166/234/240
73 droid-bionic 166/234/240
74 droid-3 166/234/240
75 droid-pro 166/234/240
76 flipside-with-motoblur 166/234/240
78 adizero-rush-shoes 223/226
79 adizero-tempaia-shoes 223/226
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
89 green-lantern-rise-of-the-manhunters-ps3 245/247
90 f-e-a-r-3-ps3-mx 245/247
94 batman-arkham-city-x360 245/248
95 game-party-in-motion-x360 245/248
96 batman-arkham-city-x360-ce 245/248
97 harry-potter-and-the-deathly-hallows-part-2-blu-raydvdultraviolet-digital-copy-combo-pack 241/242
103 fringe-the-complete-third-season-blu-ray 241/242
104 final-destination-5-blu-ray 241/242
108 due-date-blu-ray 241/242
111 last-samurai-the-dvd-ws 241/243
112 gone-with-the-wind-2-disc-special-edition 241/243
114 birds-of-prey-the-complete-series-dvd 241/243
115 evolve-sst-2-x9-complete-bike-10spd-12 203/204/208
116 i-am-legend-dvd-ws 241/243
121 fringe-the-complete-third-season 241/244
122 evolution-sst-2-xo-complete-bike-10spd12 203/204/208
126 casio-prizm-fx-cg10 250/251
127 fore-cr5-sram-red 203/204/209
128 casio-fx-115es 250/251
129 fore-cr1 203/204/209
130 casio-dr-210tm 250/251
131 catania 203/204/209
134 creative-zen-style-m300-mp3-player-16gb-black 166/177/182
135 creative-zen-touch-2-mp3-player-8gb-black 166/177/182
136 blazblue-continuum-shift-extend 245/249
148 16gb-a-series-walkman-video-mp3 166/177/179
149 8gb-e-series-walkman-video-mp3 166/177/179
152 drifter-2 203/204/210
154 jr900-wireless-headphones 166/177/181
156 extra-bass-headphones-70mm 166/177/181
158 aiko-safe-model-economy-as-30-home-safe-with-single-key 250/253
159 aiko-safe-model-as-53-home-safe-horizontal-model-with-one-tray 250/253
160 drifter-3 203/204/210
162 aiko-safe-model-as-180-office-safe-with-one-shelve-and-one-drawer 250/253
167 d3100-18-55-vr-lens-kit 166/196/197
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
170 588-chrome-wedge 203/211/212
172 compact-full-hd-camcorder 166/196/199
173 h300-long-zoom-compact-full-hd-camcorder-black 166/196/199
175 f50-flash-memory-52x-zoom-camcorder-silver 166/196/199
177 cg-black-driver 203/211/212
179 cg16-black-pearl-wedge 203/211/212
180 18-55mm-portrait-lens 166/196/200
182 gbc-smart-view-3-ring-report-cover 250/252
185 cg-lightweight-cart-bag 203/211/214
186 cg-black-staff-bag 203/211/214
187 2010-tour-staff-bag-10 203/211/214
189 af-s-nikkor-14-24mm-f-2-8g-ed 166/196/200
190 af-s-dx-nikkor-10-24mm-f-3-5-4-5g-ed 166/196/200
191 esperanza-spalding-radio-music-society 228/231
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
198 b-b-king-one-kind-favor-cd-grammy-award-winning-cd-manufacturer-geffen-records-sku-bbk-11onekindfavorcd-reviewed-2-times 228/229
199 b-b-king-original-greatest-hits-cd 228/229
200 john-rutter-the-colours-of-christmas 228/230
201 beethoven-piano-concertos-nos-1-and-2 228/230
205 dir-657-hd-media-router-1000 167/171
207 asus-usb-n53 167/171
208 h-264-megapixel-surveillance-camera-tl-sc3430 167/171
209 hp-scanjet-g3110-scanner 167/172
210 hp-photosmart-plus-e-all-in-one-printer-b210a 167/172
211 hp-officejet-pro-8600-premium-e-all-in-one-printer 167/172
213 intel-boxed-intel-core-i7-2600 167/201
214 asus-cp6130 167/168
215 intel-core-i7-processor-extreme-edition-980x-i7-980x 167/201
217 asus-cp6230 167/168
218 asus-essentio-cp1130 167/168
226 intel-core-i7-processor-i7-950 167/201
227 acer-3d-series-hn274h-bmiiid 167/170
228 lg-d2342p-pn 167/170
229 hp-2711x-27-led-monitor 167/170
230 2011-pit-boss 203/215/216
231 2011-tycoon 203/215/216
232 2011-ice-queen 203/215/216
233 crystal-lake-warm-weather-sleeping-bag 203/215/217
235 everglades-cold-weather-sleeping-bag 203/215/217
237 elite-evanston-8-tent 203/215/218
238 apple-iphone-4s-black 166/234/235
239 apple-iphone-4s-white 166/234/235
240 apple-ipad-with-retina-display-wi-fi-64gb-black 167/165
241 apple-ipad-with-retina-display-wi-fi-32gb-white 167/165
242 apple-ipod-classic-black 166/177/178
243 apple-ipod-classic-white 166/177/178
245 apple-iphone-5c-32gb-cell-phone-green 166/234/235
246 gopro-hero3-black-edition-camera 166/196/199