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 (
    4, 
    6, 
    7, 
    8, 
    9, 
    10, 
    12, 
    13, 
    14, 
    15, 
    16, 
    19, 
    20, 
    23, 
    32, 
    33, 
    34, 
    35, 
    36, 
    42, 
    52, 
    54, 
    59, 
    60, 
    61, 
    62, 
    63, 
    84, 
    85, 
    86, 
    89, 
    93, 
    94, 
    95, 
    107, 
    108, 
    109, 
    110, 
    111, 
    113, 
    114, 
    118, 
    119, 
    120, 
    121, 
    123, 
    127, 
    128, 
    130, 
    131, 
    134, 
    136, 
    141, 
    142, 
    144, 
    145, 
    146, 
    147, 
    50984, 
    50985, 
    50986, 
    50988, 
    50992, 
    50993, 
    51106, 
    51107, 
    51108, 
    51109, 
    51110, 
    51111, 
    51112, 
    51113, 
    51114, 
    51115, 
    51116, 
    51117, 
    51118, 
    51161, 
    51162, 
    51163, 
    51164, 
    51165, 
    51177, 
    51178, 
    51179, 
    51180, 
    51182, 
    51183, 
    51184, 
    51185, 
    51186, 
    51187, 
    51188, 
    51189, 
    51190, 
    51191, 
    51192, 
    51193, 
    51194, 
    51195, 
    51196, 
    51197, 
    51198, 
    51199, 
    51200, 
    51201, 
    51212, 
    51213, 
    51214, 
    51215, 
    51216, 
    51217, 
    51218, 
    51219, 
    51220, 
    51225, 
    51226, 
    51227, 
    51228, 
    51229, 
    51230, 
    51231, 
    51232, 
    51233, 
    51234, 
    51235, 
    51236, 
    51237, 
    51238, 
    51239, 
    51240, 
    51241, 
    51242, 
    51243, 
    51244, 
    51245, 
    51246, 
    51247, 
    51248, 
    51249, 
    51250, 
    51251, 
    51252, 
    51253, 
    51254, 
    51255, 
    51256, 
    51259, 
    51260, 
    51261, 
    51262, 
    51263, 
    51264, 
    51265, 
    51266, 
    51267, 
    51268, 
    51269, 
    51270, 
    51271, 
    51272, 
    51273, 
    51274, 
    51275, 
    51276, 
    51277, 
    51278, 
    51279, 
    51280, 
    51281, 
    51282, 
    51283, 
    51284, 
    51285, 
    51286, 
    51287, 
    51288, 
    51289, 
    51290, 
    51291, 
    51293, 
    51294, 
    51310, 
    51311, 
    51312, 
    51313, 
    51314, 
    51325, 
    51327, 
    51328, 
    51329, 
    51330, 
    51331, 
    51332, 
    51336, 
    51337, 
    51338, 
    51339, 
    51344, 
    51345, 
    51346, 
    51347, 
    51348, 
    51350, 
    51374, 
    51375, 
    51376, 
    51377, 
    51378, 
    51379, 
    51380, 
    51381, 
    51382, 
    51390, 
    51391, 
    51392, 
    51393, 
    51394, 
    51444, 
    51445, 
    51446, 
    51447, 
    51448, 
    51449, 
    51450, 
    51451
  ) 
  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.00737

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "161.61"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "rows_examined_per_scan": 1557,
      "rows_produced_per_join": 451,
      "filtered": "29.03",
      "cost_info": {
        "read_cost": "116.41",
        "eval_cost": "45.20",
        "prefix_cost": "161.61",
        "data_read_per_join": "766K"
      },
      "used_columns": [
        "name",
        "object_id",
        "company_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`test_uchur_k`.`cscart_seo_names`.`object_id` in (4,6,7,8,9,10,12,13,14,15,16,19,20,23,32,33,34,35,36,42,52,54,59,60,61,62,63,84,85,86,89,93,94,95,107,108,109,110,111,113,114,118,119,120,121,123,127,128,130,131,134,136,141,142,144,145,146,147,50984,50985,50986,50988,50992,50993,51106,51107,51108,51109,51110,51111,51112,51113,51114,51115,51116,51117,51118,51161,51162,51163,51164,51165,51177,51178,51179,51180,51182,51183,51184,51185,51186,51187,51188,51189,51190,51191,51192,51193,51194,51195,51196,51197,51198,51199,51200,51201,51212,51213,51214,51215,51216,51217,51218,51219,51220,51225,51226,51227,51228,51229,51230,51231,51232,51233,51234,51235,51236,51237,51238,51239,51240,51241,51242,51243,51244,51245,51246,51247,51248,51249,51250,51251,51252,51253,51254,51255,51256,51259,51260,51261,51262,51263,51264,51265,51266,51267,51268,51269,51270,51271,51272,51273,51274,51275,51276,51277,51278,51279,51280,51281,51282,51283,51284,51285,51286,51287,51288,51289,51290,51291,51293,51294,51310,51311,51312,51313,51314,51325,51327,51328,51329,51330,51331,51332,51336,51337,51338,51339,51344,51345,51346,51347,51348,51350,51374,51375,51376,51377,51378,51379,51380,51381,51382,51390,51391,51392,51393,51394,51444,51445,51446,51447,51448,51449,51450,51451)) and (`test_uchur_k`.`cscart_seo_names`.`type` = 'p') and (`test_uchur_k`.`cscart_seo_names`.`dispatch` = '') and (`test_uchur_k`.`cscart_seo_names`.`lang_code` = 'ru') and ((`test_uchur_k`.`cscart_seo_names`.`company_id` = 1) or (`test_uchur_k`.`cscart_seo_names`.`company_id` = 0)))"
    }
  }
}

Result

product_id seo_name seo_path
4 kepka-uchur-round-patch-cv-chernyy-s-setkoy 40
6 kepka-uchur-round-patch-cv-bezhevyy-s-setkoy 40
7 futbolka-uchur-covert-gray-t-shirt 40
9 kepka-uchur-active-cv-navy 40
10 kepka-uchur-active-cv-beige 40
12 futbolka-uchur-mountain-sheep-olive-t-shirt 40
13 kepka-uchur-logo-cv-olive 40
14 kepka-uchur-logo-cv-black-camouflage 40
15 kepka-uchur-mid-cap-cv-taas 40
16 kepka-uchur-mid-cap-cv-saas 40
19 shtany-uchur-all-weather-pants-lite-cv-saas 40
20 shtany-uchur-all-weather-pants-lite-cv-taas 40
23 kepka-uchur-logo-mesh-cap-cv-olive 40
32 futbolka-uchur-mens-t-shirt-cv-black 40
33 futbolka-uchur-mens-t-shirt-cv-grey 40
34 futbolka-uchur-mens-t-shirt-cv-olive 40
35 futbolka-uchur-mens-t-shirt-cv-saas 40
36 futbolka-uchur-mens-t-shirt-cv-taas 40
42 termobele-bulchut-komplekt-trikotazhnyy-cv-chernyy-tk-fleece-270g-m2-m 5/18
52 shtany-uchur-forester-cv-black-gray 40
54 tolstovka-uchur-hoodie-wind-cv-saas 40
59 kepka-uchur-embossed-logo-cv-black 40
60 kepka-uchur-embossed-logo-cv-grey 40
61 kepka-uchur-raptor-camo-mesh-cv-black 40
62 kepka-uchur-everyday-mesh-cv-black 40
63 shapka-bulchut-dvuhstoronnyaya-tk-polar-fleece-cv-haki-oranzhevyy 5/50/8
84 noski-uchur-active-city-cv-chernyy 40
85 noski-uchur-active-cv-chernyy-seryy 40
86 perchatki-uchur-hunter-lt-cv-taas 40
89 zhilet-uchur-weave-core-cv-seryy 40
93 shtany-uchur-all-weather-pants-lite-cv-chernyy 40
95 snud-uchur-cv-taas 40
107 panama-letnyaya-uchur-adventure-hat-cv-seryy 40
108 panama-letnyaya-uchur-adventure-hat-cv-chernyy 40
109 futbolka-uchur-raven-beige-t-shirt 40
110 futbolka-uchur-eagle-gray-t-shirt 40
111 futbolka-zhenskaya-uchur-tuymaada-black-t-shirt 40
113 kepka-uchur-shadow-cv-black-camouflage 40
114 kepka-uchur-rove-logo-cv-olive 40
118 kepka-uchur-rubber-patch-cv-bezhevyy-s-setkoy 40
119 kepka-uchur-rubber-patch-cv-chernyy-bez-setki 40
120 kepka-uchur-rubber-patch-cv-chernyy-s-setkoy 40
121 kepka-uchur-round-patch-logo-grey-cv-chernyy-s-setkoy 40
123 kepka-uchur-ranger-mesh-cap-cv-oliva 40
127 k-m-antignus-bulchut-tk-smesovaya-tvil-pich-cv-haki 5/22/34
128 kurtka-letnyaya-uchur-all-weather-lite-cv-taas 40
130 kurtka-letnyaya-uchur-tukulan-cv-bezhevyy 40
131 bryuki-letnie-uchur-tukulan-cv-bezhevyy 40
134 anorak-kamleyka-bulchut-tk-palatka-cv-haki-r-universalnyy 45
136 rukavicy-bulchut-tk-finlyandiya-cv-haki-m 5/52/37
141 kepka-uchur-hex-s-patchem-cv-chernyy 40
142 kepka-uchur-alpha-cv-chernyy 40
144 futbolka-uchur-wolf-black-t-shirt 40
145 futbolka-uchur-eagle-black-t-shirt 40
146 futbolka-uchur-trophy-fishing-blue-t-shirt 40
147 futbolka-uchur-covert-green-t-shirt 40
94 longsliv-uchur-active-cv-taas-ru-2 40
8 futbolka-uchur-bear-black-t-shirt-3xl 40
51293 longsliv-uchur-active-cv-taas-ru-4 40
51294 longsliv-uchur-active-cv-taas-ru-5 40
51290 longsliv-uchur-active-cv-taas 40
51291 longsliv-uchur-active-cv-taas-ru 40
51289 futbolka-uchur-bear-black-t-shirt-ru-6 40
51288 futbolka-uchur-bear-black-t-shirt-ru-5 40
51287 futbolka-uchur-bear-black-t-shirt-ru-4 40
51286 futbolka-uchur-bear-black-t-shirt-ru-3 40
51285 futbolka-uchur-bear-black-t-shirt-ru-2 40
51284 futbolka-uchur-bear-black-t-shirt-ru 40
51283 futbolka-uchur-bear-black-t-shirt 40
51282 futbolka-uchur-covert-gray-t-shirt-ru-5 40
51281 futbolka-uchur-covert-gray-t-shirt-ru-4 40
51280 futbolka-uchur-covert-gray-t-shirt-ru-3 40
51279 futbolka-uchur-covert-gray-t-shirt-ru-2 40
51278 futbolka-uchur-covert-gray-t-shirt-ru 40
51276 futbolka-uchur-covert-green-t-shirt-ru-4 40
51275 futbolka-uchur-covert-green-t-shirt-ru-3 40
51274 futbolka-uchur-covert-green-t-shirt-ru-2 40
51273 futbolka-uchur-covert-green-t-shirt-ru 40
51272 futbolka-uchur-eagle-black-t-shirt-ru-7 40
51270 futbolka-uchur-eagle-black-t-shirt-ru-5 40
51271 futbolka-uchur-eagle-black-t-shirt-ru-6 40
51269 futbolka-uchur-eagle-black-t-shirt-ru-4 40
51268 futbolka-uchur-eagle-black-t-shirt-ru-3 40
51266 futbolka-uchur-eagle-black-t-shirt-ru 40
51267 futbolka-uchur-eagle-black-t-shirt-ru-2 40
51265 futbolka-uchur-eagle-gray-t-shirt-ru-7 40
51263 futbolka-uchur-eagle-gray-t-shirt-ru-5 40
51264 futbolka-uchur-eagle-gray-t-shirt-ru-6 40
51261 futbolka-uchur-eagle-gray-t-shirt-ru-3 40
51262 futbolka-uchur-eagle-gray-t-shirt-ru-4 40
51260 futbolka-uchur-eagle-gray-t-shirt-ru-2 40
51259 futbolka-uchur-eagle-gray-t-shirt-ru 40
51256 futbolka-uchur-mens-t-shirt-cv-grey-ru-3 40
51254 futbolka-uchur-mens-t-shirt-cv-grey-ru 40
51255 futbolka-uchur-mens-t-shirt-cv-grey-ru-2 40
51252 futbolka-uchur-mens-t-shirt-cv-olive-ru-4 40
51253 futbolka-uchur-mens-t-shirt-cv-olive-ru-5 40
51251 futbolka-uchur-mens-t-shirt-cv-olive-ru-3 40
51250 futbolka-uchur-mens-t-shirt-cv-olive-ru-2 40
51249 futbolka-uchur-mens-t-shirt-cv-olive-ru 40
51247 futbolka-uchur-mens-t-shirt-cv-saas-ru-4 40
51248 futbolka-uchur-mens-t-shirt-cv-saas-ru-5 40
51245 futbolka-uchur-mens-t-shirt-cv-saas-ru-2 40
51246 futbolka-uchur-mens-t-shirt-cv-saas-ru-3 40
51244 futbolka-uchur-mens-t-shirt-cv-saas-ru 40
51243 futbolka-uchur-mens-t-shirt-cv-taas-ru-5 40
51242 futbolka-uchur-mens-t-shirt-cv-taas-ru-4 40
51241 futbolka-uchur-mens-t-shirt-cv-taas-ru-3 40
51240 futbolka-uchur-mens-t-shirt-cv-taas-ru-2 40
51239 futbolka-uchur-mens-t-shirt-cv-taas-ru 40
51238 futbolka-uchur-mountain-sheep-olive-t-shirt-ru-7 40
51237 futbolka-uchur-mountain-sheep-olive-t-shirt-ru-6 40
51236 futbolka-uchur-mountain-sheep-olive-t-shirt-ru-5 40
51235 futbolka-uchur-mountain-sheep-olive-t-shirt-ru-4 40
51234 futbolka-uchur-mountain-sheep-olive-t-shirt-ru-3 40
51233 futbolka-uchur-mountain-sheep-olive-t-shirt-ru-2 40
51232 futbolka-uchur-mountain-sheep-olive-t-shirt-ru 40
51231 futbolka-uchur-raven-beige-t-shirt-ru-7 40
51230 futbolka-uchur-raven-beige-t-shirt-ru-6 40
51227 futbolka-uchur-raven-beige-t-shirt-ru-3 40
51228 futbolka-uchur-raven-beige-t-shirt-ru-4 40
51229 futbolka-uchur-raven-beige-t-shirt-ru-5 40
51226 futbolka-uchur-raven-beige-t-shirt-ru-2 40
51225 futbolka-uchur-raven-beige-t-shirt-ru 40
51220 futbolka-uchur-trophy-fishing-blue-t-shirt-ru-5 40
51219 futbolka-uchur-trophy-fishing-blue-t-shirt-ru-4 40
51218 futbolka-uchur-trophy-fishing-blue-t-shirt-ru-3 40
51217 futbolka-uchur-trophy-fishing-blue-t-shirt-ru-2 40
51215 futbolka-uchur-wolf-black-t-shirt-ru-3 40
51216 futbolka-uchur-trophy-fishing-blue-t-shirt-ru 40
51213 futbolka-uchur-wolf-black-t-shirt-ru 40
51214 futbolka-uchur-wolf-black-t-shirt-ru-2 40
51212 futbolka-zhenskaya-uchur-tuymaada-black-t-shirt-ru-3 40
51201 bryuki-letnie-uchur-tukulan-cv-bezhevyy-ru-7 40
51200 bryuki-letnie-uchur-tukulan-cv-bezhevyy-ru-6 40
51199 bryuki-letnie-uchur-tukulan-cv-bezhevyy-ru-5 40
51198 bryuki-letnie-uchur-tukulan-cv-bezhevyy-ru-4 40
51192 shtany-uchur-all-weather-pants-lite-cv-saas-ru-4 40
51193 shtany-uchur-all-weather-pants-lite-cv-saas-ru-5 40
51194 shtany-uchur-all-weather-pants-lite-cv-saas-ru-6 40
51195 bryuki-letnie-uchur-tukulan-cv-bezhevyy-ru 40
51196 bryuki-letnie-uchur-tukulan-cv-bezhevyy-ru-2 40
51197 bryuki-letnie-uchur-tukulan-cv-bezhevyy-ru-3 40
51191 shtany-uchur-all-weather-pants-lite-cv-saas-ru-3 40
51188 shtany-uchur-all-weather-pants-lite-cv-taas-ru-6 40
51189 shtany-uchur-all-weather-pants-lite-cv-saas-ru 40
51190 shtany-uchur-all-weather-pants-lite-cv-saas-ru-2 40
51186 shtany-uchur-all-weather-pants-lite-cv-taas-ru-4 40
51187 shtany-uchur-all-weather-pants-lite-cv-taas-ru-5 40
51184 shtany-uchur-all-weather-pants-lite-cv-taas-ru-2 40
51185 shtany-uchur-all-weather-pants-lite-cv-taas-ru-3 40
51183 shtany-uchur-all-weather-pants-lite-cv-taas-ru 40
51182 shtany-uchur-all-weather-pants-lite-cv-chernyy-ru-6 40
51179 shtany-uchur-all-weather-pants-lite-cv-chernyy-ru-3 40
51180 shtany-uchur-all-weather-pants-lite-cv-chernyy-ru-4 40
51178 shtany-uchur-all-weather-pants-lite-cv-chernyy-ru-2 40
51177 shtany-uchur-all-weather-pants-lite-cv-chernyy-ru 40
51161 shtany-uchur-forester-cv-black-gray-ru 40
51162 shtany-uchur-forester-cv-black-gray-ru-2 40
51163 shtany-uchur-forester-cv-black-gray-ru-3 40
51164 shtany-uchur-forester-cv-black-gray-ru-4 40
51165 shtany-uchur-forester-cv-black-gray-ru-5 40
51106 kurtka-letnyaya-uchur-tukulan-cv-bezhevyy-ru 40
51107 kurtka-letnyaya-uchur-tukulan-cv-bezhevyy-ru-2 40
51108 kurtka-letnyaya-uchur-tukulan-cv-bezhevyy-ru-3 40
51109 kurtka-letnyaya-uchur-tukulan-cv-bezhevyy-ru-4 40
51110 kurtka-letnyaya-uchur-tukulan-cv-bezhevyy-ru-5 40
51111 kurtka-letnyaya-uchur-tukulan-cv-bezhevyy-ru-6 40
51112 kurtka-letnyaya-uchur-tukulan-cv-bezhevyy-ru-7 40
51113 kurtka-letnyaya-uchur-all-weather-lite-cv-taas-ru 40
51114 kurtka-letnyaya-uchur-all-weather-lite-cv-taas-ru-2 40
51115 kurtka-letnyaya-uchur-all-weather-lite-cv-taas-ru-3 40
51116 kurtka-letnyaya-uchur-all-weather-lite-cv-taas-ru-4 40
51117 kurtka-letnyaya-uchur-all-weather-lite-cv-taas-ru-5 40
51118 kurtka-letnyaya-uchur-all-weather-lite-cv-taas-ru-6 40
51444 futbolka-uchur-wolf-black-t-shirt-ru-4 40
51445 futbolka-uchur-wolf-black-t-shirt-ru-5 40
51446 futbolka-uchur-wolf-black-t-shirt-ru-6 40
51447 futbolka-uchur-wolf-black-t-shirt-ru-7 40
51448 futbolka-uchur-trophy-fishing-blue-t-shirt-ru-6 40
51449 futbolka-uchur-trophy-fishing-blue-t-shirt-ru-7 40
51450 kurtka-flisovaya-bulchut-tk-polar-fleece-nylon-taslan-dobby-cv-haki-ru 5/10
51451 kurtka-flisovaya-bulchut-tk-polar-fleece-nylon-taslan-dobby-cv-haki-ru-2 5/10
51310 tolstovka-uchur-hoodie-wind-cv-saas-ru 40
51311 tolstovka-uchur-hoodie-wind-cv-saas-ru-2 40
51312 tolstovka-uchur-hoodie-wind-cv-saas-ru-3 40
51313 tolstovka-uchur-hoodie-wind-cv-saas-ru-4 40
51314 tolstovka-uchur-hoodie-wind-cv-saas-ru-5 40
51325 k-m-antignus-bulchut-tk-smesovaya-tvil-pich-cv-haki-ru 5/22/34
51327 kurtka-muzhskaya-rx24-365d-cv-siniy-ru 1
51328 kurtka-muzhskaya-rx24-365d-cv-siniy-ru-2 1
51329 kurtka-muzhskaya-rx24-365d-cv-siniy-ru-3 1
51330 kurtka-muzhskaya-rx24-338d-cv-chernyy-ru 1
51331 kurtka-muzhskaya-rx24-338d-cv-chernyy-ru-2 1
51332 kurtka-muzhskaya-rx24-338d-cv-chernyy-ru-3 1
51336 kurtka-muzhskaya-rx24-359d-cv-seryy-ru 1
51337 kurtka-muzhskaya-rx24-359d-cv-seryy-ru-2 1
51338 kurtka-muzhskaya-rx24-359d-cv-seryy-ru-3 1
51339 kurtka-muzhskaya-rx24-359d-cv-seryy-ru-4 1
51344 kepka-uchur-rubber-patch-cv-chernyy-s-setkoy-ru 40
51345 kepka-uchur-rubber-patch-cv-chernyy-bez-setki-ru 40
51346 kepka-uchur-rubber-patch-cv-bezhevyy-s-setkoy-ru 40
51347 noski-uchur-active-cv-chernyy-seryy-ru 40
51348 kepka-uchur-round-patch-logo-grey-cv-chernyy-s-setkoy-ru 40
51350 kepka-uchur-ranger-mesh-cap-cv-oliva-ru 40
51374 zhilet-muzhskoy-ul-down-vest-rx24-354d-cv-seryy-ru 1
51375 zhilet-muzhskoy-ul-down-vest-rx24-354d-cv-seryy-ru-2 1
51376 termobele-bulchut-komplekt-trikotazhnyy-cv-chernyy-tk-fleece-270g-m2-m-ru 5/18
51377 termobele-bulchut-komplekt-trikotazhnyy-cv-chernyy-tk-fleece-270g-m2-m-ru-2 5/18
51378 termobele-bulchut-komplekt-trikotazhnyy-cv-chernyy-tk-fleece-270g-m2-m-ru-3 5/18
51379 termobele-bulchut-komplekt-trikotazhnyy-cv-chernyy-tk-fleece-270g-m2-m-ru-4 5/18
51380 termobele-bulchut-komplekt-trikotazhnyy-cv-chernyy-tk-fleece-270g-m2-m-ru-5 5/18
51381 zhilet-muzhskoy-rx24-366d-cv-siniy-ru 1
51382 zhilet-muzhskoy-rx24-366d-cv-siniy-ru-2 1
51390 zhilet-uchur-weave-core-cv-seryy-ru 40
51391 zhilet-uchur-weave-core-cv-seryy-ru-2 40
51392 zhilet-uchur-weave-core-cv-seryy-ru-3 40
51393 zhilet-uchur-weave-core-cv-seryy-ru-4 40
51394 zhilet-uchur-weave-core-cv-seryy-ru-5 40
50984 kurtka-flisovaya-bulchut-tk-polar-fleece-nylon-taslan-dobby-cv-haki 5/10
50985 kurtka-muzhskaya-rx24-365d-cv-siniy 5/10
50986 kurtka-muzhskaya-rx24-338d-cv-chernyy 5/10
50988 kurtka-muzhskaya-rx24-359d-cv-seryy 5/10
50992 zhilet-muzhskoy-ul-down-vest-rx24-354d-cv-seryy 5/25
50993 zhilet-muzhskoy-rx24-366d-cv-siniy 5/25
51277 futbolka-uchur-covert-green-t-shirt-ru-5 40