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 (
    82038, 148882, 148883, 148884, 148885, 
    148886, 148887, 148888, 148889, 148890, 
    148891, 148892, 148893, 148894, 148895, 
    148896, 148897, 148898, 148899, 148900, 
    148901, 148902, 148903, 148904, 148905, 
    148906, 148907, 148908, 148909, 148910, 
    148911, 148912, 148913, 148914, 148915, 
    148916, 148917, 148918, 148919, 148920, 
    148921, 148922, 148923, 148924, 148925, 
    148926, 148927, 148928, 148929, 148930, 
    148931
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00147

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "71.46"
    },
    "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": 51,
      "rows_produced_per_join": 51,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "61.26",
        "eval_cost": "10.20",
        "prefix_cost": "71.46",
        "data_read_per_join": "86K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`webmarco`.`cscart_seo_names`.`object_id` in (82038,148882,148883,148884,148885,148886,148887,148888,148889,148890,148891,148892,148893,148894,148895,148896,148897,148898,148899,148900,148901,148902,148903,148904,148905,148906,148907,148908,148909,148910,148911,148912,148913,148914,148915,148916,148917,148918,148919,148920,148921,148922,148923,148924,148925,148926,148927,148928,148929,148930,148931)) and (`webmarco`.`cscart_seo_names`.`type` = 'p') and (`webmarco`.`cscart_seo_names`.`dispatch` = '') and (`webmarco`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
82038 short-dress-for-women-en-11 2653/2658/2837/2904
148882 short-dress-for-women-en 223/225/607/476/1716
148883 short-dress-for-women-en-9 223/225/607/476/1716
148884 short-dress-for-women-en-2 223/225/607/476/1716
148885 short-dress-for-women-en-10 223/225/607/476/1716
148886 short-dress-for-women-en-12 223/225/607/476/1716
148887 short-dress-for-women-en-3 223/225/607/476/1716
148888 short-dress-for-women-en-13 223/225/607/476/1716
148889 short-dress-for-women-en-14 223/225/607/476/1716
148890 short-dress-for-women-en-4 223/225/607/476/1716
148891 short-dress-for-women-en-15 223/225/607/476/1716
148892 short-dress-for-women-en-16 223/225/607/476/1716
148893 short-dress-for-women-en-5 223/225/607/476/1716
148894 short-dress-for-women-en-17 223/225/607/476/1716
148895 short-dress-for-women-en-18 223/225/607/476/1716
148896 short-dress-for-women-en-6 223/225/607/476/1716
148897 short-dress-for-women-en-19 223/225/607/476/1716
148898 short-dress-for-women-en-20 223/225/607/476/1716
148899 short-dress-for-women-en-7 223/225/607/476/1716
148900 short-dress-for-women-en-21 223/225/607/476/1716
148901 short-dress-for-women-en-22 223/225/607/476/1716
148902 short-dress-for-women-en-8 223/225/607/476/1716
148903 short-dress-for-women-en-23 223/225/607/476/1716
148904 short-dress-for-women-en-24 223/225/607/476/1716
148905 short-dress-for-women-en-25 223/225/607/476/1716
148906 short-dress-for-women-en-26 223/225/607/476/1716
148907 short-dress-for-women-en-27 223/225/607/476/1716
148908 short-dress-for-women-en-28 223/225/607/476/1716
148909 short-dress-for-women-en-29 223/225/607/476/1716
148910 short-dress-for-women-en-30 223/225/607/476/1716
148911 short-dress-for-women-en-31 223/225/607/476/1716
148912 short-dress-for-women-en-32 223/225/607/476/1716
148913 short-dress-for-women-en-33 223/225/607/476/1716
148914 short-dress-for-women-en-34 223/225/607/476/1716
148915 short-dress-for-women-en-35 223/225/607/476/1716
148916 short-dress-for-women-en-36 223/225/607/476/1716
148917 short-dress-for-women-en-37 223/225/607/476/1716
148918 short-dress-for-women-en-38 223/225/607/476/1716
148919 short-dress-for-women-en-39 223/225/607/476/1716
148920 short-dress-for-women 223/225/607/476/1716
148921 short-dress-for-women-en-40 223/225/607/476/1716
148922 short-dress-for-women-en-41 223/225/607/476/1716
148923 short-dress-for-women-en-42 223/225/607/476/1716
148924 short-dress-for-women-en-43 223/225/607/476/1716
148925 short-dress-for-women-en-44 223/225/607/476/1716
148926 short-dress-for-women-en-45 223/225/607/476/1716
148927 short-dress-for-women-en-46 223/225/607/476/1716
148928 short-dress-for-women-en-47 223/225/607/476/1716
148929 short-dress-for-women-en-48 223/225/607/476/1716
148930 short-dress-for-women-en-49 223/225/607/476/1716
148931 short-dress-for-women-en-50 223/225/607/476/1716