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 (
    90813, 90814, 89717, 89718, 90812, 89716, 
    90810, 90811, 89714, 89715, 88295, 
    89695, 88289, 88294, 88113, 88125, 
    88137, 89689, 89694, 88111, 88112, 
    88123, 88124, 88135, 88136, 88110, 
    88122, 88134, 88287, 88288, 88290, 
    88291, 88292, 88293, 88386, 88387, 
    89687, 89688, 89690, 89691, 89692, 
    89693, 88285, 88286, 88385, 88283, 
    88284, 89685, 89686, 88383, 88384, 
    89683, 89684, 88363, 88109, 88121, 
    88133, 88280, 88281, 88282, 88357, 
    89680, 89681, 89682, 88362, 88108, 
    88120, 88132, 88276, 88277, 88278, 
    88279, 89676, 89677, 89678, 89679, 
    88355, 88356, 88358, 88359, 88360, 
    88361, 89696, 89675, 88107, 88119, 
    88131, 88275, 88304, 88305, 88353, 
    88354, 88271, 89674, 88351, 88352
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00256

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 (90813,90814,89717,89718,90812,89716,90810,90811,89714,89715,88295,89695,88289,88294,88113,88125,88137,89689,89694,88111,88112,88123,88124,88135,88136,88110,88122,88134,88287,88288,88290,88291,88292,88293,88386,88387,89687,89688,89690,89691,89692,89693,88285,88286,88385,88283,88284,89685,89686,88383,88384,89683,89684,88363,88109,88121,88133,88280,88281,88282,88357,89680,89681,89682,88362,88108,88120,88132,88276,88277,88278,88279,89676,89677,89678,89679,88355,88356,88358,88359,88360,88361,89696,89675,88107,88119,88131,88275,88304,88305,88353,88354,88271,89674,88351,88352)) 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
88107 rectangular-slimline-shower-tray-1200-x-900mm 7237/7270/7277
88108 rectangular-slimline-shower-tray-1400-x-800mm 7237/7270/7277
88109 rectangular-slimline-shower-tray-1400-x-900mm 7237/7270/7277
88110 rectangular-slimline-shower-tray-1600-x-800mm 7237/7270/7277
88111 rectangular-slimline-shower-tray-1600-x-900mm 7237/7270/7277
88112 rectangular-slimline-shower-tray-1700-x-800mm 7237/7270/7277
88113 rectangular-slimline-shower-tray-1700-x-900mm 7237/7270/7277
88119 rectangular-slimline-shower-tray-1200-x-900mm-en 7237/7270/7293
88120 rectangular-slimline-shower-tray-1400-x-800mm-en 7237/7270/7293
88121 rectangular-slimline-shower-tray-1400-x-900mm-en 7237/7270/7293
88122 rectangular-slimline-shower-tray-1600-x-800mm-en 7237/7270/7293
88123 rectangular-slimline-shower-tray-1600-x-900mm-en 7237/7270/7293
88124 rectangular-slimline-shower-tray-1700-x-800mm-en 7237/7270/7293
88125 rectangular-slimline-shower-tray-1700-x-900mm-en 7237/7270/7293
88131 rectangular-slimline-shower-tray-1200-x-900mm-en-en 7237/7270/7299
88132 rectangular-slimline-shower-tray-1400-x-800mm-en-en 7237/7270/7299
88133 rectangular-slimline-shower-tray-1400-x-900mm-en-en 7237/7270/7299
88134 rectangular-slimline-shower-tray-1600-x-800mm-en-en 7237/7270/7299
88135 rectangular-slimline-shower-tray-1600-x-900mm-en-en 7237/7270/7299
88136 rectangular-slimline-shower-tray-1700-x-800mm-en-en 7237/7270/7299
88137 rectangular-slimline-shower-tray-1700-x-900mm-en-en 7237/7270/7299
88271 slip-resistant-rectangular-slimline-shower-tray-1100-x-900mm 7237/7270/7271
88275 slip-resistant-rectangular-slimline-shower-tray-1200-x-900mm 7237/7270/7271
88276 slip-resistant-rectangular-slimline-shower-tray-1300-x-800mm 7237/7270/7271
88277 slip-resistant-rectangular-slimline-shower-tray-1400-x-700mm 7237/7270/7271
88278 slip-resistant-rectangular-slimline-shower-tray-1400-x-760mm 7237/7270/7271
88279 slip-resistant-rectangular-slimline-shower-tray-1400-x-800mm 7237/7270/7271
88280 slip-resistant-rectangular-slimline-shower-tray-1400-x-900mm 7237/7270/7271
88281 slip-resistant-rectangular-slimline-shower-tray-1500-x-700mm 7237/7270/7271
88282 slip-resistant-rectangular-slimline-shower-tray-1500-x-760mm 7237/7270/7271
88283 slip-resistant-rectangular-slimline-shower-tray-1500-x-800mm 7237/7270/7271
88284 slip-resistant-rectangular-slimline-shower-tray-1500-x-900mm 7237/7270/7271
88285 slip-resistant-rectangular-slimline-shower-tray-1600-x-700mm 7237/7270/7271
88286 slip-resistant-rectangular-slimline-shower-tray-1600-x-760mm 7237/7270/7271
88287 slip-resistant-rectangular-slimline-shower-tray-1600-x-800mm 7237/7270/7271
88288 slip-resistant-rectangular-slimline-shower-tray-1600-x-900mm 7237/7270/7271
88289 slip-resistant-bath-replacement-slimline-shower-tray-1700-x-700mm 7237/7270/7271
88290 slip-resistant-rectangular-slimline-shower-tray-1700-x-700mm 7237/7270/7271
88291 slip-resistant-rectangular-slimline-shower-tray-1700-x-760mm 7237/7270/7271
88292 slip-resistant-rectangular-slimline-shower-tray-1700-x-800mm 7237/7270/7271
88293 slip-resistant-rectangular-slimline-shower-tray-1700-x-900mm 7237/7270/7271
88294 slip-resistant-rectangular-slimline-shower-tray-1800-x-800mm 7237/7270/7271
88295 slip-resistant-rectangular-slimline-shower-tray-1800-x-900mm 7237/7270/7271
88304 slip-resistant-offset-quadrant-slimline-shower-tray-left-hand-1200-x-900mm 7237/7272/7273
88305 slip-resistant-offset-quadrant-slimline-shower-tray-right-hand-1200-x-900mm 7237/7272/7273
88351 rectangular-slimline-shower-tray-1500-x-800mm 7237/7270/7277
88352 rectangular-slimline-shower-tray-1500-x-900mm 7237/7270/7277
88353 rectangular-slimline-shower-tray-1600-x-700mm 7237/7270/7277
88354 rectangular-slimline-shower-tray-1600-x-760mm 7237/7270/7277
88355 rectangular-slimline-shower-tray-1600-x-800mm-en-en-en 7237/7270/7277
88356 rectangular-slimline-shower-tray-1600-x-900mm-en-en-en 7237/7270/7277
88357 bath-replacement-slimline-shower-tray-1700-x-700mm 7237/7270/7277
88358 rectangular-slimline-shower-tray-1700-x-700mm 7237/7270/7277
88359 rectangular-slimline-shower-tray-1700-x-760mm 7237/7270/7277
88360 rectangular-slimline-shower-tray-1700-x-800mm-en-en-en 7237/7270/7277
88361 rectangular-slimline-shower-tray-1700-x-900mm-en-en-en 7237/7270/7277
88362 rectangular-slimline-shower-tray-1800-x-800mm 7237/7270/7277
88363 rectangular-slimline-shower-tray-1800-x-900mm 7237/7270/7277
88383 rectangular-walk-in-slimline-shower-tray-1400-x-800mm 7237/7270/7277
88384 rectangular-walk-in-slimline-shower-tray-1400-x-900mm 7237/7270/7277
88385 rectangular-walk-in-slimline-shower-tray-1600-x-800mm 7237/7270/7277
88386 rectangular-walk-in-slimline-shower-tray-1700-x-700mm 7237/7270/7277
88387 rectangular-walk-in-slimline-shower-tray-1700-x-800mm 7237/7270/7277
89674 rectangular-slimline-shower-tray-1200-x-900mm-en-en-en-en 7237/7270/7293
89675 rectangular-slimline-shower-tray-1200-x-1000mm-en 7237/7270/7293
89676 rectangular-slimline-shower-tray-1300-x-800mm-en 7237/7270/7293
89677 rectangular-slimline-shower-tray-1400-x-700mm-en 7237/7270/7293
89678 rectangular-slimline-shower-tray-1400-x-760mm-en 7237/7270/7293
89679 rectangular-slimline-shower-tray-1400-x-800mm-en-en-en-en 7237/7270/7293
89680 rectangular-slimline-shower-tray-1400-x-900mm-en-en-en-en 7237/7270/7293
89681 rectangular-slimline-shower-tray-1500-x-700mm-en 7237/7270/7293
89682 rectangular-slimline-shower-tray-1500-x-760mm-en 7237/7270/7293
89683 rectangular-slimline-shower-tray-1500-x-800mm-en 7237/7270/7293
89684 rectangular-slimline-shower-tray-1500-x-900mm-en 7237/7270/7293
89685 rectangular-slimline-shower-tray-1600-x-700mm-en 7237/7270/7293
89686 rectangular-slimline-shower-tray-1600-x-760mm-en 7237/7270/7293
89687 rectangular-slimline-shower-tray-1600-x-800mm-en-en-en-en 7237/7270/7293
89688 rectangular-slimline-shower-tray-1600-x-900mm-en-en-en-en 7237/7270/7293
89689 bath-replacement-slimline-shower-tray-1700-x-700mm-en 7237/7270/7293
89690 rectangular-slimline-shower-tray-1700-x-700mm-en 7237/7270/7293
89691 rectangular-slimline-shower-tray-1700-x-760mm-en 7237/7270/7293
89692 rectangular-slimline-shower-tray-1700-x-800mm-en-en-en-en 7237/7270/7293
89693 rectangular-slimline-shower-tray-1700-x-900mm-en-en-en-en 7237/7270/7293
89694 rectangular-slimline-shower-tray-1800-x-800mm-en 7237/7270/7293
89695 rectangular-slimline-shower-tray-1800-x-900mm-en 7237/7270/7293
89696 d-shaped-slimline-shower-tray 7237/7278/7294
89714 rectangular-walk-in-slimline-shower-tray-1400-x-800mm-en 7237/7270/7293
89715 rectangular-walk-in-slimline-shower-tray-1400-x-900mm-en 7237/7270/7293
89716 rectangular-walk-in-slimline-shower-tray-1600-x-800mm-en 7237/7270/7293
89717 rectangular-walk-in-slimline-shower-tray-1700-x-700mm-en 7237/7270/7293
89718 rectangular-walk-in-slimline-shower-tray-1700-x-800mm-en 7237/7270/7293
90810 slip-resistant-rectangular-walk-in-shower-tray-1400-x-800mm 7237/7270
90811 slip-resistant-rectangular-walk-in-shower-tray-1400-x-900mm 7237/7270
90812 slip-resistant-rectangular-walk-in-shower-tray-1600-x-800mm 7237/7270
90813 slip-resistant-rectangular-walk-in-shower-tray-1700-x-700mm 7237/7270
90814 slip-resistant-rectangular-walk-in-shower-tray-1700-x-800mm 7237/7270