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 (
    100442, 100443, 100444, 100445, 100446, 
    100447, 100448, 100449, 100450, 100451, 
    100452, 100453, 100454, 100455, 100456, 
    100457, 100458, 100459, 100460, 100461, 
    100462, 100463, 100464, 100465
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00101

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.82"
    },
    "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",
      "cost_info": {
        "read_cost": "8.42",
        "eval_cost": "2.40",
        "prefix_cost": "10.82",
        "data_read_per_join": "40K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (100442,100443,100444,100445,100446,100447,100448,100449,100450,100451,100452,100453,100454,100455,100456,100457,100458,100459,100460,100461,100462,100463,100464,100465)) and (`nuie_scalesta_net`.`cscart_seo_names`.`type` = 'p') and (`nuie_scalesta_net`.`cscart_seo_names`.`dispatch` = '') and (`nuie_scalesta_net`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
100442 sy-vod06-b-p 7165/7168/7177
100443 sy-vod07-b-p 7165/7168/7177
100444 sy-vod08-b-p 7165/7168/7177
100445 sy-vod14-b-p 7165/7168/7176
100446 sy-vod15-b-p 7165/7168/7176
100447 sy-vod16-b-p 7165/7168/7176
100448 sy-vod18-b-p 7165/7168/7179
100449 sy-vod19-b-p 7165/7168/7179
100450 sy-vod59-b-p 7165/7168/7174
100451 sy-vod60-b-p 7165/7168/7174
100452 sy-vod61-b-p 7165/7168/7174
100453 sy-vod62-b-p 7165/7168/7174
100454 sy-vod63-b-p 7165/7168/7174
100455 sy-vod64-b-p 7165/7168/7174
100456 sy-vod65-b-p 7165/7168/7174
100457 sy-vod66-b-p 7165/7168/7174
100458 sy-vod67-b-p 7165/7168/7173
100459 sy-vod68-b-p 7165/7168/7173
100460 sy-vod69-b-p 7165/7168/7173
100461 sy-vod70-b-p 7165/7168/7176
100462 sy-vod71-b-p 7165/7168/7176
100463 sy-vod72-b-p 7165/7168/7176
100464 sy-vod73-b-p 7165/7168/7174
100465 sy-vod74-b-p 7165/7168/7174