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 (
    95195, 95196, 95197, 95198, 95199, 95200, 
    95201, 95202, 95203, 95204, 95205, 
    95206, 95207, 95208, 95209, 95210, 
    95211, 95212, 95213, 95214, 95215, 
    95216, 95217, 95218, 95219, 95220, 
    95221, 95222, 95223, 95224
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00122

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 (95195,95196,95197,95198,95199,95200,95201,95202,95203,95204,95205,95206,95207,95208,95209,95210,95211,95212,95213,95214,95215,95216,95217,95218,95219,95220,95221,95222,95223,95224)) 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
95195 rnd-nv4115a 7228/7230/7234
95196 rnd-nv4115ad 7228/7230/7231
95197 rnd-nv4115w 7228/7230/7234
95198 rnd-nv4115wd 7228/7230/7231
95199 rnd-nv4118a 7228/7230/7231
95200 rnd-nv4118ad 7228/7230/7231
95201 rnd-nv4118w 7228/7230/7234
95202 rnd-nv4118wd 7228/7230/7231
95203 rnd-nv4715a 7228/7230/7234
95204 rnd-nv4715ad 7228/7230/7231
95205 rnd-nv4715w 7228/7230/7234
95206 rnd-nv4715wd 7228/7230/7231
95207 rnd-nv4718ad 7228/7230/7231
95208 rnd-nv4718w 7228/7230/7231
95209 rnd-nv4718wd 7228/7230/7231
95210 rnd-nv5315a 7228/7230/7231
95211 rnd-nv5315ad 7228/7230/7231
95212 rnd-nv5315wd 7228/7230/7231
95213 rnd-nv5318a 7228
95214 rnd-nv5318ad 7228/7230/7231
95215 rnd-nv5318w 7228/7230/7234
95216 rnd-nv5318wd 7228/7230/7231
95217 rnd-nvh210dw 7228/7230/7231
95218 rnd-nvh212dw 7228/7230/7231
95219 rnd-nvh212sw 7228/7230/7234
95220 rnd-nvh214da 7228
95221 rnd-nvh214dw 7228/7230/7231
95222 rnd-nvh214sw 7228/7230/7234
95223 rnd-nvh506dw 7228/7230/7231
95224 rnd-nvh506sw 7228/7230/7234