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 (
    1987, 
    2110, 
    2111, 
    2112, 
    1900, 
    1813, 
    1820, 
    2366, 
    1897, 
    1750, 
    1924, 
    2227, 
    2204, 
    2010, 
    2309, 
    2060, 
    2122, 
    2274, 
    2061, 
    1918, 
    1913, 
    1958, 
    2290, 
    1751, 
    1957, 
    2202, 
    1814, 
    2331, 
    1748, 
    2005, 
    2214, 
    2342, 
    2215, 
    2211, 
    2225, 
    2212, 
    2213, 
    2226, 
    2151, 
    1882, 
    1815, 
    1853, 
    1759, 
    2001, 
    2276, 
    2231, 
    2281, 
    2379, 
    2388, 
    2115, 
    1929, 
    2373, 
    2372, 
    2374, 
    1760, 
    1807, 
    1847, 
    2363, 
    1816, 
    2146, 
    2201, 
    2386, 
    2359, 
    2279, 
    1843, 
    1859, 
    1794, 
    1793, 
    1817, 
    1795, 
    2278, 
    1818, 
    1784, 
    1819, 
    1849, 
    2338, 
    2383, 
    2337, 
    2336, 
    2389, 
    1802, 
    1801, 
    1880, 
    1767, 
    2346, 
    2301, 
    2081, 
    1947, 
    2157, 
    2207, 
    2142, 
    2121, 
    2375, 
    2088, 
    2089, 
    2090, 
    2087, 
    2158, 
    1787, 
    2105, 
    2133, 
    2125, 
    2092, 
    2093, 
    2046, 
    2045, 
    2044, 
    2047, 
    2049, 
    2048, 
    1995, 
    1943, 
    2120, 
    2094, 
    2385, 
    1989, 
    2314, 
    1951, 
    2096, 
    1988, 
    2098, 
    2097, 
    2099, 
    2199, 
    2200, 
    1948, 
    2095, 
    2100, 
    2124, 
    2101, 
    2134, 
    2198, 
    2291, 
    2103, 
    2307, 
    2166, 
    2208, 
    2102, 
    2104, 
    2345, 
    2143, 
    2119, 
    2144, 
    2362, 
    2233, 
    2350, 
    2232, 
    2244, 
    2051, 
    1855, 
    2367, 
    1808, 
    1891, 
    1892, 
    2368, 
    2393, 
    1952, 
    1939, 
    1930, 
    1764
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'pl'

Query time 0.00333

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "112.01"
    },
    "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": 160,
      "rows_produced_per_join": 160,
      "filtered": "100.00",
      "index_condition": "((`cscartdevel`.`cscart_seo_names`.`object_id` in (1987,2110,2111,2112,1900,1813,1820,2366,1897,1750,1924,2227,2204,2010,2309,2060,2122,2274,2061,1918,1913,1958,2290,1751,1957,2202,1814,2331,1748,2005,2214,2342,2215,2211,2225,2212,2213,2226,2151,1882,1815,1853,1759,2001,2276,2231,2281,2379,2388,2115,1929,2373,2372,2374,1760,1807,1847,2363,1816,2146,2201,2386,2359,2279,1843,1859,1794,1793,1817,1795,2278,1818,1784,1819,1849,2338,2383,2337,2336,2389,1802,1801,1880,1767,2346,2301,2081,1947,2157,2207,2142,2121,2375,2088,2089,2090,2087,2158,1787,2105,2133,2125,2092,2093,2046,2045,2044,2047,2049,2048,1995,1943,2120,2094,2385,1989,2314,1951,2096,1988,2098,2097,2099,2199,2200,1948,2095,2100,2124,2101,2134,2198,2291,2103,2307,2166,2208,2102,2104,2345,2143,2119,2144,2362,2233,2350,2232,2244,2051,1855,2367,1808,1891,1892,2368,2393,1952,1939,1930,1764)) and (`cscartdevel`.`cscart_seo_names`.`type` = 'p') and (`cscartdevel`.`cscart_seo_names`.`dispatch` = '') and (`cscartdevel`.`cscart_seo_names`.`lang_code` = 'pl'))",
      "cost_info": {
        "read_cost": "96.01",
        "eval_cost": "16.00",
        "prefix_cost": "112.01",
        "data_read_per_join": "271K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
1748 chipsy-jablkowe-bezglutenowe-bio-100-g-bio-planet 295/324
1750 baobab-sproszkowany-bio-150-g-bio-planet-superfoods 295/299
1751 camu-camu-sproszkowane-bio-150-g-bio-planet-superfoods 313
1759 ciecierzyca-bezglutenowa-bio-500-g-bio-planet 295/388
1760 daktyle-sproszkowane-bio-300-g-bio-planet 295/303
1764 kasza-gryczana-krakowska-niepalona-bio-500-g-bio-planet 295/391/404
1767 gryka-ekspandowana-bezglutenowa-bio-100-g-bio-planet 295/391/404
1784 fasolka-mung-bio-500-g-bio-planet 295/388
1787 herbata-zielona-matcha-bio-100-g-bio-planet-superfoods 295/389
1793 fasolka-czerwona-kidney-bio-1-kg-bio-planet 295/388
1794 fasolka-czarna-bio-500-g-bio-planet 295/388
1795 fasolka-czerwona-kidney-bio-500-g-bio-planet 295/388
1801 groch-zielony-polowki-bio-500-g-bio-planet 295/303
1802 groch-zielony-caly-bio-500-g-bio-planet 295/303
1807 daktyle-sproszkowane-bio-800-g-bio-planet 295/303
1808 jagody-goji-suszone-bio-1-kg-bio-planet 295/303
1813 amarantus-bio-500-g-bio-planet 295/391/404
1814 chipsy-bananowe-nieslodzone-bio-150-g-bio-planet 295/324
1815 ciecierzyca-bezglutenowa-bio-400-g-bio-planet 295/388
1816 daktyle-suszone-bezglutenowe-bio-150-g-bio-planet 295/303
1817 fasolka-czerwona-kidney-bio-400-g-bio-planet 295/388
1818 fasolka-mung-bio-400-g-bio-planet 295/388
1819 figi-suszone-bio-150-g-bio-planet 295/303
1820 ananas-suszony-krazki-bio-100-g-bio-planet 295/303
1843 fasolka-biala-bio-400-g-bio-planet 295/388
1847 daktyle-suszone-bezglutenowe-bio-1-kg-bio-planet 295/303
1849 figi-suszone-bio-400-g-bio-planet 295/303
1853 ciecierzyca-bezglutenowa-bio-5-kg-horeca-bio-planet 295/388
1855 jablka-suszone-krazki-bezglutenowe-bio-100-g-bio-planet 295/303
1859 fasolka-biala-jas-bio-400-g-bio-planet 295/388
1880 groch-zolty-bio-400-g-bio-planet 295/303
1882 ciecierzyca-bezglutenowa-bio-1-kg-bio-planet 295/388
1891 jagody-goji-suszone-bio-100-g-bio-planet 295/303
1892 jagody-goji-suszone-bio-250-g-bio-planet 295/303
1897 banany-suszone-bio-150-g-bio-planet 295/303
1900 amarantus-bio-1-kg-bio-planet 295/391/404
1913 bulion-kostki-warzywne-bez-dodatku-cukrow-i-drozdzy-bio-8-x-10-5-g-84-g-natur-compagnie 295/299
1918 bulion-kostki-warzywne-bez-dodatku-cukrow-bio-8-x-10-5-g-84-g-rapunzel 295/299
1924 barwniki-spozywcze-bezglutenowe-bio-6-x-8-g-48-g-biovegan 295/403
1929 cynamon-cejlonski-mielony-bio-50-g-lebensbaum 295/299
1930 kardamon-mielony-bio-10-g-lebensbaum 295/299
1939 kapusta-kiszona-z-marchewka-bio-680-g-410-g-runoland 295/306
1943 herbatka-dla-dzieci-rumianek-bio-20-x-1-g-20-g-apotheke 295/389
1947 herbata-czarna-z-imbirem-i-cynamonem-black-chai-bio-17-x-2-2-g-37-4-g-yogi-tea 295/389
1948 herbatka-mieta-z-lukrecja-licorice-mint-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
1951 herbatka-finest-selection-mix-herbatek-bio-6-x-3-torebki-34-2-g-yogi-tea 295/389
1952 kapusta-kiszona-z-marchewka-bezglutenowa-bio-700-g-500-g-biofood 295/306
1957 chalwa-miodowa-bio-75-g-allos 295/324
1958 buraczki-gotowane-na-parze-tarte-bezglutenowe-bio-420-g-farma-swietokrzyska 295/396
1987 algi-morskie-suszone-dulse-bio-25-g-porto-muinos 295/394
1988 herbatka-imbir-pomarancza-bio-20-x-1-5-g-30-g-apotheke 295/389
1989 herbatka-dla-matek-karmiacych-bio-20-x-1-5-g-30-g-apotheke 295/389
1995 herbatka-dla-dzieci-rooibos-bio-20-x-1-5-g-30-g-apotheke 295/389
2001 ciecierzyca-w-zalewie-bio-300-g-220-g-alce-nero 295/388
2005 chipsy-jablkowe-bezglutenowe-bio-30-g-biominki 295/324
2010 borowik-suszony-bio-20-g-runoland 313
2044 herbatka-dla-dzieci-koper-wloski-melisa-i-mieta-bio-20-x-1-5-g-30-g-apotheke 295/389
2045 herbatka-dla-dzieci-koper-wloski-bio-20-x-1-5-g-30-g-apotheke 295/389
2046 herbatka-dla-dzieci-dzika-roza-melisa-i-rokitnik-bio-20-x-1-5-g-30-g-apotheke 295/389
2047 herbatka-dla-dzieci-lipa-rumianek-i-mieta-bio-20-x-1-5-g-30-g-apotheke 295/389
2048 herbatka-dla-dzieci-owocowa-bio-20-x-2-g-40-g-apotheke 295/389
2049 herbatka-dla-dzieci-melisa-mieta-i-rumianek-bio-20-x-1-5-g-30-g-apotheke 295/389
2051 inulina-blonnik-z-agawy-bio-250-g-bio-planet-superfoods 313
2060 budyn-o-smaku-czekoladowym-bezglutenowy-bio-40-g-amylon 295/324
2061 budyn-waniliowy-bezglutenowy-bio-40-g-amylon 295/324
2081 herbata-czarna-sri-lanka-fair-trade-bio-100-x-1-8-g-180-g-oxfam 295/389
2087 herbata-zielona-lisciasta-sencha-bio-75-g-lebensbaum 295/389
2088 herbata-zielona-lisciasta-darjeeling-demeter-bio-50-g-lebensbaum 295/389
2089 herbata-zielona-lisciasta-gunpowder-bio-100-g-lebensbaum 295/389
2090 herbata-zielona-lisciasta-jasminowa-bio-75-g-lebensbaum 295/389
2092 herbatka-czekoladowa-z-kakao-choco-bio-17-x-2-2-g-37-4-g-yogi-tea 295/389
2093 herbatka-detox-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2094 herbatka-dla-kobiet-energia-womens-energy-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2095 herbatka-na-dobre-samopoczucie-wellbeing-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2096 herbatka-himalaya-bio-17-x-2-g-34-g-yogi-tea 295/389
2097 herbatka-imbirowo-pomaranczowa-z-wanilia-ginger-orange-with-vanilla-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2098 herbatka-imbirowo-cytrynowa-ginger-lemon-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2099 herbatka-klasyczna-classic-bio-17-x-2-2-g-37-4-g-yogi-tea 295/389
2100 herbatka-na-gardlo-throat-comfort-bio-17-x-1-9-g-32-3-g-yogi-tea 295/389
2101 herbatka-na-sen-bedtime-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2102 herbatka-rooibos-z-cynamonem-i-gozdzikami-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2103 herbatka-radosc-zycia-heartwarming-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2104 herbatka-tao-rose-bio-17-x-2-g-34-g-yogi-tea 295/389
2105 herbata-zielona-rownowaga-green-balance-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2110 algi-morskie-suszone-kombu-bio-25-g-porto-muinos 295/394
2111 algi-morskie-suszone-nori-platki-bio-25-g-porto-muinos 295/394
2112 algi-morskie-suszone-wakame-bio-25-g-porto-muinos 295/394
2115 cynamon-cejlonski-laska-bio-6-szt-lebensbaum 295/299
2119 herbatka-z-lukrecja-licorice-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2120 herbatka-dla-kobiet-womens-tea-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2121 herbata-zielona-energia-green-energy-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2122 budyn-o-smaku-smietankowym-bezglutenowy-bio-40-g-amylon 295/324
2124 herbatka-na-odpornosc-immune-support-bio-17-x-2-g-34-g-yogi-tea 295/389
2125 herbata-zielona-z-cytryna-i-matcha-green-tea-matcha-lemon-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2133 herbata-zielona-sencha-bio-20-x-1-5-g-30-g-lebensbaum 295/389
2134 herbatka-na-trawienie-stomach-ease-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2142 herbata-english-breakfast-fair-trade-bio-250-x-2-2-g-550-g-clipper 295/389
2143 herbatka-z-imbirem-i-cytryna-bio-250-x-2-5-g-625-g-clipper 295/389
2144 herbatka-z-miety-pieprzowej-fair-trade-bio-250-x-1-5-g-375-g-clipper 295/389
2146 dzika-roza-liofilizowana-sproszkowana-bio-70-g-dary-natury 313
2151 chlorella-spirulina-bio-375-tabletek-diet-food 313
2157 herbata-czerwona-lisciasta-pu-erh-bio-70-g-ecoblik 295/389
2158 herbata-zielona-lisciasta-sencha-japonska-bio-70-g-ecoblik 295/389
2166 herbatka-rokitnikowa-z-reishi-lions-mane-i-cordyceps-bio-70-g-ani 295/389
2198 herbatka-orzezwiajaca-czerwona-pomarancza-tangy-blood-orange-bio-17-x-2-g-34-g-yogi-tea 295/389
2199 herbatka-lekki-brzuch-happy-belly-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2200 herbatka-mango-chai-bio-17-x-2-g-34-g-yogi-tea 295/389
2201 ekstrakt-z-waleriany-w-kroplach-bio-50-ml-royal-brand 313
2202 chili-nitki-40-g-royal-brand 295/299
2204 betaina-pepsyna-bezglutenowa-60-kapsulek-pharmovit-clean-label 313
2207 herbata-earl-grey-fair-trade-bio-250-x-2-0-g-500-g-clipper 295/389
2208 herbatka-rooibos-bio-250-x-2-0-g-500-g-clipper 295/389
2211 chipsy-z-ciecierzycy-z-sola-morska-i-czarnym-pieprzem-bezglutenowe-bio-75-g-onest 295/324
2212 chipsy-z-soczewicy-paprykowe-bezglutenowe-bio-75-g-onest 295/324
2213 chipsy-z-soczewicy-z-rozmarynem-bezglutenowe-bio-75-g-onest 295/324
2214 chipsy-z-ciecierzycy-z-curry-bezglutenowe-bio-75-g-onest 295/324
2215 chipsy-z-ciecierzycy-z-sola-morska-i-czarnym-pieprzem-bezglutenowe-bio-40-g-onest 295/324
2225 chipsy-z-soczewicy-paprykowe-bezglutenowe-bio-75-g-john-altman 295/324
2226 chipsy-z-soczewicy-z-sola-i-czarnym-pieprzem-bezglutenowe-bio-75-g-john-altman 295/324
2227 baton-bakaliowy-z-kakao-kosmos-bezglutenowy-70-g-zmiany-zmiany 295/324
2231 cla-60-kapsulek-so-good 313
2232 immunity-booster-w-proszku-180-g-so-good 313
2233 hydration-all-day-w-proszku-270-g-so-good 313
2244 inozytol-max-750-mg-bezglutenowy-60-kapsulek-pharmovit-clean-label 313
2274 budyn-truskawkowy-bezglutenowy-bio-40-g-amylon 295/324
2276 ciecierzyca-w-zalewie-bio-400-g-240-g-la-bio-idea 295/401
2278 fasolka-czerwona-kidney-w-zalewie-bio-400-g-240-g-la-bio-idea 295/401
2279 fasola-maslowa-w-zalewie-bio-400-g-240-g-la-bio-idea 295/401
2281 coconut-milk-napoj-kokosowy-bez-gumy-guar-22-tluszczu-bio-200-ml-terrasana 295/389
2290 blonnik-luski-babki-jajowatej-bio-115-g-apotheke 313
2291 herbatka-pozytywna-energia-zurawina-hibiskus-positive-energy-cranberry-hibiscus-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2301 herbata-czarna-cejlonska-fair-trade-bio-20-x-2-g-40-g-lebensbaum 295/389
2307 herbatka-rokitnikowa-z-mieta-i-pomarancza-bio-20-x-1-8-g-36-g-apotheke 295/389
2309 borowik-suszony-bio-60-g-runoland 295/405
2314 herbatka-dla-mezczyzn-mens-tea-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2331 chipsy-jablkowe-bezglutenowe-bio-polska-50-g-bio-raj 295/324
2336 granola-z-kakao-bez-dodatku-cukrow-bezglutenowa-bio-320-g-papagrin 295/391/392
2337 granola-z-goji-bez-dodatku-cukrow-bezglutenowa-bio-320-g-papagrin 295/391/392
2338 granola-figa-z-kokosem-bez-dodatku-cukrow-bezglutenowa-bio-320-g-papagrin 295/391/392
2342 chipsy-z-ciecierzycy-z-sola-morska-bio-75-g-trafo 295/324
2345 herbatka-wewnetrzna-harmonia-inner-harmony-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2346 herbata-biala-z-aloesem-white-tea-with-aloe-vera-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2350 imbir-mielony-bio-40-g-lebensbaum 295/299
2359 erytrytol-500-g-batom 295/390
2362 herbatka-zloty-chai-z-kurkuma-turmeric-chai-bio-17-x-2-g-34-g-yogi-tea 295/389
2363 daktyle-suszone-bezglutenowe-bio-100-g-biominki 295/303
2366 aronia-80-bio-260-g-sad-dankow 295/362
2367 jagoda-80-bio-260-g-sad-dankow 295/362
2368 jezyna-80-bio-260-g-sad-dankow 295/362
2372 czarny-bez-80-bio-260-g-sad-dankow 295/362
2373 czarna-porzeczka-80-bio-260-g-sad-dankow 295/362
2374 czerwona-porzeczka-80-bio-260-g-sad-dankow 295/362
2375 herbata-zielona-jasminowa-bio-20-x-1-5-g-30-g-lebensbaum 295/389
2379 cykoria-instant-bezglutenowa-bio-100-g-lima 295/389
2383 granola-figa-z-kokosem-bez-dodatku-cukrow-bezglutenowa-bio-60-g-papagrin 295/391/392
2385 herbatka-dla-kobiet-rownowaga-womens-balance-bio-17-x-1-8-g-30-6-g-yogi-tea 295/389
2386 erytrytol-1-kg-batom 295/390
2388 cynamon-cejlonski-ekstrakt-400-mg-60-kapsulek-soul-farm 295/299
2389 graviola-ekstrakt-550-mg-60-kapsulek-soul-farm 313
2393 kakao-w-proszku-fair-trade-bezglutenowe-bio-150-g-alternativa3 295/393