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 (
    388363, 388674, 435256, 391747, 388621, 
    391744, 435260, 435255, 435235, 388612, 
    388654, 389225, 435241, 429392, 388364, 
    429396, 435261, 388970, 388610, 388615
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00106

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 (388363,388674,435256,391747,388621,391744,435260,435255,435235,388612,388654,389225,435241,429392,388364,429396,435261,388970,388610,388615)) 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
388363 225-55-zr17-101w-accelera-alpha 6328/10437/10439
388364 235-55-zr17-103w-accelera-phi 6328/10437/10439
388610 235-55-r17-103v-xl-fr-bravuris-5hm 6328/10437/10439
388612 235-55-r18-104h-xl-fr-pol5-barum-polaris-5 6328/10437/10439
388615 235-60-r17-102v-fr-bravuris-5hm 6328/10437/10439
388621 235-75-r15-109t-bravuris-4x4-xl 6328/10437/10439
388654 255-55-r19-111v-xl-fr-brav5-barum-bravuris-5hm 6328/10437/10439
388674 295-35-r21-107y-xl-fr-bravuris-5hm 6328/10437/10439
388970 285-35-r23-107y-xl-sc6-ro1-sil-sportcontact-6fr 6328/10437/10439
389225 235-55-r19-ap3-suv-105w-xl-tl-maxxis-tp00219500 6328/10437/10439
391744 255-50-r19-107v-dueler-rsc 6328/10437/10439
391747 275-35-r21-103w-xl-fr-ts860s-wintercontact 6328/10437/10439
429392 goma-zextour-275-40z-r20-zextour-ls669 6328/10437/10439
429396 goma-zextour-275-45z-r20-zextour-ls669 6328/10437/10439
435235 goma-greentrac-255-50-r19-107xl-y-greentrac-quest-x 6328/10437/10439
435241 goma-greentrac-245-40-r20-99y-xl-quest-x-greentrac 6328/10437/10438
435255 goma-bridgestone-195-70-r15-97t-b330-bridgestone 6328/10437/10439
435256 goma-bridgestone-205-r16c-ht684-bridgestone 6328/10437/10439
435260 goma-bridgestone-255-55-r18-109w-alenza-bridgestone 6328/10437/10439
435261 goma-continental-225-60-r16-98h-wc830-continental 6328/10437/10438