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 (
    89394, 89396, 89390, 89392, 89388, 89395, 
    89397, 89410, 89411, 89412, 82420, 
    89360, 89363, 89365, 82354, 89359, 
    89297, 89362, 89364, 89296, 89391, 
    89393, 89406, 89408, 89407, 90843, 
    82421, 89302, 89389, 89300, 82381, 
    89301, 89299, 89349, 89334, 89350, 
    89263, 89336, 82355, 89353, 82380, 
    89333, 89354, 86823, 89355, 89356, 
    89335, 89293, 89291, 89370, 89262, 
    89372, 89273, 89276, 89369, 89371, 
    89374, 89292, 89287, 86819, 86821, 
    89272, 89275, 89357, 89271, 89274, 
    89358, 86822, 89327, 89373, 89266, 
    89328, 89329, 89269, 89402, 89404, 
    89403, 89331, 89265, 89330, 89264, 
    86817, 89368, 89268, 89367, 89308, 
    89267, 86818, 86820, 89295, 89332, 
    89294, 89405, 89309, 89321, 89257
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00265

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 (89394,89396,89390,89392,89388,89395,89397,89410,89411,89412,82420,89360,89363,89365,82354,89359,89297,89362,89364,89296,89391,89393,89406,89408,89407,90843,82421,89302,89389,89300,82381,89301,89299,89349,89334,89350,89263,89336,82355,89353,82380,89333,89354,86823,89355,89356,89335,89293,89291,89370,89262,89372,89273,89276,89369,89371,89374,89292,89287,86819,86821,89272,89275,89357,89271,89274,89358,86822,89327,89373,89266,89328,89329,89269,89402,89404,89403,89331,89265,89330,89264,86817,89368,89268,89367,89308,89267,86818,86820,89295,89332,89294,89405,89309,89321,89257)) 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
82354 shower-kits-traditional-thermostatic-shower-valve-and-kit 7143/7153/7155
82355 shower-kits-traditional-thermostatic-shower-valve-and-kit-en 7143/7153/7155
82380 multi-option-shower-kits-round-brass-thermostatic-bar-valve-and-shower-kit 7143/7153/7155
82381 multi-option-shower-kits-square-brass-thermostatic-bar-valve-and-shower-kit 7143/7153/7155
82420 shower-kits-traditional-thermostatic-shower-valve-and-kit-en-en 7143/7153/7155
82421 shower-kits-traditional-thermostatic-shower-valve-and-kit-en-en-en 7143/7153/7155
86817 shower-kits-thermostatic-bar-shower-with-kit-en-en 7143/7153/7155
86818 shower-kits-round-thermostatic-bar-valve-and-shower-kit 7143/7153/7155
86819 shower-kits-square-thermostatic-bar-valve-and-shower-kit 7143/7153/7155
86820 shower-kits-round-thermostatic-bar-valve-and-shower-kit-en 7143/7153/7305
86821 shower-kits-square-thermostatic-bar-valve-and-shower-kit-en 7143/7153/7305
86822 shower-kits-round-thermostatic-bar-valve-and-shower-kit-en-en 7143/7153/7155
86823 shower-kits-square-thermostatic-bar-valve-and-shower-kit-en-en 7143/7153/7155
89257 concealed-manual-round-valve-wall-mount-shower-arm-and-round-fixed-head-shower-kit 7143/7153/7154
89262 concealed-round-thermostatic-twin-valve-and-kit 7143/7153/7154
89263 concealed-round-thermostatic-twin-valve-and-head 7143/7153/7154
89264 thermostatic-round-bar-valve-and-single-function-slide-rail-shower-kit 7143/7153/7155
89265 round-bar-valve-and-kit 7143/7153/7155
89266 thermostatic-round-bar-valve-and-multi-function-slide-rail-shower-kit 7143/7153/7155
89267 round-bar-valve-and-kit-en 7143/7153/7155
89268 thermostatic-round-bar-valve-and-multi-function-slide-rail-shower-kit-en 7143/7153/7155
89269 thermostatic-round-bar-valve-and-single-function-slide-rail-shower-kit-en 7143/7153/7155
89271 binsey-thermostatic-round-bath-shower-mixer-and-single-function-slide-rail-shower-kit 7143/7153/7155
89272 thermostatic-bath-shower-mixer-and-kit 7143/7153/7155
89273 binsey-thermostatic-round-bath-shower-mixer-and-multi-function-slide-rail-shower-kit 7143/7153/7155
89274 thermostatic-bath-shower-mixer-and-kit-en 7143/7153/7155
89275 thermostatic-bath-shower-mixer-and-kit-en-en 7143/7153/7155
89276 arvan-thermostatic-round-bath-shower-mixer-and-single-function-slide-rail-shower-kit 7143/7153/7155
89287 binsey-thermostatic-concealed-twin-round-valve-and-slide-rail-kit-with-multi-function-handset-and-outlet-elbow-shower-kit 7143/7153/7154
89291 concealed-round-thermostatic-twin-valve-and-head-en 7143/7153/7154
89292 concealed-round-thermostatic-twin-valve-and-kit-en 7143/7153/7154
89293 concealed-round-thermostatic-twin-valve-and-head-en-en 7143/7153/7154
89294 concealed-round-manual-valve-kit-and-head 7143/7153/7154
89295 binsey-manual-concealed-twin-round-valve-with-diverter-slide-rail-kit-with-multi-function-handset-and-outlet-elbow-wall-mount-shower-arm-and-round-fixed-head-shower-kit 7143/7153/7154
89296 thermostatic-concealed-twin-round-valve-with-diverter-slide-rail-kit-with-multi-function-handset-and-outlet-elbow-wall-mount-shower-arm-and-round-fixed-head-shower-kit 7143/7153/7154
89297 concealed-round-thermostatic-triple-valve-kit-and-head 7143/7153/7154
89299 binsey-thermostatic-concealed-twin-round-valve-with-diverter-slide-rail-kit-with-multi-function-handset-and-outlet-elbow-wall-mount-shower-arm-and-round-fixed-head-shower-kit 7143/7153/7154
89300 concealed-round-thermostatic-triple-valve-kit-and-head-en 7143/7153/7154
89301 arvan-thermostatic-concealed-twin-round-valve-with-diverter-slide-rail-kit-with-multi-function-handset-and-outlet-elbow-wall-mount-shower-arm-and-round-fixed-head-shower-kit 7143/7153/7154
89302 arvan-thermostatic-concealed-triple-round-valve-slide-rail-kit-with-multi-function-handset-and-outlet-elbow-wall-mount-shower-arm-and-round-fixed-head-shower-kit 7143/7153/7154
89308 round-bar-valve-and-kit-en-en-en-en-en 7143/7153/7155
89309 round-bar-valve-and-kit-en-en-en-en-en-en 7143/7153/7155
89321 round-bar-valve-and-kit-en-en-en-en-en-en-en-en-en 7143/7153/7155
89327 reef-thermostatic-bath-shower-mixer-and-multi-function-slide-rail-shower-kit 7143/7153/7155
89328 thermostatic-bath-shower-mixer-and-kit-en-en-en-en-en-en 7143/7153/7155
89329 thermostatic-bath-shower-mixer-and-kit-en-en-en-en-en-en-en 7143/7153/7155
89330 reef-thermostatic-bath-shower-mixer-and-single-function-slide-rail-shower-kit 7143/7153/7155
89331 thermostatic-bath-shower-mixer-and-kit-en-en-en-en-en-en-en-en 7143/7153/7155
89332 thermostatic-bath-shower-mixer-and-kit-en-en-en-en-en-en-en-en-en 7143/7153/7155
89333 windon-thermostatic-square-bath-shower-mixer-and-single-function-slide-rail-shower-kit 7143/7153/7155
89334 windon-thermostatic-square-bath-shower-mixer-and-single-function-slide-rail-shower-kit-en 7143/7153/7155
89335 sanford-thermostatic-square-bath-shower-mixer-and-single-function-slide-rail-shower-kit 7143/7153/7155
89336 sanford-thermostatic-square-bath-shower-mixer-and-single-function-slide-rail-shower-kit-en 7143/7153/7155
89349 concealed-square-thermostatic-twin-valve-and-kit 7143/7153/7154
89350 thermostatic-concealed-twin-square-valve-wall-mount-shower-arm-and-square-fixed-head-shower-kit 7143/7153/7154
89353 concealed-square-thermostatic-twin-valve-and-kit-en 7143/7153/7154
89354 windon-thermostatic-concealed-twin-square-valve-wall-mount-shower-arm-and-square-fixed-head-shower-kit 7143/7153/7154
89355 sanford-thermostatic-concealed-twin-square-valve-and-slide-rail-kit-with-single-function-handset-and-outlet-elbow-shower-kit 7143/7153/7154
89356 concealed-square-thermostatic-twin-valve-and-head 7143/7153/7154
89357 windon-manual-concealed-square-valve-slide-rail-kit-with-single-function-handset-and-outlet-elbow-wall-mount-shower-arm-and-square-fixed-head-shower-kit 7143/7153/7154
89358 sanford-manual-concealed-square-valve-slide-rail-kit-with-single-function-handset-and-outlet-elbow-wall-mount-shower-arm-and-square-fixed-head-shower-kit 7143/7153/7154
89359 concealed-square-thermostatic-twin-valve-kit-and-head 7143/7153/7154
89360 sanford-thermostatic-concealed-triple-square-valve-with-single-function-handset-and-outlet-elbow-wall-mount-shower-arm-and-square-fixed-head-shower-kit 7143/7153/7154
89362 windon-thermostatic-concealed-twin-square-valve-with-diverter-with-single-function-handset-and-outlet-elbow-wall-mount-shower-arm-and-square-fixed-head-shower-kit 7143/7153/7154
89363 concealed-square-thermostatic-triple-valve-kit-and-head 7143/7153/7154
89364 sanford-thermostatic-concealed-twin-square-valve-with-diverter-with-single-function-handset-and-outlet-elbow-wall-mount-shower-arm-and-square-fixed-head-shower-kit 7143/7153/7154
89365 concealed-square-thermostatic-triple-valve-kit-and-head-en 7143/7153/7154
89367 thermostatic-square-bar-valve-and-single-function-slide-rail-shower-kit-en 7143/7153/7155
89368 square-bar-valve-and-kit 7143/7153/7155
89369 square-bar-valve-and-kit-en 7143/7153/7155
89370 thermostatic-square-bar-valve-and-single-function-slide-rail-shower-kit-en-en 7143/7153/7155
89371 thermostatic-square-bar-valve-and-single-function-slide-rail-shower-kit-en-en-en 7143/7153/7155
89372 square-bar-valve-and-kit-en-en 7143/7153/7155
89373 square-bar-valve-and-kit-en-en-en 7143/7153/7155
89374 thermostatic-square-bar-valve-and-single-function-slide-rail-shower-kit-en-en-en-en 7143/7153/7155
89388 dual-exposed-valve-and-rigid-riser-kit-en-en-en 7143/7153/7154
89389 dual-exposed-valve-and-slide-rail-kit-en 7143/7153/7154
89390 twin-exposed-valve-and-rigid-riser-kit-en-en-en-en-en 7143/7153/7154
89391 victorian-traditional-twin-exposed-valve-and-single-function-slide-rail-shower-kit 7143/7153/7154
89392 edwardian-traditional-twin-exposed-valve-and-rigid-riser-shower-kit 7143/7153/7154
89393 edwardian-traditional-twin-exposed-valve-and-single-function-slide-rail-shower-kit 7143/7153/7154
89394 triple-exposed-valve-rigid-riser-kit-and-spout 7143/7153/7154
89395 triple-exposed-valve-and-rigid-riser-kit-en-en 7143/7153/7154
89396 edwardian-traditional-triple-exposed-valve-rigid-riser-kit-and-bath-spout-shower-kit 7143/7153/7154
89397 triple-exposed-valve-and-rigid-riser-kit-en-en-en 7143/7153/7154
89402 concealed-manual-valve-and-slide-rail-kit 7143/7153/7154
89403 traditional-manual-concealed-valve-wall-mount-shower-arm-and-round-fixed-head-shower-kit 7143/7153/7154
89404 exposed-manual-valve-and-slide-rail-kit 7143/7153/7154
89405 traditional-manual-exposed-valve-and-rigid-riser-kit-with-swivel-spout 7143/7153/7154
89406 victorian-traditional-thermostatic-concealed-twin-valve-and-single-function-slider-rail-kit-and-outlet-elbow 7143/7153/7154
89407 concealed-thermostatic-twin-valve-and-head 7143/7153/7154
89408 edwardian-traditional-thermostatic-concealed-twin-valve-and-single-function-slider-rail-kit-and-outlet-elbow 7143/7153/7154
89410 concealed-thermostatic-triple-valve-slide-rail-kit-and-head 7143/7153/7154
89411 concealed-thermostatic-triple-valve-slide-rail-kit-and-head-en 7143/7153/7154
89412 concealed-thermostatic-triple-valve-slide-rail-kit-and-head-en-en 7143/7153/7154
90843 edwardian-traditional-thermostatic-concealed-twin-valve-wall-mount-shower-arm-and-round-fixed-head-shower-kit 7143/7153/7154