Sandbox

SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (65442, 65444, 65445, 65446) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00057

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65442,65444,65445,65446) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
65442	Classic lighting with integrated LED components! The Wilcox cuts energy demands and revamps any space’s style. Handcrafted and American made!	The Wilcox Nautical LED Flush Mount Light, The Wilcox Nautical LED Flush Mount, The Wilcox Nautical LED Flush Mount Pendant, Wilcox Nautical LED Flush Mount Light, Wilcox Nautical LED Flush Mount, Wilcox Nautical LED Flush Mount Pendant, Wilcox Nautical flush mount, Wilcox nautical flush mount pendant, Wilcox nautical, nautical Wilcox, Wilcox nautical flush, nautical Wilcox flush, Wilcox nautical flush pendant, Wilcox, Wilcox flush, wilcox flush mount, wilcox flush mount light, wilcox flush mount pendant, wilcox flush mount pendant light, wilcox flush mount ceiling pendant, wilcox flush mount ceiling pendants, wilcox flush ceiling light, wilcox flush ceiling pendant, wilcox flush ceiling pendants, wilcox flush mount ceiling light, wilcox flush mount ceiling lighting, wilcox flush mount ceiling lights, The Wilcox, the Wilcox flush, the wilcox flush mount, the wilcox flush mount light, the wilcox flush mount pendant, the wilcox flush mount pendant light, the wilcox flush mount ceiling pendant, the wilcox flush mount ceiling pendants, the wilcox flush ceiling light, the wilcox flush ceiling pendant, the wilcox flush ceiling pendants, the wilcox flush mount ceiling light, the wilcox flush mount ceiling lighting, the wilcox flush mount ceiling lights, deep bowl flush mount, deep bowl flush mounts, flush mount pendant, flush mount light, flush mount ceiling pendant, flush mount, flush mount light, Wilcox LED, LED wilcox, led wilcox flush, wilcox led flush, led wilcox flush mount, wilcox led flush mount, wilcox led flush mount pendant, led wilcox flush mount pendant, wilcox led flush mount ceiling pendant, led wilcox flush mount ceiling pendant, wilcox led flush ceiling pendant, led wilcox flush ceiling pendant, wilcox led flush mount ceiling light, led wilcox flush mount ceiling light, LED flush mount, flush mount LED, LED flush mount pendant, Flush Mount LED Pendant, LED flush mount ceiling pendant, flush mount LED ceiling pendant, LED flush light, flush led light, BLE-F-DBW-CGG-LED, H-16008, H-16110, H-16112, H-16114, H-16116, H-16118, H-17124, classic deep bowl shade,
65444	A flush mounted LED pendant with a classic style! The Avalon is environmentally friendly and budget conscious! American made and customizable.	The Avalon Nautical LED Flush Mount Light, The Avalon Nautical LED Flush Mount, The Avalon Nautical LED Flush Mount Pendant, Avalon Nautical LED Flush Mount Light, Avalon Nautical LED Flush Mount, Avalon Nautical LED Flush Mount Pendant, Avalon Nautical flush mount, Avalon nautical flush mount pendant, Avalon nautical, nautical Avalon, Avalon nautical flush, nautical Avalon flush, Avalon nautical flush pendant, Avalon flush mount, Avalon Flush Mounts, avalon flush mount pendant, avalon flush, avalon flush light, avalon flush mount light, avalon flush pendant, flush mount avalon, flush mount avalon pendant, flush mount avalon light, flush avalon light, flush avalon, avalon flush, avalon flush light, Avalon, flush mount, flush light, flush mount light, Avalon flush pendant, flush pendant avalon, avalon flush pendant light, flush mount lighting, flush lighting, flush mount pendant light, flush mount pendant lighting, Avalon flush mount pendant lighting, avalon flush mount pendant light, avalon flush mount pendants, LED flush, Flush LED, LED flush mount, Flush mount led, Avalon LED, LED avalon, Avalon LED flush, LED Avalon Flush, Avalon LED flush mount, LED avalon flush mount, Avalon LED Flush Mount Pendant, LED Avalon Flush Mount Pendant, LED Avalon Flush Mount Pendants, Avalon LED Flush Mount Pendants, LED Avalon Flush Ceiling Pendant, Avalon LED Flush Ceiling Pendants, LED Avalon Flush Mount Ceiling Pendant, Avalon LED Flush Mount Ceiling Pendant, LED Avalon Flush Mount Ceiling Pendants, Avalon LED Flush Mount Ceiling Pendants, BLE-F-WHA-CGG-LED,
65445	Energy efficient, environmentally friendly, and uniquely stylish: this flush mount pendant embraces classic designs and integrated LED tech! American made!	The Dino Nautical LED Flush Mount Light, The Dino Nautical LED Flush Mount, The Dino Nautical LED Flush Mount Pendant, Dino Nautical LED Flush Mount Light, Dino Nautical LED Flush Mount, Dino Nautical LED Flush Mount Pendant, Dino Nautical flush mount, Dino nautical flush mount pendant, Dino nautical, nautical Dino, Dino nautical flush, nautical Dino flush, Dino nautical flush pendant, LED dino, Dino LED, LED dino flush, Dino LED flush, LED dino flush mount, Dino LED flush mount, LED dino flush mount pendant, Dino LED flush mount pendant, LED dino flush mount ceiling pendant, Dino LED flush mount ceiling pendant, LED dino flush mount ceiling light, Dino LED flush mount ceiling light, LED dino flush ceiling mount, Dino LED flush ceiling mount, LED dino flush ceiling mounts, Dino LED flush ceiling mounts, Dino LED flush light, led dino flush light, dino led flush lighting, led dino flush lighting, LED dino pendant, dino led pendant, led dino pendants, dino led pendants, dino led flush pendant, led dino flush pendant, dino led flush ceiling pendant, led dino flush ceiling pendant, dino led flush ceiling pendant, Led flush mount, led flush mounts, flush mount led, led flush mount pendant, flush mount led pendant, led flush mount pendants, flush mount led pendants, led flush mount pendant light, flush mount led pendant light, LED flush ceiling pendant, flush led ceiling pendant, dino flush mount, dino flush mounts, dino flush mount pendant, dino flush mount pendants, dino flush mount pendant light, dino flush mount pendant lights, dino flush mount pendant lighting, dino flush mount, dino flush mounts, dino flush mount pendant, dino flush mount pendants, dino flush pendant, dino flush pendants, dino flush mount light, dino flush pendant, flush mount dino, flush dino, Dino flush, dino flush pendant, dino flush pendant light, dino flush mount pendants, flush mount, flush mount light, flush mount pendant light, flush mount pendant lighting,
65446	An energy efficient, eco-friendly LED flush mount light! The Union offers an eye-catching style and integrated LED components! Handcrafted and American made!	LED union, Union LED, LED union flush, Union LED flush, LED union flush mount, Union LED flush mount, LED union flush mount pendant, Union LED flush mount pendant, LED union flush mount ceiling pendant, Union LED flush mount ceiling pendant, LED union flush mount ceiling light, Union LED flush mount ceiling light, LED union flush ceiling mount, Union LED flush ceiling mount, LED union flush ceiling mounts, Union LED flush ceiling mounts, Union LED flush light, led union flush light, union led flush lighting, led union flush lighting, LED union pendant, union led pendant, led union pendants, union led pendants, union led flush pendant, led union flush pendant, union led flush ceiling pendant, led union flush ceiling pendant, union led flush ceiling pendant, Led flush mount, led flush mounts, flush mount led, led flush mount pendant, flush mount led pendant, led flush mount pendants, flush mount led pendants, led flush mount pendant light, flush mount led pendant light, LED flush ceiling pendant, flush led ceiling pendant, union flush mount, union flush mounts, union flush mount pendant, union flush mount pendants, union flush mount pendant light, union flush mount pendant lights, union flush mount pendant lighting, union flush mount, union flush mounts, union flush mount pendant, union flush mount pendants, union flush pendant, union flush pendants, union flush mount light, union flush pendant, flush mount union, flush union, Union flush, union flush pendant, union flush pendant light, union flush mount pendants, flush mount, flush mount light, flush mount pendant light, flush mount pendant lighting, he Union Nautical LED Flush Mount Light, The Union Nautical LED Flush Mount, The Union Nautical LED Flush Mount Pendant, Union Nautical LED Flush Mount Light, Union Nautical LED Flush Mount, Union Nautical LED Flush Mount Pendant, Union Nautical flush mount, Union nautical flush mount pendant, Union nautical, nautical Union, Union nautical flush, nautical Union flush, Union nautical flush pendant, BLE-F-WHU-CGG-LED,