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"
      ]
    }
  }
}