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 (
    415289, 427787, 415302, 427779, 349683, 
    356555, 359422, 357504, 351887, 356656, 
    354756, 355713, 354511, 349842, 354972, 
    358872, 356249, 349973, 387057, 349661
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00282

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 (415289,427787,415302,427779,349683,356555,359422,357504,351887,356656,354756,355713,354511,349842,354972,358872,356249,349973,387057,349661)) 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
349661 tod-p.lettere-bcomarr-1840cm-t4041-en 2910/2916
349683 gob-fermatenda-ass-qto-fl17051-en 2910/2916
349842 ond-riordina-coperchi-as-351512-g-234-en 2910/2916
349973 ems-pattumiera-pl.ass-1621cm-ep-181-en 2910/2916
351887 mog-portakleenex-bco-16118-2015005-en 2910/2916
354511 crm-foglia-metallo-302-533cm-sr188154-en 2910/2916
354756 sub-mother-ass-302-110-5-hf17267-en 2910/2916
354972 jdm-orologio-parete-50cm-21stc429-en 2910/2916
355713 mog-m.foto-a-9-a.vita-82592cm-kk22-en 2910/2916
356249 won-quadro-as.-45451-5-xcc212814-5-6-7-en 2910/2916
356555 bir-quadro-ass-30903cm-dp14092-94-en 2910/2916
356656 imb-quadro-5-fto-mdf-61242.5-yd-317386-en 2910/2916
357504 gob-fermatende-16cm-hj45780-en 2910/2916
358872 oxo-ptafiori-parete-as-20cm-gx168037a-en 2910/2916
359422 rtl-dosatore-sap.vetro-500ml-gd17s68-en 2910/2916
387057 vazo-per-lulet-me-gdhendje-druri 2910/2916/3308
415289 pusculita-interactiva-pentru-copii-cu-functie-atm-seif-si-cod-pin 2910/2916/3487
415302 ceas-smart-de-camera-ce-indica-ora 2910/2916/3087
427779 smartwatch-si-telefon-metalic-retro-vibes-cu-card-micro-sd-conectivizate-bluetooth-4.0 2910/2916/3087
427787 ceas-inteligent-smartwatch-8-ultra-plus-cu-incarcare-wireless-curea-neagra 2910/2916/3087