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 (
    95056, 95333, 95334, 95335, 95336, 95337, 
    95338, 95339, 95340, 95343, 95347, 
    95348, 95350, 95351, 95353, 95354, 
    95355, 95514, 95515, 95516, 95520, 
    95521, 95522, 95530, 95531, 95532, 
    95546, 95547, 95548, 96190, 96783, 
    96784, 96807, 96808, 96809, 96810, 
    96811, 96812, 96813, 96814, 96815, 
    96816, 96920, 96921, 96922, 96923, 
    96924, 96925
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00162

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.62"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.82",
        "eval_cost": "4.80",
        "prefix_cost": "21.62",
        "data_read_per_join": "81K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (95056,95333,95334,95335,95336,95337,95338,95339,95340,95343,95347,95348,95350,95351,95353,95354,95355,95514,95515,95516,95520,95521,95522,95530,95531,95532,95546,95547,95548,96190,96783,96784,96807,96808,96809,96810,96811,96812,96813,96814,96815,96816,96920,96921,96922,96923,96924,96925)) 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
95056 aqven8124 7165/7168/7174
95333 sy-vod59-b 7165/7168/7174
95334 sy-vod60-b 7165/7168/7174
95335 sy-vod61-b 7165/7168/7174
95336 sy-vod62-b 7165/7168/7174
95337 sy-vod63-b 7165/7168/7174
95338 sy-vod64-b 7165/7168/7174
95339 sy-vod65-b 7165/7168/7174
95340 sy-vod66-b 7165/7168/7174
95343 sy-vod69-b 7165/7168/7174
95347 sy-vod73-b 7165/7168/7174
95348 sy-vod74-b 7165/7168/7174
95350 sy-vod76-b 7165/7168/7174
95351 sy-vod77-b 7165/7168/7174
95353 sy-vod79-b 7165/7168/7174
95354 sy-vod80-b 7165/7168/7174
95355 sy-vod81-b 7165/7168/7174
95514 238700hd-q 7165/7168/7174
95515 238700hdbb-q 7165/7168/7174
95516 238700hdk-q 7165/7168/7174
95520 238760hd-q 7165/7168/7174
95521 238760hdbb-q 7165/7168/7174
95522 238760hdk-q 7165/7168/7174
95530 238800hd-q 7165/7168/7174
95531 238800hdbb-q 7165/7168/7174
95532 238800hdk-q 7165/7168/7174
95546 238900hd-q 7165/7168/7174
95547 238900hdbb-q 7165/7168/7174
95548 238900hdk-q 7165/7168/7174
96190 sy-vod41-b 7165/7168/7174
96783 adhd80-e8-p 7165/7168/7174
96784 adhd90-e8-p 7165/7168/7174
96807 aqhd70-e6-p 7165/7168/7174
96808 aqhd76-e6-p 7165/7168/7174
96809 aqhd80-e6-p 7165/7168/7174
96810 aqhd80n-e8-p 7165/7168/7174
96811 aqhd80nbb-e8-p 7165/7168/7174
96812 aqhd80nbp-e8-p 7165/7168/7174
96813 aqhd90-e6-p 7165/7168/7174
96814 aqhd90n-e8-p 7165/7168/7174
96815 aqhd90nbb-e8-p 7165/7168/7174
96816 aqhd90nbp-e8-p 7165/7168/7174
96920 aqven8103-p 7165/7168/7174
96921 aqven8104-p 7165/7168/7174
96922 aqven8105-p 7165/7168/7174
96923 aqven8106-p 7165/7168/7174
96924 aqven8107-p 7165/7168/7174
96925 aqven8108-p 7165/7168/7174