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 (
    189, 190, 191, 1, 5, 7, 8, 9, 10, 11, 12, 
    13, 14, 16, 17, 18, 19, 20, 21, 22, 23, 
    24, 25, 26
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00098

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "57.61"
    },
    "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": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "index_condition": "((`satishecarter_march_003`.`cscart_seo_names`.`object_id` in (189,190,191,1,5,7,8,9,10,11,12,13,14,16,17,18,19,20,21,22,23,24,25,26)) and (`satishecarter_march_003`.`cscart_seo_names`.`type` = 'p') and (`satishecarter_march_003`.`cscart_seo_names`.`dispatch` = '') and (`satishecarter_march_003`.`cscart_seo_names`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "52.81",
        "eval_cost": "4.80",
        "prefix_cost": "57.61",
        "data_read_per_join": "40K"
      },
      "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
5 46-class-45-9-diag-lcd-610-series-tv 166/174/191
7 trefoil-hoodie 223/224
8 toshiba-32tl515u-32-class-1080p-3d-led-hd-tv 166/174/193
9 toshiba-42tl515u-42-class-1080p-3d-led-hd-tv 166/174/193
10 toshiba-47tl515u-47-class-1080p-3d-led-hd-tv 166/174/193
11 collegiate-72-tee 223/224
12 100g-pants 223/224
13 your-idea-inc-12-steps-to-building-a-million-dollar-business-starting-today 219/222
14 toshiba-40e220u-40-class-1080p-hd-lcd-tv 166/174/191
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
19 toshiba-bdx2150-blu-ray-player 166/174/194
20 the-abcs-of-gold-investing-how-to-protect-and-build-your-wealth-with-gold 219/222
21 toshiba-sd3300-dvd-player 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
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