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 (
    99342, 99343, 99404, 99405, 99406, 99407, 
    99408, 99409, 99410, 99411, 99422, 
    99423, 99424, 99425, 99426, 99427, 
    99428, 99429, 99430, 99431, 99432, 
    99433, 99434, 99435, 99436, 99437, 
    99491, 99492, 99493, 99494, 99495, 
    99496, 99497, 99498, 99499, 99500, 
    99501, 99502, 99503, 99504, 99505, 
    99506, 99508, 99509, 99510, 99512, 
    99513, 99514, 99516, 99517, 99518, 
    99519, 99520, 99521, 99522, 99523, 
    99524, 99525, 99526, 99527, 99529, 
    99530, 99531, 99532, 99533, 99534, 
    99535, 99536, 99537, 99538, 99539, 
    99540, 99541, 99542, 99543, 99544, 
    99545, 99546, 99547, 99548, 99549, 
    99550, 99551, 99552, 99553, 99554, 
    99555, 99556, 99557, 99574, 99575, 
    99576, 100143, 100161, 100162, 100163
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00250

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "43.23"
    },
    "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": 96,
      "rows_produced_per_join": 96,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "33.63",
        "eval_cost": "9.60",
        "prefix_cost": "43.23",
        "data_read_per_join": "162K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (99342,99343,99404,99405,99406,99407,99408,99409,99410,99411,99422,99423,99424,99425,99426,99427,99428,99429,99430,99431,99432,99433,99434,99435,99436,99437,99491,99492,99493,99494,99495,99496,99497,99498,99499,99500,99501,99502,99503,99504,99505,99506,99508,99509,99510,99512,99513,99514,99516,99517,99518,99519,99520,99521,99522,99523,99524,99525,99526,99527,99529,99530,99531,99532,99533,99534,99535,99536,99537,99538,99539,99540,99541,99542,99543,99544,99545,99546,99547,99548,99549,99550,99551,99552,99553,99554,99555,99556,99557,99574,99575,99576,100143,100161,100162,100163)) 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
99342 nmp831-p 7148/7156/7194
99343 nmp835-p 7148/7156/7194
99404 nts002-p 7148/7158/7263
99405 nts004-p 7148/7158/7263
99406 nts006-p 7148/7158/7263
99407 nts007-p 7148/7158/7263
99408 nts008-p 7148/7158/7263
99409 nts010-p 7148/7158/7263
99410 nts302-p 7148/7158/7263
99411 nts303-p 7148/7158/7263
99422 nvm001-p 7148/7207/7208
99423 nvm003-p 7148/7207/7208
99424 nvm005-p 7148/7207/7208
99425 nvm007-p 7148/7207/7208
99426 nvm012-p 7148/7207/7208
99427 nvm013-p 7148/7207/7208
99428 nvm015-p 7148/7207/7208
99429 nvm017-p 7148/7207/7208
99430 nvm032-p 7148/7207/7208
99431 nvm033-p 7148/7207/7208
99432 nvm035-p 7148/7207/7208
99433 nvm042-p 7148/7207/7208
99434 nvm043-p 7148/7207/7208
99435 nvm045-p 7148/7207/7208
99436 nvm063-p 7148/7207/7208
99437 nvm065-p 7148/7207/7208
99491 off970n-p 7148/7156/7194
99492 off971n-p 7148/7156/7194
99493 off972n-p 7148/7156/7194
99494 off973n-p 7148/7156/7194
99495 off977n-p 7148/7156/7194
99496 off978n-p 7148/7156/7194
99497 off979n-p 7148/7156/7194
99498 pan136-p 7148/7156/7194
99499 pan138-p 7148/7156/7194
99500 pan139-p 7148/7156/7194
99501 pan140-p 7148/7156/7194
99502 pan141-p 7148/7156/7194
99503 pan142-p 7148/7156/7194
99504 pan144-p 7148/7156/7194
99505 pan209l-p 7148/7156/7194
99506 pan209r-p 7148/7156/7194
99508 pdt-000599-p 7148/7156/7157
99509 pdt-000600-p 7184/7219
99510 pdt-000601-p 7184/7219
99512 pdt-000730-p 7148/7156/7157
99513 pdt-000731-p 7184/7219
99514 pdt-000732-p 7184/7219
99516 pdt-000734-p 7148/7156/7157
99517 pdt-000735-p 7184/7219
99518 pdt-000736-p 7184/7219
99519 pek185-p 7148/7225
99520 pek185bb-p 7148/7225
99521 pek185bp-p 7148/7225
99522 pek190-p 7148/7225
99523 pek190bb-p 7148/7225
99524 pek190bp-p 7148/7225
99525 peksq190-p 7148/7225
99526 peksq190bb-p 7148/7225
99527 peksq190bp-p 7148/7225
99529 pmb003-p 7148/7207/7208
99530 pmb005-p 7148/7207/7208
99531 pmb021-p 7148/7207/7208
99532 pmb022-p 7148/7207/7208
99533 pmb044-p 7148/7207/7208
99534 pmb049-p 7148/7207/7208
99535 pmb402-p 7148/7207/7208
99536 pmb403-p 7148/7207/7208
99537 pmb404-p 7148/7207/7208
99538 pmb411l-p 7148/7207/7208
99539 pmb411r-p 7148/7207/7208
99540 pmb412l-p 7148/7207/7208
99541 pmb412r-p 7148/7207/7208
99542 pmb413l-p 7148/7207/7208
99543 pmb413r-p 7148/7207/7208
99544 pmb414l-p 7148/7207/7208
99545 pmb414r-p 7148/7207/7208
99546 pmb415l-p 7148/7207/7208
99547 pmb415r-p 7148/7207/7208
99548 pmb424-p 7148/7207/7208
99549 pmb425-p 7148/7207/7208
99550 pmb512l-p 7148/7207/7208
99551 pmb512r-p 7148/7207/7208
99552 pmb513l-p 7148/7207/7208
99553 pmb513r-p 7148/7207/7208
99554 pmb612l-p 7148/7207/7208
99555 pmb612r-p 7148/7207/7208
99556 pmb613l-p 7148/7207/7208
99557 pmb613r-p 7148/7207/7208
99574 rc002-p 7148/7207/7208
99575 rc003-p 7148/7207/7208
99576 rc004-p 7148/7207/7208
100143 s4whf-p 7148/7158/7247
100161 sbm103-p 7148/7207/7208
100162 sbm105-p 7148/7207/7208
100163 sbm111l-p 7148/7207/7208