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 (
    92652, 92653, 92654, 92655, 92656, 92657, 
    92658, 92659, 92660, 92661, 92662, 
    92663, 92664, 92665, 92672, 92673, 
    92674, 92675, 92676, 92677, 92678, 
    92679, 92680, 92681, 92682, 92683, 
    92684, 92685, 92686, 92687, 92688, 
    92695, 92696, 92697, 92698, 92699, 
    92700, 92701, 92702, 92703, 92704, 
    92705, 92706, 92707, 92708, 92709, 
    92710, 92711, 92712, 92713, 92714, 
    92715, 92716, 92717, 92718, 92719, 
    92720, 92721, 92722, 92723, 92724, 
    92725, 92726, 92727, 92728, 92729, 
    92730, 92731, 92732, 92733, 92734, 
    92741, 92742, 92743, 92744, 92745, 
    92746, 92747, 92748, 92749, 92750, 
    92751, 92752, 92753, 92754, 92755, 
    92756, 92757, 92758, 92759, 92760, 
    92761, 92762, 92763, 92764, 92765
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00108

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 (92652,92653,92654,92655,92656,92657,92658,92659,92660,92661,92662,92663,92664,92665,92672,92673,92674,92675,92676,92677,92678,92679,92680,92681,92682,92683,92684,92685,92686,92687,92688,92695,92696,92697,92698,92699,92700,92701,92702,92703,92704,92705,92706,92707,92708,92709,92710,92711,92712,92713,92714,92715,92716,92717,92718,92719,92720,92721,92722,92723,92724,92725,92726,92727,92728,92729,92730,92731,92732,92733,92734,92741,92742,92743,92744,92745,92746,92747,92748,92749,92750,92751,92752,92753,92754,92755,92756,92757,92758,92759,92760,92761,92762,92763,92764,92765)) 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
92652 arn2222lsb2 7170/7192
92653 arn2222lsw2 7170/7192
92654 arn2223lbg2 7170/7192
92655 arn2223lcm 7170/7192
92656 arn2223lcm2 7170/7192
92657 arn2223lsb2 7170/7192
92658 arn2223lsw2 7170/7192
92659 arn2224lbg2 7170/7192
92660 arn2224lcm 7170/7192
92661 arn2224lcm2 7170/7192
92662 arn2224lsb2 7170/7192
92663 arn2224lsw2 7170/7192
92664 arn2225lcm 7170/7192
92665 arn2226lcm 7170/7192
92672 arn2522lbg2 7170/7192
92673 arn2522lcm 7170/7192
92674 arn2522lcm2 7170/7192
92675 arn2522lsb2 7170/7192
92676 arn2522lsw2 7170/7192
92677 arn2523lbg2 7170/7192
92678 arn2523lcm 7170/7192
92679 arn2523lcm2 7170/7192
92680 arn2523lsb2 7170/7192
92681 arn2523lsw2 7170/7192
92682 arn2524lbg2 7170/7192
92683 arn2524lcm 7170/7192
92684 arn2524lcm2 7170/7192
92685 arn2524lsb2 7170/7192
92686 arn2524lsw2 7170/7192
92687 arn2525lcm 7170/7192
92688 arn2526lcm 7170/7192
92695 arn2922lbg 7170/7192
92696 arn2922lbg2 7170/7192
92697 arn2922lcm 7170/7192
92698 arn2922lcm2 7170/7192
92699 arn2922lsb 7170/7192
92700 arn2922lsb2 7170/7192
92701 arn2922lsw 7170/7192
92702 arn2922lsw2 7170/7192
92703 arn2922w 7170/7192
92704 arn2922w2 7170/7192
92705 arn2923lbg 7170/7192
92706 arn2923lbg2 7170/7192
92707 arn2923lcm 7170/7192
92708 arn2923lcm2 7170/7192
92709 arn2923lsb 7170/7192
92710 arn2923lsb2 7170/7192
92711 arn2923lsw 7170/7192
92712 arn2923lsw2 7170/7192
92713 arn2923w 7170/7192
92714 arn2923w2 7170/7192
92715 arn2924lbg 7170/7192
92716 arn2924lbg2 7170/7192
92717 arn2924lcm 7170/7192
92718 arn2924lcm2 7170/7192
92719 arn2924lsb 7170/7192
92720 arn2924lsb2 7170/7192
92721 arn2924lsw 7170/7192
92722 arn2924lsw2 7170/7192
92723 arn2924w 7170/7192
92724 arn2924w2 7170/7192
92725 arn2925lbg 7170/7192
92726 arn2925lcm 7170/7192
92727 arn2925lsb 7170/7192
92728 arn2925lsw 7170/7192
92729 arn2925w 7170/7192
92730 arn2926lbg 7170/7192
92731 arn2926lcm 7170/7192
92732 arn2926lsb 7170/7192
92733 arn2926lsw 7170/7192
92734 arn2926w 7170/7192
92741 arn3022lbg 7170/7192
92742 arn3022lcm 7170/7192
92743 arn3022lsb 7170/7192
92744 arn3022lsw 7170/7192
92745 arn3022w 7170/7192
92746 arn3022w2 7170/7192
92747 arn3023lbg 7170/7192
92748 arn3023lcm 7170/7192
92749 arn3023lsb 7170/7192
92750 arn3023lsw 7170/7192
92751 arn3023w 7170/7192
92752 arn3023w2 7170/7192
92753 arn3024lbg 7170/7192
92754 arn3024lcm 7170/7192
92755 arn3024lsb 7170/7192
92756 arn3024lsw 7170/7192
92757 arn3024w 7170/7192
92758 arn3024w2 7170/7192
92759 arn3025lbg 7170/7192
92760 arn3025lcm 7170/7192
92761 arn3025lsb 7170/7192
92762 arn3025lsw 7170/7192
92763 arn3025w 7170/7192
92764 arn3026lbg 7170/7192
92765 arn3026lcm 7170/7192