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 (
    1662418, 1659922, 1661347, 1657700, 
    1658556, 1659797, 1659562, 1657765, 
    1657745, 1661374, 1915737, 1659943, 
    1661339, 1659257, 1660558, 1659816, 
    2591113, 1658321, 1662787, 1664138, 
    1660123, 1664236, 1661363, 1916044, 
    1660260, 1657702, 1660929, 1663152, 
    2596602, 2099753, 1658439, 1663290, 
    1661128, 1658521, 1658562, 2068216
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'ro' 
  AND (
    cscart_seo_names.company_id = 1 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.13365

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "84.06"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code",
        "company_id"
      ],
      "key_length": "210",
      "rows_examined_per_scan": 72,
      "rows_produced_per_join": 72,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "76.86",
        "eval_cost": "7.20",
        "prefix_cost": "84.06",
        "data_read_per_join": "122K"
      },
      "used_columns": [
        "name",
        "object_id",
        "company_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`maniamall_cscart`.`cscart_seo_names`.`object_id` in (1662418,1659922,1661347,1657700,1658556,1659797,1659562,1657765,1657745,1661374,1915737,1659943,1661339,1659257,1660558,1659816,2591113,1658321,1662787,1664138,1660123,1664236,1661363,1916044,1660260,1657702,1660929,1663152,2596602,2099753,1658439,1663290,1661128,1658521,1658562,2068216)) and (`maniamall_cscart`.`cscart_seo_names`.`type` = 'p') and (`maniamall_cscart`.`cscart_seo_names`.`dispatch` = '') and (`maniamall_cscart`.`cscart_seo_names`.`lang_code` = 'ro') and ((`maniamall_cscart`.`cscart_seo_names`.`company_id` = 1) or (`maniamall_cscart`.`cscart_seo_names`.`company_id` = 0)))"
    }
  }
}

Result

product_id seo_name seo_path
1657700 sigurante-capota-tuning-competitii-2buc-gc-0-maniamall-cars 4528/32420
1657702 acoperitori-pedale-race-1-maniamall-cars 4528/32420
1657745 prezoane-jante-conice-10buc-tc2-maniamall-cars 4528/32420
1657765 prezoane-jante-conice-scurte-10buc-cc1-maniamall-cars 4528/32420
1658321 huse-scaun-linear-set-8buc-jacquard-high-quality-gri-maniamall-cars 4528/32420
1658439 dezactivator-beep-centura-siguranta-zitto-2-maniamall-cars 4528/32420
1658521 adaptoare-oglinzi-race-seat-leon-11-99-9-05-maniamall-cars 4528/32420
1658556 plasa-grila-spoiler-racing-negru-small-2x4mm-100x33cm-maniamall-cars 4528/32420
1658562 huse-scaun-kynox-9buc-bej-maniamall-cars 4528/32420
1659257 bec-12v-10-5x36mm-c5w-5w-sofit-sv8-5-1buc-narva-maniamall-cars 4528/32420
1659562 buson-rezervor-camion-din-plastic-negru-cu-cheie-kamar-o-80mm-maniamall-cars 4528/32420
1659797 bec-halogen-12v-h7-55w-px26d-1buc-4cars-maniamall-cars 4528/32420
1659816 rezerva-disc-panza-pentru-aparat-de-lustruit-si-ceruit-lampa-2buc-maniamall-cars 4528/32420
1659922 set-sigurante-cilindrice-10buc-4cars-maniamall-cars 4528/32420
1659943 huse-scaun-furgoneta-de-transport-elegance-dv3-3locuri-maniamall-cars 4528/32420
1660123 vopsea-spray-cauciucata-kolor-dip-400ml-fluor-green-maniamall-cars 4528/32420
1660260 bucsa-bara-stab.fata-ford-mondeo-iii-maniamall-cars 4528/32420
1660558 termostat-wahler-vw-golf-passat-maniamall-cars 4528/32420
1660929 prelata-auto-completa-mobile-garage-l-lav-maniamall-cars 4528/32420
1661128 huse-scaun-dedicate-pentru-ford-focus-ii-2004-2011-focus-iii-2011-maniamall-cars 4528/32420
1661339 lampi-semnalizare-directie-mers-atom-led-12v-2buc-negru-maniamall-cars 4528/32420
1661347 prelata-motocicleta-impermeabila-ventura-xl-maniamall-cars 4528/32420
1661363 carcasa-tare-opti-case-pentru-suporti-telefon-mobil-opti-line-iphone-6plus-7plus-8plus-maniamall-cars 4528/32420
1661374 lampa-stop-led-cu-3-functii-nova-12v-maniamall-cars 4528/32420
1662418 pom-de-craciun-led-acril-12-cm-maniamall-cars 4528/32420
1662787 dozatoare-sare-i-piper-sticl-2-buc.-cutie-maniamall-cars 4528/32420
1663152 profil-izolator-autoadeziv-pt.-ferestre-si-usi-profil-p-100-m-maro-maniamall-cars 4528/32420
1663290 plasa-de-tantari-cu-vanzare-la-rol-croibila-100-cm-x-30-m-alb-maniamall-cars 4528/32420
1664138 lamp-solar-led-model-fulg-de-zpad-maniamall-cars 4528/32420
1664236 mini-proiectoare-dash-lites-2-led-2buc-24v-albastru-maniamall-cars 4528/32420
1915737 cauciuc-pedala-ford-fiesta-fusionfocus-imondeo-iii-maniamall-cars 4528/32420
1916044 instalaie-de-pom-cu-led-fulgi-de-nea-2-3-m-20-led-multicolor-3-x-aa-maniamall-cars 4528/32420
2068216 bicicleta-fara-pedale-pentru-copii-cu-roti-din-material-eva-saua-reglabila-culoare-negru 4528
2099753 spray-silicon-bord-polo-k2-750ml-lavanda-maniamall-cars 4528/32420
2591113 cap-de-aspirare-cu-perie-si-sac-pentru-curatarea-piscinii-bigstren-plastic-culoare-negru-portocaliu-gri 4528
2596602 organizator-auto-universal-multifunctional-pentru-scaun-piele-ecologica-58x41-cm-negru 4528