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 (
    3728, 
    3852, 
    3536, 
    3850, 
    3731, 
    3101, 
    3167, 
    3769, 
    3642, 
    3745, 
    3943, 
    3623, 
    3750, 
    3830, 
    3592, 
    3670, 
    3684, 
    3600, 
    3874, 
    3645, 
    3365, 
    3437, 
    3637, 
    3682, 
    3767, 
    3950, 
    6074, 
    3879, 
    3753, 
    6072, 
    2952, 
    3230, 
    3108, 
    3303, 
    3376, 
    3644, 
    3659, 
    3766, 
    3864, 
    3940, 
    3412, 
    3436, 
    3739, 
    3444, 
    3554, 
    5104, 
    3103, 
    3530, 
    3785, 
    3442, 
    3787, 
    3945, 
    3438, 
    3770, 
    3865, 
    3545, 
    6117, 
    3447, 
    3555, 
    3793, 
    3450, 
    6094, 
    3772, 
    3795, 
    5895, 
    3788, 
    5868, 
    3439, 
    3446, 
    3687, 
    3860, 
    8362, 
    3794, 
    3858, 
    3869, 
    3948, 
    3449, 
    3941, 
    6068, 
    3871, 
    3786, 
    3853, 
    3857, 
    3863, 
    3867, 
    3951, 
    3862, 
    5812, 
    3854, 
    3949, 
    5978, 
    3727, 
    6097, 
    3699, 
    3881, 
    3855, 
    3859, 
    6077, 
    6828, 
    5105, 
    6063, 
    6830, 
    8812, 
    8439, 
    6163, 
    8604, 
    6076, 
    8589, 
    8699, 
    6096, 
    8612, 
    10249, 
    6853, 
    6073, 
    6826, 
    8702, 
    8701, 
    6161, 
    8464, 
    8469, 
    10025, 
    7807, 
    8708, 
    6827, 
    8804, 
    6061, 
    6829, 
    8275, 
    8724, 
    10058, 
    6062, 
    6854, 
    8445, 
    10239, 
    10474, 
    6060, 
    7823, 
    7838, 
    8435, 
    8801, 
    7827, 
    6821, 
    8811, 
    7829, 
    7811, 
    8441, 
    8446, 
    7866, 
    10103, 
    6852, 
    7841, 
    8440, 
    8593, 
    8595, 
    8444, 
    8471, 
    8594, 
    6850, 
    6855, 
    7861
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'ar'

Query time 0.00449

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "117.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": 173,
      "rows_produced_per_join": 173,
      "filtered": "100.00",
      "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`object_id` in (3728,3852,3536,3850,3731,3101,3167,3769,3642,3745,3943,3623,3750,3830,3592,3670,3684,3600,3874,3645,3365,3437,3637,3682,3767,3950,6074,3879,3753,6072,2952,3230,3108,3303,3376,3644,3659,3766,3864,3940,3412,3436,3739,3444,3554,5104,3103,3530,3785,3442,3787,3945,3438,3770,3865,3545,6117,3447,3555,3793,3450,6094,3772,3795,5895,3788,5868,3439,3446,3687,3860,8362,3794,3858,3869,3948,3449,3941,6068,3871,3786,3853,3857,3863,3867,3951,3862,5812,3854,3949,5978,3727,6097,3699,3881,3855,3859,6077,6828,5105,6063,6830,8812,8439,6163,8604,6076,8589,8699,6096,8612,10249,6853,6073,6826,8702,8701,6161,8464,8469,10025,7807,8708,6827,8804,6061,6829,8275,8724,10058,6062,6854,8445,10239,10474,6060,7823,7838,8435,8801,7827,6821,8811,7829,7811,8441,8446,7866,10103,6852,7841,8440,8593,8595,8444,8471,8594,6850,6855,7861)) 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` = 'ar'))",
      "cost_info": {
        "read_cost": "100.56",
        "eval_cost": "17.30",
        "prefix_cost": "117.86",
        "data_read_per_join": "293K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
2952 anker-magsafe-car-charger-15w-qi2-with-360-phone-holder 166
3101 anker-powerexpand-7-in-1-usb-c-pd-media-hub-gray-ar 166
3103 anker-magnetic-wireless-charger-maggo-613-car-charging-mount-with-2-port-usb-ar 166
3108 anker-stand-with-qc-3-0-charger-10-w-white-ar 166/423/424/492
3167 anker-car-charger-67w-2c1a-with-3ft-c-to-c-cable-ar 166
3230 belkin-boostcharge-usb-c-to-usb-c-braided-cable-240w-pd-48v5a-2m-black-ar 166
3303 belkin-usb4-cable-usb-c-to-usb-c-240w-20gbps-2m-cable-4k-60hz-resolution-ar 166
3365 belkin-quick-charge-car-charger-with-usb-a-to-usb-c-cable-1-2m-black-ar 166
3376 belkin-boostcharge-pro-wireless-charging-qi2-15w20w-usb-c-pd-3-0-car-power-supply1-2m-c-cable-15w-ar 166
3412 belkin-boostcharge-pro-108w-4-ports-gan-charger-2m-cable-ar 166
3436 baykron-wall-charger-gan-33-eu-plug-ar 166/423/424/451
3437 baykron-wall-charger-gan-65-uk-plug-ar 166/423/424/451
3438 baykron-wall-charger-gan-65-eu-plug-ar 166/423/424/451
3439 baykron-screen-protector-clear-edge-to-edge-and-antibacterial-with-applicator-for-iphone-14-expected-to-be-compatible-with-iphone-13-13-pro-ar 166/423/448
3442 baykron-screen-protector-privacy-edge-to-edge-and-antibacterial-with-applicator-for-iphone-14-pro-max-ar 166/423/448
3444 baykron-screen-protector-privacy-edge-to-edge-and-antibacterial-with-applicator-for-iphone-14-expected-to-be-compatible-with-iphone-13-13-pro-ar 166/423/448
3446 baykron-screen-protector-privacy-edge-to-edge-and-antibacterial-with-applicator-for-iphone-14-pro-ar 166/423/448
3447 baykron-screen-protector-privacy-edge-to-edge-and-antibacterial-with-applicator-for-iphone-14-max-expected-to-be-compatible-with-iphone-13-pro-max-ar 166/423/448
3449 baykron-screen-protector-clear-edge-to-edge-and-antibacterial-with-applicator-for-iphone-13-13-pro-ar 166/423/448
3450 baykron-screen-protector-clear-edge-to-edge-and-antibacterial-with-applicator-for-iphone-13-pro-max-ar 166/423/448
3530 belkin-boostcharge-dual-usb-a-car-charger-24w-12w-ar 166
3536 belkin-pd-25w-pps-usb-c-wall-charger-wh-1m-c-c-cable-ar 166
3545 belkin-usb-c-to-usb-c-silicone-black-and-white-60w-ar 166
3554 belkin-3-port-usb-c-wall-charger-with-pps-67w-ar 166
3555 belkin-45w-dual-usb-c-gan-wall-charger-with-pps-white-ar 166
3592 belkin-3-port-usb-c-wall-charger-with-pps-67w-usb-c-to-usb-c-cable-ar 166
3600 belkin-magnetic-wireless-cake-stand-black-ar 166/423/424/492
3623 baykron-tough-clear-magsafe-compatible-antibacterial-and-anti-yellow-for-iphone-14-pro-ar 166/423/449
3637 baykron-tough-clear-magsafe-compatible-antibacterial-and-anti-yellow-for-iphone-14-max-ar 166/423/449
3642 baykron-tough-clear-antibacterial-and-anti-yellow-case-for-iphone-14-pro-ar 166/423/449
3644 baykron-tough-clear-antibacterial-and-anti-yellow-case-for-iphone-14-max-ar 166/423/449
3645 baykron-tough-clear-antibacterial-and-anti-yellow-case-for-iphone-14-pro-max-ar 166/423/449
3659 baykron-screen-protector-anti-blue-edge-to-edge-and-antibacterial-with-applicator-for-iphone-13-13-pro-ar 166/423/448
3670 baykron-usb-cable-type-c-to-lightning-mfi-2m-black-ar 166/423/424/450
3682 baykron-usb-type-c-to-type-c-cable-1-2m-3a-black-ar 166/423/424/450
3684 baykron-usb-a-to-type-c-cable-1-2m-black-ar 166/423/424/450
3687 baykron-usb-to-micro-usb-cable-1-2m-black-ar 166/423/424/450
3699 usb-a-to-micro-usb-cable-2a-1-2-meter-tpu-black-ar 166/423/424/450
3727 baykron-3-5mm-jack-to-3-5mm-jack-cable-1-2m-tpu-black-ar 166/423/424/450
3728 baykron-tough-clear-antibacterial-and-anti-yellow-case-for-iphone-13-ar-2 166/423/449
3731 baykron-silicone-antibacterial-black-color-protective-case-for-iphone-13-ar 166/423/449
3739 baykron-screen-protector-privacy-with-applicator-for-iphone-13-13-pro-ar 166/423/448
3745 baykron-2d-screen-protector-including-applicator-for-iphone-12-12-pro-ar 166/423/448
3750 belkin-3-in-1-wireless-charger-with-magsafe-15w-ar 166/423/424/492
3753 belkin-boostcharge-pro-3-in-1-wireless-charger-with-magsafe-15w-black-ar 166
3766 baykron-privacy-screen-protector-including-applicator-for-iphone-12-12-pro-ar 166/423/448
3767 baykron-privacy-screen-protector-including-applicator-for-iphone-12-pro-max-ar 166/423/448
3769 baykron-edge-to-edge-screen-protector-including-applicator-for-iphone-12-pro-max-ar 166/423/448
3770 baykron-2d-antibacterial-clear-temperd-glass-iphone-12-mini-ar 166/423/448
3772 baykron-3d-antibacterial-tempered-glass-for-iphone-12-mini-ar 166/423/448
3785 baykron-antibacterial-privacy-tempered-glass-for-iphone-12-mini-ar 166/423/448
3786 baykron-2d-antibacterial-clear-tempered-glass-for-iphone-12-iphone-12-pro-ar 166/423/448
3787 baykron-3d-antibacterial-tempered-glass-for-iphone-12-iphone-12-pro-ar 166/423/448
3788 baykron-antibacterial-privacy-tempered-glass-for-iphone-12-iphone-12-pro-ar 166/423/448
3793 baykron-2d-antibacterial-clear-tempered-glass-for-iphone-12-pro-max-ar 166/423/448
3794 baykron-3d-antibacterial-tempered-glass-for-iphone-12-pro-max-ar 166/423/448
3795 baykron-antibacterial-privacy-tempered-glass-for-iphone-12-pro-max-ar 166/423/448
3830 belkin-boost-charge-25w-wall-chargers-with-pps-usb-c-power-delivery-white-ar 166
3850 baykron-tough-crystal-clear-anti-yellow-case-for-iphone-13-ar 166/423/449
3852 baykron-tough-crystal-clear-anti-yellow-case-for-iphone-13-pro-max-ar 166/423
3853 baykron-12w-wall-charger-with-dual-usb-ports-total-power-2-4a-uk-black-ar 166/423/424/451
3854 baykron-20w-power-delivery-usb-c-wall-charger-uk-black-ar 166/423/424/451
3855 baykron-36w-fast-charging-dual-port-wall-charger-with-type-c-power-delivery-20w-qc3-0-uk-black-ar 166/423/424/451
3857 baykron-12w-wall-charger-with-dual-usb-ports-total-power-2-4a-eu-black-ar 166/423/424/451
3858 baykron-20w-power-delivery-usb-c-wall-charger-eu-black-ar 166/423/424/451
3859 baykron-36w-fast-charging-dual-port-wall-charger-with-type-c-power-delivery-20w-qc3-0-eu-black-ar 166/423/424/451
3860 baykron-2-4a-car-charger-with-dual-usb-ports-ar 166/423/424/451
3862 baykron-36w-car-charger-with-qc3-0-and-usb-type-c-power-delivery-20w-ar 166/423/424/451
3863 baykron-car-charger-with-2-usb-3-0-a-and-usb-type-c-power-delivery-20w-ar 166/423/424/451
3864 baykron-tough-transparent-case-designed-for-magsafe-iphone-12-mini-ar 166/423/449
3865 baykron-tough-transparent-antibacterial-case-iphone-12-mini-ar 166/423/449
3867 baykron-screen-protector-high-aluminium-tempered-glass-2-5d-hd-clear-with-applicator-for-iphone-15-pro-ar 166/423/448
3869 baykron-screen-protector-high-aluminium-tempered-glass-2-5d-hd-clear-with-applicator-for-iphone-15-pro-max-ar 166/423/449
3871 baykron-screen-protector-high-aluminium-tempered-glass-2-5d-hd-privacy-with-applicator-for-iphone-15-pro-ar 166/423/448
3874 belkin-pd-25w-usb-c-chgr-1m-pvc-c-ltg-cable-wht-ar 166
3879 belkin-fast-wireless-charging-stand-10w-speaker-black-ar 166/423/424/492
3881 baykron-screen-protector-high-aluminium-tempered-glass-2-5d-hd-privacy-with-applicator-for-iphone-15-pro-max-ar 166/423/448
3940 baykron-slim-bumper-protection-and-finger-print-resistant-clear-for-iphone-15-pro-ar 166/423/449
3941 baykron-slim-bumper-protection-and-finger-print-resistant-clear-for-iphone-15-pro-max-ar 166/423/449
3943 baykron-slim-bumper-protection-and-finger-print-resistant-clear-magsafe-for-iphone-15-pro-max-ar 166/423/449
3945 baykron-premium-3-in-1-magnetic-wireless-charger-magsafe-compatible-with-2m-usb-c-cable-and-eu-adapter-white-ar 166
3948 baykron-4-in-1-package-casescreencamera-lensring-for-iphone-15-pro-ar 166/423/449
3949 baykron-4-in-1-package-casescreencamera-lensring-for-iphone-15-pro-max-ar 166/423/449
3950 baykron-3-in-1-package-case-screen-protector-camera-lens-magsafe-for-iphone-15-pro-ar 166/423/449
3951 بايكرون-باكدج-٣-في-١-غطاء-واقي-شاشة-عدسة-كاميرا-ماجسيف-لهاتف-آيفون-15-برو 166/423/449
5104 فيليبس-شاحن-جداري-30w-موديل-dlp5312cw-أبيض-clone 166
5105 فيليبس-شاحن-جداري-30w-مع-كابل-c-c-موديل-dlp5312nb-أسود-clone 166
5812 iphone-15-clear-case-with-magsafe-ar 166/423/449
5868 lightning-to-vga-adapter-ar 166/423/424/426
5895 apple-60w-megasafe-power-adapter-3-pin-ar 166
5978 46mm-magnetic-link-ar 166/423/585
6060 apple-96w-usb-c-power-adapter-ar 166/423/424/451
6061 70w-usb-c-power-adapter-ar 166/423/424/451
6062 140w-usb-c-power-adapter-ar 166/423/424/451
6063 41mm-sport-band-ar 166/423/585
6068 iphone-15-pro-silicone-case-with-magsafe-ar 166/423/449
6072 41mm-leather-link-ar 166/423/585
6073 smart-folio-for-ipad-pro-12-9-inch-6th-generation-ar 166/423/449
6074 iphone-15-silicone-case-with-magsafe-ar 166/423/449
6076 45mm-sport-band-regular-ar 166/423/585
6077 41mm-sport-band-regular-ar 166/423/585
6094 45mm-nike-sport-band-regular-ar 166/423/585
6096 41mm-nike-sport-band-regular-ar 166/423/585
6097 apple-iphone-leather-wallet-with-magsafe-ar 166/423/449
6117 apple-smart-cover-for-ipad-7th-and-ipad-air-3rd-gen-ar 166/423/449
6161 usb-c-to-3-5-mm-headphone-jack-adapter-ar 166/423/424/426
6163 thunderbolt-3-usb-c-cable-0-8m-ar 166/423/424/450
6821 acefast-cable-usb-c-to-mini-jack-3-5mm-1-2m-black-ar 166/423/424/450
6826 acefast-d19-magnetic-car-holder-for-the-cockpit-black-ar 166/423
6827 acefast-d28-car-dashboard-holder-with-flexible-arm-for-phones-4-5-6-7-black-ar 166/423
6828 acefast-d29-magnetic-dashboard-mount-with-magsafe-black-ar 166/423
6829 acefast-d35-center-console-magnetic-car-holder-black-ar 166/423
6830 acefast-d36-magnetic-car-holder-for-dashboard-ar 166/423
6850 acefast-15w-magsafe-magnetic-charging-car-dashboard-holder-black-ar 166/423/424/492
6852 acefast-d43-magnetic-car-holder-for-dashboard-screen-ar-2 166/423/424/492
6853 acefast-d54-magnetic-car-mount-holder-quick-phone-mount-ar 166/423/424/492
6854 acefast-d55-magnetic-car-holder-for-dashboard-ar 166/423/424/492
6855 acefast-e23-magnetic-phone-holder-black-ar 166/423/424/492
7807 1hora-2-1a-ip-usb-cable-white-ar 166/423/424/450
7811 1hora-v8-series-type-c-usb-cable-ar 166/423/424/450
7823 1hora-usb-light-2-1a-cable-1m-white-ar 166/423/424/450
7827 1hora-v8-series-type-c-usb-2-1a-cable-1m-black-ar 166/423/424/450
7829 1hora-v8-series-type-c-usb-2-1a-cable-2m-ar 166/423/424/450
7838 1hora-v8-series-type-c-usb-2-1a-cable-1m-ar 166/423/424/450
7841 1hora-v8-series-type-c-usb-2-1a-cable-2m-ar-2 166/423/424/450
7861 1hora-2-4a-braided-usb-lightning-cable-red-ar 166/423/424/450
7866 1hora-type-c-to-type-c-3a-cable-1m-ar 166/423/424/450
8275 hama-118107-fix-tv-wall-bracket-1-star-600x400-191-cm-75-black-pack-of-1-ar 166/423
8362 hama-spot-pointer-v2-presenter-dig-laser-pointer-spot-illumination-magnifi-139919-ar 250/380
8435 hama-188301-magnet-vent-universal-smartphone-holder-black-ar 166/423/657
8439 xiaomi-focus-pen-ar 166/423/477
8440 hama-227003-th-fold-cl-ipad-air13-2024-flieder-ar 166/423/449
8441 hama-227040-fold-clear-folio-case-for-apple-ipad-pro-11-2024-pink-ar 166/423/449
8444 hama-222086-fold-clear-folio-case-for-apple-ipad-pro-13-2024-dark-blue-ar 166/423/449
8445 hama-fold-clear-tablet-case-for-apple-ipad-air-13-2024-dark-blue-ar 166/423/449
8446 hama-fold-clear-tablet-case-for-apple-ipad-pro-11-2024-lilac-ar 166/423/449
8464 hama-fold-clear-tablet-case-for-apple-ipad-pro-13-2025-2024-black-227043-ar 166/423/449
8469 hama-222088-fold-clear-tablet-case-for-apple-ipad-air-11-2024-dark-blue-ar 166/423/449
8471 hama-227045-fold-clear-tablet-case-for-apple-ipad-pro-13-2024-green-ar 166/423/449
8589 hama-4315-fun-70-selfie-bluetooth-stick-black-ar 166/423
8593 hama-217223-fold-clear-tablet-case-for-apple-ipad-10-9-10th-gen-2022-dark-blue-ar 166/423/449
8594 hama-217224-fold-clear-tablet-case-for-apple-ipad-10-9-10th-gen-2022-lilac-ar 166/423/449
8595 hama-217226-fold-clear-tablet-case-for-apple-ipad-10-9-10th-gen-2022-coral-ar 166/423/449
8604 hama-12307-8-in-1-universal-remote-control-black-ar 166/423
8612 hama-136019-case-for-apple-iphone-15-pro-transparent-ar 166/423/449
8699 hama-220832-fullmotion-tv-wall-bracket-32-65-black-ar 166/423
8701 hama-220874-trolley-tv-stand-up-to-75-black-ar 166/423
8702 hama-220875-trolley-tv-stand-with-castors-max-weight-80-kg-black-ar 166/423
8708 hama-139991-c-400-pc-webcam-1080p-ar 166/423/520
8724 hama-123762-daily-protect-mobile-phone-bag-for-iphone-16-pro-black-ar 166/423/449
8801 hama-178257-universal-smartphone-holder-ar 166/423/657
8804 hama-220831-fullmotion-tv-wall-bracket-3284-ar 166/423
8811 hama-123749-always-clear-case-for-iphone16-transparent-ar 166/423/449
8812 hama-200322-usbc-network-adapter-gigabit-ethernet-ar 166/328/543/567
10025 redmi-pad-se-cover-white-ar 166/423/449
10058 xiaomi-watch-white-leather-strap-ar 166/423/585
10103 mi-smart-band-4-charging-cable-ar 166/423/424
10239 xiaomi-mi-selfie-stick-tripod-black-ar 166/423
10249 xiaomi-smart-band-pendant-silver-ar 166/423
10474 hausberg-hbh02f-universal-tv-wall-mount-bracket-for-secure-viewing-ar 166/423