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, 65302, 65424, 65453) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00063

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,65302,65424,65453) 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,
65302	Timeless flush mount lighting design with unequaled craftsmanship! The Dino is manufactured in our Florida-based facility and is fully customizable!	BLE-F-WHD, 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,
65424	With its simple yet eye-catching lines, the Bomber establishes elevated, stylish décors. Bring handcrafted, fully customizable lighting to any home or business with this flush mount light!	BLE-F-WHB, Bomber flush, bomber flush mount, bomber flush mount pendant, bomber flush mount pendant light, bomber flush mount pendant lighting, bomber flush mount ceiling pendant, bomber flush mount ceiling pendants, bomber flush mount ceiling light, bomber flush mount ceiling lighting, bomber flush light, bomber flush lighting, bomber flush pendant, bomber flush pendant light, bomber flush pendants, bomber flush ceiling pendants, bomber flush ceiling light, bomber flush ceiling lights, bomber ceiling flush pendant, The Bomber flush, the bomber flush mount, the bomber flush mount pendant, the bomber flush mount pendant light, the bomber flush mount pendant lighting, the bomber flush mount ceiling pendant, the bomber flush mount ceiling pendants, the bomber flush mount ceiling light, the bomber flush mount ceiling lighting, the bomber flush light, the bomber flush lighting, the bomber flush pendant, the bomber flush pendant light, the bomber flush pendants, the bomber flush ceiling pendants, the bomber flush ceiling light, the bomber flush ceiling lights, the bomber ceiling flush pendant, flush mount pendant, flush mount light, flush mount ceiling pendant, flush mount, flush mount light, bomber, bomber flush mount, bomber flush mounts,
65453	Modern yet timeless, this flush mount light stands out in residential and commercial settings! Customize its appearance and elevate your decor!	Tuscany Flush Mount Light, Tuscany Flush Mount, Tuscany Flush Mount Pendant, Tuscany Pendant, Tuscany Pendant Light, Tuscany ceiling light, Tuscany flush mount ceiling pendant, Tuscany flush, Flush Tuscany, The Tuscany Flush Mount Light, The Tuscany Flush Mount, The Tuscany Flush Mount Pendant, The Tuscany Pendant, The Tuscany Pendant Light, The Tuscany ceiling light, The Tuscany flush mount ceiling pendant, The Tuscany flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant,