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 (65448, 65450, 65451, 65452) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00058

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 (65448,65450,65451,65452) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
65448	Classic lighting styles with integrated LEDs! Energy efficient and environmentally friendly, save money and elevate your space with flush mount led pendants!	The Dominion Nautical LED Flush Mount Light, The Dominion Nautical LED Flush Mount, The Dominion Nautical LED Flush Mount Pendant, Dominion Nautical LED Flush Mount Light, Dominion Nautical LED Flush Mount, Dominion Nautical LED Flush Mount Pendant, Dominion Nautical flush mount, Dominion nautical flush mount pendant, Dominion nautical, nautical Dominion, Dominion nautical flush, nautical Dominion flush, Dominion nautical flush pendant, LED dominion, Dominion LED, LED dominion flush, Dominion LED flush, LED dominion flush mount, Dominion LED flush mount, LED dominion flush mount pendant, Dominion LED flush mount pendant, LED dominion flush mount ceiling pendant, Dominion LED flush mount ceiling pendant, LED dominion flush mount ceiling light, Dominion LED flush mount ceiling light, LED dominion flush ceiling mount, Dominion LED flush ceiling mount, LED dominion flush ceiling mounts, Dominion LED flush ceiling mounts, Dominion LED flush light, led dominion flush light, dominion led flush lighting, led dominion flush lighting, LED dominion pendant, dominion led pendant, led dominion pendants, dominion led pendants, dominion led flush pendant, led dominion flush pendant, dominion led flush ceiling pendant, led dominion flush ceiling pendant, dominion 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, 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,
65450
65451	Energy efficient and incredibly stylish, this LED flush mount light is perfect for every décor! Endlessly customizable and American made!	The Marathon Nautical LED Flush Mount Light, The Marathon Nautical LED Flush Mount, The Marathon Nautical LED Flush Mount Pendant, Marathon Nautical LED Flush Mount Light, Marathon Nautical LED Flush Mount, Marathon Nautical LED Flush Mount Pendant, Marathon Nautical flush mount, Marathon nautical flush mount pendant, Marathon nautical, nautical Marathon, Marathon nautical flush, nautical Marathon flush, Marathon nautical flush pendant, BLE-F-YDM-CGG-LED, LED marathon, Marathon LED, LED marathon flush, Marathon LED flush, LED marathon flush mount, Marathon LED flush mount, LED marathon flush mount pendant, Marathon LED flush mount pendant, LED marathon flush mount ceiling pendant, Marathon LED flush mount ceiling pendant, LED marathon flush mount ceiling light, Marathon LED flush mount ceiling light, LED marathon flush ceiling mount, Marathon LED flush ceiling mount, LED marathon flush ceiling mounts, Marathon LED flush ceiling mounts, Marathon LED flush light, led marathon flush light, marathon led flush lighting, led marathon flush lighting, LED marathon pendant, marathon led pendant, led marathon pendants, marathon led pendants, marathon led flush pendant, led marathon flush pendant, marathon led flush ceiling pendant, led marathon flush ceiling pendant, marathon 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, marathon flush mount, marathon flush mounts, marathon flush mount pendant, marathon flush mount pendants, marathon flush mount pendant light, marathon flush mount pendant lights, marathon flush mount pendant lighting, marathon flush mount, marathon flush mounts, marathon flush mount pendant, marathon flush mount pendants, marathon flush pendant, marathon flush pendants, marathon flush mount light, marathon flush pendant, flush mount marathon, flush marathon, Marathon flush, marathon flush pendant, marathon flush pendant light, marathon flush mount pendants, flush mount, flush mount light, flush mount pendant light, flush mount pendant lighting, BLE-F-YDM-LED,
65452	Timeless flush mount lighting with cutting-edge LED technology! The Aero gives any space a unique sense of style and scales back energy consumption!	BLE-F-SBA-CGG-LED, The Aero Nautical LED Flush Mount Light, The Aero Nautical LED Flush Mount, The Aero Nautical LED Flush Mount Pendant, Aero Nautical LED Flush Mount Light, Aero Nautical LED Flush Mount, Aero Nautical LED Flush Mount Pendant, Aero Nautical flush mount, Aero nautical flush mount pendant, Aero nautical, nautical Aero, Aero nautical flush, nautical Aero flush, Aero nautical flush pendant, BLE-F-SBA-LED, Aero LED, LED aero, Aero LED flush, LED aero flush, aero led flush mount, led aero flush mount, Aero LED flush mount light, led aero flush mount light, LED aero flush mount ceiling pendant, aero led flush mount ceiling pendant, LED aero flush mount ceiling light, aero led flush mount ceiling light, Aero LED flush light, LED aero flush light, Aero LED flush pendant, LED Aero flush pendant, Aero LED Flush Pendants, LED Aero Flush Pendants, LED flush mount, LED flush mounts, Flush Mount LED, led flush, flush led, led flush pendant, flush led pendant, Aero flush mount, aero flush mounts, aero flush mount pendant, aero flush mount pendants, aero flush mount pendant light, aero flush mount pendant lights, aero flush mount pendant lighting, areo, aero flush mount, aero flush mounts, aero flush mount pendant, aero flush mount pendants, aero flush pendant, aero flush pendants, aero flush mount light, aero flush pendant, flush mount aero, flush aero, Aero flush, aero flush pendant, aero flush pendant light, aero flush mount pendants, flush mount, flush mount light, flush mount pendant light, flush mount pendant lighting,