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 (
    276524, 276525, 276526, 276527, 276528, 
    276529, 276530, 276531, 276532, 276533, 
    276534, 276535, 276536, 276537, 276538, 
    276539, 276540, 276541, 276542, 276543
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00134

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "14.70"
    },
    "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": 20,
      "rows_produced_per_join": 20,
      "filtered": "100.00",
      "index_condition": "((`s2cart`.`cscart_seo_names`.`object_id` in (276524,276525,276526,276527,276528,276529,276530,276531,276532,276533,276534,276535,276536,276537,276538,276539,276540,276541,276542,276543)) and (`s2cart`.`cscart_seo_names`.`type` = 'p') and (`s2cart`.`cscart_seo_names`.`dispatch` = '') and (`s2cart`.`cscart_seo_names`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "12.70",
        "eval_cost": "2.00",
        "prefix_cost": "14.70",
        "data_read_per_join": "33K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
276524 abb-miniature-circuit-breaker-276525 5188/4936
276525 abb-miniature-circuit-breaker-276526 5188/4936
276526 abb-miniature-circuit-breaker-276527 5188/4936
276527 abb-miniature-circuit-breaker-276528 5188/4936
276528 abb-miniature-circuit-breaker-276529 5188/4936
276529 abb-miniature-circuit-breaker-276530 5188/4936
276530 abb-miniature-circuit-breaker-276531 5188/4936
276531 abb-miniature-circuit-breaker-276532 5188/4936
276532 abb-miniature-circuit-breaker-276533 5188/4936
276533 abb-miniature-circuit-breaker-276534 5188/4936
276534 abb-miniature-circuit-breaker-276535 5188/4936
276535 abb-miniature-circuit-breaker-276536 5188/4936
276536 abb-miniature-circuit-breaker-276537 5188/4936
276537 abb-miniature-circuit-breaker-276538 5188/4936
276538 abb-miniature-circuit-breaker-276539 5188/4936
276539 abb-miniature-circuit-breaker-276540 5188/4936
276540 abb-miniature-circuit-breaker-276541 5188/4936
276541 abb-miniature-circuit-breaker-s200m-4p-c 5188/4936
276542 abb-miniature-circuit-breaker-s200m-4p-c-276543 5188/4936
276543 abb-miniature-circuit-breaker-s200m-4p-c-276544 5188/4936