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 (
    415297, 415290, 286710, 286709, 286708, 
    286707, 282473, 286711, 282471, 282465, 
    282463, 282464, 428031, 366955, 282472, 
    366957, 282468, 366959, 366958, 309500
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00113

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 (415297,415290,286710,286709,286708,286707,282473,286711,282471,282465,282463,282464,428031,366955,282472,366957,282468,366959,366958,309500)) 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
282471 colostrum-leng-125ml 4001/4254
282472 cistus-incanus-kapsula 4001/4254
282473 krem-xhel-pas-diellit-200ml 4001/4254
286707 terapi 4001/4254
286708 kirurgji 4001/4254
286709 ortopedi 4001/4254
286710 ortodonci 4001/4254
286711 profilaksi-estetike-filler-botox-mesoterap 4001/4254
309500 kirurgji-en 4001/4254
366955 mind-master-extreme 4001/4254
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
415290 guler-cervical-de-elongare 4001/4254
415297 corector-de-postura-inteligent-cu-senzor-de-vibratie-pentru-spate-drept-si-indreptare-umeri-si-coloana 4001/4254
428031 cantar-electronic-de-bucatarie-cu-bol-de-plastic-sonashi 4001/4254/4431/5968