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 (
    9984, 
    9985, 
    9986, 
    9987, 
    9988, 
    9989, 
    9990, 
    9991, 
    9992, 
    9993, 
    9994, 
    9995, 
    9996, 
    9997, 
    9998, 
    9999, 
    10747, 
    10748, 
    10749, 
    10750, 
    10751, 
    10752, 
    9972, 
    9973, 
    9975, 
    9976, 
    9977, 
    9978, 
    9979, 
    10179, 
    10180, 
    10523, 
    10073, 
    10077, 
    10076, 
    10086, 
    10085, 
    10084, 
    10083, 
    10082, 
    10081, 
    10080, 
    10079, 
    10584, 
    10594, 
    10739, 
    10740, 
    10741, 
    10742, 
    10759, 
    10760, 
    10761, 
    10762, 
    10763, 
    10764, 
    10765, 
    10766, 
    10778, 
    10779, 
    10780, 
    10781, 
    10782, 
    10783, 
    10784, 
    10785, 
    10786, 
    10787, 
    10788, 
    10789, 
    10790, 
    10791, 
    10767, 
    10768, 
    10769, 
    10770, 
    10771, 
    10772, 
    10773, 
    10774, 
    10775, 
    10776, 
    10777, 
    12944, 
    12985, 
    12986, 
    12987, 
    12988, 
    12989, 
    12990, 
    12991, 
    12992, 
    12993, 
    12994, 
    10063, 
    10052, 
    10072, 
    10046, 
    10059, 
    10064, 
    10057, 
    10048, 
    10062, 
    10070, 
    10058, 
    10045, 
    10054, 
    10047, 
    10071, 
    10067, 
    10051, 
    10060, 
    10055, 
    10043, 
    10068, 
    10065, 
    10061, 
    10050, 
    10056, 
    10044, 
    10069, 
    10066, 
    10024, 
    10025, 
    10026, 
    10027, 
    10028, 
    10029, 
    10030
  ) 
  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.00147

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 (9984,9985,9986,9987,9988,9989,9990,9991,9992,9993,9994,9995,9996,9997,9998,9999,10747,10748,10749,10750,10751,10752,9972,9973,9975,9976,9977,9978,9979,10179,10180,10523,10073,10077,10076,10086,10085,10084,10083,10082,10081,10080,10079,10584,10594,10739,10740,10741,10742,10759,10760,10761,10762,10763,10764,10765,10766,10778,10779,10780,10781,10782,10783,10784,10785,10786,10787,10788,10789,10790,10791,10767,10768,10769,10770,10771,10772,10773,10774,10775,10776,10777,12944,12985,12986,12987,12988,12989,12990,12991,12992,12993,12994,10063,10052,10072,10046,10059,10064,10057,10048,10062,10070,10058,10045,10054,10047,10071,10067,10051,10060,10055,10043,10068,10065,10061,10050,10056,10044,10069,10066,10024,10025,10026,10027,10028,10029,10030) 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
9972 continent-col-03 265/280/283/1641
9973 continent-col-04 265/280/283/1641
9975 continent-col-06 265/280/283/1641
9976 continent-col-07 265/280/283/1641
9977 continent-col-08 265/280/283/1641
9978 continent-col-09 265/280/283/1641
9979 continent-col-10 265/280/283/1641
9984 abitare-col-02-ru 265/280/283/1638
9985 abitare-col-03 265/280/283/1638
9986 abitare-col-04 265/280/283/1638
9987 abitare-col-05 265/280/283/1638
9988 abitare-col-06 265/280/283/1638
9989 abitare-col-07 265/280/283/1638
9990 abitare-col-08 265/280/283/1638
9991 abitare-col-09 265/280/283/1638
9992 abitare-col-10 265/280/283/1638
9993 abitare-col-11 265/280/283/1638
9994 abitare-col-12 265/280/283/1638
9995 abitare-col-13 265/280/283/1638
9996 abitare-col-14 265/280/283/1638
9997 abitare-col-15 265/280/283/1638
9998 abitare-col-16 265/280/283/1638
9999 abitare-col-17 265/280/283/1638
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
10043 simmetrika-col-05-ru 265/280/283/1629
10044 simmetrika-col-05-ru-2 265/280/283/1629
10045 simmetrika-col-15 265/280/283/1629
10046 simmetrika-col-06 265/280/283/1629
10047 simmetrika-col-17 265/280/283/1629
10048 simmetrika-col-10 265/280/283/1629
10050 simmetrika-col-02-ru 265/280/283/1629
10051 simmetrika-col-21 265/280/283/1629
10052 simmetrika-col-03 265/280/283/1629
10054 simmetrika-col-16 265/280/283/1629
10055 simmetrika-col-03-ru 265/280/283/1629
10056 simmetrika-col-03-ru-2 265/280/283/1629
10057 simmetrika-col-09 265/280/283/1629
10058 simmetrika-col-13 265/280/283/1629
10059 simmetrika-col-07 265/280/283/1629
10060 simmetrika-col-01-ru 265/280/283/1629
10061 simmetrika-col-01-ru-2 265/280/283/1629
10062 simmetrika-col-11 265/280/283/1629
10063 simmetrika-col-01 265/280/283/1629
10064 simmetrika-col-08 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
10070 simmetrika-col-12 265/280/283/1629
10071 simmetrika-col-18 265/280/283/1629
10072 simmetrika-col-05 265/280/283/1629
10073 cos-col-04 265/280/283/1674
10076 cos-col-06 265/280/283/1674
10077 cos-col-05 265/280/283/1674
10079 cos-col-14 265/280/283/1674
10080 cos-col-13 265/280/283/1674
10081 cos-col-12 265/280/283/1674
10082 cos-col-11 265/280/283/1674
10083 cos-col-10 265/280/283/1674
10084 cos-col-09 265/280/283/1674
10085 cos-col-08 265/280/283/1674
10086 cos-col-07 265/280/283/1674
10179 cos-col-01 265/280/283/1674
10180 cos-col-02 265/280/283/1674
10523 cos-col-03 265/280/283/1674
10584 cos-col-15 265/280/283/1674
10594 cos-col-16 265/280/283/1674
10739 desert-col-01 265/280/283/1669
10740 desert-col-02 265/280/283/1669
10741 desert-col-03 265/280/283/1669
10742 desert-plain 265/280/283/1669
10747 product-10747 265/280/283/1677
10748 product-10748 265/280/283/1677
10749 product-10749 265/280/283/1677
10750 product-10750 265/280/283/1677
10751 product-10751 265/280/283/1677
10752 product-10752 265/280/283/1677
10759 product-10759 265/280/283/1678
10760 product-10760 265/280/283/1678
10761 product-10761 265/280/283/1678
10762 dune-col-04 265/280/283/1678
10763 dune-col-05 265/280/283/1678
10764 dune-col-06 265/280/283/1678
10765 dune-col-07 265/280/283/1678
10766 dune-col-08 265/280/283/1678
10767 product-10767 265/280/283/1681
10768 product-10768 265/280/283/1681
10769 product-10769 265/280/283/1681
10770 product-10770 265/280/283/1681
10771 product-10771 265/280/283/1681
10772 product-10772 265/280/283/1681
10773 pafos-col-07 265/280/283/1681
10774 pafos-col-08 265/280/283/1681
10775 product-10775 265/280/283/1681
10776 product-10776 265/280/283/1681
10777 pafos-col-11 265/280/283/1681
10778 product-10778 265/280/283/1675
10779 product-10779 265/280/283/1675
10780 product-10780 265/280/283/1675
10781 product-10781 265/280/283/1675
10782 product-10782 265/280/283/1675
10783 product-10783 265/280/283/1675
10784 product-10784 265/280/283/1675
10785 product-10785 265/280/283/1675
10786 product-10786 265/280/283/1675
10787 product-10787 265/280/283/1675
10788 product-10788 265/280/283/1675
10789 product-10789 265/280/283/1675
10790 product-10790 265/280/283/1675
10791 product-10791 265/280/283/1675
12944 philosophy-jute-sol-01 265/280/283
12985 primo-col-01 265/280/283/1649
12986 primo-col-02 265/280/283/1649
12987 primo-col-03 265/280/283/1649
12988 primo-col-04 265/280/283/1649
12989 primo-col-05 265/280/283/1649
12990 primo-col-06 265/280/283/1649
12991 primo-col-07 265/280/283/1649
12992 primo-col-08 265/280/283/1649
12993 primo-col-09 265/280/283/1649
12994 primo-col-10 265/280/283/1649