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 (
    94652, 94653, 94659, 94660, 94661, 94663, 
    94664, 94665, 94675, 94676, 94677, 
    94813, 94817, 94818, 94819, 95449, 
    95803, 95805, 95807, 95809, 95811, 
    97719, 97720, 97721, 97722, 97723, 
    97724, 97725, 97726, 97727, 97765, 
    97766, 97767, 97768, 97769, 97770, 
    97771, 97772, 97773, 97775, 97776, 
    97777, 97783, 97784, 97785, 97787, 
    97788, 97789
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00151

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 (94652,94653,94659,94660,94661,94663,94664,94665,94675,94676,94677,94813,94817,94818,94819,95449,95803,95805,95807,95809,95811,97719,97720,97721,97722,97723,97724,97725,97726,97727,97765,97766,97767,97768,97769,97770,97771,97772,97773,97775,97776,97777,97783,97784,97785,97787,97788,97789)) 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
94652 bayf428 7244/7245
94653 bayf431 7244/7245
94659 bayf481 7244/7245
94660 bayf484 7244/7245
94661 bayf487 7244/7245
94663 bayf822 7244/7245
94664 bayf828 7244/7245
94665 bayf831 7244/7245
94675 bayf881 7244/7245
94676 bayf884 7244/7245
94677 bayf887 7244/7245
94813 off3217 7244/7245
94817 pp1127 7244/7245
94818 pp1128 7244/7245
94819 pp1129 7244/7245
95449 237titmc350 7244/7245
95803 lsl117 7244/7245
95805 lsl1417 7244/7245
95807 lsl1817 7244/7245
95809 lsl3117 7244/7245
95811 lsl3217 7244/7245
97719 bayf122-p 7244/7245
97720 bayf123-p 7244/7245
97721 bayf124-p 7244/7245
97722 bayf128-p 7244/7245
97723 bayf129-p 7244/7245
97724 bayf130-p 7244/7245
97725 bayf131-p 7244/7245
97726 bayf132-p 7244/7245
97727 bayf133-p 7244/7245
97765 bayf181-p 7244/7245
97766 bayf182-p 7244/7245
97767 bayf183-p 7244/7245
97768 bayf184-p 7244/7245
97769 bayf185-p 7244/7245
97770 bayf186-p 7244/7245
97771 bayf187-p 7244/7245
97772 bayf188-p 7244/7245
97773 bayf189-p 7244/7245
97775 bayf422-p 7244/7245
97776 bayf428-p 7244/7245
97777 bayf431-p 7244/7245
97783 bayf481-p 7244/7245
97784 bayf484-p 7244/7245
97785 bayf487-p 7244/7245
97787 bayf822-p 7244/7245
97788 bayf828-p 7244/7245
97789 bayf831-p 7244/7245