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 (
    10447, 10460, 10400, 10397, 10399, 10403, 
    10402, 10401, 10404, 10356, 10351, 
    10368, 10009, 10012, 10474, 10420, 
    10387, 10354, 10428, 10453, 10471, 
    10365, 10398, 10463, 10406, 10436, 
    10480, 10486, 10545, 10350, 10412, 
    10488, 10384, 10449, 10452, 10462, 
    10461, 10472, 10482, 10553, 10381, 
    10013, 10371, 10373, 10394, 10466, 
    10467, 10551, 10011, 10370, 10372, 
    10388, 10457, 10459, 10475, 10555, 
    10007, 10008, 10010, 10352, 10353, 
    10357, 10358, 10378, 10379, 10383, 
    10392, 10393, 10405, 10411, 10414, 
    10425, 10427, 10470, 10359, 10361, 
    10376, 10390, 10426, 10429
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'ar'

Query time 0.00479

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "56.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": 82,
      "rows_produced_per_join": 82,
      "filtered": "100.00",
      "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`object_id` in (10447,10460,10400,10397,10399,10403,10402,10401,10404,10356,10351,10368,10009,10012,10474,10420,10387,10354,10428,10453,10471,10365,10398,10463,10406,10436,10480,10486,10545,10350,10412,10488,10384,10449,10452,10462,10461,10472,10482,10553,10381,10013,10371,10373,10394,10466,10467,10551,10011,10370,10372,10388,10457,10459,10475,10555,10007,10008,10010,10352,10353,10357,10358,10378,10379,10383,10392,10393,10405,10411,10414,10425,10427,10470,10359,10361,10376,10390,10426,10429)) 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": "48.71",
        "eval_cost": "8.20",
        "prefix_cost": "56.91",
        "data_read_per_join": "139K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
10007 hausberg-electric-sandwich-maker-ar 372/466/573
10008 hausberg-toaster-ar 372/466/573
10009 hausberg-electric-toaster-machine-ar 372/466/573
10010 hausberg-electric-toaster-machine-white-ar 372/466/573
10011 hausberg-electric-mixer-ar 372/466/574
10012 hausberg-electric-mixer-hb-4120ng-ar 372/466/574
10013 hausberg-rechargeable-hand-mixer-ar 372/466/574
10350 hausberg-hb-28-hair-dryer-black-ar 577/473/474
10351 hausberg-hb-29-hair-dryer-ar 577/473/474
10352 hausberg-hb-261gr-hair-dryer-ar 577/473/474
10353 hausberg-hb-263gr-hair-dryer-ar 577/473/474
10354 hausberg-hb-32rz-hair-straightener-ar 577/473/475
10356 hausberg-hb-33rz-hair-straightener-ar 577/473/475
10357 hausberg-hb-900ab-popcorn-maker-ar 372/466
10358 hausberg-hb-910rs-popcorn-maker-ar 372/466
10359 hausberg-hb-1311in-healthy-food-cooking-pot-5l-steel-ar 372/466
10361 hausberg-hb-540-electric-grill-set-with-stand-ar 372/466/573
10365 hausberg-hb-6000ng-personal-scale-ar 372
10368 hausberg-hb-6011ab-kitchen-scale-ar 372
10370 hausberg-hb-26au-hair-dryer-ar 577/473/474
10371 hausberg-hb-3735ab-coffee-maker-ar 250/553/554
10372 hausberg-hb-3725in-coffee-maker-ar 372/552/556
10373 hausberg-hb-3730in-espresso-coffee-maker-ar 372/552/556
10376 hausberg-hb-7545in-juicer-ar 372/466/574
10378 hausberg-hb-3815in-kettle-800-watt-ar 372/466/575
10379 hausberg-hb-3620-kettle-2l-ar 372/466/575
10381 hausberg-hb-3622rs-kettle-2-0-l-ar 372/466/575
10383 hausberg-hb-3635in-tea-maker-ar 372/466/575
10384 hausberg-hb-3640in-tea-maker-ar 372/466/575
10387 hausberg-hb-7825ng-steam-iron-ar 372/587
10388 hausberg-hb-7840vr-steam-iron-ar 372/587
10390 hausberg-hb-7900ng-portable-steam-iron-ar 372/587
10392 hausberg-hb-7925-steam-iron-ar 372/587
10393 hausberg-hb-7927rst-steam-iron-ar 372/587
10394 hausberg-hb-7930mv-steam-iron-ar 372/587
10397 hausberg-hb-2029gr-handheld-vacuum-cleaner-ar 372/384
10398 hausberg-hb-2033gr-handheld-vacuum-cleaner-ar 372/384/598
10399 hausberg-hb-2035ab-handheld-vacuum-cleaner-ar 372/384
10400 hausberg-hb-2890ng-portable-carpet-washer-vacuum-cleaner-ar 372/384
10401 hausberg-hb-2835au-drum-vacuum-cleaner-ar 372/384
10402 hausberg-hb-2837in-drum-vacuum-cleaner-ar 372/384
10403 hausberg-hb-2820rs-bagless-vacuum-cleaner-ar 372/384
10404 hausberg-hb-2823au-bagless-vacuum-cleaner-ar 372/384
10405 hausberg-electric-blender-ar-ar 372/466/574
10406 hausberg-electric-blender-set-with-jar-ar 372/466/574
10411 hausberg-electric-turkish-coffee-machine-ar 372/552/556
10412 hausberg-electric-coffee-grinder-ar 372/552/556
10414 hausberg-hb-7762-blender-ar 372/466
10420 hausberg-hb-7675ng-hand-blender-ar 372/466/574
10425 hausberg-hb-3445-meat-grinder-ar 372/466/574
10426 hausberg-hb-3455-meat-grinder-ar 372/466/574
10427 hausberg-hb-3460-meat-grinder-ar 372/466/574
10428 hausberg-hb-2365-electric-fryer-ar 372/466/467
10429 hausberg-lint-remover-with-battery-ar 372
10436 hausberg-electric-iron-with-teflon-soleplate-ar 372/587
10447 hausberg-hb-80rz-electric-epilator-for-smooth-and-long-lasting-hair-removal-ar 577/578
10449 hausberg-electric-epilator-for-smooth-and-long-lasting-hair-removal-ar 577/578
10452 hausberg-hb-8216ng-electric-fireplace-heater-for-warm-and-cozy-heating-ar 372/566/597
10453 hausberg-hb-8565ng-radiant-electric-heater-for-efficient-indoor-heating-ar 372/566/597
10457 hausberg-hb-8575al-carbon-heater-ar 372/566
10459 hausberg-hb-8809ng-carbon-electric-heater-for-fast-and-efficient-heating-ar 372/566/597
10460 hausberg-hb-8810ng-carbon-electric-heater-for-fast-and-efficient-heating-ar 372/566/597
10461 hausberg-hb-8217ab-digital-wall-mounted-hot-and-cool-electric-heater-ar 372/566/597
10462 hausberg-hb-8219ab-electric-fan-heater-for-efficient-and-adjustable-warmth-ar 372/566/597
10463 hausberg-hb-8228ng-electric-fan-heater-for-fast-and-efficient-warmth-ar 372/566/597
10466 hausberg-hb-8930ng-oil-filled-radiator-heater-for-efficient-and-comfortable-warmth-ar 372/566/597
10467 hausberg-hb-6030ng-hot-water-dispenser-with-tea-bar-ar 372/466/575
10470 hausberg-hb-h-1705-electric-juicer-for-fresh-and-healthy-juices-ar 372/466
10471 hausberg-hb-2019ng-handheld-vacuum-cleaner-ar 372/384
10472 hausberg-hbh07r-universal-tv-wall-mount-bracket-for-secure-installation-ar 166/423
10474 hausberg-hbh02f-universal-tv-wall-mount-bracket-for-secure-viewing-ar 166/423
10475 hausberg-hbh03f-universal-tv-wall-mount-bracket-for-stable-and-adjustable-viewing-ar 166/423
10480 hausberg-electric-professional-sandwich-maker-and-grill-ar 372/466/573
10482 hausberg-electric-stand-mixer-ar 372/466/574
10486 hausberg-electric-mixer-ar-2 372/466/574
10488 hausberg-electric-steel-blender-set-with-glass-jar-hb-7764in-ar 372/466/574
10545 hausberg-electric-midi-oven-with-fan-and-double-glass-ar 372/466/579
10551 hausberg-single-burner-electrical-hot-plate-ar 372/466
10553 hausberg-double-burner-electrical-hot-plate-ar 372/466
10555 hausberg-electric-ice-maker-ar 372/466/655