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 (
    9953, 
    9629, 
    9753, 
    9569, 
    9655, 
    9611, 
    10030, 
    9643, 
    9925, 
    9584, 
    9683, 
    8457, 
    9952, 
    9630, 
    9568, 
    9668, 
    9654, 
    9937, 
    9610, 
    9738, 
    8939, 
    9961, 
    9923, 
    9582, 
    9682, 
    8308, 
    9632, 
    9750, 
    9666, 
    9737, 
    8936, 
    8307, 
    9641, 
    9924, 
    9581, 
    9681, 
    9950, 
    9627, 
    9565, 
    9665, 
    9652, 
    9934, 
    9606, 
    8933, 
    9960, 
    9640, 
    9922, 
    9578, 
    9949, 
    9626, 
    9748, 
    9564, 
    9664, 
    9651, 
    9933, 
    9604, 
    9735, 
    8687, 
    9959, 
    9921, 
    9577, 
    9662, 
    9947, 
    9625, 
    9562, 
    9650, 
    9932, 
    9600, 
    9734, 
    7493, 
    9958, 
    9638, 
    9576, 
    9677, 
    9945, 
    9623, 
    9746, 
    8999, 
    9931, 
    9599, 
    8463, 
    6883, 
    9956, 
    9758, 
    9575, 
    9676, 
    9660, 
    9944, 
    9621, 
    9745, 
    8983, 
    9648, 
    9930, 
    9732, 
    8462, 
    9957, 
    9635, 
    9757, 
    9574, 
    9673, 
    9658, 
    9943, 
    9744, 
    9647, 
    9928, 
    9589, 
    9730, 
    8461, 
    9955, 
    9756, 
    9573, 
    9672, 
    9657, 
    9942, 
    9616, 
    9743, 
    8945, 
    9927, 
    9587, 
    9686, 
    8459, 
    9954, 
    9633, 
    9754, 
    9671, 
    9656, 
    9612, 
    8941, 
    10202, 
    9645, 
    9926, 
    9585, 
    9685, 
    8458, 
    9670, 
    9939, 
    9740, 
    8940, 
    9752, 
    9642, 
    9951, 
    9566, 
    9653, 
    9935, 
    9607, 
    9962, 
    9749, 
    9736, 
    8235, 
    9680, 
    8213, 
    9639, 
    9678, 
    9747, 
    8686, 
    9920, 
    9661, 
    9649, 
    9733, 
    9636, 
    9591, 
    9619, 
    8982, 
    9634, 
    9646, 
    9572, 
    9940, 
    9741
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en' 
  AND (
    cscart_seo_names.company_id = 1 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00328

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": 336,
          "filtered": 100,
          "index_condition": "cscart_seo_names.object_id in (9953,9629,9753,9569,9655,9611,10030,9643,9925,9584,9683,8457,9952,9630,9568,9668,9654,9937,9610,9738,8939,9961,9923,9582,9682,8308,9632,9750,9666,9737,8936,8307,9641,9924,9581,9681,9950,9627,9565,9665,9652,9934,9606,8933,9960,9640,9922,9578,9949,9626,9748,9564,9664,9651,9933,9604,9735,8687,9959,9921,9577,9662,9947,9625,9562,9650,9932,9600,9734,7493,9958,9638,9576,9677,9945,9623,9746,8999,9931,9599,8463,6883,9956,9758,9575,9676,9660,9944,9621,9745,8983,9648,9930,9732,8462,9957,9635,9757,9574,9673,9658,9943,9744,9647,9928,9589,9730,8461,9955,9756,9573,9672,9657,9942,9616,9743,8945,9927,9587,9686,8459,9954,9633,9754,9671,9656,9612,8941,10202,9645,9926,9585,9685,8458,9670,9939,9740,8940,9752,9642,9951,9566,9653,9935,9607,9962,9749,9736,8235,9680,8213,9639,9678,9747,8686,9920,9661,9649,9733,9636,9591,9619,8982,9634,9646,9572,9940,9741) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en' and (cscart_seo_names.company_id = 1 or cscart_seo_names.company_id = 0)"
        }
      }
    ]
  }
}

Result

product_id seo_name seo_path
6883 gel-lak-oxxi-248-10-ml-en 387/448/450
7493 gel-lak-oxxi-274-10-ml-en 387/448/450
8213 gel-lak-oxxi-259-10-ml-en 387/448/450
8235 gel-lak-oxxi-202-10-ml-en 387/448/450
8307 gel-lak-oxxi-277-10-ml 387/448/450
8308 gel-lak-oxxi-278-10-ml-en 387/448/450
8457 gel-lak-oxxi-269-10-ml-en 387/448/450
8458 gel-lak-oxxi-270-10-ml-en 387/448/450
8459 gel-lak-oxxi-271-10-ml 387/448/450
8461 gel-lak-oxxi-272-10-ml-en 387/448/450
8462 gel-lak-oxxi-273-10-ml-en 387/448/450
8463 gel-lak-oxxi-275-10-ml-en 387/448/450
8686 gel-lak-oxxi-042-10-ml-en 387/448/450
8687 gel-lak-oxxi-024-10-ml-en 387/448/450
8933 gel-lak-oxxi-044-10-ml-en 387/448/450
8936 gel-lak-oxxi-060-10-ml-en 387/448/450
8939 gel-lak-oxxi-070-10-ml-en 387/448/450
8940 gel-lak-oxxi-084-10-ml 387/448/450
8941 gel-lak-oxxi-173-10-ml 387/448/450
8945 gel-lak-oxxi-151-10-ml-en 387/448/450
8982 gel-lak-oxxi-138-10-ml-en 387/448/450
8983 gel-lak-oxxi-109-10-ml 387/448/450
8999 gel-lak-oxxi-245-10-ml 387/448/450
9562 gel-lak-oxxi-107-10-ml 387/448/450
9564 gel-lak-oxxi-076-10-ml-en 387/448/450
9565 gel-lak-oxxi-061-10-ml-en 387/448/450
9566 gel-lak-oxxi-267-10-ml-en 387/448/450
9568 gel-lak-oxxi-265-10-ml-en 387/448/450
9569 gel-lak-oxxi-266-10-ml-en 387/448/450
9572 gel-lak-oxxi-002-10-ml-en 387/448/450
9573 gel-lak-oxxi-004-10-ml-en 387/448/450
9574 gel-lak-oxxi-006-10-ml-en 387/448/450
9575 gel-lak-oxxi-007-10-ml-en 387/448/450
9576 gel-lak-oxxi-008-10-ml-en 387/448/450
9577 gel-lak-oxxi-010-10-ml-en 387/448/450
9578 gel-lak-oxxi-012-10-ml-en 387/448/450
9581 gel-lak-oxxi-019-10-ml-en 387/448/450
9582 gel-lak-oxxi-020-10-ml-en 387/448/450
9584 gel-lak-oxxi-022-10-ml-en 387/448/450
9585 gel-lak-oxxi-023-10-ml-en 387/448/450
9587 gel-lak-oxxi-051-10-ml-en 387/448/450
9589 gel-lak-oxxi-053-10-ml-en 387/448/450
9591 gel-lak-oxxi-054-10-ml-en 387/448/450
9599 gel-lak-oxxi-059-10-ml-en 387/448/450
9600 gel-lak-oxxi-062-10-ml-en 387/448/450
9604 gel-lak-oxxi-063-10-ml-en 387/448/450
9606 gel-lak-oxxi-064-10-ml-en 387/448/450
9607 gel-lak-oxxi-065-10-ml-en 387/448/450
9610 gel-lak-oxxi-069-10-ml-en 387/448/450
9611 gel-lak-oxxi-072-10-ml-en 387/448/450
9612 gel-lak-oxxi-039-10-ml-en 387/448/450
9616 gel-lak-oxxi-043-10-ml-en 387/448/450
9619 gel-lak-oxxi-071-10-ml-en 387/448/450
9621 gel-lak-oxxi-067-10-ml-en 387/448/450
9623 gel-lak-oxxi-080-10-ml-en 387/448/450
9625 gel-lak-oxxi-152-10-ml 387/448/450
9626 gel-lak-oxxi-116-10-ml-en 387/448/450
9627 gel-lak-oxxi-118-10-ml-en 387/448/450
9629 gel-lak-oxxi-120-10-ml-en 387/448/450
9630 gel-lak-oxxi-121-10-ml-en 387/448/450
9632 gel-lak-oxxi-123-10-ml-en 387/448/450
9633 gel-lak-oxxi-124-10-ml-en 387/448/450
9634 gel-lak-oxxi-117-10-ml-en 387/448/450
9635 gel-lak-oxxi-125-10-ml-en 387/448/450
9636 gel-lak-oxxi-127-10-ml-en 387/448/450
9638 gel-lak-oxxi-013-10-ml-en 387/448/450
9639 gel-lak-oxxi-130-10-ml-en 387/448/450
9640 gel-lak-oxxi-133-10-ml-en 387/448/450
9641 gel-lak-oxxi-140-10-ml-en 387/448/450
9642 gel-lak-oxxi-141-10-ml-en 387/448/450
9643 gel-lak-oxxi-015-10-ml-en 387/448/450
9645 gel-lak-oxxi-154-10-ml-en 387/448/450
9646 gel-lak-oxxi-155-10-ml-en 387/448/450
9647 gel-lak-oxxi-158-10-ml-en 387/448/450
9648 gel-lak-oxxi-160-10-ml-en 387/448/450
9649 gel-lak-oxxi-165-10-ml-en 387/448/450
9650 gel-lak-oxxi-166-10-ml-en 387/448/450
9651 gel-lak-oxxi-191-10-ml-en 387/448/450
9652 gel-lak-oxxi-199-10-ml-en 387/448/450
9653 gel-lak-oxxi-219-10-ml-en 387/448/450
9654 gel-lak-oxxi-221-10-ml-en 387/448/450
9655 gel-lak-oxxi-226-10-ml-en 387/448/450
9656 gel-lak-oxxi-235-10-ml-en 387/448/450
9657 gel-lak-oxxi-243-10-ml 387/448/450
9658 gel-lak-oxxi-244-10-ml 387/448/450
9660 gel-lak-oxxi-252-10-ml-en 387/448/450
9661 gel-lak-oxxi-256-10-ml-en 387/448/450
9662 gel-lak-oxxi-258-10-ml-en 387/448/450
9664 gel-lak-oxxi-073-10-ml-en 387/448/450
9665 gel-lak-oxxi-074-10-ml-en 387/448/450
9666 gel-lak-oxxi-093-10-ml 387/448/450
9668 gel-lak-oxxi-264-10-ml-en 387/448/450
9670 gel-lak-oxxi-230-10-ml-en 387/448/450
9671 gel-lak-oxxi-017-10-ml-en 387/448/450
9672 gel-lak-oxxi-011-10-ml-en 387/448/450
9673 gel-lak-oxxi-110-10-ml-en 387/448/450
9676 gel-lak-oxxi-241-10-ml 387/448/450
9677 gel-lak-oxxi-159-10-ml-en 387/448/450
9678 gel-lak-oxxi-025-10-ml-en 387/448/450
9680 gel-lak-oxxi-028-10-ml 387/448/450
9681 gel-lak-oxxi-030-10-ml 387/448/450
9682 gel-lak-oxxi-031-10-ml 387/448/450
9683 gel-lak-oxxi-033-10-ml-en 387/448/450
9685 gel-lak-oxxi-027-10-ml-en 387/448/450
9686 gel-lak-oxxi-035-10-ml 387/448/450
9730 gel-lak-oxxi-041-10-ml-en 387/448/450
9732 gel-lak-oxxi-047-10-ml-en 387/448/450
9733 gel-lak-oxxi-180-10-ml-en 387/448/450
9734 gel-lak-oxxi-228-10-ml-en 387/448/450
9735 gel-lak-oxxi-049-10-ml-en 387/448/450
9736 gel-lak-oxxi-045-10-ml-en 387/448/450
9737 gel-lak-oxxi-247-10-ml-en 387/448/450
9738 gel-lak-oxxi-261-10-ml-en 387/448/450
9740 gel-lak-oxxi-005-10-ml-en 387/448/450
9741 gel-lak-oxxi-205-10-ml 387/448/450
9743 gel-lak-oxxi-251-10-ml-en 387/448/450
9744 gel-lak-oxxi-255-10-ml-en 387/448/450
9745 gel-lak-oxxi-188-10-ml 387/448/450
9746 gel-lak-oxxi-201-10-ml 387/448/450
9747 gel-lak-oxxi-157-10-ml-en 387/448/450
9748 gel-lak-oxxi-075-10-ml-en 387/448/450
9749 gel-lak-oxxi-077-10-ml 387/448/450
9750 gel-lak-oxxi-078-10-ml-en 387/448/450
9752 gel-lak-oxxi-090-10-ml-en 387/448/450
9753 gel-lak-oxxi-103-10-ml 387/448/450
9754 gel-lak-oxxi-105-10-ml 387/448/450
9756 gel-lak-oxxi-108-10-ml 387/448/450
9757 gel-lak-oxxi-115-10-ml-en 387/448/450
9758 gel-lak-oxxi-038-10-ml 387/448/450
9920 gel-lak-oxxi-172-10-ml-en 387/448/450
9921 gel-lak-oxxi-171-10-ml-en 387/448/450
9922 gel-lak-oxxi-182-10-ml-en 387/448/450
9923 gel-lak-oxxi-183-10-ml-en 387/448/450
9924 gel-lak-oxxi-187-10-ml-en 387/448/450
9925 gel-lak-oxxi-185-10-ml-en 387/448/450
9926 gel-lak-oxxi-222-10-ml-en 387/448/450
9927 gel-lak-oxxi-227-10-ml-en 387/448/450
9928 gel-lak-oxxi-233-10-ml-en 387/448/450
9930 gel-lak-oxxi-246-10-ml-en 387/448/450
9931 gel-lak-oxxi-253-10-ml-en 387/448/450
9932 gel-lak-oxxi-254-10-ml-en 387/448/450
9933 gel-lak-oxxi-257-10-ml-en 387/448/450
9934 gel-lak-oxxi-262-10-ml-en 387/448/450
9935 gel-lak-oxxi-260-10-ml-en 387/448/450
9937 gel-lak-oxxi-003-10-ml-en 387/448/450
9939 gel-lak-oxxi-086-10-ml-en 387/448/450
9940 gel-lak-oxxi-094-10-ml-en 387/448/450
9942 gel-lak-oxxi-234-10-ml-en 387/448/450
9943 gel-lak-oxxi-236-10-ml-en 387/448/450
9944 gel-lak-oxxi-104-10-ml-en 387/448/450
9945 gel-lak-oxxi-134-10-ml-en 387/448/450
9947 gel-lak-oxxi-066-10-ml-en 387/448/450
9949 gel-lak-oxxi-102-10-ml-en 387/448/450
9950 gel-lak-oxxi-135-10-ml-en 387/448/450
9951 gel-lak-oxxi-088-10-ml-en 387/448/450
9952 gel-lak-oxxi-095-10-ml-en 387/448/450
9953 gel-lak-oxxi-164-10-ml-en 387/448/450
9954 gel-lak-oxxi-029-10-ml-en 387/448/450
9955 gel-lak-oxxi-032-10-ml-en 387/448/450
9956 gel-lak-oxxi-036-10-ml-en 387/448/450
9957 gel-lak-oxxi-112-10-ml-en 387/448/450
9958 gel-lak-oxxi-085-10-ml-en 387/448/450
9959 gel-lak-oxxi-096-10-ml-en 387/448/450
9960 gel-lak-oxxi-092-10-ml-en 387/448/450
9961 gel-lak-oxxi-111-10-ml-en 387/448/450
9962 gel-lak-oxxi-034-10-ml-en 387/448/450
10030 gel-lak-oxxi-263-10-ml-en 387/448/450
10202 gel-lak-oxxi-276-10-ml-en 387/448/450