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 (
    92556, 92557, 86235, 86238, 86229, 89593, 
    89594, 91938, 86231, 91937, 91939, 
    91940, 91941, 91942, 91943, 86856, 
    86228, 86223, 89004, 91961, 91962, 
    91963, 91964, 91965, 91966, 91967, 
    86227, 82403, 82410, 82424, 89591, 
    89592, 86226, 86237, 86230, 91993, 
    91994, 91995, 91996, 91997, 91998, 
    91999, 82362, 91960, 82360, 91953, 
    91954, 91955, 91956, 91957, 91958, 
    91959, 84290, 82404, 82342, 82367, 
    86236, 86222, 82338, 82337, 82406, 
    82412, 82426, 86224, 91978, 91981, 
    82563, 82567, 82571, 82333, 86225, 
    91977, 91979, 91980, 91982, 91983, 
    82556, 85583, 89595, 89596, 89597, 
    82335, 82336, 82401, 82409, 82419, 
    82405, 82411, 82425, 91992, 91936, 
    91970, 91973, 86234, 82374, 91985
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00259

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "43.23"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code"
      ],
      "key_length": "206",
      "rows_examined_per_scan": 96,
      "rows_produced_per_join": 96,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "33.63",
        "eval_cost": "9.60",
        "prefix_cost": "43.23",
        "data_read_per_join": "162K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (92556,92557,86235,86238,86229,89593,89594,91938,86231,91937,91939,91940,91941,91942,91943,86856,86228,86223,89004,91961,91962,91963,91964,91965,91966,91967,86227,82403,82410,82424,89591,89592,86226,86237,86230,91993,91994,91995,91996,91997,91998,91999,82362,91960,82360,91953,91954,91955,91956,91957,91958,91959,84290,82404,82342,82367,86236,86222,82338,82337,82406,82412,82426,86224,91978,91981,82563,82567,82571,82333,86225,91977,91979,91980,91982,91983,82556,85583,89595,89596,89597,82335,82336,82401,82409,82419,82405,82411,82425,91992,91936,91970,91973,86234,82374,91985)) and (`nuie_scalesta_net`.`cscart_seo_names`.`type` = 'p') and (`nuie_scalesta_net`.`cscart_seo_names`.`dispatch` = '') and (`nuie_scalesta_net`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
82333 fixed-shower-heads-fixed-head 7148/7149/7150
82335 shower-heads-fixed-head 7148/7149/7150
82336 shower-kits-slide-rail-kit 7148/7149/7151
82337 slimline-slide-rail-kit 7148/7149/7151
82338 slide-rail-kits-linear-slide-rail-kits 7148/7149/7151
82342 slide-rail-kits-water-saving-slide-rail-kit 7148/7149/7151
82360 slide-rail-kits-sheer-slide-rail-kit 7148/7149/7151
82362 slide-rail-kits-kubix-slide-rail-kit 7148/7149/7151
82367 shower-kits-slider-rail-kit 7148/7149/7151
82374 outlet-elbow-parking-bracket-flex-and-handset-en 7148/7149/7152
82401 fixed-shower-heads-fixed-head-en 7148/7149/7150
82403 shower-kits-slide-rail-kit-en 7148/7149/7151
82404 slide-rail-kits-slider-rail-kit 7148/7149/7151
82405 shower-accessories-outlet-elbow-parking-bracket-flex-and-handset 7148/7149/7152
82406 shower-accessories-outlet-elbow-parking-bracket-flex-and-handset-en 7148/7149/7152
82409 fixed-shower-heads-square-fixed-head-200mm 7143/7300/7302
82410 shower-kits-square-slider-rail-kit-with-elbow 7143/7300/7301
82411 shower-accessories-round-outlet-elbow-c-wall-parking-bracket-and-kit 7143/7300/7304
82412 shower-accessories-square-outlet-elbow-c-wall-parking-bracket-and-kit 7143/7300/7304
82419 fixed-shower-heads-fixed-head-en-en 7148/7149/7150
82424 shower-kits-slide-rail-kit-en-en 7148/7149/7151
82425 shower-accessories-outlet-elbow-parking-bracket-flex-and-handset-brushed-brass 7148/7149/7152
82426 shower-accessories-outlet-elbow-parking-bracket-flex-and-handset-brushed-brass-en 7148/7149/7152
82556 fixed-shower-heads-wall-mounted-arm-en 7148/7149/7161
82563 fixed-shower-heads-wall-mounted-arm-en-en-en-en 7148/7149/7161
82567 fixed-shower-heads-small-rectangular-shower-arm 7143/7300/7303
82571 fixed-shower-heads-wall-mounted-arm-en-en-en-en-en-en 7148/7149/7161
84290 shower-accessories-douche-spray-kit-and-thermostatic-valve 7148/7149/7152
85583 wastes-and-extras-deck-shower-kit 7184/7221
86222 shower-heads-fixed-head-en 7148/7149/7150
86223 shower-heads-fixed-head-en-en 7148/7149/7150
86224 shower-heads-fixed-head-en-en-en 7148/7149/7150
86225 fixed-head-en-en 7148/7149/7150
86226 fixed-shower-heads-fixed-head-en-en-en 7148/7149/7150
86227 fixed-shower-heads-ceiling-mounted-head-and-arm 7148/7149/7227
86228 fixed-shower-heads-fixed-head-en-en-en-en 7148/7149/7150
86229 fixed-shower-heads-ceiling-mounted-head-and-arm-en 7148/7149/7227
86230 fixed-shower-heads-fixed-head-en-en-en-en-en 7148/7149/7150
86231 fixed-shower-heads-fixed-head-en-en-en-en-en-en 7148/7149/7150
86234 fixed-head-en-en-en 7148/7149/7150
86235 fixed-shower-heads-ceiling-mounted-fixed-head 7148/7149/7227
86236 fixed-shower-heads-ceiling-tile-fixed-head 7148/7149/7227
86237 fixed-shower-heads-ceiling-tile-fixed-head-en 7148/7149/7227
86238 fixed-shower-heads-ceiling-tile-fixed-head-en-en 7148/7149/7227
86856 shower-accessories-shower-seat 7148/7149/7152
89004 astra-bath-filler 7184/7186
89591 shower-heads-round-led-fixed-head 7148/7149/7150
89592 shower-heads-square-led-fixed-head 7148/7149/7150
89593 shower-heads-round-led-fixed-head-en 7148/7149/7150
89594 shower-heads-square-led-fixed-head-en 7148/7149/7150
89595 shower-kits-slide-rail-kit-en-en-en-en-en-en-en 7148/7149/7151
89596 shower-kits-round-slider-rail-kit-with-elbow 7143/7300/7301
89597 shower-kits-slide-rail-kit-en-en-en-en-en-en-en-en 7148/7149/7151
91936 victrion-traditional-slide-rail-kit-and-handset 7143
91937 victrion-traditional-slide-rail-kit-and-handset-en 7143
91938 victrion-traditional-slide-rail-kit-and-handset-en-en 7143
91939 victrion-traditional-slide-rail-kit-and-handset-en-en-en 7143
91940 victrion-traditional-slide-rail-kit-and-handset-en-en-en-en 7143
91941 victrion-traditional-slide-rail-kit-and-handset-en-en-en-en-en 7143
91942 victrion-traditional-slide-rail-kit-and-handset-en-en-en-en-en-en 7143
91943 victrion-traditional-slide-rail-kit-and-handset-en-en-en-en-en-en-en 7143
91953 victrion-8-fixed-shower-head-en 7143
91954 victrion-8-fixed-shower-head-en-en 7143
91955 victrion-8-fixed-shower-head-en-en-en 7143
91956 victrion-8-fixed-shower-head-en-en-en-en 7143
91957 victrion-8-fixed-shower-head-en-en-en-en-en 7143
91958 victrion-8-fixed-shower-head-en-en-en-en-en-en 7143
91959 victrion-8-fixed-shower-head-en-en-en-en-en-en-en 7143
91960 victrion-12-fixed-shower-head 7143
91961 victrion-12-fixed-shower-head-en 7143
91962 victrion-12-fixed-shower-head-en-en 7143
91963 victrion-12-fixed-shower-head-en-en-en 7143
91964 victrion-12-fixed-shower-head-en-en-en-en 7143
91965 victrion-12-fixed-shower-head-en-en-en-en-en 7143
91966 victrion-12-fixed-shower-head-en-en-en-en-en-en 7143
91967 victrion-12-fixed-shower-head-en-en-en-en-en-en-en 7143
91970 victrion-ceiling-mounted-shower-arm-en-en 7143
91973 victrion-ceiling-mounted-shower-arm-en-en-en-en-en 7143
91977 victrion-arch-wall-mounted-shower-arm-en 7143
91978 victrion-arch-wall-mounted-shower-arm-en-en 7143
91979 victrion-arch-wall-mounted-shower-arm-en-en-en 7143
91980 victrion-arch-wall-mounted-shower-arm-en-en-en-en 7143
91981 victrion-arch-wall-mounted-shower-arm-en-en-en-en-en 7143
91982 victrion-arch-wall-mounted-shower-arm-en-en-en-en-en-en 7143
91983 victrion-arch-wall-mounted-shower-arm-en-en-en-en-en-en-en 7143
91985 victrion-straight-wall-mounted-shower-arm-en 7143
91992 victrion-wall-mounted-handset-shower-set 7143
91993 victrion-wall-mounted-handset-shower-set-en 7143
91994 victrion-wall-mounted-handset-shower-set-en-en 7143
91995 victrion-wall-mounted-handset-shower-set-en-en-en 7143
91996 victrion-wall-mounted-handset-shower-set-en-en-en-en 7143
91997 victrion-wall-mounted-handset-shower-set-en-en-en-en-en 7143
91998 victrion-wall-mounted-handset-shower-set-en-en-en-en-en-en 7143
91999 victrion-wall-mounted-handset-shower-set-en-en-en-en-en-en-en 7143
92556 a15088 7143/7300/7302
92557 a15167 7148/7149/7151