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 (
    98737, 98750, 98751, 98752, 98753, 98754, 
    98755, 98756, 98757, 99509, 99510, 
    99513, 99514, 99517, 99518, 99653, 
    99654, 99655, 99656, 99657, 99658, 
    99659, 99660, 99661, 99662, 99663, 
    99664, 99665, 99666, 99667, 99668, 
    100504, 100505, 100506, 100507, 100508, 
    100509, 100510, 100511, 100512, 100513, 
    100514, 100515, 100516, 100517, 100518, 
    100519, 100520, 100521, 100522, 100523, 
    100524, 100525, 100526, 100527, 100528, 
    100529, 100530, 100531, 100532, 100533, 
    100534, 100535, 100642, 100644, 100646, 
    100648, 100789, 100790, 100791, 100792, 
    100793, 100794, 100795, 100796, 100797, 
    100798, 100799, 100800, 100801, 100802, 
    100803, 100804, 100805, 100806, 100807, 
    100808, 100809, 100810, 100811, 100812, 
    100813, 100814, 100815, 100816, 100817
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00254

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 (98737,98750,98751,98752,98753,98754,98755,98756,98757,99509,99510,99513,99514,99517,99518,99653,99654,99655,99656,99657,99658,99659,99660,99661,99662,99663,99664,99665,99666,99667,99668,100504,100505,100506,100507,100508,100509,100510,100511,100512,100513,100514,100515,100516,100517,100518,100519,100520,100521,100522,100523,100524,100525,100526,100527,100528,100529,100530,100531,100532,100533,100534,100535,100642,100644,100646,100648,100789,100790,100791,100792,100793,100794,100795,100796,100797,100798,100799,100800,100801,100802,100803,100804,100805,100806,100807,100808,100809,100810,100811,100812,100813,100814,100815,100816,100817)) 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
98737 kra805sl-p 7184/7217
98750 ksa305dl-p 7184/7217
98751 ksa305sl-p 7184/7217
98752 ksa405dl-p 7184/7217
98753 ksa405sl-p 7184/7217
98754 ksa605dl-p 7184/7217
98755 ksa605sl-p 7184/7217
98756 ksa805dl-p 7184/7217
98757 ksa805sl-p 7184/7217
99509 pdt-000600-p 7184/7219
99510 pdt-000601-p 7184/7219
99513 pdt-000731-p 7184/7219
99514 pdt-000732-p 7184/7219
99517 pdt-000735-p 7184/7219
99518 pdt-000736-p 7184/7219
99653 kch305dl-p 7184/7217
99654 kch305sl-p 7184/7217
99655 kch405dl-p 7184/7217
99656 kch405sl-p 7184/7217
99657 kch605dl-p 7184/7217
99658 kch605sl-p 7184/7217
99659 kch805dl-p 7184/7217
99660 kch805sl-p 7184/7217
99661 ksi305dl-p 7184/7217
99662 ksi305sl-p 7184/7217
99663 ksi405dl-p 7184/7217
99664 ksi405sl-p 7184/7217
99665 ksi605dl-p 7184/7217
99666 ksi605sl-p 7184/7217
99667 ksi805dl-p 7184/7217
99668 ksi805sl-p 7184/7217
100504 tk001-p 7184/7217
100505 tk002-p 7184/7217
100506 tk002bg-p 7184/7217
100507 tk002bn-p 7184/7217
100508 tk002k-p 7184/7217
100509 tk003-p 7184/7217
100510 tk003bg-p 7184/7217
100511 tk003bn-p 7184/7217
100512 tk003k-p 7184/7217
100513 tk004-p 7184/7217
100514 tk004bg-p 7184/7217
100515 tk004bn-p 7184/7217
100516 tk004k-p 7184/7217
100517 tk005bn-p 7184/7217
100518 tk005cp-p 7184/7217
100519 tk007-p 7184/7217
100520 tk008-p 7184/7217
100521 tk009-p 7184/7217
100522 tk009bg-p 7184/7217
100523 tk009bn-p 7184/7217
100524 tk009k-p 7184/7217
100525 tk010-p 7184/7217
100526 tk011-p 7184/7217
100527 tk012-p 7184/7217
100528 tk013-p 7184/7217
100529 tk014-p 7184/7217
100530 tk015-p 7184/7217
100531 tk015bg-p 7184/7217
100532 tk015bn-p 7184/7217
100533 tk015k-p 7184/7217
100534 tk016-p 7184/7217
100535 tk017-p 7184/7217
100642 ttr-clu04-p 7184/7217
100644 ttr-clu06-p 7184/7217
100646 ttr-lev04-p 7184/7217
100648 ttr-lev06-p 7184/7217
100789 was219-m 7184/7219
100790 was219bc-m 7184/7219
100791 was219bco-m 7184/7219
100792 was219bg-m 7184/7219
100793 was219bn-m 7184/7219
100794 was219co-m 7184/7219
100795 was219g-m 7184/7219
100796 was219n-m 7184/7219
100797 was220-p 7184/7219
100798 was220b-p 7184/7219
100799 was220bc-m 7184/7219
100800 was220bco-m 7184/7219
100801 was220bg-m 7184/7219
100802 was220bn-m 7184/7219
100803 was220bs-p 7184/7219
100804 was220co-m 7184/7219
100805 was220f-p 7184/7219
100806 was220g-m 7184/7219
100807 was220gm-p 7184/7219
100808 was220ig-p 7184/7219
100809 was220kg-p 7184/7219
100810 was220m-p 7184/7219
100811 was220me-p 7184/7219
100812 was220mw-p 7184/7219
100813 was220n-m 7184/7219
100814 was220pg-p 7184/7219
100815 was220pw-p 7184/7219
100816 was220r-p 7184/7219
100817 was221-m 7184/7219