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 (65298, 65301, 65426, 65447) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00038

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 (65298,65301,65426,65447) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
65298	Big style for small spaces, the Avalon Flush Mount Light is customizable and American made! Choose color and customizing options and elevate your décor today!	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, BLE-F-WHA,
65301	Timeless lighting styles for smaller spaces, this flush mount pendant stands out in any décor! American made and fully customizable!	BLE-F-SBD, Dominion flush mount, dominion flush mounts, dominion flush mount pendant, dominion flush mount pendants, dominion flush mount pendant light, dominion flush mount pendant lights, dominion flush mount pendant lighting, dominion flush mount, dominion flush mounts, dominion flush mount pendant, dominion flush mount pendants, dominion flush pendant, dominion flush pendants, dominion flush mount light, dominion flush pendant, flush mount dominion, flush dominion, Dominion flush, dominion flush pendant, dominion flush pendant light, dominion flush mount pendants, flush mount, flush mount light, flush mount pendant light, flush mount pendant lighting, H-15512, H-15514, H-15516, shallow dome warehouse shade, shallow dome warehouse flush mount,
65426	A timeless lighting design, the Esso offers a hint of character to indoor and exterior spaces. Handcrafted, fully customizable, and incredibly stylish!	BLE-F-WHE, Esso Flush Mount, Esso Flush Mounts, Esso Flush Mount Pendant, Esso Flush Mount Pendant Light, Esso Flush Mount Ceiling Pendant, Esso Flush Mount Ceiling Pendants, Esso Flush Pendant, Esso Flush Pendant Light, Esso Flush Pendant Lights, Esso flush ceiling light, esso flush mount ceiling light, flush mount pendant, flush mount light, flush mount ceiling pendant, The Esso Flush Mount, The Esso Flush Mounts, The Esso Flush Mount Pendant, The Esso Flush Mount Pendant Light, The Esso Flush Mount Ceiling Pendant, The Esso Flush Mount Ceiling Pendants, The Esso Flush Pendant, The Esso Flush Pendant Light, The Esso Flush Pendant Lights, the Esso flush ceiling light, the esso flush mount ceiling light, flush, flush mount, flush mount light, esso,
65447	Classic lighting updated with modern LED tech! The Bomber features fully integrated LED components—environmentally and budget friendly!	The Bomber Nautical LED Flush Mount Light, The Bomber Nautical LED Flush Mount, The Bomber Nautical LED Flush Mount Pendant, Bomber Nautical LED Flush Mount Light, Bomber Nautical LED Flush Mount, Bomber Nautical LED Flush Mount Pendant, Bomber Nautical flush mount, Bomber nautical flush mount pendant, Bomber nautical, nautical Bomber, Bomber nautical flush, nautical Bomber flush, Bomber nautical flush pendant, LED bomber, Bomber LED, LED bomber flush, Bomber LED flush, LED bomber flush mount, Bomber LED flush mount, LED bomber flush mount pendant, Bomber LED flush mount pendant, LED bomber flush mount ceiling pendant, Bomber LED flush mount ceiling pendant, LED bomber flush mount ceiling light, Bomber LED flush mount ceiling light, LED bomber flush ceiling mount, Bomber LED flush ceiling mount, LED bomber flush ceiling mounts, Bomber LED flush ceiling mounts, Bomber LED flush light, led bomber flush light, bomber led flush lighting, led bomber flush lighting, LED bomber pendant, bomber led pendant, led bomber pendants, bomber led pendants, bomber led flush pendant, led bomber flush pendant, bomber led flush ceiling pendant, led bomber flush ceiling pendant, bomber 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, bomber flush mount, bomber flush mounts, bomber flush mount pendant, bomber flush mount pendants, bomber flush mount pendant light, bomber flush mount pendant lights, bomber flush mount pendant lighting, bomber flush mount, bomber flush mounts, bomber flush mount pendant, bomber flush mount pendants, bomber flush pendant, bomber flush pendants, bomber flush mount light, bomber flush pendant, flush mount bomber, flush bomber, Bomber flush, bomber flush pendant, bomber flush pendant light, bomber flush mount pendants, flush mount, flush mount light, flush mount pendant light, flush mount pendant lighting, BLE-F-WHB-CGG-LED, H-15111, H-15113, H-15115, H-15117, curved warehouse shade,