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 (
    1232946, 600081, 591543, 611228, 591145, 
    611260, 1779540, 594090, 621042, 459123, 
    592444, 589118, 1232940, 1232908, 
    594006, 595804, 866378, 590566, 592825, 
    796380, 698317, 1233022, 594292, 1232971, 
    612103, 589509, 1232911, 866376, 1233039, 
    589731, 1068615, 696911, 590525, 611377, 
    590341, 614832
  ) 
  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.00843

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "84.92"
    },
    "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": "77.72",
        "eval_cost": "7.20",
        "prefix_cost": "84.92",
        "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 (1232946,600081,591543,611228,591145,611260,1779540,594090,621042,459123,592444,589118,1232940,1232908,594006,595804,866378,590566,592825,796380,698317,1233022,594292,1232971,612103,589509,1232911,866376,1233039,589731,1068615,696911,590525,611377,590341,614832)) 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
459123 proiector-led-auto-patrat-cu-9-led-uri-putere-27w 290/1035/2689
589118 cap-echilibror-hayon-bolt-cu-cap-bila-m8-set-2-bucati-pentru-amortizor-lungime-filet-8.5mm-12x13mm-kft-auto 290/8174/8203
589509 chit-bicomponent-poxilina-adeziv-cu-caracteristici-de-sudura-metalica-70g-kft-auto 290/8192
589731 comutator-mecanism-ridicare-geam-renault-kangoo-1998-2002-clio-2-1998-2001-scenic-09.1999-06.2003-buton-geamuri-electrice-7700410151-cu-6-pini-kft-auto 290/8174/8371
590341 cupla-aer-m12-mufa-rapida-cot-90-grade-plastic-kft-auto 290/8180/8392
590525 far-opel-astra-g-01.1998-08.2009-tyc-fata-dreapta-tip-bec-h7hb3-kft-auto 290/8185/8186
590566 fierbator-apa-electric-pentru-masina-12v-150w-carpoint-kft-auto 290/8180/8320
591145 grila-spoiler-vw-passat-3c-b6-2005-07.2010-partea-stanga-cu-gaura-proiector-kft-auto 290/8174/8445
591543 huse-scaune-auto-sofer-ares-trafic-pentru-nissan-primastar-opel-vivaro-renault-trafic-kft-auto 290/8448/8449
592444 maner-usa-nissan-qashqai-j10-2007-2010-usa-fata-spate-partea-stanga-cromat-kft-auto 290/8174/8337
592825 mufa-bec-ceramica-pentru-soclu-h4-cu-cablu-15-cm-mufa-bec-h4-kft-auto 290/8242/8509
594006 rola-ghidare-curea-distributie-opel-astra-g-astra-h-vectra-c-zafira-a-b-corsa-c-meriva-signum-motorizari-1.8-1.8-16v-1.6-16v-1.6-cng-1.8-i-diametru-ext-52.50mm-latime-25-mm-kft-auto 290/43883
594090 rulment-roata-fata-daewoo-matiz-1998-2008-chevrolet-spark-2005-set-kft-auto 290/8231/8562
594292 set-175-splinturi-si-arcuri-de-compresie-si-tractiune-diferite-marimi-kft-auto 290/8572
595804 set-yale-inchidere-seat-ibiza-cordoba-1993-1999-vw-polo-6kv-classic-combi-11.1995-06.2001-vw-polo-6n-hatchback-10.1994-08.1999-cu-stift-butuc-usa-fata-stanga-dreapta-kft-auto 290/8174/8268
600081 cauciuc-auto-3-butoane-hy-123-compatibil-cheie-hyundai-allcars 290/8341/8680
611228 valva-tubeless-tr602hp-maniacars 290/3178/3179/3209
611260 banda-flexibila-led-drl-30cm-cu-functie-de-semnalizare-dinamica-flowbo30cm-maniacars 290/3168/3169/3170/7897/7898
611377 manson-schimbator-compatibil-skoda-octavia-ii-2004-2011-cod-m-art290-6-viteze-negru-maniacars 290/3118/3119/3281
612103 filtru-aer-tuning-cu-carcasa-rosie-maniacars 290/1098/3174
614832 prindere-podea-pentru-marfa-u-01-maniacars 290/3118/3155/7905/7906/7907
621042 lamela-cheie-vw-104-compatibila-smart-key-volkswagen-seat-skoda-allcars 290/8341/8776
696911 set-capacele-pentru-jante-68mm-maniacars 290/3157/3158
698317 adaptor-pentru-bec-xenon-audi-h7-maniacars 290/3204/3205
796380 suport-numar-de-inamtriculare-pentru-scuter-sau-motocicleta-culoare-negru 290/11611
866376 adaptor-bec-led-h7-ns-07-bmw-e46 290/8183/8184
866378 adaptor-bec-led-h7-ns-08-bmw-e46 290/8183/8184
1068615 segment-reparatie-prag-skoda-octavia-2-1z3-1z5-10.2008-12.2013-skoda-octavia-ii-tour-2-1z3-1z5-06.2004-12.2012-partea-stanga-dreapta-l1860mm-partea-inferioara-kft-auto 290/19342/19389/19501/20534
1232908 stickere-auto-baiat-piss-maniastiker-ro 290/16837/16886
1232911 set-protectie-praguri-opel-astra-h-maniastiker-ro 290/16853/16883
1232940 sticker-ornament-auto-model-bmw-m-power-20cm-x-18cm-maniastiker-ro 290/16837/16890
1232946 sticker-sports-mind-bmw-sport-maniastiker-ro 290/16837/16840
1232971 sticker-prag-alfa-romeo-set-2-buc-maniastiker-ro 290/16837/16895
1233022 sticker-auto-laterale-bmw-m-power-set-2-buc.-maniastiker-ro-3 290/16837/16892
1233039 set-protectii-praguri-crom-vw-maniastiker-ro 290/16853/16883
1779540 ventuza-dubla-pentru-transport-geamuri-sau-sticla-lungime-32-cm-capacitate-70-kg-negru 286/28866