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 (
    100751, 100752, 100753, 100754, 100755, 
    100756, 100757, 100758, 100759, 100760, 
    100761, 100762, 100763, 100764, 100765, 
    100766, 100767, 100768, 100769, 100770, 
    100771, 100772, 100773, 100774, 100775, 
    100776, 100777, 100778, 100779, 100780, 
    100781, 100782, 100783, 100784, 100785, 
    100786, 100787, 100788, 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, 100818, 100819, 100820, 
    100821, 100822, 100823, 100824, 100825, 
    100826, 100827, 100828, 100829, 100830, 
    100831, 100832, 100833, 100834, 100835, 
    100836, 100837, 100838, 100839, 100840, 
    100841, 100842, 100843, 100844, 100845, 
    100846
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00245

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 (100751,100752,100753,100754,100755,100756,100757,100758,100759,100760,100761,100762,100763,100764,100765,100766,100767,100768,100769,100770,100771,100772,100773,100774,100775,100776,100777,100778,100779,100780,100781,100782,100783,100784,100785,100786,100787,100788,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,100818,100819,100820,100821,100822,100823,100824,100825,100826,100827,100828,100829,100830,100831,100832,100833,100834,100835,100836,100837,100838,100839,100840,100841,100842,100843,100844,100845,100846)) 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
100751 was107b-p 7148/7156/7157
100752 was107bc-m 7148/7156/7157
100753 was107bco-m 7148/7156/7157
100754 was107bg-m 7148/7156/7157
100755 was107bn-m 7148/7156/7157
100756 was107bs-m 7148/7156/7157
100757 was107co-m 7148/7156/7157
100758 was107f-p 7148/7156/7157
100759 was107g-m 7148/7156/7157
100760 was107gm-p 7148/7156/7157
100761 was107ig-p 7148/7156/7157
100762 was107kg-p 7148/7156/7157
100763 was107m-p 7148/7156/7157
100764 was107me-p 7148/7156/7157
100765 was107mw-p 7148/7156/7157
100766 was107n-m 7148/7156/7157
100767 was107pg-p 7148/7156/7157
100768 was107pw-p 7148/7156/7157
100769 was107r-p 7148/7156/7157
100770 was110-p 7148/7156/7157
100771 was110b-p 7148/7156/7157
100772 was110bc-m 7148/7156/7157
100773 was110bco-m 7148/7156/7157
100774 was110bg-m 7148/7156/7157
100775 was110bn-m 7148/7156/7157
100776 was110bs-m 7148/7156/7157
100777 was110co-m 7148/7156/7157
100778 was110f-p 7148/7156/7157
100779 was110g-m 7148/7156/7157
100780 was110gm-p 7148/7156/7157
100781 was110ig-p 7148/7156/7157
100782 was110kg-p 7148/7156/7157
100783 was110m-p 7148/7156/7157
100784 was110mw-p 7148/7156/7157
100785 was110n-m 7148/7156/7157
100786 was110pg-p 7148/7156/7157
100787 was110pw-p 7148/7156/7157
100788 was110r-p 7148/7156/7157
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
100818 was221bc-m 7184/7219
100819 was221bco-m 7184/7219
100820 was221bg-m 7184/7219
100821 was221bn-m 7184/7219
100822 was221co-m 7184/7219
100823 was221g-m 7184/7219
100824 was221n-m 7184/7219
100825 was222-m 7184/7219
100826 was222bc-m 7184/7219
100827 was222bco-m 7184/7219
100828 was222bg-m 7184/7219
100829 was222bn-m 7184/7219
100830 was222co-m 7184/7219
100831 was222g-m 7184/7219
100832 was222n-m 7184/7219
100833 was305-p 7184/7219
100834 was305bc-m 7184/7219
100835 was305bco-m 7184/7219
100836 was305bg-m 7184/7219
100837 was305bn-m 7184/7219
100838 was305co-m 7184/7219
100839 was305g-m 7184/7219
100840 was305n-m 7184/7219
100841 was308-m 7148/7156/7157
100842 was308bc-m 7148/7156/7157
100843 was308bco-m 7148/7156/7157
100844 was308bg-m 7148/7156/7157
100845 was308bn-m 7148/7156/7157
100846 was308co-m 7148/7156/7157