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

Query time 0.00141

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 (286627,282473,282471,282465,282463,282464,366955,282472,282469,366957,282468,366959,366958,366953,366956,366952,381767,366954,366951,286628)) 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
282463 aloe-vera-drinking-gel-immune-plus-1l 4001/4254
282464 mind-master-formula-red-1l 4001/4254
282465 aloe-vera-termolocion-relaksues-100ml 4001/4254
282468 woman-phyto-kapsula-46gr 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
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