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 (
    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, 
    147, 
    148, 
    149, 
    150, 
    151, 
    152, 
    153, 
    154, 
    155, 
    156, 
    157, 
    158, 
    159, 
    160, 
    161, 
    162, 
    163, 
    164, 
    165, 
    167, 
    168, 
    169, 
    170, 
    171, 
    172, 
    173, 
    174, 
    175, 
    176, 
    177, 
    178, 
    179, 
    180, 
    181, 
    182, 
    183, 
    184
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00200

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 (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,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184)) 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
222 series-3-15-6-laptop 167/169
108 due-date-blu-ray 241/242
88 lord-of-the-rings-war-in-the-north-ps3 245/247
160 drifter-3 203/204/210
243 apple-ipod-classic-white 166/177/178
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
233 crystal-lake-warm-weather-sleeping-bag 203/215/217
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
122 evolution-sst-2-xo-complete-bike-10spd12 203/204/208
126 casio-prizm-fx-cg10 250/251
224 samsung-galaxy-tab-8-9-at-and-t 167/165
230 2011-pit-boss 203/215/216
235 everglades-cold-weather-sleeping-bag 203/215/217
236 weathermaster-screened-6-tent-with-hinged-door 203/215/218
90 f-e-a-r-3-ps3-mx 245/247
82 legend-of-the-guardians-the-owls-of-gahoole-vg 245/246
177 cg-black-driver 203/211/212
181 womens-bloom-complete-set 203/211/212
124 truth-sst-2-x9-complete-bike-10spd-12 203/204/208
239 apple-iphone-4s-white 166/234/235
142 yamaha-tsx-130wh 166/177/180
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
167 d3100-18-55-vr-lens-kit 166/196/197
229 hp-2711x-27-led-monitor 167/170
132 samsung-galaxy-player-5-0 166/177/182
227 acer-3d-series-hn274h-bmiiid 167/170
228 lg-d2342p-pn 167/170
170 588-chrome-wedge 203/211/212
232 2011-ice-queen 203/215/216
150 wildwood-city-classic 203/204/210
158 aiko-safe-model-economy-as-30-home-safe-with-single-key 250/253
149 8gb-e-series-walkman-video-mp3 166/177/179
172 compact-full-hd-camcorder 166/196/199
238 apple-iphone-4s-black 166/234/235
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
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
152 drifter-2 203/204/210
151 wildwood-classic 203/204/210
131 catania 203/204/209
129 fore-cr1 203/204/209
127 fore-cr5-sram-red 203/204/209
234 white-water-cool-weather-sleeping-bag 203/215/217
115 evolve-sst-2-x9-complete-bike-10spd-12 203/204/208
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
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
178 wilson-jones-364-heavy-duty-round-ring-binder-with-label-holder-1-black 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
100 the-hangover-part-ii-blu-ray 241/242
79 adizero-tempaia-shoes 223/226
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
130 casio-dr-210tm 250/251
128 casio-fx-115es 250/251
121 fringe-the-complete-third-season 241/244
118 smallville-the-complete-tenth-season 241/244
123 supernatural-the-complete-sixth-season 241/244
119 the-big-bang-theory-the-complete-fourth-season 241/244
140 yamaha-pdx-11-db 166/177/180
141 yamaha-pdx-11-gr 166/177/180
144 yamaha-pdx-30bu 166/177/180
143 yamaha-pdx-30pi 166/177/180
242 apple-ipod-classic-black 166/177/178
225 samsung-galaxy-tab-7-0-verizon 167/165
217 asus-cp6230 167/168
218 asus-essentio-cp1130 167/168
137 ultimate-marvel-vs-capcom-3 245/249
215 intel-core-i7-processor-extreme-edition-980x-i7-980x 167/201
226 intel-core-i7-processor-i7-950 167/201
134 creative-zen-style-m300-mp3-player-16gb-black 166/177/182
135 creative-zen-touch-2-mp3-player-8gb-black 166/177/182
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
168 d300s-body-only 166/196/197
161 mv800-16-1-megapixel-multiview-compact-digital-camera 166/196/198
165 nikon-1-j1-one-lens-kit-white 166/196/198
164 wb210-10mb-14-megapixel-slim-digital-camera-red 166/196/198
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
145 sansa-fuze-mp3-player-red-4gb 166/177/179
138 ridge-racer 245/249
139 shinobido-2-revenge-of-zen 245/249
156 extra-bass-headphones-70mm 166/177/181
154 jr900-wireless-headphones 166/177/181
155 porta-pro-ktc-on-ear-headphone 166/177/181
157 studio-monitor-headphones 166/177/181
153 ur55-full-size-headphones 166/177/181
175 f50-flash-memory-52x-zoom-camcorder-silver 166/196/199
173 h300-long-zoom-compact-full-hd-camcorder-black 166/196/199
184 samsung-30mm-nx-pancake-lens 166/196/200
183 samsung-50-200mm-nx-telephoto-ois-lens 166/196/200
96 batman-arkham-city-x360-ce 245/248
95 game-party-in-motion-x360 245/248
93 scene-it-bright-lights-big-screen-x360 245/248
89 green-lantern-rise-of-the-manhunters-ps3 245/247
84 lego-batman-wii 245/246
85 looney-tunes-acme-arsenal-wii 245/246
87 sesame-street-cookies-counting-carnival-wii 245/246
83 speed-racer-the-videogame-wii 245/246