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 (
    10705, 
    10706, 
    10707, 
    10708, 
    10709, 
    10710, 
    10711, 
    10712, 
    10668, 
    10669, 
    10670, 
    10671, 
    10672, 
    10673, 
    10674, 
    10675, 
    10676, 
    10677, 
    10678, 
    10679, 
    10680, 
    10681, 
    10682, 
    10683, 
    10684, 
    10685, 
    10686, 
    10725, 
    10724, 
    10701, 
    10699, 
    10698, 
    10696, 
    10695, 
    10693, 
    10692, 
    15958, 
    15957, 
    15956, 
    12600, 
    12602, 
    12604, 
    12606, 
    12608, 
    12603, 
    12615, 
    12597, 
    12609, 
    12610, 
    12607, 
    12596, 
    12611, 
    12613, 
    12612, 
    12605, 
    12601, 
    12616, 
    12599, 
    10666, 
    10664, 
    10663, 
    10661, 
    10659, 
    10658, 
    10657, 
    12619, 
    12620, 
    12593, 
    12595, 
    12585, 
    12587, 
    12623, 
    13091, 
    12588, 
    12590, 
    12591, 
    12592, 
    10497, 
    10498, 
    10499, 
    10500, 
    10501, 
    10502, 
    10503, 
    10504, 
    10505, 
    10506, 
    10507, 
    10508, 
    10509, 
    10510, 
    10511, 
    10512, 
    10513, 
    10514, 
    10515, 
    10516, 
    10517, 
    10518, 
    10519, 
    10520, 
    10521, 
    10641, 
    10640, 
    10639, 
    10638, 
    10637, 
    10636, 
    10635, 
    10634, 
    10633, 
    10632, 
    10631, 
    10630, 
    10629, 
    10628, 
    10627, 
    10626, 
    10625, 
    10624, 
    10623, 
    10622, 
    10621, 
    10620, 
    10619, 
    10618, 
    10617, 
    10616
  ) 
  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.00289

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 (10705,10706,10707,10708,10709,10710,10711,10712,10668,10669,10670,10671,10672,10673,10674,10675,10676,10677,10678,10679,10680,10681,10682,10683,10684,10685,10686,10725,10724,10701,10699,10698,10696,10695,10693,10692,15958,15957,15956,12600,12602,12604,12606,12608,12603,12615,12597,12609,12610,12607,12596,12611,12613,12612,12605,12601,12616,12599,10666,10664,10663,10661,10659,10658,10657,12619,12620,12593,12595,12585,12587,12623,13091,12588,12590,12591,12592,10497,10498,10499,10500,10501,10502,10503,10504,10505,10506,10507,10508,10509,10510,10511,10512,10513,10514,10515,10516,10517,10518,10519,10520,10521,10641,10640,10639,10638,10637,10636,10635,10634,10633,10632,10631,10630,10629,10628,10627,10626,10625,10624,10623,10622,10621,10620,10619,10618,10617,10616) 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
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
10616 borneo-col-10 265/280/286/1659
10617 borneo-col-11 265/280/286/1659
10618 borneo-col-12 265/280/286/1659
10619 borneo-col-13 265/280/286/1659
10620 borneo-col-14 265/280/286/1659
10621 borneo-col-15 265/280/286/1659
10622 borneo-col-16 265/280/286/1659
10623 borneo-col-17 265/280/286/1659
10624 borneo-col-18 265/280/286/1659
10625 persona-col-01 265/280/291/1660
10626 persona-col-02 265/280/291/1660
10627 persona-col-03 265/280/291/1660
10628 persona-col-04 265/280/291/1660
10629 persona-col-05 265/280/291/1660
10630 persona-col-06 265/280/291/1660
10631 persona-col-07 265/280/291/1660
10632 persona-col-08 265/280/291/1660
10633 persona-col-09 265/280/291/1660
10634 persona-col-10 265/280/291/1660
10635 persona-col-11 265/280/291/1660
10636 persona-col-12 265/280/291/1660
10637 inspiration-plain-col-08 265/280/291/1650
10638 inspiration-plain-col-09 265/280/291/1650
10639 inspiration-plain-col-10 265/280/291/1650
10640 inspiration-plain-col-11 265/280/291/1650
10641 inspiration-plain-col-12 265/280/291/1650
10657 podushka-dekorativnaya-garmoniya-grafika-07-50x50 265/271/275
10658 podushka-dekorativnaya-garmoniya-grafika-08-50x50 265/271/275
10659 podushka-dekorativnaya-garmoniya-bukle-05-50x50 265/271/275
10661 podushka-dekorativnaya-garmoniya-grafika-01-45x45 265/271/275
10663 podushka-dekorativnaya-garmoniya-grafika-04-45x45 265/271/275
10664 podushka-dekorativnaya-garmoniya-bukle-07-30x50 265/271/275
10666 podushka-dekorativnaya-garmoniya-bukle-08-30x50 265/271/275
10668 bora-bora-col-01 265/280/286/1661
10669 bora-bora-col-02 265/280/286/1661
10670 bora-bora-col-03 265/280/286/1661
10671 bora-bora-col-04 265/280/286/1661
10672 bora-bora-col-05 265/280/286/1661
10673 bora-bora-col-06 265/280/286/1661
10674 bora-bora-col-07 265/280/286/1661
10675 bora-bora-col-08 265/280/286/1661
10676 bora-bora-col-09 265/280/286/1661
10677 bora-bora-col-10 265/280/286/1661
10678 bora-bora-col-11 265/280/286/1661
10679 bora-bora-col-12 265/280/286/1661
10680 bora-bora-col-13 265/280/286/1661
10681 bora-bora-col-14 265/280/286/1661
10682 bora-bora-col-15 265/280/286/1661
10683 bora-bora-col-16 265/280/286/1661
10684 bora-bora-col-17 265/280/286/1661
10685 bora-bora-col-18 265/280/286/1661
10686 bora-bora-col-19 265/280/286/1661
10692 podushka-dekorativnaya-garmoniya-grafika-09-50x50 265/271/275
10693 podushka-dekorativnaya-inspiration-plain-12-45x45 265/271/275
10695 product-10695 265/271/275
10696 product-10696 265/271/275
10698 product-10698 265/271/275
10699 product-10699 265/271/275
10701 product-10701 265/271/275
10705 flame-col-02 265/280/291/1662
10706 flame-col-03 265/280/291/1662
10707 flame-col-04 265/280/291/1662
10708 flame-col-05 265/280/291/1662
10709 flame-col-06 265/280/291/1662
10710 flame-col-07 265/280/291/1662
10711 flame-col-08 265/280/291/1662
10712 flame-col-09 265/280/291/1662
10724 esckimo-col-04 265/280/309/775
10725 esckimo-col-05 265/280/309/775
12585 tureckiy-kover-donna-satin-silver-200h300 265/266/1688
12587 tureckiy-kover-donna-antik-gold-200h300 265/266/1688
12588 tureckiy-kover-good-night-blue-152h200 265/266/267
12590 belgiyskiy-kover-prisma-200x300 265/266/277
12591 belgiyskiy-kover-porto-200x300 265/266/278
12592 belgiyskiy-kover-djotto-200x290 265/266/278
12593 tureckiy-kover-donna-antique-copper-300x400 265/266/1688
12595 tureckiy-kover-donna-antik-gold-160x230 265/266/1688
12596 tureckiy-kover-nordic-ocean-200x290 265/266/277
12597 tureckiy-kover-sumatra-soft-mix-160x230 265/266/277
12599 tureckiy-kover-botanica-bone-bone-160x230 265/266/270
12600 tureckiy-kover-botanica-bone-bone-80x150 265/266/270
12601 tureckiy-kover-elegant-bone-bone-160x230 265/266/277
12602 tureckiy-kover-elegant-bone-bone-80x150 265/266/267
12603 tureckiy-kover-zebra-bone-bone-160x230 265/266/270
12604 tureckiy-kover-zebra-bone-bone-80x150 265/266/277
12605 tureckiy-kover-grigio-grey-grey-160x230 265/266/270
12606 tureckiy-kover-grigio-grey-grey-80x150 265/266/267
12607 tureckiy-kover-pebbles-grey-grey-160x230 265/266/270
12608 tureckiy-kover-pebbles-grey-grey-80x75 265/266/267
12609 tureckiy-kover-shale-beige-shr-papatya 265/266/277
12610 tureckiy-kover-penthouse-shr-papatya-160x230 265/266/267
12611 tureckiy-kover-mosaic-160x230 265/266/270
12612 tureckiy-kover-lama-i-bone-black-160x230 265/266/277
12613 tureckiy-kover-lama-ii-bone-grey-160x230 265/266/277
12615 tureckiy-kover-wave-160x230 265/266/270
12616 tureckiy-kover-ecotouch-grey-papatya-160x230 265/266/277
12619 tureckiy-kover-donna-satin-silver-160x230 265/266/1688
12620 tureckiy-kover-donna-pearl-160x230 265/266/267
12623 tureckiy-kover-donna-pearl-200h300 265/266/270
13091 tureckiy-kover-balloons-grey-152h200 265/266/267
15956 komplekt-podushek-16 265/271/272
15957 komplekt-podushek-27 265/271/272
15958 komplekt-podushek-18 265/271/272