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 (
    969, 
    970, 
    636, 
    637, 
    972, 
    973, 
    974, 
    975, 
    941, 
    942, 
    943, 
    944, 
    945, 
    946, 
    948, 
    949, 
    953, 
    954, 
    955, 
    699, 
    700, 
    701, 
    702, 
    774, 
    775, 
    776, 
    777, 
    778, 
    779, 
    780, 
    781, 
    782, 
    783, 
    784, 
    785, 
    786, 
    787, 
    788, 
    789, 
    790, 
    791, 
    792, 
    793, 
    794, 
    795, 
    678, 
    679, 
    680, 
    564, 
    565, 
    566, 
    567, 
    568, 
    569, 
    570, 
    571, 
    572, 
    573, 
    574, 
    575, 
    576, 
    577, 
    578, 
    579, 
    580, 
    581, 
    582, 
    583, 
    584, 
    585, 
    586, 
    592, 
    593, 
    827, 
    828, 
    829, 
    830, 
    831, 
    832, 
    833, 
    834, 
    835, 
    837, 
    838, 
    839, 
    840, 
    841, 
    842, 
    843, 
    844, 
    845, 
    846, 
    847, 
    848, 
    849, 
    850, 
    851, 
    852, 
    853, 
    854, 
    855, 
    856, 
    857, 
    858, 
    859, 
    860, 
    861, 
    862, 
    863, 
    864, 
    865, 
    866, 
    867, 
    868, 
    869, 
    870, 
    871, 
    872, 
    873, 
    874, 
    875, 
    876, 
    877, 
    878, 
    811, 
    812, 
    815, 
    816, 
    817, 
    818, 
    1025, 
    1026, 
    1027
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'ru'

Query time 0.00199

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "250.24"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "rows_examined_per_scan": 1183,
      "rows_produced_per_join": 137,
      "filtered": "11.58",
      "cost_info": {
        "read_cost": "222.85",
        "eval_cost": "27.40",
        "prefix_cost": "250.25",
        "data_read_per_join": "232K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`cscart`.`cscart_seo_names`.`object_id` in (969,970,636,637,972,973,974,975,941,942,943,944,945,946,948,949,953,954,955,699,700,701,702,774,775,776,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,678,679,680,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,592,593,827,828,829,830,831,832,833,834,835,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,811,812,815,816,817,818,1025,1026,1027)) and (`cscart`.`cscart_seo_names`.`type` = 'p') and (`cscart`.`cscart_seo_names`.`dispatch` = '') and (`cscart`.`cscart_seo_names`.`lang_code` = 'ru'))"
    }
  }
}

Result

product_id seo_name seo_path
593 krovat-dzhelato-90x200-dub-vinchenca-beton-kashemir-ru 301/302
592 krovat-dzhelato-90x200-dub-vinchenca-beton-kashemir 301
581 myagkoe-kreslo-ulm-velutto-04-ru-3 403/300
578 myagkoe-kreslo-ulm-velutto-04 403/300
566 kreslo-aylend-california-102-ru 403/300
701 divan-uglovoy-denzel-formula-ru-2 298/404/405
832 krovat-s-yaschikami-kassiya 301/366/374
582 myagkoe-kreslo-ulm-velutto-04-ru-4 403/300
583 myagkoe-kreslo-holli-velutto-04 403/300
584 myagkoe-kreslo-holli-velutto-04-ru 403/300
585 myagkoe-kreslo-holli-velutto-04-ru-2 403/300
586 myagkoe-kreslo-holli-velutto-04-ru-3 403/300
579 myagkoe-kreslo-ulm-velutto-04-ru 403/300
580 myagkoe-kreslo-ulm-velutto-04-ru-2 403/300
570 myagkoe-kreslo-dublin-maxx-100-ru-2 403/300
565 kreslo-aylend-california-102 403/300
572 myagkoe-kreslo-dublin-maxx-100-ru-4 403/300
573 myagkoe-kreslo-transformser-tivoli-dub-shampan-maxx-100 403/300
568 myagkoe-kreslo-dublin-maxx-100 403/300
574 myagkoe-kreslo-transformser-tivoli-dub-shampan-maxx-100-ru 403/300
577 myagkoe-kreslo-transformser-tivoli-dub-shampan-maxx-100-ru-4 403/300
564 kreslo-aylend-belyy-california-102 403/300
576 myagkoe-kreslo-transformser-tivoli-dub-shampan-maxx-100-ru-3 403/300
575 myagkoe-kreslo-transformser-tivoli-dub-shampan-maxx-100-ru-2 403/300
571 myagkoe-kreslo-dublin-maxx-100-ru-3 403/300
569 myagkoe-kreslo-dublin-maxx-100-ru 403/300
567 kreslo-aylend-california-102-ru-2 403/300
941 polka-ikar 333/334/336
702 divan-uglovoy-denzel-formula-ru-3 298/404/405
636 komod-dzhelato-dub-vinchenca-beton-kashemir 309
637 komod-dzhelato-dub-vinchenca-beton-kashemir-ru 309/311
700 divan-uglovoy-denzel-formula-ru 298/404/405
699 divan-uglovoy-denzel-formula 298/404/405
678 mini-prihozhaya-ivet-dub-zolotistyy-ru 303/304
679 mini-prihozhaya-ivet-dub-zolotistyy 303
680 mini-prihozhaya-ivet-dub-zolotistyy-ru-2 303/304
774 divan-uglovoy-levyy-bergamo 298/404/405
775 divan-uglovoy-levyy-bergamo-ru 298/404/405
776 divan-uglovoy-levyy-bergamo-ru-2 298/404/405
777 divan-uglovoy-krosbi 298/404/405
778 divan-uglovoy-krosbi-ru 298/404/405
779 divan-uglovoy-krosbi-ru-2 298/404/405
780 divan-uglovoy-krosbi-ru-3 298/404/405
781 divan-uglovoy-pravyy-lesli 298/404/405
782 divan-uglovoy-pravyy-lesli-ru 298/404/405
783 divan-uglovoy-pravyy-lesli-ru-2 298/404/405
784 divan-uglovoy-pravyy-lesli-ru-3 298/404/405
785 divan-argos-ru 298/299/391
786 divan-argos 298/299/391
787 divan-argos-ru-2 298/299/391
788 divan-denzel-ru 298/299/391
789 divan-denzel 298/299/391
790 divan-denzel-ru-2 298/299/391
791 divan-denzel-ru-3 298/299/391
792 divan-lesli 298/299/391
793 divan-lesli-ru 298/299/391
794 divan-lesli-ru-2 298/299/391
795 divan-lesli-ru-3 298/299/391
811 pismennyy-stol-pravyy-kassiya 392/394/397
812 pismennyy-stol-pravyy-kassiya-ru 392/394/397
815 pismennyy-stol-kassiya 392/394/416
816 pismennyy-stol-kassiya-ru 392/394/416
817 pismennyy-stol-kassiya-ru-2 392/394/416
818 pismennyy-stol-kassiya-ru-3 392/394/416
827 krovat-s-podemnym-mehanizmom-brianna-ru 301/302/367
828 krovat-s-podemnym-mehanizmom-brianna 301/302/367
829 krovat-s-podemnym-mehanizmom-brianna-ru-2 301/302/367
830 krovat-s-podemnym-mehanizmom-brianna-ru-3 301/302/367
831 krovat-s-podemnym-mehanizmom-brianna-ru-4 301/302/367
833 krovat-s-yaschikami-kassiya-ru 301/366/374
834 krovat-dvuhyarusnaya-levaya-kassiya 301/372/373
835 krovat-dvuhyarusnaya-levaya-kassiya-ru 301/372/373
837 krovat-s-podemnym-mehanizmom-dakota-ru-2 301/302/368
838 krovat-s-podemnym-mehanizmom-dakota-ru 301/302/368
839 krovat-s-podemnym-mehanizmom-dakota 301/302/368
840 krovat-s-podemnym-mehanizmom-dakota-ru-3 301/302/368
841 krovat-s-podemnym-mehanizmom-dakota-ru-4 301/302/368
842 krovat-s-podemnym-mehanizmom-brianna 301/302/368
843 krovat-s-podemnym-mehanizmom-brianna-ru 301/302/368
844 krovat-s-podemnym-mehanizmom-brianna-ru-2 301/302/368
845 krovat-s-podemnym-mehanizmom-brianna-ru-3 301/302/368
846 krovat-s-podemnym-mehanizmom-brianna-ru-4 301/302/368
847 krovat-aleks-ru 301/302/368
848 krovat-aleks 301/302/368
849 krovat-aleks-ru-2 301/302/368
850 krovat-aleks-ru-3 301/302/368
851 krovat-aleks-ru-4 301/302/368
852 krovat-s-podemnym-mehanizmom-kassiya 301/302/369
853 krovat-s-podemnym-mehanizmom-kassiya-ru 301/302/369
854 krovat-s-podemnym-mehanizmom-brianna-ru-3 301/302/369
855 krovat-s-podemnym-mehanizmom-brianna-ru 301/302/369
856 krovat-s-podemnym-mehanizmom-brianna-ru-2 301/302/369
857 krovat-s-podemnym-mehanizmom-brianna 301/302/369
858 krovat-s-podemnym-mehanizmom-brianna-ru-4 301/302/369
859 krovat-s-podemnym-mehanizmom-muza 301/302/369
860 krovat-s-podemnym-mehanizmom-muza-ru 301/302/369
861 krovat-s-podemnym-mehanizmom-muza-ru-2 301/302/369
862 krovat-s-podemnym-mehanizmom-muza-ru-3 301/302/369
863 krovat-s-podemnym-mehanizmom-muza-ru-4 301/302/369
864 krovat-s-podemnym-mehanizmom-estrella 301/302/369
865 krovat-s-podemnym-mehanizmom-estrella-ru 301/302/369
866 krovat-s-podemnym-mehanizmom-estrella-ru-2 301/302/369
867 krovat-s-podemnym-mehanizmom-estrella-ru-3 301/302/369
868 krovat-s-podemnym-mehanizmom-dakota 301/302/369
869 krovat-s-podemnym-mehanizmom-dakota-ru 301/302/369
870 krovat-s-podemnym-mehanizmom-dakota-ru-2 301/302/369
871 krovat-s-podemnym-mehanizmom-dakota-ru-3 301/302/369
872 krovat-s-podemnym-mehanizmom-dakota-ru-4 301/302/369
873 krovat-s-podemnym-mehanizmom-lyuksor 301/302/370
874 krovat-s-podemnym-mehanizmom-lyuksor-ru 301/302/370
875 krovat-s-podemnym-mehanizmom-estrella-ru-4 301/302/369
876 krovat-s-podemnym-mehanizmom-estrella-ru 301/302/370
877 krovat-s-podemnym-mehanizmom-estrella-ru-2 301/302/370
878 krovat-s-podemnym-mehanizmom-estrella-ru-3 301/302/370
942 polka-ikar-ru 333/334/336
943 polka-ikar-ru-2 333/334/336
944 polka-ikar-ru-3 333/334/336
945 polka-kassiya 333/334/336
946 polka-kassiya-ru 333/334/336
948 polka-ilia 333/334/337
949 polka-ilia-ru 333/334/337
953 polka-kassiya 333/334/339
954 polka-kassiya-ru 333/334/339
955 polka-kassiya-ru-2 333/334/339
969 komod-kassiya 309/310/349
970 komod-kassiya-ru 309/310/349
972 komod-lyuksor 309/310/350
973 komod-lyuksor-ru 309/310/350
974 komod-lyuksor-ru-2 309/310/350
975 komod-lyuksor-ru-3 309/310/350
1025 zerkalo-kassiya 399/400/401
1026 zerkalo-kassiya-ru 399/400/401
1027 zerkalo-kassiya-ru-2 399/400/401