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 (
    435263, 434879, 286627, 381767, 366959, 
    366958, 366957, 366956, 366955, 366954, 
    366953, 366952, 366951, 282465, 286628, 
    286626, 282473, 282472, 282471, 282469
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00079

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "28.03"
    },
    "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": 20,
      "rows_produced_per_join": 20,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "24.03",
        "eval_cost": "4.00",
        "prefix_cost": "28.03",
        "data_read_per_join": "33K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`webmarco`.`cscart_seo_names`.`object_id` in (435263,434879,286627,381767,366959,366958,366957,366956,366955,366954,366953,366952,366951,282465,286628,286626,282473,282472,282471,282469)) and (`webmarco`.`cscart_seo_names`.`type` = 'p') and (`webmarco`.`cscart_seo_names`.`dispatch` = '') and (`webmarco`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
282465 aloe-vera-termolocion-relaksues-100ml 4001/4254
282469 super-omega-kapsula-100gr 4001/4254
282471 colostrum-leng-125ml 4001/4254
282472 cistus-incanus-kapsula 4001/4254
282473 krem-xhel-pas-diellit-200ml 4001/4254
286626 vipwell 4001
286627 vipwell-serume 4001
286628 donation 3532
366951 cell-essence-energy 3532/3535/3539/3638/3748
366952 cell-essence-regeneration 3532/3535/3539/3638/7160
366953 probalance 3532/3535/3539/3638/7160
366954 vita-active 3532/3535/3539/3638/7160
366955 mind-master-extreme 4001/4254
366956 lr-microsilver-plus-paste-dhembesh 4001/4003/4004
366957 lr-go-intra-performanc2 4001/4254/5272/5385
366958 post-performance-shake 4001/4254/5272/5305
366959 pre-performance-gel 4001/4254/5272/5326
381767 protect-propolis-cream 4001/4003/4525/4857/5268
434879 lr-microsilver-plus-orale 10254
435263 cian 4001