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 (
    10331, 10358, 10378, 10311, 10332, 10359, 
    10379, 10312, 10333, 10360, 10380, 
    10334, 10361, 10381, 10335, 10362, 
    10336, 10363, 10337, 10364, 10338, 
    10365, 10339, 10366, 10340, 10367, 
    10341, 10368, 10342, 12565, 10293, 
    10296, 10301, 10313, 10318, 10294, 
    10297, 10302, 10314, 10319, 12552, 
    12554, 10295, 10298, 10303, 10315, 
    10320, 10299, 10304, 10316, 10321, 
    10300, 10317, 10322, 12572, 12575, 
    12571, 12573, 10273, 10272, 10271, 
    10270, 10269, 10268
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'ru' 
  AND (
    cscart_seo_names.company_id = 1 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00143

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "dispatch"],
      "key": "PRIMARY",
      "key_length": "210",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code",
        "company_id"
      ],
      "rows": 128,
      "filtered": 100,
      "index_condition": "cscart_seo_names.object_id in (10331,10358,10378,10311,10332,10359,10379,10312,10333,10360,10380,10334,10361,10381,10335,10362,10336,10363,10337,10364,10338,10365,10339,10366,10340,10367,10341,10368,10342,12565,10293,10296,10301,10313,10318,10294,10297,10302,10314,10319,12552,12554,10295,10298,10303,10315,10320,10299,10304,10316,10321,10300,10317,10322,12572,12575,12571,12573,10273,10272,10271,10270,10269,10268) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'ru' and (cscart_seo_names.company_id = 1 or cscart_seo_names.company_id = 0)"
    }
  }
}

Result

product_id seo_name seo_path
10268 gravitaciya-col-33 265/280/286/323
10269 gravitaciya-col-34 265/280/286/323
10270 gravitaciya-col-35 265/280/286/323
10271 gravitaciya-col-36 265/280/286/323
10272 gravitaciya-col-37 265/280/286/323
10273 gravitaciya-col-38 265/280/286/323
10293 esckimo-col-01 265/280/309/775
10294 esckimo-col-02 265/280/309/775
10295 esckimo-col-03 265/280/309/775
10296 salon-col-01 265/280/291/1645
10297 salon-col-02 265/280/291/1645
10298 salon-col-03 265/280/291/1645
10299 salon-col-04 265/280/291/1645
10300 salon-col-05 265/280/291/1645
10301 flashback-col-01 265/280/291/1644
10302 flashback-col-02 265/280/291/1644
10303 flashback-col-03 265/280/291/1644
10304 flashback-col-04 265/280/291/1644
10311 devotion-col-07 265/280/291/1647
10312 devotion-col-08 265/280/291/1647
10313 magnifico-col-01 265/280/439/1643
10314 magnifico-col-02 265/280/439/1643
10315 magnifico-col-03 265/280/439/1643
10316 magnifico-col-04 265/280/439/1643
10317 magnifico-col-05 265/280/439/1643
10318 magnifico-plain-col-01 265/280/439/1643
10319 magnifico-plain-col-02 265/280/439/1643
10320 magnifico-plain-col-03 265/280/439/1643
10321 magnifico-plain-col-04 265/280/439/1643
10322 magnifico-plain-col-05 265/280/439/1643
10331 mechta-col-09 265/280/286/1648
10332 mechta-col-10 265/280/286/1648
10333 mechta-col-11 265/280/286/1648
10334 mechta-col-12 265/280/286/1648
10335 mechta-col-13 265/280/286/1648
10336 mechta-col-14 265/280/286/1648
10337 mechta-col-15 265/280/286/1648
10338 mechta-col-16 265/280/286/1648
10339 mechta-col-17 265/280/286/1648
10340 mechta-col-18 265/280/286/1648
10341 mechta-col-19 265/280/286/1648
10342 mechta-col-20 265/280/286/1648
10358 excellence-col-16 265/280/442/1646
10359 excellence-col-17 265/280/442/1646
10360 excellence-col-18 265/280/442/1646
10361 excellence-col-19 265/280/442/1646
10362 excellence-col-20 265/280/442/1646
10363 excellence-col-21 265/280/442/1646
10364 excellence-col-22 265/280/442/1646
10365 excellence-col-23 265/280/442/1646
10366 excellence-col-24 265/280/442/1646
10367 excellence-col-25 265/280/442/1646
10368 excellence-col-26 265/280/442/1646
10378 impulse-col-06 265/280/291/1652
10379 impulse-col-07 265/280/291/1652
10380 impulse-col-08 265/280/291/1652
10381 impulse-col-09 265/280/291/1652
12552 tureckiy-kover-marble-powder-160x230 265/266/268
12554 tureckiy-kover-marble-ocean-200x290 265/266/268
12565 belgiyskiy-kover-apatite-200x300 265/266/267
12571 belgiyskiy-kover-shabby-200x300 265/266/267
12572 belgiyskiy-kover-plaza-160x230 265/266/278
12573 belgiyskiy-kover-andromeda-200x300 265/266/267
12575 belgiyskiy-kover-florense-160x230 265/266/267