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 (
    10071, 
    10067, 
    10051, 
    10060, 
    10055, 
    10043, 
    10068, 
    10065, 
    10061, 
    10050, 
    10056, 
    10044, 
    10069, 
    10066, 
    12671, 
    12672, 
    15779, 
    12673, 
    12674, 
    12675, 
    12676, 
    12677, 
    12678, 
    12679, 
    9687, 
    10024, 
    10025, 
    10026, 
    10027, 
    10028, 
    10029, 
    10030, 
    10031, 
    10032, 
    10033, 
    10034, 
    10035, 
    10036, 
    10037, 
    10038, 
    10039, 
    10040, 
    10756, 
    10757, 
    10758, 
    10397, 
    10398, 
    10399, 
    10400, 
    10401, 
    10402, 
    12700, 
    12546, 
    12633, 
    12573, 
    12548, 
    12580, 
    12576, 
    12565, 
    12567, 
    12549, 
    12581, 
    12557, 
    12558, 
    12570, 
    12578, 
    12568, 
    12547, 
    12569, 
    12584, 
    12592, 
    12575, 
    12574, 
    12550, 
    12544, 
    12564, 
    12577, 
    12579, 
    12555, 
    12560, 
    12556, 
    12561, 
    12572, 
    12583, 
    12591, 
    12582, 
    12590, 
    12571, 
    12632, 
    12559, 
    12631, 
    10596, 
    10597, 
    10598, 
    10599, 
    10600, 
    10521, 
    10520, 
    10519, 
    10518, 
    10517, 
    10516, 
    10515, 
    10514, 
    10513, 
    10512, 
    10511, 
    10510, 
    10509, 
    10508, 
    10507, 
    10506, 
    10505, 
    10504, 
    10503, 
    10502, 
    10501, 
    10500, 
    10499, 
    10498, 
    10497, 
    9839, 
    12702, 
    9841, 
    9848, 
    9840, 
    9844, 
    9843
  ) 
  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.00140

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 (10071,10067,10051,10060,10055,10043,10068,10065,10061,10050,10056,10044,10069,10066,12671,12672,15779,12673,12674,12675,12676,12677,12678,12679,9687,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10037,10038,10039,10040,10756,10757,10758,10397,10398,10399,10400,10401,10402,12700,12546,12633,12573,12548,12580,12576,12565,12567,12549,12581,12557,12558,12570,12578,12568,12547,12569,12584,12592,12575,12574,12550,12544,12564,12577,12579,12555,12560,12556,12561,12572,12583,12591,12582,12590,12571,12632,12559,12631,10596,10597,10598,10599,10600,10521,10520,10519,10518,10517,10516,10515,10514,10513,10512,10511,10510,10509,10508,10507,10506,10505,10504,10503,10502,10501,10500,10499,10498,10497,9839,12702,9841,9848,9840,9844,9843) 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
9687 stockholm 265/273
9839 gravitaciya-col-01 265/280/286/323
9840 gravitaciya-col-05 265/280/286/323
9841 gravitaciya-col-03 265/280/286/323
9843 gravitaciya-col-07 265/280/286/323
9844 gravitaciya-col-06 265/280/286/323
9848 gravitaciya-col-04 265/280/286/323
10024 target-col-01 265/280/283/1636
10025 target-col-02 265/280/283/1636
10026 target-col-03 265/280/283/1636
10027 target-col-04 265/280/283/1636
10028 target-soft-col-01 265/280/283/1636
10029 target-soft-col-02 265/280/283/1636
10030 target-soft-col-03 265/280/283/1636
10031 target-soft-col-04 265/280/283/1636
10032 target-soft-col-05 265/280/283/1636
10033 target-soft-col-06 265/280/283/1636
10034 target-soft-col-07 265/280/283/1636
10035 target-soft-col-08 265/280/283/1636
10036 target-soft-col-09 265/280/283/1636
10037 target-soft-col-10 265/280/283/1636
10038 target-soft-col-11 265/280/283/1636
10039 target-soft-col-12 265/280/283/1636
10040 target-soft-col-13 265/280/283/1636
10043 simmetrika-col-05-ru 265/280/283/1629
10044 simmetrika-col-05-ru-2 265/280/283/1629
10050 simmetrika-col-02-ru 265/280/283/1629
10051 simmetrika-col-21 265/280/283/1629
10055 simmetrika-col-03-ru 265/280/283/1629
10056 simmetrika-col-03-ru-2 265/280/283/1629
10060 simmetrika-col-01-ru 265/280/283/1629
10061 simmetrika-col-01-ru-2 265/280/283/1629
10065 simmetrika-col-07-ru 265/280/283/1629
10066 simmetrika-col-07-ru-2 265/280/283/1629
10067 simmetrika-col-20 265/280/283/1629
10068 simmetrika-col-06-ru 265/280/283/1629
10069 simmetrika-col-06-ru-2 265/280/283/1629
10071 simmetrika-col-18 265/280/283/1629
10397 winnie-col-01 265/280/309/787
10398 winnie-col-02 265/280/309/787
10399 winnie-col-03 265/280/309/787
10400 winnie-col-04 265/280/309/787
10401 winnie-col-05 265/280/309/787
10402 winnie-col-06 265/280/309/787
10497 garmoniya-rogozhka-col-05 265/280/439/455
10498 garmoniya-rogozhka-col-04 265/280/439/455
10499 garmoniya-rogozhka-col-03 265/280/439/455
10500 garmoniya-rogozhka-col-02 265/280/439/455
10501 garmoniya-rogozhka-col-01 265/280/439/455
10502 garmoniya-miks-col-07 265/280/439/455
10503 garmoniya-miks-col-06 265/280/439/455
10504 garmoniya-miks-col-05 265/280/439/455
10505 garmoniya-miks-col-04 265/280/439/455
10506 garmoniya-miks-col-03 265/280/439/455
10507 garmoniya-miks-col-02 265/280/439/455
10508 garmoniya-miks-col-01 265/280/439/455
10509 garmoniya-grafika-col-09 265/280/439/455
10510 garmoniya-grafika-col-08 265/280/439/455
10511 garmoniya-grafika-col-07 265/280/439/455
10512 garmoniya-grafika-col-06 265/280/439/455
10513 garmoniya-grafika-col-05 265/280/439/455
10514 garmoniya-grafika-col-04 265/280/439/455
10515 garmoniya-grafika-col-03 265/280/439/455
10516 garmoniya-grafika-col-02 265/280/439/455
10517 garmoniya-grafika-col-01 265/280/439/455
10518 garmoniya-bukle-col-09 265/280/439/455
10519 garmoniya-bukle-col-08 265/280/439/455
10520 garmoniya-bukle-col-07 265/280/439/455
10521 garmoniya-bukle-col-06 265/280/439/455
10596 garmoniya-bukle-col-01 265/280/439/455
10597 garmoniya-bukle-col-02 265/280/439/455
10598 garmoniya-bukle-col-03 265/280/439/455
10599 garmoniya-bukle-col-04 265/280/439/455
10600 garmoniya-bukle-col-05 265/280/439/455
10756 vista-col-01 265/280/291/1679
10757 vista-col-02 265/280/291/1679
10758 vista-col-03 265/280/291/1679
12544 belgiyskiy-kover-granite-160x230 265/266/278
12546 belgiyskiy-kover-agat-200x300 265/266/278
12547 belgiyskiy-kover-chic-200x300 265/266/277
12548 belgiyskiy-kover-antique-160x230 265/266/277
12549 belgiyskiy-kover-basalt-160x230 265/266/267
12550 belgiyskiy-kover-fresco-160x230 265/266/278
12555 belgiyskiy-kover-origami-160h230 265/266/277
12556 belgiyskiy-kover-oscar-160h230 265/266/277
12557 belgiyskiy-kover-bauhaus-160h230 265/266/278
12558 belgiyskiy-kover-bauhaus-200x300 265/266/277
12559 belgiyskiy-kover-spectrum-160h230 265/266/278
12560 belgiyskiy-kover-origami-200x300 265/266/267
12561 belgiyskiy-kover-oscar-200x300 265/266/267
12564 belgiyskiy-kover-granite-200h300 265/266/277
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
12574 belgiyskiy-kover-florense-200x300 265/266/277
12575 belgiyskiy-kover-florense-160x230 265/266/267
12576 belgiyskiy-kover-apatite-160x230 265/266/278
12577 belgiyskiy-kover-mirror-160x230 265/266/267
12578 belgiyskiy-kover-boreal-160x230 265/266/278
12579 belgiyskiy-kover-mirror-80x125 265/266/267
12580 belgiyskiy-kover-antique-80x125 265/266/267
12581 belgiyskiy-kover-basalt-200x300 265/266/278
12582 belgiyskiy-kover-prisma-160x230 265/266/278
12583 belgiyskiy-kover-porto-160x230 265/266/278
12584 belgiyskiy-kover-djotto-160x230 265/266/277
12590 belgiyskiy-kover-prisma-200x300 265/266/277
12591 belgiyskiy-kover-porto-200x300 265/266/278
12592 belgiyskiy-kover-djotto-200x290 265/266/278
12631 belgiyskiy-kover-topaz-160h230 265/266/267
12632 belgiyskiy-kover-slab-200x300 265/266/277
12633 belgiyskiy-kover-air-200x300 265/266/277
12671 solo-col-01 265/280/442/784
12672 solo-col-02 265/280/442/784
12673 solo-col-04 265/280/442/784
12674 solo-col-05 265/280/442/784
12675 solo-col-06 265/280/442/784
12676 solo-col-07 265/280/442/784
12677 solo-col-08 265/280/442/784
12678 solo-col-09 265/280/442/784
12679 solo-col-10 265/280/442/784
12700 winnie-col-08 265/280/309/787
12702 gravitaciya-col-02 265/280/286/323
15779 solo-col-03 265/280/442/784