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 (
    415231, 415251, 415216, 415253, 415218, 
    415214, 415333, 415252, 415212, 415344, 
    415204, 415209, 415233, 415207, 415337, 
    415335, 415338, 415222, 415210, 415343
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00144

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "28.03"
    },
    "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": 20,
      "rows_produced_per_join": 20,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "24.03",
        "eval_cost": "4.00",
        "prefix_cost": "28.03",
        "data_read_per_join": "33K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`webmarco`.`cscart_seo_names`.`object_id` in (415231,415251,415216,415253,415218,415214,415333,415252,415212,415344,415204,415209,415233,415207,415337,415335,415338,415222,415210,415343)) and (`webmarco`.`cscart_seo_names`.`type` = 'p') and (`webmarco`.`cscart_seo_names`.`dispatch` = '') and (`webmarco`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
415204 djemte-e-rruges-pal 5368/5388/219/221
415207 duart-e-vogla-mesimet-e-para 5368/5388/219/221
415209 enciklopedia-ime-e-pare-bota-perreth-meje 5368/5388/219/221
415210 enciklopedia-ime-e-pare-cfare 5368/5388/219/221
415212 enciklopedia-ime-e-pare-kur 5368/5388/219/221
415214 enciklopedia-ime-e-pare-perse 5368/5388/219/221
415216 ferma-hap-dritarezat-dhe-zbulo 5368/5388/219/221
415218 gjiganti-im-i-vogel-alfabeti-dhe-ngjyrat 5368/5388/219/221
415222 hajdi 5368/5388/219/221
415231 karta-per-duart-e-vogla-me-meso-te-shkruaj-123 5368/5388/219/221
415233 karta-per-duart-e-vogla-me-meso-te-shkruaj-abc 5368/5388/219/221
415251 me-meso-te-shkruaj-numrat-format-dhe-ngjyrat 5368/5388/219/221
415252 me-meso-te-shkruaj-shkronjat-e-medha-te-alfabetit 5368/5388/219/221
415253 me-meso-te-shkruaj-tabelen-e-shumezimit 5368/5388/219/221
415333 rregullat-e-reja-te-marketingut-dhe-pr-it 5368/5388/219/221
415335 udherrefyes-per-nje-shtatzeni-te-shendetshme 5368/5388/219/221
415337 nje-vit-jete-si-danezet 5368/5388/219/221
415338 ushqimet-qe-shpetojne-jete 5368/5388/219/221
415343 humb-ne-peshe-tani 5368/5388/219/221
415344 menyra-e-lehte-per-te-lene-duhanin-pa-shtuar-ne-peshe 5368/5388/219/221