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 (
    2825, 
    2827, 
    2562, 
    2563, 
    2564, 
    12698, 
    2626, 
    2624, 
    12711, 
    2839, 
    2840, 
    2835, 
    2836, 
    2838, 
    2841, 
    2834, 
    2837, 
    13543, 
    13547, 
    13545, 
    13544, 
    2544, 
    2750, 
    2752, 
    2748, 
    2746, 
    2747, 
    2749, 
    2751, 
    15127, 
    14590, 
    2778, 
    2779, 
    2677, 
    12691, 
    12690, 
    11136, 
    2772, 
    15123, 
    2754, 
    2634, 
    14659, 
    13548, 
    13533, 
    16585, 
    11120, 
    12706, 
    12702, 
    12704, 
    12703, 
    12705, 
    4386, 
    4387, 
    13994, 
    4388, 
    2575, 
    2774, 
    2773, 
    16717, 
    15137, 
    2743, 
    2742, 
    2756, 
    2755, 
    15156, 
    11810, 
    15131, 
    2784, 
    2786, 
    2791, 
    11133, 
    2790, 
    2785, 
    2787, 
    2788, 
    2789, 
    15385, 
    2608, 
    2609, 
    2610, 
    2611, 
    2612, 
    15476, 
    11135, 
    2763, 
    2764, 
    2831, 
    2832, 
    15312, 
    15977, 
    17299, 
    2844, 
    17012, 
    2679, 
    2669, 
    2683, 
    2680, 
    2675, 
    2674, 
    2616, 
    2615, 
    2552, 
    11121, 
    2618, 
    12686, 
    12687, 
    2845, 
    2643, 
    14662, 
    11805, 
    2803, 
    16261, 
    2580, 
    4394, 
    2769, 
    2768, 
    2766, 
    15149, 
    15978, 
    15146, 
    15147, 
    15477, 
    2640, 
    12975, 
    11118, 
    12685, 
    2566, 
    3215, 
    3214, 
    15154, 
    13222, 
    14298, 
    13223, 
    16052, 
    2733, 
    2736, 
    2734, 
    2735, 
    15140, 
    2829, 
    2659, 
    14661, 
    15424, 
    2681, 
    2770, 
    2771, 
    2731, 
    15130, 
    17301, 
    15153, 
    2725, 
    2728, 
    2732, 
    2729, 
    2722, 
    2828, 
    14663, 
    2714, 
    2715, 
    2716, 
    2717, 
    2713, 
    2623, 
    2622, 
    15969, 
    2730, 
    15128, 
    2724, 
    2726, 
    2727, 
    15544, 
    16335, 
    15151, 
    15150, 
    15423, 
    3216, 
    2718, 
    2721, 
    2678, 
    15973, 
    15426, 
    2567, 
    2557, 
    2569, 
    2556, 
    2822, 
    2808, 
    2843, 
    2813, 
    2814, 
    2600, 
    2597
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00713

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "151.96"
    },
    "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": 231,
      "rows_produced_per_join": 231,
      "filtered": "100.00",
      "index_condition": "((`dev_yourmart_co_bw`.`cscart_seo_names`.`object_id` in (2825,2827,2562,2563,2564,12698,2626,2624,12711,2839,2840,2835,2836,2838,2841,2834,2837,13543,13547,13545,13544,2544,2750,2752,2748,2746,2747,2749,2751,15127,14590,2778,2779,2677,12691,12690,11136,2772,15123,2754,2634,14659,13548,13533,16585,11120,12706,12702,12704,12703,12705,4386,4387,13994,4388,2575,2774,2773,16717,15137,2743,2742,2756,2755,15156,11810,15131,2784,2786,2791,11133,2790,2785,2787,2788,2789,15385,2608,2609,2610,2611,2612,15476,11135,2763,2764,2831,2832,15312,15977,17299,2844,17012,2679,2669,2683,2680,2675,2674,2616,2615,2552,11121,2618,12686,12687,2845,2643,14662,11805,2803,16261,2580,4394,2769,2768,2766,15149,15978,15146,15147,15477,2640,12975,11118,12685,2566,3215,3214,15154,13222,14298,13223,16052,2733,2736,2734,2735,15140,2829,2659,14661,15424,2681,2770,2771,2731,15130,17301,15153,2725,2728,2732,2729,2722,2828,14663,2714,2715,2716,2717,2713,2623,2622,15969,2730,15128,2724,2726,2727,15544,16335,15151,15150,15423,3216,2718,2721,2678,15973,15426,2567,2557,2569,2556,2822,2808,2843,2813,2814,2600,2597)) and (`dev_yourmart_co_bw`.`cscart_seo_names`.`type` = 'p') and (`dev_yourmart_co_bw`.`cscart_seo_names`.`dispatch` = '') and (`dev_yourmart_co_bw`.`cscart_seo_names`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "128.86",
        "eval_cost": "23.10",
        "prefix_cost": "151.96",
        "data_read_per_join": "391K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
2544 backsberg-750ml-chardonnay-1-x-750ml-1s 265/356
2552 fleur-du-cap-chenin-blanc-wine-1-x-750ml-ea 265/356
2556 lomond-wine-syrah-1-x-750ml-1s 265/356
2557 lomond-wine-sauvignon-blanc-1-x-750ml-1s 265/356
2562 4th-street-3lt-wine-red-natural-sweet-1-x-3lt-disc 265/356
2563 4th-street-5lt-wine-red-natural-sweet-1-x-5lt-1s 265/356
2564 4th-street-5lt-wine-rose-natural-sweet-1-x-5lt-1s 265/356
2566 999-j.c.le-roux-non-alcoholic-le-domaine-1-x-750ml-1s 265/356
2567 lomond-wine-pinot-noir-1-x-750ml-1s 265/356
2569 lomond-red-wine-shirazmouvedreviognier-1-x-750ml-1s 265/356
2575 chateau-libertas-wine-1-x-750ml-bottle 265/356
2580 graca-wine-dry-white-1-x-750ml-bottle 265/356
2597 monis-750ml-sherry-med-crm-1-x-750ml-1s 265/356
2600 monis-750ml-sherry-full-crm-1-x-750ml-1s 265/356
2608 durbanville-hills-wine-chardonnay-dry-white-1-x-750ml-1s 265/356
2609 durbanville-hills-wine-750ml-merlot-1-x-750ml-bottle 265/356
2610 durbanville-hills-pinotage-red-1-x-750ml-1s 265/356
2611 durbanville-hills-wine-750ml-sauvignon-blanc-1-x-750ml-1s 265/356
2612 durbanville-hills-wine-750ml-shiraz-1-x-750ml-1s 265/356
2615 fleur-du-cap-chardonnay-wine-1-x-750ml-ea 265/356
2616 fleur-du-cap-cabernet-sauvignon-wine-1-x-750ml-1s-.jpeg 265/356
2618 fleur-du-cap-sauvignon-blanc-wine-1-x-750ml-bottle 265/356
2622 la-mottee-wine-sauvignon-blanc-1-x-750ml-1s 265/356
2623 la-mottee-millennium-wine-1-x-750ml-1s 265/356
2624 alto-750ml-wine-rouge-1-x-750ml-bottle 265/356
2626 allesverloren-750ml-port-1-x-750ml-1s 265/356
2634 boschendal-750ml-wine-brut-nv-1-x-750ml-1s 265/356
2640 999-homestead-wine-sauvignon-blanc-1-x-750ml-1s 265/356
2643 french-quarter-wine-white-1-x-750ml-1s 265/356
2659 kanonkop-750ml-wine-pinotage-1-x-750ml-1s 265/356
2669 fat-bastard-750ml-wine-chardonnay-1-x-750ml-1s 265/356
2674 fat-bastard-750ml-wine-shiraz-1-x-750ml-1s 265/356
2675 fat-bastard-750ml-wine-sauvignon-blanc-1-x-750ml-1s 265/356
2677 barista-wine-coffee-pinotage-1-x-750ml-1s 265/356
2678 leeuwenkuil-wine-shiraz-1-x-750ml-1s 265/356
2679 fat-bastard-750ml-wine-cabernet-sauvignon-1-x-750ml-1s 265/356
2680 fat-bastard-pinotage-wine-1-x-750ml-1s 265/356
2681 krone-750ml-night-nec-vitage-demi-sec-orig-1-x-750ml-1s 265/356
2683 fat-bastard-merlot-wine-1-x-750ml-1s 265/356
2713 la-capra-wine-750ml-sauv-blanc-2011-1-x-750ml-1s 265/356
2714 la-capra-wine-750ml-chenin-blanc-1-x-750ml-1s 265/356
2715 la-capra-wine-750ml-merlot-1-x-750ml-1s 265/356
2716 la-capra-wine-pinot-grigio-white-1-x-750ml-1s 265/356
2717 la-capra-wine-red-sangiovese-1-x-750ml-1s 265/356
2718 landskroon-wine-cabernet-sauvignon-1-x-750ml-1s 265/356
2721 landskroon-chardonnay-1-x-750ml-1s 265/356
2722 kwv-750ml-wine-port-cape-ruby-sp-1-x-750ml-1s 265/356
2724 laborie-750ml-wine-chenin-blanc-1-x-750ml-1s 265/356
2725 kwv-750ml-wine-classic-merlot-1-x-750ml-bottle 265/356
2726 laborie-wine-merlot-1-x-750ml-1s 265/356
2727 laborie-wine-sauvignon-blanc-1-x-750ml-1s 265/356
2728 kwv-750ml-wine-pinotage-1-x-750ml-1s 265/356
2729 kwv-750ml-wine-classic-shiraz-1-x-750ml-bottle 265/356
2730 laborie-wine-merlot-cabernet-sauvignon-1-x-750ml-1s 265/356
2731 kwv-750ml-wine-classic-chenin-blanc-1-x-750ml-bottle 265/356
2732 kwv-750ml-wine-classic-sauvignon-blanc-1-x-750ml-bottle 265/356
2733 kaapzicht-wine-sauvignon-merlot-and-cab-bin-3-reserve-1-x-750ml-1s 265/356
2734 kaapzicht-wine-merlot-1-x-750ml-1s 265/356
2735 kaapzicht-wine-sauvignon-blanc-1-x-750ml-1s 265/356
2736 kaapzicht-wine-chenin-blanc-1-x-750ml-1s 265/356
2742 de-krans-750ml-wine-ruby-port-1-x-750ml-1s 265/356
2743 de-krans-wine-cape-tawny-port-1-x-750ml-1s 265/356
2746 balance-wine-semillon-sauvignon-blanc-1-x-750ml-1s 265/356
2747 balance-wine-750ml-shiraz-1-x-750ml-1s 265/356
2748 balance-wine-makers-sauvignon-blanc-1-x-750ml-1s 265/356
2749 balance-winemakers-chenin-blanc-1-x-750ml-1s 265/356
2750 balance-winemakers-merlot-1-x-750ml-1s 265/356
2751 balance-wine-750ml-cabernet-sauvignon-1-x-750ml-1s 265/356
2752 balance-wine-makers-pinot-noir-1-x-750ml-1s 265/356
2754 boland-750ml-wine-cabernet-sauvignon-2007-1-x-750ml-1s 265/356
2755 diemersdal-wine-sauvignon-blanc-1-x-750ml-1s 265/356
2756 diemersdal-wine-merlot-1-x-750ml-1s 265/356
2763 excelsior-wine-750ml-chardonnay-2007-1-x-750ml-1s 265/356
2764 excelsior-wine-cabernet-sauvignon-2007-si-1-x-750ml-1s 265/356
2766 graham-beck-wine-brut-spark-1-x-750ml-1s 265/356
2768 graham-beck-wine-brut-rose-1-x-750ml-1s 265/356
2769 graham-beck-375ml-wine-brut-1-x-375ml-1s 265/356
2770 krone-750ml-wine-spark-brut-borealis-cuvee-1-x-750ml-1s 265/356
2771 krone-750ml-wine-spark-brut-rose-cuvee-1-x-750ml-1s 265/356
2772 beyerskloof-wine-pinotage-1-x-750ml-1s 265/356
2773 clos-malverne-wine-merlot-red-1-x-750ml-1s 265/356
2774 clos-malverne-wine-chardonnay-white-1-x-751ml-1s 265/356
2778 bardo-wine-classic-dry-white-1-x-1lt-1s 265/356
2779 bardo-wine-classic-red-1-x-1lt-1s 265/356
2784 du-toitskloof-750ml-wine-white-chardonnay-1-x-750ml-1s 265/356
2785 du-toitskloof-wine-cellar-sauvignon-blanc-1-x-750ml-1s 265/356
2786 du-toitskloof-750ml-wine-chenin-blanc-1-x-750ml-1s 265/356
2787 du-toitskloof-750ml-wine-shiraz-1-x-750ml-1s 265/356
2788 du-toitskloof-750ml-wine-spark-brut-1-x-750ml-1s 265/356
2789 du-toitskloof-500ml-wine-hanepoort-jerepi-1-x-500ml-1s 265/356
2790 du-toitskloof-wine-pinotmerlotruby-cabernet-1-x-750ml-1s 265/356
2791 du-toitskloof-wine-cellar-pinotage-2009-1-x-750ml-1s 265/356
2803 gm-and-ahrens-wine-vintage-cuvee-1-x-750ml-1s 265/356
2808 lutzville-cape-diamond-wine-merlot-1-x-750ml-1s 265/356
2813 meerlust-wine-chardonnay-2008-1-x-750ml-1s 265/356
2814 meerlust-wine-rubicon-1-x-750ml-1s 265/356
2822 lookout-wine-750ml-pinotage-rose-2010-1-x-750ml-1s 265/356
2825 1659-south-africa-wine-750ml-merlot-cinsault-cab-sauv-1-x-750ml-1s 265/356
2827 historic-wine-savignon-blanc-1659-1-x-750ml-1s 265/356
2828 l-ormarins-750ml-brut-classique-sparkling-wine-1-x-750ml-1s 265/356
2829 kanonkop-750ml-wine-kadette-1-x-750ml-1s 265/356
2831 fabulous-750ml-wine-sweet-red-1-x-750ml-1s 265/356
2832 fabulous-750ml-wine-sweet-rose-1-x-750ml-1s 265/356
2834 arabella-wine-750ml-sauvignon-blanc-1-x-750ml-1s 265/356
2835 arabella-wine-750ml-chenin-blanc-1-x-750ml-1s 265/356
2836 arabella-wine-750ml-merlot-1-x-750ml-1s 265/356
2837 arabella-wine-750ml-shiraz-1-x-750ml-1s 265/356
2838 arabella-wine-750ml-pink-panacea-1-x-750ml-1s 265/356
2839 arabella-wine-750ml-cabernet-sauvignon-1-x-750ml-1s 265/356
2840 arabella-wine-750ml-chardonnay-1-x-750ml-1s 265/356
2841 arabella-wine-750ml-pinotage-1-x-750ml-1s 265/356
2843 margaret-wine-rose-1-x-750ml-1s 265/356
2844 fantinel-750ml-wine-prosecco-extra-dry-1-x-750ml-1s 265/356
2845 french-quarter-wine-red-1-x-750ml-1s 265/356
3214 j.c.le-roux-spark-wine-le-domaine-1-x-750ml-bottle 265/356
3215 j.c.le-roux-spark-wine-la-chanson-1-x-750ml-bottle 265/356
3216 landskroon-wine-cabernet-franc-merlot-red-1-x-750ml-1s 265/356
4386 chateau-del-rei-perle 265/356
4387 chateau-del-rei-rose 265/356
4388 chateau-del-rei-dry 265/356
4394 graham-beck-bliss-nectar-demi-sec-750ml 265/356
11118 j.c.le-roux-vibrazio-demi-sec-1-x-750ml-1s 265/356
11120 cellar-cask-wine-johannisberger-red-1-x-5lt-box 265/356
11121 fleur-du-cap-merlot-wine-1-x-750ml-1s 265/356
11133 cederberg-wine-750ml-chenin-blanc-1-x-750ml-1s 265/356
11135 ernie-els-wine-750ml-big-easy-white-1-x-750ml-1s 265/356
11136 beyerskloof-750ml-chenin-pinotage-wine-6-x-750ml 265/356
11805 glen-carlou-750ml-wine-chardonnay-1-x-750ml-1s 265/356
11810 diemersfontein-wine-pinotage-1-x-750ml-1s 265/356
12685 j.c.le-roux-spark-wine-demi-sec-nectar-rose-1-x-750ml-ea 265/356
12686 franschhoek-cellar-brut-rose-nv-1-x-750ml-ea 265/356
12687 franschhoek-cellar-cellar-brut-royale-1-x-750ml-ea 265/356
12690 bellingham-wine-homestead-light-sau-blanc-1-x-750ml-ea 265/356
12691 bellingham-homestead-light-pinotage-1-x-750ml-ea 265/356
12698 999-vergelegen-wine-mill-race-red-1-x-750ml-1s 265/356
12702 cellar-select-wine-cabernet-sauvignon-merlot-1-x-750ml-1s 265/356
12703 cellar-select-wine-merlot-1-x-750ml-1s 265/356
12704 cellar-select-wine-chardonnay-1-x-750ml-1s 265/356
12705 cellar-select-wine-sauvignon-blanc-1-x-750ml-1s 265/356
12706 cellar-select-wine-cabernet-sauvignon-1-x-750ml-1s 265/356
12711 alvis-drift-brut-rose-sparkling-1-x-750ml-ea 265/356
12975 indaba-chardonnay 265/356
13222 jordan-chameleon-750ml-wine-red-1-x-750ml 265
13223 jordan-wine-chardonnay-chameleon-sav-blanc-1-x-750ml 265
13533 cape-town-wine-co.-sauvignon-blanc 265/356
13543 arra-vineyards-natural-sweet-red-blend 265/356
13544 arra-vineyards-pinotage 265/356
13545 arra-vineyards-cape-blend 265/356
13547 arra-vineyards-cabernet-sauvignon-shiraz 265/356
13548 cape-town-wine-co.-merlot-cab-sav-cab-franc-blend 265/356
13994 chateau-del-rei-sweet-red-24-x-250-ml 265
14298 jordan-chenin-blanc-2023 265
14590 balance-winemakers-pinot-grigio 265
14659 cape-of-good-hope-parel-vallei-merlot-750ml 265
14661 ken-forrester-old-vine-reserve-chenin-blanc-2021-750ml 265
14662 cederberg-ghost-corner-sauvignon-blanc-750ml 265
14663 lormarins-private-cuvee-750ml 265
15123 bigfeet-sauvignon-blanc 265
15127 balance-winemakers-selection-chardonnay-2017-1-x-750ml 265
15128 laborie-chardonnay-2022-1-x-750ml 265
15130 kwv-classic-collection-chardonnay-2022-1-x-750ml 265
15131 du-toitskloof-cabernet-sauvignon-1-x-750ml 265
15137 de-grendel-merlot-2016-1-x-750ml 265
15140 kanonkop-kadette-pinotage-rose-2024-1-x-750ml 265
15146 haute-cabriere-chardonnay-pinot-noir-1-x-750ml 265
15147 haute-cabriere-pinot-noir-rose-2022-wine-co-za 265
15149 groot-constantia-merlot-2020-groot-constantia 265
15150 landskroon-pinotage-2022-1-x-750ml 265
15151 landskroon-merlot-2022-1-x-750ml 265
15153 kwv-roodeberg-reserve-2020-1-x-750ml 265
15154 jordan-black-magic-merlot-2022-1-x-750ml 265
15156 diemersfontein-cabernet-sauvignon-2019-1-x-750ml 265
15312 fairview-chardonnay-2021-1-x-750ml 265
15385 durbanville-hills-cabernet-sauvignon-750ml 265/356
15423 landskroon-shiraz-2016-1-x-750ml 265
15424 kleine-zalze-cellar-selection-cabernet-sauvignon-merlot-2021-1-x-750ml 265
15426 loch-lomond-original-single-malt-whisky-1-x-750ml 265
15476 ernie-els-big-easy-cabernet-sauvignon-750ml-x-1 265
15477 haute-cabriere-unwooded-pinot-noir-2017-750ml 265
15544 land-of-the-giant-sauv-blan-6x750ml 265/356
15969 laborie-merlot-2023-750ml-x-1 265
15973 leopards-leap-special-edition-pinotage-2022 265
15977 fairview-sauvignon-blanc-1-x-750ml 265
15978 groot-constantia-sauvignon-blanc-2023-1-x-750ml 265
16052 jordan-the-prospector-syrah-2022-750ml-x-1 265
16261 goats-do-roam-rose-2024-1-x-750ml 265
16335 land-of-the-giant-shiraz-6x750ml 265/356
16585 cathedral-cellar-cabernet-sauvignon-2017-1-x-750ml 265
16717 da-luca-prosecco-doc-1-x-750ml 265/356
17012 fat-bastard-chenin-blanc-1-x-750ml 265
17299 fairview-shiraz-1-x-750-ml 265/356
17301 kwv-classic-sauvignon-blanc-1x750ml 265/356