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 (
    101263, 101264, 101265, 101266, 101267, 
    101268, 101269, 101270, 101271, 101272, 
    101273, 101274, 101275, 101276, 101277, 
    101278, 101279, 101280, 101281, 101282, 
    101283, 101284, 101285, 101286, 101287, 
    101288, 101289, 101290, 101291, 101292
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00127

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 (101263,101264,101265,101266,101267,101268,101269,101270,101271,101272,101273,101274,101275,101276,101277,101278,101279,101280,101281,101282,101283,101284,101285,101286,101287,101288,101289,101290,101291,101292)) 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
101263 ffhr105l 7170/7200
101264 ffhr105r 7170/7200
101265 ffhr106l 7170/7200
101266 ffhr106r 7170/7200
101267 ffhr107l 7170/7200
101268 ffhr107r 7170/7200
101269 ffhr108l 7170/7200
101270 ffhr108r 7170/7200
101271 ffhr109l 7170/7200
101272 ffhr109r 7170/7200
101273 ffhr110l 7170/7200
101274 ffhr110r 7170/7200
101275 ffhr111l 7170/7200
101276 ffhr111r 7170/7200
101277 ffhr112l 7170/7200
101278 ffhr112r 7170/7200
101279 ffhr113 7170/7200
101280 ffhr114 7170/7200
101281 ffhr115 7170/7200
101282 ffhr116 7170/7200
101283 ffhr1401 7170/7200
101284 ffhr1402 7170/7200
101285 ffhr1403 7170/7200
101286 ffhr1404l 7170/7200
101287 ffhr1404r 7170/7200
101288 ffhr1405l 7170/7200
101289 ffhr1405r 7170/7200
101290 ffhr1406l 7170/7200
101291 ffhr1406r 7170/7200
101292 ffhr1407l 7170/7200