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 (
    6924, 
    6730, 
    7172, 
    6706, 
    6797, 
    6801, 
    6750, 
    6694, 
    10195, 
    7084, 
    6689, 
    6782, 
    6763, 
    6736, 
    6812, 
    8743, 
    6768, 
    6720, 
    6722, 
    6702, 
    6798, 
    6793, 
    6749, 
    6691, 
    9495, 
    6921, 
    6688, 
    6781, 
    6759, 
    6734, 
    6811, 
    8680, 
    6765, 
    6718, 
    11375, 
    6721, 
    6700, 
    6796, 
    6791, 
    6748, 
    6682, 
    8802, 
    6923, 
    6687, 
    6779, 
    6755, 
    6732, 
    6810, 
    6920, 
    6762, 
    6717, 
    11104, 
    6719, 
    6701, 
    6795, 
    6789, 
    6747, 
    8801, 
    6686, 
    6778, 
    6754, 
    6731, 
    6808, 
    6922, 
    6761, 
    6715, 
    11103, 
    6716, 
    6699, 
    6794, 
    6783, 
    6746, 
    8688, 
    6915, 
    6685, 
    6776, 
    6751, 
    6806, 
    6918, 
    6760, 
    6712, 
    11059, 
    6714, 
    6698, 
    6790, 
    6780, 
    6745, 
    8241, 
    6916, 
    6684, 
    6777, 
    6744, 
    6729, 
    6805, 
    6919, 
    6758, 
    6713, 
    11052, 
    6711, 
    6697, 
    6788, 
    6769, 
    6743, 
    8008, 
    6917, 
    6683, 
    6775, 
    6740, 
    6728, 
    6710, 
    6804, 
    6914, 
    6757, 
    6705, 
    10992, 
    6696, 
    6787, 
    6770, 
    6742, 
    8000, 
    6912, 
    11378, 
    6773, 
    6739, 
    6727, 
    6708, 
    6803, 
    6809, 
    6756, 
    6704, 
    10778, 
    6693, 
    6786, 
    6767, 
    6741, 
    7914, 
    6913, 
    11211, 
    6774, 
    6735, 
    6726, 
    6709, 
    6800, 
    6807, 
    6753, 
    6703, 
    10640, 
    7411, 
    6692, 
    6785, 
    6766, 
    6738, 
    6814, 
    8865, 
    6772, 
    6733, 
    6725, 
    6707, 
    6799, 
    6802, 
    6752, 
    6695, 
    10246, 
    6690, 
    6784, 
    6764, 
    6737, 
    6813, 
    8742, 
    6771, 
    6724, 
    6723
  ) 
  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.00311

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "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": 344,
          "filtered": 100,
          "index_condition": "cscart_seo_names.object_id in (6924,6730,7172,6706,6797,6801,6750,6694,10195,7084,6689,6782,6763,6736,6812,8743,6768,6720,6722,6702,6798,6793,6749,6691,9495,6921,6688,6781,6759,6734,6811,8680,6765,6718,11375,6721,6700,6796,6791,6748,6682,8802,6923,6687,6779,6755,6732,6810,6920,6762,6717,11104,6719,6701,6795,6789,6747,8801,6686,6778,6754,6731,6808,6922,6761,6715,11103,6716,6699,6794,6783,6746,8688,6915,6685,6776,6751,6806,6918,6760,6712,11059,6714,6698,6790,6780,6745,8241,6916,6684,6777,6744,6729,6805,6919,6758,6713,11052,6711,6697,6788,6769,6743,8008,6917,6683,6775,6740,6728,6710,6804,6914,6757,6705,10992,6696,6787,6770,6742,8000,6912,11378,6773,6739,6727,6708,6803,6809,6756,6704,10778,6693,6786,6767,6741,7914,6913,11211,6774,6735,6726,6709,6800,6807,6753,6703,10640,7411,6692,6785,6766,6738,6814,8865,6772,6733,6725,6707,6799,6802,6752,6695,10246,6690,6784,6764,6737,6813,8742,6771,6724,6723) 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
6682 gel-lak-kira-nails-018-svetlyy-korallovyy-emal-6-ml 387/434/435
6683 gel-lak-kira-nails-003-svetlyy-rozovyy-dlya-frencha-emal-6-ml 387/434/435
6684 gel-lak-kira-nails-005-nasyschennyy-rozovyy-dlya-frencha-emal-6-ml 387/434/435
6685 gel-lak-kira-nails-006-rozovo-persikovyy-dlya-frencha-emal-6-ml 387/434/435
6686 gel-lak-kira-nails-007-persikovyy-dlya-frencha-emal-6-ml 387/434/435
6687 gel-lak-kira-nails-008-yarko-rozovyy-dlya-frencha-emal-6-ml 387/434/435
6688 gel-lak-kira-nails-009-bledno-bezhevyy-emal-6-ml 387/434/435
6689 gel-lak-kira-nails-010-svetlyy-persikovyy-emal-6-ml 387/434/435
6690 gel-lak-kira-nails-011-blednyy-rozovyy-emal-6-ml 387/434/435
6691 gel-lak-kira-nails-016-ochen-yarkiy-malinovyy-neonovyy-6-ml 387/434/435
6692 gel-lak-kira-nails-022-bezhevyy-emal-6-ml 387/434/435
6693 gel-lak-kira-nails-012-svetlyy-nezhno-rozovyy-emal-6-ml 387/434/435
6694 gel-lak-kira-nails-014-kremovyy-emal-6-ml 387/434/435
6695 gel-lak-kira-nails-019-morkovnyy-neonovyy-6-ml 387/434/435
6696 gel-lak-kira-nails-020-rozovo-persikovyy-emal-6-ml 387/434/435
6697 gel-lak-kira-nails-024-salatovyy-emal-6-ml 387/434/435
6698 gel-lak-kira-nails-026-svetlyy-biryuzovyy-emal-6-ml 387/434/435
6699 gel-lak-kira-nails-027-goluboy-emal-6-ml 387/434/435
6700 gel-lak-kira-nails-028-zelenyy-emal-6-ml 387/434/435
6701 gel-lak-kira-nails-029-sine-fioletovyy-emal-6-ml 387/434/435
6702 gel-lak-kira-nails-030-fioletovyy-emal-6-ml 387/434/435
6703 gel-lak-kira-nails-031-fuksiya-emal-6-ml 387/434/435
6704 gel-lak-kira-nails-032-slivovyy-emal-6-ml 387/434/435
6705 gel-lak-kira-nails-033-burgundi-emal-6-ml 387/434/435
6706 gel-lak-kira-nails-039-korichnevyy-emal-6-ml 387/434/435
6707 gel-lak-kira-nails-034-temnyy-krasnyy-emal-6-ml 387/434/435
6708 gel-lak-kira-nails-035-chernyy-emal-6-ml 387/434/435
6709 gel-lak-kira-nails-036-belyy-emal-6-ml 387/434/435
6710 gel-lak-kira-nails-037-yarko-krasnyy-emal-6-ml 387/434/435
6711 gel-lak-kira-nails-047-priglushennyy-persikovo-bezhevyy-emal-6-ml 387/434/435
6712 gel-lak-kira-nails-051-yarkiy-rozovo-korallovyy-emal-6-ml 387/434/435
6713 gel-lak-kira-nails-065-rozovo-lilovyy-emal-6-ml 387/434/435
6714 gel-lak-kira-nails-038-krasnyy-emal-6-ml 387/434/435
6715 gel-lak-kira-nails-043-priglushennyy-malinovyy-emal-6-ml 387/434/435
6716 gel-lak-kira-nails-040-temno-krasnyy-emal-6-ml 387/434/435
6717 gel-lak-kira-nails-041-malinovyy-emal-6-ml 387/434/435
6718 gel-lak-kira-nails-042-malinovyy-emal-6-ml 387/434/435
6719 gel-lak-kira-nails-044-yarkiy-korallovyy-rozovyy-emal-6-ml 387/434/435
6720 gel-lak-kira-nails-045-temno-karamelnyy-s-melkim-shimer-6-ml 387/434/435
6721 gel-lak-kira-nails-046-svetlyy-bezhevo-rozovyy-emal-6-ml 387/434/435
6722 gel-lak-kira-nails-049-svetlyy-rozovo-persikovyy-emal-6-ml 387/434/435
6723 gel-lak-kira-nails-048-persikovo-rozovyy-emal-6-ml 387/434/435
6724 gel-lak-kira-nails-050-kremovyy-emal-6-ml 387/434/435
6725 gel-lak-kira-nails-052-svetlyy-malinovo-krasnyy-emal-6-ml 387/434/435
6726 gel-lak-kira-nails-053-priglushennyy-malinovo-rozovyy-cvet-emal-6-ml 387/434/435
6727 gel-lak-kira-nails-054-rozovyy-emal-6-ml 387/434/435
6728 gel-lak-kira-nails-055-svetlo-rozovyy-emal-6-ml 387/434/435
6729 gel-lak-kira-nails-056-lilovo-rozovyy-emal-6-ml 387/434/435
6730 gel-lak-kira-nails-057-lososevaya-rozovyy-emal-6-ml 387/434/435
6731 gel-lak-kira-nails-058-temnyy-rozovyy-emal-6-ml 387/434/435
6732 gel-lak-kira-nails-059-nasyschennyy-lososevaya-rozovyy-emal-6-ml 387/434/435
6733 gel-lak-kira-nails-061-temnyy-malinovyy-emal-6-ml 387/434/435
6734 gel-lak-kira-nails-062-nasyschennyy-fioletovyy-emal-6-ml 387/434/435
6735 gel-lak-kira-nails-063-fuksiya-emal-6-ml 387/434/435
6736 gel-lak-kira-nails-064-bledno-rozovyy-emal-6-ml 387/434/435
6737 gel-lak-kira-nails-066-svetlo-seryy-emal-6-ml 387/434/435
6738 gel-lak-kira-nails-067-temnyy-fioletovyy-emal-6-ml 387/434/435
6739 gel-lak-kira-nails-068-holodnaya-sveta-marsala-emal-6-ml 387/434/435
6740 gel-lak-kira-nails-069-vinno-purpurnyy-emal-6-ml 387/434/435
6741 gel-lak-kira-nails-070-korichnevo-rozovyy-emal-6-ml 387/434/435
6742 gel-lak-kira-nails-071-bezhevo-korichnevyy-s-zolotym-mikrobleskom-6-ml 387/434/435
6743 gel-lak-kira-nails-110-molochnyy-shokolad-emal-6-ml 387/434/435
6744 gel-lak-kira-nails-076-mentolovyy-emal-6-ml 387/434/435
6745 gel-lak-kira-nails-077-salatovyy-emal-6-ml 387/434/435
6746 gel-lak-kira-nails-078-zelenyy-emal-6-ml 387/434/435
6747 gel-lak-kira-nails-079-nasyschennyy-zelenyy-emal-6-ml 387/434/435
6748 gel-lak-kira-nails-072-oranzhevyy-emal-6-ml 387/434/435
6749 gel-lak-kira-nails-081-goluboy-emal-6-ml 387/434/435
6750 gel-lak-kira-nails-082-goluboy-emal-6-ml 387/434/435
6751 gel-lak-kira-nails-084-vasilkovyy-emal-6-ml 387/434/435
6752 gel-lak-kira-nails-085-lilovo-seryy-emal-6-ml 387/434/435
6753 gel-lak-kira-nails-086-zelenovato-biryuzovyy-emal-6-ml 387/434/435
6754 gel-lak-kira-nails-087-svetlo-sirenevyy-emal-6-ml 387/434/435
6755 gel-lak-kira-nails-088-bledno-sirenevyy-emal-6-ml 387/434/435
6756 gel-lak-kira-nails-089-sirenevo-rozovyy-emal-6-ml 387/434/435
6757 gel-lak-kira-nails-090-priglushennyy-rozovyy-emal-6-ml 387/434/435
6758 gel-lak-kira-nails-091-blednyy-lilovo-rozovyy-emal-6-ml 387/434/435
6759 gel-lak-kira-nails-092-temno-sirenevyy-emal-6-ml 387/434/435
6760 gel-lak-kira-nails-093-rozovyy-emal-6-ml 387/434/435
6761 gel-lak-kira-nails-096-yarkiy-rozovyy-neonovyy-emal-6-ml 387/434/435
6762 gel-lak-kira-nails-097-ochen-yarkiy-rozovyy-neonovyy-emal-6-ml 387/434/435
6763 gel-lak-kira-nails-099-rozovo-sirenevyy-emal-6-ml 387/434/435
6764 gel-lak-kira-nails-100-priglushennaya-rozovaya-fuksiya-emal-6-ml 387/434/435
6765 gel-lak-kira-nails-101-yarkiy-rozovyy-emal-6-ml 387/434/435
6766 gel-lak-kira-nails-102-temnaya-fuksiya-emal-6-ml 387/434/435
6767 gel-lak-kira-nails-103-rozovo-lilovyy-emal-6-ml 387/434/435
6768 gel-lak-kira-nails-104-nasyschennyy-rozovyy-emal-6-ml 387/434/435
6769 gel-lak-kira-nails-106-svetlo-korallovyy-emal-neonovyy-6-ml 387/434/435
6770 gel-lak-kira-nails-107-morkovnyy-neonovyy-emal-6-ml 387/434/435
6771 gel-lak-kira-nails-108-persikovyy-emal-6-ml 387/434/435
6772 gel-lak-kira-nails-109-temno-bezhevyy-emal-6-ml 387/434/435
6773 gel-lak-kira-nails-111-nasyschennyy-bezhevyy-emal-6-ml 387/434/435
6774 gel-lak-kira-nails-112-rozovo-bezhevyy-emal-6-ml 387/434/435
6775 gel-lak-kira-nails-113-korichnevo-rozovyy-emal-6-ml 387/434/435
6776 gel-lak-kira-nails-114-svetlo-korichnevyy-emal-6-ml 387/434/435
6777 gel-lak-kira-nails-115-sirenevo-bezhevyy-emal-6-ml 387/434/435
6778 gel-lak-kira-nails-116-sero-korichnevyy-emal-6-ml 387/434/435
6779 gel-lak-kira-nails-117-korichnevyy-emal-6-ml 387/434/435
6780 gel-lak-kira-nails-118-rozovo-shokoladnyy-emal-6-ml 387/434/435
6781 gel-lak-kira-nails-119-slivovo-korichnevyy-emal-6-ml 387/434/435
6782 gel-lak-kira-nails-120-krasno-korichnevyy-emal-6-ml 387/434/435
6783 gel-lak-kira-nails-121-temno-shokoladnyy-emal-6-ml 387/434/435
6784 gel-lak-kira-nails-122-blednyy-sero-salatovyy-emal-6-ml 387/434/435
6785 gel-lak-kira-nails-123-svetlo-salatovyy-emal-neonovyy-6-ml 387/434/435
6786 gel-lak-kira-nails-128-temno-zelenyy-emal-6-ml 387/434/435
6787 gel-lak-kira-nails-129-biryuzovyy-emal-6-ml 387/434/435
6788 gel-lak-kira-nails-130-nezhno-goluboy-emal-6-ml 387/434/435
6789 gel-lak-kira-nails-131-akvamarinovyy-emal-6-ml 387/434/435
6790 gel-lak-kira-nails-135-fioletovyy-emal-6-ml 387/434/435
6791 gel-lak-kira-nails-136-ultramarin-emal-6-ml 387/434/435
6793 gel-lak-kira-nails-137-nefritovyy-emal-6-ml 387/434/435
6794 gel-lak-kira-nails-138-zheltyy-emal-6-ml 387/434/435
6795 gel-lak-kira-nails-139-bezhevyy-emal-6-ml 387/434/435
6796 gel-lak-kira-nails-140-nezhno-rozovyy-emal-6-ml 387/434/435
6797 gel-lak-kira-nails-141-bezhevo-rozovyy-emal-6-ml 387/434/435
6798 gel-lak-kira-nails-142-persikovo-rozovyy-emal-6-ml 387/434/435
6799 gel-lak-kira-nails-145-oranzhevo-krasnyy-emal-6-ml 387/434/435
6800 gel-lak-kira-nails-159-priglushennyy-sero-siniy-emal-6-ml 387/434/435
6801 gel-lak-kira-nails-143-temno-morkovnyy-emal-6-ml 387/434/435
6802 gel-lak-kira-nails-147-temnyy-moh-emal-6-ml 387/434/435
6803 gel-lak-kira-nails-148-temno-zelenyy-emal-6-ml 387/434/435
6804 gel-lak-kira-nails-149-temno-fioletovyy-emal-6-ml 387/434/435
6805 gel-lak-kira-nails-150-krasno-korichnevyy-emal-6-ml 387/434/435
6806 gel-lak-kira-nails-160-seryy-emal-6-ml 387/434/435
6807 gel-lak-kira-nails-151-baklazhannyy-emal-6-ml 387/434/435
6808 gel-lak-kira-nails-152-fioletovo-korichnevyy-emal-6-ml 387/434/435
6809 gel-lak-kira-nails-153-temnyy-baklazhan-emal-6-ml 387/434/435
6810 gel-lak-kira-nails-154-temno-korichnevyy-emal-6-ml 387/434/435
6811 gel-lak-kira-nails-156-yarko-siniy-emal-6-ml 387/434/435
6812 gel-lak-kira-nails-157-temno-fioletovyy-emal-6-ml 387/434/435
6813 gel-lak-kira-nails-162-zolotoy-s-serebryanymi-blestkami-emal-6-ml 387/434/435
6814 gel-lak-kira-nails-002-nezhno-rozovyy-emal-6-ml 387/434/435
6912 gel-lak-kira-nails-015-bezhevyy-emal-6-ml 387/434/435
6913 gel-lak-kira-nails-017-rozovyy-emal-6-ml 387/434/435
6914 gel-lak-kira-nails-168-morskaya-pena-emal-6-ml 387/434/435
6915 gel-lak-kira-nails-094-priglushennyy-rozovyy-emal-6-ml 387/434/435
6916 gel-lak-kira-nails-095-nasyschennyy-krasnyy-s-mikrobliskom-6-ml 387/434/435
6917 gel-lak-kira-nails-144-nasyschennyy-krasnyy-emal-6-ml 387/434/435
6918 gel-lak-kira-nails-146-olivkovyy-emal-6-ml 387/434/435
6919 gel-lak-kira-nails-163-krasnaya-roza-emal-6-ml 387/434/435
6920 gel-lak-kira-nails-164-vinnyy-emal-6-ml 387/434/435
6921 gel-lak-kira-nails-165-krasnyy-emal-6-ml 387/434/435
6922 gel-lak-kira-nails-167-lavandovoe-nezhnost-emal-6-ml 387/434/435
6923 gel-lak-kira-nails-166-pikantno-krasnyy-emal-6-ml 387/434/435
6924 gel-lak-kira-nails-169-persikovyy-fatin-emal-6-ml 387/434/435
7084 gel-lak-kira-nails-001-rozovyy-dlya-frencha-poluprozrachnyy-emal-6-ml 387/434/435
7172 gel-lak-kira-nails-125-priglushennyy-svet-zelenyy-emal-6-ml 387/434/435
7411 gel-lak-kira-nails-004-rozovyy-kamuflyazh-dlya-frencha-emal-6-ml 387/434/435
7914 gel-lak-kira-nails-134-zeleno-seryy-emal-6-ml 387/434/435
8000 gel-lak-kira-nails-025-blednyy-salatovyy-emal-6-ml 387/434/435
8008 gel-lak-kira-nails-132-nezhno-goluboy-emal-6-ml 387/434/435
8241 gel-lak-kira-nails-158-priglushennyy-siniy-emal-6-ml 387/434/435
8680 gel-lak-kira-nails-127-haki-emal-6-ml 387/434/435
8688 gel-lak-kira-nails-023-zheltyy-emal-6-ml 387/434/435
8742 gel-lak-kira-nails-060-fuksiya-emal-6-ml 387/434/435
8743 gel-lak-kira-nails-083-bledno-vasilkovyy-emal-6-ml 387/434/435
8801 gel-lak-kira-nails-073-svetlo-zheltyy-emal-6-ml 387/434/435
8802 gel-lak-kira-nails-074-svetlo-zheltyy-emal-6-ml 387/434/435
8865 gel-lak-kira-nails-172-korallovyy-neonovyy-6-ml 387/434/435
9495 gel-lak-kira-nails-133-sero-goluboy-emal-6-ml 387/434/435
10195 gel-lak-kira-nails-155-sirenevo-rozovyy-emal-6-ml 387/434/435
10246 gel-lak-kira-nails-105-nezhno-rozovyy-emal-6-ml 387/434/435
10640 gel-lak-kira-nails-171-spokoynyy-zelenyy-emal-6-ml 387/434/435
10778 gel-lak-kira-nails-126-priglushennyy-zelenyy-emal-6-ml 387/434/435
10992 gel-lak-kira-nails-080-temno-goluboy-emal-6-ml 387/434/435
11052 gel-lak-kira-nails-013-svetlyy-persikovo-rozovyy-emal-6-ml 387/434/435
11059 gel-lak-kira-nails-161-temnyy-sine-goluboy-emal-6-ml 387/434/435
11103 gel-lak-kira-nails-075-bledno-zheltyy-emal-6-ml 387/434/435
11104 gel-lak-kira-nails-021-oranzhevyy-emal-6-ml 387/434/435
11211 gel-lak-kira-nails-170-6-ml 387/434/435
11375 gel-lak-kira-nails-124-salatovyy-emal-neonovye-6-ml 387/434/435
11378 gel-lak-kira-nails-098-korallovyy-neonovyy-emal-6-ml 387/434/435