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 (
    100294, 100295, 100480, 100481, 100482, 
    100483, 100484, 100485, 100486, 100487, 
    100488, 100489, 100490, 100491, 100492, 
    100493, 100494, 100495, 100496, 100497, 
    100498, 100499, 100504, 100505, 100506, 
    100507, 100508, 100509, 100510, 100511
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00061

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "13.52"
    },
    "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": 30,
      "rows_produced_per_join": 30,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "10.52",
        "eval_cost": "3.00",
        "prefix_cost": "13.52",
        "data_read_per_join": "50K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (100294,100295,100480,100481,100482,100483,100484,100485,100486,100487,100488,100489,100490,100491,100492,100493,100494,100495,100496,100497,100498,100499,100504,100505,100506,100507,100508,100509,100510,100511)) 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
100294 sot303-m 7184/7186
100295 sot304-m 7184/7185
100480 t1c-p 7148/7156/7157
100481 t2c-p 7148/7156/7157
100482 tat303-p 7184/7186
100483 tat304-p 7184/7185
100484 tb001-p 7148/7156/7157
100485 tb002-p 7148/7156/7157
100486 tb003-p 7148/7156/7157
100487 tel353-m 7184/7186
100488 tel354-m 7184/7185
100489 tel453-m 7184/7186
100490 tel853-m 7184/7186
100491 tex353-m 7184/7186
100492 tex354-m 7184/7185
100493 tex453-m 7184/7186
100494 tex853-m 7184/7186
100495 tiw334-m 7184/7186
100496 tiw353-m 7184/7186
100497 tiw354-m 7184/7185
100498 tiw453-m 7184/7186
100499 tiw853-m 7184/7186
100504 tk001-p 7184/7217
100505 tk002-p 7184/7217
100506 tk002bg-p 7184/7217
100507 tk002bn-p 7184/7217
100508 tk002k-p 7184/7217
100509 tk003-p 7184/7217
100510 tk003bg-p 7184/7217
100511 tk003bn-p 7184/7217