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 (
    2187, 
    2244, 
    2172, 
    2171, 
    1668, 
    8586, 
    8372, 
    2222, 
    2175, 
    2228, 
    2220, 
    2177, 
    2230, 
    2226, 
    1667, 
    2221, 
    2179, 
    1666, 
    8240, 
    2183, 
    8813, 
    2176, 
    8433, 
    2224, 
    2195, 
    2225, 
    8514, 
    2189, 
    2196, 
    2186, 
    2180, 
    2178, 
    2191, 
    2170, 
    2181, 
    2190, 
    2185, 
    2198, 
    2182, 
    2188, 
    2173, 
    8784, 
    2193, 
    2184, 
    2197, 
    2174, 
    2199, 
    2219, 
    2223, 
    2194, 
    2243, 
    2200, 
    2229, 
    8789, 
    8695, 
    8766, 
    8802, 
    8362, 
    8573, 
    8696, 
    8243, 
    8617, 
    8601, 
    8375, 
    8570, 
    8812, 
    8536, 
    8604, 
    8589, 
    8699, 
    8590, 
    8612, 
    8800, 
    8702, 
    8576, 
    8701, 
    8464, 
    8469, 
    8577, 
    8708, 
    8703, 
    8783, 
    8804, 
    8275, 
    8569, 
    8724, 
    8445, 
    8470, 
    8435, 
    8801, 
    8805, 
    8811, 
    8815, 
    8441, 
    8446, 
    8543, 
    8245, 
    8440, 
    8519, 
    8593, 
    8595, 
    8432, 
    8444, 
    8471, 
    8594, 
    8472, 
    8457, 
    8806, 
    8828, 
    8830, 
    8575, 
    8269, 
    8466, 
    8363, 
    8459, 
    8460, 
    8603, 
    8581, 
    8709, 
    8438, 
    8799, 
    8831, 
    8241, 
    8272, 
    8273, 
    8276, 
    8365, 
    8382, 
    8538, 
    8572, 
    8578, 
    8580, 
    8585, 
    8597, 
    8614, 
    8615, 
    8729, 
    8730, 
    8757, 
    8797, 
    8810, 
    8814, 
    8829, 
    8242, 
    8244, 
    8277, 
    8280, 
    8373, 
    8377, 
    8403, 
    8431, 
    8434, 
    8443, 
    8517, 
    8540, 
    8574, 
    8587, 
    8596, 
    8600, 
    8605
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'ar'

Query time 0.00622

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "112.91"
    },
    "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": 162,
      "rows_produced_per_join": 162,
      "filtered": "100.00",
      "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`object_id` in (2187,2244,2172,2171,1668,8586,8372,2222,2175,2228,2220,2177,2230,2226,1667,2221,2179,1666,8240,2183,8813,2176,8433,2224,2195,2225,8514,2189,2196,2186,2180,2178,2191,2170,2181,2190,2185,2198,2182,2188,2173,8784,2193,2184,2197,2174,2199,2219,2223,2194,2243,2200,2229,8789,8695,8766,8802,8362,8573,8696,8243,8617,8601,8375,8570,8812,8536,8604,8589,8699,8590,8612,8800,8702,8576,8701,8464,8469,8577,8708,8703,8783,8804,8275,8569,8724,8445,8470,8435,8801,8805,8811,8815,8441,8446,8543,8245,8440,8519,8593,8595,8432,8444,8471,8594,8472,8457,8806,8828,8830,8575,8269,8466,8363,8459,8460,8603,8581,8709,8438,8799,8831,8241,8272,8273,8276,8365,8382,8538,8572,8578,8580,8585,8597,8614,8615,8729,8730,8757,8797,8810,8814,8829,8242,8244,8277,8280,8373,8377,8403,8431,8434,8443,8517,8540,8574,8587,8596,8600,8605)) 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": "96.71",
        "eval_cost": "16.20",
        "prefix_cost": "112.91",
        "data_read_per_join": "274K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
1666 hama-139916-x-pointer-6in1-wireless-laser-presenter-ar 250/380
1667 hama-wireless-laser-presenter-x-pointer-139915-ar 250
1668 hama-magcharge-multi-charging-station-187272-ar 166/423/424/492
2170 hama-134960-amw-200-optical-wireless-mouse-3-buttons-anthracite-black-ar 166/350/382
2171 hama-173020-mw-300-v2-optical-3-button-wireless-mouse-usb-receiver-black-ar 166/350/382
2172 hama-173021-mw-300-v2-optical-3-button-wireless-mouse-usb-receiver-blue-ar 166/350/382
2173 hama-173023-mw-300-v2-optical-3-button-wireless-mouse-quiet-usb-receiver-yellow-ar 166/350/382
2174 hama-173022-mw-300-v2-optical-3-button-wireless-mouse-quiet-usb-receiver-red-ar 166/350/382
2175 hama-173026-mw-400-v2-optical-6-button-wireless-mouse-ergonomic-black-ar 166/350/382
2176 hama-173027-mw-400-v2-optical-6-button-wireless-mouse-ergonomic-usb-rec-denim-ar 166/350/382
2177 hama-173028-mw-400-v2-optical-6-button-wireless-mouse-ergonomic-usb-rec-sienna-ar 166/350/382
2178 hama-173032-mw-500-recharge-optical-6-button-wireless-mouse-battery-black-ar 166/350/382
2179 hama-173036-mw-500-recharge-optical-6-button-mouse-ergonomic-creme-white-ar 166/350/382
2180 hama-173035-mw-500-recharge-optical-6-button-mouse-ergonomic-forest-green-ar 166/350/382
2181 hama-173034-mw-500-recharge-optical-6-button-mouse-ergonomic-polar-blue-ar 166/350/382
2182 hama-173033-mw-500-recharge-optical-6-button-mouse-ergonomic-bordeaux-red-ar 166/350/382
2183 hama-182617-mw-650-optical-6-button-multi-device-mouse-with-usb-a-bluetooth-black-ar 166/350/382
2184 hama-d3173069-wkm-750-multi-device-keyboard-mouse-set-wireless-led-blk-qwerty-gulf-ar 166/350/381
2185 hama-d3182685-kmw-600-wireless-mm-kmb-ar 166/350/381
2186 hama-d3173065-wireless-keyboard-and-mouse-set-wkm-550-black-english-arabic-layout-ar 166/350/381
2187 hama-d3173066-wireless-keyboard-and-mouse-set-wkm-550-white-english-arabic-layout-ar 166/350/381
2188 hama-d3173056-wireless-keyboard-and-mouse-set-wkm-200-black-english-arabic-layout-ar 166/350/381
2189 hama-d3173051-wireless-keyboard-and-mouse-set-wkm-100-black-english-arabic-layout-ar 166/350/381
2190 hama-d3182664-cortino-wireless-keyboard-mouse-set-gulf-ar 166/350/381
2191 hama-d3182677-kmw-700-wireless-keyboard-mouse-set-anthracite-black-gulf-ar 166/350/381
2193 hama-200335-video-adapter-displayport-plug-hdmi-socket-ultra-hd-4k-ar 166/423
2194 hama-200334-video-adapter-2-in-1-displayport-plug-vga-and-hdmi-socket-ultra-hd-4k 166
2195 hama-200329-video-adapter-displayport-plug-hdmi-socket-ultra-hd-4k60-hz-alu-ar 166
2196 hama-200314-video-adapter-usb-c-plug-displayport-socket-ultra-hd-4k-ar 166
2197 hama-200342-video-adapter-vgausb-plug-hdmi-socket-full-hd-1080p-ar 166/423/424/426
2198 hama-200144-usb-c-hub-multiport-6-ports-3-x-usb-a-usb-c-hdmi-lan-ethernet-ar 166
2199 hama-200109-usb-c-hub-multiport-5-ports-2-x-usb-a-usb-c-hdmi-lan-ethernet-ar 166
2200 hama-200102-usb-c-hub-multiport-7-ports-3-x-usb-a-usb-c-vga-hdmi-lan-ethernet-ar 166/423/425
2219 hama-200110-usb-c-hub-multiport-6-ports-2-x-usb-a-usb-c-hdmi-sd-microsd-ar 166/423/425
2220 hama-73050544-home-x12cd-shredder-shredder-with-security-level-e3-p4-t4-ar 250/336
2221 hama-73210293-mini-gan-charger-uk-65w-gan-pd-qc-white-ar 166
2222 hama-201653-fast-charger-usb-c-pd-qualcomm-gan-mini-charger-45-w-white-ar 166
2223 hama-73210296-mini-charger-kit-uk-35w-2xusb-c-white-ar 166
2224 hama-73210290-mini-charger-uk-25w-pd-qc-white-ar 166
2225 hama-73210584-charging-kit-usb-c-pd-qualcomm-20-w-usb-c-cable-1-m-uk-plug-black-ar 166
2226 hama-201562-reflective-charging-cable-usb-c-lightning-1-5-m-nylon-ar 166
2228 hama-201603-charging-cable-usb-c-lightning-1-5-m-white-ar 166/423
2229 hama-201702-full-featured-usb-c-usb-c-charging-cable-240w-usb-3-2-gen1-5gbit-s-1-5-m-ar 166
2230 hama-201589-charging-cable-usb-c-usb-c-1-m-black-ar 166
2243 hama-201713-colour-10-power-pack-10000-mah-2-outputs-usb-c-usb-a-green-ar 166/378/432
2244 hama-201716-colour-20-power-pack-20000-mah-2-outputs-usb-c-usb-a-green-ar 166/378/432
8240 hama-178291-universal-smartphone-holder-ar 166/423/657
8241 hama-skross-power-bank-10000mah-reload-10-white-ar 166/378/432
8242 hama-210564-20w-lightning-car-charging-set-white-ar 166/423/424/451
8243 hama-184068-freedom-light-bluetooth-true-wireless-earbuds-white-ar 166/329/344
8244 hama-magcase-extreme-protect-for-iphone-16-pro-max-transparent-ar 166/423/449
8245 hama-pd-20-power-pack-20000-mah-anthracite-ar 166/378/432
8269 hama-205006-high-speed-hdmi-cable-4k-plug-to-plug-with-ethernet-3-0-m-ar 472/542
8272 hama-184020-connect-bluetooth-headphones-in-ear-micro-ear-hook-black-ar 166/329/457
8273 hama-196935-finest-feel-edge-protector-for-apple-airtag-ar 166/423/586
8275 hama-118107-fix-tv-wall-bracket-1-star-600x400-191-cm-75-black-pack-of-1-ar 166/423
8276 hama-finest-feel-edge-protector-for-apple-airtag-red-ar 166/423/449
8277 hama-215516-magcase-safety-back-cover-for-apple-iphone-14-transparent-ar 166/423/449
8280 hama-119454-premium-screen-protection-glass-for-apple-ipad-pro-12-9-inch-clear-ar 166/423/448
8362 hama-spot-pointer-v2-presenter-dig-laser-pointer-spot-illumination-magnifi-139919-ar 250/380
8363 hama-scribble-tablet-stylus-for-apple-ipads-high-precision-tilt-recognition-ar 166/423/477
8365 123770-co-fanta-feel-mc-apple-iph-16pro-schwarz-ar 166/423/449
8372 hama-178250-universal-smartphone-holder-black-ar 166/423/657
8373 hama-200604-usb-2-0-a-to-b-cable-5m-black-ar 166/423/424/450
8375 hama-mw-300-v2-optical-3-button-wireless-mouse-black-ar 166/350/382
8377 hama-cam-protect-back-cover-for-apple-iphone-15-pro-max-transparent-blue-ar 166/423/449
8382 hama-118104-fix-tv-wall-bracket-1-star-400x400-165-cm-65-black-ar 166/423
8403 hama-fantastic-feel-mobile-case-for-iphone-16-blue-123756-ar 166/423/449
8431 hama-123768-fantastic-feel-mobile-case-for-iphone-16-pro-blue-ar 166/423/449
8432 hama-emw-500-vertical-ergonomic-wireless-mouse-6-buttons-black-182699-ar 166/350/382
8433 hama-186440-3-in-1-smart-replacement-air-filter-ar 372/461/464
8434 hama-188204-tube-2-0-bluetooth-speaker-black-ar 166/329/347
8435 hama-188301-magnet-vent-universal-smartphone-holder-black-ar 166/423/657
8438 hama-173193-compact-waterproof-bluetooth-speaker-ar 166/329/347
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
8443 hama-210925-premium-screen-protector-for-ipad-air-13-2024-ar 166/423/448
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
8457 hama-227041-fold-clear-tablet-case-with-pen-compartment-for-ipad-pro-11-2024-2025-black-ar 166/423/449
8459 hama-200103-connect2office-basic-usb-c-docking-station-removable-feet-9-ports-ar 166/423/425
8460 hama-200110-usb-c-hub-multiport-6-ports-2-x-usb-a-usb-c-hdmi-sd-microsd-ar-ar 166/423/425
8464 hama-fold-clear-tablet-case-for-apple-ipad-pro-13-2025-2024-black-227043-ar 166/423/449
8466 hama-227047-fold-clear-protective-tablet-case-with-integrated-pen-holder-for-apple-ipad-pro-13-2025-2024-black-ar 166/423/449
8469 hama-222088-fold-clear-tablet-case-for-apple-ipad-air-11-2024-dark-blue-ar 166/423/449
8470 hama-185663-tayrona-sleeve-15-6-light-grey-ar 658
8471 hama-227045-fold-clear-tablet-case-for-apple-ipad-pro-13-2024-green-ar 166/423/449
8472 hama-187259-power-pack-fabric-10-inches-ar 166/378/432
8514 hama-maglock-magnetic-vent-car-phone-holder-210508-ar 166/423/657
8517 hama-187274-charging-data-cable-usb-c-to-lightning-3-m-black-ar 166/423/424/450
8519 hama-188237-ball-shape-bluetooth-speaker-with-5-light-modes-5w-black-ar 166/329/347
8536 hama-196611-perth-laptop-bag-up-to-40-cm-15-6-dark-blue-ar 658
8538 hama-222045-premium-lightweight-laptop-backpack-up-to-41-cm-16-2-dark-blue-ar 658
8540 hama-227061-ultimate-laptop-bag-34-36-cm-13-3-14-1-black-ar 658
8543 hama-54448-charging-station-for-playstation-5-ar 245/332/417
8569 hama-d3045054-cat-6-pimf-gold-plated-double-shielded-network-cable-5-m-length-ar 166/328/543/343
8570 hama-184081-spirit-chop-in-ear-true-wireless-bluetooth-headphones-white-ar 166/329/344
8572 hama-216545-tayrona-laptop-bag-fits-up-to-14-1-laptops-dark-grey-padded-adjustable-shoulder-strap-ar 658
8573 hama-216545-tayrona-laptop-bag-fits-up-to-15-6-laptops-dark-grey-padded-adjustable-shoulder-strap-ar 658
8574 hama-222041-premium-lightweight-laptop-bag-fits-13-314-1-laptops-dark-blue-eco-friendly-padded-compartments-ar 658
8575 hama-222042-premium-lightweight-laptop-bag-40-41-cm-15-6-16-2-dark-blue-ar 658
8576 hama-200687-network-cable-cat-6a-10-gbit-s-u-utp-flat-15-00-m-ar 166/328/543/343
8577 hama-200693-network-cable-cat-8-40-gbit-s-s-ftp-shielded-halogen-free-3-m-ar 166/328/543/343
8578 hama-222050-ultra-lightweight-laptop-bag-34-36-cm-13-3-14-1-black-ar 658
8580 hama-222051-ultra-lightweight-laptop-bag-40-41-cm-15-6-16-2-olive-ar 658
8581 hama-222060-silvan-laptop-bag-sustainable-34-36-cm-13-3-14-1-light-blue-ar 658
8585 hama-136022-fantastic-feel-cover-for-iphone-15-pro-blue-ar 166/423/449
8586 hama-187268-magcharge-car-fc15-wireless-car-charger-15w-turbo-fast-charge-ar 166/423/657
8587 hama-217222-fold-clear-tablet-case-for-apple-ipad-10-9-10th-gen-2022-black-ar 166/423/449
8589 hama-4315-fun-70-selfie-bluetooth-stick-black-ar 166/423
8590 hama-002-anti-theft-backpack-black-ar 658
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
8596 hama-213005-premium-crystal-glass-screen-protector-for-apple-iphone-13-mini-ar 166/423/448
8597 hama-213014-privacy-screen-protector-glass-for-apple-iphone-13-mini-pack-of-1-ar 166/423/448
8600 hama-220830-tv-wall-bracket-swivel-tilt-pull-out-165-cm-65-up-to-40-kg-ar 166/423
8601 hama-216497-perth-15-6-backpack-black-ar 658
8603 hama-184105-in-ear-earphones-black-with-usb-c-port-ar 166/329/457
8604 hama-12307-8-in-1-universal-remote-control-black-ar 166/423
8605 hama-217114-florence-laptop-bag-13-3-black-grey-ar 658
8612 hama-136019-case-for-apple-iphone-15-pro-transparent-ar 166/423/449
8614 hama-184168-spirit-unchained-enc-true-wireless-earbuds-red-ar 166/329/344
8615 hama-217232-velvet-tablet-case-for-apple-ipad-11-2025-ipad-10-9-2022-petrol-ar 166/423/449
8617 hama-184080-spirit-chop-true-wireless-in-ear-bluetooth-headphones-black-ar 166/329/344
8695 hama-220809-rigid-tv-wall-bracket-65-ar 166/423
8696 hama-184165-freedom-buddy-true-wireless-earbuds-purple-ar 166/329/344
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
8703 hama-freedom-light-ii-bluetooth-tws-earbuds-with-voice-control-ar 166/329/344
8708 hama-139991-c-400-pc-webcam-1080p-ar 166/423/520
8709 hama-184169-spirit-unchained-enc-true-wireless-earbuds-blue-ar 166/329/344
8724 hama-123762-daily-protect-mobile-phone-bag-for-iphone-16-pro-black-ar 166/423/449
8729 hama-80582-fantastic-feel-case-for-samsung-galaxy-s25-ultra-black-ar 166/423/449
8730 hama-123753-extreme-protect-case-for-iphone-16-transparent-black-ar 166/423/449
8757 hama-184179-passion-clear-ii-true-wireless-in-ear-anc-earbuds-ar 166/329/344
8766 hama-silvan-laptop-bag-sustainable-ar 658
8783 hama-222048-ultra-lightweight-laptop-bag-13-314-1-olive-ar 658
8784 hama-45021-usb-2-0-shielded-cable-1-80-m-gray-ar 166/328/543/343
8789 hama-home-x10cd-paper-shredder-crosscut-p4-ar 250/336
8797 hama-80581-extreme-protect-case-for-samsung-galaxy-s25-ultra-black-ar 166/423/449
8799 hama-urage-exodus-700-semi-mechanical-gaming-keyboard-d3186011-ar 166/350/383
8800 hama-d3045053-cat-6-pimf-gold-plated-double-shielded-network-cable-3-m-ar 166/328/543/343
8801 hama-178257-universal-smartphone-holder-ar 166/423/657
8802 hama-186437-smart-air-purifier-ar 372/461/462
8804 hama-220831-fullmotion-tv-wall-bracket-3284-ar 166/423
8805 hama-urage-186066-soundz-900-dac-7-1-gaming-headset-ar 166/329/399
8806 hama-d3223861-3way-power-strip-usbc-a-20w-pd-2m-white-ar 166/351/446
8810 hama-222021-fold-clear-case-with-pen-holder-for-ipad-mini-8-3-black-ar 166/423/449
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
8813 hama-200677-cat6a-network-cable-10m-ar 166/328/543/343
8814 hama-217233-velvet-tablet-case-for-ipad11-10-9-sand-ar 166/423/449
8815 hama-urban-15-6-laptop-backpack-ar 658
8828 hama-123765-extreme-protect-case-for-iphone-16-pro-transparent-ar 166/423/449
8829 hama-136024-feel-magcase-backcover-for-iphone-15-pro-black-ar 166/423/449
8830 hama-186023-urage-soundz310-gaming-headset-black-ar 166/329/399/524
8831 hama-136853-clear-case-for-iphone-16-plus-transparent-ar 166/423/449