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, 
    10267, 
    10266, 
    10265, 
    10264, 
    10263, 
    12570, 
    12567, 
    12569, 
    12568, 
    10261, 
    10260, 
    10259, 
    10258, 
    10257, 
    10256, 
    10255, 
    10254, 
    10253, 
    10252, 
    10251, 
    10250, 
    10249, 
    10248, 
    10247, 
    10246, 
    10245, 
    10244, 
    10243, 
    10242, 
    10241, 
    10203, 
    10204, 
    10205, 
    10206, 
    10207, 
    10208, 
    10209, 
    10210, 
    10211, 
    10212, 
    10213, 
    10214, 
    10215, 
    10216, 
    10217, 
    10218, 
    10219, 
    10220, 
    10221, 
    10222, 
    10144, 
    10145, 
    10146, 
    10147, 
    10148, 
    10149, 
    10150, 
    10151, 
    10152, 
    12969, 
    10103, 
    10104, 
    10105, 
    10106
  ) 
  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.00284

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": 256,
      "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,10267,10266,10265,10264,10263,12570,12567,12569,12568,10261,10260,10259,10258,10257,10256,10255,10254,10253,10252,10251,10250,10249,10248,10247,10246,10245,10244,10243,10242,10241,10203,10204,10205,10206,10207,10208,10209,10210,10211,10212,10213,10214,10215,10216,10217,10218,10219,10220,10221,10222,10144,10145,10146,10147,10148,10149,10150,10151,10152,12969,10103,10104,10105,10106) 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
10103 matisse-col-41 265/280/291/1618
10104 matisse-col-33 265/280/291/1618
10105 matisse-col-22 265/280/291/1618
10106 matisse-col-16 265/280/291/1618
10144 erwin-i-col-02 265/280/393/1151
10145 erwin-i-col-03 265/280/393/1151
10146 erwin-i-col-04 265/280/393/1151
10147 erwin-i-col-05 265/280/393/1151
10148 erwin-ii-col-01 265/280/393/1151
10149 erwin-ii-col-02 265/280/393/1151
10150 erwin-ii-col-03 265/280/393/1151
10151 erwin-ii-col-04 265/280/393/1151
10152 erwin-ii-col-05 265/280/393/1151
10203 maverisk-col-01 265/280/370/1637
10204 maverisk-col-02 265/280/370/1637
10205 maverisk-col-03 265/280/370/1637
10206 maverick-col-04 265/280/370/1637
10207 maverisk-col-05 265/280/370/1637
10208 maverisk-col-06 265/280/370/1637
10209 maverick-col-07 265/280/370/1637
10210 maverisk-col-08 265/280/370/1637
10211 maverisk-col-09 265/280/370/1637
10212 maverisk-col-10 265/280/370/1637
10213 maverisk-col-11 265/280/370/1637
10214 maverisk-col-12 265/280/370/1637
10215 maverisk-col-13 265/280/370/1637
10216 maverick-col-14 265/280/370/1637
10217 maverisk-col-15 265/280/370/1637
10218 maverisk-col-16 265/280/370/1637
10219 maverisk-col-17 265/280/370/1637
10220 maverisk-col-18 265/280/370/1637
10221 maverisk-col-19 265/280/370/1637
10222 maverisk-col-20 265/280/370/1637
10241 crush-col-18 265/280/286/1622
10242 crush-col-19 265/280/286/1622
10243 crush-col-20 265/280/286/1622
10244 crush-col-21 265/280/286/1622
10245 crush-col-22 265/280/286/1622
10246 crush-col-23 265/280/286/1622
10247 crush-col-24 265/280/286/1622
10248 crush-col-25 265/280/286/1622
10249 crush-col-26 265/280/286/1622
10250 crush-col-27 265/280/286/1622
10251 crush-col-28 265/280/286/1622
10252 crush-col-29 265/280/286/1622
10253 crush-col-30 265/280/286/1622
10254 crush-col-31 265/280/286/1622
10255 crush-col-32 265/280/286/1622
10256 crush-col-33 265/280/286/1622
10257 crush-col-34 265/280/286/1622
10258 crush-col-35 265/280/286/1622
10259 crush-col-36 265/280/286/1622
10260 crush-col-37 265/280/286/1622
10261 crush-col-38 265/280/286/1622
10263 gravitaciya-col-28 265/280/286/323
10264 gravitaciya-col-29 265/280/286/323
10265 gravitaciya-col-30 265/280/286/323
10266 gravitaciya-col-31 265/280/286/323
10267 gravitaciya-col-32 265/280/286/323
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
12567 belgiyskiy-kover-apatite-80x125 265/266/278
12568 belgiyskiy-kover-carrara-80x125 265/266/277
12569 belgiyskiy-kover-chic-80x125 265/266/278
12570 belgiyskiy-kover-bauhaus-80x125 265/266/277
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
12969 erwin-i-col-01 265/280/393/1151