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 (
    3925, 
    2807, 
    3415, 
    2612, 
    3077, 
    3409, 
    3411, 
    3413, 
    3550, 
    3878, 
    3515, 
    3875, 
    2926, 
    3748, 
    3128, 
    2543, 
    3288, 
    3035, 
    3220, 
    3410, 
    3599, 
    5107, 
    6112, 
    3043, 
    3880, 
    2429, 
    3805, 
    2921, 
    3095, 
    3524, 
    3742, 
    3668, 
    3044, 
    3168, 
    3527, 
    3535, 
    3360, 
    3702, 
    3536, 
    3101, 
    3167, 
    3750, 
    3830, 
    3592, 
    3670, 
    3684, 
    3600, 
    3874, 
    3365, 
    3437, 
    3682, 
    3879, 
    3753, 
    2952, 
    3230, 
    3108, 
    3303, 
    3376, 
    3412, 
    3436, 
    3554, 
    5104, 
    3103, 
    3530, 
    3945, 
    3438, 
    3545, 
    3555, 
    5895, 
    5868, 
    3687, 
    3860, 
    3858, 
    3853, 
    3857, 
    3863, 
    3862, 
    3854, 
    3727, 
    3699, 
    3855, 
    3859, 
    5105, 
    8812, 
    6163, 
    6853, 
    6161, 
    7807, 
    6062, 
    6854, 
    6060, 
    6061, 
    7823, 
    7838, 
    7827, 
    6821, 
    7829, 
    7811, 
    7866, 
    10103, 
    6852, 
    7841, 
    6850, 
    6855, 
    7856, 
    7861, 
    10160, 
    7863, 
    7840, 
    7812, 
    7855, 
    7860, 
    7868, 
    7869, 
    7870, 
    10242, 
    7813, 
    7825, 
    8242, 
    8373, 
    8517, 
    8700, 
    10246, 
    7837, 
    7864, 
    8285, 
    8287, 
    8330, 
    8374, 
    8571, 
    8726, 
    8728, 
    8803, 
    10085, 
    10099, 
    10106, 
    10256, 
    7859, 
    8268, 
    8331, 
    8378, 
    8436, 
    8442, 
    8579, 
    8583, 
    8606, 
    8727, 
    10107, 
    10166, 
    7858, 
    7862, 
    8270, 
    8286, 
    8376, 
    8384, 
    8402, 
    8467, 
    8468, 
    8531, 
    8533
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00451

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "115.61"
    },
    "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": 168,
      "rows_produced_per_join": 168,
      "filtered": "100.00",
      "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`object_id` in (3925,2807,3415,2612,3077,3409,3411,3413,3550,3878,3515,3875,2926,3748,3128,2543,3288,3035,3220,3410,3599,5107,6112,3043,3880,2429,3805,2921,3095,3524,3742,3668,3044,3168,3527,3535,3360,3702,3536,3101,3167,3750,3830,3592,3670,3684,3600,3874,3365,3437,3682,3879,3753,2952,3230,3108,3303,3376,3412,3436,3554,5104,3103,3530,3945,3438,3545,3555,5895,5868,3687,3860,3858,3853,3857,3863,3862,3854,3727,3699,3855,3859,5105,8812,6163,6853,6161,7807,6062,6854,6060,6061,7823,7838,7827,6821,7829,7811,7866,10103,6852,7841,6850,6855,7856,7861,10160,7863,7840,7812,7855,7860,7868,7869,7870,10242,7813,7825,8242,8373,8517,8700,10246,7837,7864,8285,8287,8330,8374,8571,8726,8728,8803,10085,10099,10106,10256,7859,8268,8331,8378,8436,8442,8579,8583,8606,8727,10107,10166,7858,7862,8270,8286,8376,8384,8402,8467,8468,8531,8533)) 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": "98.81",
        "eval_cost": "16.80",
        "prefix_cost": "115.61",
        "data_read_per_join": "284K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
2429 anker-zolo-usb-c-to-c-braided-cable-1m-240w 166
2543 anker-usb-c-display-hub-4-in-1-4k-display-10gbps-100w-pd-in-gray 166
2612 anker-maggo-wireless-charging-station-3-in-1-qi2-15w-black 166
2807 anker-maggo-usb-c-adapter-3-in-1-10gbps-for-iphone-black 166
2921 anker-powerline-iii-flow-c-to-c-cable-100w-6ft-white 166
2926 anker-323-car-charger-52-5w-black 166
2952 anker-magsafe-car-charger-15w-qi2-with-360-phone-holder-en 166
3035 anker-prime-240w-gan-desktop-charger-4-ports-black 166
3043 anker-car-charger-30w-2-ports-black 166
3044 anker-wall-charger-20w-2-ports-with-usb-c-cable-white 166/423/424/492
3077 anker-511-usb-c-charger-nano-pro-20w-black 166
3095 anker-car-charger-2-port-usb-39w-qc3-0 166
3101 anker-powerexpand-7-in-1-usb-c-pd-media-hub-gray 166
3103 anker-magnetic-wireless-charger-maggo-613-car-charging-mount-with-2-port-usb 166
3108 anker-stand-with-qc-3-0-charger-10-w-white 166/423/424/492
3128 anker-20w-ultra-compact-phone-and-tablet-charger-purple 166
3167 anker-car-charger-67w-2c1a-with-3ft-c-to-c-cable 166
3168 anker-maggo-wireless-charger-2-in-1-dock-stand 166/423/424/492
3220 belkin-boostcharge-usb-c-to-usb-c-braided-cable-240w-pd-48v-5a-1m 166
3230 belkin-boostcharge-usb-c-to-usb-c-braided-cable-240w-pd-48v5a-2m-black 166
3288 belkin-3-0-usb-c-to-usb-a-adapter-5gbps-1-5a-black 166
3303 belkin-usb4-cable-usb-c-to-usb-c-240w-20gbps-2m-cable-4k-60hz-resolution 166
3360 belkin-usb-c-to-ethernet-adapter-with-power-delivery-up-to-100w 166
3365 belkin-quick-charge-car-charger-with-usb-a-to-usb-c-cable-1-2m-black 166
3376 belkin-boostcharge-pro-wireless-charging-qi2-15w20w-usb-c-pd-3-0-car-power-supply1-2m-c-cable-15w 166
3409 dviced-wall-charger-30w-gan-1-usb-a-1-usb-c-eu-black 166
3410 belkin-4-port-gan-charger-108w 166
3411 dviced-wall-charger-cable-35w-gan-1-usb-a-1-usb-c-uk-black 166
3412 belkin-boostcharge-pro-108w-4-ports-gan-charger-2m-cable 166
3413 belkin-charge-3-in-1-wireless-charger-for-apple-devices-white 166
3415 dviced-wall-charger-140w-gan-2-usb-c-1-usb-a-uk-black 166
3436 baykron-wall-charger-gan-33-eu-plug 166/423/424/451
3437 baykron-wall-charger-gan-65-uk-plug 166/423/424/451
3438 baykron-wall-charger-gan-65-eu-plug 166/423/424/451
3515 belkin-boostcharge-3-in-1-magnetic-charging-stand-with-qi2-fast-wireless-charging-15w 166
3524 belkin-belkin-boost-charge-flex-usb-c-to-usb-c-silicone-cable-1m 166
3527 belkin-boostcharge-usb-c-wall-charger-20w-1m-usb-c-cable 166
3530 belkin-boostcharge-dual-usb-a-car-charger-24w-12w 166
3535 belkin-pd-30w-pps-usb-c-wall-charger-wht 166
3536 belkin-pd-25w-pps-usb-c-wall-charger-wh-1m-c-c-cable 166
3545 belkin-usb-c-to-usb-c-silicone-black-and-white-60w 166
3550 belkin-cable-usb-c-to-lightning-braided-2m-black-en 166
3554 belkin-3-port-usb-c-wall-charger-with-pps-67w 166
3555 belkin-45w-dual-usb-c-gan-wall-charger-with-pps-white 166
3592 belkin-3-port-usb-c-wall-charger-with-pps-67w-usb-c-to-usb-c-cable 166
3599 belkin-usb-c-gan-universal-laptop-charger-100w 166
3600 belkin-magnetic-wireless-cake-stand-black 166/423/424/492
3668 baykron-usb-to-lightning-cable-1-2-m-mfi-black 166/423/424/450
3670 baykron-usb-cable-type-c-to-lightning-mfi-2m-black 166/423/424/450
3682 baykron-usb-type-c-to-type-c-cable-1-2m-3a-black 166/423/424/450
3684 baykron-usb-a-to-type-c-cable-1-2m-black 166/423/424/450
3687 baykron-usb-to-micro-usb-cable-1-2m-black 166/423/424/450
3699 usb-a-to-micro-usb-cable-2a-1-2-meter-tpu-black 166/423/424/450
3702 baykron-usb-type-c-to-usb-type-c-cable-3a-1-2m-tpu-black 166/423/424/450
3727 baykron-3-5mm-jack-to-3-5mm-jack-cable-1-2m-tpu-black 166/423/424/450
3742 belkin-boost-charge-wireless-car-charger-with-vent-mount-10w 166
3748 belkin-boostcharge-pro-2-in-1-wireless-charger-stand-with-magsafe-15w 166
3750 belkin-3-in-1-wireless-charger-with-magsafe-15w 166/423/424/492
3753 belkin-boostcharge-pro-3-in-1-wireless-charger-with-magsafe-15w-black 166
3805 belkin-braided-usb-c-to-usb-c-cable-1-m-black 166
3830 belkin-boost-charge-25w-wall-chargers-with-pps-usb-c-power-delivery-white 166
3853 baykron-12w-wall-charger-with-dual-usb-ports-total-power-2-4a-uk-black 166/423/424/451
3854 baykron-20w-power-delivery-usb-c-wall-charger-uk-black 166/423/424/451
3855 baykron-36w-fast-charging-dual-port-wall-charger-with-type-c-power-delivery-20w-qc3-0-uk-black 166/423/424/451
3857 baykron-12w-wall-charger-with-dual-usb-ports-total-power-2-4a-eu-black 166/423/424/451
3858 baykron-20w-power-delivery-usb-c-wall-charger-eu-black 166/423/424/451
3859 baykron-36w-fast-charging-dual-port-wall-charger-with-type-c-power-delivery-20w-qc3-0-eu-black 166/423/424/451
3860 baykron-2-4a-car-charger-with-dual-usb-ports 166/423/424/451
3862 baykron-36w-car-charger-with-qc3-0-and-usb-type-c-power-delivery-20w 166/423/424/451
3863 baykron-car-charger-with-2-usb-3-0-a-and-usb-type-c-power-delivery-20w 166/423/424/451
3874 belkin-pd-25w-usb-c-chgr-1m-pvc-c-ltg-cable-wht 166
3875 belkin-cube-wall-charger-45w-pps-bk-1m-c-c-cable-black 166
3878 belkincar-charger-with-4-usb-black 166
3879 belkin-fast-wireless-charging-stand-10w-speaker-black 166/423/424/492
3880 belkin-magnetic-wireless-car-charger-10w 166
3925 tp-link-tl-wn781nd-150mbps-wireless-n-pci-express-adapter 166/423/424/426
3945 baykron-premium-3-in-1-magnetic-wireless-charger-magsafe-compatible-with-2m-usb-c-cable-and-eu-adapter-white 166
5104 philips-wall-charger-30w-dlp5312cw-white-clone 166
5105 philips-wall-charger-30w-with-cable-c-c-dlp5312nb-black-clone 166
5107 philips-wall-charger-100w-dlp6331cw-white-clone 166
5868 lightning-to-vga-adapter 166/423/424/426
5895 apple-60w-megasafe-power-adapter-3-pin 166
6060 apple-96w-usb-c-power-adapter 166/423/424/451
6061 70w-usb-c-power-adapter 166/423/424/451
6062 140w-usb-c-power-adapter 166/423/424/451
6112 apple-thunderbolt-4-usb-c-pro-cable 166/423/424/450
6161 usb-c-to-3-5-mm-headphone-jack-adapter 166/423/424/426
6163 thunderbolt-3-usb-c-cable-0-8m 166/423/424/450
6821 acefast-cable-usb-c-to-mini-jack-3-5mm-1-2m-black 166/423/424/450
6850 acefast-15w-magsafe-magnetic-charging-car-dashboard-holder-black 166/423/424/492
6852 acefast-d43-magnetic-car-holder-for-dashboard-screen-en 166/423/424/492
6853 acefast-d54-magnetic-car-mount-holder-quick-phone-mount 166/423/424/492
6854 acefast-d55-magnetic-car-holder-for-dashboard 166/423/424/492
6855 acefast-e23-magnetic-phone-holder-black 166/423/424/492
7807 1hora-2-1a-ip-usb-cable-white 166/423/424/450
7811 1hora-v8-series-type-c-usb-cable 166/423/424/450
7812 1hora-2-1a-type-c-tpe-cable-1m-black 166/423/424/450
7813 1hora-cto-c-3a-hd-data-cable-1-5m-black 166/423/424/450
7823 1hora-usb-light-2-1a-cable-1m-white 166/423/424/450
7825 1hora-2m-5a-type-c-black-pvc-braided-cable 166/423/424/450
7827 1hora-v8-series-type-c-usb-2-1a-cable-1m-black 166/423/424/450
7829 1hora-v8-series-type-c-usb-2-1a-cable-2m 166/423/424/450
7837 1hora-v8-series-ip-usb-2-1a-cable-2m-white 166/423/424/450
7838 1hora-v8-series-type-c-usb-2-1a-cable-1m 166/423/424/450
7840 1hora-v8-series-micro-usb-2-1a-cable-2m-white 166/423/424/450
7841 1hora-v8-series-type-c-usb-2-1a-cable-2m-en-2 166/423/424/450
7855 1hora-c-to-c-3a-hd-braided-data-cable-2-m-black 166/423/424/450
7856 1hora-type-usb-to-c-5a-braided-cable-1m-black 166/423/424/450
7858 1hora-v8-series-ip-usb-2-1a-cable-1m-white 166/423/424/450
7859 1hora-2-4a-braided-aluminum-alloy-type-c-cable-black 166/423/424/450
7860 1hora-circular-aluminiumabspc-u-safety-hammer-ca 166/423/424
7861 1hora-2-4a-braided-usb-lightning-cable-red 166/423/424/450
7862 1hora-pd20w-circular-aluminiumabspc-c-port-car-c 166/423/424
7863 1hora-3a-usb-to-type-c-cable 166/423/424/450
7864 1hora-mgt-suction-bracket-air-outlet-type-black 166/423/424/492
7866 1hora-type-c-to-type-c-3a-cable-1m 166/423/424/450
7868 1hora-magnetic-bracket-vertical-type-black 166/423/424/492
7869 1hora-1-to-3-retractable-dc-usb-to-micro-lightning-type-c-2-1a-cable 166/423/424/450
7870 1hora-type-c-to-type-c-3a-hd-braided-data-cable-black 166/423/424/450
8242 hama-210564-20w-lightning-car-charging-set-white 166/423/424/451
8268 hama-1-5-m-usb-2-0-usb-a-to-usb-b-cable-black-200602 166/423/424/450
8270 hama-205007-high-speed-hdmi-cable-plugplug-with-ethernet-gold-plated-5-m-black 166/423/424/450
8285 hama-highspeed-hdmi-cable-plug-plug-rotation-gold-plated-ethernet-3-0-m-122111 166/423/424/450
8286 hama-audio-video-cable-3x-rca-plugs-to-3x-rca-plugs-gold-plated-3-m 166/423/424/450
8287 hama-usb-c-to-usb-b-cable-480-mbps-1-5m-black-200642 166/423/424/450
8330 hama-usb-cable-usb-2-0-480-mbit-s-3-00-m 166/423/424/450
8331 hama-audio-optical-fibre-cable-toslink-odt-black-3-m-flexible-durable-with-aramid-fibre-gold-plated-connections 166/423/424/450
8373 hama-200604-usb-2-0-a-to-b-cable-5m-black 166/423/424/450
8374 hama-135723-micro-usb-to-usb-c-2-0-gold-plated-socket-adapter-black 166/423/424/426
8376 hama-high-speed-hdmi-cable-plug-plug-ethernet-1-5m-black-205005 166/423/424/450
8378 hama-fabric-usb-c-to-usb-c-charging-cable-1m-nylon-orange-201727 166/423/424/450
8384 hama-210522-car-charging-kit-usb-c-and-usb-a-pd-qc-30w-with-usb-c-cable-black 166/423/424/451
8402 hama-201728-fabric-charging-cable-usb-c-to-usb-c-1-m-grey 166/423/424/450
8436 hama-183317-car-charger-lightning-30w-turbo-fast-charge-with-1m-cable-white 166/423/424/451
8442 hama-205009-high-speed-hdmi-cable-plug-to-plug-4k-ethernet-gold-plated-10-m 166/423/424/450
8467 hama-183231-12v-car-charger-3a-with-1-5-m-cable-black 166/423/424/451
8468 hama-201726-fabric-usb-c-to-usb-c-charging-cable-1-m-green 166/423/424/450
8517 hama-187274-charging-data-cable-usb-c-to-lightning-3-m-black 166/423/424/450
8531 hama-201697-fc15-wireless-car-charger-15-w-black 166/423/424/492
8533 hama-205143-usb-c-to-usb-a-cable-usb-3-2-gen-1-1-5-m 166/423/424/450
8571 hama-201740-fabric-charging-cable-usb-c-usb-c-100-w-1-5-m-nylon-black 166/423/424/450
8579 hama-201561-reflective-charging-cable-usb-c-lightning-1-5-m-nylon-blue 166/423/424/450
8583 hama-201674-qi-fc15-15w-wireless-charging-pad-charger-black 166/423/424/492
8606 hama-205243-ultra-high-speed-hdmi-cable-certified-plug-to-plug-8k-3-0-m 166/423/424/450
8700 hama-205280-high-speed-hdmi-cable-10-m 166/423/424/450
8726 hama-178400-microusb-to-lightning-adapter-mfi-black 166/423/424/426
8727 hama-187263-fc15-prime-line-induction-charger-2500ma-black 166/423/424/492
8728 hama-187262-qifc15s-wireless-charger-set-15w-anthracite 166/423/424/492
8803 hama-188324-fc10s-fabric-induction-charger-2000ma-black 166/423/424/492
8812 hama-200322-usbc-network-adapter-gigabit-ethernet 166/328/543/567
10085 apple-30w-usb-c-power-adapter 166/423/424/451
10099 xiaomi-magnetic-charging-cable-for-wearables 166/423/424
10103 mi-smart-band-4-charging-cable 166/423/424
10106 xiaomi-mi-20w-wireless-charging-stand 166/423/424/492
10107 xiaomi-mi-37w-dual-port-car-charger 166/423/424
10160 xiaomi-smart-band-7-charging-cable 166/423/424
10166 xiaomi-watch-s1-active-charging-cable 166/423/424/492
10242 xiaomi-mi-usb-type-c-to-type-c-cable-1-5m 166/423/424
10246 xiaomi-mi-watch-charging-dock-black 166/423/424/492
10256 xiaomi-mi-smart-band-5-charging-cable 166/423/424