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 (
    919, 
    918, 
    924, 
    922, 
    921, 
    925, 
    525, 
    917, 
    916, 
    955, 
    942, 
    941, 
    446, 
    953, 
    952, 
    951, 
    949, 
    948, 
    947, 
    946, 
    945, 
    944, 
    982, 
    980, 
    979, 
    978, 
    981, 
    478, 
    977, 
    975, 
    974, 
    973, 
    972, 
    971, 
    970, 
    994, 
    996, 
    493, 
    985, 
    986, 
    988, 
    990, 
    991, 
    993, 
    1003, 
    1001, 
    1000, 
    508, 
    1322, 
    1262, 
    1317, 
    1318, 
    1319, 
    1320, 
    1321, 
    1256, 
    1395, 
    1396, 
    1397, 
    1399, 
    1406, 
    1407, 
    1408, 
    1409, 
    1410, 
    1411, 
    1412, 
    1273, 
    1425, 
    1427, 
    1428, 
    1429, 
    1431, 
    1266, 
    1442, 
    1447, 
    1263, 
    1458, 
    2467, 
    2468, 
    2469, 
    2470, 
    2471, 
    2472, 
    2478, 
    2483, 
    2482, 
    2484, 
    2485, 
    2486, 
    2487, 
    2488, 
    2489, 
    2490, 
    2491, 
    2492, 
    2493, 
    2494, 
    2495, 
    2496, 
    2497, 
    2524, 
    2525, 
    2526, 
    2527, 
    2528, 
    2529, 
    2530, 
    2531, 
    2576, 
    2577, 
    2578, 
    2615, 
    2620, 
    2621, 
    4526, 
    4527, 
    4528, 
    4529, 
    4530, 
    4532, 
    4533, 
    5727, 
    5729, 
    5730, 
    5731, 
    5732, 
    5733, 
    5734, 
    5735, 
    5736, 
    5739, 
    5741, 
    5742, 
    5743, 
    5744, 
    5745, 
    5746, 
    5747, 
    5748, 
    5749, 
    5750, 
    5752, 
    5753, 
    5754, 
    5755, 
    5756, 
    5757, 
    5758, 
    5759, 
    5760, 
    5761, 
    5762, 
    7004, 
    7005, 
    7006, 
    7007, 
    7008, 
    7009, 
    7010, 
    7011, 
    7012, 
    7013, 
    7014, 
    7015, 
    10284, 
    10285, 
    10286, 
    10287, 
    10288, 
    10289, 
    10290, 
    10291, 
    10292, 
    10293
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00681

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "123.86"
    },
    "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": 178,
      "rows_produced_per_join": 178,
      "filtered": "100.00",
      "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`object_id` in (919,918,924,922,921,925,525,917,916,955,942,941,446,953,952,951,949,948,947,946,945,944,982,980,979,978,981,478,977,975,974,973,972,971,970,994,996,493,985,986,988,990,991,993,1003,1001,1000,508,1322,1262,1317,1318,1319,1320,1321,1256,1395,1396,1397,1399,1406,1407,1408,1409,1410,1411,1412,1273,1425,1427,1428,1429,1431,1266,1442,1447,1263,1458,2467,2468,2469,2470,2471,2472,2478,2483,2482,2484,2485,2486,2487,2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2524,2525,2526,2527,2528,2529,2530,2531,2576,2577,2578,2615,2620,2621,4526,4527,4528,4529,4530,4532,4533,5727,5729,5730,5731,5732,5733,5734,5735,5736,5739,5741,5742,5743,5744,5745,5746,5747,5748,5749,5750,5752,5753,5754,5755,5756,5757,5758,5759,5760,5761,5762,7004,7005,7006,7007,7008,7009,7010,7011,7012,7013,7014,7015,10284,10285,10286,10287,10288,10289,10290,10291,10292,10293)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`type` = 'p') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`dispatch` = '') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "106.06",
        "eval_cost": "17.80",
        "prefix_cost": "123.86",
        "data_read_per_join": "301K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
446 apple-iphone-16-pro-en-8 166/234/235
478 iphone-16 166/234/235
493 apple-iphone-16-plus-en 166/234/235
508 apple-iphone-16e 166/234/235
525 apple-iphone-16-pro-max 166/234/235
916 apple-iphone-16-pro-max-en-10 166/234/235
917 apple-iphone-16-pro-max-en-11 166/234/235
918 apple-iphone-16-pro-max-en 166/234/235
919 apple-iphone-16-pro-max-en-2 166/234/235
921 apple-iphone-16-pro-max-en-4 166/234/235
922 apple-iphone-16-pro-max-en-5 166/234/235
924 apple-iphone-16-pro-max-en-7 166/234/235
925 apple-iphone-16-pro-max-en-8 166/234/235
941 apple-iphone-16-pro-en 166/234/235
942 apple-iphone-16-pro-en-2 166/234/235
944 apple-iphone-16-pro 166/234/235
945 apple-iphone-16-pro-en-13 166/234/235
946 apple-iphone-16-pro-en-14 166/234/235
947 apple-iphone-16-pro-en-15 166/234/235
948 apple-iphone-16-pro-en-12 166/234/235
949 apple-iphone-16-pro-en-11 166/234/235
951 apple-iphone-16-pro-en-9 166/234/235
952 apple-iphone-16-pro-en-4 166/234/235
953 apple-iphone-16-pro-en-7 166/234/235
955 apple-iphone-16-pro-en-5 166/234/235
970 apple-iphone-16 166/234/235
971 apple-iphone-16-en 166/234/235
972 apple-iphone-16-en-2 166/234/235
973 apple-iphone-16-en-3 166/234/235
974 apple-iphone-16-en-4 166/234/235
975 apple-iphone-16-en-5 166/234/235
977 apple-iphone-16-en-13 166/234/235
978 apple-iphone-16-en-9 166/234/235
979 apple-iphone-16-en-10 166/234/235
980 apple-iphone-16-en-11 166/234/235
981 apple-iphone-16-en-8 166/234/235
982 apple-iphone-16-en-7 166/234/235
985 apple-iphone-16-plus 166/234/235
986 apple-iphone-16-plus-en-2 166/234/235
988 apple-iphone-16-plus-en-14 166/234/235
990 apple-iphone-16-plus-en-4 166/234/235
991 apple-iphone-16-plus-en-5 166/234/235
993 apple-iphone-16-plus-en-7 166/234/235
994 apple-iphone-16-plus-en-8 166/234/235
996 apple-iphone-16-plus-en-10 166/234/235
1000 apple-iphone-16e-en-4 166/234/235
1001 apple-iphone-16e-en 166/234/235
1003 apple-iphone-16e-en-3 166/234/235
1256 galaxy-a06 166/234/326
1262 galaxy-a56-5g-en-5 166/234/326
1263 galaxy-s24 166/234/326
1266 galaxy-s24-ultra 166/234/326
1273 galaxy-z-fold6 166/234/326
1317 galaxy-a56-5g-en 166/234/326
1318 galaxy-a56-5g-en-3 166/234/326
1319 galaxy-a56-5g 166/234/326
1320 galaxy-a56-5g-en-4 166/234/326
1321 galaxy-a56-5g-en-2 166/234/326
1322 samsung-galaxy-a56-5g 166/234/326
1395 galaxy-a06-en-2 166/234/326
1396 galaxy-a06-en-3 166/234/326
1397 galaxy-a06-en-6 166/234/326
1399 galaxy-a06-en-5 166/234/326
1406 galaxy-s24-fe 166/234/326
1407 samsung-galaxy-s24-fe-en 166
1408 galaxy-s24-fe-en 166
1409 galaxy-s24-fe-en-2 166
1410 galaxy-s24-fe-en-3 166
1411 galaxy-s24-fe-en-4 166
1412 galaxy-s24-fe-en-5 166
1425 galaxy-a55-5g-en-3 166
1427 galaxy-a55-5g-en-2 166
1428 galaxy-a55-5g 166/234/326
1429 galaxy-a55-5g-en-4 166
1431 galaxy-a55-5g-en-6 166
1442 galaxy-s24-ultra-en 166
1447 galaxy-s24-ultra-en-6 166
1458 galaxy-s24-en-6 166
2467 xiaomi-15-ultra-en-3 166
2468 xiaomi-15-ultra-en-4 166
2469 xiaomi-15-ultra-en-6 166
2470 xiaomi-15-ultra-en-2 166
2471 xiaomi-15-ultra-en 166/234/236
2472 xiaomi-15-ultra-en-5 166
2478 xiaomi-14t-pro 166/234/236
2482 xiaomi-14t-pro-en-6 166/234
2483 xiaomi-14t-pro-en-5 166/234
2484 xiaomi-14t-pro-en-8 166/234
2485 xiaomi-14t-pro-en-3 166/234
2486 xiaomi-14t-pro-en-2 166/234
2487 xiaomi-14t-pro-en-7 166/234
2488 xiaomi-14t-pro-en-4 166/234
2489 xiaomi-14t-pro-en 166/234
2490 xiaomi-14t 166/234/236
2491 xiaomi-14t-en-2 166/234
2492 xiaomi-14t-en-3 166/234
2493 xiaomi-14t-en-6 166/234
2494 xiaomi-14t-en-7 166/234
2495 xiaomi-14t-en-4 166/234
2496 xiaomi-14t-en-5 166/234
2497 xiaomi-14t-en 166/234
2524 xiaomi-redmi-a5-en-4 166
2525 xiaomi-redmi-a5-en 166
2526 xiaomi-redmi-a5-en-3 166
2527 xiaomi-redmi-a5 166/234/236
2528 xiaomi-redmi-a5-en-5 166
2529 xiaomi-redmi-a5-en-7 166
2530 xiaomi-redmi-a5-en-2 166
2531 xiaomi-redmi-a5-en-6 166
2576 xiaomi-poco-m7-pro-5g 166/234/236
2577 xiaomi-poco-m7-pro-5g-en 166
2578 xiaomi-poco-m7-pro-5g-en-2 166
2615 xiaomi-poco-c61-en 166/234
2620 xiaomi-poco-c61 166/234/236
2621 xiaomi-poco-c61-en-2 166/234
4526 samsung-galaxy-s25-ultra-en 166/234/326
4527 samsung-galaxy-s25-ultra-en-4 166
4528 samsung-galaxy-s25-ultra-en-3 166
4529 samsung-galaxy-s25-ultra-en-2 166
4530 samsung-galaxy-s25-ultra-en-8 166
4532 samsung-galaxy-s25-ultra-en-6 166
4533 samsung-galaxy-s25-ultra-en-5 166
5727 apple-iphone-17-pro 166/234/235
5729 apple-iphone-17-pro-en-4 166
5730 apple-iphone-17-pro-en-6 166
5731 apple-iphone-17-pro-en-5 166
5732 apple-iphone-17-pro-en-2 166
5733 apple-iphone-17-pro-en 166
5734 apple-iphone-17-pro-en-3 166
5735 apple-iphone-17-pro-en-7 166
5736 apple-iphone-17-pro-en-8 166
5739 apple-iphone-17-pro-clone 166/234/235
5741 apple-iphone-17-en-4 166
5742 apple-iphone-17-en-7 166
5743 apple-iphone-17-en 166
5744 apple-iphone-17-en-3 166
5745 apple-iphone-17-en-5 166
5746 apple-iphone-17-en-6 166
5747 apple-iphone-17-en-8 166
5748 apple-iphone-17 166
5749 apple-iphone-17-en-2 166
5750 apple-iphone-17-clone 166/234/235
5752 apple-iphone-air-en-3 166
5753 apple-iphone-air-en-4 166
5754 apple-iphone-air-en-5 166
5755 apple-iphone-air-en 166
5756 apple-iphone-air 166
5757 apple-iphone-air-en-2 166
5758 apple-iphone-air-en-6 166
5759 apple-iphone-air-en-7 166
5760 apple-iphone-air-en-8 166
5761 apple-iphone-air-en-9 166
5762 apple-iphone-air-en-10 166
7004 apple-iphone-17-pro-max-en-11 166/234/235
7005 apple-iphone-17-pro-max-en-5 166/234/235
7006 apple-iphone-17-pro-max-en-6 166/234/235
7007 apple-iphone-17-pro-max-en-7 166/234/235
7008 apple-iphone-17-pro-max-en-8 166/234/235
7009 apple-iphone-17-pro-max-en 166/234/235
7010 apple-iphone-17-pro-max-en-2 166/234/235
7011 apple-iphone-17-pro-max-en-3 166/234/235
7012 apple-iphone-17-pro-max-en-4 166/234/235
7013 apple-iphone-17-pro-max 166/234/235
7014 apple-iphone-17-pro-max-en-10 166/234/235
7015 apple-iphone-17-pro-max-en-9 166/234/235
10284 apple-iphone-15 166/234/235
10285 apple-iphone-15-en-9 166/234/235
10286 apple-iphone-15-en 166/234/235
10287 apple-iphone-15-en-2 166/234/235
10288 apple-iphone-15-en-3 166/234/235
10289 apple-iphone-15-en-4 166/234/235
10290 apple-iphone-15-en-5 166/234/235
10291 apple-iphone-15-en-6 166/234/235
10292 apple-iphone-15-en-7 166/234/235
10293 apple-iphone-15-en-8 166/234/235