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 (
    98177, 98178, 98179, 98180, 98181, 98182, 
    98183, 98184, 98185, 98186, 98187, 
    98188, 98189, 98190, 98191, 98200, 
    98201, 98202, 98203, 98204, 98205, 
    98206, 98207, 98391, 98392, 98393, 
    98394, 98395, 98396, 98397, 98398, 
    98399, 98400, 98401, 98402, 98403, 
    98404, 98405, 98406, 98411, 98412, 
    98413, 98422, 98427, 98429, 98433, 
    98435, 98439, 98440, 98441, 98443, 
    98447, 98451, 98453, 98456, 98476, 
    98477, 98478, 98479, 98480, 98481, 
    98483, 98484, 98490, 98492, 98759, 
    98769, 98770, 98771, 98772, 98897, 
    99066, 99508, 99512, 99516, 100480, 
    100481, 100484, 100485, 100486, 100700, 
    100701, 100702, 100703, 100704, 100705, 
    100706, 100707, 100708, 100709, 100710, 
    100711, 100712, 100713, 100714, 100715
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00235

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 (98177,98178,98179,98180,98181,98182,98183,98184,98185,98186,98187,98188,98189,98190,98191,98200,98201,98202,98203,98204,98205,98206,98207,98391,98392,98393,98394,98395,98396,98397,98398,98399,98400,98401,98402,98403,98404,98405,98406,98411,98412,98413,98422,98427,98429,98433,98435,98439,98440,98441,98443,98447,98451,98453,98456,98476,98477,98478,98479,98480,98481,98483,98484,98490,98492,98759,98769,98770,98771,98772,98897,99066,99508,99512,99516,100480,100481,100484,100485,100486,100700,100701,100702,100703,100704,100705,100706,100707,100708,100709,100710,100711,100712,100713,100714,100715)) 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
98177 cma025bc-m 7148/7156/7157
98178 cma025bco-m 7148/7156/7157
98179 cma025bg-m 7148/7156/7157
98180 cma025bn-m 7148/7156/7157
98181 cma025co-m 7148/7156/7157
98182 cma025g-m 7148/7156/7157
98183 cma025n-m 7148/7156/7157
98184 cma030-m 7148/7156/7157
98185 cma030bc-m 7148/7156/7157
98186 cma030bco-m 7148/7156/7157
98187 cma030bg-m 7148/7156/7157
98188 cma030bn-m 7148/7156/7157
98189 cma030co-m 7148/7156/7157
98190 cma030g-m 7148/7156/7157
98191 cma030n-m 7148/7156/7157
98200 cma045-m 7148/7156/7157
98201 cma045bc-m 7148/7156/7157
98202 cma045bco-m 7148/7156/7157
98203 cma045bg-m 7148/7156/7157
98204 cma045bn-m 7148/7156/7157
98205 cma045co-m 7148/7156/7157
98206 cma045g-m 7148/7156/7157
98207 cma045n-m 7148/7156/7157
98391 ctw905-m 7148/7156/7157
98392 ctw905bc-m 7148/7156/7157
98393 ctw905bco-m 7148/7156/7157
98394 ctw905bg-m 7148/7156/7157
98395 ctw905bn-m 7148/7156/7157
98396 ctw905co-m 7148/7156/7157
98397 ctw905g-m 7148/7156/7157
98398 ctw905n-m 7148/7156/7157
98399 ctw910-m 7148/7156/7157
98400 ctw910bc-m 7148/7156/7157
98401 ctw910bco-m 7148/7156/7157
98402 ctw910bg-m 7148/7156/7157
98403 ctw910bn-m 7148/7156/7157
98404 ctw910co-m 7148/7156/7157
98405 ctw910g-m 7148/7156/7157
98406 ctw910n-m 7148/7156/7157
98411 da311-p 7148/7156/7157
98412 da314-p 7148/7156/7157
98413 da811-p 7148/7156/7157
98422 e1527-p 7148/7156/7157
98427 e309-p 7148/7156/7157
98429 e315-p 7148/7156/7157
98433 e324-p 7148/7156/7157
98435 e327-p 7148/7156/7157
98439 e345-p 7148/7156/7157
98440 e347-p 7148/7156/7157
98441 e348-p 7148/7156/7157
98443 e357-p 7148/7156/7157
98447 e396-p 7148/7156/7157
98451 e427-p 7148/7156/7157
98453 e727-p 7148/7156/7157
98456 e827-p 7148/7156/7157
98476 ea318-p 7148/7156/7157
98477 ea329-p 7148/7156/7157
98478 ea333-p 7148/7156/7157
98479 ea366-p 7148/7156/7157
98480 ea368-p 7148/7156/7157
98481 ea381-p 7148/7156/7157
98483 ea384-p 7148/7156/7157
98484 ea385-p 7148/7156/7157
98490 ek308-p 7148/7156/7157
98492 ek321-p 7148/7156/7157
98759 la380-p 7148/7156/7157
98769 lh302-p 7148/7156/7157
98770 lh305-p 7148/7156/7157
98771 lh307-p 7148/7156/7157
98772 lh311-p 7148/7156/7157
98897 m1c-p 7148/7156/7157
99066 nbl001-p 7148/7156/7157
99508 pdt-000599-p 7148/7156/7157
99512 pdt-000730-p 7148/7156/7157
99516 pdt-000734-p 7148/7156/7157
100480 t1c-p 7148/7156/7157
100481 t2c-p 7148/7156/7157
100484 tb001-p 7148/7156/7157
100485 tb002-p 7148/7156/7157
100486 tb003-p 7148/7156/7157
100700 was020-p 7148/7156/7157
100701 was020bc-m 7148/7156/7157
100702 was020bco-m 7148/7156/7157
100703 was020bg-m 7148/7156/7157
100704 was020bn-m 7148/7156/7157
100705 was020co-m 7148/7156/7157
100706 was020g-m 7148/7156/7157
100707 was020n-m 7148/7156/7157
100708 was030-p 7148/7156/7157
100709 was030bc-m 7148/7156/7157
100710 was030bco-m 7148/7156/7157
100711 was030bg-m 7148/7156/7157
100712 was030bn-m 7148/7156/7157
100713 was030co-m 7148/7156/7157
100714 was030g-m 7148/7156/7157
100715 was030n-m 7148/7156/7157