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 (
    1732000, 1661266, 1731933, 1658668, 
    1658805, 2539827, 1661450, 1658400, 
    1661340, 2072334, 1659066, 1163013, 
    1663387, 2253671, 1659620, 1658630, 
    1659207, 1658657, 1657931, 1661143, 
    1732317, 1664148, 1732319, 1657915, 
    1659840, 1658338, 1658635, 1658606, 
    1658866, 1658169, 1660818, 1659802, 
    1659293, 1660499, 1658645, 1661096
  ) 
  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.00373

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "84.11"
    },
    "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.91",
        "eval_cost": "7.20",
        "prefix_cost": "84.11",
        "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 (1732000,1661266,1731933,1658668,1658805,2539827,1661450,1658400,1661340,2072334,1659066,1163013,1663387,2253671,1659620,1658630,1659207,1658657,1657931,1661143,1732317,1664148,1732319,1657915,1659840,1658338,1658635,1658606,1658866,1658169,1660818,1659802,1659293,1660499,1658645,1661096)) 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
1163013 total-lama-taiere-carbid-tungsten-compatibil-mto-tht576004b 4528/32420
1657915 priza-auto-incorporabila-12v-20a-carpoint-maniamall-cars 4528/32420
1657931 aparatori-noroi-camion-45x35cm-2buc-maniamall-cars 4528/32420
1658169 plasa-protectie-universala-120x50cm-maniamall-cars 4528/32420
1658338 bec-tip-led-12v-iluminat-bord-soclu-pl.-t5-w2x4-6d-5buc-albast-maniamall-cars 4528/32420
1658400 autocolant-3d-crom-type-3-28mm-litera-b-maniamall-cars 4528/32420
1658606 set-sigurante-cilindrice-10buc-lampa-maniamall-cars 4528/32420
1658630 bec-tip-led-24v-poz-semn-bord-soclu-metal-t4w-ba9s-2buc-rosu-maniamall-cars 4528/32420
1658635 bec-tip-led-12v-sofit-cu-8-leduri-13x35mm-sv8-5-8-1buc-verde-maniamall-cars 4528/32420
1658645 bec-halogen-blu-xe-h7-55w-px26d-12v-2buc-maniamall-cars 4528/32420
1658657 bec-halogen-blu-xe-h7-100w-px26d-12v-2buc-maniamall-cars 4528/32420
1658668 priza-auto-incorporabila-din-12-24v-16a-lampa-maniamall-cars 4528/32420
1658805 burduf-schimbator-viteza-cu-snur-galben-maniamall-cars 4528/32420
1658866 prezoane-antifurt-jante-sferice-m14x1-5mm-4buc-tip-d-maniamall-cars 4528/32420
1659066 maner-schimbator-viteza-imitatie-lemn-si-masaj-4cars-maniamall-cars 4528/32420
1659207 bec-halogen-12v-h10-42w-py20d-1buc-lampa-maniamall-cars 4528/32420
1659293 bec-xenon-12v-h7-35w-px26d-1buc-6000k-maniamall-cars 4528/32420
1659620 bec-tip-led-12v-soclu-plastic-t5-w2x4-6d-2buc-curcubeu-maniamall-cars 4528/32420
1659802 bec-led-2smd-12v-sofit-t11x36mm-soclu-sv8-5-8-2buc-alb-maniamall-cars 4528/32420
1659840 oglinda-interioara-cu-ventuza-148x60mm-carpoint-maniamall-cars 4528/32420
1660499 placute-frana-spate-trw-mercedes-c-class-w202-w203-maniamall-cars 4528/32420
1660818 priza-tripla-bricheta-cu-usb-si-telecomanda-duo-4-ir-24v-maniamall-cars 4528/32420
1661096 huse-scaun-de-luxe-sport-edition-jacquard-high-quality-9buc-negru-maniamall-cars 4528/32420
1661143 breloc-chei-cu-cablu-10cm-usb-la-micro-usb-maniamall-cars 4528/32420
1661266 ornamente-bara-protectie-reflectorizante-cata-reflex-4buc-maniamall-cars 4528/32420
1661340 releu-electronic-pentru-semnalizatoare-led-6-12-24v-maniamall-cars 4528/32420
1661450 coliere-fixare-proiectoare-fixer-2buc-maniamall-cars 4528/32420
1663387 rui-pentru-fixarea-gazonului-artificial-pachet-de-10-maniamall-cars 4528/32420
1664148 fierbator-apa-1l-carpoint-12v-150w-maniamall-cars 4528/32420
1731933 ornamente-crom-pt.-oglinda-compatibil-land-range-rover-freelander-2-discovery-sport-crom-0230-mra36-240521-3 290/3118/9711/9712
1732000 ornamente-crom-pt.-oglinda-compatibil-dacia-duster-2010-tr-mra36-150421-5 290/3118/9711/9712/23771
1732317 aparatori-noroi-dedicate-mercedes-clasa-e-w212-berlina-facelift-w212-w212-t-modell-facelift-s212-2013-2016-mud1104-ch-2-mra36-091220-22 290/3118/3124
1732319 aparatori-noroi-dedicate-land-rover-range-rover-evoque-prestige-2011-mud1102-ch-2-mra36-091220-20 290/3118/3124
2072334 suport-magnetic-auto-pentru-telefon-cu-prindere-in-grila-de-ventilatie-culoare-negru 4528
2253671 set-accesorii-intex-pentru-curatarea-piscinelor-culoare-alb-albastru 4528
2539827 termometru-alimentar-analogic-de-insertie-pentru-carne-inox-0c-120c-negru-argintiu 285/3100/4496