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 (
    95663, 95664, 95665, 95666, 95667, 95668, 
    95669, 95670, 95671, 95672, 95673, 
    95674, 95675, 95676, 95677, 95678, 
    95679, 95680, 95681, 95682, 95684, 
    95685, 95686, 95687, 95688, 95689, 
    95690, 95691, 95692, 95693, 95694, 
    95695, 95696, 95697, 95698, 95699, 
    95700, 95701, 96189, 96842, 96843, 
    96844, 96845, 96846, 96847, 97713, 
    97714, 97715, 98024, 98025, 98026, 
    98027, 98028, 98029, 98515, 98521, 
    98522, 99054, 99055, 99189, 99190, 
    99191, 99239, 99356, 99357, 99358, 
    99359, 99360, 99361, 99362, 99363, 
    99364, 99365, 99366, 99374, 99375, 
    99376, 99377, 99378, 99379, 99380, 
    99381, 99382, 99383, 99384, 99385, 
    99386, 99387, 99388, 99389, 99390, 
    99391, 99392, 99393, 99394, 99395
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00357

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 (95663,95664,95665,95666,95667,95668,95669,95670,95671,95672,95673,95674,95675,95676,95677,95678,95679,95680,95681,95682,95684,95685,95686,95687,95688,95689,95690,95691,95692,95693,95694,95695,95696,95697,95698,95699,95700,95701,96189,96842,96843,96844,96845,96846,96847,97713,97714,97715,98024,98025,98026,98027,98028,98029,98515,98521,98522,99054,99055,99189,99190,99191,99239,99356,99357,99358,99359,99360,99361,99362,99363,99364,99365,99366,99374,99375,99376,99377,99378,99379,99380,99381,99382,99383,99384,99385,99386,99387,99388,99389,99390,99391,99392,99393,99394,99395)) 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
95663 alqbd76-e5 7195/7222
95664 alqbd80-e5 7195/7222
95665 alqbd90-e5 7195/7222
95666 alqce7676-e5 7195/7222
95667 alqce8080-e5 7195/7222
95668 alqpd70-e5 7195/7222
95669 alqpd76-e5 7195/7222
95670 alqpd80-e5 7195/7222
95671 alqpd90-e5 7195/7222
95672 alqsp70-e5 7195/7222
95673 alqsp76-e5 7195/7222
95674 alqsp80-e5 7195/7222
95675 alqsp90-e5 7195/7222
95676 alqu108-e5 7195/7222
95677 alqu128-e5 7195/7222
95678 alqu129-e5 7195/7222
95679 alqu7-e5 7195/7222
95680 alqu8-e5 7195/7222
95681 alqu9-e5 7195/7222
95682 alrfl18530bb 7195/7222
95684 alrs025 7195/7222
95685 alrs025gm 7195/7222
95686 alrs030gmhc 7195/7222
95687 alrs030h 7195/7222
95688 alrs030hc 7195/7222
95689 alrs030hgm 7195/7222
95690 alrsbp025 7195/7222
95691 alrsbp030hc 7195/7222
95692 alrsc070 7195/7222
95693 alrsc076 7195/7222
95694 alrsc080 7195/7222
95695 alrsc090 7195/7222
95696 alrsc10 7195/7222
95697 alrsc11 7195/7222
95698 alrsc12 7195/7222
95699 alrsc14 7195/7222
95700 alrscbb030h 7195/7222
95701 alrscbb030hc 7195/7222
96189 sy-vod38 7195/7222
96842 aqven6121-p 7195/7222
96843 aqven6130-p 7195/7222
96844 aqven6135-p 7195/7222
96845 aqven6137-p 7195/7222
96846 aqven6139-p 7195/7222
96847 aqven6140-p 7195/7222
97713 baye201-m 7195/7222
97714 baye203-m 7195/7222
97715 baye204-m 7195/7222
98024 bss010-m 7195/7222
98025 bss013-m 7195/7222
98026 bss015-m 7195/7222
98027 bss020-m 7195/7222
98028 bss025-m 7195/7222
98029 bss028-m 7195/7222
98515 ersbs0-p 7195/7222
98521 erss1-p 7195/7222
98522 erssq-p 7195/7222
99054 nbbs1-p 7195/7222
99055 nbbsr1-p 7195/7222
99189 ncs0-p 7195/7222
99190 ncs0bp-p 7195/7222
99191 ncs1-p 7195/7222
99239 ncsr1-p 7195/7222
99356 nsbs2-p 7195/7222
99357 nsbs27-p 7195/7222
99358 nsbs28-p 7195/7222
99359 nsbs2bp-p 7195/7222
99360 nsbs3-p 7195/7222
99361 nsbs7-p 7195/7222
99362 nsbs78-p 7195/7222
99363 nsbs7bb-p 7195/7222
99364 nsbs7bf-p 7195/7222
99365 nsbs7bp-p 7195/7222
99366 nsbsr1-p 7195/7222
99374 nss1-p 7195/7222
99375 nss17-p 7195/7222
99376 nss18-p 7195/7222
99377 nss2-p 7195/7222
99378 nss6bp-p 7195/7222
99379 nss7bp-p 7195/7222
99380 nssf1-p 7195/7222
99381 nssq-p 7195/7222
99382 nssq1-p 7195/7222
99383 nssq7-p 7195/7222
99384 nssq78-p 7195/7222
99385 nssq7bb-p 7195/7222
99386 nssq7bp-p 7195/7222
99387 nssq7fl-p 7195/7222
99388 nssq7flbb-p 7195/7222
99389 nssq7flbp-p 7195/7222
99390 nssq8-p 7195/7222
99391 nssqbb-p 7195/7222
99392 nssqbf-p 7195/7222
99393 nssqbfc-p 7195/7222
99394 nssqgm-p 7195/7222
99395 nssqr-p 7195/7222