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 (
    1, 
    228, 
    8, 
    9, 
    10, 
    8483, 
    71, 
    4, 
    2359, 
    1532, 
    8499, 
    8502, 
    8501, 
    2459, 
    1528, 
    2432, 
    2455, 
    1517, 
    2438, 
    8498, 
    7624, 
    8484, 
    8497, 
    2812, 
    7608, 
    8485, 
    1538, 
    8488, 
    8486, 
    8492, 
    8487, 
    7614, 
    8503, 
    8505, 
    7613, 
    8496, 
    8489, 
    7248, 
    7615, 
    2465, 
    7290, 
    8490, 
    7283, 
    8491, 
    8493, 
    7625, 
    7285, 
    7294, 
    7261, 
    7611, 
    7612, 
    2441, 
    7616, 
    7293, 
    7279, 
    7617, 
    7620, 
    7618, 
    7619, 
    7281, 
    7610, 
    7277, 
    7609, 
    7623, 
    7621, 
    7622, 
    2832, 
    8478, 
    8474, 
    8475, 
    6380, 
    10136, 
    10137, 
    8512, 
    3506, 
    8513, 
    8510, 
    4949, 
    10135, 
    5985, 
    8511, 
    2462, 
    2827, 
    5767, 
    6459, 
    8717, 
    5971, 
    2439, 
    10138, 
    6451, 
    8716, 
    8711, 
    2833, 
    8266, 
    8265, 
    8267, 
    8712, 
    6381, 
    5986, 
    8264, 
    8509, 
    8507, 
    8508, 
    6447, 
    6373, 
    6440, 
    8714, 
    8713, 
    8720, 
    8718, 
    8719, 
    8715, 
    6590, 
    6379, 
    8722, 
    6336, 
    8494, 
    8506, 
    6444, 
    8721, 
    5973, 
    5989, 
    5994, 
    6593, 
    6594, 
    9625, 
    6592, 
    10127, 
    10193, 
    6454, 
    10133, 
    10095, 
    10120, 
    10128, 
    10122, 
    10217, 
    10312, 
    10196, 
    10315, 
    10317, 
    10198, 
    10139, 
    10201, 
    10216, 
    10320, 
    10200, 
    10121, 
    10134, 
    10321, 
    10322, 
    10323, 
    10314, 
    10319, 
    9642, 
    10199, 
    10310, 
    10316, 
    8947, 
    10202, 
    10309
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00671

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "117.86"
    },
    "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": 173,
      "rows_produced_per_join": 173,
      "filtered": "100.00",
      "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`object_id` in (1,228,8,9,10,8483,71,4,2359,1532,8499,8502,8501,2459,1528,2432,2455,1517,2438,8498,7624,8484,8497,2812,7608,8485,1538,8488,8486,8492,8487,7614,8503,8505,7613,8496,8489,7248,7615,2465,7290,8490,7283,8491,8493,7625,7285,7294,7261,7611,7612,2441,7616,7293,7279,7617,7620,7618,7619,7281,7610,7277,7609,7623,7621,7622,2832,8478,8474,8475,6380,10136,10137,8512,3506,8513,8510,4949,10135,5985,8511,2462,2827,5767,6459,8717,5971,2439,10138,6451,8716,8711,2833,8266,8265,8267,8712,6381,5986,8264,8509,8507,8508,6447,6373,6440,8714,8713,8720,8718,8719,8715,6590,6379,8722,6336,8494,8506,6444,8721,5973,5989,5994,6593,6594,9625,6592,10127,10193,6454,10133,10095,10120,10128,10122,10217,10312,10196,10315,10317,10198,10139,10201,10216,10320,10200,10121,10134,10321,10322,10323,10314,10319,9642,10199,10310,10316,8947,10202,10309)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`type` = 'p') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`dispatch` = '') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "100.56",
        "eval_cost": "17.30",
        "prefix_cost": "117.86",
        "data_read_per_join": "293K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
1 lg-uhd-ut8000-4k-2024 166/174/190
4 lg-qned-86-4k-2024 166/174/190
8 lg-qned-90-miniled-4k-2024 166/174/190
9 lg-nanocell-nano80-4k-2024 166/174/190
10 lg-uhd-b4-oled-4k-2024 166/174/190
71 lg-qned-80-4k-2024 166/174/190
228 lg-evo-uhd-c4-oled-4k-2024 166/174/190
1517 oled-s90d-4k-tizen-os-smart-tv-2024 166/174/190
1528 qled-q70d-series-4k-smart-tv-2024 166/174/190
1532 qled-4k-q60d-tizen-os-smart-tv 166/174/190
1538 crystal-uhd-du8100-4k-tizen-os-smart-tv-2024 166/174/190
2359 xiaomi-mi-3-1-soundbar 166/329/527
2432 xiaomi-tv-a-pro-2026 166/174/190
2438 xiaomi-tv-a-2026 166/174/190
2439 xiaomi-tv-max-2025 166/174/190
2441 xiaomi-tv-s-mini-2025 166/174/190
2455 xiaomi-tv-a-pro-2025 166/174/190
2459 xiaomi-tv-a-2025 166/174/190
2462 xiaomi-tv-max-86-2024 372/453/454
2465 xiaomi-tv-q2-65-l65m7-q2me 166/174/190
2812 jbl-bar-500-pro-black 166/174/337
2827 jbl-bar-800-5-1-2-channel-soundbar-with-detachable-speakers 166/329/527
2832 jbl-bar-1000-pro-black 166/174/337
2833 jbl-bar-1300-channel-soundbar-with-detachable-surround-speakers 166/174/337
3506 epson-co-w01-projector 166/174/486
4949 tcl-tv-p7k-uk-qled-direct-led-tv-4k-hdr-tv-smart 166/174/190
5767 lg-86-inch-lg-uhd-ai-ut80-4k-smart-tv-ai-magic-remote-hdr10-webos24-2024 166/174/190
5971 lg-75-inch-lg-qned-evo-ai-qned86-miniled-4k-120hz-smart-tv-ai-magic-remote-webos25-2025 166/174/190
5973 lg-86-inch-nanocell-ai-nano80-4k-smart-tv-ai-magic-remote-hdr10-webos25-2025-en 166/174/190
5985 lg-50-inch-uhd-ai-ua85-4k-smart-tv-ai-magic-remote-hdr10-webos25-2025 166/174/190
5986 lg-qned82-65-inch-4k-smart-tv-with-ai-technology-and-ai-magic-control-hdr10-and-webos-25-model 166/174/190
5989 lg-oled-evo-tv-83-inch-c3-series-webos-smart-ai-thinq-magic-remote-4-side-cinema-dolby-vision-hdr10-hlg-ai-picture-pro-ai-sound-pro-9-1-2ch-dolby-atmos-1-pole-stand 166/174/190
5994 lg-65-inch-oled-evo-g4-4k-smart-tv-ai-magic-remote-dolby-vision-webos24-2024 166/174/190
6336 tcl-tv-t6c-smart-tv-4k-qled-colorful-quantum-crystal-hdr-10-dolby-vision-atmos 166/174/190
6373 tcl-tv-q6c-premium-qd-mini-led 372/453/454
6379 tcl-audio-q85h-pro-home-theater-soundbar 166/329/527
6380 tcl-audio-q75h-speaker-with-dolby-atmos 166/329/527
6381 tcl-audio-q65h-5-1ch-high-end-home-theater-soundbar 166/329/527
6440 tcl-p8k-uk-4k-qled-hdr-smart-tv-4k-ultra-hd-google-tv-with-144hz-motion-clarity-pro-and-onkyo-2-1-sound 166/174/190
6444 tcl-4k-144hz-qled-tv-with-google-tv-and-game-master-pro-3-0 166/174/190
6447 tcl-tv-4k-uhd-p755 166/174/190
6451 tcl-television-c755-qd-mini-led 166/174/190
6454 tcl-tv-43-43p735-black 372/453/454
6459 tcl-tv-c8k-premium-qd-mini-led-144hz 372/453/454
6590 toshiba-television-z670mw-qled-4k-ultra-hd 166/174/190
6592 toshiba-television-qled-4-k-ultra-hd-black 166/174/190
6593 toshiba-tv-85-85m550lw-2023 166/174/190
6594 toshiba-tv-65-65x8900kw-black 166/174/190
7248 hisense-65-inch-a62qs-series-4k-uhd-smart-tv 166/174/190
7261 hisense-q6gn-qd6-series-qled-4k-smart-tv 372/453/454
7277 hisense-a61n-smart-led-tv 372/453/454
7279 hisense-u7q-ultra-hd-4k-mini-led-smart-tv 372/453/454
7281 hisense-a61n-smart-television-4k-uhd-display 166/174/190
7283 hisense-q7q-qled-ai-4k-smart-tv 166/174/190
7285 hisense-a6500n-series-4k-uhd-smart-led-tv 372/453/454
7290 hisense-a62ns-4k-uhd-smart-led-tv 372/453/454
7293 hisense-a4q-series-fhd-smart-led-tv 372/453/454
7294 hisense-a4n-smart-hd-led-tv 166/174/190
7608 hisense-u7q-ultra-hd-4k-mini-led-smart-tv-en 372/453/454
7609 hisense-q6gn-qd6-series-qled-4k-smart-tv-en 372/453/454
7610 hisense-q6gn-qd6-series-qled-4k-smart-tv-en-3 372/453/454
7611 hisense-q6gn-qd6-series-qled-4k-smart-tv-en-2 372/453/454
7612 hisense-a62qs-series-4k-uhd-smart-tv 166/174/190
7613 hisense-a62qs-series-4k-uhd-smart-tv-en 166/174/190
7614 hisense-a62qs-series-4k-uhd-smart-tv-en-2 166/174/190
7615 hisense-u7n-mini-led-uled-4k-vidaa-smart-tv 166/174/190
7616 hisense-q7q-qled-ai-4k-smart-tv-en 166/174/190
7617 hisense-a6500n-series-4k-uhd-smart-led-tv-en 372/453/454
7618 hisense-a6500n-series-4k-uhd-smart-led-tv-en-2 372/453/454
7619 hisense-a6500n-series-4k-uhd-smart-led-tv-en-3 372/453/454
7620 hisense-a6500n-series-4k-uhd-smart-led-tv-en-4 372/453/454
7621 hisense-a62ns-4k-uhd-smart-led-tv-en 372/453/454
7622 hisense-a62ns-4k-uhd-smart-led-tv-en-2 372/453/454
7623 hisense-a61n-smart-led-tv-en 372/453/454
7624 hisense-a61n-smart-led-tv-en-2 372/453/454
7625 hisense-a4q-series-fhd-smart-led-tv-en 372/453/454
8264 lg-uhd-ai-ua85-4k-smart-tv-ai-magic-remote-hdr10-webos25-2025-en 166/174/190
8265 lg-qned82-4k-smart-tv-with-ai-technology-and-ai-magic-control-hdr10-and-webos-25-model 166/174/190
8266 lg-qned-evo-ai-qned86-miniled-4k-120hz-smart-tv-ai-magic-remote-webos25-2025-en 166/174/190
8267 lg-qned-evo-ai-qned86-miniled-4k-120hz-smart-tv-ai-magic-remote-webos25-2025 166/174/190
8474 xiaomi-tv-s-mini-2025-en 166/174/190
8475 xiaomi-tv-s-mini-2025-en-2 166/174/190
8478 xiaomi-tv-q2 166/174/190
8483 xiaomi-tv-a-pro-2026-43 166/174/190
8484 xiaomi-tv-a-pro-2026-55 166/174/190
8485 xiaomi-tv-a-pro-2026-65 166/174/190
8486 xiaomi-tv-a-pro-2025-43 166/174/190
8487 xiaomi-tv-a-pro-2025-55 166/174/190
8488 xiaomi-tv-a-pro-2025-65 166/174/190
8489 xiaomi-tv-a-2026-55 166/174/190
8490 xiaomi-tv-a-2026-65 166/174/190
8491 xiaomi-tv-a-2025-43 166/174/190
8492 xiaomi-tv-a-2025-50 166/174/190
8493 xiaomi-tv-a-2025-55 166/174/190
8494 toshiba-television-z670mw-qled-4k-ultra-hd-75 166/174/190
8496 samsung-crystal-uhd-du8100-4k-tizen-os-smart-tv-2024 166/174/190
8497 samsung-oled-s90d-4k-tizen-os-smart-tv-77-2024 166/174/190
8498 samsung-oled-s90d-4k-tizen-os-smart-tv-65-2024 166/174/190
8499 samsung-qled-4k-q60d-tizen-os-smart-tv-85 166/174/190
8501 samsung-qled-4k-q60d-tizen-os-smart-tv-55 166/174/190
8502 samsung-qled-4k-q60d-tizen-os-smart-tv-75 166/174/190
8503 samsung-qled-q70d-series-4k-smart-tv-85-2024 166/174/190
8505 samsung-qled-q70d-series-4k-smart-tv-75-2024 166/174/190
8506 tcl-tv-t6c-smart-tv-4k-qled-colorful-quantum-crystal-hdr-10-dolby-vision-atmos-en 166/174/190
8507 tcl-tv-q6c-premium-qd-mini-led-85 372/453/454
8508 tcl-tv-q6c-premium-qd-mini-led-65 372/453/454
8509 tcl-tv-q6c-premium-qd-mini-led-75 372/453/454
8510 tcl-tv-p7k-uk-qled-43-direct-led-tv-4k-hdr-tv-smart 166/174/190
8511 tcl-tv-p7k-uk-qled-55-direct-led-tv-4k-hdr-tv-smart 166/174/190
8512 tcl-tv-p7k-uk-qled-65-direct-led-tv-4k-hdr-tv-smart 166/174/190
8513 tcl-tv-p7k-uk-qled-75-direct-led-tv-4k-hdr-tv-smart 166/174/190
8711 tcl-tv-65-c8k-premium-qd-mini-led-144hz-en 372/453/454
8712 tcl-tv-c8k-75-premium-qd-mini-led-144hz-en 372/453/454
8713 tcl-tv-4k-uhd-p755-43 166/174/190
8714 tcl-tv-4k-uhd-p755-50 166/174/190
8715 tcl-tv-4k-uhd-p755-55 166/174/190
8716 tcl-television-c755-50-qd-mini-led 166/174/190
8717 tcl-television-c755-55-qd-mini-led 166/174/190
8718 tcl-55-p8k-uk-4k-qled-hdr-smart-tv-4k-ultra-hd-google-tv-with-144hz-motion-clarity-pro-and-onkyo-2-1-sound 166/174/190
8719 tcl-65-p8k-uk-4k-qled-hdr-smart-tv-4k-ultra-hd-google-tv-with-144hz-motion-clarity-pro-and-onkyo-2-1-sound 166/174/190
8720 tcl-75-p8k-uk-4k-qled-hdr-smart-tv-4k-ultra-hd-google-tv-with-144hz-motion-clarity-pro-and-onkyo-2-1-sound 166/174/190
8721 tcl-55-4k-144hz-qled-tv-with-google-tv-and-game-master-pro-3-0 166/174/190
8722 tcl-65-4k-144hz-qled-tv-with-google-tv-and-game-master-pro-3-0 166/174/190
8947 samsung-ls03d-the-frame-qled-4k-art-mode-smart-tv-en 372/453/454
9625 s24-ultra-projector 166/174/486
9642 yaber-projector-y21-native 250/656
10095 xiaomi-smart-projector-l1-pro-eu 166/174/486
10120 samsung-ua43t5300-smart-tv-43 166
10121 samsung-ua50du7000-crystal-uhd-4k-smart-tv-model-50-2024 166
10122 samsung-u8000f-crystal-uhd-4k-smart-tv-55 166
10127 samsung-u8000f-crystal-uhd-4k-smart-tv 166
10128 samsung-u8000f-crystal-uhd-4k-smart-tv-en 166
10133 samsung-u8000f-crystal-uhd-4k-smart-tv-50 166
10134 samsung-du9000-crystal-uhd-4k-tizen-os-smart-tv-98 166
10135 samsung-oled-s85f-4k-smart-tv-55 166
10136 samsung-s85f-oled-4k-smart-tv 166
10137 samsung-s85f-oled-4k-smart-tv-en 166
10138 samsung-s85f-oled-4k-smart-tv-en-2 166
10139 samsung-oled-s90f-4k-samsung-vision-ai-smart-tv-83-new 166
10193 شاومي-ستيك-تي-في-الذكي-٤-كيه-إي-يو 372/453/454
10196 samsung-qa55q7faau-qled-4k-vision-ai-smart-tv-2025-55 166
10198 samsung-qa55q8faau-qled-4k-vision-ai-smart-tv-2025-55 166
10199 samsung-qa55q8faau-qled-4k-vision-ai-smart-tv-2025-55-en 166
10200 samsung-qa55q8faau-qled-4k-vision-ai-smart-tv-2025-55-en-2 166
10201 samsung-qa55q8faau-qled-4k-vision-ai-smart-tv-2025-55-en-3 166
10202 samsung-qa65qn800c-neo-qled-8k-smart-tv-65 166
10216 samsung-qa65qn800du-neo-qled-8k-qn800d-tizen-os-smart-tv-65 166
10217 samsung-qa65qn800du-neo-qled-8k-qn800d-tizen-os-smart-tv-65-en 166
10309 samsung-qa65qn800du-neo-qled-8k-qn800d-tizen-os-smart-tv-85 166
10310 samsung-qa65qn900fu-class-neo-qled-8k-samsung-vision-ai-smart-tv-65 166
10312 neo-qa55qn70fau-qled-4k-samsung-vision-ai-smart-tv-2025 166
10314 samsung-qa55qn85fau-neo-qled-4k-samsung-vision-ai-smart-tv-2025-55 166
10315 neo-qa55qn70fau-qled-4k-samsung-vision-ai-smart-tv-55-2025 166
10316 samsung-qa55qn85dbu-neo-qled-4k-smart-tv-55-en 166
10317 neo-qa55qn70fau-qled-4k-samsung-vision-ai-smart-tv-75-2025 166
10319 samsung-qa65qn85fau-neo-qled-4k-samsung-vision-ai-smart-tv-2025-55 166
10320 samsung-qa75qn85fau-neo-qled-4k-samsung-vision-ai-smart-tv-2025-55 166
10321 samsung-qa85qn70fau-neo-qled-4k-samsung-vision-ai-smart-tv-2025-55 166
10322 samsung-qa85qn85dbe-neo-qled-4k-smart-tv-85 166
10323 samsungqa100qn80fu-neo-qled-4k-smart-tv-100 166