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 (
    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
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00115

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "115.21"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code"
      ],
      "key_length": "206",
      "rows_examined_per_scan": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "index_condition": "((`danishecarter_latest`.`cscart_seo_names`.`object_id` in (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)) and (`danishecarter_latest`.`cscart_seo_names`.`type` = 'p') and (`danishecarter_latest`.`cscart_seo_names`.`dispatch` = '') and (`danishecarter_latest`.`cscart_seo_names`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "105.61",
        "eval_cost": "9.60",
        "prefix_cost": "115.21",
        "data_read_per_join": "81K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
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
100 the-hangover-part-ii-blu-ray 241/242
101 nokia-x3-02 166/234/238
102 pr-100-womens-white-quartz-watch 223/227
103 fringe-the-complete-third-season-blu-ray 241/242
104 final-destination-5-blu-ray 241/242
105 nokia-lumia-800 166/234/238
106 nokia-e5-00 166/234/238
107 montblanc-classic-collection-money-clip 223/227
108 due-date-blu-ray 241/242
109 montblanc-contemporary-collection-key-ring-with-montblanc-emblem 223/227
110 roots-30th-anniversary-special-edition-dvd 241/243
111 last-samurai-the-dvd-ws 241/243
112 gone-with-the-wind-2-disc-special-edition 241/243
113 sgh-i677 166/234/237
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
117 sch-i515 166/234/237
118 smallville-the-complete-tenth-season 241/244
119 the-big-bang-theory-the-complete-fourth-season 241/244
120 samsung-galaxy-s-ii-epic-4g-touch-black 166/234/237
121 fringe-the-complete-third-season 241/244
122 evolution-sst-2-xo-complete-bike-10spd12 203/204/208
123 supernatural-the-complete-sixth-season 241/244
124 truth-sst-2-x9-complete-bike-10spd-12 203/204/208
125 samsung-galaxy-s-ii 166/234/237
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
132 samsung-galaxy-player-5-0 166/177/182
133 samsung-galaxy-player-4-0 166/177/179
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
137 ultimate-marvel-vs-capcom-3 245/249
138 ridge-racer 245/249
139 shinobido-2-revenge-of-zen 245/249
140 yamaha-pdx-11-db 166/177/180
141 yamaha-pdx-11-gr 166/177/180
142 yamaha-tsx-130wh 166/177/180
143 yamaha-pdx-30pi 166/177/180
144 yamaha-pdx-30bu 166/177/180