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 (
    94273, 94274, 94275, 94276, 94277, 94278, 
    94279, 94280, 94281, 94282, 94283, 
    94284, 94285, 94286, 94287, 94288, 
    94289, 94290, 94291, 94292, 94293, 
    94294, 94295, 94296, 94297, 94298, 
    94299, 94300, 94301, 94302, 94303, 
    94304, 94305, 94306, 94307, 94308, 
    94309, 94310, 94311, 94312, 94313, 
    94314, 94315, 94316, 94317, 94318, 
    94319, 94320
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00161

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 (94273,94274,94275,94276,94277,94278,94279,94280,94281,94282,94283,94284,94285,94286,94287,94288,94289,94290,94291,94292,94293,94294,94295,94296,94297,94298,94299,94300,94301,94302,94303,94304,94305,94306,94307,94308,94309,94310,94311,94312,94313,94314,94315,94316,94317,94318,94319,94320)) 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
94273 enzw109 7165/7166
94274 enzw110 7165/7166
94275 enzw111 7165/7166
94276 enzw112 7165/7166
94277 enzw113 7165/7166
94278 enzw114 7165/7166
94279 enzw115 7165/7166
94280 enzw116 7165/7166
94281 enzw117 7165/7166
94282 enzw118 7165/7166
94283 enzw119 7165/7166
94284 enzw120 7165/7166
94285 enzw121 7165/7166
94286 enzw122 7165/7166
94287 enzw123 7165/7166
94288 enzw124 7165/7166
94289 enzw125 7165/7166
94290 enzw126 7165/7166
94291 enzw127 7165/7166
94292 enzw128 7165/7166
94293 enzw129 7165/7166
94294 enzw130 7165/7166
94295 enzw131 7165/7166
94296 enzw132 7165/7166
94297 enzw133 7165/7166
94298 enzw134 7165/7166
94299 enzw135 7165/7166
94300 enzw136 7165/7166
94301 enzw137 7165/7166
94302 enzw138 7165/7166
94303 enzw139 7165/7166
94304 enzw140 7165/7166
94305 enzw141 7165/7166
94306 enzw142 7165/7166
94307 enzw143 7165/7166
94308 enzw144 7165/7166
94309 enzw145 7165/7166
94310 enzw146 7165/7166
94311 enzw147 7165/7166
94312 enzw148 7165/7166
94313 enzw149 7165/7166
94314 enzw150 7165/7166
94315 enzw151 7165/7166
94316 enzw152 7165/7166
94317 enzw153 7165/7166
94318 enzw154 7165/7166
94319 enzw155 7165/7166
94320 enzw156 7165/7166