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

Query time 0.00276

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 (7172,6924,6730,6705,10992,6710,6804,6914,6757,6742,8000,6696,6787,6770,6727,6912,11378,6773,6739,6704,10778,6708,6803,6809,6756,6741,7914,6693,6786,6767,6726,6913,11211,6774,6735,6703,10640,6709,6800,6807,6753,6738,7411,6692,6785,6766,6725,6814,8865,6772,6733,6695,10246,6707,6799,6802,6752,6737,6690,6784,6764,6723,6813,8742,6771,6724,6694,10195,6706,6797,6801,6750,6736,7084,6689,6782,6763,6722,6812,8743,6768,6720,6691,9495,6702,6798,6793,6749,6734,6921,6688,6781,6759,11375,6721,6811,8680,6765,6718,6682,8802,6700,6796,6791,6748,6732,6923,6687,6779,6755,11104,6719,6810,6920,6762,6717,8801,6701,6795,6789,6747,6731,6686,6778,6754,11103,6716,6808,6922,6761,6715,8688,6699,6794,6783,6746,6915,6685,6776,6751,6712,11059,6714,6806,6918,6760,8241,6698,6790,6780,6745,6729,6916,6684,6777,6744,6713,11052,6711,6805,6919,6758,8008,6697,6788,6769,6743,6728,6917,6683,6775,6740) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'uk' 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-svitliy-koraloviy-emal-6-ml 387/434/435
6683 gel-lak-kira-nails-003-svitliy-rozheviy-dlya-frencha-emal-6-ml 387/434/435
6684 gel-lak-kira-nails-005-nasicheniy-rozheviy-dlya-frencha-emal-6-ml 387/434/435
6685 gel-lak-kira-nails-006-rozhevo-persikoviy-dlya-frencha-emal-6-ml 387/434/435
6686 gel-lak-kira-nails-007-persikoviy-dlya-frencha-emal-6-ml 387/434/435
6687 gel-lak-kira-nails-008-yaskravo-rozheviy-dlya-frencha-emal-6-ml 387/434/435
6688 gel-lak-kira-nails-009-blido-bezheviy-emal-6-ml 387/434/435
6689 gel-lak-kira-nails-010-svitliy-persikoviy-emal-6-ml 387/434/435
6690 gel-lak-kira-nails-011-blidiy-rozheviy-emal-6-ml 387/434/435
6691 gel-lak-kira-nails-016-duzhe-yaskraviy-malinoviy-neonoviy-6-ml 387/434/435
6692 gel-lak-kira-nails-022-bezheviy-emal-6-ml 387/434/435
6693 gel-lak-kira-nails-012-svitliy-nizhno-rozheviy-emal-6-ml 387/434/435
6694 gel-lak-kira-nails-014-kremoviy-emal-6-ml 387/434/435
6695 gel-lak-kira-nails-019-morkvyaniy-neonoviy-6-ml 387/434/435
6696 gel-lak-kira-nails-020-rozhevo-persikoviy-emal-6-ml 387/434/435
6697 gel-lak-kira-nails-024-salatoviy-emal-6-ml 387/434/435
6698 gel-lak-kira-nails-026-svitliy-biryuzoviy-emal-6-ml 387/434/435
6699 gel-lak-kira-nails-027-blakitniy-emal-6-ml 387/434/435
6700 gel-lak-kira-nails-028-zeleniy-emal-6-ml 387/434/435
6701 gel-lak-kira-nails-029-sino-fioletoviy-emal-6-ml 387/434/435
6702 gel-lak-kira-nails-030-fioletoviy-emal-6-ml 387/434/435
6703 gel-lak-kira-nails-031-fuksiya-emal-6-ml-uk 387/434/435
6704 gel-lak-kira-nails-032-slivoviy-emal-6-ml 387/434/435
6705 gel-lak-kira-nails-033-burgundi-emal-6-ml-uk 387/434/435
6706 gel-lak-kira-nails-039-korichneviy-emal-6-ml 387/434/435
6707 gel-lak-kira-nails-034-temniy-chervoniy-emal-6-ml 387/434/435
6708 gel-lak-kira-nails-035-chorniy-emal-6-ml 387/434/435
6709 gel-lak-kira-nails-036-biliy-emal-6-ml 387/434/435
6710 gel-lak-kira-nails-037-yaskravo-chervoniy-emal-6-ml 387/434/435
6711 gel-lak-kira-nails-047-priglusheniy-persikovo-bezheviy-emal-6-ml 387/434/435
6712 gel-lak-kira-nails-051-yaskraviy-rozhevo-koraloviy-emal-6-ml 387/434/435
6713 gel-lak-kira-nails-065-rozhevo-liloviy-emal-6-ml 387/434/435
6714 gel-lak-kira-nails-038-chervoniy-emal-6-ml 387/434/435
6715 gel-lak-kira-nails-043-priglusheniy-malinoviy-emal-6-ml 387/434/435
6716 gel-lak-kira-nails-040-temno-chervoniy-emal-6-ml 387/434/435
6717 gel-lak-kira-nails-041-malinoviy-emal-6-ml 387/434/435
6718 gel-lak-kira-nails-042-malinoviy-emal-6-ml 387/434/435
6719 gel-lak-kira-nails-044-yaskraviy-koraloviy-rozheviy-emal-6-ml 387/434/435
6720 gel-lak-kira-nails-045-temno-karamelniy-z-dribnim-shimer-6-ml 387/434/435
6721 gel-lak-kira-nails-046-svitliy-bezhevo-rozheviy-emal-6-ml 387/434/435
6722 gel-lak-kira-nails-049-svitliy-rozhevo-persikoviy-emal-6-ml 387/434/435
6723 gel-lak-kira-nails-048-persikovo-rozheviy-emal-6-ml 387/434/435
6724 gel-lak-kira-nails-050-kremoviy-emal-6-ml 387/434/435
6725 gel-lak-kira-nails-052-svitliy-malinovo-chervoniy-emal-6-ml 387/434/435
6726 gel-lak-kira-nails-053-priglusheniy-malinovo-rozheviy-kolir-emal-6-ml 387/434/435
6727 gel-lak-kira-nails-054-rozheviy-emal-6-ml 387/434/435
6728 gel-lak-kira-nails-055-svitlo-rozheviy-emal-6-ml 387/434/435
6729 gel-lak-kira-nails-056-lilovo-rozheviy-emal-6-ml 387/434/435
6730 gel-lak-kira-nails-057-lososeva-rozheviy-emal-6-ml 387/434/435
6731 gel-lak-kira-nails-058-temniy-rozheviy-emal-6-ml 387/434/435
6732 gel-lak-kira-nails-059-nasicheniy-lososeva-rozheviy-emal-6-ml 387/434/435
6733 gel-lak-kira-nails-061-temniy-malinoviy-emal-6-ml 387/434/435
6734 gel-lak-kira-nails-062-nasicheniy-fioletoviy-emal-6-ml 387/434/435
6735 gel-lak-kira-nails-063-fuksiya-emal-6-ml-uk 387/434/435
6736 gel-lak-kira-nails-064-blido-rozheviy-emal-6-ml 387/434/435
6737 gel-lak-kira-nails-066-svitlo-siriy-emal-6-ml 387/434/435
6738 gel-lak-kira-nails-067-temniy-fioletoviy-emal-6-ml 387/434/435
6739 gel-lak-kira-nails-068-holodna-svitla-marsala-emal-6-ml 387/434/435
6740 gel-lak-kira-nails-069-vinno-purpurniy-emal-6-ml 387/434/435
6741 gel-lak-kira-nails-070-korichnevo-rozheviy-emal-6-ml 387/434/435
6742 gel-lak-kira-nails-071-bezhevo-korichneviy-iz-zolotim-mikrobliskom-6-ml 387/434/435
6743 gel-lak-kira-nails-110-molochniy-shokolad-emal-6-ml 387/434/435
6744 gel-lak-kira-nails-076-mentoloviy-emal-6-ml 387/434/435
6745 gel-lak-kira-nails-077-salatoviy-emal-6-ml 387/434/435
6746 gel-lak-kira-nails-078-zeleniy-emal-6-ml 387/434/435
6747 gel-lak-kira-nails-079-nasicheniy-zeleniy-emal-6-ml 387/434/435
6748 gel-lak-kira-nails-072-pomarancheviy-emal-6-ml 387/434/435
6749 gel-lak-kira-nails-081-blakitniy-emal-6-ml 387/434/435
6750 gel-lak-kira-nails-082-blakitniy-emal-6-ml 387/434/435
6751 gel-lak-kira-nails-084-voloshkoviy-emal-6-ml 387/434/435
6752 gel-lak-kira-nails-085-lilovo-siriy-emal-6-ml 387/434/435
6753 gel-lak-kira-nails-086-zelenuvato-biryuzoviy-emal-6-ml 387/434/435
6754 gel-lak-kira-nails-087-svitlo-buzkoviy-emal-6-ml 387/434/435
6755 gel-lak-kira-nails-088-blido-buzkoviy-emal-6-ml 387/434/435
6756 gel-lak-kira-nails-089-buzkovo-rozheviy-emal-6-ml 387/434/435
6757 gel-lak-kira-nails-090-priglusheniy-rozheviy-emal-6-ml 387/434/435
6758 gel-lak-kira-nails-091-blidiy-lilovo-rozheviy-emal-6-ml 387/434/435
6759 gel-lak-kira-nails-092-temno-buzkoviy-emal-6-ml 387/434/435
6760 gel-lak-kira-nails-093-rozheviy-emal-6-ml 387/434/435
6761 gel-lak-kira-nails-096-yaskraviy-rozheviy-neonoviy-emal-6-ml 387/434/435
6762 gel-lak-kira-nails-097-duzhe-yaskraviy-rozheviy-neonoviy-emal-6-ml 387/434/435
6763 gel-lak-kira-nails-099-rozhevo-buzkoviy-emal-6-ml 387/434/435
6764 gel-lak-kira-nails-100-priglushena-rozheva-fuksiya-emal-6-ml 387/434/435
6765 gel-lak-kira-nails-101-yaskraviy-rozheviy-emal-6-ml 387/434/435
6766 gel-lak-kira-nails-102-temna-fuksiya-emal-6-ml 387/434/435
6767 gel-lak-kira-nails-103-rozhevo-liloviy-emal-6-ml 387/434/435
6768 gel-lak-kira-nails-104-nasicheniy-rozheviy-emal-6-ml 387/434/435
6769 gel-lak-kira-nails-106-svitlo-koraloviy-emal-neonoviy-6-ml 387/434/435
6770 gel-lak-kira-nails-107-morkvyaniy-neonoviy-emal-6-ml 387/434/435
6771 gel-lak-kira-nails-108-persikoviy-emal-6-ml 387/434/435
6772 gel-lak-kira-nails-109-temno-bezheviy-emal-6-ml 387/434/435
6773 gel-lak-kira-nails-111-nasicheniy-bezheviy-emal-6-ml 387/434/435
6774 gel-lak-kira-nails-112-rozhevo-bezheviy-emal-6-ml 387/434/435
6775 gel-lak-kira-nails-113-korichnevo-rozheviy-emal-6-ml 387/434/435
6776 gel-lak-kira-nails-114-svitlo-korichneviy-emal-6-ml 387/434/435
6777 gel-lak-kira-nails-115-buzkovo-bezheviy-emal-6-ml 387/434/435
6778 gel-lak-kira-nails-116-siro-korichneviy-emal-6-ml 387/434/435
6779 gel-lak-kira-nails-117-korichneviy-emal-6-ml 387/434/435
6780 gel-lak-kira-nails-118-rozhevo-shokoladniy-emal-6-ml 387/434/435
6781 gel-lak-kira-nails-119-slivovo-korichneviy-emal-6-ml 387/434/435
6782 gel-lak-kira-nails-120-chervono-korichneviy-emal-6-ml 387/434/435
6783 gel-lak-kira-nails-121-temno-shokoladniy-emal-6-ml 387/434/435
6784 gel-lak-kira-nails-122-blidiy-siro-salatoviy-emal-6-ml 387/434/435
6785 gel-lak-kira-nails-123-svitlo-salatoviy-emal-neonoviy-6-ml 387/434/435
6786 gel-lak-kira-nails-128-temno-zeleniy-emal-6-ml 387/434/435
6787 gel-lak-kira-nails-129-biryuzoviy-emal-6-ml 387/434/435
6788 gel-lak-kira-nails-130-nizhno-blakitniy-emal-6-ml 387/434/435
6789 gel-lak-kira-nails-131-akvamarinoviy-emal-6-ml 387/434/435
6790 gel-lak-kira-nails-135-fioletoviy-emal-6-ml 387/434/435
6791 gel-lak-kira-nails-136-ultramarin-emal-6-ml-uk-4 387/434/435
6793 gel-lak-kira-nails-137-nefritoviy-emal-6-ml 387/434/435
6794 gel-lak-kira-nails-138-zhovtiy-emal-6-ml-uk-6 387/434/435
6795 gel-lak-kira-nails-139-bezheviy-emal-6-ml 387/434/435
6796 gel-lak-kira-nails-140-nizhno-rozheviy-emal-6-ml 387/434/435
6797 gel-lak-kira-nails-141-bezhevo-rozheviy-emal-6-ml 387/434/435
6798 gel-lak-kira-nails-142-persikovo-rozheviy-emal-6-ml-uk-5 387/434/435
6799 gel-lak-kira-nails-145-oranzhevo-chervoniy-emal-6-ml 387/434/435
6800 gel-lak-kira-nails-159-priglusheniy-siro-siniy-emal-6-ml 387/434/435
6801 gel-lak-kira-nails-143-temno-morkvyaniy-emal-6-ml 387/434/435
6802 gel-lak-kira-nails-147-temniy-moh-emal-6-ml 387/434/435
6803 gel-lak-kira-nails-148-temno-zeleniy-emal-6-ml 387/434/435
6804 gel-lak-kira-nails-149-temno-fioletoviy-emal-6-ml 387/434/435
6805 gel-lak-kira-nails-150-chervono-korichneviy-emal-6-ml 387/434/435
6806 gel-lak-kira-nails-160-siriy-emal-6-ml 387/434/435
6807 gel-lak-kira-nails-151-baklazhanoviy-emal-6-ml 387/434/435
6808 gel-lak-kira-nails-152-fioletovo-korichneviy-emal-6-ml 387/434/435
6809 gel-lak-kira-nails-153-temniy-baklazhan-emal-6-ml 387/434/435
6810 gel-lak-kira-nails-154-temno-korichneviy-emal-6-ml 387/434/435
6811 gel-lak-kira-nails-156-yaskravo-siniy-emal-6-ml 387/434/435
6812 gel-lak-kira-nails-157-temno-fioletoviy-emal-6-ml 387/434/435
6813 gel-lak-kira-nails-162-zolotiy-razom-iz-sribnimi-kulkami-emal-6-ml 387/434/435
6814 gel-lak-kira-nails-002-nizhno-rozheviy-emal-6-ml 387/434/435
6912 gel-lak-kira-nails-015-bezheviy-emal-6-ml 387/434/435
6913 gel-lak-kira-nails-017-rozheviy-emal-6-ml 387/434/435
6914 gel-lak-kira-nails-168-morska-pina-emal-6-ml 387/434/435
6915 gel-lak-kira-nails-094-priglusheniy-rozheviy-emal-6-ml 387/434/435
6916 gel-lak-kira-nails-095-nasicheniy-chervoniy-z-mikrobliskom-6-ml 387/434/435
6917 gel-lak-kira-nails-144-nasicheniy-chervoniy-emal-6-ml 387/434/435
6918 gel-lak-kira-nails-146-olivkoviy-emal-6-ml 387/434/435
6919 gel-lak-kira-nails-163-chervona-troyanda-emal-6-ml 387/434/435
6920 gel-lak-kira-nails-164-vinniy-emal-6-ml 387/434/435
6921 gel-lak-kira-nails-165-chervoniy-emal-6-ml 387/434/435
6922 gel-lak-kira-nails-167-lavandova-nizhnist-emal-6-ml 387/434/435
6923 gel-lak-kira-nails-166-pikantno-chervoniy-emal-6-ml 387/434/435
6924 gel-lak-kira-nails-169-persikoviy-fatin-emal-6-ml 387/434/435
7084 gel-lak-kira-nails-001-rozheviy-dlya-frencha-napivprozoriy-emal-6-ml 387/434/435
7172 gel-lak-kira-nails-125-priglusheniy-svitlo-zeleniy-emal-6-ml 387/434/435
7411 gel-lak-kira-nails-004-rozheviy-kamuflyazh-dlya-frencha-emal-6-ml 387/434/435
7914 gel-lak-kira-nails-134-zeleno-siriy-emal-6-ml 387/434/435
8000 gel-lak-kira-nails-025-blidiy-salatoviy-emal-6-ml 387/434/435
8008 gel-lak-kira-nails-132-nizhno-blakitniy-emal-6-ml 387/434/435
8241 gel-lak-kira-nails-158-priglusheniy-siniy-emal-6-ml 387/434/435
8680 gel-lak-kira-nails-127-haki-emal-6-ml-uk 387/434/435
8688 gel-lak-kira-nails-023-zhovtiy-emal-6-ml 387/434/435
8742 gel-lak-kira-nails-060-fuksiya-emal-6-ml-uk 387/434/435
8743 gel-lak-kira-nails-083-blido-voloshkoviy-emal-6-ml 387/434/435
8801 gel-lak-kira-nails-073-sonyachno-zhovtiy-emal-6-ml 387/434/435
8802 gel-lak-kira-nails-074-blido-zhovtiy-emal-6-ml 387/434/435
8865 gel-lak-kira-nails-172-korallovyy-neonovyy-6-ml-uk 387/434/435
9495 gel-lak-kira-nails-133-siro-blakitniy-emal-6-ml 387/434/435
10195 gel-lak-kira-nails-155-buzkovo-rozheviy-emal-6-ml 387/434/435
10246 gel-lak-kira-nails-105-nizhno-rozheviy-emal-6-ml 387/434/435
10640 gel-lak-kira-nails-171-spokiyniy-zeleniy-emal-6-ml 387/434/435
10778 gel-lak-kira-nails-126-priglusheniy-zeleniy-emal-6-ml 387/434/435
10992 gel-lak-kira-nails-080-temno-blakitniy-emal-6-ml 387/434/435
11052 gel-lak-kira-nails-013-svitliy-persikovo-rozheviy-emal-6-ml 387/434/435
11059 gel-lak-kira-nails-161-temniy-sino-blakitniy-emal-6-ml 387/434/435
11103 gel-lak-kira-nails-075-svitlo-zhovtiy-emal-6-ml 387/434/435
11104 gel-lak-kira-nails-021-pomarancheviy-emal-6-ml 387/434/435
11211 gel-lak-kira-nails-170-molochniy-shokolad-emal-6-ml 387/434/435
11375 gel-lak-kira-nails-124-salatoviy-emal-neonoviy-6-ml 387/434/435
11378 gel-lak-kira-nails-098-koraloviy-neonoviy-emal-6-ml 387/434/435