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 (65299, 65300, 65301, 65425) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

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 (65299,65300,65301,65425) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
65299 The Aero Flush Mount Light brings a timeless style to undersized spaces and areas with lower ceilings. Handcrafted from high-quality metals and fully customizable! 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, BLE-F-SBA,
65300 Handcrafted flush mount lighting with a timeless design! The Conoco embraces classic styles and a fully customizable appearance, making it perfect for every home or business! BLE-F-FCC, Conoco flush mount, conoco flush mounts, conoco flush mount pendant, conoco flush mount pendants, conoco flush mount pendant light, conoco flush mount pendant lights, conoco flush mount pendant lighting, conoco flush mount, conoco flush mounts, conoco flush mount pendant, conoco flush mount pendants, conoco flush pendant, conoco flush pendants, conoco flush mount light, conoco flush pendant, flush mount conoco, flush conoco, Conoco flush, conoco flush pendant, conoco flush pendant light, conoco flush mount pendants, flush mount, flush mount light, flush mount pendant light, flush mount pendant lighting,
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,
65425 The Marathon Flush Mount adds character and style to a wide variety of spaces. American made and customizable with colorful finishes and functional accessories! BLE-F-YDM, Marathon flush mount, marathon flush mount pendant, marathon flush mount pendant light, marathon flush mount ceiling pendant, marathon flush mount ceiling light, marathon flush pendant, marathon flush, marathon flush light, marathon flush pendant light, marathon flush ceiling pendant, marathon flush ceiling light, marathon flush ceiling pendant light, The Marathon flush mount, the marathon flush mount pendant, the marathon flush mount pendant light, the marathon flush mount ceiling pendant, the marathon flush mount ceiling light, the marathon flush pendant, the marathon flush, the marathon flush light, the marathon flush pendant light, the marathon flush ceiling pendant, the marathon flush ceiling light, the marathon flush ceiling pendant light, flush mount pendant, flush mount light, flush mount ceiling pendant, flush mount, flush mount light, marathon,