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 (
    480519, 524885, 697773, 866373, 1118377, 
    697683, 612103, 880671, 1434961, 694679, 
    822677, 614913, 301401, 822659, 613219, 
    613221, 1025388, 822679, 1025367, 
    1025365, 1230911, 1338749, 1731846, 
    1732251, 359020, 1153153, 1153155, 
    1338924, 1231165, 1731742, 1732158, 
    1231166, 1732357, 1153734, 1732013, 
    1663556
  ) 
  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.01306

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "84.41"
    },
    "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.21",
        "eval_cost": "7.20",
        "prefix_cost": "84.41",
        "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 (480519,524885,697773,866373,1118377,697683,612103,880671,1434961,694679,822677,614913,301401,822659,613219,613221,1025388,822679,1025367,1025365,1230911,1338749,1731846,1732251,359020,1153153,1153155,1338924,1231165,1731742,1732158,1231166,1732357,1153734,1732013,1663556)) 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
301401 plasa-de-depozitare-durabila-cu-carlige-60-x-60-cm-lungime-intinsa 290/1098/5862
359020 organizator-auto-pentru-spatarul-scaunului-din-fata-al-masinii 294/3689
480519 kit-pentru-reparatie-parbriz-sau-geam-auto 290/1098/1571
524885 priza-remorca-auto-cu-adaptor-inclus-pentru-7-sau-13-pini 290/1098/7127
612103 filtru-aer-tuning-cu-carcasa-rosie-maniacars 290/1098/3174
613219 invertor-220v-12v-20a-240w-cu-ventilator-maniacars 290/1098/3154
613221 invertor-220v-12v-30a-360w-cu-ventilator-maniacars 290/1098/3154
614913 ridicator-tensiune-pentru-fir-neon-maniacars 290/1098/3154
694679 kit-cablaj-carlig-remorca-7-pini-maniacars 290/1098/3129
697683 releu-4-pini-40a-12v-maniacars 290/1098/3154
697773 pompa-amorsare-auto-cu-cot-maniacars 290/1098/3126
822659 priza-remorca-auto-blow-cu-7-pini-12-24v-culoare-argintiu 290/1098/7127
822677 adaptor-priza-bricheta-blow-3xusb-5.2a-protectie-la-supratensiune 290/1098/5870
822679 vesta-cu-doua-dungi-reflectorizante-omologata-european-culoare-portocaliu 290/2799
866373 incarcator-auto-wireless-cu-suport-inchidere-deschidere-automata-incarcare-prin-inductie-electromagnetica-brat-reglabil-negru 297/1000/1001/2920
880671 priza-bricheta-auto-tripla-12v-24v-cu-port-usb 290/1098/5870
1025365 cablu-frana-2m-1.5mm-mto-bsp0758 290/1098/16582
1025367 cablu-frana-2m-1.5mm-mto-bsp0763 290/1098/16582
1025388 camasa-frana-fata-l75-mto-r50033.2 290/1098/16582
1118377 covoras-husa-auto-de-protectie-bancheta-sau-portbagaj-pentru-transport-animale-144x144-cm 290/1098/21168
1153153 set-chei-pentru-demontare-radio-auto-blaupunkt-phillips-compatibil-opel-2-buc 290/1098/10976
1153155 set-chei-pentru-demontare-radio-auto-compatibil-vw-audi-2-buc 290/1098/10976
1153734 tester-de-presiune-analogic-pt.-pneuri-gbz-55779-brico-decohome 290/1098/23246/23281
1230911 parasolar-auto-universal-retractabil-pentru-parbriz-sau-luneta-protectie-uv-150x65-cm-gri 290/1098/5842
1231165 camera-auto-165-175-185-14 290/1098/16864
1231166 camera-auto-600-650-16 290/1098/16864
1338749 set-huse-scaune-fataspate-art210fs-super-soft-diverse-culori 290/1098/21065
1338924 suport-telefon-cu-incarcator-wireless-s5-2in1 290/1098/23246/23310
1434961 antena-auto-ornamentala-universala-tip-rechin-din-plastic-15x5.5x7cm-culoare-alb 290/1098/7128
1663556 opel-chevrolet-carcasa-tip-cheie-briceag-cu-3-butoane-maniamall-cars 290/1098/10887
1731742 abtibild-reflectorizant-5cm-x-40-t078-mra36-150621-4 290/1098/3174
1731846 eleron-portbagaj-haion-universal-negru-lucios-cod-univ-091-mra36-040621-19 290/1098/3174
1732013 set-2-becuri-halogen-h7-osram-cool-blue-intense-12v-55w-mra36-120421-1 290/1098/37477
1732158 lada-frigorifica-termoelectrica-capacitate-21l-tensiune-alimentare-12v-putere-48w-cu-adaptor-220v-breckner-germany-bk87829-mra36-220221-10 290/1098/3154
1732251 rola-cheder-cu-adeziv-4.5-metri-cod-508802-045-mra36-270121-2 290/1098/1165
1732357 prelata-moto-atv-marimea-s-1.70.60.8m-mra36-041220-1 290/1098/1165