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 (
    65688, 65103, 65454, 65694, 65102, 65596, 
    65696, 65519, 65597, 65683, 65613, 
    65702, 65608, 65716, 65717, 65697, 
    65695, 65690, 65568, 65612, 65602, 
    65610, 65851, 65611
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en' 
  AND (
    cscart_seo_names.company_id = 1 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00116

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "dispatch"],
      "key": "dispatch",
      "key_length": "210",
      "used_key_parts": [
        "dispatch",
        "object_id",
        "type",
        "lang_code",
        "company_id"
      ],
      "rows": 48,
      "filtered": 100,
      "index_condition": "cscart_seo_names.object_id in (65688,65103,65454,65694,65102,65596,65696,65519,65597,65683,65613,65702,65608,65716,65717,65697,65695,65690,65568,65612,65602,65610,65851,65611) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en' and (cscart_seo_names.company_id = 1 or cscart_seo_names.company_id = 0)"
    }
  }
}

Result

product_id seo_name seo_path
65102 sinclair-28-stem-mount-pendant-light 1628
65103 sinclair-28-chain-hung-pendant-light 1628
65454 chateau-flush-mount-light 1887/1888/1892
65519 glass-ball-globes 1571/1573
65568 replacement-gu24-socket-and-cord-kit 1571/1573
65596 double-maven-rope-chandelier 1887/1888/2010
65597 copeland-stem-mount-pendant-light 1887/1888/1890
65602 trevino-chandelier 1887/1888/1894
65608 lennox-5-light-chandelier 1887/1888/2010
65610 russo-stem-mount-pendant-light 1669/1699/1704
65611 briggs-chain-hung-pendant-light 1887/1888/1891
65612 callaway-chandelier 1887/1888/2010
65613 ledford-wall-sconce 1669/1831/1832
65683 ledford-chain-hung-pendant-light 1669/1699/1700
65688 barn-light-basics-seaside-gooseneck-light 1615
65690 barn-light-basics-seaside-pendant-light 1615
65694 barn-light-basics-wilcox-gooseneck-light 1620
65695 barn-light-basics-wilcox-stem-mount-light 1620
65696 barn-light-basics-wilcox-pendant-light 1620
65697 barn-light-basics-loma-pendant-light 1631
65702 barn-light-basics-avalon-pendant-light 1623
65716 milan-cylinder-gooseneck-light 1669/1831/1697
65717 venice-cylinder-gooseneck-light 1669/1831/1697
65851 led-amber-st19-250-lumen-bulb 1920/1942/1943