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 (
    7141, 7387, 7945, 9994, 7969, 7418, 7628, 
    7950, 7961, 7963, 7976, 8043, 9041, 
    9232, 6856, 7399, 8007, 8955, 9098, 
    9541, 9921, 9386, 6489, 7413
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'ar'

Query time 0.00170

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "17.26"
    },
    "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": 25,
      "rows_produced_per_join": 25,
      "filtered": "100.00",
      "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`object_id` in (7141,7387,7945,9994,7969,7418,7628,7950,7961,7963,7976,8043,9041,9232,6856,7399,8007,8955,9098,9541,9921,9386,6489,7413)) 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": "14.76",
        "eval_cost": "2.50",
        "prefix_cost": "17.26",
        "data_read_per_join": "42K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
6489 braun-satin-hair-7-st780-professional-hair-straightener-with-iontec-technology-170w-ceramic-plates-ar 577/473/475
6856 hugo-boss-femme-eau-de-parfum-for-women-ar 577/621/623
7141 anua-heartleaf-77-soothing-toner-ar 577/629/630
7387 sally-hansen-complete-treatment-instant-dry-top-coat-ar 577/650/652
7399 golden-rose-extreme-gel-shine-nail-color-shade-31-pearl-steel-gray-ar 577/650/651
7413 sally-hansen-nail-rehab-strengthener-ar 577/650/652
7418 sally-hansen-salon-effects-perfect-manicure-fake-nails-pink-clay-square-ar 577/650/652
7628 prada-paradoxe-edp-ar 577/621/623
7945 white-barn-bath-and-body-works-vanilla-and-santal-candle-ar 577/621/626
7950 white-barn-bath-and-body-works-pineapple-pound-cake-candle-ar 577/621/626
7961 bath-and-body-works-caramelcreamsoda-scented-candle-ar 577/621/626
7963 bath-and-body-works-bergamot-waters-scented-candle-ar 577/621/626
7969 orto-parisi-terroni-eau-de-parfum-ar 577/621/627
7976 nasomatto-black-afghano-eau-de-parfum-ar 577/621/627
8007 loewe-aura-pink-magnolia-eau-de-parfum-ar 577/621/627
8043 boadicea-the-victorious-lavish-eau-de-parfum-ar 577/621/627
8955 جيل-إيه-سي-إم-ميديسان-المطفّي-بعامل-حماية-spf-50-ar 577/629/634
9041 emmanuelle-jane-love-moment-fine-fragrance-mist-ar 577/639/640
9098 bath-and-body-works-water-lily-springs-body-mist-ar 577/639/640
9232 bath-and-body-works-saltwater-breeze-body-cream-ar 577/639/642
9386 slazenger-active-sport-deodorant-for-men-blue-ar 577/639/643
9541 trisa-hairb-basic-small-rubber-ar 577
9921 trisa-thin-elastics-ar 577
9994 lacoste-timeless-homme-eau-de-toilette-ar 577/621/622